From 212f1d3cde3b2a3d30ef39cdde83e553cb7254f8 Mon Sep 17 00:00:00 2001
From: 王 垚 <1402714037@qq.com>
Date: 星期一, 05 九月 2022 17:29:52 +0800
Subject: [PATCH] 生产计划平台保存校验流传单号 判断是否已生成生产订单
---
MES/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 deletions(-)
diff --git a/MES/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs b/MES/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
index 987a6e0..1657a8f 100644
--- a/MES/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
+++ b/MES/src/BLL/Demo.BillView/PRD/Pro_WorkBillPlatform.cs
@@ -716,6 +716,16 @@
var fSpreadBillNoSplit = dayPlanModel.LastOrDefault().FSpreadBillNo.Split('-');
fSpreadBillNo = Convert.ToInt32(fSpreadBillNoSplit[fSpreadBillNoSplit.Length - 1]);
}
+ var fnallySpreadBillNo = "";
+ for (int i = 1; i < 100; i++)
+ {
+ fnallySpreadBillNo = $"{FSCOrderNo}-{FSRCBILLENTRYSEQ}-{fSpreadBillNo + i}";
+ string yzsql = $"select FID from T_PRD_MO where FBILLNO = '{fnallySpreadBillNo}'";
+ var yzfid = DBServiceHelper.ExecuteScalar<int>(Context, yzsql, 0);
+ if (yzfid == 0)
+ break;
+ }
+
//閫夊崟鏁版嵁 鍋氭柊澧�
JObject jsonRoot = new JObject();
jsonRoot.Add("Creator", "");
@@ -779,7 +789,8 @@
JObject jsonFPOOrderEntry = new JObject();
jsonFPOOrderEntry.Add("FHMasterDate", date.AddDays(0).ToShortDateString()); ;//涓绘棩鏈�
jsonFPOOrderEntry.Add("FHQty ", Convert.ToString(current["FT0"])); ;//鏃ヨ鍒掓暟閲�
- jsonFPOOrderEntry.Add("FSpreadBillNo", $"{FSCOrderNo}-{FSRCBILLENTRYSEQ}-{fSpreadBillNo + 1}"); //娴佷紶鍗曞彿 鐢熶骇璁㈠崟鍙�+鐢熶骇璁㈠崟鏄庣粏琛屽彿+搴忓彿mo0001-1-1
+
+ jsonFPOOrderEntry.Add("FSpreadBillNo", fnallySpreadBillNo); //娴佷紶鍗曞彿 鐢熶骇璁㈠崟鍙�+鐢熶骇璁㈠崟鏄庣粏琛屽彿+搴忓彿mo0001-1-1
Entry.Add(jsonFPOOrderEntry);
jsonModel.Add("FEntity", Entry);
--
Gitblit v1.9.1