| | |
|---|
| | | /// <param name="inspectMark">检验标记</param> |
|---|
| | | /// <param name="inspectStatus">质量状态</param> |
|---|
| | | /// <param name="locatNo">储位地址</param> |
|---|
| | | /// <param name="sortField">排序字段</param> |
|---|
| | | /// <param name="sortType">排序方式</param> |
|---|
| | | /// <returns></returns> |
|---|
| | | public List<AdventBoxInfoDto> GetEmergencyWarning(string skuNo, string skuName, string lotNo, string palletNo, string status, string inspectMark, string inspectStatus, string locatNo) |
|---|
| | | 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,c.ExpirationTime |
|---|
| | |
|---|
| | | { |
|---|
| | | str += " and a.InspectStatus = @inspectstatus"; |
|---|
| | | } |
|---|
| | | //判断质量状态是否为空 |
|---|
| | | if (!string.IsNullOrEmpty(locatNo)) |
|---|
| | | { |
|---|
| | | str += " and c.LocatNo=@locatNo"; |
|---|
| | | } |
|---|
| | | //排序 |
|---|
| | | 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 |
|---|
| | |
|---|
| | | status, //状态 |
|---|
| | | inspectmark = inspectMark, //检验标记 |
|---|
| | | inspectstatus = inspectStatus, //质量状态 |
|---|
| | | //储位地址 |
|---|
| | | locatNo = locatNo, |
|---|
| | | }); |
|---|
| | | return stockList; |
|---|
| | | } |
|---|
