Views/UserCenter/UsersList.ashx

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

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

<%@ WebHandler Language="C#" Class="UsersList" %>

using System;
using System.Web;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using MicroDBHelper;
using MicroPublicHelper;
using MicroDTHelper;
using MicroAuthHelper;

public class UsersList : IHttpHandler, System.Web.SessionState.IRequiresSessionState
{

    //****************
    //说明
    //根据表名返回表的内容
    //如父项和子项，主要菜单和子菜单等
    //****************

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        MicroAuth.CheckLogin();

        string flag = MicroPublic.GetMsg("SubmitFailed"),
                    Action = context.Server.UrlDecode(context.Request.QueryString["action"]),
                    MID = context.Server.UrlDecode(context.Request.QueryString["mid"]),
                    ShortTableName = context.Server.UrlDecode(context.Request.QueryString["stn"]),
                    Type = context.Server.UrlDecode(context.Request.QueryString["type"]),
                    TypeID = context.Server.UrlDecode(context.Request.QueryString["typeid"]),
                    Keyword = context.Server.UrlDecode(context.Request.QueryString["Keyword"]),
                    Page = context.Server.UrlDecode(context.Request.QueryString["page"]),
                    Limit = context.Server.UrlDecode(context.Request.QueryString["limit"]);

        //测试数据
        //ShortTableName = "use";
        //Type = "all";
        //TypeID = "1";

        Page = string.IsNullOrEmpty(Page) == true ? "1" : Page;
        Limit = string.IsNullOrEmpty(Limit) == true ? "10" : Limit;

        if (!string.IsNullOrEmpty(ShortTableName) && !string.IsNullOrEmpty(Type))
        {
            Type = Type.ToLower();

            if (Type == "all")
                flag = GetAllUsersList(ShortTableName, Page.toInt(), Limit.toInt());

            if (Type == "dept")
                flag = GetDeptUsersList(ShortTableName, TypeID.toInt(), Page.toInt(), Limit.toInt());

            if (Type == "jtitle")
                flag = GetJobTitleUsersList(ShortTableName, TypeID.toInt(), Page.toInt(), Limit.toInt());

            if (Type == "role")
                flag = GetRolesUsersList(ShortTableName, TypeID.toInt(), Page.toInt(), Limit.toInt());