| | |
| | | //",HGroupID=" + omodel.HGroupID.ToString() + |
| | | //",HWHID=" + omodel.HWHID.ToString() + |
| | | //",HSCWHID=" + omodel.HSCWHID.ToString() + |
| | | ",HEquipDotCheckRuleInterID='" + omodel.HEquipDotCheckRuleInterID + "'" + |
| | | ",HMouldMaintainRuleID='" + omodel.HMouldMaintainRuleID + "'" + |
| | | ",HCycleUnit='" + omodel.HCycleUnit + "'" + |
| | | ",HCheckCycle=" + omodel.HCheckCycle.ToString() + |
| | | ",HBeginDate='" + omodel.HBeginDate + "'" + |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" + |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HCycleUnit,HCheckCycle,HBeginDate,HEndDate"+ |
| | | ",HInnerBillNo,HExplanation,HEquipDotCheckRuleInterID" + |
| | | ",HInnerBillNo,HExplanation,HMouldMaintainRuleID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'"+ |
| | | ",'" + omodel.HCycleUnit + "'," + omodel.HCheckCycle.ToString() + ",'" + omodel.HBeginDate + "','" + omodel.HEndDate + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'" + "','" + omodel.HEquipDotCheckRuleInterID + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'" + "','" + omodel.HMouldMaintainRuleID + "'" + |
| | | ") "); |
| | | //æå
¥å表é
ä»¶ä¿¡æ¯ |
| | | foreach (Model.ClsSc_MouldMaintainPlanBillSub oSub in DetailColl) |
| | |
| | | public string HEndDate;// datetime --计åç»ææ¥æ |
| | | public string HExplanation;// varchar(500) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public int HEquipDotCheckRuleInterID; //å¨å
·ä¿å
»è§ç¨id |
| | | public int HMouldMaintainRuleID; //å¨å
·ä¿å
»è§ç¨id |
| | | } |
| | | } |
| | |
| | | public long HDeptID;// int --éªæ¶é¨é¨ |
| | | public string HExplanation;// varchar(500) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | |
| | | public int HMouldRepairWorkID;//维修记å½id |
| | | } |
| | | } |
| | |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | //è·åä¿å
»é¡¹ç®ç¼è¾æ°æ® |
| | | string sql = "select ä¿å
»é¡¹ç®ID HMaintainItemID, ä¿å
»é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å
»é¡¹ç® HMaintainItem,ä¿å
»é¨ä½ HMaintainPart,å
·ä½è¦æ± HClaim,è´è´£äººID,è´è´£äººä»£ç HManagerNumber,è´è´£äººåç§° HManagerName,å夿³¨2 HRemark,HEquipDotCheckRuleInterID,HEquipDotCheckNo from h_v_Sc_MouldMaintainPlanBillSub_Item where 1 = 1 " + sqlWhere + ""; |
| | | string sql = "select ä¿å
»é¡¹ç®ID HMaintainItemID, ä¿å
»é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å
»é¡¹ç® HMaintainItem,ä¿å
»é¨ä½ HMaintainPart,å
·ä½è¦æ± HClaim,è´è´£äººID,è´è´£äººä»£ç HManagerNumber,è´è´£äººåç§° HManagerName,å夿³¨2 HRemark,HMouldMaintainRuleID,HEquipDotCheckNo from h_v_Sc_MouldMaintainPlanBillSub_Item where 1 = 1 " + sqlWhere + ""; |
| | | |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainPlanBillSub_Item"); |
| | | //è·åé
件项ç®ç¼è¾æ°æ® |
| | |
| | | ",HEmpID=" + omodel.HEmpID.ToString() + |
| | | ",HManagerID=" + omodel.HManagerID.ToString() + |
| | | ",HDeptID=" + omodel.HDeptID.ToString() + |
| | | |
| | | ",HMouldRepairWorkID=" + omodel.HMouldRepairWorkID.ToString() + |
| | | |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | |
| | | ",HYear,HPeriod,HRemark" + |
| | | ",HMouldID,HCheckBeginDate,HCheckResult" + |
| | | ",HEmpID,HManagerID,HDeptID"+ |
| | | ",HInnerBillNo,HExplanation" + |
| | | ",HInnerBillNo,HExplanation,HMouldRepairWorkID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "','" + omodel.HMaker + "',getdate()" + |
| | | "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'"+ |
| | | "," + omodel.HMouldID.ToString() + ",'" + omodel.HCheckBeginDate + "','" + omodel.HCheckResult + "'" + |
| | | "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'" + |
| | | ",'" + omodel.HInnerBillNo + "','" + omodel.HExplanation + "'" + "," + omodel.HMouldRepairWorkID + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_MouldRepairCheckBillSub oSub in DetailColl) |