HTNResp/Controllers/UserListController.cs

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

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

using HTNResp.Codes;
using HTNResp.Common;
using Maticsoft.DBUtility;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Script.Serialization;

namespace HTNResp.Controllers
{
    [Login, Authority]
    public class UserListController : BaseController
    {
        HTNResp.BLL.UserTable bll = new HTNResp.BLL.UserTable();
        HTNResp.BLL.Program bllProgram = new BLL.Program();
        HTNResp.BLL.ProjectDictionary bllProject = new BLL.ProjectDictionary();
        public override ActionResult Index()
        {
            DataTable dt = DbHelperSQL.Query("select * from AccessTable a join PermissionTable p on (p.TableID=a.ID)").Tables[0];
            string authAll = ModelConvertHelper.ConvertToModel(dt);

            BLL.AccessTable bllaccess = new BLL.AccessTable();
            List<Model.AccessTable> AccessList = bllaccess.GetModelList("");


            ViewBag.AccessList = AccessList;
            ViewBag.EvalGridUserAuth = authAll;
            return View();
        }

        public override ActionResult AjaxList()
        {
            int start = 0;  // 分页起始条目数
            int length = 0; // 分页每页分页数

            start = Convert.ToInt32(Request.Params["start"]);
            length = Convert.ToInt32(Request.Params["length"]);

            // todo: 读取数据库 获取分页数据
            //string strSql = "Status=1";

            //System.Text.StringBuilder sb = new System.Text.StringBuilder();
            //if (!string.IsNullOrEmpty(Request.Params["DecisionRule"]))
            //{
            //    sb.Append(" and DecisionRule like '%" + Request.Params["DecisionRule"] + "%' ");
            //}
            //if (!string.IsNullOrEmpty(Request.Params["Contents"]))
            //{
            //    sb.Append(" and Contents like '%" + Request.Params["Contents"] + "%' ");
            //}
            //if (!string.IsNullOrEmpty(Request.Params["Sex"]))
            //{
            //    sb.Append(" and Sex='" + Request.Params["Sex"] + "' ");
            //}
            //if (!string.IsNullOrEmpty(Request.Params["EvalGuidId"]))
            //{
            //    sb.Append(" and EvalGuidId='" + Request.Params["EvalGuidId"] + "'");