| | |
|---|
| | | /// <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,string locatNo) |
|---|
| | | 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 str = $@"select detail.*,house.WareHouseNo+'-'+house.WareHouseName as WareHouseName,roadway.RoadwayNo+'-'+roadway.RoadwayName as RoadwayName,area.AreaNo+'-'+area.AreaName as AreaName |
|---|
| | | from DataStockDetail detail |
|---|
| | |
|---|
| | | if (!string.IsNullOrEmpty(AreaNo)) |
|---|
| | | { |
|---|
| | | str += $" and detail.AreaNo='{AreaNo}'"; |
|---|
| | | } |
|---|
| | | if (!string.IsNullOrEmpty(locatNo)) |
|---|
| | | { |
|---|
| | | str += $" and detail.LocatNo='{locatNo}'"; |
|---|
| | | } |
|---|
| | | |
|---|
| | | int i = 0; |
|---|
