| | |
| | | "', HProcID = '" + omodel.HProcID + |
| | | "', HEquipID = '" + omodel.HEquipID + |
| | | "', HOrgID = '" + omodel.HOrgID + |
| | | "', HMouldID = '" + omodel.HMouldID + |
| | | "' where HInterID = " + omodel.HInterID; |
| | | |
| | | oCn.RunProc(mainSql); |
| | |
| | | //鎻掑叆涓昏〃 |
| | | string mainSql = "insert into Gy_MaterialTechParamBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" + |
| | | ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID,HProcID ) " + |
| | | ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID,HProcID,HMouldID ) " + |
| | | "values(" + |
| | | "" + omodel.HYear.ToString() + |
| | | "," + omodel.HPeriod.ToString() + |
| | |
| | | "','" + omodel.HWorkCenterID + |
| | | "','" + omodel.HEquipID + |
| | | "','" + omodel.HOrgID + |
| | | "','" + omodel.HProcID + |
| | | "','" + omodel.HProcID + |
| | | "','" + omodel.HMouldID + |
| | | "')"; |
| | | |
| | | oCn.RunProc(mainSql); |