#region 绑定参数值
        private void BindQuery()
        {
            if (!string.IsNullOrEmpty(Request.QueryString["key"]))
                Text_Key.Text = Request.QueryString["key"];
        }
        #endregion
        #region 提交搜索
        protected void Btn_Search_Click(object sender, EventArgs e)
        {
            StringBuilder query = new StringBuilder(Request.Url.AbsolutePath);
            query.Append("?");
            if (!string.IsNullOrEmpty(Text_Key.Text.Trim()))
                query.AppendFormat("key={0}&", HttpUtility.UrlEncode(Text_Key.Text.Trim()));
            Response.Redirect(query.ToString().Trim('&'), true);
        }
        #endregion
        #region 分页绑定
        public void Rep_Bind() 
        {

            int currentPageIndex = 1;
            if (Validator.IsUInt32(Request.QueryString["page"])) currentPageIndex = Convert.ToInt32(Request.QueryString["page"]);
            GetPageData getPage = new GetPageData();
            getPage.TableName = "[Company]";
            getPage.KeyName = "[CompanyID]";
            getPage.FieldList = "*";
            getPage.OrderByList = "[CompanyID]";
            getPage.Where = this.SQLWhere(getPage);
            getPage.SQLKind = Lib.EnumSQLKind.Over;
            getPage.ConnectionString = ConnectionStrings.CruisesTransactionReadOnly;
            getPage.PageSize = 15;
            getPage.CurrentPageIndex = currentPageIndex;
            Repeater_List.DataSource = getPage.DataTableList();
            Repeater_List.DataBind();
            PageUI getPageUI = new PageUI();
            getPageUI.RecordCount = getPage.RecordCount;
            getPageUI.CurrentPageIndex = getPage.CurrentPageIndex;
            getPageUI.PageSize = getPage.PageSize;
            Li_PageUI.Text = getPageUI.GetPageUIHtml();
           
        }
        #endregion
        #region 检索方法
        private string SQLWhere(GetPageData getPage)
        {
            System.Collections.Generic.List<SqlParameter> parLiat = new System.Collections.Generic.List<SqlParameter>();
            getPage.SqlParaList = parLiat;
            System.Text.StringBuilder where = new System.Text.StringBuilder();
            if (!string.IsNullOrEmpty(Request.QueryString["key"]))
            {
                string key = Function.RemoveSQL(Request.QueryString["key"].Trim(), 10);
                where.AppendFormat(" [CompanyName] LIKE '%{0}%' AND ", key);
            }
            where.Append(" 1=1");
            return where.ToString();
        }
        #endregion
<div class="main">
        公司名称:<asp:TextBox CssClass="txt" Width="100px" ID="Text_Key" MaxLength="20" runat="server"></asp:TextBox>
        <asp:Button CssClass="btn1" ID="Btn_Search" runat="server" Text="搜索" onclick="Btn_Search_Click"/>
    </div>
<table class="main border" cellpadding="0" cellspacing="0" border="0">
        <tr>
            <th>公司ID</th>
            <th style="width:200px;">公司名称</th>
            <th style="width:300px;">应用标识</th>
            <th style="width:300px;">应用密钥</th>
            <th style="width:300px;">通知地址</th>
            <th>操作</th>
        </tr>
        <asp:Repeater ID="Repeater_List" EnableViewState="false" runat="server">
            <ItemTemplate>
            <tr class="row">
                <td><%#Eval("CompanyID")%></td>
                <td><%#Eval("CompanyName")%></td>
                <td><%#Eval("AppKey")%></td>
                <td><%#Eval("AppSecret")%></td>
                <td><%#Eval("ReturnUrl")%></td>

          
                <td>
                <a href="AppSecret_Add.aspx?id=<%#Eval("CompanyID") %>&name=<%#Eval("CompanyName")%>">编辑</a>
              <a href="AppSecret_List.aspx?id=<%#Eval("CompanyID") %>&name=<%#Eval("CompanyName")%>" onclick="return confirm('确定要删除?');">删除</a></td>
            </tr>
            </ItemTemplate>
        </asp:Repeater>
    </table>
    <asp:Literal ID="Li_PageUI" EnableViewState="false" runat="server"></asp:Literal>

 

 posted on 2012-10-24 17:56  kakestar  阅读(1471)  评论(0编辑  收藏  举报