优化清点逻辑

Rodney Chen

2025-03-18 05fdade2564f0880fcba935aadf12e79a467764b

 Tiger.Business.WMS/Transaction/Yada/Count_BIZ_U9_ASN.cs

@@ -21,7 +21,7 @@
    {
        public ICount_BIZ_U9_ASN Init(string id, string userCode, string apiHost, string orgCode)
        {
            base.Init(id, apiHost, userCode, orgCode);
            base.Init(id, userCode, apiHost, orgCode);
            //加载已经清点数据
            LoadData();
            Logger.Console.Info($"Start {this.GetType().Name} Transaction[ID: {TransID}]");
@@ -41,8 +41,7 @@
      /// </summary>
      private void LoadData()
        {
            var orders = MainDB.Queryable<BIZ_U9_ASN>().Where(q => ("," + q.RECEIVER + ",").Contains("," + UserCode + ",")).ToList();
            OrderList = orders.Select(q => q.ORDER_NO).ToList();
            OrderList = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.RECEIVER == UserCode && SqlFunc.Subqueryable<BIZ_U9_ASN>().Where(s => s.ORDER_NO == q.ORDER_NO && s.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Any()).Select(q => q.ORDER_NO).ToList();
        }
        /// <summary>
        /// 扫描入口
@@ -139,7 +138,7 @@
                    {
                        action.IsSuccessed = false;
                        //action.LocaleMsg = Biz.L("物料编码[{0}]不存在或者该物料未启用");
                        action.LocaleMsg = Biz.L("WMS.Default.ScanItem.ItemCodeNotExistsOrNotActive", inv.ItemInfo.ITEM_CODE.IsNullOrEmpty(inv.Barcode.ItemCode));
                        action.LocaleMsg = Biz.L("WMS.Default.ScanItem.ItemCodeNotExistsOrNotActive", (inv.ItemInfo?.ITEM_CODE).IsNullOrEmpty(inv.Barcode.ItemCode));
                        return action;
                    }

@@ -155,8 +154,7 @@
                            AUTH_ORG = input.AuthOption.CurOrg,
                            STATUS = WMS_ITEM.STATUSs.WaitIn.GetValue(),
                            QTY = inv.Barcode.Qty.ToDouble(),
                            PROD_DATE = inv.Barcode.DateCode.ToDateTime(),
                            ERP_WH = CurScanShelf.WarehouseCode,
                            PROD_DATE = (inv.Barcode.DateCode?? DateTime.Now.ToString("yyyy-MM-dd")).ToDateTime(),
                            UNIT = inv.Barcode.Unit,
                        };

@@ -166,7 +164,6 @@
                            AUTH_ORG = input.AuthOption.CurOrg,
                            ITEM_CODE = inv.Barcode.ItemCode,
                            QTY = inv.Barcode.Qty.ToDouble(),
                            ERP_WH = CurScanShelf.WarehouseCode,
                            UNIT = inv.Barcode.Unit,
                        };

@@ -201,12 +198,12 @@
                    {
                        foreach (var item in inv.Items)
                        {
                            item.ERP_WH = CurScanShelf.WarehouseCode;
                            item.ERP_WH = "";
                            item.AUTH_ORG = input.AuthOption.CurOrg;
                        }
                        foreach (var item in inv.Packages)
                        {
                            item.ERP_WH = CurScanShelf.WarehouseCode;
                            item.ERP_WH = "";
                            item.AUTH_ORG = input.AuthOption.CurOrg;
                        }
                    }
@@ -475,11 +472,11 @@
         return Orders;
      }

      /// <summary>
      ///  设置收货单明细赠品数量
      /// </summary>
      /// <returns></returns>
      public async Task<ApiAction> SetGiftQty(BaseInput input)
        /// <summary>
        ///  生成收货单：调用U9新增收货单接口
        /// </summary>
        /// <returns></returns>
        public async Task<ApiAction> SetGiftQty(BaseInput input)
      {
         var action = new ApiAction();
         try
@@ -598,38 +595,34 @@
                     ASN_NO =asnDtl.ORDER_NO,
                     ASN_LINE_ID = item.SrcASNDocLineId.ToString(),
                     ASN_LINE = asnDtl.LINE_NO,
                            ERP_CODE = item.ItemCode1,
                  };
                        receipt.Details.Add(receiptDt);
                    }

               foreach (var item in order.SnList)
               foreach (var sn in order.SnList)
               {
                        var dtl = receipt.Details.First(q => q.ASN_LINE == item.LINE_NO);
                        var dtl = receipt.Details.First(q => q.ASN_LINE == sn.LINE_NO);
                        BIZ_U9_RECEIPT_SN receiptSn = new()
                  {

                        {
                            AUTH_ORG = dtl.AUTH_ORG,
                            ORDER_NO = dtl.ORDER_NO,
                            LINE_NO = dtl.LINE_NO,
                            SN = receipt.Details.First().ORDER_NO,
                            //META_SN
                            ITEM_CODE = dtl.ITEM_CODE,
                            STATUS = BIZ_U9_RECEIPT.STATUSs.Imported.GetValue(),
                            //  QTY
                            //UNIT 
                            //IS_OK
                            // IS_IN
                            //IS_SCRAP
                            //LOTNO
                            //CARTON_NO
                            //PALLET_NO 
                     AUTH_ORG = dtl.AUTH_ORG,
                           // REMARK = result.Data[item].Code,
                            SN = sn.SN,
                            META_SN = sn.META_SN,
                            ITEM_CODE = sn.ITEM_CODE,
                            STATUS = WMS_ITEM.STATUSs.WaitIn.GetValue(),
                            QTY = sn.QTY,
                            UNIT = sn.UNIT,
                            IS_OK = sn.IS_OK,
                            IS_IN = sn.IS_IN,
                            LOTNO = sn.LOTNO,
                            CARTON_NO = sn.CARTON_NO,
                            PALLET_NO = sn.PALLET_NO,
                        };
                        receipt.SnList.Add(receiptSn);
                    }
					
            }
               // throw new NotImplementedException();

            //更新库存表信息
            var items = MainDB.Queryable<WMS_ITEM>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && s.ORDER_NO == order.ORDER_NO).Any()).ToList();