From c85bd651e18603acc95f0a97c9f34326d588540b Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期五, 08 五月 2026 11:26:24 +0800
Subject: [PATCH] 修复项目穿透功能
---
WebAPI/Controllers/PM_ProjectCommunicationBillListController.cs | 14 ++++++++++++--
1 files changed, 12 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/PM_ProjectCommunicationBillListController.cs b/WebAPI/Controllers/PM_ProjectCommunicationBillListController.cs
index 91ad16c..a62e502 100644
--- a/WebAPI/Controllers/PM_ProjectCommunicationBillListController.cs
+++ b/WebAPI/Controllers/PM_ProjectCommunicationBillListController.cs
@@ -160,7 +160,7 @@
[HCusID], [HPMEmpID], [HWorkEmpID], [HProSituation], [HProRisk], [HProProgramme],
[HReportEmpID], [HOrgID]
)
- VALUES ({DateTime.Now.Year}, {DateTime.Now.Month}, '{list[0].HBillType}', '{list[0].HBillSubType}', {list[0].HInterID}, '{list[0].HDate}', '{list[0].HBillNo}', 1, 0, 0, 0, '{list[0].HRemark ?? ""}', '{list[0].HBacker ?? ""}', '{(list[0].HBackDate)}', '{list[0].HBackRemark ?? ""}', '{list[0].HChecker ?? ""}', '{(list[0].HCheckDate)}', '{list[0].HMaker ?? ""}', '{(list[0].HMakeDate)}', '{list[0].HUpDater ?? ""}', '{(list[0].HUpDateDate)}', '{list[0].HCloseMan ?? ""}', '{(list[0].HCloseDate)}', '{list[0].HCloseType }', '{list[0].HDeleteMan ?? ""}', '{(list[0].HDeleteDate)}', '{list[0].HMainSourceBillType ?? ""}', '{list[0].HMainSourceInterID}', '{list[0].HMainSourceEntryID}', '{list[0].HMainSourceBillNo ?? ""}', '{list[0].HPrintQty}', {list[0].HProjectID }, '{list[0].HProNumber ?? ""}', '{list[0].HProName ?? ""}', {list[0].HCusID }, {list[0].HPMEmpID }, {list[0].HWorkEmpID }, '{list[0].HProSituation ?? ""}', '{list[0].HProRisk ?? ""}', '{list[0].HProProgramme ?? ""}', {list[0].HReportEmpID}, {100038} );";
+ VALUES ({DateTime.Now.Year}, {DateTime.Now.Month}, '{list[0].HBillType}', '{list[0].HBillSubType}', {list[0].HInterID}, '{list[0].HDate}', '{list[0].HBillNo}', 1, 0, 0, 0, '{list[0].HRemark ?? ""}', '{list[0].HBacker ?? ""}', '{(list[0].HBackDate)}', '{list[0].HBackRemark ?? ""}', '{ ""}', '{(list[0].HCheckDate)}', '{list[0].HMaker ?? ""}', '{(list[0].HMakeDate)}', '{list[0].HUpDater ?? ""}', '{(list[0].HUpDateDate)}', '{list[0].HCloseMan ?? ""}', '{(list[0].HCloseDate)}', '{list[0].HCloseType }', '{list[0].HDeleteMan ?? ""}', '{(list[0].HDeleteDate)}', '{list[0].HMainSourceBillType ?? ""}', '{list[0].HMainSourceInterID}', '{list[0].HMainSourceEntryID}', '{list[0].HMainSourceBillNo ?? ""}', '{list[0].HPrintQty}', {list[0].HProjectID }, '{list[0].HProNumber ?? ""}', '{list[0].HProName ?? ""}', {list[0].HCusID }, {list[0].HPMEmpID }, {list[0].HWorkEmpID }, '{list[0].HProSituation ?? ""}', '{list[0].HProRisk ?? ""}', '{list[0].HProProgramme ?? ""}', {list[0].HReportEmpID}, {100038} );";
oCN.RunProc(sql);
objJsonResult.code = "0";
objJsonResult.count = 1;
@@ -180,6 +180,8 @@
",HProRisk='" + list[0].HProRisk + "'" +
",HProProgramme='" + list[0].HProProgramme + "'" +
",HReportEmpID=" + list[0].HReportEmpID +
+ ",HUpDater='" + UserName +"'"+
+ ",HUpDateDate='" + DateTime.Now +"'"+
" Where HInterID=" + list[0].HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
@@ -268,7 +270,15 @@
objJsonResult.data = null;
return objJsonResult;
}
-
+ DataSet ds=oCN.RunProcReturn("select HChecker from PM_ProjectCommunicationBillMain where HInterID=" + HInterID, "PM_ProjectCommunicationBillMain");
+ if (ds.Tables[0].Rows[0]["HChecker"] != null && ds.Tables[0].Rows[0]["HChecker"].ToString() != "")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍗曟嵁宸插鏍革紝涓嶈兘鍒犻櫎锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
oCN.BeginTran();
oCN.RunProc("delete from PM_ProjectCommunicationBillMain where HInterID = " + HInterID);
--
Gitblit v1.9.1