public bool AddOrEditMenu(MenuDto dto)
{
if (dto.id == 0)
{
var node = new TbMenu
{
MenuName = dto.name,
MenuIcon = dto.icon,
MenuUrl = dto.url,
MenuNo = dto.menuNo,
MenuParentId = dto.parentId,
UpdateBy = dto.updateBy
};
using (_dbContext)
{
_dbContext.Add(node);
return(_dbContext.SaveChanges() > 0 ? true : false);
}
}
else
{
var entity = _dbContext.TbMenu.First(x => x.MenuId == dto.id);
entity.MenuName = dto.name;
entity.MenuIcon = dto.icon;
entity.MenuUrl = dto.url;
entity.MenuNo = dto.menuNo;
entity.UpdateBy = dto.updateBy;
_dbContext.Update(entity);
return(_dbContext.SaveChanges() > 0 ? true : false);
}
}
public bool AddOrEditRolePermis(RolePermisDto dto)
{
var newPermis = dto.permissions.Select(x => new TbPermission
{
MenuId = x.menuId,
SearchState = x.search,
AddState = x.add,
DeleteState = x.delete,
UpdateState = x.update,
ImportState = x.import,
ErportState = x.export,
LockState = x._lock,
UpdateBy = dto.updateBy
});
var newPerRelation = newPermis.Select(x => new TbPerRelation {
Permiss = x
}).ToList();
if (dto.roleId != 0)
{
using (_dbContext)
{
var entity = _dbContext.TbRole
.Include(x => x.TbPerRelation)
.ThenInclude(x => x.Permiss)
.FirstOrDefault(x => x.RoleId == dto.roleId);
_dbContext.TbPermission.RemoveRange(entity.TbPerRelation.Select(x => x.Permiss));
entity.RoleName = dto.roleName;
entity.TbPerRelation = newPerRelation;
_dbContext.TbRole.Update(entity);
return(_dbContext.SaveChanges() > 0 ? true : false);
}
}
else
{
using (_dbContext)
{
var newRole = new TbRole
{
RoleId = dto.roleId,
RoleNo = dto.roleNo,
RoleName = dto.roleName,
TbPerRelation = newPerRelation,
UpdateBy = dto.updateBy
};
_dbContext.TbRole.AddRange(newRole);
return(_dbContext.SaveChanges() > 0 ? true : false);
}
}
}
/// <summary>
/// 修改密码
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public bool ChangePwd(ChangePwdDto dto)
{
var entity = _dbContext.TbUser.FirstOrDefault(x => x.UserNo == dto.userNo && x.UserPassword == dto.oldPwd);
if (entity != null)
{
entity.UserPassword = dto.newPwd;
entity.UpdateTime = DateTime.Now;
entity.UpdateBy = entity.UserId.ToString();
using (_dbContext)
{
_dbContext.TbUser.Update(entity);
return(_dbContext.SaveChanges() > 0 ? true : false);
}
}
return(false);
}
