public DataTable getUserTree()
{
sqlHelper sh = new sqlHelper();
sysLoginInCls si = public_method.getLoginInObject();
string sql = "select * from vw_tree_all "
+ " where userId in (select userId from sys_dataRole_user where roleId = " + si.dataRoleId + ")"
+ " union all select* from vw_tree_all"
+ " where id in (select distinct parentId from vw_tree_all"
+ " where userId in (select userId from sys_dataRole_user where roleId = " + si.dataRoleId + "))"
+ " union all select* from vw_tree_all"
+ " where id in (select distinct parentId from vw_tree_all"
+ " where id in (select distinct parentId from vw_tree_all"
+ " where userId in (select userId from sys_dataRole_user where roleId = " + si.dataRoleId + ")))"
+ " union all select* from vw_tree_all"
+ " where id in (select distinct parentId from vw_tree_all"
+ " where id in (select distinct parentId from vw_tree_all"
+ " where id in (select distinct parentId from vw_tree_all"
+ " where userId in (select userId from sys_dataRole_user where roleId = " + si.dataRoleId + "))))";
DataTable dt = new DataTable();
try
{
dt = sh.dbClient().SqlQueryable <object>(sql).ToDataTable();
}
catch
{
}
return(dt);
}
public DataTable getSelectItem(string tableName, int belongsId, int checkDataRole = 0)
{
sysLoginInCls si = public_method.getLoginInObject();
DataTable dt = new DataTable();
//这里执行
try
{
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
string whereSql = "";
string sql = "select * from " + tableName + " where flag=1 " + whereSql;
if (checkDataRole == 1)
{
#region
sql += " and belongsId = " + belongsId;
#endregion
}
dt = db.SqlQueryable <object>(sql).ToDataTable();
}
catch (Exception ex)
{
}
return(dt);
}
public DataTable getSelectItem2(string tableName, string fieldValue)
{
sysLoginInCls si = public_method.getLoginInObject();
DataTable dt = new DataTable();
//这里执行
try
{
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
string sql = "select * from " + tableName + " where (flag=1";
if (!string.IsNullOrEmpty(fieldValue) && fieldValue != "null")
{
sql += " and projectId= " + si.projectId + " and carId is null ) or (flag=1 and projectId= " + si.projectId + " and guanYouId=" + fieldValue + ")";
}
else
{
sql += " and projectId= " + si.projectId + " and carId is null )";
}
dt = db.SqlQueryable <object>(sql).ToDataTable();
}
catch (Exception ex)
{
}
return(dt);
}
public returnR getNowLoginObejct()
{
sysLoginInCls si = public_method.getLoginInObject();
returnR r = new returnR();
r.code = (int)sysEnum.操作成功;
r.data = si;
r.msg = "成功";
return(r);
}
protected override void Initialize(RequestContext requestContext)
{
base.Initialize(requestContext);
sysLoginInCls si = public_method.getLoginInObject();
if (si == null)
{
requestContext.HttpContext.Response.Redirect("/login/index");
}
else
{
//正常用户
}
}
public returnR checkAction()
{
returnR rr = new returnR();
sysLoginInCls si = public_method.getLoginInObject();
if (si == null)
{
rr.code = -1;//掉线了
}
else
{
rr.code = 1;//有效
}
return(rr);
}
public DataTable getDataRoleUserIdList()
{
sqlHelper sh = new sqlHelper();
sysLoginInCls si = public_method.getLoginInObject();
string sql = "select userId from sys_dataRole_user where roleId = " + si.dataRoleId;
DataTable dt = new DataTable();
try
{
dt = sh.dbClient().SqlQueryable <object>(sql).ToDataTable();
}
catch
{
}
return(dt);
}
/// <summary>
/// 日本监控web
/// </summary>
/// <returns></returns>
public ActionResult Index()
{
string userId = "0";
string userName = "";
string userRoleName = "管理员";
sysLoginInCls sl = public_method.getLoginInObject();
if (sl != null)
{
userId = sl.loginUserId.ToString();
userName = sl.userName;
}
ViewData["userId"] = userId;
ViewData["userName"] = userName;
ViewData["userRoleName"] = userRoleName;
ViewData["roleId"] = sl.roleId;
ViewData["dataRoleId"] = sl.dataRoleId;
return(View());
}
public static sysLoginInCls getLoginInObject()
{
sysLoginInCls si = null;
string ip = GetIPAddress();
for (var i = 0; i < MvcApplication.l_sysLoginInCls.Count; i++)
{
if (MvcApplication.l_sysLoginInCls[i].loginInIp == ip)
{
si = MvcApplication.l_sysLoginInCls[i];
break;
}
}
try
{
if (si == null)
{
System.Web.HttpContext.Current.Response.Redirect("/login/index");
}
} catch (Exception x) {
Console.Write(x.Message);
}
return(si);
}
public List <dtTree_List> getUserTree()
{
List <dtTree_List> l_dtTree = new List <dtTree_List>();
sqlHelper sh = new sqlHelper();
sysLoginInCls si = public_method.getLoginInObject();
string sql = "select * from vw_Bs_mySelectUserTree where 1=1";
DataTable dt_all = new DataTable();
try
{
dt_all = sh.dbClient().SqlQueryable <object>(sql).ToDataTable();
}
catch
{
}
DataTable dt = new DataTable();
if (si.loginIsAdmin == false)
{
if (si.managerFlag == "1")
{
dt = dt_all.Clone();
var myDepartId = si.dataRoleId.ToString();//这里获取一下这个先所有的信息
for (var i = 0; i < dt_all.Rows.Count; i++)
{
if (myDepartId == dt_all.Rows[i]["id"].ToString().ToLower() &&
dt_all.Rows[i]["type"].ToString() == "depart")
{
dt_all.Rows[i]["belongsId"] = "0";
dt.Rows.Add(dt_all.Rows[i].ItemArray);
break;
}
}
//递归找到所有属于这个部门的部门
for (var i = 0; i < dt_all.Rows.Count; i++)
{
if (dt_all.Rows[i]["type"].ToString() == "depart")
{
if (myDepartId == dt_all.Rows[i]["belongsId"].ToString())
{
dt.Rows.Add(dt_all.Rows[i].ItemArray);
getMyDepartSon(ref dt, dt_all.Rows[i]["id"].ToString(), dt_all);
}
}
}
//然后找到所有属于这个部门的人员
for (var i = 0; i < dt_all.Rows.Count; i++)
{
if (dt_all.Rows[i]["type"].ToString() == "user")
{
string belongsId = dt_all.Rows[i]["belongsId"].ToString();
for (var j = 0; j < dt.Rows.Count; j++)
{
if (belongsId == dt.Rows[j]["id"].ToString())
{
dt.Rows.Add(dt_all.Rows[i].ItemArray);
break;
}
}
}
}
dt.DefaultView.Sort = "type desc ";
dt = dt.DefaultView.ToTable();
}
else
{
dt = dt_all.Clone();
//只能看到他自己
var myUserId = "u" + si.loginUserId.ToString();
var myDepartId = si.dataRoleId.ToString();
for (var i = 0; i < dt_all.Rows.Count; i++)
{
if (myUserId.ToLower() == dt_all.Rows[i]["id"].ToString().ToLower() &&
dt_all.Rows[i]["type"].ToString() == "user")
{
dt.Rows.Add(dt_all.Rows[i].ItemArray);
break;
}
}
for (var i = 0; i < dt_all.Rows.Count; i++)
{
if (myDepartId == dt_all.Rows[i]["id"].ToString().ToLower() &&
dt_all.Rows[i]["type"].ToString() == "depart")
{
dt_all.Rows[i]["belongsId"] = "0";
dt.Rows.Add(dt_all.Rows[i].ItemArray);
break;
}
}
}
}
else
{
dt = dt_all.Clone();
//这是是管理员登录的
string data_role_id = si.dataRoleId.ToString();//这里获取的 登录人员的 数据权限id
sql = "select teamId from sys_dataRole_user where roleId='" + data_role_id + "'and flag=1";
DataTable dt_department = new DataTable();
try
{
dt_department = sh.dbClient().Ado.GetDataTable(sql);//这是我所有的部门权限
}
catch {
}
if (dt_department != null && dt_department.Rows.Count > 0)
{
for (var i = 0; i < dt_department.Rows.Count; i++)
{
string departId = dt_department.Rows[i]["teamId"].ToString();
getMyDepartFather(ref dt, departId, dt_all);
}
}
//dt = dt_all;
//然后找到所有属于这个部门的人员
for (var i = 0; i < dt_all.Rows.Count; i++)
{
if (dt_all.Rows[i]["type"].ToString() == "user")
{
string belongsId = dt_all.Rows[i]["belongsId"].ToString();
for (var j = 0; j < dt_department.Rows.Count; j++)
{
if (belongsId == dt_department.Rows[j]["teamId"].ToString())
{
dt.Rows.Add(dt_all.Rows[i].ItemArray);
break;
}
}
}
}
dt.DefaultView.Sort = "type desc ";
dt = dt.DefaultView.ToTable();
}
if (dt != null && dt.Rows.Count > 0)
{
for (var i = 0; i < dt.Rows.Count; i++)
{
string id = dt.Rows[i]["id"].ToString();
dtTree_List dtTree = new dtTree_List();
dtTree.id = id;
dtTree.type = dt.Rows[i]["type"].ToString();
dtTree.mylevel = dt.Rows[i]["mylevel"].ToString();
if (id.Length > 1)
{
if (id.Substring(0, 1).ToLower() == "u")
{
dtTree.iconClass = "dtree-icon-yonghu";
}
else
{
dtTree.iconClass = "dtree-icon-fuxuankuang-banxuan";
}
}
dtTree.title = dt.Rows[i]["name"].ToString();
dtTree.checkArr = "0";
dtTree.parentId = dt.Rows[i]["belongsId"].ToString();
l_dtTree.Add(dtTree);
}
}
return(l_dtTree);
}
public returnR resetPsw(JObject userObj)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
if (userObj == null)
{
r.code = (int)sysEnum.参数必填;
return(r);
}
//这里执行
try
{
#region 判断用户
string userId = userObj["userId"].ToString();
if (string.IsNullOrEmpty(userId))
{
r.code = (int)sysEnum.参数必填;
r.msg = "userId必填";
return(r);
}
string pwd = userObj["psw"].ToString();
if (string.IsNullOrEmpty(pwd))
{
r.code = (int)sysEnum.参数必填;
r.msg = "用户密码必填";
return(r);
}
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
#endregion
sysLoginInCls si = public_method.getLoginInObject();
pwd = DES_En_De.UserMd5(pwd);//这里进行加密
int iReturn = db.Updateable <sys_user>()
.SetColumns(it => new sys_user()
{
pwd = pwd
,
updateUserId = si.loginUserId
,
updateDate = DateTime.Now
})
.Where(it => it.userId.ToString() == userId).ExecuteCommand();
if (iReturn > 0)
{
r.code = (int)sysEnum.操作成功;
r.msg = "重置密码成功";
#region //写日志
sys_log sys_log = new sys_log();
sys_log.logType = "重置";
sys_log.logText = "重置用户id[" + userId + "]密码成功";
sys_log.createUserId = si.loginUserId;
public_method.saveLog(sys_log);
#endregion
return(r);
}
else
{
r.code = (int)sysEnum.执行数据库失败;
r.msg = "重置密码失败";
return(r);
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = ex.Message;
}
return(r);
}
public returnR login(JObject passJson)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
try {
string userName = passJson["userName"].ToString();
if (string.IsNullOrEmpty(userName))
{
r.code = (int)sysEnum.参数必填;
return(r);
}
string psw = passJson["psw"].ToString();
if (string.IsNullOrEmpty(psw))
{
r.code = (int)sysEnum.参数必填;
return(r);
}
psw = DES_En_De.UserMd5(psw);
string isAdmin = passJson["isAdmin"].ToString();
if (string.IsNullOrEmpty(isAdmin))
{
isAdmin = "false";
}
sqlHelper sh = new sqlHelper();
if (isAdmin.ToLower() == "true")
{
#region
DataTable loginTable = sh.dbClient().Queryable <sys_user>()
.Where(it => it.userName == userName && it.pwd == psw).ToDataTable();
if (loginTable == null || loginTable.Rows.Count <= 0)
{
r.code = (int)sysEnum.数据不存在;
r.msg = "账号或密码错误";
return(r);
}
//这里是成成功的
string ip = public_method.GetIPAddress();
sysLoginInCls si = new sysLoginInCls();
si.loginInIp = ip;
si.loginUserId = int.Parse(loginTable.Rows[0]["userId"].ToString());
si.userName = loginTable.Rows[0]["userName"].ToString();
si.roleId = loginTable.Rows[0]["roleId"].ToString();
si.dataRoleId = loginTable.Rows[0]["dataRoleId"].ToString();
si.loginIsAdmin = true;
si.mySubordinateList = "";
MvcApplication.setLoginInCls(si);
r.code = (int)sysEnum.操作成功;
r.data = si;
r.msg = "登录成功！";
#endregion
}
else
{
DataTable loginTable = sh.dbClient().Queryable <tb_Machine_user>()
.Where(it => it.account == userName && it.psw == psw).ToDataTable();
if (loginTable == null || loginTable.Rows.Count <= 0)
{
r.code = (int)sysEnum.数据不存在;
r.msg = "账号或密码错误";
return(r);
}
//这里是成成功的
string ip = public_method.GetIPAddress();
sysLoginInCls si = new sysLoginInCls();
si.loginInIp = ip;
si.loginIsAdmin = false;
si.loginUserId = int.Parse(loginTable.Rows[0]["userId"].ToString());
si.userName = loginTable.Rows[0]["userName"].ToString();
si.roleId = "15";
si.dataRoleId = loginTable.Rows[0]["belongsId"].ToString();;
si.managerFlag = loginTable.Rows[0]["managerFlag"].ToString();
si.mySubordinateList = "";
MvcApplication.setLoginInCls(si);
r.code = (int)sysEnum.操作成功;
r.data = si;
r.msg = "登录成功！";
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = "发生异常" + ex.Message;
return(r);
}
return(r);
}
public returnR userDel(JObject passJson)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
if (passJson == null)
{
r.code = (int)sysEnum.参数必填;
return(r);
}
//这里执行
try
{
sysLoginInCls si = public_method.getLoginInObject();
string userIdList = passJson["userIdList"].ToString();
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
string[] useridArray = userIdList.Split(',');
List <string> list = new List <string>();
for (int i = 0; i < useridArray.Length; i++)
{
list.Add(useridArray[i]);
}
int iReturn = db.Updateable <sys_user>()
.SetColumns(it => new sys_user()
{
flag = (int)sysEnum.数据被删除
, updateUserId = si.loginUserId
, updateDate = DateTime.Now
})
.Where(it => list.Contains(it.userId.ToString())).ExecuteCommand();
if (iReturn > 0)
{
r.code = (int)sysEnum.操作成功;
r.msg = "成功删除用户";
#region //写日志
sys_log sys_log = new sys_log();
sys_log.logType = "删除";
sys_log.logText = "删除用户id[" + userIdList + "]";
sys_log.createUserId = si.loginUserId;
public_method.saveLog(sys_log);
#endregion
return(r);
}
else
{
r.code = (int)sysEnum.执行数据库失败;
r.msg = "删除用户失败";
return(r);
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = ex.Message;
}
return(r);
}
public returnR userUpdate(JObject userObj)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
if (userObj == null)
{
r.code = (int)sysEnum.参数必填;
return(r);
}
//这里执行
try
{
#region 判断用户
string userId = userObj["userId"].ToString();
if (string.IsNullOrEmpty(userId))
{
r.code = (int)sysEnum.参数必填;
r.msg = "userId必填";
return(r);
}
string username = userObj["userName"].ToString();
if (string.IsNullOrEmpty(username))
{
r.code = (int)sysEnum.参数必填;
r.msg = "用户名称必填";
return(r);
}
sqlHelper sh = new sqlHelper();
ISqlSugarClient db = sh.dbClient();
var dataList = db.Queryable <sys_user>()
.Where(it => it.userName == username && it.flag == 1 && it.userId.ToString() != userId).ToList();
if (dataList.Count > 0)
{
r.code = (int)sysEnum.数据库中已经存在;
r.msg = "数据库中已存在[" + username + "]";
return(r);
}
#endregion
sysLoginInCls si = public_method.getLoginInObject();
string realName = userObj["realName"].ToString();
sys_user sys_user = new sys_user();
sys_user.userId = int.Parse(userId);
sys_user.userName = username;
sys_user.realName = realName;
sys_user.roleId = int.Parse(userObj["roleId"].ToString());
sys_user.dataRoleId = int.Parse(userObj["dataRoleId"].ToString());
sys_user.phone = userObj["phone"].ToString();
sys_user.email = userObj["email"].ToString();
sys_user.remarks = userObj["remarks"].ToString();
sys_user.updateUserId = si.loginUserId; //更新人
sys_user.updateDate = System.DateTime.Now; //更新时间
sys_user.flag = 1; //默认开启
//这里转换一下
int iReturn = db.Updateable(sys_user)
.IgnoreColumns(it => new { it.createDate, it.createUserId, it.pwd }).ExecuteCommand();
if (iReturn > 0)
{
r.code = (int)sysEnum.操作成功;
r.msg = "更新[" + username + "]成功";
#region //写日志
sys_log sys_log = new sys_log();
sys_log.logType = "更新";
sys_log.logText = Newtonsoft.Json.JsonConvert.SerializeObject(sys_user);
sys_log.createUserId = si.loginUserId;
public_method.saveLog(sys_log);
#endregion
return(r);
}
else
{
r.code = (int)sysEnum.执行数据库失败;
r.msg = "更新[" + username + "]失败";
return(r);
}
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = ex.Message;
}
return(r);
}
public returnR login_employee(JObject passJson)
{
returnR r = new returnR();
r.code = (int)sysEnum.还没有执行;
try
{
string account = passJson["account"].ToString();
if (string.IsNullOrEmpty(account))
{
r.code = (int)sysEnum.参数必填;
return(r);
}
string psw = passJson["psw"].ToString();
if (string.IsNullOrEmpty(psw))
{
r.code = (int)sysEnum.参数必填;
return(r);
}
psw = DES_En_De.UserMd5(psw);
sqlHelper sh = new sqlHelper();
DataTable loginTable = sh.dbClient().Queryable <tb_Machine_user>()
.Where(it => it.account == account && it.psw == psw).ToDataTable();
if (loginTable == null || loginTable.Rows.Count <= 0)
{
r.code = (int)sysEnum.数据不存在;
r.msg = "账号或密码错误";
return(r);
}
//这里是成成功的
string ip = public_method.GetIPAddress();
sysLoginInCls si = new sysLoginInCls();
si.loginInIp = ip;
si.loginUserId = int.Parse(loginTable.Rows[0]["userId"].ToString());
si.userName = loginTable.Rows[0]["userName"].ToString();
si.belongsId = loginTable.Rows[0]["belongsId"].ToString();
si.managerFlag = loginTable.Rows[0]["managerFlag"].ToString();
if (si.managerFlag == "1")
{
DataTable subList = getMySubordinateList(si.belongsId);//递归求得所有下级的userId
string mySubordinateList = "";
for (int i = 0; i < subList.Rows.Count; i++)
{
if (i > 0)
{
mySubordinateList += ",";
}
mySubordinateList += subList.Rows[i][0].ToString();
}
si.mySubordinateList = mySubordinateList;
}
else
{
si.mySubordinateList = si.loginUserId.ToString();
}
MvcApplication.setLoginInCls(si);
r.code = (int)sysEnum.操作成功;
r.data = si;
r.msg = "登录成功！";
}
catch (Exception ex)
{
r.code = (int)sysEnum.发生异常;
r.msg = "发生异常" + ex.Message;
return(r);
}
return(r);
}
