| | |
|---|
| | | { |
|---|
| | | if (!input.Code.IsNullOrEmpty()) |
|---|
| | | { |
|---|
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(q => CurPoolList.Select(q => q.SN).Contains(q.SN)).ExecuteCommand(); |
|---|
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(q => q.TRANS_CODE == req.BILLCODE).ExecuteCommand(); |
|---|
| | | //如果上一次推荐有数据，则先灭掉亮的灯 |
|---|
| | | if (Suggests.Any()) |
|---|
| | | { |
|---|
| | |
|---|
| | | Suggests.RemoveAll(q => q.poolItem.IsNullOrEmpty()); |
|---|
| | | |
|---|
| | | //保存物料池到数据库 |
|---|
| | | var db = Biz.Db; |
|---|
| | | var dbTran = db.UseTran(() => |
|---|
| | | { |
|---|
| | | db.Deleteable<WMS_ITEM_POOL>().Where(q => q.TRANS_CODE == req.BILLCODE).ExecuteCommand(); |
|---|
| | | db.Insertable(CurPoolList).ExecuteCommand(); |
|---|
| | | }); |
|---|
| | | if (!dbTran.IsSuccess) |
|---|
| | | { |
|---|
| | | throw dbTran.ErrorException; |
|---|
| | | } |
|---|
| | | Biz.Db.Insertable(CurPoolList).ExecuteCommand(); |
|---|
| | | action = await LightAll(new() { AuthOption = input.AuthOption, ReqType = ReqType.IsWhole, Color = LedColor.Blue,ItemCode = input.Code }); |
|---|
| | | } |
|---|
| | | } |
|---|
| | |
|---|
| | | //} |
|---|
| | | var MaxDC = CurPoolList.Any(x => x.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE) ? CurPoolList.Where(x => x.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE).Max(t => t.PROD_DATE) : DateTime.MinValue; |
|---|
| | | //判断系统参数是否设置先进先出 |
|---|
| | | if (Biz.SysParam["YesOrNo"].PARAM_VALUE == "Y") |
|---|
| | | if (Cache.SysParam["YesOrNo"].PARAM_VALUE == "Y") |
|---|
| | | { |
|---|
| | | if (CurInv.Items.Max(x => x.PROD_DATE).Date > MaxDC.Date) |
|---|
| | | { |
|---|
