| | |
|---|
| | | /// <param name="inspectStatus">质量状态</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public List<DataBoxInfo> GetDataBoxInfo(string id, string skuNo, string skuName, string palletNo, string lotNo, |
|---|
| | | string boxNo, string status, string inspectMark, string bitBoxMark, string inspectStatus) |
|---|
| | | string boxNo, string status, string inspectMark, string bitBoxMark, string inspectStatus, string WareHouseNo, string AreaNo) |
|---|
| | | { |
|---|
| | | string str = "select PalletNo,PalletNo2,PalletNo3,BoxNo,BoxNo2,BoxNo3,Status,LotNo,Qty,FullQty,SkuNo,SkuName," + |
|---|
| | | "LotText,ProductionTime,ExpirationTime,InspectMark,BitBoxMark,InspectStatus,InspectTime from DataBoxInfo Where IsDel = @isdel"; |
|---|
| | |
|---|
| | | public List<AdventBoxInfoDto> GetEmergencyWarning(string skuNo, string skuName, string lotNo, string palletNo, string status, string inspectMark, string inspectStatus) |
|---|
| | | { |
|---|
| | | string str = @" select d.WareHouseName,d.WareHouseNo,e.RoadwayName,e.RoadwayNo,f.AreaName,f.AreaNo,c.LocatNo,a.PalletNo, |
|---|
| | | a.SkuNo,a.SkuName,SUM(a.Qty) as Qty,a.Standard,a.LotNo,a.SupplierLot,a.ProductionTime,a.Status |
|---|
| | | a.SkuNo,a.SkuName,SUM(a.Qty) as Qty,a.Standard,a.LotNo,a.SupplierLot,a.ProductionTime,a.Status,c.ExpirationTime |
|---|
| | | from DataBoxInfo a |
|---|
| | | left join SysMaterials b on a.SkuNo = b.SkuNo |
|---|
| | | left join DataStockDetail c on a.StockDetailId = c.Id |
|---|
| | |
|---|
| | | str += " and a.InspectStatus = @inspectstatus"; |
|---|
| | | } |
|---|
| | | //排序 |
|---|
| | | str += @" group by d.WareHouseName,d.WareHouseNo,e.RoadwayName,e.RoadwayNo,f.AreaName,f.AreaNo,c.LocatNo,a.PalletNo,a.SkuNo,a.SkuName,a.Standard,a.LotNo,a.SupplierLot,a.ProductionTime,a.Status order by a.SkuNo,a.LotNo "; |
|---|
| | | str += @" group by d.WareHouseName,d.WareHouseNo,e.RoadwayName,e.RoadwayNo,f.AreaName,f.AreaNo,c.LocatNo,a.PalletNo,a.SkuNo,a.SkuName,a.Standard,a.LotNo,a.SupplierLot,a.ProductionTime,a.Status,c.ExpirationTime order by a.SkuNo,a.LotNo "; |
|---|
| | | List<AdventBoxInfoDto> stockList = Db.Ado.SqlQuery<AdventBoxInfoDto>(str, new |
|---|
| | | { |
|---|
| | | skuno = skuNo, //物料号 |
|---|
