From 2fa45c3a43e907ad22dcfada5be88c0f31115e31 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期四, 07 九月 2023 11:10:02 +0800
Subject: [PATCH] 工作任务单：增加项目内码字段 工作任务单：记录源单信息
---
WebAPI/Controllers/项目管理/工作任务/PM_WorkTaskBillController.cs | 25 +++++++++++++++++++------
1 files changed, 19 insertions(+), 6 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 44b6bdf..fb58736 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"
@@ -29,6 +29,7 @@
{
public int HInterID;
public string HBillNo;
+ public int HProjectID;
public string HProNumber;
public string HProName;
public int HProjectStageID;
@@ -146,6 +147,7 @@
string HBillSubType = "";
int HInterID = mainList[0].HInterID;
string HBillNo = mainList[0].HBillNo;
+ int HProjectID = mainList[0].HProjectID;
string HProNumber = mainList[0].HProNumber;
string HProName = mainList[0].HProName;
int HProjectStageID = mainList[0].HProjectStageID;
@@ -199,8 +201,8 @@
if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//鏂板
{
string sql = "insert into PM_WorkTaskBillMain" +
- "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" +
- ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate)" +
+ "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProjectID,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" +
+ ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType)" +
"values(" +
"" + HYear +
"," + HPeriod +
@@ -208,7 +210,8 @@
"','" + HBillSubType +
"'," + HInterID +
",'" + HBillNo +
- "','" + HProNumber +
+ "'," + HProjectID +
+ ",'" + HProNumber +
"'," + HProjectStageID +
",'" + HName +
"','" + HDate +
@@ -224,6 +227,10 @@
"'," + HOrgID +
",'" + HMaker +
"','" + HMakerDate +
+ "'," + HMainSourceInterID +
+ "," + HMainSourceEntryID +
+ ",'" + HMainSourceBillNo +
+ "','" + HMainSourceBillType +
"')";
//涓昏〃
@@ -239,7 +246,8 @@
",HBillType = '" + HBillType +
"',HBillSubType = '" + HBillSubType +
"',HBillNo = '" + HBillNo +
- "',HProNumber = '" + HProNumber +
+ "',HProjectID = " + HProjectID +
+ ",HProNumber = '" + HProNumber +
"',HProjectStageID = " + HProjectStageID +
",HName = '" + HName +
"',HDate = '" + HDate +
@@ -255,6 +263,10 @@
"',HOrgID = " + HOrgID +
",HUpdater = '" + HUpdater +
"',HUpdateDate = '" + HUpdaterDate +
+ "',HMainSourceInterID = " + HMainSourceInterID +
+ ",HMainSourceEntryID = " + HMainSourceEntryID +
+ ",HMainSourceBillNo = '" + HMainSourceBillNo +
+ "',HMainSourceBillType = '" + HMainSourceBillType +
"' where HInterID = " + HInterID;
oCN.RunProc(sql);
@@ -267,7 +279,7 @@
}else if (OperationType == 4 && ds.Tables[0].Rows.Count == 0) //涓嬫帹
{
string sql = "insert into PM_WorkTaskBillMain" +
- "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" +
+ "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProjectID,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" +
",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType)" +
"values(" +
"" + HYear +
@@ -276,7 +288,8 @@
"','" + HBillSubType +
"'," + HInterID +
",'" + HBillNo +
- "','" + HProNumber +
+ "'," + HProjectID +
+ ",'" + HProNumber +
"'," + HProjectStageID +
",'" + HName +
"','" + HDate +
--
Gitblit v1.9.1