收货单查询方法补充

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