智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yangle
2022-12-20 f3406b5d603b0b8ac026cda734739262207d6065 
 WebAPI/Controllers/BaseSet/Gy_UnitController.cs


@@ -1,5 +1,7 @@


using Newtonsoft.Json;


using Model;


using Newtonsoft.Json;


using Newtonsoft.Json.Linq;


using NPOI.SS.Formula.Functions;


using Pub_Class;


using System;


using System.Collections;


@@ -7,6 +9,7 @@


using System.Data;


using System.Data.SqlClient;


using System.Web.Http;


using WebAPI.Controllers.SCGL.日计划管理;


using WebAPI.Models;


using WebAPI.Service;




@@ -332,10 +335,10 @@


                oCN.RunProc(sql);


                oCN.RunProc("Insert into Gy_Unit" +


                    " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" +


                    ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID) " +


                    ",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 + ")", ref DBUtility.ClsPub.sExeReturnInfo);


                    "'," + lsmain[0].HRate.ToString() + "," + DBUtility.ClsPub.BoolToString(lsmain[0].HStandard) + "," + lsmain[0].HUSEORGID + "," + lsmain[0].HCREATEORGID + ")", ref DBUtility.ClsPub.sExeReturnInfo);


                //修改上级为非末级代码


                sql = "set identity_insert Gy_Unit off";


                oCN.RunProc(sql);