From ccfc7f25cbb5e78d335b44648a9964426a38a17f Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 15 十二月 2022 09:54:05 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/基础资料/基础资料/Gy_CustLocationController.cs | 50 -------------------------------------------------- 1 files changed, 0 insertions(+), 50 deletions(-) diff --git "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CustLocationController.cs" "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CustLocationController.cs" index 60b9271..12c083a 100644 --- "a/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CustLocationController.cs" +++ "b/WebAPI/Controllers/\345\237\272\347\241\200\350\265\204\346\226\231/\345\237\272\347\241\200\350\265\204\346\226\231/Gy_CustLocationController.cs" @@ -342,55 +342,5 @@ } } #endregion - - #region 浜よ揣鍦扮偣 閲戣澏鍚屾 - [Route("Gy_CustLocation/SaveGy_CustLocationListApi")] - [HttpPost] - public object SaveGy_CustLocationListApi([FromBody] JObject msg) - { - try - { - var _value = msg["model"].ToString(); - SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - ListModels oListModels = new ListModels(); - List<Model.ClsGy_CustLocation_Model> lsmain = new List<Model.ClsGy_CustLocation_Model>(); - lsmain = oListModels.getObjectByJson_Gy_CustLocation(_value); - string sql = string.Empty; - //淇濆瓨 - oCN.BeginTran(); - sql = $"delete Gy_CustLocation where HItemID = {lsmain[0].HItemID}"; - oCN.RunProc(sql); - sql = "set identity_insert Gy_CustLocation on"; - oCN.RunProc(sql); - - oCN.RunProc($@"insert into Gy_CustLocation(HItemID,HNumber,HName ,HShortNumber,HParentID ,HLevel - ,HEndFla,HStopflag,HRemark ,HHelpCode ,HUseFlag - ,HMakeTime ,HMakeEmp ,HCheckEmp ,HCheckTime ,HModifyEmp - ,HModifyTime ,HStopEmp ,HStopTime ,HUSEORGID,HCREATEORGID) - values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{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].HHelpCode}','{lsmain[0].HUseFlag}' - ,'{lsmain[0].HMakeTime}','{lsmain[0].HMakeEmp}','{lsmain[0].HCheckEmp}','{lsmain[0].HCheckTime}','{lsmain[0].HModifyEmp}' - ,'{lsmain[0].HModifyTime}','{lsmain[0].HStopEmp}',null,{lsmain[0].HUSEORGID},{lsmain[0].HCREATEORGID})", ref DBUtility.ClsPub.sExeReturnInfo); - //淇敼涓婄骇涓洪潪鏈骇浠g爜 - sql = "set identity_insert Gy_CustLocation off"; - oCN.RunProc(sql); - oCN.Commit(); - - objJsonResult.code = "1"; - objJsonResult.count = 1; - objJsonResult.Message = "淇濆瓨鎴愬姛锛�"; - objJsonResult.data = 1; - return objJsonResult; - } - catch (Exception e) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "淇濆瓨澶辫触锛�" + e.ToString(); - objJsonResult.data = 1; - return objJsonResult; - } - } - #endregion } } \ No newline at end of file -- Gitblit v1.9.1