| | |
|---|
| | | 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, //物料号 |
|---|
