| | |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | ",HMaintainLevID=" + omodel.HMaintainLevID + |
| | | ",HSafeDays=" + omodel.HSafeDays + |
| | | ",HErrWarDays=" + omodel.HErrWarDays + |
| | | ",HStandard=" + Convert.ToString(omodel.HStandard ? 1 : 0) + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //删除关联 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | oCn.RunProc("Insert Into Sb_EquipMaintainRuleBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo" + |
| | | ",HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo,HMaintainLevID,HSafeDays,HErrWarDays,HStandard" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + |
| | | "',"+ omodel.HCheckCycle.ToString() + ",'" + omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + |
| | | "') "); |
| | | "',"+ omodel.HCheckCycle.ToString() + ",'" + omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HMaintainLevID + "," + omodel.HSafeDays + "," + omodel.HErrWarDays + ", " + Convert.ToString(omodel.HStandard ? 1 : 0) + |
| | | ") "); |
| | | |
| | | //插入保养项子表 |
| | | foreach (Models.ClsSb_EquipMaintainRuleBillSub_Item Item in DetailColl_Pay) |