/// <summary> /// 添加编辑角色 /// </summary> /// <param name="dto"></param> /// <returns></returns> public void AddEdit(RoleAddEditDto dto) { dto.RoleName = dto.RoleName.Trim(); SysRole role = null; if (dto.RoleId.HasValue) { if (dbClint.Queryable<SysRole>().Where(r => r.RoleName == dto.RoleName && r.IsDeleted == false && r.RoleId != dto.RoleId.Value).Any()) throw Oops.Oh($"已存在角色【{dto.RoleName}】!"); role = _repository.FirstOrDefault(r=>r.RoleId==dto.RoleId.Value); role.ModifyDate = DateTime.Now; role.ModifyUserId = _userManager.UserId; role.ModifyUserName = _userManager.UserName; } else { if (dbClint.Queryable<SysRole>().Where(r => r.RoleName == dto.RoleName && r.IsDeleted == false).Any()) throw Oops.Oh($"已存在角色【{dto.RoleName}】!"); role = new SysRole() { CreateDate = DateTime.Now, CreateUserId = _userManager.UserId, CreateUserName = _userManager.UserName, IsDeleted = false }; } role.RoleName = dto.RoleName; role.Remark = dto.Remark; role.IsEnabled = dto.IsEnabled; if (dto.RoleId.HasValue) dbClint.Updateable(role).ExecuteCommand(); else dbClint.Insertable(role).ExecuteCommand(); }
/// <summary> /// 添加编辑角色 /// </summary> /// <param name="dto"></param> /// <returns></returns> public void AddEdit(OrgAddEditDto dto) { dto.OrgName = dto.OrgName.Trim(); SysOrg org = null; if (dto.OrgId.HasValue) { org = _repository.FirstOrDefault(o => o.OrgId == dto.OrgId.Value); org.ModifyDate = DateTime.Now; org.ModifyUserId = _userManager.UserId; org.ModifyUserName = _userManager.UserName; } else { org = new SysOrg() { CreateDate = DateTime.Now, CreateUserId = _userManager.UserId, CreateUserName = _userManager.UserName, IsLeaf = false, IsDeleted = false }; } org.OrgName = dto.OrgName; org.ParentOrgId = dto.ParentOrgId; org.ParentOrgName = dto.ParentOrgId > 0 ? dto.ParentOrgName : ""; org.Status = dto.Status; org.SortNo = dto.SortNo ?? 0; if (org.ParentOrgId > 0) { if (dbClint.Queryable <SysOrg>().Where(o => o.OrgName == dto.OrgName && o.ParentOrgId == dto.ParentOrgId && o.OrgId != dto.OrgId && o.IsDeleted == false).Any()) { throw Oops.Oh("同部门下的子部门不能重复!"); } } if (dto.OrgId.HasValue) { dbClint.Updateable(org).ExecuteCommand(); } else { dbClint.Insertable(org).ExecuteCommand(); } }
/// <summary> /// 添加和编辑用户信息 /// </summary> /// <param name="dto"></param> public void AddEdit(UserAddEditDto dto) { //去前后空格 dto.UserName = dto.UserName.Trim(); dto.Email = dto.Email.Trim(); long userId = 0; SysUser sysUser = null; if (dto.UserId.HasValue) { if (dbClint.Queryable <SysUser>().Where(u => u.UserCode == dto.UserCode && u.IsDeleted == false && u.UserId != dto.UserId.Value).Any()) { throw Oops.Oh(string.Format("用户名[{0}]已经存在!", dto.UserName)); } if (dbClint.Queryable <SysUser>().Where(u => u.Email == dto.Email && u.IsDeleted == false && u.UserId != dto.UserId.Value).Any()) { throw Oops.Oh(string.Format("邮箱[{0}]已经被使用!", dto.Email)); } sysUser = _repository.FirstOrDefault(u => u.UserId == dto.UserId.Value); sysUser.ModifyDate = DateTime.Now; sysUser.ModifyUserId = _userManager.UserId; sysUser.ModifyUserName = _userManager.UserName; userId = sysUser.UserId; } else { if (dbClint.Queryable <SysUser>().Where(u => u.UserName == dto.UserName && u.IsDeleted == false).Any()) { throw Oops.Oh(string.Format("用户名[{0}]已经存在!", dto.UserName)); } if (dbClint.Queryable <SysUser>().Where(u => u.Email == dto.Email && u.IsDeleted == false).Any()) { throw Oops.Oh(string.Format("邮箱[{0}]已经被使用!", dto.Email)); } sysUser = new SysUser() { CreateDate = DateTime.Now, CreateUserId = _userManager.UserId, CreateUserName = _userManager.UserName, //Password = EncryptHelper.DESEnCode(dto.Password.Trim(), _auth.PasswordKey), Type = (int)UserTypeEnum.Normal, IsDeleted = false }; } sysUser.UserCode = dto.UserCode; sysUser.UserName = dto.UserName; sysUser.Email = dto.Email; sysUser.Phone = dto.Phone; sysUser.Status = dto.Status; sysUser.Sex = dto.Sex; sysUser.Qq = dto.Qq; sysUser.Remark = dto.Remark; var result = dbClint.Ado.UseTran(() => { if (dto.UserId.HasValue) { dbClint.Updateable(sysUser).ExecuteCommand(); } else { userId = dbClint.Insertable(sysUser).ExecuteReturnBigIdentity(); } //用户部门 if (dto.OrgId.HasValue && dto.OrgId > 0) { _sysRelevanceService.SetUserOrg(userId, dto.OrgId.Value); } }); if (result.IsSuccess == false) { throw Oops.Oh(result.ErrorMessage); } }
/// <summary> /// 根据模块id获取模块信息 /// </summary> /// <returns></returns> public SysModule GetModuleById(long moduleId) { return(_repository.FirstOrDefault(m => m.ModuleId == moduleId)); }