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);
}
}
