public static string page(string PageIndex, string PageSize, string txtname, string dptid, string ustat, string schid, string schsubs, string childrenids) { string ret = ""; if (Com.Session.userid == null) { ret = "expire"; } else { SchSystem.BLL.SchUserInfo userbll = new SchSystem.BLL.SchUserInfo(); if (schid == "") { schid = "0"; } //Stat:0废弃,1正常,2被删除,正常界面不显示删除,超管界面可以考虑 string strwhere = " Stat=1 and SchId='" + Com.Public.SqlEncStr(schid) + "'";//SysType if (!string.IsNullOrEmpty(txtname)) { strwhere += " and UserTname like '%" + Com.Public.SqlEncStr(txtname) + "%'"; } if (Com.Session.systype != "2") { strwhere += " and SysType=0 "; } if (!string.IsNullOrEmpty(ustat)) { if (ustat != "3") { strwhere += " and AccStat='" + Com.Public.SqlEncStr(ustat) + "' and len(UserName)>0 "; } else { strwhere += " and (len(UserName)=0 or UserName=NULL) "; } } if (!string.IsNullOrEmpty(schsubs) && schsubs != "0") { strwhere += " and SubCode='" + Com.Public.SqlEncStr(schsubs) + "'"; } if (!string.IsNullOrEmpty(dptid) && dptid != "0") { if (!string.IsNullOrEmpty(childrenids)) { childrenids = childrenids.Substring(0, childrenids.Length - 1); strwhere += " and UserId in (select UserName from SchUserDept where DeptId in (" + Com.Public.SqlEncStr(childrenids) + "))"; } else { strwhere += " and UserId in (select UserName from SchUserDept where DeptId=" + Com.Public.SqlEncStr(dptid) + ")"; } } Com.Public.PageModelResp pages = new Com.Public.PageModelResp(); pages.PageIndex = int.Parse(PageIndex); pages.PageSize = int.Parse(PageSize); int rowc = 0; int pc = 0; DataTable dt = userbll.GetListCols("Mobile,UserId,UserName,UserTname,Postion,Title,Sex,AccStat,SchId", strwhere, "UserTname", "ASC", pages.PageIndex, pages.PageSize, ref rowc, ref pc).Tables[0]; pages.PageCount = pc; pages.RowCount = rowc; if (dt.Rows.Count > 0) { dt.Columns.Add("Dpts"); //获取关联的部门 //性别 dt.Columns.Add("Sexn"); //获取关联的角色 dt.Columns.Add("Roles"); //获取关联科目 dt.Columns.Add("SubName"); //获取关联科目 dt.Columns.Add("Ustat"); SchSystem.BLL.SchUserRoleXXTV rolevbll = new SchSystem.BLL.SchUserRoleXXTV(); SchSystem.BLL.SchUserDeptV deptvbll = new SchSystem.BLL.SchUserDeptV(); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i]["Roles"] = rolevbll.GetNames("UserName='******' and Stat=1 and schid=" + dt.Rows[i]["SchId"]); dt.Rows[i]["Roles"] = rolevbll.GetNames("UserId='" + dt.Rows[i]["UserId"] + "' and Stat=1 and schid=" + dt.Rows[i]["SchId"]); dt.Rows[i]["Dpts"] = deptvbll.GetNames("UserId='" + dt.Rows[i]["UserId"] + "' and Stat=1 and schid=" + dt.Rows[i]["SchId"]); dt.Rows[i]["Sexn"] = dt.Rows[i]["Sex"].ToString() == "1" ? "男" : "女"; //dt.Rows[i]["Ustat"] = dt.Rows[i]["Stat"].ToString() == "1" ? "正常" : "停用"; if (dt.Rows[i]["AccStat"].ToString() == "1") { dt.Rows[i]["Ustat"] = "正常"; } else if (dt.Rows[i]["AccStat"].ToString() == "0") { dt.Rows[i]["Ustat"] = "停用"; } //if (!string.IsNullOrEmpty(dt.Rows[i]["SubCode"].ToString())) // dt.Rows[i]["SubName"] = Com.Public.GetSubName(dt.Rows[i]["SubCode"].ToString(), dt.Rows[i]["SchId"].ToString()); //else // dt.Rows[i]["SubName"] = ""; } pages.list = dt; } ret = Newtonsoft.Json.JsonConvert.SerializeObject(pages); } return(ret); }
public string MenuInfoExt = ""; //特殊权限功能数据,json //需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一 protected void Page_Load(object sender, EventArgs e) { uid = Request.Params["uid"].ToString(); SchSystem.BLL.SchUserInfo userbll = new SchSystem.BLL.SchUserInfo(); SchSystem.Model.SchUserInfo usermodel = userbll.GetModel(int.Parse(uid)); if (usermodel != null && usermodel.UserId > 0) { utname = usermodel.UserTname; usex = usermodel.Sex == 0 ? "女" : "男"; ups = usermodel.Postion; ujb = usermodel.Title; utl = usermodel.Telno; uname = usermodel.UserName; if (usermodel.PassWord == Com.Public.StrToMD5("123456")) { upw = "123456"; upwname = "初始密码"; } else if (usermodel.PassWord == "") { upw = ""; upwname = "初始密码"; } else { upw = "●●●●●●"; upwname = "用户密码"; } ustat = usermodel.AccStat == 0 ? "禁用" : "正常"; SchSystem.BLL.SchUserDeptV dpvbll = new SchSystem.BLL.SchUserDeptV(); udpts = dpvbll.GetNames("UserId=" + uid); uno = "00000000".Substring(0, 8 - uid.Length) + uid; schid = usermodel.SchId.ToString(); SchSystem.BLL.SchRoleXXT rolebll = new SchSystem.BLL.SchRoleXXT(); DataTable dtrole = rolebll.GetList("RoleId id,null pId,RoleName name,'false' checked", "Stat=1 and SchId=" + schid + " and SysType='0' Order by RoleName").Tables[0]; //获取该用户关联的角色 SchSystem.BLL.SchUserRoleXXTV urolevbll = new SchSystem.BLL.SchUserRoleXXTV(); string uroleids = urolevbll.GetIds(" UserId='" + uid + "' and stat=1 and schid=" + schid); if (!string.IsNullOrEmpty(uroleids) && dtrole != null) { string[] ids = uroleids.Split(','); for (int i = 0; i < dtrole.Rows.Count; i++) { string id = dtrole.Rows[i]["id"].ToString(); if (ids.Contains(id)) { dtrole.Rows[i]["checked"] = "true"; } } } roles = Newtonsoft.Json.JsonConvert.SerializeObject(dtrole); //获取功能树,查询条件需要根据用户种类和状态等,后面需要改 //根据学校拥有的子系统 SchSystem.BLL.SchAppRole schapprolebll = new SchSystem.BLL.SchAppRole(); string appstr = schapprolebll.GetAppStr(int.Parse(schid)); if (appstr != "") { appstr = " and (AppCode=1 or AppCode=2 or AppCode in (" + appstr + ")) "; } SchSystem.BLL.SchMenuInfoUserFuncXXT funcbll = new SchSystem.BLL.SchMenuInfoUserFuncXXT(); DataTable dtfunc = funcbll.GetList("MenuId id,Pid pId,TextName name,FuncCode funcode,'false' checked", " Stat=1 " + appstr + " Order by OrderId").Tables[0]; funcstr = Newtonsoft.Json.JsonConvert.SerializeObject(dtfunc); } }