/// <summary>
/// 根据角色Id获取角色编辑信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public RoleInfoEditModel GetRoleInfoById(string id)
{
try
{
if (string.IsNullOrWhiteSpace(id))
{
throw new Exception("角色Id不能为空！");
}
RoleInfoEditModel result = new RoleInfoEditModel();
DataTable dt = _sql.Query("SELECT RoleName,RoleCode FROM RoleInfo WHERE IsDeleted = 0 AND RoleInfoId = @id", new Dictionary <string, object> {
{ "@id", id }
});
if (dt != null && dt.Rows.Count > 0)
{
result.RoleInfoId = id;
result.RoleName = Cast.ConToString(dt.Rows[0]["RoleName"]);
result.RoleCode = Cast.ConToString(dt.Rows[0]["RoleCode"]);
}
return(result);
}
catch (Exception ex)
{
_log.Error(ex);
throw ex;
}
}
/// <summary>
/// 创建或更新角色信息
/// </summary>
/// <param name="info">角色编辑信息</param>
/// <returns></returns>
public string CreateOrUpdateRoleInfo(RoleInfoEditModel info)
{
try
{
if (string.IsNullOrWhiteSpace(info.RoleName))
{
throw new Exception("角色名称不能为空！");
}
if (string.IsNullOrWhiteSpace(info.RoleCode))
{
throw new Exception("角色编码不能为空！");
}
_sql.OpenDb();
string result = string.Empty;
RoleInfo roleInfo = new RoleInfo();
info.FillTableWithModel <RoleInfo>(roleInfo);
if (!string.IsNullOrEmpty(info.RoleInfoId))
{
_sql.Update(roleInfo);
result = Constants.UpdateSuccessMssg;
}
else
{
DataTable dt = _sql.Query("SELECT RoleName FROM RoleInfo WHERE IsDeleted = 0 AND RoleCode = @code", new Dictionary <string, object> {
{ "@code", info.RoleCode }
});
if (dt != null && dt.Rows.Count > 0)
{
throw new Exception(string.Format("当前角色【{0}:{1}】已存在！", info.RoleCode, Cast.ConToString(dt.Rows[0]["RoleName"])));
}
_sql.Create(roleInfo);
result = Constants.CreateSuccessMssg;
}
return(result);
}
catch (Exception ex)
{
_log.Error(ex);
throw ex;
}
finally
{
_sql.CloseDb();
}
}