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