工作任务单：增加项目内码字段 工作任务单：记录源单信息

duhe

2023-09-07 2fa45c3a43e907ad22dcfada5be88c0f31115e31

 WebAPI/Controllers/项目管理/工作任务/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 +