| | |
|---|
| | | /// <param name="inspectStatus">质量状态</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public List<StockDetailDto> GetBindList(string skuNo, string skuName, string palletNo, string lotNo, string boxNo, string status, |
|---|
| | | string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName, string startTime, string endTime) |
|---|
| | | string inspectMark, string bitPalletMark, string bitBoxMark, string inspectStatus, string ownerNo, string ownerName, |
|---|
| | | string startTime, string endTime, string WareHouseNo, string AreaNo) |
|---|
| | | { |
|---|
| | | string str = "select detail.*,house.WareHouseNo + '-' + house.WareHouseName as WareHouseName,roadway.RoadwayNo + '-' + roadway.RoadwayName as RoadwayName," + |
|---|
| | | "area.AreaNo + '-' + area.AreaName as AreaName " + |
|---|
| | |
|---|
| | | endTime = Convert.ToDateTime(endTime).AddDays(1).ToString(); |
|---|
| | | str += $" and detail.CompleteTime < '{endTime}'"; |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(WareHouseNo)) |
|---|
| | | { |
|---|
| | | str += $" and detail.WareHouseNo = '{WareHouseNo}'"; |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(WareHouseNo)) |
|---|
| | | { |
|---|
| | | str += $" and detail.WareHouseNo = '{WareHouseNo}'"; |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(AreaNo)) |
|---|
| | | { |
|---|
| | | str += $" and detail.AreaNo = '{AreaNo}'"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | int i = 0; |
|---|
| | | //在箱码明细中获取相应数据 |
|---|
