From 9debd4bde28b01a578f680f7e97872f9711a7fd5 Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期五, 11 十月 2024 13:41:25 +0800
Subject: [PATCH] 审核工艺路线时，同一个物料存在两个工艺路线，则刷新默认工艺路线
---
WebAPI/DLL/ClsSc_MouldMaintainBill.cs | 30 +++++++++++++++++++++++-------
1 files changed, 23 insertions(+), 7 deletions(-)
diff --git a/WebAPI/DLL/ClsSc_MouldMaintainBill.cs b/WebAPI/DLL/ClsSc_MouldMaintainBill.cs
index db7ec17..b41c296 100644
--- a/WebAPI/DLL/ClsSc_MouldMaintainBill.cs
+++ b/WebAPI/DLL/ClsSc_MouldMaintainBill.cs
@@ -137,18 +137,34 @@
",'" + omodel.HDeptID + "'" +
") ");
//鎻掑叆瀛愯〃
+ //foreach (Models.ClsSc_MouldMaintainBillSub oSub in DetailColl)
+ //{
+ // oCn.RunProc("Insert into Sc_MouldMaintainBillSub " +
+ // " (HInterID,HEntryID,HMaterID" +
+ // ",HQty,HUnitID" +
+ // ",HQtyMust,HManagerID,HClaim" +
+ // ",HCloseMan,HCloseType,HRemark" +
+ // ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
+ // ") values("
+ // + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaterID.ToString() +
+ // "," + oSub.HQty.ToString() + "," + oSub.HUnitID.ToString() +
+ // "," + oSub.HQtyMust.ToString() + "," + oSub.HManagerID.ToString() + ",'" + oSub.HClaim + "'" +
+ // ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
+ // "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
+ // ") ");
+ //}
foreach (Models.ClsSc_MouldMaintainBillSub oSub in DetailColl)
{
- oCn.RunProc("Insert into Sc_MouldMaintainBillSub " +
- " (HInterID,HEntryID,HMaterID" +
- ",HQty,HUnitID" +
- ",HQtyMust,HManagerID,HClaim" +
+ oCn.RunProc("Insert into Sc_MouldMaintainBillSub_Item " +
+ " (HInterID,HEntryID,HMaintainItemID" +
+ ",HMaintainItem,HMaintainPart" +
+ ",HManagerID,HClaim" +
",HCloseMan,HCloseType,HRemark" +
",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
") values("
- + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaterID.ToString() +
- "," + oSub.HQty.ToString() + "," + oSub.HUnitID.ToString() +
- "," + oSub.HQtyMust.ToString() + "," + oSub.HManagerID.ToString() + ",'" + oSub.HClaim + "'" +
+ + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaintainItemID.ToString() +
+ ",'" + oSub.HMaintainItem.ToString() + "','" + oSub.HMaintainPart.ToString() +
+ "'," + oSub.HManagerID.ToString() + ",'" + oSub.HClaim + "'" +
",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
") ");
--
Gitblit v1.9.1