public Role GetById(long id)
{
var dataSet = _cacheService.Get <DataSet>(id);
#region 从库读取数据
if (dataSet == null)
{
StringBuilder querySql = new StringBuilder();
querySql.AppendFormat($"SELECT * FROM sys_roles WHERE id=@id;");
querySql.AppendFormat(@"SELECT l.* FROM sys_func_roles_link l WHERE l.rid=@id; ");
dataSet = _baseQueryRepository.Context.Ado.GetDataSetAll(querySql.ToString(), new { id });
}
#endregion
#region DataSet 转化为实体
var domain = Dtoer.Mapper <Role>(dataSet.Tables[0]).FirstOrDefault();
var func = Dtoer.Mapper <FuncLink>(dataSet.Tables[1]);
if (func != null)
{
domain.Mapp(new { Funcs = func });
}
#endregion
#region 缓存
_cacheService.SetChacheValue(id, dataSet);
#endregion
return(domain);
}
public SysMember GetById(long id)
{
var dataSet = _cacheService.Get <DataSet>(id);
#region 从数据库读取状态
if (dataSet == null)
{
StringBuilder querySql = new StringBuilder();
querySql.AppendFormat("SELECT * FROM sys_member WHERE id=@id;");
querySql.AppendFormat(@"SELECT r.* FROM sys_roles r
INNER JOIN sys_member_roles_link rl on rl.rid = r.id
WHERE rl.mid = @id;");
dataSet = _baseQueryRepository.Context.Ado.GetDataSetAll(querySql.ToString(), new { id });
}
#endregion
#region DataSet 转化为实体
var domain = Dtoer.Mapper <SysMember>(dataSet.Tables[0]).FirstOrDefault();
var roles = Dtoer.Mapper <Role>(dataSet.Tables[1]);
if (roles != null)
{
domain.Mapp(new { Roles = roles });
}
#endregion
#region 缓存
_cacheService.SetChacheValue(id, dataSet);
#endregion
return(domain);
}
public SysFunc GetById(long id)
{
var dataSet = _cacheService.Get <DataSet>(id);
#region 从库读取数据
if (dataSet == null)
{
StringBuilder querySql = new StringBuilder();
querySql.AppendFormat($"SELECT * FROM sys_func WHERE id=@id;");
dataSet = _baseQueryRepository.Context.Ado.GetDataSetAll(querySql.ToString(), new { id });
}
#endregion
#region DataSet 转化为实体
var domain = Dtoer.Mapper <SysFunc>(dataSet.Tables[0]).FirstOrDefault();
#endregion
#region 缓存
_cacheService.SetChacheValue(id, dataSet);
#endregion
return(domain);
}
