| | |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc("UpDate Sb_EquipMaintainPlanBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== |
| | | ",HDate='" + omodel.HDate + "'" + |
| | | ",HYear='" + omodel.HYear.ToString() + "'" + |
| | | ",HPeriod='" + omodel.HPeriod.ToString() + "'" + |
| | | ",HRemark='" + omodel.HRemark + "'" + |
| | |
| | | ",HBeginDate='" + omodel.HBeginDate + "'" + |
| | | ",HEndDate='" + omodel.HEndDate+"'" + |
| | | ",HCycleUnit='" + omodel.HCycleUnit + "'" + |
| | | ",HMouldMaintainRuleID='" + omodel.HMouldMaintainRuleID + "'" + |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HExplanation='" + omodel.HExplanation+"'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo+"'" + |
| | |
| | | oCn.RunProc("Insert Into Sb_EquipMaintainPlanBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HEquipID" + |
| | | ",HBeginDate,HEndDate,HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo" + |
| | | ",HBeginDate,HEndDate,HCheckCycle,HCycleUnit,HExplanation,HInnerBillNo,HMouldMaintainRuleID" + |
| | | ") "+ |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'," + omodel.HEquipID.ToString() + |
| | | ",'" + omodel.HBeginDate +"','" +omodel.HEndDate + "'," + omodel.HCheckCycle.ToString() +",'"+ omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo +"'" + |
| | | ",'" + omodel.HBeginDate +"','" +omodel.HEndDate + "'," + omodel.HCheckCycle.ToString() +",'"+ omodel.HCycleUnit + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo +"','" + omodel.HMouldMaintainRuleID + "'" + |
| | | ") "); |
| | | if (DetailColl != null) |
| | | { |
| | |
| | | public Int64 HCheckCycle; |
| | | public string HExplanation; |
| | | public string HInnerBillNo; |
| | | public int HMouldMaintainRuleID; //ä¿å
»è§ç¨id |
| | | |
| | | |
| | | } |