public static string roledel(string schid, string roleid) { if (!Com.Public.isVa(schid, "")) { return("无跨界权限;"); } string ret = "success"; if (Com.Session.userid == null) { ret = "expire"; } else { try { SchSystem.BLL.SchUserRoleV surBll = new SchSystem.BLL.SchUserRoleV(); bool surBool = surBll.ExistsRoleData(schid, roleid); if (surBool) { ret = "success01"; } else { SchSystem.BLL.SchRole bll = new SchSystem.BLL.SchRole(); SchSystem.Model.SchRole model = new SchSystem.Model.SchRole(); model.RoleId = int.Parse(roleid); model.Stat = 2; model.LastRecTime = DateTime.Now; model.LastRecUser = Com.Session.userid; if (bll.UpdateStat(model)) { ret = "success"; } else { ret = "操作失败"; } } } catch (Exception ex) { ret = ex.Message; } } return(ret); }
public string subs = ""; //相应学校科目表及个人科目,json //需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一 protected void Page_Load(object sender, EventArgs e) { //if (true)//如果没对应权限,及判断用户类型是否跨界,主要防止非法篡改数据出现 //{ // Response.Write("无对应权限"); // Response.End(); //} if (!IsPostBack) { //先得到操作类型 dotype = Request.Params["dotype"].ToString(); string uid = "0"; //修改时的用户ID string uname = ""; //修改时的用户账号 if (dotype == "a") //添加 { //根据登录人员的身份,需要得到不同的参数 if (Com.SoureSession.Souresystype == "2")//超管,两个关键参数均需要确认 { schid = Request.Params["schid"].ToString(); systype = Request.Params["systype"].ToString(); if (string.IsNullOrEmpty(schid) || string.IsNullOrEmpty(systype))//如果没有对应参数中任意一个 { Response.Write("学校ID为空或者添加的类型为空!"); Response.End(); } } else//本学校超管或本学校有权限的用户,只能操作普通用户 { schid = Com.SoureSession.Soureschid; systype = "0"; } } else if (dotype == "e" || dotype == "s")//修改或查看,不能修改用户的类型及学校参数 { btnname = "修改"; uid = Request.Params["uid"].ToString(); if (string.IsNullOrEmpty(uid)) { Response.Write("无对应修改的用户!"); Response.End(); } //获取修改的对应用户的 SchSystem.BLL.SchUserInfo userbll = new SchSystem.BLL.SchUserInfo(); SchSystem.Model.SchUserInfo usermodel = userbll.GetModel(int.Parse(uid)); if (usermodel != null && usermodel.UserId > 0) { umodelstr = Newtonsoft.Json.JsonConvert.SerializeObject(usermodel); schid = usermodel.SchId.ToString(); systype = usermodel.SysType.ToString(); uname = usermodel.UserName; } else { Response.Write("无该用户!"); Response.End(); } } else//不在添加及修改之内,则返回 { Response.Write("没有可供确认的操作类型!"); Response.End(); } //判断跨界操作的可能性 if (!Com.Public.isVa(schid, systype)) { Response.Write("出错,用户非法跨界操作!"); Response.End(); } SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo(); schname = schbll.GetSchName(int.Parse(schid)); if (!string.IsNullOrEmpty(schid) && !string.IsNullOrEmpty(systype)) { //获取整个学校的科目 subs = Com.Public.GetDrp("sub", schid, "1", false, "", ""); //获取整个学校的部门 SchSystem.BLL.SchDepartInfo dptbll = new SchSystem.BLL.SchDepartInfo(); DataTable dtdept = dptbll.GetList("Pid pId,DepartId id,DepartName name,'false' checked", "SchId=" + schid + " and Stat=1 Order by OrderId").Tables[0]; //获取该用户的关联部门 SchSystem.BLL.SchUserDeptV udeptvbll = new SchSystem.BLL.SchUserDeptV(); string udeptids = udeptvbll.GetIds(" UserId='" + uid + "' and stat=1 and schid=" + schid); if (!string.IsNullOrEmpty(udeptids) && dtdept != null) { string[] ids = udeptids.Split(','); for (int i = 0; i < dtdept.Rows.Count; i++) { string id = dtdept.Rows[i]["id"].ToString(); if (ids.Contains(id)) { dtdept.Rows[i]["checked"] = "true"; } } } depts = Newtonsoft.Json.JsonConvert.SerializeObject(dtdept); //获取角色菜单 SchSystem.BLL.SchRole rolebll = new SchSystem.BLL.SchRole(); DataTable dtrole = rolebll.GetList("RoleId id,null pId,RoleName name,'false' checked", "Stat=1 and SchId=" + schid + " and SysType='" + systype + "' Order by RoleName").Tables[0]; if (dtrole.Rows.Count == 0) { //给个默认根节点 DataRow dr = dtrole.NewRow(); dr["id"] = "0"; dr["pId"] = DBNull.Value; dr["name"] = "权限组"; dr["checked"] = "false"; dtrole.Rows.Add(dr); } //获取该用户关联的角色 SchSystem.BLL.SchUserRoleV urolevbll = new SchSystem.BLL.SchUserRoleV(); 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.SchMenuInfoUserFunc funcbll = new SchSystem.BLL.SchMenuInfoUserFunc(); 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); } } }
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.SchUserRoleV rolevbll = new SchSystem.BLL.SchUserRoleV(); 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 static string UserLoginDo(string uname, bool iscookies, string schid) { string str = ""; SchSystem.BLL.SchUserInfo userbll = new SchSystem.BLL.SchUserInfo(); //查询登录用户记录数据 DataTable SchUserInfoDs = userbll.GetList("UserId,UserName,UserTname,SchId,SysType,ImgUrl", "UserName='******' and Stat=1 and AccStat=1 and SchId=" + schid).Tables[0]; if (SchUserInfoDs.Rows.Count > 0) { SchSystem.BLL.SchUserRoleV userroleV = new SchSystem.BLL.SchUserRoleV(); DataTable dtroles = userroleV.GetList("UserName='******' and Stat=1 and AccStat=1 and SchId=" + schid).Tables[0]; //if (dtroles.Rows.Count > 0) //{ //设置Session信息 Com.Session.usertid = SchUserInfoDs.Rows[0]["UserId"].ToString(); Com.Session.userid = SchUserInfoDs.Rows[0]["UserName"].ToString(); Com.Session.uname = SchUserInfoDs.Rows[0]["UserTname"].ToString(); Com.Session.schid = SchUserInfoDs.Rows[0]["SchId"].ToString(); Com.Session.systype = SchUserInfoDs.Rows[0]["SysType"].ToString(); Com.Session.imgurl = SchUserInfoDs.Rows[0]["ImgUrl"].ToString(); //合并普通权限串 Com.Session.userrolestr = Com.Public.UserRoleStr(dtroles); //合并特殊权限串 Com.Session.userrolestrext = Com.Public.UserRoleExtStr(dtroles); Com.Session.ulogintime = DateTime.Now.ToString("yyyyMMddHHmmss"); //设置cookies if (iscookies) { CookieHelper.SetCookie("uname", uname, DateTime.Now.AddDays(7)); } //获取老师身份 if (Com.Session.usertp == "0") { string tectype = "0"; //1年级主任,2科任组长,3班主任,4科任老师 SchSystem.BLL.SchGradeUserV bllgrade = new SchSystem.BLL.SchGradeUserV(); if (bllgrade.Exists(Com.Session.usertid)) { tectype += ",1"; } SchSystem.BLL.SchUserSubV bllsub = new SchSystem.BLL.SchUserSubV(); if (bllsub.Exists(Com.Session.usertid)) { tectype += ",2"; } SchSystem.BLL.SchClassUser bllclasssub = new SchSystem.BLL.SchClassUser(); if (bllclasssub.ExistsV(0, 1, Com.Session.usertid, 1)) { tectype += ",3"; } if (bllclasssub.ExistsV(0, 1, Com.Session.usertid, 0)) { tectype += ",4"; } Com.Session.usertectp = tectype; } //获取该学校的系统编辑状态 SchSystem.BLL.SchInfo schbll = new SchSystem.BLL.SchInfo(); SchSystem.Model.SchInfo schmodel = schbll.GetModel(int.Parse(Com.Session.schid)); Com.Session.appeditstat = schmodel.SonSysStat.ToString(); str = "1"; //} // else // { // str = "该账号没有相应的权限或者对应角色被屏蔽,请联系管理员进行分配处理"; // } } else { str = "该账号被屏蔽或不存在"; } return(str); }
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.SchRole rolebll = new SchSystem.BLL.SchRole(); 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]; if (dtrole.Rows.Count == 0) { //给个默认根节点 //DataRow dr = dtrole.NewRow(); //dr["id"] = "0"; //dr["pId"] = DBNull.Value; //dr["name"] = "权限组"; //dr["checked"] = "false"; //dtrole.Rows.Add(dr); } //获取该用户关联的角色 SchSystem.BLL.SchUserRoleV urolevbll = new SchSystem.BLL.SchUserRoleV(); string uroleids = urolevbll.GetIds(" UserId='" + uid + "' and stat=1 and schid=" + usermodel.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(usermodel.SchId); if (appstr != "") { appstr = " and (AppCode=1 or AppCode=2 or AppCode in (" + appstr + ")) "; } SchSystem.BLL.SchMenuInfoUserFunc funcbll = new SchSystem.BLL.SchMenuInfoUserFunc(); 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); //获取特殊权限功能树 SchSystem.BLL.SchMenuInfoUser smieBll = new SchSystem.BLL.SchMenuInfoUser(); DataTable dtsmie = smieBll.GetList("MenuId id,Pid pId,TextName name,FuncCode funcode,'false' checked", " Stat=1 " + appstr + " Order by OrderId").Tables[0]; MenuInfoExt = Newtonsoft.Json.JsonConvert.SerializeObject(dtsmie); } }