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