| | |
| | | "', HWorkCenterID = '" + omodel.HWorkCenterID + |
| | | "', HEquipID = '" + omodel.HEquipID + |
| | | "', HOrgID = '" + omodel.HOrgID + |
| | | "' where HInterID = " + omodel.HInterID; |
| | | "', HProcID = " + omodel.HProcID + |
| | | " where HInterID = " + omodel.HInterID; |
| | | |
| | | oCn.RunProc(mainSql); |
| | | //删除关联 |
| | |
| | | //插入主表 |
| | | string mainSql = "insert into Gy_MaterialMouldBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" + |
| | | ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID ) " + |
| | | ",HDeptID,HEmpID,HMaterID,HWorkCenterID,HEquipID,HOrgID,HProcID) " + |
| | | "values(" + |
| | | "" + omodel.HYear.ToString() + |
| | | "," + omodel.HPeriod.ToString() + |
| | |
| | | ",'" + omodel.HMaterID + |
| | | "','" + omodel.HWorkCenterID + |
| | | "','" + omodel.HEquipID + |
| | | "','" + omodel.HOrgID + |
| | | "')"; |
| | | "','" + omodel.HOrgID + |
| | | "'," + omodel.HProcID + |
| | | ")"; |
| | | |
| | | oCn.RunProc(mainSql); |
| | | |