工作任务 单据的页面里,增加 新字段 任务形态, 下拉框的方式(计划,后补,其他),新增时 默认值为 计划, 显示在 备注 字段的 右边 即可 ; HTaskType varchar(10) --任务形态(计划,后补,其他)
1个文件已修改
9 ■■■■ 已修改文件
WebAPI/Controllers/项目管理/工作任务/PM_WorkTaskBillController.cs 9 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
WebAPI/Controllers/项目管理/工作任务/PM_WorkTaskBillController.cs
@@ -65,6 +65,7 @@
            public string HDeleteManDate;
            public string HBackerDate;
            public string HBackRemark;
            public string HTaskType;
            public int HMainSourceInterID;
            public int HMainSourceEntryID;
@@ -185,6 +186,7 @@
                string HDeleteManDate = mainList[0].HDeleteManDate;
                string HBackerDate = mainList[0].HBackerDate;
                string HBackRemark = mainList[0].HBackRemark;
                string HTaskType = mainList[0].HTaskType;
                int HMainSourceInterID = mainList[0].HMainSourceInterID;
                int HMainSourceEntryID = mainList[0].HMainSourceEntryID;
                string HMainSourceBillNo = mainList[0].HMainSourceBillNo;
@@ -212,7 +214,7 @@
                {
                    string sql = "insert into PM_WorkTaskBillMain" +
                        "(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,HOrderLevID,HTaskClassID)" +
                        ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HOrderLevID,HTaskClassID,HTaskType)" +
                        "values(" +
                        "" + HYear +
                        "," + HPeriod +
@@ -243,6 +245,7 @@
                        "','" + HMainSourceBillType +
                        "','" + HOrderLevID  +
                        "','"+ HTaskClassID+
                        "','"+ HTaskType +
                        "')";
                    //涓昏〃
@@ -281,6 +284,7 @@
                        "',HMainSourceBillType = '" + HMainSourceBillType +
                        "',HOrderLevID  = '" + HOrderLevID  +
                        "',HTaskClassID  = '" + HTaskClassID +
                        "',HTaskType  = '" + HTaskType +
                        "' where HInterID = " + HInterID;
                    oCN.RunProc(sql);
@@ -295,7 +299,7 @@
                {
                    string sql = "insert into PM_WorkTaskBillMain" +
                        "(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,HOrderLevID )" +
                        ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HOrderLevID,HTaskType )" +
                        "values(" +
                        "" + HYear +
                        "," + HPeriod +
@@ -325,6 +329,7 @@
                        ",'" + HMainSourceBillNo +
                        "','" + HMainSourceBillType +
                        "','" + HOrderLevID +
                        "','" + HTaskType +
                        "')";
                    //涓昏〃
                    oCN.RunProc(sql);