工作任务 单据的页面里,增加 新字段 任务形态, 下拉框的方式(计划,后补,其他),新增时 默认值为 计划, 显示在 备注 字段的 右边 即可 ; HTaskType varchar(10) --任务形态(计划,后补,其他)
| | |
| | | public string HDeleteManDate; |
| | | public string HBackerDate; |
| | | public string HBackRemark; |
| | | public string HTaskType; |
| | | |
| | | public int HMainSourceInterID; |
| | | public int HMainSourceEntryID; |
| | |
| | | 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; |
| | |
| | | { |
| | | 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 + |
| | |
| | | "','" + HMainSourceBillType + |
| | | "','" + HOrderLevID + |
| | | "','"+ HTaskClassID+ |
| | | "','"+ HTaskType + |
| | | "')"; |
| | | |
| | | //涓昏〃 |
| | |
| | | "',HMainSourceBillType = '" + HMainSourceBillType + |
| | | "',HOrderLevID = '" + HOrderLevID + |
| | | "',HTaskClassID = '" + HTaskClassID + |
| | | "',HTaskType = '" + HTaskType + |
| | | "' where HInterID = " + HInterID; |
| | | |
| | | oCN.RunProc(sql); |
| | |
| | | { |
| | | 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 + |
| | |
| | | ",'" + HMainSourceBillNo + |
| | | "','" + HMainSourceBillType + |
| | | "','" + HOrderLevID + |
| | | "','" + HTaskType + |
| | | "')"; |
| | | //涓昏〃 |
| | | oCN.RunProc(sql); |