| | |
|---|
| | | result.WLPZBH = items.HEAD.WLPZH; |
|---|
| | | result.WLPZND = items.HEAD.WLPZND; |
|---|
| | | result.resultCode = 0; |
|---|
| | | result.resultMsg = ""; |
|---|
| | | db.CommitTran(); |
|---|
| | | simpleResults.Add(result); |
|---|
| | | } |
|---|
| | |
|---|
| | | else if (!string.IsNullOrEmpty(model.item_code)) |
|---|
| | | { |
|---|
| | | var starts = db.Queryable<CntrItemRel>().Where(cir => cir.S_CNTR_TYPE == "半托" && cir.S_ITEM_CODE == model.item_code).OrderBy(cir => cir.T_CREATE).ToList().FirstOrDefault(); |
|---|
| | | if (starts!=null) |
|---|
| | | { |
|---|
| | | LogHelper.Info($"starts{starts}"); |
|---|
| | | var starts12 = db.Queryable<LocCntrRel>().Where(lcr => lcr.S_CNTR_CODE== starts.S_CNTR_CODE).ToList().FirstOrDefault(); |
|---|
| | | LogHelper.Info($"starts1{starts12}"); |
|---|
| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | #region MyRegion |
|---|
| | | var list = db.Queryable<CntrItemRel>().Select(s => s.S_CNTR_CODE).ToArray(); |
|---|
| | | var S_LOC_CODElist = db.Queryable<LocCntrRel>().Where(s => !list.Contains(s.S_CNTR_CODE)).Select(s => s.S_LOC_CODE).ToArray(); |
|---|
| | | start = db.Queryable<Location>().Where(it => S_LOC_CODElist.Contains(it.S_CODE)).ToList().FirstOrDefault(); |
|---|
| | |
|---|
| | | |
|---|
| | | |
|---|
| | | model.cntr_code = starts12?.S_CNTR_CODE; |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | #region MyRegion |
|---|
| | | |
|---|
| | | #endregion |
|---|
| | | } |
|---|
| | | if (start == null) |
|---|
| | |
|---|
| | | var po1 = new TN_Outbound_Order { S_NO = WMSHelper.GenerateShippNo(), UNAME = po.UNAME, S_FACTORY = po.S_FACTORY, S_CBZX = po.S_CBZX, S_ZZKM = po.S_ZZKM, S_LRZX = po.S_LRZX, BLDAT = po.BLDAT, BUDAT = po.BUDAT, S_OUT_TYPE = po.S_OUT_TYPE, S_BS_TYPE = po.S_BS_TYPE, S_AREA_CODE = po.S_AREA_CODE, S_BS_NO = po.S_NO }; |
|---|
| | | List<TN_Ll_detail> tN_Ll_Details = new List<TN_Ll_detail>(); |
|---|
| | | po1.Details = new List<TN_Outbound_Detail>(); |
|---|
| | | var list = po.Details.Where(s => s.F_QTY > s.F_ACC_D_QTY).Select(s => s.S_ITEM_CODE).Distinct().ToArray(); |
|---|
| | | var Sitemlist = db.Queryable<CntrItemRel>().Where(s => list.Contains(s.S_ITEM_CODE)).Select(s => s.S_ITEM_CODE).ToArray(); |
|---|
| | | |
|---|
| | | po.Details = po.Details.Where(s => s.F_QTY > s.F_ACC_D_QTY && Sitemlist.Contains(s.S_ITEM_CODE)).ToList(); |
|---|
| | | if (po.Details.Count() > 0) |
|---|
| | | { |
|---|
| | | |
|---|
| | | foreach (var a in po.Details) |
|---|
| | | { |
|---|
| | | if (a.F_QTY > a.F_ACC_D_QTY) |
|---|
| | |
|---|
| | | return result; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | else |
|---|
| | | { |
|---|
| | | result.code = 1; |
|---|
| | | result.msg = $"领料单{po.S_NO}找不到对应库存物料信息"; |
|---|
| | | return result; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | db.CommitTran(); |
|---|
| | | } |
|---|
| | |
|---|
| | | List<JHWBackDto.ITEM> iTEMs = new List<JHWBackDto.ITEM>(); |
|---|
| | | foreach (var item in po.Details) |
|---|
| | | { |
|---|
| | | var podetail = po.Details.Where(s => s.S_ITEM_CODE == item.S_ITEM_CODE).FirstOrDefault(); |
|---|
| | | // var podetail = po.Details.Where(s => s.S_ITEM_CODE == item.S_ITEM_CODE).FirstOrDefault(); |
|---|
| | | JHWBackDto.ITEM ckbitem = new JHWBackDto.ITEM(); |
|---|
| | | ckbitem.WLBH = item.S_ITEM_CODE; |
|---|
| | | ckbitem.GC = po.S_FACTORY; |
|---|
| | | ckbitem.XSDD = podetail?.S_XSDD; |
|---|
| | | ckbitem.XSDDHXM = podetail?.S_XSDDXMBH; |
|---|
| | | ckbitem.XSDD = item?.S_XSDD; |
|---|
| | | ckbitem.XSDDHXM = item?.S_XSDDXMBH; |
|---|
| | | ckbitem.SL = item.F_QTY; |
|---|
| | | ckbitem.DW = podetail?.S_UOM; |
|---|
| | | ckbitem.DDH = podetail?.S_DDH; |
|---|
| | | ckbitem.DW = item?.S_UOM; |
|---|
| | | ckbitem.DDH = item?.S_DDH; |
|---|
| | | //ckbitem.PH = podetail?.S_PH; |
|---|
| | | // ckbitem.TSKCBS = podetail?.S_TSKCBS; |
|---|
| | | //ckbitem.DDHXM = (podetail?.N_ROW_NO); |
|---|
| | | ckbitem.WBS = podetail?.S_WBS; |
|---|
| | | ckbitem.KCDD = podetail?.S_KCDD; |
|---|
| | | ckbitem.PC = podetail?.S_BATCH_NO; |
|---|
| | | ckbitem.WBS = item?.S_WBS; |
|---|
| | | ckbitem.KCDD = item?.S_KCDD; |
|---|
| | | ckbitem.PC = item?.S_BATCH_NO; |
|---|
| | | #region MyRegion |
|---|
| | | // List<JHWBackDto.ITEM1> listitem1 = new List<JHWBackDto.ITEM1>(); |
|---|
| | | JHWBackDto.ITEM1 listitem1 = new JHWBackDto.ITEM1(); |
|---|
| | | listitem1.XLH = podetail?.S_SERIAL_NO.Split(',').ToList(); |
|---|
| | | listitem1.XLH = item?.S_SERIAL_NO.Split(',').ToList(); |
|---|
| | | ////string[] xlhValues = item.S_SERIAL_NO.Split(','); |
|---|
| | | //var serialNos = string.Join(",", CntrItemRels |
|---|
| | | // .Where(s => s.S_ITEM_CODE == item.S_ITEM_CODE) |
|---|
