| | |
|---|
| | | 锘縰sing AutoMapper; |
|---|
| | | 锘縰sing Autofac.Core; |
|---|
| | | using AutoMapper; |
|---|
| | | using SqlSugar; |
|---|
| | | using WIDESEA_Common.LocationEnum; |
|---|
| | | using WIDESEA_Common.StockEnum; |
|---|
| | |
|---|
| | | public List<Dt_StockInfo> GetStockInfos(string materielCode, string lotNo, string supplyCode, List<string> locationCodes) |
|---|
| | | { |
|---|
| | | var query = Db.Queryable<Dt_StockInfo>() |
|---|
| | | .Where(x => locationCodes.Contains(x.LocationCode) |
|---|
| | | .Where(x => locationCodes.Contains(x.LocationCode) && x.StockStatus==StockStatusEmun.鍏ュ簱瀹屾垚.ObjToInt() |
|---|
| | | // && x.StockStatus == (int)StockStatusEmun.姝ｅ父) |
|---|
| | | ).Includes(x => x.Details); |
|---|
| | | |
|---|
| | |
|---|
| | | // } |
|---|
| | | |
|---|
| | | //} |
|---|
| | | public List<StockSelectViewDTO> GetSelectViewDTOs(string orderNo,string materielCode) |
|---|
| | | { |
|---|
| | | var outboundOrder = SqlSugarHelper.DbWMS.Queryable<Dt_OutboundOrder>().Where(x => x.UpperOrderNo == orderNo).First(); |
|---|
| | | return GetStockSelectViews(outboundOrder.Id, materielCode); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public List<StockSelectViewDTO> GetStockSelectViews(int orderId, string materielCode) |
|---|
| | | { |
|---|
