更新U9实体，新增业务实体

Rodney Chen

2025-03-24 459d4a2b2bd5390a5d02947e75a934207fb9ad0c

 Tiger.Business.WMS/Transaction/Old/InProductionReturn.cs

@@ -246,7 +246,7 @@
                    return action;
                }
                string billCode = barcodeScanneds?.BUSINESSCODE;
                string billCodeT = barcodeScannedsT?.BILLCODE;
                string billCodeT = barcodeScannedsT?.ORDER_NO;
                //string billLine = barcodeScanneds[0].BILLLINE;

                foreach (var item in inv.Items)
@@ -321,41 +321,41 @@
                }
                Logger.Default.Info($"更新单据明细信息:单号[{billCode}]，项次[{string.Join(",", billDetail.Select(q=>q.BILLLINE))}]，数量[{string.Join(",", billDetail.Select(q => q.INVENTORYQTY))}]，状态[{string.Join(",", billDetail.Select(q => q.LINESTATUS))}]");
                //调拨单
                var billDetailT = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.BILLCODE.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE).ToList();
                var billDetailT = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.ORDER_NO.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE).ToList();
                foreach (var dtl in billDetailT)
                {
                    dtl.INWAREHOUSECODE = putOnInfo.Warehouse.WH_CODE;
                    dtl.IN_WH_CODE = putOnInfo.Warehouse.WH_CODE;
                }
                var totalT = Biz.Db.Queryable<BIZ_WMS_TRANSFER_SN>()
                   .Where(t => t.BILLCODE.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE)
                   .Where(t => t.ORDER_NO.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE)
                   .Where(t => t.STATUS == WMS_ITEM.STATUSs.InStore.GetValue() || inv.Items.Select(q => q.SN).Contains(t.SN))
                   .Sum(x => x.QTY);
                foreach (var dtl in billDetailT)
                {
                    dtl.INQTY = total;
                    dtl.INVENTORYQTY = total;
                    dtl.QTY_IN = total;
                    //dtl.INVENTORYQTY = total;
                    if (dtl.ITEM_CODE == lotNo?.ITEM_CODE)
                    {
                        dtl.BATCH_NO_IN = WarehouseName.Contains("客供") ? lotNo.LOTNO : "";
                        dtl.BATCH_NO_OUT = WarehouseName.Contains("客供") ? lotNo.LOTNO : "";
                        dtl.IN_LOTNO = WarehouseName.Contains("客供") ? lotNo.LOTNO : "";
                        dtl.OUT_LOTNO = WarehouseName.Contains("客供") ? lotNo.LOTNO : "";
                    }
                }
                //billDetail.DELIVERYDATE = DateTime.Now.Date;
                //billDetail.QTY = total; //inv.Barcode.Qty.ToDouble();
                var isCompletedT = false;
                // 更新单据HEADER状态
                var billHeaderT = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(t => t.BILLCODE.ToUpper() == billCodeT).First();
                if (billDetailT.Sum(t => t.PRQTY) == totalT)
                var billHeaderT = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(t => t.ORDER_NO.ToUpper() == billCodeT).First();
                if (billDetailT.Sum(t => t.QTY_REQ) == totalT)
                {
                    foreach (var dtl in billDetailT)
                    {
                        dtl.LINESTATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue();
                        dtl.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue();
                    }

                    //barcodeScanned.STATUS = WMS_ITEM.STATUSs.InStore.GetValue();
                    if (!Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.BILLCODE.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE != inv.ItemInfo.ITEM_CODE && t.LINESTATUS != BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue()).Any())
                    if (!Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.ORDER_NO.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE != inv.ItemInfo.ITEM_CODE && t.STATUS != BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue()).Any())
                    {
                        billHeaderT.STATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue();
                        billHeaderT.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue();
                        isCompletedT = true;
                    }
                }
@@ -363,10 +363,10 @@
                {
                    foreach (var dtl in billDetailT)
                    {
                        dtl.LINESTATUS = BIZ_WMS_TRANSFER.STATUSs.WORKING.GetValue();
                        dtl.STATUS = BIZ_WMS_TRANSFER.STATUSs.Storing.GetValue();
                    }
                }
                Logger.Default.Info($"更新单据明细信息:单号[{billCodeT}]，项次[{string.Join(",", billDetailT.Select(q => q.BILLLINE))}]，数量[{string.Join(",", billDetailT.Select(q => q.INVENTORYQTY))}]，状态[{string.Join(",", billDetail.Select(q => q.LINESTATUS))}]");
                Logger.Default.Info($"更新单据明细信息:单号[{billCodeT}]，项次[{string.Join(",", billDetailT.Select(q => q.ORDER_LINE))}]，数量[{string.Join(",", billDetailT.Select(q => q.QTY_IN))}]，状态[{string.Join(",", billDetail.Select(q => q.LINESTATUS))}]");

                #endregion