| | |
| | | .LeftJoin<BllArrivalNoticeDetail>((a, b) => a.ASNDetailNo == b.Id) |
| | | .LeftJoin<SysUserInfor>((a, b, c) => a.CreateUser == c.Id) |
| | | .LeftJoin<SysUserInfor>((a, b, c, d) => a.UpdateUser == d.Id) |
| | | .LeftJoin<SysStorageLocat>((a, b, c, d, e) => a.LocatNo == e.LocatNo) |
| | | .LeftJoin<SysWareHouse>((a, b, c, d, e,f) => a.WareHouseNo == f.WareHouseNo) |
| | | //.LeftJoin<BllBoxInfo>((a, b, c, d, e, f) => a.Id == e.BindNo) |
| | | .Select((a, b, c, d,e,f) => new PalletBindDto() |
| | | //.LeftJoin<SysStorageLocat>((a, b, c, d, e) => a.LocatNo == e.LocatNo) |
| | | .LeftJoin<SysWareHouse>((a, b, c, d,f) => a.WareHouseNo == f.WareHouseNo) |
| | | .LeftJoin<SysStorageRoadway>((a, b, c, d, f,g) => a.RoadwayNo == g.RoadwayNo) |
| | | .Select((a, b, c, d,f,g) => new PalletBindDto() |
| | | { |
| | | Id = a.Id, |
| | | ASNNo = a.ASNNo, |
| | |
| | | PalletNo3 = a.PalletNo3, |
| | | LocatNo = a.LocatNo, |
| | | RoadwayNo = a.RoadwayNo, |
| | | RoadwayName = g.RoadwayName, |
| | | WareHouseNo = a.WareHouseNo, |
| | | WareHouseName = a.WareHouseNo+"-"+f.WareHouseName, |
| | | Qty = a.Qty, |