|  |  | 
 |  |  |                 ",HExplanation='" + omodel.HExplanation + "'" + | 
 |  |  |                 ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + | 
 |  |  |                 ",HRepairContent='" + omodel.HRepairContent + "'" + | 
 |  |  |                 ",HMainSourceBillType='"+ omodel.HMainSourceBillType+"'"+ | 
 |  |  |                 ",HMainSourceInterID="+ omodel.HMainSourceInterID.ToString()+ | 
 |  |  |                 ",HMainSourceEntryID="+ omodel.HMainSourceEntryID.ToString()+ | 
 |  |  |                 ",HCycleUnit='" + omodel.HCycleUnit + "'" + | 
 |  |  |                  | 
 |  |  |                 " where HInterID=" + lngBillKey.ToString()); | 
 |  |  | 
 |  |  |                        ") values(" | 
 |  |  |                        + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + | 
 |  |  |                        "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + | 
 |  |  |                       "," + oSub.HRepairID1.ToString() + ",'"+ oSub.HManagerID1.ToString() + "','" + oSub.HRepairExplanation + "'," + oSub.HEmpID.ToString() +  | 
 |  |  |                       "," + oSub.HRepairID.ToString() + ",'"+ oSub.HManagerID.ToString() + "','" + oSub.HRepairExplanation + "'," + oSub.HEmpID.ToString() +  | 
 |  |  |                        ") "); | 
 |  |  |                 } | 
 |  |  |                 // | 
 |  |  | 
 |  |  |                 "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + | 
 |  |  |                 ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + | 
 |  |  |                 ",HEquipID,HRepairID,HPlanTimes,HEmpID,HManagerID,HTimes" + | 
 |  |  |                 ",HDeptID,HExplanation,HInnerBillNo,HRepairBeginDate,HRepairEndDate,HRepairContent,HCycleUnit" + | 
 |  |  |                 ",HDeptID,HExplanation,HInnerBillNo,HRepairBeginDate,HRepairEndDate,HRepairContent,HCycleUnit,HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID" + | 
 |  |  |                 ") " + | 
 |  |  |                 " values('" + this.BillType + "','"  + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + | 
 |  |  |                 ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + | 
 |  |  |                 ", " + omodel.HEquipID.ToString() + "," + omodel.HRepairID.ToString() + "," + omodel.HPlanTimes.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HTimes.ToString() + | 
 |  |  |                 ", " + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','" + omodel.HRepairBeginDate.ToShortDateString() + "','" + omodel.HRepairEndDate.ToShortDateString() + "','" + omodel.HRepairContent + "','" + omodel.HCycleUnit + "'" + | 
 |  |  |                 ", " + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','" + omodel.HRepairBeginDate.ToShortDateString() + "','" + omodel.HRepairEndDate.ToShortDateString() + "','" + omodel.HRepairContent + "','" + omodel.HCycleUnit + "','" + | 
 |  |  |                  omodel.HMainSourceBillType+"',"+ omodel.HMainSourceInterID.ToString()+","+ omodel.HMainSourceEntryID.ToString() + | 
 |  |  |                 ") "); | 
 |  |  |                 //插入子表 | 
 |  |  |                 foreach (Models.ClsSb_EquipRepairWorkBillSub oSub in DetailColl) | 
 |  |  | 
 |  |  |                        ") values(" | 
 |  |  |                        + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + | 
 |  |  |                        "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + | 
 |  |  |                       "," + oSub.HRepairID1.ToString() + ",'" + oSub.HManagerID1.ToString() + "','" + oSub.HRepairExplanation + "'," + oSub.HEmpID.ToString() + | 
 |  |  |                       "," + oSub.HRepairID.ToString() + ",'" + oSub.HManagerID.ToString() + "','" + oSub.HRepairExplanation + "'," + oSub.HEmpID.ToString() + | 
 |  |  |                        ")"); | 
 |  |  |                     oCn.RunProc("Insert into Sb_EquipRepairWorkBillSub " + | 
 |  |  |                        " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + | 
 |  |  | 
 |  |  |                        ") values(" | 
 |  |  |                        + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + | 
 |  |  |                        "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + | 
 |  |  |                       "," + oSub.HRepairID1.ToString() + ",'"+ oSub.HManagerID1.ToString() + "','" + oSub.HRepairExplanation + "'," + oSub.HEmpID.ToString() + | 
 |  |  |                       "," + oSub.HRepairID.ToString() + ",'"+ oSub.HManagerID.ToString() + "','" + oSub.HRepairExplanation + "'," + oSub.HEmpID.ToString() + | 
 |  |  |                        ") "); | 
 |  |  |                 } | 
 |  |  |                 // | 
 |  |  | 
 |  |  |                     //=================================================== | 
 |  |  |                      | 
 |  |  |                     oSub.HRepairExplanation = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HRepairExplanation"]); | 
 |  |  |                     oSub.HRepairID1 = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HRepairID"]); | 
 |  |  |                     oSub.HRepairID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HRepairID"]); | 
 |  |  |                     oSub.HEmpID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEmpID"]); | 
 |  |  |  | 
 |  |  |  |