| | |
|---|
| | | public async Task<List<DataStockDetail>> GetStockQueryList(string locatNo, string palletNo) |
|---|
| | | { |
|---|
| | | return await Db.Queryable<DataStockDetail>() |
|---|
| | | .Where(s => s.IsDel == "0" && s.LocatNo.Contains(locatNo) && s.PalletNo.Contains(palletNo)) |
|---|
| | | .Where(s => s.IsDel == "0" && s.LocatNo.Contains(locatNo) || s.PalletNo.Contains(palletNo)) |
|---|
| | | .OrderBy(s => new { s.LotNo, s.LocatNo, s.PalletNo }) |
|---|
| | | .ToListAsync(); |
|---|
| | | |
|---|
| | |
|---|
| | | SkuName = boxInfo.SkuName, |
|---|
| | | LotNo = boxInfo.LotNo, |
|---|
| | | BoxNoList = new List<string>() { boxNoNew } , |
|---|
| | | Date1 = boxInfo.ProductionTime.ToString(), |
|---|
| | | Date2 = boxInfo.ExpirationTime.ToString(), |
|---|
| | | |
|---|
| | | Date1 = boxInfo.ProductionTime == null ? "" : Convert.ToDateTime(boxInfo.ProductionTime).ToString("yyyy-MM-dd"), |
|---|
| | | Date2 = boxInfo.ExpirationTime == null ? "" : Convert.ToDateTime(boxInfo.ExpirationTime).ToString("yyyy-MM-dd"), |
|---|
| | | }; |
|---|
| | | |
|---|
| | | #endregion |
|---|
