public static string usersave(string dotype, string schid, string systype, string userid, string usercode, string usertname, string usertel, string userpst, string usertitle, string usermobile, string username, string userpw, string usersex, string userstat, string usersub, string userdpts, string userroles)
{
//解密 RSA
RSACryptoService rsa = new RSACryptoService(PublicProperty.PrivateKey, PublicProperty.PublicKey);
if (userpw != "")
{
userpw = Com.Public.SqlEncStr(rsa.Decrypt(userpw));
}
username = Com.Public.SqlEncStr(username);
string ret = "";
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(Com.SoureSession.jsid, Com.SoureSession.jstoken);
if (rsp.code == "ERROR_TOKEN")
{
ret = "expire";
}
else
{
try
{
if (string.IsNullOrEmpty(schid) || schid == "0")
{
ret += "非法的学校!";
}
SchSystem.BLL.SchUserInfo userbll = new SchSystem.BLL.SchUserInfo();
SchSystem.Model.SchUserInfo usermodel = new SchSystem.Model.SchUserInfo();
if (!Com.Public.isVa(schid, ""))
{
ret += "无跨界权限;";
}
//判断编号及账号是否有重复,生成密码加密
if (dotype == "e")
{
if (username != "")
{
if (userbll.ExistsUserName(int.Parse(userid), username))
{
ret += "账号重复!";
}
else if (!userbll.ExistsUserName(0, username))
{
userbll.UpdateUserName(username, int.Parse(userid));
}
}
}
if (dotype == "a")
{
if (username != "")
{
StringBuilder sbExists = new StringBuilder();
string utname = "";
if (userbll.ExistsUserName(0, username))
{
SchSystem.BLL.SchUserDeptV bllusdpt = new SchSystem.BLL.SchUserDeptV();
DataTable dt = bllusdpt.GetList("DepartName,UserTname", "UserName='******'").Tables[0];
DataRow[] dr = dt.Select();
foreach (DataRow item in dr)
{
sbExists.Append(item["DepartName"].ToString() + "、");
utname = item["UserTname"].ToString();
}
//ret += "账号重复!";
ret += sbExists.ToString().Substring(0, sbExists.ToString().Length - 1);
ret += "," + utname;
}
}
}
if (ret == "")
{
usermodel.LastRecTime = DateTime.Now;
usermodel.LastRecUser = Com.SoureSession.Soureuserid;
usermodel.Mobile = usermobile;
usermodel.Postion = userpst;
usermodel.Sex = int.Parse(usersex);
if (!string.IsNullOrEmpty(userstat))
{
usermodel.AccStat = int.Parse(userstat);
}
else
{
usermodel.AccStat = 2;
}
usermodel.SubCode = usersub;
usermodel.SysType = int.Parse(systype);
usermodel.Telno = usertel;
usermodel.Title = usertitle;
usermodel.UserNo = usercode;
usermodel.UserTname = usertname;
if (dotype == "e")
{
if (!string.IsNullOrEmpty(userpw) && !string.IsNullOrEmpty(username))
{
userpw = Com.Public.StrToMD5(userpw);
if (userpw == Com.Public.StrToMD5("123456"))//如果重置密码时保存
{
userbll.UpdatePw(int.Parse(userid), userpw);
}
}
usermodel.UserId = int.Parse(userid);
userbll.UpdateUser(usermodel);
}
if (dotype == "a")
{
//必须有账号和密码
if (!string.IsNullOrEmpty(userpw) && !string.IsNullOrEmpty(username))
{
usermodel.PassWord = Com.Public.StrToMD5("123456"); //SchManagerInfoSystem.Common.DESEncrypt.Encrypt(userpw) ;添加时均为123456密码
}
usermodel.RecTime = DateTime.Now;
usermodel.RecUser = Com.SoureSession.Soureuserid;
usermodel.SchId = int.Parse(schid);
usermodel.UserName = username;
userid = userbll.Add(usermodel).ToString();
}
//添加或更新关联部门
SchSystem.BLL.SchUserDept userdeptbll = new SchSystem.BLL.SchUserDept();
if (userdpts == null)
{
userdpts = "0";
}
userdeptbll.DoUserDept(userid, Com.SoureSession.Soureuserid, schid, userdpts);
//添加或更新关联角色
//SchSystem.BLL.SchUserRole userrolebll = new SchSystem.BLL.SchUserRole();
//if (userroles == null) userroles = "0";
//userrolebll.DoUserRole(userid, Com.Session.userid, schid, userroles);
ret = "success";
}
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
public string publicKey = "";//公钥
//需要根据不同情况建立或修改的不同学校用户和不同类型的用户,本学校用户唯一,不需要全系统唯一
protected void Page_Load(object sender, EventArgs e)
{
//if (true)//如果没对应权限,及判断用户类型是否跨界,主要防止非法篡改数据出现
//{
// Response.Write("无对应权限");
// Response.End();
//}
if (!IsPostBack)
{
//公钥
publicKey = 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") //添加
{
//根据登录人员的身份,需要得到不同的参数
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")//修改,不能修改用户的类型及学校参数
{
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();
}
//判断跨界操作的可能性
/*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);
//获取特殊权限功能树
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);
}
}
}
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);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Com.Session.systype == "1" || Com.Session.systype == "2")//超级管理员和学校管理员
{
islook = true;
if (Com.Session.appeditstat == "0" && Com.Session.systype == "1")
{
isadd = false;
isedit = false;
isdel = false;
}
else
{
isadd = true;
isedit = true;
isdel = true;
}
}
else//普通老师
{
isadd = false;
isedit = false;
isdel = false;
islook = true;//学科/年级/班级任课权限
}
//isGradeClassAuth = Com.Public.IsUserVal(Com.Session.userrolestr, 2) ? true : false;//学科/年级/班级任课权限
//不是超管获取本学校的
if (Com.Session.systype != "2")
{
schid = Com.Session.schid;
}
else//超管还要加省市区学校下拉,后面需要更改
{
//第一次加载,获取省市区,获取第一个省份下的所有学校
StringBuilder sbarea = new StringBuilder();
//获取省份
sbarea.Append("省:<select id=\"aprov\">");
string sareacode = "";
sbarea.Append(Com.Public.GetDrpArea("0", "", ref sareacode, false));
sbarea.Append("</select>");
//获取城市
sbarea.Append("市:<select id=\"acity\">");
string sareacitycode = "";
sbarea.Append(Com.Public.GetDrpArea("1", sareacode, ref sareacitycode, false));
sbarea.Append("</select>");
//获取区县
sbarea.Append("区:<select id=\"acoty\">");
string sareacotycode = "";
sbarea.Append(Com.Public.GetDrpArea("2", sareacitycode, ref sareacotycode, false));
cotycode = sareacotycode;
sbarea.Append("</select>");
sbarea.Append("学校:<select id=\"asch\">");
string sareaschid = "";
sbarea.Append(Com.Public.GetDrpArea("3", sareacotycode, ref sareaschid, false));
if (sareaschid != "")
{
schid = sareaschid;
}
sbarea.Append("</select>");
areastr = sbarea.ToString();
systype = Com.Session.systype;
}
//当前学校年级:IsFinish状态，1代表已毕业；0代表未毕业
// SchSystem.BLL.SchGradeInfo sgiBll = new SchSystem.BLL.SchGradeInfo();
//DataSet dsSchGrade = sgiBll.GetList("IsFinish=0 and SchId=" + schid);
//年级
SchSystem.BLL.SchGradeInfo sgiBLL = new SchSystem.BLL.SchGradeInfo();
DataTable dtSchGrade = sgiBLL.GetList(" IsFinish=0 and SchId='" + schid + "' order by GradeCode").Tables[0];//得到年级数据列表,并且是为非毕业的年级
//年级领导
SchSystem.BLL.SchGradeUsers sguBLL = new SchSystem.BLL.SchGradeUsers();
dtSchGrade.Columns.Add("GradeBoss");
if (dtSchGrade.Rows.Count > 0)
{
for (int i = 0; i < dtSchGrade.Rows.Count; i++)
{
dtSchGrade.Rows[i]["GradeBoss"] = sguBLL.GetNames("GradeId=" + dtSchGrade.Rows[i]["GradeId"].ToString());
}
}
grades = Newtonsoft.Json.JsonConvert.SerializeObject(dtSchGrade);
//当前学校所开设的科目
SchSystem.BLL.SchSub schsubBll = new SchSystem.BLL.SchSub();
DataSet dsSchSub = schsubBll.GetList("Stat=1 and SchId='" + schid + "'");
//DataSet dsSchSub = schsubBll.GetSubList("SchSub.Stat=1 and SchId='" + Com.Public.SqlEncStr(schid) + "'");
subs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSchSub);
//获取科目教师
SchSystem.BLL.SchSubLeader scuBll = new SchSystem.BLL.SchSubLeader();
DataSet dssubUser = scuBll.GetListTecSub("*", "schid='" + Com.Public.SqlEncStr(schid) + "' and Stat=1");
subUser = Newtonsoft.Json.JsonConvert.SerializeObject(dssubUser);
//subUser
//当前学校的教师
SchSystem.BLL.SchUserInfo suiBll = new SchSystem.BLL.SchUserInfo();
DataSet dsSUI = suiBll.GetList("*", "Stat=1 and SchId='" + Com.Public.SqlEncStr(schid) + "'");
tecs = Newtonsoft.Json.JsonConvert.SerializeObject(dsSUI);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string Action = context.Request.Form["Action"];
if (Action == "null")
{
context.Response.Write(PublicProperty.PublicKey);
}
else if (Action == "Login")//登录
{
string str = "";
//解密 RSA
RSACryptoService rsa = new RSACryptoService(PublicProperty.PrivateKey, PublicProperty.PublicKey);
try
{
string usernameEncode = context.Request.Form["UserName"];
string pwdEncode = context.Request.Form["PassWord"];
string txtCode = context.Request.Form["TxtCode"];//IsCookies
//string IsCookies = context.Request.Form["IsCookies"];
string txtcode = rsa.Decrypt(txtCode);
//string iscookies = rsa.Decrypt(IsCookies);
//bool iscook =false;
//if (iscookies == "1") iscook = true;
if (recode(txtcode, context))
{
string uname = Com.Public.SqlEncStr(rsa.Decrypt(usernameEncode));
if (!string.IsNullOrEmpty(uname))
{
string pwd = Com.Public.SqlEncStr(rsa.Decrypt(pwdEncode));
Com.Session.userpw = pwd;
Com.Session.usertp = "0";
string pwdmd5 = Com.Public.StrToMD5(pwd);
//查询所登录的用户名和密码是否一致。如果一致，则返回true；否则，返回false。
SchSystem.BLL.SchUserInfo userbll = new SchSystem.BLL.SchUserInfo();
bool result = userbll.Exists("UserName='******' and PassWord='******' and Stat=1 and AccStat=1 and schid=" + Com.Public.getKey("adminschid"));// and SysType=2
if (result == true)
{
//用户登录处理函数
str = Com.Public.UserLoginDo(uname, false, Com.Public.getKey("appschid"));
if (str == "1" && pwd == "123456")
{
str = "2";
}
}
else
{
str = "3";//账号或密码错误,或者被停用，请联系管理员
}
}
else
{
str = "4";//用户名不能为空
}
}
else
{
str = "5";//验证码错误
}
}
catch (Exception ex)
{
str = ex.Message;
}
context.Response.Write(str);
}
else if (Action == "out")//退出
{
/*PublicMethod.Clear();*/
context.Session.Clear();
context.Session.Abandon();
context.Response.Clear();
//清除cookies
Com.CookieHelper.ClearCookie("uname");
context.Response.Write("out");
}
}
public static string udel(string schid, string id)
{
if (!Com.Public.isVa(schid, ""))
{
return("无跨界权限");
}
string ret = "";
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(Com.SoureSession.jsid, Com.SoureSession.jstoken);
if (rsp.code == "ERROR_TOKEN")
{
ret = "expire";
}
else
{
try
{
SchSystem.BLL.SchSubLeader sslBll = new SchSystem.BLL.SchSubLeader();
bool sslBool = sslBll.ExistsClassSubLeader(schid, id);
if (sslBool)
{
ret = "success01";
}
else
{
SchSystem.BLL.SchGradeUsers sguBll = new SchSystem.BLL.SchGradeUsers();
bool sguBool = sguBll.ExistsGradeUser(schid, id);
if (sguBool)
{
ret = "success02";
}
else
{
SchSystem.BLL.SchClassUser scuBll = new SchSystem.BLL.SchClassUser();
bool scuBooll = scuBll.ExistsClassUser(schid, id);
if (scuBooll)
{
ret = "success03";
}
else
{
SchSystem.BLL.SchUserInfo bll = new SchSystem.BLL.SchUserInfo();
SchSystem.Model.SchUserInfo model = new SchSystem.Model.SchUserInfo();
model.UserId = int.Parse(id);
model.Stat = 2;
model.LastRecTime = DateTime.Now;
model.LastRecUser = Com.SoureSession.Soureuserid;
if (bll.UpdateStat(model))
{
ret = "success";
}
else
{
ret = "操作失败";
}
}
}
}
}
catch (Exception ex)
{
ret = ex.Message;
}
}
return(ret);
}
public static string page(string PageIndex, string PageSize, string txtname, string dptid, string ustat, string schid, string schsubs, string childrenids)
{
string ret = "";
Com.DataPack.DataRsp <Com.DataPack.UserInfo> rsp = Com.Public.UserFuncSoure(Com.SoureSession.jsid, Com.SoureSession.jstoken);
if (rsp.code == "ERROR_TOKEN")
{
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.SoureSession.Souresystype != "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("*", 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);
}
