| | |
| | | ",HPlanNo='" + omodel.HPlanNo + "'" + |
| | | ",HExplanation='" + omodel.HExplanation+"'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo+"'" + |
| | | ",HEquipDotCheckRuleInterID="+omodel.HEquipDotCheckRuleInterID+ |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //鍒犻櫎鍏宠仈 |
| | | DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | oCn.RunProc("Insert Into Sb_EquipDotCheckBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark,HEquipID" + |
| | | ",HBeginDate,HEndDate,HPlanNo,HExplanation,HInnerBillNo" + |
| | | ",HBeginDate,HEndDate,HPlanNo,HExplanation,HInnerBillNo,HEquipDotCheckRuleInterID" + |
| | | ") "+ |
| | | " 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.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'" + |
| | | ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "','" + omodel.HPlanNo + "','" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," +omodel.HEquipDotCheckRuleInterID.ToString()+ |
| | | ") "); |
| | | //鎻掑叆瀛愯〃 |
| | | foreach (Model.ClsSb_EquipDotCheckBillSub oSub in DetailColl) |