| | |
|---|
| | | /// <param name="bitBoxMark">零箱标记</param> |
|---|
| | | /// <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 WareHouseNo, string AreaNo) |
|---|
| | | 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 WareHouseNo, string AreaNo,string locatNo) |
|---|
| | | { |
|---|
| | | string str = $@"select detail.*,house.WareHouseNo+'-'+house.WareHouseName as WareHouseName,roadway.RoadwayNo+'-'+roadway.RoadwayName as RoadwayName,area.AreaNo+'-'+area.AreaName as AreaName |
|---|
| | | from DataStockDetail detail |
|---|
| | |
|---|
| | | { |
|---|
| | | str += $" and detail.AreaNo='{AreaNo}'"; |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(locatNo)) |
|---|
| | | { |
|---|
| | | str += $" and detail.LocatNo='{locatNo}'"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | int i = 0; |
|---|
| | | //在箱码明细中获取相应数据 |
|---|
