From 5563f93c09bd957e3a08cf6314f2c4395143d238 Mon Sep 17 00:00:00 2001
From: YangYuGang <1378265336@qq.com>
Date: 星期三, 12 三月 2025 08:59:19 +0800
Subject: [PATCH] 收货单查询方法补充
---
Tiger.Business.WMS/Transaction/Yada/Count_BIZ_U9_ASN.cs | 80 ++++++++++++++++++++++++++++++++++-----
1 files changed, 69 insertions(+), 11 deletions(-)
diff --git a/Tiger.Business.WMS/Transaction/Yada/Count_BIZ_U9_ASN.cs b/Tiger.Business.WMS/Transaction/Yada/Count_BIZ_U9_ASN.cs
index 300048d..92cb0be 100644
--- a/Tiger.Business.WMS/Transaction/Yada/Count_BIZ_U9_ASN.cs
+++ b/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();
--
Gitblit v1.9.3