From bef6120383b2e8d5695f7c21d0db05681f2c7fdb Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期二, 14 十二月 2021 17:43:53 +0800
Subject: [PATCH] 新增盘点方案
---
WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs | 9 +++++----
1 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs b/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs
index 0007191..8bc97a1 100644
--- a/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs
+++ b/WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs
@@ -42,7 +42,7 @@
//
oCn.BeginTran();
//鏇存柊涓昏〃
- oCn.RunProc("UpDate Sb_EquipMaintainPlanBillMain set " +
+ oCn.RunProc("UpDate Sb_EquipMaintainRuleBillMain set " +
" HBillNo='" + omodel.HBillNo + "'" + //鍥哄畾璧嬪��===============
",HDate='" + omodel.HDate + "'" +
",HYear='" + omodel.HYear.ToString() + "'" +
@@ -83,7 +83,7 @@
//鎻掑叆閰嶄欢瀛愯〃
foreach (Models.ClsSb_EquipMaintainRuleBillSub oSub in DetailColl_Mater)
{
- oCn.RunProc("Insert into Sb_EquipMaintainRuleBillSub " +
+ string sql = "Insert into Sb_EquipMaintainRuleBillSub " +
" (HInterID,HEntryID," +
"HCloseMan,HEntryCloseDate,HCloseType,HRemark," +
"HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," +
@@ -92,8 +92,9 @@
+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() +
",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
"," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
- "," + oSub.HQty.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() +
- ") ");
+ "," + oSub.HQty.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + ",0" +
+ ") ";
+ oCn.RunProc(sql);
}
sReturn = "淇敼鍗曟嵁鎴愬姛锛�";
oCn.Commit();
--
Gitblit v1.9.1