InquesUserList.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class InquesUserList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            gvbind();
        }
    }
    private void gvbind()
    {
        string XueXiao = Request.QueryString["XueXiao"].ToString();
        string XingMing = Request.QueryString["XingMing"].ToString();
        string Sex = Request.QueryString["Sex"].ToString();


        string Age = Request.QueryString["Age"].ToString();
        string emal = Request.QueryString["emal"].ToString();
        string Tel = Request.QueryString["Tel"].ToString();

      string   sql = "select   * from [Users] where  1=1";



      if (XueXiao != "")
        {
            sql += " and   XueXiao   like   '%" + XueXiao + "%'   ";

        }
        if (XingMing != "")
        {
            sql += " and   XingMing   like   '%" + XingMing + "%'   ";
        }
        if (Sex != "全部")
        {
            sql += " and   Sex   like   '%" + Sex + "%'   ";
        }
        if (Age != "")
        {
            sql += " and   Age   like   '%" + Age + "%'   ";
        } if (emal != "")
        {
            sql += " and   emal   like   '%" + emal + "%'   ";
        } if (Tel != "")
        {
            sql += " and   Tel   like   '%" + Tel + "%'   ";
        }