| | |
|---|
| | | { |
|---|
| | | if (type == "1")//平库出库获取单据 |
|---|
| | | { |
|---|
| | | var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && (m.Status == "1" || m.Status == "0")).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync(); |
|---|
| | | List<string> statusList = new List<string>() { "0", "1", "2", "3" }; |
|---|
| | | var allotList = await Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && statusList.Contains(m.Status)).Select(m => m.SONo).Distinct().Where(m => !string.IsNullOrWhiteSpace(m)).ToListAsync(); |
|---|
| | | return allotList; |
|---|
| | | } |
|---|
| | | //获取状态为待拣货或者部分拣货的出库单 |
|---|
| | |
|---|
| | | { |
|---|
| | | throw Oops.Bah("单据为空，请选择单据"); |
|---|
| | | } |
|---|
| | | //获取状态为待拣货或者部分拣货的出库单 |
|---|
| | | var allotList = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.SONo == soNo && (m.Status == "0" || m.Status == "1")); |
|---|
| | | //获取状态为0待下发、1任务下发、2待拣货、3部分拣货的出库单 |
|---|
| | | List<string> statusList = new List<string>() { "0", "1", "2", "3" }; |
|---|
| | | var allotList = Db.Queryable<BllExportAllot>().Where(m => m.IsDel == "0" && m.SONo == soNo && (statusList.Contains(m.Status))); |
|---|
| | | |
|---|
| | | var list = await allotList.GroupBy(m => new { m.SODetailNo, m.SkuNo, m.SkuName, m.LotNo }).Select(m => new DetailIdSkuLotNo() |
|---|
| | | { |
|---|
