/// <summary>
/// 依据角色名获取角色
/// </summary>
/// <param name="roleName"></param>
/// <returns>不存在返回Null</returns>
public TRightsRole GetRoleByName(string roleName)
{
TRightsRole result = null;
using (var conn = DapperHelper.CreateConnection())
{
result = conn.Query <TRightsRole>(@"SELECT * FROM dbo.t_rights_role AS r WHERE r.name= @RoleName;", new { @RoleName = roleName }).FirstOrDefault();
}
return(result);
}
/// <summary>
/// 插入
/// </summary>
/// <param name="item">待插入的记录</param>
public bool Insert(TRightsRole item)
{
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"INSERT INTO dbo.t_rights_role VALUES (@Name ,@Description ,@OrganizationId ,@CreatedBy ,@CreatedTime ,@LastUpdatedBy ,@LastUpdatedTime);", item);
if (effectRows > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 依id查询
/// </summary>
/// <param name="id">id</param>
/// <returns></returns>
public TRightsRole GetById(int id)
{
TRightsRole result = null;
using (var conn = DapperHelper.CreateConnection())
{
result = conn.Query <TRightsRole>(@"SELECT r.organization_id AS OrganizationId, r.created_by AS CreatedBy,r.created_time AS CreatedTime,
r.last_updated_by AS LastUpdatedBy,r.last_updated_time AS LastUpdatedTime,*
FROM dbo.t_rights_role AS r
WHERE r.id= @Id;", new { @Id = id }).FirstOrDefault();
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="item">待更新的记录</param>
/// <returns></returns>
public bool Update(TRightsRole item)
{
using (var conn = DapperHelper.CreateConnection())
{
var effectRows = conn.Execute(@"UPDATE dbo.t_rights_role SET name= @Name, description= @Description, organization_id= @OrganizationId, last_updated_by= @LastUpdatedBy,
last_updated_time= @LastUpdatedTime WHERE id= @Id;", item);
if (effectRows > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="request"></param>
/// <param name="loginInfo"></param>
/// <returns></returns>
public ServiceResult <bool> AddRole(AddRoleRequest request, TRightsUser loginInfo)
{
//需要检查是否已存在相同名称的角色
var result = new ServiceResult <bool>
{
ReturnCode = ReturnCodeType.Error
};
var role = _roleDao.GetRoleByName(request.Name);
if (role != null)
{
result.Message = "已存在相同名称的角色!";
return(result);
}
var currentTime = DateTime.Now;
var item = new TRightsRole
{
Name = request.Name,
Description = request.Description,
OrganizationId = request.OrgId,
CreatedBy = loginInfo.Id,
CreatedTime = currentTime,
LastUpdatedBy = loginInfo.Id,
LastUpdatedTime = currentTime
};
var rs = _roleDao.Insert(item);
if (rs == true)
{
result.ReturnCode = ReturnCodeType.Success;
result.Content = true;
}
return(result);
}
