From fcc99f2648369ea6aa20e59f59653ac872bba091 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期日, 19 十月 2025 13:01:03 +0800
Subject: [PATCH] 分支合并
---
WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs | 61 ++++++++++++++++++++++++++++++
1 files changed, 61 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs b/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs
index 63a59f7..297df22 100644
--- a/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs
+++ b/WebAPI/Controllers/BaseSet/Xt_ORGANIZATIONSController.cs
@@ -629,6 +629,67 @@
}
#endregion
+
+ #region 缁勭粐鏈烘瀯鎺ュ彛淇濆瓨
+ [Route("Xt_ORGANIZATIONS/SaveXt_ORGANIZATIONSAPI")]
+ [HttpPost]
+ public object SaveXt_ORGANIZATIONSAPI([FromBody] JObject oMain)
+ {
+ try
+ {
+ var model = oMain["model"].ToString();
+ LogService.Write("1" + model);
+ //鍙嶅簭鍒楀寲
+ model = "[" + model + "]";
+ List<Xt_ORGANIZATIONS> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_ORGANIZATIONS>>(model);
+ string sql = string.Empty;
+ oCN.BeginTran();
+ foreach (var item in lsmain)
+ {
+ // 浣跨敤褰撳墠item鐨凥ItemID鍒犻櫎
+ sql = $"delete from Xt_ORGANIZATIONS where HItemID = {item.HItemID}";
+ oCN.RunProc(sql);
+ // 寮�鍚痠dentity_insert
+ sql = "set identity_insert Xt_ORGANIZATIONS on";
+ oCN.RunProc(sql);
+
+ LogService.Write("缁勭粐鏈烘瀯" + @"Insert into Xt_ORGANIZATIONS (HItemID,HNumber,HName,HParentID,HStopflag,HMakeTime,HRemark)" +
+ " values('" + item.HItemID + "','" + item.HNumber + "','" + item.HName + "','" + item.HParentID + "','" + item.HStopflag + "'," +
+ ",getdate(),'" + item.HRemark +
+ "') ");
+
+ // 鎻掑叆褰撳墠item鐨勮褰�
+ sql = "Insert into Xt_ORGANIZATIONS (HItemID,HNumber,HName,HParentID,HStopflag,HMakeTime,HRemark)" +
+ " values('" + item.HItemID + "','" + item.HNumber + "','" + item.HName + "','" + item.HParentID + "','" + item.HStopflag + "'," +
+ ",getdate(),'" + item.HRemark +
+ "') ";
+ oCN.RunProc(sql);
+ // 鍏抽棴identity_insert
+ sql = "set identity_insert Xt_ORGANIZATIONS off";
+ oCN.RunProc(sql);
+
+ // 鎻愪氦褰撳墠浜嬪姟
+ oCN.Commit();
+ }
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鏂板鍗曟嵁鎴愬姛锛�";
+ //objJsonResult.data = null;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ oCN.RollBack();
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.Message;
+ objJsonResult.data = null;
+ return objJsonResult;
+
+ }
+ }
+ #endregion
+
//
}
}
\ No newline at end of file
--
Gitblit v1.9.1