private IQueryable <TInAsn> Query(QueryAsn queryAsn)
{
if (queryAsn.PageSize == 0)
{
queryAsn.PageSize = 20;
}
var query = wms.TInAsns as IQueryable <TInAsn>;
if (queryAsn.whId > 0)
{
query = query.Where(x => x.WhId == queryAsn.whId);
}
if (queryAsn.custId > 0)
{
query = query.Where(x => x.CustId == queryAsn.custId);
}
if (queryAsn.brandId > 0)
{
query = query.Where(x => x.BrandId == queryAsn.brandId);
}
if (!string.IsNullOrEmpty(queryAsn.asnCode))
{
query = query.Where(x => x.Code == queryAsn.asnCode);
}
if (!string.IsNullOrEmpty(queryAsn.bizCode))
{
query = query.Where(x => x.BizCode == queryAsn.bizCode);
}
if (!string.IsNullOrEmpty(queryAsn.goodsType))
{
query = query.Where(x => x.GoodsType == queryAsn.goodsType);
}
if (!string.IsNullOrEmpty(queryAsn.status))
{
query = query.Where(x => x.Status == queryAsn.status);
}
if (!string.IsNullOrEmpty(queryAsn.checkStatus))
{
query = query.Where(x => x.CheckStatus == queryAsn.checkStatus);
}
if (queryAsn.isCiq != null)
{
query = query.Where(x => x.IsCiq == queryAsn.isCiq);
}
return(query);
}
public JsonResult Index([FromUri] QueryAsn queryAsn)
{
var list = asnService.PageList(queryAsn);
var totalCount = asnService.TotalCount(queryAsn);
var response = new JsonResult(
new SingleResponse
{
Data = list,
TotalCount = totalCount
}
);
return(response);
}
public int TotalCount(QueryAsn queryAsn)
{
return(this.Query(queryAsn).Count());
}
public List <TInAsn> PageList(QueryAsn queryAsn)
{
return(this.Query(queryAsn).
OrderByDescending(x => x.Id).Skip(queryAsn.PageIndex).Take(queryAsn.PageSize).ToList());
}
