public static string uprole(string schid, string roleid, string rolename, string rolestr, string rolextstr)
{
if (!Com.Public.isVa(schid, ""))
{
return("无跨界权限;");
}
string ret = "success";
if (Com.Session.userid == null)
{
ret = "expire";
}
else
{
try
{
SchSystem.BLL.SchRoleSoure bll = new SchSystem.BLL.SchRoleSoure();
SchSystem.Model.SchRoleSoure model = new SchSystem.Model.SchRoleSoure();
model.RoleId = int.Parse(roleid);
model.RoleName = Com.Public.SqlEncStr(rolename);
model.RoleStr = rolestr;
//model.RoleExtStr = rolextstr;
model.Stat = 1;
model.LastRecTime = DateTime.Now;
model.LastRecUser = Com.SoureSession.Soureuserid;
bll.Update(model);
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
public static string getrole(string schid, string roleid)
{
if (!Com.Public.isVa(schid, ""))
{
return("无跨界权限;");
}
SchSystem.BLL.SchRoleSoure bll = new SchSystem.BLL.SchRoleSoure();
DataTable dtrole = bll.GetList("RoleId id,0 pId,RoleName name,RoleStr rolestr,RoleStrExt roleextstr", "RoleId=" + Com.Public.SqlEncStr(roleid)).Tables[0];
return(Newtonsoft.Json.JsonConvert.SerializeObject(dtrole));
}
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.SchUserRoleSoure surBll = new SchSystem.BLL.SchUserRoleSoure();
bool surBool = surBll.ExistsRoleData(schid, roleid);
if (surBool)
{
ret = "success01";
}
else
{
SchSystem.BLL.SchRoleSoure bll = new SchSystem.BLL.SchRoleSoure();
SchSystem.Model.SchRoleSoure model = new SchSystem.Model.SchRoleSoure();
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 static string addrole(string schid, string rolename, string rolestr, string roleextstr)
{
if (!Com.Public.isVa(schid, ""))
{
return("无跨界权限;");
}
string ret = "";
if (Com.Session.userid == null)
{
ret = "expire";
}
else
{
try
{
SchSystem.BLL.SchRoleSoure bll = new SchSystem.BLL.SchRoleSoure();
SchSystem.Model.SchRoleSoure model = new SchSystem.Model.SchRoleSoure();
model.RecTime = DateTime.Now;
model.RecUser = Com.Session.userid;
model.SchId = int.Parse(schid);
model.SysType = 0;
model.RoleName = Com.Public.SqlEncStr(rolename);
model.RoleStr = rolestr;
//model.RoleExtStr = roleextstr;
model.RoleStrExt = roleextstr;
model.Stat = 1;
model.LastRecTime = DateTime.Now;
model.LastRecUser = Com.Session.userid;
int id = bll.Add(model);
ret = id.ToString();
}
catch (Exception ex)
{
ret = ex.Message;
}
}
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.SchRoleSoure rolebll = new SchSystem.BLL.SchRoleSoure();
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.SchUserRoleSoureV urolevbll = new SchSystem.BLL.SchUserRoleSoureV();
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.SchMenuInfoUserFuncSoure funcbll = new SchSystem.BLL.SchMenuInfoUserFuncSoure();
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 string publicKey = "";//公钥
//需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//公钥
publicKey = Model.PublicProperty.PublicKey.Replace("\r\n", ",");
//权限组的增删改
isadd = true;
isedit = true;
isdel = true;
islook = true;
//先得到操作类型
dotype = Request.Params["dotype"].ToString();
string uid = "0"; //修改时的用户ID
string uname = ""; //修改时的用户账号
if (dotype == "a") //添加
{
schid = Request.Params["schid"].ToString();
systype = Request.Params["systype"].ToString();
if (string.IsNullOrEmpty(schid) || string.IsNullOrEmpty(systype)) //如果没有对应参数中任意一个
{
Response.Write("学校ID为空或者添加的类型为空!");
Response.End();
}
}
else if (dotype == "e")//修改,不能修改用户的类型及学校参数
{
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)
{
//给默认的屏蔽密码,管理员不能随便修改,只能重置为123456
if (!string.IsNullOrEmpty(usermodel.PassWord)) //密码不为空
{
if (usermodel.PassWord == Com.Public.StrToMD5("123456")) //初始密码
{
usermodel.PassWord = "******";
}
else//非初始密码
{
usermodel.PassWord = "******";
}
}
else//密码为空
{
usermodel.PassWord = "";
}
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();
}
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.SchRoleSoure rolebll = new SchSystem.BLL.SchRoleSoure();
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];
//获取该用户关联的角色
SchSystem.BLL.SchUserRoleSoureV urolevbll = new SchSystem.BLL.SchUserRoleSoureV();
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.SchMenuInfoUserFuncSoure funcbll = new SchSystem.BLL.SchMenuInfoUserFuncSoure();
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();
SchSystem.BLL.SchMenuInfoUserFuncSoure smieBll = new SchSystem.BLL.SchMenuInfoUserFuncSoure();
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);
}
}
}