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