收货单查询方法补充

YangYuGang

2025-03-12 5563f93c09bd957e3a08cf6314f2c4395143d238

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

@@ -9,17 +9,8 @@
using System.Threading.Tasks;
using Tiger.Model;
using Tiger.IBusiness;
using Tiger.Model.Sharetronic.Shelf;
using Tiger.Business.WMS.Sharetronic.Shelf;
using Tiger.Model.MES.Yada;
using static IronPython.SQLite.PythonSQLite;
using static Community.CsharpSqlite.Sqlite3;
using Tiger.Model.Entitys.MES.Position;
using MailKit.Search;
using static IronPython.Modules._ast;
using Tiger.Model.Entitys.MES.U9C;
using System.Security.Policy;
using Org.BouncyCastle.Asn1.X509;

namespace Tiger.Business.WMS.Transaction
{
@@ -560,7 +551,7 @@
                  aSNToRcvTransDTOs = order.Details.Select(q => new ASNToRcvTransDTO { ASNLineKey = q.ID, TransQty = new() { m_amount1 = q.QTY + q.QTY_GIFT } }).ToList(),
               }
            };
            var result = await DI.Resolve<WMS_U9C>().CreateRcvBySrcASN(iInput);
            var result = await DI.Resolve<IWMS_U9C>().CreateRcvBySrcASN(iInput);
            if (!result.IsSuccessed)
            {
               action.IsSuccessed = false;
@@ -570,7 +561,74 @@

            //根据接口返回收货单单号查询单据明细，并创建条码明细
            var receipt = new BIZ_U9_RECEIPT();
            throw new NotImplementedException();
            receipt.Details = new();
            receipt.SnList = new();
                DbClient U9Cdb = Biz.DataSource["YadaU9C"].Client;
                var list = U9Cdb.Queryable<mes_ReturnedDocInfo>().Where(x => x.RcvId == result.Data[0].ID.ToDouble() && x.DocNo == result.Data[0].Code).ToList();

            if (list != null && list.Count > 0)
            {
               receipt.AUTH_ORG = order.AUTH_ORG;
               receipt.STATUS = BIZ_U9_RECEIPT.STATUSs.InQC.GetValue();
               receipt.ORDER_NO = list.First().DocNo;
               receipt.SUPP_CODE = list.First().SupplierCode;
               receipt.SUPP_NAME = list.First().SupplierName;
               receipt.RECEIVER = UserCode;
               receipt.RECEIVE_DATE = DateTime.Now;
               receipt.ASN_ID = order.ID;
               receipt.ASN_NO = order.ORDER_NO;
               receipt.ORDER_DATE = list.First().ModifiedOn;
               receipt.HANDLED = 0;
               receipt.HANDLED_DATE = DateTime.Now;

               foreach (var item in list)
               {
                  var asnDtl = order.Details.First(q => q.ID == item.SrcASNDocLineId.ToString());
                  BIZ_U9_RECEIPT_DTL receiptDt = new()
                  {
                            AUTH_ORG = receipt.AUTH_ORG,
                            STATUS = BIZ_U9_RECEIPT.STATUSs.InQC.GetValue(),
                     ORDER_NO = item.DocNo,
                     LINE_NO = item.DocLineNo.ToString(),
                     ITEM_CODE = item.ItemCode,
                     QTY = item.RtnFillQtyTU.ToDouble(), // mes单据数量 --U9退补数量
                            QTY_GIFT = asnDtl.QTY_GIFT,
                            ASN_ID = item.SrcASNDocId.ToString(),
                     ASN_NO =asnDtl.ORDER_NO,
                     ASN_LINE_ID = item.SrcASNDocLineId.ToString(),
                     ASN_LINE = asnDtl.LINE_NO,
                  };
                        receipt.Details.Add(receiptDt);
                    }

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

                            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,
                        };
                        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();