From 5ca523ad4bc92a240ed4844994236cc8281ea90b Mon Sep 17 00:00:00 2001 From: 王 垚 <1402714037@qq.com> Date: 星期三, 30 十一月 2022 17:07:46 +0800 Subject: [PATCH] 代码上传 --- WebAPI/Controllers/BaseSet/Gy_UnitController.cs | 50 +++++++++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 47 insertions(+), 3 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_UnitController.cs b/WebAPI/Controllers/BaseSet/Gy_UnitController.cs index 59e9b10..fb7252d 100644 --- a/WebAPI/Controllers/BaseSet/Gy_UnitController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_UnitController.cs @@ -28,7 +28,7 @@ /// </summary> [Route("Gy_Unit/list1")] [HttpGet] - public object list(string sWhere,string user,string Organization) + public object list(string sWhere, string user, string Organization) { try { @@ -268,7 +268,7 @@ oItem.HShortNumber = sShortNumber;//鐭唬鐮� oItem.HEndFlag = true;//鏈骇鏍囧織 oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //绛夌骇 - oItem.HRate= msg_HRate;//鎹㈢畻姣斾緥 + oItem.HRate = msg_HRate;//鎹㈢畻姣斾緥 oBill.oModel = oItem; } @@ -312,6 +312,50 @@ } } + [Route("Gy_Unit/SaveGy_UnitListApi")] + [HttpPost] + public object SaveGy_UnitListApi([FromBody] JObject msg) + { + try + { + var _value = msg["model"].ToString(); + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + ListModels oListModels = new ListModels(); + List<Model.ClsGy_Unit_Model> lsmain = new List<Model.ClsGy_Unit_Model>(); + lsmain = oListModels.getObjectByJson_Gy_Unit(_value); + string sql = string.Empty; + //淇濆瓨 + oCN.BeginTran(); + sql = $"delete Gy_Unit where HItemID = {lsmain[0].HItemID}"; + oCN.RunProc(sql); + sql = "set identity_insert Gy_Unit on"; + oCN.RunProc(sql); + oCN.RunProc("Insert into Gy_Unit" + + " (HItemID,HNumber,HName,HHelpCode,HShortNumber,HParentID" + + ",HLevel,HEndFlag,HStopflag,HRemark,HRate,HStandard,HUSEORGID) " + + " 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); + //淇敼涓婄骇涓洪潪鏈骇浠g爜 + sql = "set identity_insert Gy_Unit 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; + } + } /// <summary> /// 璁¢噺鍗曚綅鑾峰彇淇℃伅 /// </summary> @@ -330,7 +374,7 @@ /// <returns></returns> [Route("DeltetGy_Unit")] [HttpGet] - public object DeltetGy_Unit(string HItemID,string user) + public object DeltetGy_Unit(string HItemID, string user) { DataSet ds; //string ModRightNameCheck = "Sc_ProcessReport_check"; -- Gitblit v1.9.1