| | |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc("UpDate Sb_EquipRepairCheckBillMain set " + |
| | | " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== |
| | | ",HDate='" + omodel.HDate + "'" + |
| | | //",HDate='" + omodel.HDate + "'" + |
| | | ",HYear='" + omodel.HYear.ToString() + "'" + |
| | | ",HPeriod='" + omodel.HPeriod.ToString() + "'" + |
| | | ",HRemark='" + omodel.HRemark + "'" + |
| | |
| | | ",HManagerID=" + omodel.HManagerID.ToString() + |
| | | ",HDeptID=" + omodel.HDeptID.ToString() + |
| | | ",HCheckBeginDate='" + omodel.HCheckBeginDate + "'" + |
| | | ",HMouldRepairWorkID='" + omodel.HMouldRepairWorkID + "'" + |
| | | ",HCheckResult='" + omodel.HCheckResult + "'" + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HEquipID,HExplanation,HInnerBillNo,HEmpID" + |
| | | ",HManagerID,HDeptID,HCheckResult,HCheckBeginDate" + |
| | | ",HManagerID,HDeptID,HCheckResult,HCheckBeginDate,HMouldRepairWorkID" + |
| | | ") " + |
| | | " 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.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HEmpID.ToString() + |
| | | "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HCheckResult + "','" + omodel.HCheckBeginDate + "'" + |
| | | "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HCheckResult + "','" + omodel.HCheckBeginDate + "'," + omodel.HMouldRepairWorkID + |
| | | ") "); |
| | | ////æå
¥å表 |
| | | foreach (Model.ClsSb_EquipRepairCheckBillSub oSub in DetailColl) |