| | |
|---|
| | | { |
|---|
| | | try |
|---|
| | | { |
|---|
| | | LogService.Write("单位：" + msg.ToString()); |
|---|
| | | var _value = msg["model"].ToString(); |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | ListModels oListModels = new ListModels(); |
|---|
| | |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | sql = "set identity_insert Gy_Unit on"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | |
|---|
| | | LogService.Write("单位：" + "Insert into Gy_Unit" + |
|---|
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
|---|
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID,HCREATEORGID) " + |
|---|
| | | " Values('" + lsmain[0].HItemID + "','" + lsmain[0].HNumber + "','" + lsmain[0].HName + "','" + lsmain[0].HHelpCode + "','" + lsmain[0].HShortNumber + "'," + lsmain[0].HParentID.ToString() + |
|---|
| | | "," + lsmain[0].HLevel.ToString() + "," + Convert.ToString(lsmain[0].HEndFlag ? 1 : 0) + "," + Convert.ToString(lsmain[0].HStopflag ? 1 : 0) + ",'" + lsmain[0].HRemark + |
|---|
| | | "'," + lsmain[0].HRate.ToString() + "," + DBUtility.ClsPub.BoolToString(lsmain[0].HStandard) + "," + lsmain[0].HUSEORGID + "," + lsmain[0].HCREATEORGID + ")"); |
|---|
| | | |
|---|
| | | oCN.RunProc("Insert into Gy_Unit" + |
|---|
| | | " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
|---|
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID,HCREATEORGID) " + |
|---|
