private IQueryable <VAsnCheck> Query(QueryAsnCheck queryAsnCheck)
{
if (queryAsnCheck.PageSize == 0)
{
queryAsnCheck.PageSize = 20;
}
var query = (from check in wms.TInChecks
join asn in wms.TInAsns on check.HId equals asn.Id
select new VAsnCheck
{
Id = check.Id,
HId = check.HId,
Code = check.Code,
AsnCode = asn.Code,
IsCiq = check.IsCiq,
Status = check.Status,
AsnCartonQty = asn.CartonQty,
AsnQty = asn.PieceQty,
CartonQty = check.CartonQty,
Qty = check.Qty,
DamageCartonQty = check.DamageCartonQty,
DamageQty = check.DamageQty,
CreatedTime = check.CreatedTime,
CreatedBy = check.CreatedBy
})
as IQueryable <VAsnCheck>;
return(query);
}
public int TaskTotalCount(QueryAsnCheck queryAsnCheck)
{
return(this.Query(queryAsnCheck)
.Where(x => x.Status == Enum.GetName(typeof(EnumOperateStatus), EnumOperateStatus.Doing) ||
x.Status == Enum.GetName(typeof(EnumOperateStatus), EnumOperateStatus.Init))
.Count());
}
public List <VAsnCheck> PageList(QueryAsnCheck queryAsnCheck)
{
return(this.Query(queryAsnCheck)
.OrderByDescending(x => x.Id)
.Skip(queryAsnCheck.PageIndex)
.Take(queryAsnCheck.PageSize)
.ToList());
}
public List <VAsnCheck> TaskPageList(QueryAsnCheck queryAsnCheck)
{
return(this.Query(queryAsnCheck)
.Where(x => x.Status == Enum.GetName(typeof(EnumOperateStatus), EnumOperateStatus.Doing) ||
x.Status == Enum.GetName(typeof(EnumOperateStatus), EnumOperateStatus.Init))
.OrderByDescending(x => x.Id)
.Skip(queryAsnCheck.PageIndex)
.Take(queryAsnCheck.PageSize).ToList());
}
public JsonResult List([FromUri] QueryAsnCheck queryAsnCheck)
{
var list = asnCheckService.PageList(queryAsnCheck);
var totalCount = asnCheckService.TotalCount(queryAsnCheck);
var response = new JsonResult(
new SingleResponse
{
Data = list,
TotalCount = totalCount
}
);
return(response);
}
public int TotalCount(QueryAsnCheck queryAsnCheck)
{
return(this.Query(queryAsnCheck).Count());
}
