#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>