/// <summary> /// 设定用户部门 /// </summary> /// <param name="userId"></param> /// <param name="deptId"></param> /// <returns></returns> public JsonMessage UpdateUserDept(string userId, string deptId) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _userRep.GetById(userId); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "该用户不存在");// } result = _userRep.UpdateUserDept(userId, deptId); jsonMsg = ServiceResult.Message(result, "更新成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "设定用户部门失败"); } //写入log WriteSystemLog(jsonMsg, CREATE, OPT_MODEL, "设定用户部门"); return(jsonMsg); }
/// <summary> /// 删除操作码 /// </summary> /// <param name="moId"></param> /// <param name="menu_id"></param> /// <returns></returns> public JsonMessage Delete(string moId, string menu_id) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _menuOpApp.GetById(moId, menu_id); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "操作码删除失败,操作码不存在"); } result = _menuOpApp.Delete(moId, menu_id); jsonMsg = ServiceResult.Message(1, "操作码删除成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, menu_id + ":" + moId + ":删除操作码失败"); } //写入log WriteSystemLog(jsonMsg, DELETE, OPT_MODEL, menu_id + ":" + moId + ":删除操作码"); return(jsonMsg); }
/// <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]); }
/// <summary> /// 添加部门 /// </summary> /// <param name="code"></param> /// <param name="name"></param> /// <param name="parentId"></param> /// <param name="site_code"></param> /// <param name="site_name"></param> /// <param name="sort"></param> /// <param name="type"></param> /// <param name="desc"></param> /// <param name="isAble"></param> /// <param name="isEnd"></param> /// <returns></returns> public JsonMessage Insert(string code, string name, string parent_code, string site_code, string site_name, int sort, string type, string desc, bool isAble, bool isEnd) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _deptRep.GetById(parent_code); if (dt == null || dt.Rows.Count < 1) { throw new CustomException(0, "添加失败,父节点不存在,请刷新后在试");//添加失败,父节点不存在,请刷新后在试 } DataTable dt2 = _deptRep.GetByCodeOrName(code, name); if (!ValidateHelper.IsDataTableNotData(dt2)) { throw new CustomException(0, "添加失败,部门编号或名称已存在"); } SysDeptModel model = new SysDeptModel(); model.DEPT_CODE = code; model.DEPT_NAME = name; model.PARENT_CODE = parent_code; model.SITE_CODE = site_code; model.SITE_NAME = site_name; model.DEPT_SORT = sort; model.DEPT_TYPE = "LOCAL"; model.DEPT_DESC = desc; model.IS_ABLE = isAble ? 1 : 0; model.IS_END = isEnd ? 1 : 0; model.CREATE_USER = UserID; model.LM_USER = UserID; result = _deptRep.Insert(model); jsonMsg = ServiceResult.Message(1, "添加成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, name + ":添加部门信息失败"); } //写入log WriteSystemLog(jsonMsg, CREATE, OPT_MODEL, name + ":添加部门信息"); return(jsonMsg); }
/// <summary> /// 修改密码 /// </summary> /// <param name="userId">用户账号</param> /// <param name="oldPwd">旧密码</param> /// <param name="newPwd">新密码</param> /// <param name="newPwdOk">二次新密码</param> /// <param name="isQR">是否更改二维码</param> /// <param name="QRCode">加密二维码</param> /// <returns></returns> public JsonMessage EditPassword(string userId, string oldPwd, string newPwd, string newPwdOk, bool isQR, string QRCode) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { SysUserModel model = null; DataTable dt = _userRep.Login(userId, oldPwd); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "旧密码不正确"); } if (ValidateHelper.IsNullOrEmpty(userId)) { throw new CustomException(0, "非法操作,用户名不能为空"); } if (ValidateHelper.IsNullOrEmpty(newPwd)) { throw new CustomException(0, "新密码不能为空"); } if (oldPwd == newPwd) { throw new CustomException(0, "旧密码不能已新密码一致"); } if (newPwd != newPwdOk) { throw new CustomException(0, "两次密码不一致"); } result = _userRep.EditPassword(userId, newPwd, isQR, QRCode); jsonMsg = ServiceResult.Message(result, "密码修改成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "用户自行修改密码失败"); } //写入log WriteSystemLog(jsonMsg, UPDATE, OPT_MODEL, "用户修改密码"); return(jsonMsg); }
/// <summary> /// 修改用户信息 /// </summary> /// <param name="userId"></param> /// <param name="userName"></param> /// <param name="e_mail"></param> /// <param name="tel"></param> /// <param name="sex"></param> /// <param name="post"></param> /// <param name="resetPwd"></param> /// <param name="qrCode"></param> /// <param name="isAble"></param> /// <param name="isChangePwd"></param> /// <param name="desc"></param> /// <returns></returns> public JsonMessage Edit(string userId, string userName, string e_mail, string tel, bool sex, string post, bool resetPwd, bool qrCode, bool isAble, bool isChangePwd, string desc) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _userRep.GetById(userId); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "该用户不存在"); } string newPwd = "123456"; SysUserModel model = new SysUserModel(); model.USER_CODE = userId; model.USER_NAME = userName; model.USER_PWD = resetPwd ? MD5Cryption.MD5(newPwd) : dt.Rows[0]["USER_PWD"].ToString(); model.USER_EMAIL = e_mail; model.USER_TEL = tel; model.USER_SEX = sex ? 1 : 0; model.USER_POST = post; model.IS_ABLED = isAble ? 1 : 0; model.IS_C_PWD = isChangePwd ? 1 : 0; model.QR_CODE = qrCode ? DESCryption.Encrypt(userId + newPwd) : dt.Rows[0]["QR_CODE"].ToString(); model.USER_DESC = desc; model.LM_USER = UserID; result = _userRep.Edit(model); jsonMsg = ServiceResult.Message(result, "修改用户成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "修改用户失败"); } //写入log WriteSystemLog(jsonMsg, CREATE, OPT_MODEL, "修改用户"); return(jsonMsg); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="menuId"></param> /// <param name="menuName"></param> /// <param name="parentId"></param> /// <param name="code"></param> /// <param name="link"></param> /// <param name="icon"></param> /// <param name="sort"></param> /// <param name="type"></param> /// <param name="desc"></param> /// <param name="isable"></param> /// <param name="isend"></param> /// <returns></returns> public JsonMessage Edit(string menuId, string menuName, string parentId, string code, string link, string icon, int sort, string type, string desc, bool isable, bool isend) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _menuRep.GetById(menuId); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "菜单不存在,刷新后尝试"); } SysMenuModel model = new SysMenuModel(); model.MENU_ID = menuId; model.MENU_NAME = menuName; model.PARENT_ID = parentId; model.MENU_CODE = code; model.MENU_PATH = link; model.MENU_ICON = icon; model.MENU_SORT = sort; model.MENU_TYPE = type; model.MENU_DESC = desc; model.IS_ABLED = isable ? 1 : 0; model.IS_END = isend ? 1 : 0; model.CREATE_USER = UserID; model.LM_USER = UserID; result = _menuRep.Edit(model); jsonMsg = ServiceResult.Message(1, "菜单修改成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, menuId + ":修改系统菜单失败"); } //写入log WriteSystemLog(jsonMsg, UPDATE, OPT_MODEL, menuId + ":修改系统菜单"); return(jsonMsg); }
/// <summary> /// 更新部门信息 /// </summary> /// <param name="dept_code"></param> /// <param name="name"></param> /// <param name="parent_code"></param> /// <param name="site_code"></param> /// <param name="site_name"></param> /// <param name="sort"></param> /// <param name="type"></param> /// <param name="desc"></param> /// <param name="isAble"></param> /// <param name="isEnd"></param> /// <returns></returns> public JsonMessage Edit(string dept_code, string name, string parent_code, string site_code, string site_name, int sort, string type, string desc, bool isAble, bool isEnd) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _deptRep.GetById(dept_code); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "更新失败,该部门不存在,请刷新后再试");// } SysDeptModel model = new SysDeptModel(); model.DEPT_CODE = dept_code; model.DEPT_NAME = name; model.PARENT_CODE = parent_code; model.SITE_CODE = site_code; model.SITE_NAME = site_name; model.DEPT_SORT = sort; model.DEPT_TYPE = "LOCAL"; model.DEPT_DESC = desc; model.IS_ABLE = isAble ? 1 : 0; model.IS_END = isEnd ? 1 : 0; model.LM_USER = UserID; result = _deptRep.Edit(model); jsonMsg = ServiceResult.Message(1, "更新成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, dept_code + ":更新部门信息失败"); } //写入log WriteSystemLog(jsonMsg, UPDATE, OPT_MODEL, dept_code + ":更新部门信息"); return(jsonMsg); }
/// <summary> /// 添加角色信息 /// </summary> /// <param name="roleName"></param> /// <param name="desc"></param> /// <returns></returns> public JsonMessage Insert(string roleName, string desc) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _roleRep.GetByRoleName(roleName); if (!ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "角色名称重复,请重新填写 ");//角色名称重复,请重新填写 } SysRoleModel model = new SysRoleModel(); model.ROLE_ID = GuidHelper.GenerateComb().ToString().ToUpper(); model.ROLE_NAME = roleName; model.ROLE_DESC = desc; model.CREATE_USER = UserID; model.LM_USER = UserID; result = _roleRep.Insert(model); if (result == 1) { _rightRep.InsertSysRight(model.CREATE_USER, model.LM_USER); } jsonMsg = ServiceResult.Message(1, "角色添加成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) {//记录异常 jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "添加角色失败"); } //写入log WriteSystemLog(jsonMsg, CREATE, OPT_MODEL, "添加角色信息"); return(jsonMsg); }
public JsonMessage Delete(string dept_code) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { if (dept_code == "0000000000") { throw new CustomException(0, "删除失败,顶级菜单不能删除");// } DataTable dt = _deptRep.GetByParentId(dept_code); if (!ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "删除失败,该部门下存在子部门,请先删除子部门"); // } DataTable dt_n = _deptRep.GetById(dept_code); if (ValidateHelper.IsDataTableNotData(dt_n)) { throw new CustomException(0, "删除失败,该部门不存在,请刷新后再试");// } result = _deptRep.Delete(dept_code); jsonMsg = ServiceResult.Message(1, "删除成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, dept_code + ":删除部门信息失败"); } //写入log WriteSystemLog(jsonMsg, DELETE, OPT_MODEL, dept_code + ":删除部门信息"); return(jsonMsg); }
/// <summary> /// 添加操作码 /// </summary> /// <param name="keyCode"></param> /// <param name="name"></param> /// <param name="menuId"></param> /// <param name="isValid"></param> /// <param name="desc"></param> /// <returns></returns> public JsonMessage Insert(string keyCode, string name, string menuId, bool isValid, string desc) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _menuOpApp.GetByCodeOrName(menuId, name, keyCode); if (!ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, " 添加操作码失败,操作码名称或代码重复"); } SysMenuOptModel model = new SysMenuOptModel(); model.MO_CODE = keyCode; model.MO_NAME = name; model.MENU_ID = menuId; model.IS_ABLED = isValid ? 1 : 0; model.MO_DESC = desc; model.CREATE_USER = UserID; model.LM_USER = UserID; result = _menuOpApp.Insert(model); jsonMsg = ServiceResult.Message(1, "添加操作码成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "为菜单[" + menuId + "]添加操作码[" + keyCode + "]失败"); } //写入log WriteSystemLog(jsonMsg, CREATE, OPT_MODEL, menuId + ":" + keyCode + ":添加操作码"); return(jsonMsg); }
/// <summary> /// 删除角色 /// </summary> /// <param name="roleId"></param> /// <returns></returns> public JsonMessage Delete(string roleId) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _roleRep.GetById(roleId); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "角色删除失败,角色不存在");// } result = _roleRep.Delete(roleId); if (result > 0) { _userRep.DeleteSysUserRoleByRoleId(roleId);//根据角色ID 删除用户与角色的对应关系 _roleRep.ClearUnusedRightOpt(); } jsonMsg = ServiceResult.Message(1, "角色删除成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "删除角色失败"); } //写入log WriteSystemLog(jsonMsg, DELETE, OPT_MODEL, "删除角色"); return(jsonMsg); }
/// <summary> /// 修改角色 /// </summary> /// <param name="roleId"></param> /// <param name="roleName"></param> /// <param name="desc"></param> /// <returns></returns> public JsonMessage Edit(string roleId, string roleName, string desc) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) try { DataTable dt = _roleRep.GetById(roleId); if (ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "角色修改失败,角色不存在");// } SysRoleModel model = new SysRoleModel(); model.ROLE_ID = roleId; model.ROLE_NAME = roleName; model.ROLE_DESC = desc; model.LM_USER = UserID; result = _roleRep.Edit(model); jsonMsg = ServiceResult.Message(1, "角色修改成功"); } catch (CustomException ex) { jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, "修改角色失败"); } //写入log WriteSystemLog(jsonMsg, UPDATE, OPT_MODEL, "修改角色信息"); return(jsonMsg); }
public JsonMessage Insert(string menuName, string parentId, string code, string link, string icon, int sort, string type, string desc, bool isable, bool isend) { JsonMessage jsonMsg = new JsonMessage(); //返回Json int result = -1; //类型(成功 、失败) _menuRep.BeginTransaction(); try { DataTable dt = _menuRep.GetByCodeOrName(code, menuName); if (!ValidateHelper.IsDataTableNotData(dt)) { throw new CustomException(0, "添加失败,菜单名称或编码已存在"); } SysMenuModel model = new SysMenuModel(); model.MENU_ID = GuidHelper.GenerateComb().ToString().ToUpper(); model.MENU_NAME = menuName; model.PARENT_ID = parentId; model.MENU_CODE = code; model.MENU_PATH = link; model.MENU_ICON = icon; model.MENU_SORT = sort; model.MENU_TYPE = type; model.MENU_DESC = desc; model.IS_ABLED = isable ? 1 : 0; model.IS_END = isend ? 1 : 0; model.CREATE_USER = UserID; model.LM_USER = UserID; result = _menuRep.Insert(model); if (result == 1) { SysMenuOptModel optModel = new SysMenuOptModel(); optModel.MO_CODE = "browse"; optModel.MO_NAME = "浏览"; optModel.MENU_ID = model.MENU_ID; optModel.IS_ABLED = 1; optModel.MO_DESC = "请勿删除,默认添加项,误删除请重新添加上"; optModel.CREATE_USER = UserID; optModel.LM_USER = UserID; _menuOptRep.Insert(optModel); _rightRep.InsertSysRight(model.CREATE_USER, model.LM_USER); } _menuRep.CommitTransaction(); jsonMsg = ServiceResult.Message(1, "菜单添加成功"); } catch (CustomException ex) { _menuRep.RollbackTransaction(); jsonMsg = ServiceResult.Message(ex.ResultFlag, ex.Message); } catch (Exception ex) { _menuRep.RollbackTransaction(); jsonMsg = ServiceResult.Message(-1, ex.Message); WriteSystemException(ex, this.GetType(), OPT_MODEL, code + ":添加系统菜单失败"); } //写入log WriteSystemLog(jsonMsg, CREATE, OPT_MODEL, code + ":添加系统菜单"); return(jsonMsg); }