| | |
|---|
| | | |
|---|
| | | List<Model.ClsGy_Operator_Model> operatorInfos = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_Operator_Model>>(operatorInfoModel); |
|---|
| | | //淇濆瓨 |
|---|
| | | oCN.BeginTran(); |
|---|
| | | //sql = $"delete Gy_Operator where HItemID = {lsmain[0].HItemID}"; |
|---|
| | | //oCN.RunProc(sql); |
|---|
| | | //sql = "set identity_insert Gy_Operator on"; |
|---|
| | | //oCN.RunProc(sql); |
|---|
| | | //oCN.RunProc($@"insert into Gy_Operator(HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID |
|---|
| | | // ,HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HOperatorId,HOperatorType,HSEQ,HStaffId,HIsUse) |
|---|
| | | // values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HHelpCode}','{lsmain[0].HShortNumber}', |
|---|
| | | // {lsmain[0].HParentID},{lsmain[0].HLevel},{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) }, |
|---|
| | | // '{lsmain[0].HRemark}','{lsmain[0].HUseFlag}',{lsmain[0].HUSEORGID},{lsmain[0].HOperatorId},'{lsmain[0].HOperatorType}', |
|---|
| | | // {lsmain[0].HSEQ},{lsmain[0].HStaffId},{lsmain[0].HIsUse})", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | oCN.BeginTran(); |
|---|
| | | sql = "set identity_insert Gy_Operator on"; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | foreach (var item in operatorInfos) |
|---|
