From 7632bb98d88c05da859ba0a6030fe0a9d3940b3d Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 27 五月 2025 13:01:21 +0800
Subject: [PATCH] 器具维护：修改和删除是判断是否已经审核，若已审核则操作失败
---
DAL/计划管理/ClsGy_ICBomBill.cs | 11 ++++++-----
1 files changed, 6 insertions(+), 5 deletions(-)
diff --git "a/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_ICBomBill.cs" "b/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_ICBomBill.cs"
index 79c75ae..c027bbd 100644
--- "a/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_ICBomBill.cs"
+++ "b/DAL/\350\256\241\345\210\222\347\256\241\347\220\206/ClsGy_ICBomBill.cs"
@@ -39,9 +39,9 @@
//鏇存柊涓昏〃
oCn.RunProc("UpDate Gy_ICBomBillMain set " +
" HBillNo='" + omodel.HBillNo + "'" +
- ",HDate='" + omodel.HDate + "'" +
- ",HYear='" + omodel.HYear.ToString() + "'" +
- ",HPeriod='" + omodel.HPeriod.ToString() + "'" +
+ //",HDate='" + omodel.HDate + "'" +
+ //",HYear='" + omodel.HYear.ToString() + "'" +
+ //",HPeriod='" + omodel.HPeriod.ToString() + "'" +
",HRemark='" + omodel.HRemark + "'" +
",HUpDater='" + omodel.HUpDater + "'" +
",HUpDateDate='" + omodel.HUpDateDate + "'" +
@@ -56,6 +56,7 @@
",HProdRate=" + omodel.HProdRate.ToString() +
",HQty=" + omodel.HQty.ToString() +
",HJump='" + omodel.HJump + "'" +
+ ",HBomType='" + omodel.HBomType + "'" +
" where HInterID=" + lngBillKey.ToString());
//鍒犻櫎鍏宠仈
DeleteRelation(ref sReturn, lngBillKey);
@@ -104,12 +105,12 @@
"(HBillType,HInterID,HBillNo,HDate" +
",HYear,HPeriod,HRemark,HMaker,HMakeDate,HMaterTypeID,HStatus" +
",HMaterID,HParentID,HVersion,HPicNo,HPropertyID" +
- ",HUnitID,HQty,HProdRate,HJump" +
+ ",HUnitID,HQty,HProdRate,HJump,HBomType" +
") " +
" values('" + this.BillType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
"," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate(),'" + omodel.HMaterTypeID.ToString() + "','" + omodel.HStatus +
"','" + omodel.HMaterID.ToString() + "'," + omodel.HParentID.ToString() + ",'" + omodel.HVersion + "','" + omodel.HPicNo + "'," +omodel.HPropertyID.ToString() +
- ","+omodel.HUnitID.ToString()+","+omodel.HQty.ToString()+","+omodel.HProdRate.ToString()+",'"+omodel.HJump +"'"+
+ ","+omodel.HUnitID.ToString()+","+omodel.HQty.ToString()+","+omodel.HProdRate.ToString()+",'"+omodel.HJump +"','"+omodel.HBomType + "'"+
") ");
//鎻掑叆瀛愯〃
foreach (Model.ClsGy_ICBomBillSub oSub in DetailColl)
--
Gitblit v1.9.1