| | |
| | | //涓昏〃 |
| | | string mainSql = "insert into Qc_PreventErrMouldCheckBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" + |
| | | ",HMaterID,HCheckEmpID,HNote,HLastResult) " + |
| | | ",HMaterID,HCheckEmpID,HNote,HLastResult,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo) " + |
| | | "values(" + |
| | | "" + (omodel.HYear.ToString() != "0" ? omodel.HYear.ToString() : DateTime.Now.Year.ToString()) + |
| | | "," + omodel.HPeriod.ToString() + |
| | |
| | | "','" + omodel.HCheckEmpID + |
| | | "','" + omodel.HNote + |
| | | "','" + omodel.HLastResult + |
| | | "','" + omodel.HMainSourceInterID + |
| | | "','" + omodel.HMainSourceEntryID + |
| | | "','" + omodel.HMainSourceBillNo + |
| | | "')"; |
| | | |
| | | oCn.RunProc(mainSql); |