/// <summary> /// 获取用户权限 /// </summary> /// <param name="userId"></param> /// <param name="url"></param> /// <returns></returns> public IList <permModel> GetPermission(string userId, string url) { DataTable dt = _rightRep.GetPermission(userId, url); IList <permModel> list = ConverHelper.ToList <permModel>(dt); return(list); }
public IList <SysMenuOptRightModel> GetRightByMenuIdAndRoleId(string moduleId, string roleId) { DataTable dt = _rightRep.GetRightByMenuIdAndRoleId(moduleId, roleId); IList <SysMenuOptRightModel> list = ConverHelper.ToList <SysMenuOptRightModel>(dt); return(list); }
public SysRoleModel GetById(string roleId) { DataTable dt = _roleRep.GetById(roleId); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); return(list[0]); }
/// <summary> /// 获取部门列表 /// </summary> /// <param name="parent_code"></param> /// <returns></returns> public IList <SysDeptModel> GetList(string parent_code) { DataTable dt = _deptRep.GetList(parent_code); IList <SysDeptModel> list = ConverHelper.ToList <SysDeptModel>(dt); return(list); }
public IList <SysRoleModel> GetList(GridPager pager, string roleName, string desc) { DataTable dt = _roleRep.GetList(pager, roleName, desc); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); return(list); }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="pager"></param> /// <param name="userId"></param> /// <param name="userName"></param> /// <param name="roleId"></param> /// <returns></returns> public IList <SysUserModel> GetList(GridPager pager, string userId, string userName, string roleId) { DataTable dt = _userRep.GetList(pager, userId, userName, roleId); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); return(list); }
public IList <SysUserModel> GetByDeptCode(GridPager pager, string dept_code) { DataTable dt = _userRep.GetByDeptCode(pager, dept_code); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); return(list); }
public IList <SysRoleModel> GetRoleYesUser(string userId) { DataTable dt = _roleRep.GetRoleYesUser(userId); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); return(list); }
/// <summary> /// 获取当前用户信息 /// </summary> /// <returns></returns> public JsonMessage GetUser() { JsonMessage jsonMsg = new JsonMessage(); try { DataTable dt = _userRep.GetById(UserID); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count > 0) { jsonMsg = ServiceResult.Message(1, "获取成功", list[0]); } else { jsonMsg = ServiceResult.Message(0, "获取失败,用户不存在,请确认", list[0]); } } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); } return(jsonMsg); }
public IList <SysUserModel> GetUserYesRole(GridPager pager, string roleId, string user) { DataTable dt = _userRep.GetUserYesRole(pager, roleId, user); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); return(list); }
/// <summary> /// 获取菜单列表 /// </summary> /// <param name="parentId"></param> /// <returns></returns> public IList <SysMenuModel> GetParentList(string parentId) { DataTable dt = _menuRep.GetParentList(parentId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); return(list); }
/// <summary> /// 根据角色获取菜单列表 /// </summary> /// <param name="roleId"></param> /// <param name="parentId"></param> /// <returns></returns> public IList <SysMenuModel> GetListByRoleId(string roleId, string parentId) { DataTable dt = _menuRep.GetListByRoleId(roleId, parentId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); return(list); }
/// <summary> /// 获取移动端用户菜单列表 WebApi用 /// </summary> /// <returns></returns> public JsonMessage GetMobileMenuList(string user_id) { JsonMessage jsonMsg = new JsonMessage(); int result = 1; List <MenuTreeModel> toSource = new List <MenuTreeModel>(); try { DataTable dt = _homeRep.GetMobileMenuByUserId(user_id); //获取当前用户所有权限 List <MenuTreeModel> list_fo = ConverHelper.ToList <MenuTreeModel>(dt).ToList(); //转换成List形式 toSource = new List <MenuTreeModel>(); var list = list_fo.FindAll(p => p.parent_id == "1"); //获取根节点数据 if (list.Count > 0) { foreach (var item in list) { GetMenuTreeJson(item, item.id, list_fo); //调用递归 toSource.Add(item); //添加到集合中 } } jsonMsg = ServiceResult.Message(1, "菜单获取成功", toSource); } catch (Exception ex) { jsonMsg = ServiceResult.Message(0, "系统异常,菜单列表加载失败", toSource); WriteSystemException(ex, this.GetType(), OPT_MODEL, "左侧菜单列表加载失败,请刷新尝试"); } return(jsonMsg); }
public IList <SysMenuModel> GetMenuByUserId(string userId, string parentId) { DataTable dt = _homeRep.GetMenuByUserId(userId, parentId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); return(list); }
/// <summary> /// 获取操作码列表 /// </summary> /// <param name="menuId"></param> /// <returns></returns> public IList <SysMenuOptModel> GetOpListByMenuId(string menuId) { DataTable dt = _menuOpApp.GetOptListByMenuId(menuId); IList <SysMenuOptModel> list = ConverHelper.ToList <SysMenuOptModel>(dt); return(list); }
public IList <SysExceptionModel> GetList(GridPager pager, string userName, string sDate, string eDate) { DataTable dt = _exceptionRep.GetList(pager, userName, sDate, eDate); IList <SysExceptionModel> list = ConverHelper.ToList <SysExceptionModel>(dt); return(list); }
/// <summary> /// 列印用户二维码标签 /// </summary> /// <param name="user_code">用户账号</param> /// <param name="is_qr">是否QR(true 是二维码,false是一维码)</param> /// <returns></returns> public JsonMessage PrinterUserQR(string user_code, bool is_qr) { string tmpUser = user_code.Replace(",", "','"); DataTable dt = _userRep.GetUserByIds(tmpUser); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); string nowDate = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); string img = "<img style='width: 342px;' src='/route/common/BarQRImg/GetBarCodeImg?text="; string tbl = ""; tbl = "<table style='width:18cm' border='1' cellspacing='10'><tr height='120px'>"; if (is_qr == true) { img = "<img style='width: 100px;' src='/route/common/BarQRImg/GetQrCodeImg?size=3&text="; } for (int i = 0; i < list.Count; i++) { if (i % 3 == 0 && i != 0) { if (is_qr == true) { if (i % 18 == 0) { tbl += "</tr><tr height='140px' style='page-break-before:always;' >"; } else { tbl += "</tr><tr height='140px' >"; } } else { if (i % 30 == 0) { tbl += "</tr><tr height='140px' style='page-break-before:always;' >"; } else { tbl += "</tr><tr height='140px' >"; } } } tbl += "<td style='text-align: center; width: 5.5cm; font-size: 16px;'>" + list[i].USER_CODE + "<br/>" + list[i].USER_NAME + "<br/>"; tbl += img + list[i].QR_CODE + "' /> " + "<br/>" + nowDate + "</td>"; if (i == list.Count - 1 && i % 3 != 0) { tbl += "</tr>"; } } tbl += "</table>"; JsonMessage jsonMsg = ServiceResult.Message(1, "", tbl); return(jsonMsg); }
public SysLogModel GetById(string id) { DataTable dt = _logRep.GetById(id); IList <SysLogModel> list = ConverHelper.ToList <SysLogModel>(dt); if (list.Count > 0) { return(list[0]); } return(null); }
/// <summary> /// 获取用户信息(or) /// </summary> /// <param name="user_code">工号</param> /// <param name="user_name">姓名</param> /// <returns></returns> public SysUserModel GetUserByIdOrName(string user_code, string user_name) { DataTable dt = _userRep.GetUserByIdOrName(user_code, user_name); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count > 0) { return(list[0]); } return(new SysUserModel()); }
/// <summary> /// 获取菜单明细 /// </summary> /// <param name="menuId"></param> /// <returns></returns> public SysMenuModel GetById(string menuId) { DataTable dt = _menuRep.GetById(menuId); IList <SysMenuModel> list = ConverHelper.ToList <SysMenuModel>(dt); if (list.Count > 0) { return(list[0]); } return(null); }
/// <summary> /// 获取用户信息 /// </summary> /// <param name="userId">用户ID</param> /// <returns></returns> public SysUserModel GetById(string userId) { DataTable dt = _userRep.GetById(userId); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count > 0) { return(list[0]); } return(null); }
/// <summary> /// 获取app最新版本号 /// </summary> /// <returns></returns> public AppVersionModel GetNewAppVersion() { DataTable dt = _appRep.GetNewAppVersion(); if (ValidateHelper.IsDataTableNotData(dt)) { return(new AppVersionModel()); } IList <AppVersionModel> list = ConverHelper.ToList <AppVersionModel>(dt); return(list[0]); }
public IList <SysLogModel> GetList(GridPager pager, string msg, string res, string type, string module, string userName, string sDate, string eDate) { SysLogModel model = new SysLogModel(); model.LOG_MSG = msg; model.LOG_RESULT = res; model.LOG_TYPE = type; model.LOG_MODULE = module; DataTable dt = _logRep.GetList(pager, model, userName, sDate, eDate); IList <SysLogModel> list = ConverHelper.ToList <SysLogModel>(dt); return(list); }
public IList <SysRoleModel> GetListDistinctName() { DataTable dt = _roleRep.GetListDistinctName(); IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt); if (list.Count > 0) { SysRoleModel model = new SysRoleModel(); model.ROLE_ID = ""; model.ROLE_NAME = "--ALL--"; list.Insert(0, model); } return(list); }
public IList <SysLogModel> GetLogType(string field) { DataTable dt = _logRep.GetLogType(field); IList <SysLogModel> list = ConverHelper.ToList <SysLogModel>(dt); if (list.Count > 0) { SysLogModel model = new SysLogModel(); model.LOG_ID = ""; model.LOG_TYPE = "--ALL--"; list.Insert(0, model); } return(list); }
/// <summary> /// 获取菜单列表 /// </summary> /// <returns></returns> public JsonMessage GetMenuList() { JsonMessage jsonMsg = new JsonMessage(); int result = 1; List <MenuTreeModel> toSource = new List <MenuTreeModel>(); //List<MenuTreeModel> toSource = (List<MenuTreeModel>)CacheHelper.GetCache("MenuTreeJson");//获取缓存中的数据 //if (toSource == null) //{ try { DataTable dt = _homeRep.GetMenuByPersonId(UserID); //获取当前用户所有权限 List <MenuTreeModel> list_fo = ConverHelper.ToList <MenuTreeModel>(dt).ToList(); //转换成List形式 toSource = new List <MenuTreeModel>(); var list = list_fo.FindAll(p => p.parent_id == "0"); //获取根节点数据 if (list.Count > 0) { foreach (var item in list) { GetMenuTreeJson(item, item.id, list_fo); //调用递归 toSource.Add(item); //添加到集合中 } } jsonMsg = ServiceResult.Message(1, "菜单获取成功", toSource); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, "系统异常,菜单列表加载失败", toSource); WriteSystemException(ex, this.GetType(), OPT_MODEL, "左侧菜单列表加载失败,请刷新尝试"); } return(jsonMsg); }
/// <summary> /// 用户登录 /// </summary> /// <param name="model">返回用户信息</param> /// <param name="user_id">登录名</param> /// <param name="pwd">密码</param> /// <returns></returns> public JsonMessage Login(string user_id, string pwd, string qr_code) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { if (ValidateHelper.IsNullOrEmpty(user_id) && ValidateHelper.IsNullOrEmpty(qr_code)) { throw new CustomException(0, "用户名和二维码不能同时为空"); } if (ValidateHelper.IsNullOrEmpty(pwd) && ValidateHelper.IsNullOrEmpty(qr_code)) { throw new CustomException(0, "密码和二维码不能同时为空"); } DataTable dt; if (ValidateHelper.IsNullOrEmpty(qr_code)) { dt = _userRep.Login(user_id, pwd); } else { dt = _userRep.Login(qr_code); } IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count < 1) { if (ValidateHelper.IsNullOrEmpty(qr_code)) { throw new CustomException(2, "用户名或密码错误");//用户名或密码错误 } else { throw new CustomException(2, "二维码不正确");//二维码不正确 } } if (!ConverHelper.ToBool(list[0].IS_ABLED)) { throw new CustomException(3, "账号已被禁用,请联系系统管理员");//账号是否被禁用 } jsonMsg = ServiceResult.Message(1, "登录成功", list[0]); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); } //写入log SysLogLoginModel log = new SysLogLoginModel(); log.LOGIN_ID = GuidHelper.GenerateComb().ToString(); log.USER_CODE = user_id; log.USER_PWD = MD5Cryption.MD5(pwd); log.USER_PWD_LAWS = ValidateHelper.IsNullOrEmpty(user_id) ? qr_code : pwd; log.LOGIN_IP = NetHelper.GetUserIp; log.LOGIN_RESULT = jsonMsg.type == 1 ? "SUCCESS" : "FAIL"; log.LOGIN_MSG = jsonMsg.message; _loglRep.Insert(log); return(jsonMsg); }
/// <summary> /// 用户登录 /// </summary> /// <param name="model">返回用户信息</param> /// <param name="user_id">登录名</param> /// <param name="pwd">密码</param> /// <returns></returns> public JsonMessage Login(ref AccountModel model, string user_id, string pwd) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { if (ValidateHelper.IsNullOrEmpty(StringHelper.Trim(user_id))) { throw new CustomException(0, "用户名不能为空"); } if (ValidateHelper.IsNullOrEmpty(pwd)) { throw new CustomException(0, "密码不能为空"); } //UserID = userId; DataTable dt = _userRep.Login(user_id, MD5Cryption.MD5(pwd)); IList <SysUserModel> list = ConverHelper.ToList <SysUserModel>(dt); if (list.Count < 1) { throw new CustomException(2, "用户名或密码错误");//用户名或密码错误 } if (!ConverHelper.ToBool(list[0].IS_ABLED)) { throw new CustomException(3, "账号已被禁用,请联系系统管理员");//账号是否被禁用 } model.UserCode = list[0].USER_CODE; model.UserName = list[0].USER_NAME; model.LoginNo = list[0].USER_CODE; model.QRCode = list[0].QR_CODE; model.DeptCode = list[0].DEPT_CODE; jsonMsg = ServiceResult.Message(1, "登录成功"); SessionHelper.SetSession("Account", model); CookieHelper.SetCookie("Account", DESCryption.Encrypt(ConverHelper.ToJson(model))); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); } //写入log SysLogLoginModel log = new SysLogLoginModel(); log.LOGIN_ID = GuidHelper.GenerateComb().ToString(); log.USER_CODE = user_id; log.USER_PWD = MD5Cryption.MD5(pwd); log.USER_PWD_LAWS = pwd; log.LOGIN_IP = NetHelper.GetUserIp; log.LOGIN_RESULT = jsonMsg.type == 1 ? "SUCCESS" : "FAIL"; log.LOGIN_MSG = jsonMsg.message; _loglRep.Insert(log); return(jsonMsg); }