| | |
| | | public string HWaterSupplyDate; //éæ°´æ¥æ |
| | | public string HWorkNote; //ç«£å·¥èµæï¼å¯ææ¬ï¼ |
| | | public string HWorkProcNote; //æ½å·¥å®ææ
åµï¼å¯ææ¬ï¼ |
| | | public string HProBeginDate; //å·¥ç¨å¼å·¥æ¥æ |
| | | public string HProEndDate; //å·¥ç¨å®å·¥æ¥æ |
| | | public int HProPMEmpID; //å·¥ç¨é¡¹ç®ç»ç |
| | | public string HWorkPicNumber; //竣工å¾ç¼å· |
| | | |
| | | public double HYuSuanMoney; //é¢ç®é ä»· |
| | | public double HHeTongMoney; //ååé ä»· |
| | |
| | | public double HAnZhuangMoney; //å®è£
è´¹ |
| | | public double HBanZuMoney; //çç»å·¥è´¹ |
| | | public double HYuShouKuanMoney; //颿¶æ¬¾ |
| | | public double HGongFeiMoney; //工费ç»è´¦ |
| | | public double HJieZhangMoney; //ç»ç®ç»è´¦ |
| | | public string HGongFeiMoney; //工费ç»è´¦ |
| | | public string HJieZhangMoney; //ç»ç®ç»è´¦ |
| | | |
| | | public int HTaskClassID; //ä»»å¡å¤§ç±»(Gy_TaskClass) |
| | | public int HTaskClassEntryID; //ä»»å¡é¡¹ç®åç±»(Gy_TaskClass) |
| | |
| | | string HWaterSupplyDate = mainList[0].HWaterSupplyDate; //éæ°´æ¥æ |
| | | string HWorkNote = mainList[0].HWorkNote; //ç«£å·¥èµæï¼å¯ææ¬ï¼ |
| | | string HWorkProcNote = mainList[0].HWorkProcNote; //æ½å·¥å®ææ
åµï¼å¯ææ¬ï¼ |
| | | |
| | | int HProPMEmpID = mainList[0].HProPMEmpID; //项ç®ç»ç |
| | | string HWorkPicNumber = mainList[0].HWorkPicNumber; //竣工å¾ç¼å· |
| | | string HProBeginDate = mainList[0].HProBeginDate; //项ç®å¼å·¥æ¥æ |
| | | string HProEndDate = mainList[0].HProEndDate; //项ç®å®å·¥æ¥æ |
| | | double HYuSuanMoney = mainList[0].HYuSuanMoney; //é¢ç®é ä»· |
| | | double HHeTongMoney = mainList[0].HHeTongMoney; //ååé ä»· |
| | | double HJieSuanMoney = mainList[0].HJieSuanMoney; //ç»ç®é ä»· |
| | |
| | | double HAnZhuangMoney = mainList[0].HAnZhuangMoney; //å®è£
è´¹ |
| | | double HBanZuMoney = mainList[0].HBanZuMoney; //çç»å·¥è´¹ |
| | | double HYuShouKuanMoney = mainList[0].HYuShouKuanMoney; //颿¶æ¬¾ |
| | | double HGongFeiMoney = mainList[0].HGongFeiMoney; //工费ç»è´¦ |
| | | double HJieZhangMoney = mainList[0].HJieZhangMoney; //ç»ç®ç»è´¦ |
| | | string HGongFeiMoney = mainList[0].HGongFeiMoney; //工费ç»è´¦ |
| | | string HJieZhangMoney = mainList[0].HJieZhangMoney; //ç»ç®ç»è´¦ |
| | | |
| | | int HTaskClassID = mainList[0].HTaskClassID; //ä»»å¡å¤§ç±»(Gy_TaskClass) |
| | | int HTaskClassEntryID = mainList[0].HTaskClassEntryID; //ä»»å¡é¡¹ç®åç±»(Gy_TaskClass) |
| | |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HProNumber,HProName,HCusID,HBeginDate,HEndDate,HSumMoney," + |
| | | "HProMoney,HWorkMoney,HOtherMoney,HProType,HPMEmpID,HWorkEmpID,HDepEmpID,HConWorkDays,HDepDays,HLastMoney,HPayCusID,HOrgID,HMaterID,HProjectClassID,HBuildComp,HBuildAddress,HWorkNo,HReDate,HPicNo,HWorkTask,HProjectNote,HContacts,HContactNumber" + |
| | | ",HSupplierID,HMangerEmpID,HMaterPlanDate,HWorkerID,HPlanWorkTimes,HRelWorkTimes,HTestDate,HTestCheckerID,HTestNote,HSewageDate,HWaterSupplyDate,HWorkNote,HWorkProcNote,HYuSuanMoney,HHeTongMoney,HJieSuanMoney,HShenJiMoney,HCaiLiaoMoney,HAnZhuangMoney,HBanZuMoney,HYuShouKuanMoney,HGongFeiMoney,HJieZhangMoney," + |
| | | "HTaskClassID,HTaskClassEntryID,HTaskAddress,HBreakStatus,HWaterLeakage,HPipeDiameter,HPipeMaterial,HAlarmEmp,HAlarmLink,HReceEmp,HReceTime,HTaskMaterMoney,HTaskSetupMoney,HTaskOtherMoney,HTaskExamMoney,HTaskWorkMoney,HIsAccount,HAccountDate,HAccountWorkMoneyDate,HIsCheckExam,HIsCheckWorkMoney,HInfoBackTime,HInfoBackMan,HInfoNote,HTaskBTime,HTaskETime,HTaskNote,HTaskWorkEmp,HBeginCloseValveTime,HEndCloseValveTime,HCloseValveQty,HBeginOpenValveTime,HEndOpenValveTime,HOpenValveQty,HValveWorkEmp,HTaskRemark,HDeptID)" + |
| | | "HTaskClassID,HTaskClassEntryID,HTaskAddress,HBreakStatus,HWaterLeakage,HPipeDiameter,HPipeMaterial,HAlarmEmp,HAlarmLink,HReceEmp,HReceTime,HTaskMaterMoney,HTaskSetupMoney,HTaskOtherMoney,HTaskExamMoney,HTaskWorkMoney,HIsAccount,HAccountDate,HAccountWorkMoneyDate,HIsCheckExam,HIsCheckWorkMoney,HInfoBackTime,HInfoBackMan,HInfoNote,HTaskBTime,HTaskETime,HTaskNote,HTaskWorkEmp,HBeginCloseValveTime,HEndCloseValveTime,HCloseValveQty,HBeginOpenValveTime,HEndOpenValveTime,HOpenValveQty,HValveWorkEmp,HTaskRemark,HDeptID,HProPMEmpID,HWorkPicNumber,HProBeginDate,HProEndDate)" + |
| | | "values(" + |
| | | "" + HYear + |
| | | "," + HPeriod + |
| | |
| | | ",'" + HTaskExamMoney + "'" + ",'" + HTaskWorkMoney + "'" + ",'" + (HIsAccount?1:0) + "'" + ",'" + HAccountDate + "'" + ",'" + HAccountWorkMoneyDate + "'" + ",'" + (HIsCheckExam ? 1 : 0) + "'" + |
| | | ",'" + (HIsCheckWorkMoney ? 1 : 0) + "'" + ",'" + HInfoBackTime + "'" + ",'" + HInfoBackMan + "'" + ",'" + HInfoNote + "'" + ",'" + HTaskBTime + "'" + |
| | | ",'" + HTaskETime + "'" + ",'" + HTaskNote + "'" + ",'" + HTaskWorkEmp + "'" + ",'" + HBeginCloseValveTime + "'" + ",'" + HEndCloseValveTime + "'" + |
| | | ",'" + HCloseValveQty + "'" + ",'" + HBeginOpenValveTime + "'" + ",'" + HEndOpenValveTime + "'" + ",'" + HOpenValveQty + "'" + ",'" + HValveWorkEmp + "'" + ",'" + HTaskRemark + "','" + HDeptID + "'" + |
| | | ",'" + HCloseValveQty + "'" + ",'" + HBeginOpenValveTime + "'" + ",'" + HEndOpenValveTime + "'" + ",'" + HOpenValveQty + "'" + ",'" + HValveWorkEmp + "'" + ",'" + HTaskRemark + "','" + HDeptID + "','" + HProPMEmpID + "','" + HWorkPicNumber + "','" + HProBeginDate + "','" + HProEndDate + "'"+ |
| | | ")"; |
| | | |
| | | //主表 |
| | |
| | | "',HAccountWorkMoneyDate = '" + HAccountWorkMoneyDate + "',HIsCheckExam = '" + (HIsCheckExam?1:0) + "',HIsCheckWorkMoney = '" + (HIsCheckWorkMoney?1:0) + "',HInfoBackTime = '" + HInfoBackTime + "',HInfoBackMan = '" + HInfoBackMan + "',HInfoNote = '" + HInfoNote + |
| | | "',HTaskBTime = '" + HTaskBTime + "',HTaskETime = '" + HTaskETime + "',HTaskNote = '" + HTaskNote + "',HTaskWorkEmp = '" + HTaskWorkEmp + "',HBeginCloseValveTime = '" + HBeginCloseValveTime + "',HEndCloseValveTime = '" + HEndCloseValveTime + |
| | | "',HCloseValveQty = '" + HCloseValveQty + "',HBeginOpenValveTime = '" + HBeginOpenValveTime + "',HEndOpenValveTime = '" + HEndOpenValveTime + "',HOpenValveQty = '" + HOpenValveQty + "',HValveWorkEmp = '" + HValveWorkEmp + "',HTaskRemark = '" + HTaskRemark + "',HDeptID = '" + HDeptID + "'" + |
| | | ",HProBeginDate = '" + HProBeginDate + "',HProEndDate = '" + HProEndDate + "',HProPMEmpID = '" + HProPMEmpID + "',HWorkPicNumber = '" + HWorkPicNumber + |
| | | " where HInterID = " + HInterID; |
| | | oCN.RunProc(sql); |
| | | |