AdminInfoManage.aspx.cs

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

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

using MyWeb.DBUtility;
using MyWeb.WebUtility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace MyWeb
{
    public partial class AdminInfoManage : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        [WebMethod]
        public static string loadAdminInfoManage(string pi, string ps)
        {
            DBHelper db = new DBHelper();
            //分页sql查询列表数据
            string sql = "select top " + ((Convert.ToInt32(pi) - 1) * Convert.ToInt32(ps) + Convert.ToInt32(ps)) + " * from AdminInfo_Tbl where del=0 and id not in (select top " + ((Convert.ToInt32(pi) - 1) * Convert.ToInt32(ps)) + " id from AdminInfo_Tbl where del=0 order by addDate desc) order by addDate desc";
            DataSet ds = db.Query(sql);
            string html = "";
            string sex = "";
            string isAudit = "";
            string type = "";
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                //判断性别
                if (ds.Tables[0].Rows[i]["sex"].ToString() == "1")
                {
                    sex = "男";
                }
                else
                {
                    sex = "女";
                }
                if (ds.Tables[0].Rows[i]["isAudit"].ToString() == "1")
                {
                    isAudit = "已审核";
                }
                else
                {
                    isAudit = "未审核";
                }
                if (ds.Tables[0].Rows[i]["type"].ToString() == "0")
                {
                    type = "超级管理员";
                }
                else
                {
                    type = "普通管理员";
                }
                //得到列表数据  <td><input type='button' value='设为超级管理员' class='btn3' id='" + ds.Tables[0].Rows[i]["id"] + "'/></td><td><input type='button' value='设为普通管理员' class='btn4' id='" + ds.Tables[0].Rows[i]["id"] + "'/></td>    <td>" + type + "</td>
                html += "<tr><td>" + ds.Tables[0].Rows[i]["account"] + "</td><td>" + ds.Tables[0].Rows[i]["tel"] + "</td><td>" + ds.Tables[0].Rows[i]["password"] + "</td><td>" + ds.Tables[0].Rows[i]["age"] + "</td><td>" + sex + "</td><td>" + ds.Tables[0].Rows[i]["addDate"] + "</td><td>" + isAudit + "</td><td><input type='button' value='删除' class='btn' id='" + ds.Tables[0].Rows[i]["id"] + "'/></td><td><a href='EditAdminInfo.aspx?id=" + ds.Tables[0].Rows[i]["id"] + "'>修改</a></td><td><input type='button' value='审核' class='btn2' id='" + ds.Tables[0].Rows[i]["id"] + "'/></td></tr>";
            }