| | |
| | | .GroupBy((a, b) => new |
| | | { |
| | | a.PalletNo, |
| | | a.BindNo, |
| | | a.BoxNo, |
| | | a.SkuNo, |
| | | a.SkuName, |
| | |
| | | .Select((a, b) => new BoxInfoDto() |
| | | { |
| | | BoxNo = a.BoxNo, |
| | | BindNo = a.BindNo, |
| | | PalletNo = a.PalletNo, |
| | | Qty = SqlFunc.AggregateSum(a.Qty), |
| | | FullQty = a.FullQty, |
| | |
| | | /// <param name="boxNo">箱码</param> |
| | | /// <param name="boxNo3">支码</param> |
| | | /// <returns></returns> |
| | | public List<BoxInfoDto> GetBoxInfoByBoxNo(string boxNo, string boxNo3) |
| | | public List<BoxInfoDto> GetBoxInfoByBoxNo(string bindNo, string boxNo, string boxNo3) |
| | | { |
| | | Expression<Func<BllBoxInfo, bool>> item = Expressionable.Create<BllBoxInfo>() |
| | | .AndIF(!string.IsNullOrWhiteSpace(bindNo), it => it.BindNo == int.Parse(bindNo)) |
| | | .AndIF(!string.IsNullOrWhiteSpace(boxNo), it => it.BoxNo == boxNo.Trim()) |
| | | .AndIF(!string.IsNullOrWhiteSpace(boxNo3), it => it.BoxNo3.Contains(boxNo3.Trim())) |
| | | .And(m => m.IsDel == "0") |