From fddd1f3d621a1947d698652c72b6a16cc3f6ee2d Mon Sep 17 00:00:00 2001
From: hudong <Administrator@PC-20250329JZUF>
Date: 星期二, 24 六月 2025 17:07:51 +0800
Subject: [PATCH] 增加 审核表 审核逻辑优化 出入库逻辑修改
---
api/WmsSpaHelper.cs | 177 +++++++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 142 insertions(+), 35 deletions(-)
diff --git a/api/WmsSpaHelper.cs b/api/WmsSpaHelper.cs
index 616cc30..6589bf4 100644
--- a/api/WmsSpaHelper.cs
+++ b/api/WmsSpaHelper.cs
@@ -1009,7 +1009,7 @@
{
var result = new SimpleResult();
//鍒ゆ柇鍐查攢鍑瘉缂栧彿 鏄惁涓虹┖ 濡傛灉涓虹┖ 鍒欎负鍐查攢(瀹℃牳鍓嶆墠鑳藉啿閿�紝闈炲緟鎵ц鐘舵�鎻愮ず鎵ц涓笉鍙啿閿� 涓嶄负绌�鍒欎负澶栭噰鍏ュ簱
- if ((itemwlpz.HEAD.YDLX == "351" || itemwlpz.HEAD.YDLX == "Z89") && itemwlpz.ITEM[0].FHGC == "3040")
+ if (itemwlpz.ITEM[0].JDBS=="H" && itemwlpz.ITEM[0].GC == "3040")
{
var po = db.Queryable<TN_Ll_Order>().Includes(a => a.Details).Where(s => s.S_NO == itemwlpz.HEAD.WLPZH).First();
//鍒涘缓鍑哄簱鍗曚富瀛愯〃
@@ -1245,7 +1245,7 @@
}
#endregion
}
- else if ((itemwlpz.HEAD.YDLX == "351" || itemwlpz.HEAD.YDLX == "Z89") && itemwlpz.ITEM[0].GC == "3040")
+ else if (itemwlpz.ITEM[0].JDBS == "S" && itemwlpz.ITEM[0].GC == "3040")
{
//鍒涘缓鍏ュ簱鍗曚富瀛愯〃
var po = WMSHelper.GetInboundOrder(itemwlpz.HEAD.WLPZH);
@@ -1733,6 +1733,8 @@
/// <returns></returns>
internal static SimpleResult InboundOrderSorting(MPSorting model)
{
+
+
var result = new SimpleResult();
foreach (var a in model.MaterList)
{
@@ -1747,6 +1749,27 @@
// var db = new SqlHelper<object>().GetInstance();
using (var db = new SqlHelper<object>().GetInstance())
{
+ Location endloc = new Location();
+ var hwbd = db.Queryable<TN_Container_Code>().Where(a => a.S_CNTR_CODE == model.cntr_code).First();
+ if (hwbd!=null)
+ {
+ endloc = db.Queryable<Location>().Where(a => a.S_CODE == hwbd.S_LOC_CODE).First();
+ if (endloc?.N_LOCK_STATE != 0)
+ {
+ result.resultCode = 3;
+ result.resultMsg = $"缁堢偣搴撲綅宸查攣/涓嶅瓨鍦�;
+ return result;
+ }
+ }
+ else
+ {
+ result.resultCode = 3;
+ result.resultMsg = $"{model.cntr_code}鎵樼洏鎵句笉鍒拌揣浣�;
+ return result;
+ }
+
+
+
var locinfo = db.Queryable<Location>().Where(a => a.S_CODE == model.start).First();
if (locinfo?.N_LOCK_STATE != 0)
@@ -1819,7 +1842,9 @@
S_START_LOC = model.start,
S_START_AREA = locinfo.S_AREA_CODE,
S_START_WH = locinfo.S_WH_CODE,
- S_END_LOC = model.start,
+ S_END_LOC = endloc.S_CODE,
+ S_END_AREA = endloc.S_AREA_CODE,
+ S_END_WH = endloc.S_WH_CODE,
S_BS_NO = model.MaterList[0].arrival_no,
N_TYPE = 1,
S_TYPE = WMSTask.GetTypeStr(1),
@@ -2000,26 +2025,42 @@
if (!string.IsNullOrEmpty(model.cntr_code))
{
- #region MyRegion
- //var list = db.Queryable<CntrItemRel>().Select(s => s.S_CNTR_CODE).ToArray();
- //var S_LOC_CODElist = db.Queryable<LocCntrRel>().Where(s=>!list.Contains(s.S_CNTR_CODE)).Select(s=>s.S_LOC_CODE).ToArray();
- //start = db.Queryable<Location>().Where(it => S_LOC_CODElist.Contains(it.S_CODE)).First();
+ var hwbd = db.Queryable<TN_Container_Code>().Where(a => a.S_CNTR_CODE == model.cntr_code).First();
+ if (hwbd!=null)
+ {
+ end = db.Queryable<Location>().Where(s => s.S_CODE == hwbd.S_LOC_CODE).First();
+ }
+ else
+ {
- //// 鑾峰彇鎵�湁琚崰鐢ㄧ殑瀹瑰櫒缂栫爜
- //var usedContainerCodes = db.Queryable<CntrItemRel>().Select(s => s.S_CNTR_CODE).ToList();
+ #region MyRegion
+ //var list = db.Queryable<CntrItemRel>().Select(s => s.S_CNTR_CODE).ToArray();
+ //var S_LOC_CODElist = db.Queryable<LocCntrRel>().Where(s=>!list.Contains(s.S_CNTR_CODE)).Select(s=>s.S_LOC_CODE).ToArray();
+ //start = db.Queryable<Location>().Where(it => S_LOC_CODElist.Contains(it.S_CODE)).First();
- // 鑾峰彇鏈鍗犵敤鐨勫鍣ㄥ搴旂殑璐т綅缂栫爜
- var availableLocationCodes = db.Queryable<LocCntrRel>()
- .Select(s => s.S_LOC_CODE)
- .ToList();
+ //// 鑾峰彇鎵�湁琚崰鐢ㄧ殑瀹瑰櫒缂栫爜
+ //var usedContainerCodes = db.Queryable<CntrItemRel>().Select(s => s.S_CNTR_CODE).ToList();
+ #endregion
+ // 鑾峰彇鏈鍗犵敤鐨勫鍣ㄥ搴旂殑璐т綅缂栫爜
+ var availableLocationCodes = db.Queryable<LocCntrRel>()
+ .Select(s => s.S_LOC_CODE)
+ .ToList();
// 鑾峰彇绗竴涓彲鐢ㄨ揣浣嶏紙濡傛灉娌℃湁鍒欒繑鍥瀗ull锛� end = db.Queryable<Location>()
.Where(it => !availableLocationCodes.Contains(it.S_CODE) && it.S_AREA_CODE == "HJQ")
.ToList().FirstOrDefault();
+ if (end!=null)
+ {
+ TN_Container_Code tN_Container_Code = new TN_Container_Code();
+ tN_Container_Code.S_CNTR_CODE= model.cntr_code;
+ tN_Container_Code.S_LOC_CODE = end.S_CODE;
+ var sss = db.Insertable<TN_Container_Code>(tN_Container_Code).ExecuteCommand();
+ }
- #endregion
+ }
+
}
else
{
@@ -2298,7 +2339,7 @@
else
{
db.Updateable(cir).UpdateColumns(it => new { it.F_QTY, it.S_CNTR_TYPE, it.F_ALLOC_QTY, it.T_MODIFY }).ExecuteCommand();
- //娣诲姞鍥炲簱浣滀笟
+
}
}
else
@@ -2346,6 +2387,26 @@
result.resultMsg += $"浠诲姟{locs.S_CODE}鏉ユ簮鍙穥locs.S_BS_NO}鎵句笉鍒伴厤鐩樹俊鎭�;
return result;
}
+ Location endloc = new Location();
+ var hwbd = db.Queryable<TN_Container_Code>().Where(a => a.S_CNTR_CODE == cntr_code).First();
+ if (hwbd != null)
+ {
+ endloc = db.Queryable<Location>().Where(a => a.S_CODE == hwbd.S_LOC_CODE).First();
+ if (endloc?.N_LOCK_STATE != 0)
+ {
+ result.resultCode = 3;
+ result.resultMsg = $"缁堢偣搴撲綅宸查攣/涓嶅瓨鍦�;
+ return result;
+ }
+
+ }
+ else
+ {
+ result.resultCode = 3;
+ result.resultMsg = $"{cntr_code}鎵樼洏鎵句笉鍒拌揣浣�;
+ return result;
+ }
+
//var location = db.Queryable<Location>().Where(a => a.S_CODE == locs.S_LOC_CODE).First();
var wmsTask = new WMSTask
{
@@ -2355,12 +2416,12 @@
S_START_AREA = startinfo.S_AREA_CODE,
S_START_WH = startinfo.S_WH_CODE,
- S_END_LOC = start,
- S_END_AREA = startinfo.S_AREA_CODE,
- S_END_WH = startinfo.S_AREA_CODE,
- //S_END_LOC = locs?.S_START_LOC,
- //S_END_AREA = locs?.S_START_AREA,
- //S_END_WH = locs?.S_START_WH,
+ //S_END_LOC = start,
+ //S_END_AREA = startinfo.S_AREA_CODE,
+ //S_END_WH = startinfo.S_AREA_CODE,
+ S_END_LOC = endloc?.S_CODE,
+ S_END_AREA = endloc?.S_AREA_CODE,
+ S_END_WH = endloc?.S_WH_CODE,
N_TYPE = 1,
// S_TYPE = WMSTask.GetTypeStr(1),
@@ -4324,7 +4385,7 @@
List<TN_Inbound_Detail> tN_Inbound_Details = new List<TN_Inbound_Detail>();
po.Details = po.Details.Where(d => model.Wlist.Any(w =>
w.S_ITEM_CODE == d.S_ITEM_CODE &&
- w.N_ROW_NO == d.N_ROW_NO))
+ w.N_ROW_NO == d.N_ROW_NO)).OrderBy(s => s.N_ROW_NO)
.ToList();
if (po.S_IN_TYPE == "鍐呴噰鍏ュ簱")
{
@@ -4364,6 +4425,13 @@
tN_Inbound_Details.Add(item);
}
+ string combinedIds= string.Join(",", po.Details.Select(x => x.N_ROW_NO));
+ var KEY = WCSHelper.Generate13DigitIds();
+ var s_key= db.Queryable<TN_InBounder_Sh>().Where(a => a.S_NO == model.S_NO&&a.N_ROW_NO == combinedIds).First();
+ if (s_key!=null)
+ {
+ KEY = s_key.S_KEY;
+ }
NcRkDto.Root roots = new NcRkDto.Root
{
ROOT = new NcRkDto.ROOT
@@ -4373,9 +4441,9 @@
HEAD = new NcRkDto.HEAD
{
- KEY = po.S_NO,
+ KEY = KEY,
GZRQ = DateTime.Now.ToString("yyyyMMdd"),
- GZRY = model.GZRY,
+ GZRY = model.GZRY,//GenerateTaskNo
WLPZBH = po.S_NO,
WLPZND = po.S_WLPZND
},
@@ -4390,8 +4458,7 @@
var json = JsonConvert.SerializeObject(roots.ROOT);
string xml = JsonConvert.DeserializeXmlNode(json, "ROOT").OuterXml;
- // 鐜板湪 root 瀵硅薄鍖呭惈浜嗘偍瀹氫箟鐨勫亣鏁版嵁
- // 鍙戦�POST璇锋眰
+
LogHelper.Info($"鍐呴噰鏀惰揣xml鏁版嵁{xml}");
#region MyRegion
@@ -4449,15 +4516,9 @@
//娣诲姞鍑瘉璁板綍琛� result.resultMsg = data.ROOT.ITEM.MSGDESP;
result.resultCode = data.ROOT.ITEM.MSGCODE;
- //MaterialVoucher materialVoucher = new MaterialVoucher();
if (data.ROOT.ITEM.MSGCODE == 0)
{
- //materialVoucher.S_NO = model.S_NO;
- //materialVoucher.S_TYPE = po.S_IN_TYPE;
- //materialVoucher.S_WLPZBH = data.ROOT.ITEM.WLPZH;
- //materialVoucher.S_WLPZND = data.ROOT.ITEM.WLPZND;
- //materialVoucher.STATUS = 0;
- //db.Insertable<MaterialVoucher>(materialVoucher).ExecuteCommand();
+
List<MaterialVoucher> materials = new List<MaterialVoucher>();
foreach (var item in model.Wlist)
{
@@ -4478,6 +4539,16 @@
db.Insertable<MaterialVoucher>(materials).ExecuteCommand();
}
}
+ else
+ {
+
+ TN_InBounder_Sh tN_InBounder_Sh = new TN_InBounder_Sh();
+ tN_InBounder_Sh.S_KEY = KEY;
+ tN_InBounder_Sh.N_ROW_NO = combinedIds;
+ tN_InBounder_Sh.S_NO = po.S_NO;
+ db.Insertable<TN_InBounder_Sh>(tN_InBounder_Sh).ExecuteCommand();
+
+ }
}
@@ -4496,13 +4567,20 @@
PZZDRQ = DateTime.Parse(po.BLDAT.ToString()).ToString("yyyyMMdd");
}
+ string combinedIds = string.Join(",", po.Details.Select(x => x.N_ROW_NO));
+ var KEY = WCSHelper.Generate13DigitIds();
+ var s_key = db.Queryable<TN_InBounder_Sh>().Where(a => a.S_NO == model.S_NO && a.N_ROW_NO == combinedIds).First();
+ if (s_key != null)
+ {
+ KEY = s_key.S_KEY;
+ }
JHWBackDto.Root myRoot = new JHWBackDto.Root
{
ROOT = new JHWBackDto.ROOT
{
HEAD = new JHWBackDto.HEAD
{
- KEY = po.S_NO,
+ KEY = KEY,
GZRQ = GZRQ,
PZZDRQ = PZZDRQ,
YHM = po.UNAME,
@@ -4517,6 +4595,7 @@
}
};
+
//鍥炲弬鐗╂枡淇℃伅
List<JHWBackDto.ITEM> iTEMs = new List<JHWBackDto.ITEM>();
foreach (var item in po.Details)
@@ -4627,6 +4706,17 @@
db.Insertable<MaterialVoucher>(materials).ExecuteCommand();
}
}
+ else
+ {
+
+ TN_InBounder_Sh tN_InBounder_Sh = new TN_InBounder_Sh();
+ tN_InBounder_Sh.S_KEY = KEY;
+ tN_InBounder_Sh.N_ROW_NO = combinedIds;
+ tN_InBounder_Sh.S_NO = po.S_NO;
+ db.Insertable<TN_InBounder_Sh>(tN_InBounder_Sh).ExecuteCommand();
+
+ }
+
#endregion
}
@@ -4668,6 +4758,13 @@
tN_Inbound_Details.Add(item);
}
+ string combinedIds = string.Join(",", po.Details.Select(x => x.N_ROW_NO));
+ var KEY = WCSHelper.Generate13DigitIds();
+ var s_key = db.Queryable<TN_InBounder_Sh>().Where(a => a.S_NO == model.S_NO && a.N_ROW_NO == combinedIds).First();
+ if (s_key != null)
+ {
+ KEY = s_key.S_KEY;
+ }
WcRkBc.Root roots = new WcRkBc.Root
{
ROOT = new WcRkBc.ROOT
@@ -4676,7 +4773,7 @@
{
HEAD = new WcRkBc.HEAD
{
- KEY = po.S_NO,
+ KEY = KEY,
GZRQ = DateTime.Now.ToString("yyyyMMdd"),
GZRY = model.GZRY,
GC = po.S_FACTORY
@@ -4773,6 +4870,16 @@
}
}
+ else
+ {
+
+ TN_InBounder_Sh tN_InBounder_Sh = new TN_InBounder_Sh();
+ tN_InBounder_Sh.S_KEY = KEY;
+ tN_InBounder_Sh.N_ROW_NO = combinedIds;
+ tN_InBounder_Sh.S_NO = po.S_NO;
+ db.Insertable<TN_InBounder_Sh>(tN_InBounder_Sh).ExecuteCommand();
+
+ }
}
--
Gitblit v1.9.1