| | |
| | | } |
| | | foreach (var item in items.ITEM) |
| | | { |
| | | //bool v= MaterPanduan(item.WLBM, item.SL); |
| | | // if (!v) |
| | | // { |
| | | // result.resultMsg = "失败"; |
| | | // result.WLPZBH = items.HEAD.WLPZH; |
| | | // result.resultCode = 1; |
| | | // result.WLPZND = items.HEAD.WLPZND; |
| | | // result.resultMsg = $"物料{item.WLBM}数量超过 库存总数"; |
| | | // simpleResults.Add(result); |
| | | // continue; |
| | | // } |
| | | bool v = MaterPanduan(item.WLBM, item.SL); |
| | | if (!v) |
| | | { |
| | | result.resultMsg = "失败"; |
| | | result.WLPZBH = items.HEAD.WLPZH; |
| | | result.resultCode = 1; |
| | | result.WLPZND = items.HEAD.WLPZND; |
| | | result.resultMsg = $"物料{item.WLBM}数量超过 库存总数"; |
| | | simpleResults.Add(result); |
| | | continue; |
| | | } |
| | | ///判断是否都有冲销凭证编号 |
| | | if (string.IsNullOrEmpty(item.CXPZH)) |
| | | { |
| | |
| | | po.Details = new List<TN_Inbound_Detail>(); |
| | | if (itemwlpz.ITEM.Count > 0) |
| | | { |
| | | itemwlpz.ITEM.ForEach(a => |
| | | { |
| | | foreach (var a in itemwlpz.ITEM) |
| | | |
| | | { |
| | | bool v = MaterPanduan(a.WLBM, a.SL); |
| | | if (!v) |
| | | { |
| | | result.resultMsg = "失败"; |
| | | result.WLPZBH = itemwlpz.HEAD.WLPZH; |
| | | result.resultCode = 1; |
| | | result.WLPZND = itemwlpz.HEAD.ND; |
| | | result.resultMsg = $"物料{a.WLBM}数量超过 库存总数"; |
| | | simpleResults.Add(result); |
| | | continue; |
| | | } |
| | | po.Details.Add(new TN_Inbound_Detail |
| | | { |
| | | S_IO_NO = itemwlpz.HEAD.WLPZH, |
| | |
| | | }); |
| | | //} |
| | | |
| | | }); |
| | | } |
| | | db.Insertable<TN_Inbound_Order>(po).ExecuteCommand(); |
| | | db.Insertable<TN_Inbound_Detail>(po.Details).ExecuteCommand(); |
| | | db.CommitTran(); |
| | |
| | | var Details = new List<TN_Inbound_Detail>(); |
| | | if (itemwlpz.ITEM.Count > 0) |
| | | { |
| | | itemwlpz.ITEM.ForEach(a => |
| | | foreach (var a in itemwlpz.ITEM) |
| | | { |
| | | bool v = MaterPanduan(a.WLBM, a.SL); |
| | | if (!v) |
| | | { |
| | | result.resultMsg = "失败"; |
| | | result.WLPZBH = itemwlpz.HEAD.WLPZH; |
| | | result.resultCode = 1; |
| | | result.WLPZND = itemwlpz.HEAD.ND; |
| | | result.resultMsg = $"物料{a.WLBM}数量超过 库存总数"; |
| | | simpleResults.Add(result); |
| | | continue; |
| | | } |
| | | if (po.Details.Where(s => s.S_ITEM_CODE == a.WLBM).Count() > 0) |
| | | { |
| | | var poq = po.Details.Where(s => s.S_ITEM_CODE == a.WLBM).FirstOrDefault(); |
| | |
| | | }); |
| | | } |
| | | |
| | | }); |
| | | } |
| | | db.Insertable<TN_Inbound_Detail>(Details).ExecuteCommand(); |
| | | db.CommitTran(); |
| | | |
| | |
| | | po.Details = new List<TN_Inbound_Detail>(); |
| | | if (itemwlpz.ITEM.Count > 0) |
| | | { |
| | | itemwlpz.ITEM.ForEach(a => |
| | | foreach (var a in itemwlpz.ITEM) |
| | | |
| | | { |
| | | bool v = MaterPanduan(a.WLBH, a.SL); |
| | | if (!v) |
| | | { |
| | | result.resultMsg = "失败"; |
| | | result.WLPZBH = itemwlpz.HEAD.WLPZBH; |
| | | result.resultCode = 1; |
| | | result.WLPZND = itemwlpz.HEAD.WLPZNF; |
| | | result.resultMsg = $"物料{a.WLBH}数量超过 库存总数"; |
| | | simples.Add(result); |
| | | continue; |
| | | } |
| | | #region 不需要 |
| | | //if (a.ITEM1.Select(s => s.XLH).Count() > 0)//判断序列号是否为多个 |
| | | //{ |
| | |
| | | }); |
| | | //} |
| | | |
| | | }); |
| | | } |
| | | db.Insertable<TN_Inbound_Order>(po).ExecuteCommand(); |
| | | db.Insertable<TN_Inbound_Detail>(po.Details).ExecuteCommand(); |
| | | db.CommitTran(); |
| | |
| | | var Details = new List<TN_Inbound_Detail>(); |
| | | if (itemwlpz.ITEM.Count > 0) |
| | | { |
| | | itemwlpz.ITEM.ForEach(a => |
| | | foreach (var a in itemwlpz.ITEM) |
| | | |
| | | { |
| | | bool v = MaterPanduan(a.WLBH, a.SL); |
| | | if (!v) |
| | | { |
| | | result.resultMsg = "失败"; |
| | | result.WLPZBH = itemwlpz.HEAD.WLPZBH; |
| | | result.resultCode = 1; |
| | | result.WLPZND = itemwlpz.HEAD.WLPZNF; |
| | | result.resultMsg = $"物料{a.WLBH}数量超过 库存总数"; |
| | | simples.Add(result); |
| | | continue; |
| | | } |
| | | if (po.Details.Where(s => s.S_ITEM_CODE == a.WLBH).Count() > 0) |
| | | { |
| | | var poq = po.Details.Where(s => s.S_ITEM_CODE == a.WLBH).FirstOrDefault(); |
| | |
| | | }); |
| | | } |
| | | |
| | | }); |
| | | } |
| | | db.Insertable<TN_Inbound_Detail>(Details).ExecuteCommand(); |
| | | db.CommitTran(); |
| | | |
| | |
| | | .LeftJoin<CntrItemRel>((lcr, cir) => lcr.S_CNTR_CODE == cir.S_CNTR_CODE&&cir.S_CNTR_TYPE=="半托") |
| | | .Where((lcr, cir) => cir.S_CNTR_CODE != null) |
| | | .LeftJoin<Location>((lcr, cir, loc) => lcr.S_LOC_CODE == loc.S_CODE && loc.S_AREA_CODE == "HJQ") |
| | | .OrderBy((lcr, cir) => cir.T_CREATE) |
| | | .Select((lcr, cir, loc) => loc).ToList() // 返回 Location 对象 |
| | | .FirstOrDefault(); // 或者 Take(1).ToList()[0] |
| | | } |