SystemManage/username_dc.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.OleDb;
using qiupeng.Public;
using System.IO;
namespace qphr.SystemManage
{
    public partial class username_dc : System.Web.UI.Page
    {
  
        Db List = new Db();
        public static string SqlStrStart, SqlStrMid, SqlStr;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (this.Session["username"] == null)
            {
                this.Response.Write("<script language=javascript>alert('登陆超时！');window.parent.location = '../main_d.aspx'</script>");
                return;

            }

            if (!Page.IsPostBack)
            {
                List.InsertLog("导出用户管理列表", "用户管理");
                DataBindToGridview();
                List.ToExcel(GridView1,"User");
               
            }
        }

        public void DataBindToGridview()
        {
            SqlStrStart = "select * from qp_hr_username where 1=1";
            

            SqlStrMid = string.Empty;
            SqlStrMid = Server.UrlDecode(Request.QueryString["str"]);
            SqlStr = SqlStrStart + SqlStrMid;//查询

            if (Request.QueryString["str"] != null)
            {

                string SQL_GetList_xs = "" + SqlStr + " ";
                GridView1.DataSource = List.GetGrid_Pages_not(SQL_GetList_xs);
                GridView1.DataBind();


            }
            else
            {
                string SQL_GetList_xs = "select * from qp_hr_username";
                GridView1.DataSource = List.GetGrid_Pages_not(SQL_GetList_xs);