Web/Controllers/usermanagerController.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Text;
using Maticsoft.DBUtility;
using System.Data;
namespace Web.Controllers
{
    public class usermanagerController : Controller
    {
        SoftMVC.BLL.T_usermanager umbll = new SoftMVC.BLL.T_usermanager();
        SoftMVC.Model.T_usermanager ummodel = new SoftMVC.Model.T_usermanager();
        private string returnstr = "";
        private string sql, getsql;
        #region"页面转向"
        public ActionResult usermanagerlist()
        {
            if (Session["username"] != null && Session["username"] != "")
            {
                return View();
            }
            else
            {
                return RedirectToAction("../userlogin/userlogin");
            }
        }
        #endregion
        #region"绑定菜单数据"
        public string userlistjson()
        {
            StringBuilder usersb = new StringBuilder();
            string userstr = "";
            try{
            if (!string.IsNullOrEmpty(Request["start"]) && !string.IsNullOrEmpty(Request["limit"]))
            {
                int start = int.Parse(Request["start"].ToString());
                int limit = int.Parse(Request["limit"].ToString());
                if (Request["selectuser"] != null && Request["selectuser"] != "")
                {
                    sql = "select * from T_usermanager   where username1 like '%" + Request["selectuser"].ToString() + "%' or realname like '%" + Request["selectuser"].ToString() + "%'";
                }
                else
                {
                    sql = "select * from T_usermanager";
                }
                int totilecount = int.Parse(DbHelperSQL.Query(Utils.getSqlCount(sql)).Tables[0].Rows[0][0].ToString());
                usersb.Append("{usercount:" + totilecount + ",userlist:[");
                getsql = Utils.getPageSizeSql(sql, "userid", 10, start);
                foreach (DataRow dr in DbHelperSQL.Query(getsql).Tables[0].Rows)
                {
                    usersb.Append("{userid:'" + dr["userid"].ToString() + "',peoplename:'" + dr["peopleid"].ToString() + "',username1:'" + dr["username1"].ToString() + "',realname:'" + dr["realname"].ToString() + "',userisuser:'" + dr["userisuser"].ToString() + "',starttime:'" + Convert.ToDateTime(dr["starttime"].ToString()).ToString("yyyy-MM-dd") + "',endtime:'" + Convert.ToDateTime(dr["endtime"].ToString()).ToString("yyyy-MM-dd") + "',addtime:'" + dr["addtime"].ToString() + "',lasttime:'" + dr["lasttime"].ToString() + "',islocked:'" + dr["islocked"].ToString() + "'},");
                }
                usersb.Append("]}");
                userstr = usersb.ToString().Replace(",]}", "]}");
            }
            }
            catch (Exception ex)
            {