| | |
| | | //涓昏〃 |
| | | string mainSql = "insert into Gy_EnvironmentTestSchemeBillMain" + |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HRemark,HMaker,HMakeDate" + |
| | | ",HDeptID,HCenterWorkID,HProcID) " + |
| | | ",HDeptID,HCenterWorkID,HProcID,HOrgID) " + |
| | | "values(" + |
| | | "" + (omodel.HYear.ToString() != "0" ? omodel.HYear.ToString() : DateTime.Now.Year.ToString()) + |
| | | "," + omodel.HPeriod.ToString() + |
| | |
| | | "','" + omodel.HBillNo + |
| | | "','" + omodel.HRemark + |
| | | "','" + omodel.HMaker + |
| | | "','getdate()" + |
| | | "','" + omodel.HDeptID + |
| | | "',getdate()" + |
| | | ",'" + omodel.HDeptID + |
| | | "','" + omodel.HCenterWorkID + |
| | | "','" + omodel.HProcID + |
| | | "','" + omodel.HOrgID + |
| | | "')"; |
| | | |
| | | oCn.RunProc(mainSql); |