public IHttpActionResult Skus(RequestPayload.RequestPayload payload)
{
using (_dbContext)
{
var query = _dbContext.TjSkus.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x =>
x.SkuType.Contains(payload.Kw.Trim()) || x.SkuCode.Contains(payload.Kw.Trim()));
}
if (payload.FirstSort != null)
{
query = query.OrderBy(payload.FirstSort.Field, payload.FirstSort.Direct == "DESC");
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
// var data = list.Select(_mapper.Map<DncUser, UserJsonModel>);
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult GoodsList(Guid id, RequestPayload.RequestPayload payload)
{
using (_dbContext) {
var query = _dbContext.Goods.Where(x => x.ShopId == id);
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(RequestPayload.RequestPayload payload)
{
using (_dbContext)
{
//var query = from gr in _dbContext.GrabageRoom
// join v in _dbContext.Village
// on gr.VillageId equals v.VillageUuid
// where gr.IsDelete == "0"
// select new
// {
// gr.Posititon,
// gr.Ljname,
// v.Vname,
// gr.SystemUser.FirstOrDefault(x => x.SystemUserUuid == gr.SystemUserUuid).RealName,
// };
var response =
ResponseModelFactory.CreateResultInstance;
//response.SetData(list, totalCount);
return(Ok(response));
}
}
