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