From 5f6d23ae024a31fc6cdb272ba7024156c3bf044e Mon Sep 17 00:00:00 2001
From: YL <YL@LAPTOP-SE03PLUR>
Date: 星期三, 30 六月 2021 08:36:22 +0800
Subject: [PATCH] LAYUI版PDA：增加 设备 保养记录单模块
---
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