| | |
|---|
| | | oCN.RunProc("Insert Into Gy_Department " + |
|---|
| | | "(HItemID,HNumber,HShortNumber,HName,HParentID" + |
|---|
| | | ",HLevel,HEndFlag,HRemark,HStopFlag,HUseFlag" + |
|---|
| | | ",HCREATEORGID,HUSEORGID"+ |
|---|
| | | ",HCREATEORGID,HUSEORGID,HERPItemID" + |
|---|
| | | ") " + |
|---|
| | | " values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HShortNumber + "','" + lsmain[0].HName + "',0" + |
|---|
| | | ",'',0,'" + lsmain[0].HRemark + "',0,''" + |
|---|
| | | "," + lsmain[0].HCreateOrgID + "," + lsmain[0].HUseOrgID + "" + |
|---|
| | | "," + lsmain[0].HCreateOrgID + "," + lsmain[0].HUseOrgID + "," + lsmain[0].HItemID + |
|---|
| | | ") "); |
|---|
| | | sql = "set identity_insert Gy_Department off"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | |
|---|
| | | ,HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HCREATEORGID,HUSEORGID |
|---|
| | | ) |
|---|
| | | values |
|---|
| | | ({jsonData.HItemID},{jsonData.HERPItemID},'{jsonData.HNumber}','{jsonData.HName}', |
|---|
| | | ({jsonData.HItemID},{jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}', |
|---|
| | | '{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}','{jsonData.HMakeTime}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID})"; |
|---|
| | | |
|---|
| | | oCN.RunProc(sql); |
|---|
