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