From ec45aed6396c2a65bc0b9ae1b433fa1c3f13c337 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 07 九月 2023 13:10:37 +0800 Subject: [PATCH] 任务汇报单:子表增加项目ID(HProjectID) --- WebAPI/Controllers/项目管理/工作任务/PM_WorkTaskBillController.cs | 7 +++++-- 1 files changed, 5 insertions(+), 2 deletions(-) diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" index fb58736..d5bcf69 100644 --- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" +++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" @@ -995,6 +995,7 @@ public class PM_WorkTaskReportBill_Sub { public int RowID; + public int HProjectID; public string HProNumber; public int HProjectStageID; public string HProjectStageName; @@ -1240,6 +1241,7 @@ i++; //鍚屼竴涓富琛ㄤ笅鐨勫瓙琛ㄧ殑鍐呯爜鑷 int HEntryID = i; + int HProjectID = oSub.HProjectID; string HProNumber = oSub.HProNumber; int HProjectStageID = oSub.HProjectStageID; string HName = oSub.HName; @@ -1256,13 +1258,14 @@ string sql = "insert into PM_WorkTaskReportBillSub" + - "(HInterID,HBillNo_bak,HEntryID,HRemark,HProNumber,HProjectStageID,HName,HTaskNote,HType,HRelTimes,HReportNote,HAdv,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo) " + + "(HInterID,HBillNo_bak,HEntryID,HRemark,HProjectID,HProNumber,HProjectStageID,HName,HTaskNote,HType,HRelTimes,HReportNote,HAdv,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo) " + "values(" + "" + HInterID + ",'" + HBillNo + "'," + HEntryID + ",'" + HRemark + - "','" + HProNumber + + "'," + HProjectID + + ",'" + HProNumber + "'," + HProjectStageID + ",'" + HName + "','" + HTaskNote + -- Gitblit v1.9.1