Ϊϵͳҳе˺ܶҳͿؼϸĴο̡йaspxؼϢ뿴ǰ½ں΢˾վwww.microsofot.com/msnҪñϵͳֻͨʣ;
1ʹwindows ceϵͳֱֻʹʡ
2ʹ÷windows ceϵͳֻҪǰ½ڣ޸Ĵ룬ԱWAP׼Ҳڷwindows ceֻϷʡ
 
<%@ Register TagPrefix="CC" TagName="Footer" Src="Footer.ascx" %>
<%@ Register TagPrefix="CC" TagName="Header" Src="Header.ascx" %>
<%@ Page language="c#" Codebehind="Default.cs" AutoEventWireup="false" Inherits="Book_Store.Default" codePage="936"%>
<HTML> 
<HEAD>
    <title>topl if e</title>
<meta name="vs_targetSchema" content="http://schemas.microsoft
.com/intellisense/ie3-2nav3-0">
<meta name="GENERATOR" content="YesSoftware CodeCharge v.2.0.5 using 'ASP.NET C#.ccp' build 9/27/2001">
    <meta name="CODE_LANGUAGE" Content="C#">
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="cache-control" content="no-cache"> 
    <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD> 
<body style="COLOR: #000000; FONT-FAMILY: Arial, Tahoma, Verdana, Helvetica; BACKGROUND-COLOR: #ffffff"> 
    <form method="post" runat="server">
    <CC:Header id="Header" runat="server" />
    <table> 
        <tr>
          <td valign="top">
                <table id="Search_holder" runat="Server" style=
"WIDTH:100%">
                   <tr>
                        <td colspan="5"><a name="Search"><font style="FONT
-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="SearchForm_Title" runat="server"></asp:label></font></a></td>
                   </tr> 
                   <tr>
                        <td><font style="FONT-SIZE: 9pt; COLOR: #000000"></font></td>
                        <td> 
                            <asp:DropDownList style="FONT-SIZE: 9pt; COLOR: #000000" id="Search_category_id" DataTextField="name" 

DataValueField="category_id" runat="server"/>
                        </td>
                    </tr>
                    <tr>
                         <td><font style="FONT-SIZE: 9pt; COLOR: #000000"></font></td> 
                         <td>
                              <asp:TextBox id="Search_name" Columns="10" runat="server"/>
                         </td>
                    </tr>
                    <tr>
                        <td align="right" colspan="3">
                              <asp:Button id="Search_search_button" Text="" runat="server"/>
                        </td>
                    </tr>
                </table>
                <table id="AdvMenu_holder" runat="Server" style=
"WIDTH:100%"> 
                    <tr>
                        <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="AdvMenuForm_Title" runat=
"server"> </asp:label></font></td> 
                    </tr>
                    <tr>
                        <td>
                            <asp:HyperLink NavigateUrl="AdvSearch.aspx" id="AdvMenu_Field1" style="FONT-SIZE: 9pt; COLOR: #000000" 
                                runat="server">߼</asp:HyperLink>
</td> 
                    </tr>
                </table>
                <br>
                <table id="Categories_holder" runat="Server" style=
"WIDTH:100%"> 


                   <TBODY>
<tr>
                        <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="CategoriesForm_Title" runat=
"server"></asp:label></font></td>
                      </tr> 
<tr>
                           <td>
                               <asp:Label id="Categories_Column_name" Text
="" style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ce7e00" 
                                                runat="server" /></td>
                     </tr><tr id="Categories_no_records" runat="server"> 
                           <td colspan="1"><font style="FONT-SIZE:9pt; COLOR: #000000">No records</font></td>
                     </tr>
<tr>
                     <td><asp:Repeater id="Categories_Repeater" runat=
"server">
                              <HeaderTemplate>
                     </td>
                 </tr>
</HeaderTemplate>
<ItemTemplate> 
                         <tr>
                            <td style="background-color: #FFFFFF; border
-width: 1"> 
                                <asp:HyperLink id=Categories_name Navigate
Url='<%# "Books.aspx"+"?"+"category_id="+Server.UrlEncode(DataBinder.Eval
(Container. DataItem, c_category_id").ToString()) +"&" +""%>' style="font
-size: 9pt; color: #000000" runat="server"> '<%#Server.HtmlEncode (Data
Binder.Eval(Container.DataItem, "c_name").ToString()) %>' </asp:HyperLink>
&nbsp; 
                            </td>
                         </tr>
                     </ItemTemplate>

<FooterTemplate>
                         <tr>
                             <td>
                     </FooterTemplate>
                  /asp:Repeater></td>
            </tr> 
        </table>
        <br>
        <table id="Specials_holder" runat="Server" style="WIDTH:100%"> 
            <tr>
                <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="SpecialsForm_Title" runat="server">TOP 10</asp:label></font></td>
           </tr> 
            <tr id="Specials_no_records" runat="server">
                <td colspan="2"><font style="FONT-SIZE: 9pt; COLOR: #000000">No records</font></td> 
            </tr> 
           <tr>
               <td><asp:Repeater id="Specials_Repeater" runat="server">

                          <HeaderTemplate>
                </td>
            </tr> 
            </HeaderTemplate>
            <ItemTemplate> 
                <tr>
                    <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_title_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                        runat="server"/></td>
      </tr>
      <tr>
           <td style="background-color: #FFFFFF; border-width: 1">
               <asp:Label id="Specials_article_title" style="font-size: 9pt; color: #000000" runat="server">                          <%# DataBinder.Eval(Container.DataItem, "e_article_
title") %>
               </asp:Label>&nbsp; 
           </td>
        </tr>
        <tr>
            <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_desc_Column_Title" style="font
-size: 9pt; color: #CE7E00; font-weight: bold" 
                         runat="server" /></td>
            </tr>
            <tr>
                <td style="background-color: #FFFFFF; border-width: 1">
                    <asp:Label id="Specials_article_desc" style=
"font-size:9pt; color:#000000" runat="server">
                <%# DataBinder.Eval(Container.DataItem, "e_article_desc") %>
                     </asp:Label>&nbsp;
                </td>
            </tr>
        </ItemTemplate> 
        <SeparatorTemplate> 
            <tr>
                <td colspan="2" style="background-color: #FFFFFF; border-
width: 1">&nbsp;</td>
            </tr>
        </SeparatorTemplate>
        <FooterTemplate>
             <tr>
                  <td>
        </FooterTemplate>
        </asp:Repeater></TD></TR>
    </table>
    </TD><td valign="top"><table width="250">
            <tr>
                    <td><FONT face=""></FONT></td>
            </tr>
        </table>
        <table id="Recommended_holder" runat="Server" style="WIDTH:
100%"> 
              <TBODY>
<tr>

                      <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="RecommendedForm_Title" runat="server">ʱоƷ</asp:label></font></td> 
                            </tr> 
<tr id="Recommended_no_records" runat="server">
                                <td colspan="4"><font style="FONT-SIZE: 9pt; COLOR: #000000">No records</font></td> 
                            </tr>
<tr>
                                <td><asp:Repeater id="Recommended_
Repeater" onitemdatabound="Recommended_Repeater_ItemDataBound" runat
="server"> 
                                           <HeaderTemplate> 
                                </td> 
                           </tr> 
</HeaderTemplate>
<ItemTemplate> 
                          <tr>
                              <td><table width="100%" style="width:100%"> 
                                       <tr>
                                           <td 
                                               style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="name_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" runat="server" />
                                           </td>
                                       </tr>
                                       <tr>
                                           <td style="background-color: #FF
FFFF; border-width: 1">
                                               <asp:HyperLink id=Recommended_name NavigateUrl='<%# "BookDetail.aspx"+"?"+"item_id="+Server.
UrlEncode(DataBinder.Eval(Container .DataItem, "i_item_id").ToString()) +"&" +""%>' style="font-size: 9pt; color: #000000" runat="server"> '<%#DataBinder.
Eval(Container.DataItem, "i_name") %>' </asp:HyperLink>&nbsp;
                                           </td>
                                       </tr>
                                       <tr>
                                            <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="author_
Column_Title" style="font-size: 9pt; color:#CE7E00; font-weight: bold"

runat="server" /></td>
                                       </tr>
                                       <tr>
                                            <td style="background-color: 
#FFFFFF; border-width: 1"> 
                                                <asp:Label id="Recommended_author" style="font-size: 9pt; color: #000000" runat="server"> '<%# Server.HtmlEncode(DataBinder.Eval (Container.DataItem, "i_author").
ToString()) %>' </asp:Label>&nbsp;
                                            </td>
                                        </tr>
                                        <tr>
                                            <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="۸" id="price_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
runat="server"/></td>
                                        </tr>
                                        <tr>
                                            <td style="background-color: #FFFFFF; border-width: 1">
                                                <input type=hidden id=
Recommended_image_url runat="server" value='<%# DataBinder.Eval(Container.
DataItem, "i_image_url") %>'> 
                                                <asp:Label id="Recommended
_price" style="font-size: 9pt; color: #000000" runat="server"> '<%# Server.
HtmlEncode(DataBinder.Eval(Container.DataItem, "i_price").ToString()) %>' </asp:Label>&nbsp;
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                            </tr>
                        </table>
                    </td>
                    </tr></ItemTemplate> 
                    <SeparatorTemplate>
                        <tr>
                            <td colspan="2" style="background-color: #FFFFFF; border-width: 1">&nbsp;</td>
                        </tr>
                    </SeparatorTemplate>
                    <FooterTemplate>
                        <tr>
                        <td>
                    </FooterTemplate>
                    </asp:Repeater></TD></TR>
                    <tr>
                        <td colspan="1"> 
                            <font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ce7e00"> 
                                <CC:Pager id="Recommended_Pager" style=
"FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ce7e00" 
                                   ShowFirst="False" showLast="False" showprev="True" shownext="True" ShowFirstCaption=""
                                   showLastCaption="" showtotal="False" showtotalstring="of" shownextCaption="Next" showprevCaption="Previous" 
                                   PagerStyle="1" NumberOfPages="10" runat=
"server"/>
                            </font>
                        </td> 
                    </tr> 
                    </TBODY></TABLE></TD><td valign="top">
                        <table id="What_holder" runat="Server" style=
"WIDTH:100%"> 
                            <TBODY>
<tr>

                                <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="WhatForm_Title" runat=
"server">Ʒչ̨ </asp:label></font></td> 
                            </tr>
<tr id="What_no_records" runat="server"> 
                                <td colspan="3"><font style="FONT-SIZE: 9pt; COLOR: #000000">No records</font></td>
                           </tr>
<tr>
                                <td><asp:Repeater id="What_Repeater" onitemdatabound="What_Repeater_ItemDataBound" runat="server">
                                           <HeaderTemplate>
                                </td> 
                           </tr> 
</HeaderTemplate> 
<ItemTemplate>
                           <tr>
                                <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_title
_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                                    runat="server"/></td>
                           </tr>
                           <tr>
                               <td style="background-color: #FFFFFF; border
-width: 1">
                                   <asp:HyperLink id=What_article_title NavigateUrl='<%# "BookDetail.aspx"+"?"+"item_id="+Server.UrlEncode(DataBinder.Eval(Container .DataItem, "e_item_id").ToString()) +"&" +""%>' style="font-size: 9pt; color: #000000" runat="server"> '<%#DataBinder.Eval(Container.DataItem, "e_article
_title") %>' </asp:HyperLink>&nbsp;
                              </td>
                          </tr>
                          <tr>
                               <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_desc_
Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                                   runat="server" /></td>
                          </tr>
                          <tr>
                              <td style="background-color: #FFFFFF; border-
width: 1">



                                  <input type=hidden id=What_item_id runat
="server" value='<%# DataBinder.Eval(Container.DataItem, "e_item_id") %>'> 
                                  <asp:Label id="What_article_desc" style=
"font-size: 9pt; color: #000000" runat="server"> '<%# DataBinder.Eval
(Container.DataItem, "e_article_desc") %>' </asp:Label>&nbsp; 
                                  </td>
                             </tr>
                         </ItemTemplate>
<SeparatorTemplate>
                             <tr>
                                 <td colspan="2" style="background-color: #FFFFFF; border-width: 1">&nbsp;</td>
                             </tr>
                         </SeparatorTemplate>
<FooterTemplate>
                             <tr>
                                 <td>
                              </FooterTemplate>
                  </asp:Repeater></td>
              </TR></TBODY></TABLE>
              <table id="New_holder" runat="Server" style="WIDTH:100%">
                  <tr>
                      <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="NewForm_Title" runat="server">׻</asp:label></font></td> 
                  </tr>
                  <tr id="New_no_records" runat="server">
                        <td colspan="3"><font style="FONT-SIZE: 9pt; COLOR: #000000">No records</font></td>
                  </tr>
                  <tr>
                      <td><asp:Repeater id="New_Repeater" onitemdata
bound="New_Repeater_ItemDataBound" runat="server">
                      <HeaderTemplate>
                      </td>
                </tr> 
                </HeaderTemplate>
                <ItemTemplate>
                    <tr>
                        <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_title_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                                   runat="server" /></td>
                    </tr>
                    <tr>


                        <td style="background-color: #FFFFFF; border-width: 1">
                            <asp:HyperLink id=New_article_title Navigate
Url='<%# "BookDetail.aspx"+"?"+"item_id="+Server.UrlEncode(DataBinder.Eval
(Container .DataItem, "e_item_id").ToString()) +"&" +""%>' style="font-size: 9pt; color: #000000" runat="server"> '<%#DataBinder.Eval(Container.DataItem, "e_article_title") %>' </asp:HyperLink>&nbsp; 
                        </td>
                    </tr>
                    <tr>
                        <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_desc_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                                     runat="server" /></td>
                   </tr>
                   <tr>
                        <td style="background-color: #FFFFFF; border-width: 1">
                            <input type=hidden id=New_item_id runat=
"server" value='<%# DataBinder.Eval(Container.DataItem, "e_item_id") %>'>
                            <asp:Label id="New_article_desc" style=
"font-size: 9pt; color: #000000" runat="server"> '<%# DataBinder.Eval
(Container.DataItem, "e_article_desc") %>' </asp:Label>&nbsp; 
                       </td>
                   </tr>
                   </ItemTemplate>
                   <SeparatorTemplate> 
                       <tr>
                           <td colspan="2" style="background-color: #FFFFFF; border-width: 1">&nbsp;</td>
                       </tr>
                   </SeparatorTemplate>
                   <FooterTemplate>
                      <tr>
                          <td>
                   </FooterTemplate>
                   </asp:Repeater></TD></TR>
               </table>
               <table id="Weekly_holder" runat="Server" style=
"WIDTH:100%"> 
                    <tr>
                        <td colspan="1"><font style="FONT-WEIGHT: bold; FONT-SIZE: 9pt; COLOR: #ffffff"><asp:label id="WeeklyForm_Title" runat="server"
>Ƶ</asp:label></font></td> 
                    </tr>
                    <tr id="Weekly_no_records" runat="server">
                        <td colspan="3"><font style="FONT-SIZE: 9pt; COLOR: #000000">No records</font></td> 
                    </tr>
                    <tr>
                        <td><asp:Repeater id="Weekly_Repeater" onitemdata
bound="Weekly_Repeater_ItemDataBound" runat="server">
                             <HeaderTemplate>
                    </td>
                </tr>
                </HeaderTemplate>
                <ItemTemplate> 
                    <tr>
                        <td><table width="100%" style="width:100%">
                    <tr>
                        <td style="background-color: #FFFFFF; border-style: inset; border-width: 0"><asp:Label Text="" id="article_title_Column_Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                                    runat="server" /></td>
                    </tr>
                    <tr>
                        <td style="background-color: #FFFFFF; border-width: 1">
                            <asp:HyperLink id=Weekly_article_title NavigateUrl='<%# "BookDetail.aspx"+"?"+"item_id="+Server.UrlEncode(Data
Binder.Eval(Container .DataItem, "e_item_id").ToString()) +"&" +""%>' style="font-size: 9pt; color: #000000" runat="server"> '<%#DataBinder.Eval
(Container.DataItem, "e_article_title") %>' </asp:HyperLink>&nbsp; 
                        </td>
                    </tr>
                    <tr>
                            <td style="background-color: #FFFFFF; border
-style: inset; border-width: 0"><asp:Label Text="" id="article_desc_Column_
Title" style="font-size: 9pt; color: #CE7E00; font-weight: bold" 
                                        runat="server" /></td>
                    </tr>
                    <tr>
                        <td style="background-color: #FFFFFF; border-width: 1">
                            <input type=hidden id=Weekly_item_id runat=
"server" value='<%# DataBinder.Eval(Container.DataItem, "e_item_id") %>'> 
                            <asp:Label id="Weekly_article_desc" style=
"font-size: 9pt; color: #000000" runat="server"> '<%# DataBinder.Eval
(Container.DataItem, "e_article_desc") %>' </asp:Label>&nbsp; 
                        </td>
                    </tr>
                    </table> 
                </td> 
            </tr> 
        </ItemTemplate> 
        <SeparatorTemplate> 
            <tr> 
                <td colspan="2" style="background-color: #FFFFFF; border
-width: 1">&nbsp;</td>
            </tr>
        </SeparatorTemplate>
        <FooterTemplate>
            <tr>
                    <td>
        </FooterTemplate> 
        </asp:Repeater></TD></TR>
        </table>  </TD></TR></TBODY></TABLE>
        <CC:Footer id="Footer" runat="server" /> 
    </form> 
  </body> 
</HTML> 
´Ϊ̨룬ز
namespace Book_Store 
{ 
 
    using System; 
    using System.Collections; 
    using System.ComponentModel; 
    using System.Data; 
    using System.Data.OleDb; 
    using System.Drawing; 
    using System.Web; 
    using System.Web.SessionState; 
    using System.Web.UI; 
    using System.Web.UI.WebControls; 
    using System.Web.UI.HtmlControls; 

public class Default:System.Web.UI.Page

    { 

// ĬCustomIncludesʼ
   protected CCUtility Utility; 

    //Search form SearchͿؼ
    protected System.Web.UI.WebControls.Button Search_search_button;
    protected System.Web.UI.WebControls.DropDownList Search_category
_id;
    protected System.Web.UI.WebControls.TextBox Search_name; 

    //Grid form RecommendedͿؼ
    protected System.Web.UI.HtmlControls.HtmlTableRow Recommended_no_
records; 
    protected string Recommended_sSQL; 
    protected string Recommended_sCountSQL; 
    protected int Recommended_CountPage; 
    protected CCPager Recommended_Pager; 
    protected System.Web.UI.WebControls.Repeater Recommended_Repeater; 
    protected int i_Recommended_curpage=1; 

    //Grid form WhatͿؼ
    protected System.Web.UI.HtmlControls.HtmlTableRow What_no_records; 
    protected string What_sSQL;
    protected string What_sCountSQL;
    protected int What_CountPage;

    protected System.Web.UI.WebControls.Repeater What_Repeater;
    protected int i_What_curpage=1; 

    //Grid form CategoriesͿؼ
    protected System.Web.UI.HtmlControls.HtmlTableRow Categories_no_
records;
    protected string Categories_sSQL;
    protected string Categories_sCountSQL;

    protected int Categories_CountPage; 
    protected System.Web.UI.WebControls.Repeater Categories_Repeater;
    protected int i_Categories_curpage=1; 
    
    //Grid form NewͿؼ
    protected System.Web.UI.HtmlControls.HtmlTableRow New_no_records;
    protected string New_sSQL;
    protected string New_sCountSQL;
    protected int New_CountPage; 

    protected System.Web.UI.WebControls.Repeater New_Repeater;
    protected int i_New_curpage=1; 

    //Grid form WeeklyͿؼ
    protected System.Web.UI.HtmlControls.HtmlTableRow Weekly_no_records;
    protected string Weekly_sSQL;
    protected string Weekly_sCountSQL;
    protected int Weekly_CountPage; 
    protected System.Web.UI.WebControls.Repeater Weekly_Repeater;
    protected int i_Weekly_curpage=1; 

    //Grid form SpecialsͿؼ
    protected System.Web.UI.HtmlControls.HtmlTableRow Specials_no_
records; protected string Specials_sSQL;
    protected string Specials_sCountSQL;
    protected int Specials_CountPage; 

    protected System.Web.UI.WebControls.Repeater Specials_Repeater;
    protected int i_Specials_curpage=1; 

    // ÿValuesActionsPK's,List  Search
    protected string Search_FormAction="Books.aspx?";

    // ÿValuesActionsPK's,ListAdvMenu
    protected string AdvMenu_FormAction=".aspx?"; 

    // ÿValues ActionsPK's,ListRecommended
    protected string Recommended_FormAction=".aspx?"; 

    // ÿValuesActionsPK's,ListWhat
    protected string What_FormAction=".aspx?"; 

    // ÿValuesActionsPK's,ListCategories
    protected string Categories_FormAction=".aspx?"; 

    // ÿValuesActionsPK's,ListNew
    protected string New_FormAction=".aspx?"; 

    // ÿValuesActionsPK's,ListWeekly
    protected string Weekly_FormAction=".aspx?"; 
    protected System.Web.UI.WebControls.Label SearchForm_Title; 
    protected System.Web.UI.WebControls.Label AdvMenuForm_Title; 
    protected System.Web.UI.WebControls.HyperLink AdvMenu_Field1; 
    protected System.Web.UI.WebControls.Label CategoriesForm_Title; 
    protected System.Web.UI.WebControls.Label Categories_Column_name; 
    protected System.Web.UI.WebControls.Label SpecialsForm_Title;
    protected System.Web.UI.WebControls.Label RecommendedForm_Title; 
    protected System.Web.UI.WebControls.Label WhatForm_Title; 
    protected System.Web.UI.WebControls.Label NewForm_Title; 
    protected System.Web.UI.WebControls.Label WeeklyForm_Title; 
    protected System.Web.UI.HtmlControls.HtmlTable Search_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable AdvMenu_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable Categories_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable Specials_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable Recommended_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable What_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable New_holder; 
    protected System.Web.UI.HtmlControls.HtmlTable Weekly_holder; 

    // ÿValuesActionsPK's,ListSpecials
    protected string Specials_FormAction=".aspx?";


public Default() 
{ 
this.Init += new System.EventHandler(Page_Init); 
} 

// ĬCustomIncludes
// ---------------------

public void ValidateNumeric(object source, ServerValidateEventArgs args) {
        try{
              Decimal temp=Decimal.Parse(args.Value);
              args.IsValid=true; 
            }catch{
              args.IsValid=false; } 
    }
//===============================
// ĬShowʼ 
        protected void Page_Load(object sender, EventArgs e)
        {
    Utility=new CCUtility(this); 
    //=============================== 
// ĬOpen Eventʼ
// ĬOpen Event
        //=============================== 
        //===============================
// ĬOpenAnyPage Eventʼ
// ĬOpenAnyPage Event 
    //=============================== 
    // 
    //=============================== 
    // ĬPageSecurityʼ
    // ĬPageSecurity
    //=============================== 



      if (!IsPostBack){ 
          Page_Show(sender, e); 
     } 
}

protected void Page_Unload(object sender, EventArgs e) 
{
    //
    // CODEGEN:ASP+ Windows Form DesignerҪ
    //
     if (Utility!=null) Utility.DBClose(); 
} 
 
protected void Page_Init(object sender, EventArgs e) 
{
    //
    // CODEGEN:ASP+Windows Form DesignerҪ
    // InitializeComponent();  System.EventHandler 
    Search_search_button.Click += new (this.Search_search_Click); 

    Recommended_Pager.NavigateCompleted+=new NavigateCompletedHandler(this.Recommended_pager_navigate_completed); 
   
} 
Ҫ֧DesignerķCô༭޸ıݡ
            private void InitializeComponent() 
            { 
            this.Unload += new System.EventHandler(this.Page_Unload); 
            this.Load += new System.EventHandler(this.Page_Load); 
        } 

            protected void Page_Show(object sender, EventArgs e) 
            {
        Search_Show();
        AdvMenu_Show();
        Recommended_Bind();
        What_Bind();
        Categories_Bind();
        New_Bind();
        Weekly_Bind();
        Specials_Bind(); 

            } 


// ĬShow

// Login

void Search_Show() { 

// Search Open Eventʼ
// Search Open Event

// Search Showʼ
Utility.buildListBox(Search_category_id.Items,"select category_id,name from categories order by 2","category_id","name","All",""); 

string s; 

s=Utility.GetParam("category_id"); 

try {Search_category_id.SelectedIndex=Search_category_id.Items.
IndexOf(Search_cate gory_id.Items.FindByValue(s)); 
}catch{} 

s=Utility.GetParam("name"); 
Search_name.Text = s; 

// Search Show Eventʼ
// Search Show Event

// Search Show

// Search Close Eventʼ
// Search Close Event
} 

void Search_search_Click(Object Src, EventArgs E) {
string sURL = Search_FormAction + "category_id="+Search_category_
id.SelectedItem.Value+"&" 
  + "name="+Search_name.Text+"&" 
; 
// Transit 
sURL += ""; 
Response.Redirect(sURL); 
} 

// Login

  protected void AdvMenu_Show(){ 

// AdvMenu Open Eventʼ 
// AdvMenu Open Event 

    // AdvMenu Showʼ

// AdvMenu BeforeShow Eventʼ 
// AdvMenu BeforeShow Event 

    // AdvMenu Show

} 

// Login form 

const int Recommended_PAGENUM = 5; 

public void Recommended_Repeater_ItemDataBound(Object Sender, Repeater
ItemEventArgs e){ 

// Recommended Show Eventʼ
  if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { 
    ((HyperLink)e.Item.FindControl("Recommended_name")).Text ="<img border=\"0\" src=\"" + ((DataRowView)e.Item.DataItem )["i_image_url"]
.ToString() + "\"></td><td valign=\"top\"><table width=\"100%\" style=
\"width:100%\"><tr><td style=\"background-color: #FFFFFF; border-style:
inset; border-width: 0\"><font style=\"font-size: 9pt; color: #CE7E00;
font-weight: bold\"><b>" + ((DataRowView)e.Item.DataItem )["i_name"].ToString() + "</b>"; 
} 
// Recommended Show Event
} 

ICollection Recommended_CreateDataSource() { 

        // Recommended Showʼ 
Recommended_sSQL = ""; 
Recommended_sCountSQL = ""; 

string sWhere = "", sOrder = ""; 

bool HasParam = false; 

//------------------------------- 
//  ORDER BY
//-------------------------------
System.Collections.Specialized.StringDictionary Params =new System.
Collections.Specialized.StringDictionary(); 

    sWhere = " WHERE is_recommended=1";

//------------------------------- 
// base SQL
//------------------------------- 

Recommended_sSQL = "select [i].[author] as i_author, " + 
    "[i].[image_url] as i_image_url, " + 
    "[i].[item_id] as i_item_id, " + 
    "[i].[name] as i_name, " + 
    "[i].[price] as i_price " + 
    " from [items] i "; 

//------------------------------- 
// Assemble full SQL
//------------------------------- 

  Recommended_sSQL = Recommended_sSQL + sWhere + sOrder; 
    if (Recommended_sCountSQL.Length== 0) {
      int iTmpI = Recommended_sSQL.ToLower().IndexOf("select ");
      int iTmpJ = Recommended_sSQL.ToLower().LastIndexOf(" from ")-1;
      Recommended_sCountSQL = Recommended_sSQL.Replace(Recommended_
sSQL.Substring(iTmpI + 7, iTmpJ-6), " count(*) ");
      iTmpI = Recommended_sCountSQL.ToLower().IndexOf(" order by");
        if (iTmpI > 1) Recommended_sCountSQL = Recommended_sCountSQL
.Substring(0, iTmpI);
    }

//------------------------------- 

OleDbDataAdapter command = new OleDbDataAdapter(Recommended_sSQL, Utility.Connection);
DataSet ds = new DataSet(); 

command.Fill(ds, (i_Recommended_curpage -1) * Recommended_PAGENUM, Recommended_PAGENUM,"Recommended");
OleDbCommand ccommand = new OleDbCommand(Recommended_sCountSQL, Utility
.Connection); 
int PageTemp=(int)ccommand.ExecuteScalar();
Recommended_Pager.MaxPage=(PageTemp%Recommended_PAGENUM)>0 ?(int)(PageTemp/Recommended_PAGENUM)+1:(int)(PageTemp/Recommended_P AGENUM);
bool AllowScroller=Recommended_Pager.MaxPage==1?false:true; 

DataView Source; 
        Source = new DataView(ds.Tables[0]); 

    if (ds.Tables[0].Rows.Count == 0){ 
         Recommended_no_records.Visible = true; 
         AllowScroller=false;} 
    else
        {Recommended_no_records.Visible = false; 
        AllowScroller=AllowScroller&&true;} 

Recommended_Pager.Visible=AllowScroller; 
return Source; 
// Recommended Show

} 

protected void Recommended_pager_navigate_completed(Object Src, int CurrPage)
    {
        i_Recommended_curpage=CurrPage; 

// Recommended CustomNavigation Eventʼ
// Recommended CustomNavigation Event
Recommended_Bind(); 
        } 

void Recommended_Bind() {
      Recommended_Repeater.DataSource = Recommended_Create
DataSource();
        Recommended_Repeater.DataBind(); 

} 

// Login

const int What_PAGENUM = 20;

public void What_Repeater_ItemDataBound(Object Sender, RepeaterItem
EventArgs e){ 

// What Show Eventʼ
  if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) {
    ((HyperLink)e.Item.FindControl("What_article_title")).Text ="<b>"+((DataRowView)e.Item.DataItem )["e_article_title"].ToString()+"<b>";
    ((Label)e.Item.FindControl("What_article_desc")).Text="<img align=\"left\" border=\"0\" src=\"" + Utility.Dlookup("items","image_url",
"item_id=" + ((DataRowView)e.Item.DataItem )["e_item_id"].ToString()) + "\">" + ((DataRowView)e.Item.DataItem )["e_article_desc"].ToString(); 
}
// What Show Event
} 

ICollection What_CreateDataSource() { 

        // What Showʼ
What_sSQL = ""; 
What_sCountSQL = ""; 

string sWhere = "", sOrder = ""; 

bool HasParam = false;

System.Collections.Specialized.StringDictionary Params =new System.
Collections.Specialized.StringDictionary(); 

    sWhere = " WHERE editorial_cat_id=1"; 

//------------------------------- 
//  base SQL
//------------------------------- 

What_sSQL = "select [e].[article_desc] as e_article_desc, " +
    "[e].[article_title] as e_article_title, " +
    "[e].[item_id] as e_item_id " +
    "from [editorials] e "; 

//------------------------------- 
// Assemble full SQL
//------------------------------- 

    What_sSQL = What_sSQL + sWhere + sOrder; 

//------------------------------- 

OleDbDataAdapter command = new OleDbDataAdapter(What_sSQL, Utility.Connection);
DataSet ds = new DataSet();

command.Fill(ds, 0, What_PAGENUM, "What");
DataView Source;
        Source = new DataView(ds.Tables[0]); 

    if (ds.Tables[0].Rows.Count == 0){ 
        What_no_records.Visible = true; 
        } 
    else
        {What_no_records.Visible = false; 
        }

    return Source;
    // What Show 

}

void What_Bind() {
      What_Repeater.DataSource = What_CreateDataSource(); 
      What_Repeater.DataBind(); 

} 

// Login

const int Categories_PAGENUM = 20;

public void Categories_Repeater_ItemDataBound(Object Sender, Repeater
ItemEventArgs e){ 

// Categories Show Eventʼ
// Categories Show Event
} 

ICollection Categories_CreateDataSource() { 

         // Categories Showʼ
Categories_sSQL = "";
Categories_sCountSQL = "";

string sWhere = "", sOrder = ""; 

bool HasParam = false; 

System.Collections.Specialized.StringDictionary Params =new System.
Collections.Specialized.StringDictionary();
//-------------------------------
// Build base SQL
//------------------------------- 
Categories_sSQL = "select [c].[category_id] as c_category_id, " + 
    "[c].[name] as c_name " + 
    " from [categories] c "; 

//-------------------------------
//Assemble full SQL
//-------------------------------

    Categories_sSQL = Categories_sSQL + sWhere + sOrder; 

//------------------------------- 

OleDbDataAdapter command = new OleDbDataAdapter(Categories_sSQL, Utility.Connection);
DataSet ds = new DataSet();

command.Fill(ds, 0, Categories_PAGENUM, "Categories");
DataView Source;
        Source = new DataView(ds.Tables[0]);

    if (ds.Tables[0].Rows.Count == 0){
        Categories_no_records.Visible = true;
        }
    Else
        {Categories_no_records.Visible = false;
        } 

    return Source;
    // Categories Show

} 

void Categories_Bind() { 
      Categories_Repeater.DataSource = Categories_CreateDataSource(); 
      Categories_Repeater.DataBind(); 

} 

// Login 

const int New_PAGENUM = 20;

public void New_Repeater_ItemDataBound(Object Sender, RepeaterItem
EventArgs e){ 

// New Show Eventʼ
  if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItem
Type.AlternatingItem) {
    ((HyperLink)e.Item.FindControl ("New_article_title")).Text ="<b>"+
((DataRowView)e.Item.DataItem)["e_article_title"].ToString()+"<b>"; 
((Label)e.Item.FindControl("New_article_desc")).Text="<img align=\"left\" border=\"0\" src=\"" + Utility.Dlookup("items","image_url",
"item_id=" + ((DataRowView)e.Item.DataItem )["e_item_id"].ToString()) + "\">" + ((DataRowView)e.Item.DataItem )["e_article_desc"].ToString(); 

} 
// New Show Event
} 

ICollection New_CreateDataSource() { 

        // New Showʼ
New_sSQL = ""; 
New_sCountSQL = ""; 

string sWhere = "", sOrder = ""; 

bool HasParam = false; 

System.Collections.Specialized.StringDictionary Params =new System.Collections.Specialized.StringDictionary(); 

  sWhere = " WHERE editorial_cat_id=2";

//------------------------------- 
// Build base SQL
//------------------------------- 

New_sSQL = "select [e].[article_desc] as e_article_desc, " + 
    "[e].[article_title] as e_article_title, " + 
    "[e].[item_id] as e_item_id " + 
    "from [editorials] e "; 

//------------------------------- 
// Assemble full SQL
//------------------------------- 

  New_sSQL = New_sSQL + sWhere + sOrder;
//------------------------------- 

OleDbDataAdapter command = new OleDbDataAdapter(New_sSQL, Utility
.Connection);

DataSet ds = new DataSet();

command.Fill(ds, 0, New_PAGENUM, "New"); 
DataView Source; 
        Source = new DataView(ds.Tables[0]); 

      if (ds.Tables[0].Rows.Count == 0){ 
          New_no_records.Visible = true;
          }
      else
          {New_no_records.Visible = false; 
          } 

      return Source;
      // New Show

}

void New_Bind() { 
        New_Repeater.DataSource = New_CreateDataSource(); 
        New_Repeater.DataBind(); 

} 

// Login

const int Weekly_PAGENUM = 20;

public void Weekly_Repeater_ItemDataBound(Object Sender, RepeaterItem
EventArgs e){ 

// Weekly Show Eventʼ
  if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) {
((HyperLink)e.Item.FindControl("Weekly_article_title")).Text ="<b>"+((DataRowView)e.Item.DataItem )["e_article_title"].ToString()+"<b>"; 
((Label)e.Item.FindControl("Weekly_article_desc")).Text="<img align=
\"left\" border=\"0\" src=\"" + Utility.Dlookup("items","image_url","item_id=" + ((DataRowView)e.Item.DataItem )["e_item_id"].ToString()) + "\">" + ((DataRowView)e.Item.DataItem )["e_article_desc"].ToString(); 
} 
// Weekly Show Event
} 

ICollection Weekly_CreateDataSource() { 
        // Weekly Showʼ
Weekly_sSQL = ""; 
Weekly_sCountSQL = "";

string sWhere = "", sOrder = "";

bool HasParam = false; 

System.Collections.Specialized.StringDictionary Params =new System.
Collections.Specialized.StringDictionary(); 

  sWhere = " WHERE editorial_cat_id=3"; 

//------------------------------- 
// Build base SQL
//------------------------------- 

Weekly_sSQL = "select [e].[article_desc] as e_article_desc, " + 
    "[e].[article_title] as e_article_title, " + 
    "[e].[item_id] as e_item_id " + 
    "from [editorials] e "; 

//------------------------------- 
// Assemble full SQL
//------------------------------- 


  Weekly_sSQL = Weekly_sSQL + sWhere + sOrder; 
//------------------------------- 

OleDbDataAdapter command = new OleDbDataAdapter(Weekly_sSQL, Utility
.Connection);
DataSet ds = new DataSet(); 

command.Fill(ds, 0, Weekly_PAGENUM, "Weekly"); 
DataView Source; 
        Source = new DataView(ds.Tables[0]); 
        if (ds.Tables[0].Rows.Count == 0){ 
            Weekly_no_records.Visible = true;
            } 
        Else
            {Weekly_no_records.Visible = false;
            } 

        return Source;
        // Weekly Show

} 

void Weekly_Bind() {
      Weekly_Repeater.DataSource = Weekly_CreateDataSource();
      Weekly_Repeater.DataBind();

} 

// Login

const int Specials_PAGENUM = 20;

public void Specials_Repeater_ItemDataBound(Object Sender, Repeater
ItemEventArgs e){ 

// Specials Show Eventʼ
// Specials Show Event
} 

ICollection Specials_CreateDataSource() { 
        // Specials Showʼ 
Specials_sSQL = ""; 
Specials_sCountSQL = ""; 

string sWhere = "", sOrder = ""; 

bool HasParam = false; 

System.Collections.Specialized.StringDictionary Params =new System.
Collections.Specialized.StringDictionary(); 

  sWhere = " WHERE editorial_cat_id=4"; 

//------------------------------- 
// Build base SQL
//------------------------------- 

Specials_sSQL = "select [e].[article_desc] as e_article_desc, " + 
    "[e].[article_title] as e_article_title " +
    "from [editorials] e ";

//------------------------------- 
// Assemble full SQL
//------------------------------- 

   Specials_sSQL = Specials_sSQL + sWhere + sOrder;
//------------------------------- 

OleDbDataAdapter command = new OleDbDataAdapter(Specials_sSQL, Utility.
Connection); 

DataSet ds = new DataSet(); 

command.Fill(ds, 0, Specials_PAGENUM, "Specials");
DataView Source;
        Source = new DataView(ds.Tables[0]); 
      if (ds.Tables[0].Rows.Count == 0){
          Specials_no_records.Visible = true;
          }
      Else
          {Specials_no_records.Visible = false;
          }

    return Source; 
    // Specials Show

}

void Specials_Bind() { 
      Specials_Repeater.DataSource = Specials_CreateDataSource(); 
      Specials_Repeater.DataBind();
