From 5bbeade86d6266febdec3fd7e792dac7c43f9c94 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期五, 09 五月 2025 09:46:30 +0800
Subject: [PATCH] 来料打印更新
---
Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs | 60 ++++++++++++++++++++++++++++++++----------------------------
1 files changed, 32 insertions(+), 28 deletions(-)
diff --git a/Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs b/Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs
index 1a67a60..678579d 100644
--- a/Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs
+++ b/Tiger.Business.WMS/Transaction/Yada/Print_BIZ_U9_ASN.cs
@@ -44,7 +44,7 @@
private List<BIZ_U9_ASN_SN> CurSn = new();
List<string> SnList = new();
private string rcvDocType = "RCV03"; //榛樿鏃犲崟
- private string CurReqType = "0";
+ private string CurReqType = "0";
#endregion
#region Functions
@@ -56,12 +56,12 @@
var _Sns = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.ORDER_NO == SqlFunc.Subqueryable<BIZ_U9_ASN_DTL>().Where(s => SqlFunc.StartsWith(s.UPDATE_USER, $"GenerateASN_{UserCode}")).Select(s => s.ORDER_NO)).ToList();
CurSn.AddRange(_Sns);
OrderList = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.RECEIVER == $"{UserCode}_NoSource" && 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>
- /// 鑾峰彇褰撳墠鎵�鏈夊崟鎹俊鎭�
- /// </summary>
- /// <returns></returns>
+ /// 鑾峰彇褰撳墠鎵�鏈夊崟鎹俊鎭�
+ /// </summary>
+ /// <returns></returns>
public async Task<ApiAction<List<BIZ_U9_ASN>>> GetOrderList()
{
var action = new ApiAction<List<BIZ_U9_ASN>>();
@@ -205,13 +205,13 @@
action.Data.Data = CurOrder;
return action;
}
- if (CurSn.Any(q=> q.ORDER_NO == AsnSn.ORDER_NO && q.LINE_NO == AsnSn.LINE_NO))
+ if (CurSn.Any(q => q.ORDER_NO == AsnSn.ORDER_NO && q.LINE_NO == AsnSn.LINE_NO))
{
action.IsSuccessed = false;
action.LocaleMsg = Biz.L($"鎵弿鐨勬潯鐮佺殑ASN鍗昜{AsnSn.ORDER_NO}]鐨勮鍙穂{AsnSn.LINE_NO}]宸茬粡瀛樺湪锛岃鍏堝畬鎴愭湭瀹屾垚鐨勬搷浣�");
return action;
}
- if (!CurSn.Any(q=>q.SN == AsnSn.SN))
+ if (!CurSn.Any(q => q.SN == AsnSn.SN))
{
CurSn.Add(AsnSn);
}
@@ -245,7 +245,8 @@
{
var reqType = input.Options["reqType"].ToString();
//濡傛灉绫诲瀷涓嶄竴鏍凤紝鍒欐竻闄urOrder
- if (CurReqType != reqType) {
+ if (CurReqType != reqType)
+ {
CurOrder = null;
CurReqType = reqType;
}
@@ -254,8 +255,9 @@
{
CurOrder = await MainDB.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO == SqlFunc.Subqueryable<BIZ_U9_ASN_DTL>().Where(s => SqlFunc.StartsWith(s.UPDATE_USER, $"GenerateASN_{UserCode}_Sample")).Select(s => s.ORDER_NO)).Includes(q => q.Details, d => d._ItemInfos).IncludesAllFirstLayer().FirstAsync();
}
- CurOrder = CurOrder??new() {
- ORDER_NO= $"WASN{DateTime.Now.ToString("yyyyMMddHHmmss")}",
+ CurOrder = CurOrder ?? new()
+ {
+ ORDER_NO = $"WASN{DateTime.Now.ToString("yyyyMMddHHmmss")}",
SUPP_CODE = dtl.SUPP_CODE,
DELIVERY_DATE = DateTime.Now,
PLANARRIVED_DATE = DateTime.Now,
@@ -268,7 +270,8 @@
return action;
}
//濡傛灉娌℃湁渚涘簲鍟嗗悕绉帮紝鍒欎粠渚涘簲鍟嗚〃涓幏鍙�
- if (CurOrder.SUPP_NAME.IsNullOrEmpty()) {
+ if (CurOrder.SUPP_NAME.IsNullOrEmpty())
+ {
CurOrder.SUPP_NAME = MainDB.Queryable<BAS_SUPPLIER>().Where(q => q.SUPP_CODE == CurOrder.SUPP_CODE).First()?.SUPP_NAME_CN;
}
//if (!CurOrder.ORDER_NO.IsNullOrEmpty() && CurOrder.ORDER_NO.StartsWith("WASN") && CurOrder.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue())
@@ -278,8 +281,8 @@
// return action;
//}
- dtl.UPDATE_USER = CurReqType == "2" ? $"GenerateASN_{UserCode}_Sample": $"GenerateASN_{UserCode}";
- dtl.REMARK = CurReqType == "1"? CurSn.Where(q => q.ORDER_NO == dtl.ORDER_NO && q.LINE_NO == dtl.LINE_NO).FirstOrDefault()?.SN: dtl.REMARK;
+ dtl.UPDATE_USER = CurReqType == "2" ? $"GenerateASN_{UserCode}_Sample" : $"GenerateASN_{UserCode}";
+ dtl.REMARK = CurReqType == "1" ? CurSn.Where(q => q.ORDER_NO == dtl.ORDER_NO && q.LINE_NO == dtl.LINE_NO).FirstOrDefault()?.SN : dtl.REMARK;
dtl.ORDER_NO = CurOrder.ORDER_NO;
BIZ_U9_ASN Asn = new()
{
@@ -326,8 +329,8 @@
if (reqType == "2")
{
db.Updateable<BIZ_U9_ASN_DTL>()
- .SetColumns( it => it.LINE_NO == SqlFunc.Subqueryable<BIZ_U9_ASN_DTL>().Where(q=>q.ORDER_NO == _dtl.ORDER_NO).Select(q => (SqlFunc.AggregateMax(SqlFunc.ToInt32(q.LINE_NO)) + 10).ToString()))
- .Where(q=>q.ORDER_NO == _dtl.ORDER_NO && q.LINE_NO == _dtl.LINE_NO)
+ .SetColumns(it => it.LINE_NO == SqlFunc.Subqueryable<BIZ_U9_ASN_DTL>().Where(q => q.ORDER_NO == _dtl.ORDER_NO).Select(q => (SqlFunc.AggregateMax(SqlFunc.ToInt32(q.LINE_NO)) + 10).ToString()))
+ .Where(q => q.ORDER_NO == _dtl.ORDER_NO && q.LINE_NO == _dtl.LINE_NO)
.ExecuteCommand();
}
});
@@ -358,11 +361,11 @@
action.LocaleMsg = Biz.L($"鎴愬姛鎻愪氦ASN鍗昜{dtl.ORDER_NO}]琛屾暟鎹紝璇风偣鍑绘墦鍗版寜閽墦鍗版爣绛�");
var asnSn = MainDB.Queryable<BIZ_U9_ASN_SN>().Where(q => q.ORDER_NO == dtl.ORDER_NO && q.LINE_NO == dtl.LINE_NO && (q.STATUS == WMS_ITEM.STATUSs.Counted.GetValue() || q.STATUS == WMS_ITEM.STATUSs.Rejected.GetValue())).ToList();
- if (asnSn.Count>0 && asnSn.Sum(q => q.QTY) == dtl.QTY)
+ if (asnSn.Count > 0 && asnSn.Sum(q => q.QTY) == dtl.QTY)
{
action.IsSuccessed = false;
action.LocaleMsg = dtl.ORDER_NO.IsNullOrEmpty() ? Biz.L($"鏁版嵁涓嶅瓨鍦紒") : Biz.L($"ASN鍗昜{dtl.ORDER_NO}]琛孾{dtl.LINE_NO}]鏁版嵁宸插叏閮ㄦ彁浜ゅ畬鎴愶紝濡傛灉鏈墦鍗版爣绛捐鐐瑰嚮鎵撳嵃鎸夐挳鎵撳嵃鏍囩");
- SnList.AddRange(asnSn.Select(q=>q.SN));
+ SnList.AddRange(asnSn.Select(q => q.SN));
return action;
}
List<BIZ_U9_ASN_SN> sns = new();
@@ -374,7 +377,7 @@
foreach (var sn in snlist)
{
var strs = sn.SN.Split('/');
- var metaSn = reqType == "2" ? $"{DI.Resolve<ICodeRuleCache>()["SampleBarcode"]?.Generate(strs[0],"/", strs[1], "/").Data.ToString() ?? ""}" : DI.Resolve<ICodeRuleCache>()["NoSourceBarcode"]?.Generate($"{sn.SN}").Data.ToString() ?? "";
+ var metaSn = reqType == "2" ? $"{DI.Resolve<ICodeRuleCache>()["SampleBarcode"]?.Generate(strs[0], "/", strs[1], "/").Data.ToString() ?? ""}" : DI.Resolve<ICodeRuleCache>()["NoSourceBarcode"]?.Generate($"{sn.SN}").Data.ToString() ?? "";
SnList.Add(metaSn);
var barcode = new Barcode(metaSn);
BIZ_U9_ASN_SN info = new()
@@ -449,13 +452,13 @@
//浣跨敤缁熶竴鐨勪簨鍔B瀵硅薄
var db = GetCommitDB();
//鏁版嵁淇濆瓨閫昏緫
- db.Updateable<BIZ_U9_ASN>(UserCode).SetColumns(q => q.STATUS == BIZ_U9_ASN.STATUSs.Counting.GetValue()).Where(q => q.ORDER_NO == dtl.ORDER_NO).ExecuteCommand();
+ db.Updateable<BIZ_U9_ASN>(UserCode).SetColumns(q => new BIZ_U9_ASN() { STATUS = BIZ_U9_ASN.STATUSs.Counting.GetValue(), COMMIT_JSON = $"{reqType}" }).Where(q => q.ORDER_NO == dtl.ORDER_NO).ExecuteCommand();
db.Storageable(sns, UserCode).ExecuteCommand();
if (reqType == "2")
{
db.Updateable<BIZ_U9_ASN_SN>()
.SetColumns(q => q.LINE_NO == SqlFunc.Subqueryable<BIZ_U9_ASN_DTL>().Where(t1 => t1.ID == dtl.ID).Select(t1 => t1.LINE_NO))
- .Where(q=>sns.Select(s=>s.ID).Contains(q.ID))
+ .Where(q => sns.Select(s => s.ID).Contains(q.ID))
.ExecuteCommand();
}
@@ -495,7 +498,7 @@
try
{
var reqType = input.Options["reqType"].ToString();
- var order = await MainDB.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO == orderNo).Includes(q => q.Details, d => d._ItemInfos, e=> e.ExtInfo).IncludesAllFirstLayer().FirstAsync();
+ var order = await MainDB.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO == orderNo).Includes(q => q.Details, d => d._ItemInfos, e => e.ExtInfo).IncludesAllFirstLayer().FirstAsync();
if (order.IsNullOrEmpty())
{
action.IsSuccessed = false;
@@ -526,6 +529,7 @@
//濡傛灉鏄殢鍗曡禒鍝佹垨鑰呮牱鍝�
if (reqType.ToInt32() > 0)
{
+ rcvDocType = reqType == "2" ? "RCV03" : "RCV01";
var iInput = new CreateReceivementInput
{
userId = UserCode,
@@ -537,11 +541,11 @@
Supplier = new() { m_code = order.SUPP_CODE },
BusinessDate = DateTime.Now,
RcvDocType = new() { m_code = rcvDocType },
- RcvLines = finishNotSubmit.Select(q=> new RcvLine
+ RcvLines = finishNotSubmit.Select(q => new RcvLine
{
- ItemInfo = new() { m_itemCode = q.ITEM_CODE},
+ ItemInfo = new() { m_itemCode = q.ITEM_CODE },
Wh = new() { m_code = "10101" },
- RcvLineLocations = new(){
+ RcvLineLocations = new(){
new(){
Location = new(){ m_code= q.ItemInfo.DEFAULT_LOCATION??""},
LocationQtyTU = q.QTY,
@@ -554,7 +558,7 @@
EyeballingQtyTU = q.QTY,
RcvProcedure = q.ItemInfo.ExtInfo.ReceiptMode,
RcvLotCode = q.SUPP_LOTNO,
- InvLotCode = q.LOTNO,
+ InvLotCode = q.LOTNO,
}).ToList(),
}
},
@@ -580,7 +584,7 @@
{
ASNLineKey = q.ID,
TransQty = new() { m_amount1 = q.QTY },
- BinInfoList = new() { new() { Bin = new() { m_code = q.ItemInfo.DEFAULT_LOCATION }, LocationQtySU = q.QTY, LocationQtyTU = q.QTY } },
+ BinInfoList = new() { new() { Bin = new() { m_code = q.ItemInfo?.DEFAULT_LOCATION ?? "" }, LocationQtySU = q.QTY, LocationQtyTU = q.QTY } },
}).ToList(),
}
};
@@ -618,7 +622,7 @@
foreach (var item in list)
{
- var asnDtl = finishNotSubmit.First(q => q.ID == item.SrcASNDocLineId.ToString());
+ var asnDtl = finishNotSubmit.First(q => q.ID == item.SrcASNDocLineId.ToString() || (item.SrcASNDocLineId.ToString()=="0" && q.ITEM_CODE == item.ItemCode && q.QTY==item.RcvQtyTU));
BIZ_U9_RECEIPT_DTL receiptDt = new()
{
ID = item.RcvLineId.ToString(),
--
Gitblit v1.9.3