public string All([FromQuery] QueryCategoryListReq request)
{
TableData data = new TableData();
data = _app.Load(request);
return(JsonHelper.Instance.Serialize(data));
}
public TableData All(QueryCategoryListReq request)
{
var result = new TableData();
var categories = UnitWork.Find <Category>(null);
if (!string.IsNullOrEmpty(request.key))
{
categories = categories.Where(u => u.Name.Contains(request.key) || u.Id.Contains(request.key));
}
if (!string.IsNullOrEmpty(request.TypeId))
{
categories = categories.Where(u => u.TypeId == request.TypeId);
}
var query = from category in categories
join ct in UnitWork.Find <CategoryType>(null) on category.TypeId equals ct.Id
into tmp
from ct in tmp.DefaultIfEmpty()
select new
{
category.Name,
category.Id,
category.TypeId,
TypeName = ct.Name,
category.Description
};
result.data = query.OrderBy(u => u.TypeId)
.Skip((request.page - 1) * request.limit)
.Take(request.limit).ToList();
result.count = categories.Count();
return(result);
}
/// <summary>
/// 加载列表
/// </summary>
public TableData Load(QueryCategoryListReq request)
{
var loginContext = _auth.GetCurrentUser();
if (loginContext == null)
{
throw new CommonException("登录已过期", Define.INVALID_TOKEN);
}
var properties = loginContext.GetProperties("Category");
if (properties == null || properties.Count == 0)
{
throw new Exception("当前登录用户没有访问该模块字段的权限，请联系管理员配置");
}
var propertyStr = string.Join(",", properties.Select(u => u.Key));
return(new TableData
{
columnHeaders = properties,
count = Repository.GetCount(null),
data = Repository.Find(request.page, request.limit, "Id desc").Select($"new ({propertyStr})")
});
}
/// <summary>
/// 加载列表
/// </summary>
public async Task <TableData> Load(QueryCategoryListReq request)
{
var loginContext = _auth.GetCurrentUser();
if (loginContext == null)
{
throw new CommonException("登录已过期", Define.INVALID_TOKEN);
}
var columnFields = loginContext.GetTableColumns("Category");
if (columnFields == null || columnFields.Count == 0)
{
throw new Exception("请在代码生成界面配置Category表的字段属性");
}
var result = new TableData();
var objs = UnitWork.Find <Category>(null);
if (!string.IsNullOrEmpty(request.TypeId))
{
objs = objs.Where(u => u.TypeId == request.TypeId);
}
if (!string.IsNullOrEmpty(request.key))
{
objs = objs.Where(u => u.Id.Contains(request.key) || u.Name.Contains(request.key));
}
var propertyStr = string.Join(',', columnFields.Select(u => u.ColumnName));
result.columnFields = columnFields;
result.data = objs.OrderBy(u => u.DtCode)
.Skip((request.page - 1) * request.limit)
.Take(request.limit).Select($"new ({propertyStr})");
result.count = await objs.CountAsync();
return(result);
}
/// <summary>
/// 加载列表
/// </summary>
public TableData Load(QueryCategoryListReq request)
{
var loginContext = _auth.GetCurrentUser();
if (loginContext == null)
{
throw new CommonException("登录已过期", Define.INVALID_TOKEN);
}
var properties = loginContext.GetProperties("Category");
if (properties == null || properties.Count == 0)
{
throw new Exception("当前登录用户没有访问该模块字段的权限，请联系管理员配置");
}
var result = new TableData();
var objs = UnitWork.Find <Category>(null);
if (!string.IsNullOrEmpty(request.TypeId))
{
objs = objs.Where(u => u.TypeId == request.TypeId);
}
if (!string.IsNullOrEmpty(request.key))
{
objs = objs.Where(u => u.Id.Contains(request.key) || u.Name.Contains(request.key));
}
var propertyStr = string.Join(',', properties.Select(u => u.Key));
result.columnHeaders = properties;
result.data = objs.OrderBy(u => u.DtCode)
.Skip((request.page - 1) * request.limit)
.Take(request.limit).Select($"new ({propertyStr})");
result.count = objs.Count();
return(result);
}
public TableData Load([FromQuery] QueryCategoryListReq request)
{
return(_app.Load(request));
}
public async Task <TableData> Load([FromQuery] QueryCategoryListReq request)
{
return(await _app.Load(request));
}
