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/基础资料/基础资料/Gy_UnitConvertRateController.cs | 80 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 80 insertions(+), 0 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_UnitConvertRateController.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_UnitConvertRateController.cs"
index 222eabd..6d1ad8d 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_UnitConvertRateController.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_UnitConvertRateController.cs"
@@ -1,4 +1,5 @@
锘縰sing DBUtility;
+using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
@@ -308,5 +309,84 @@
#endregion
+
+ #region 鍗曚綅鎹㈢畻鎺ュ彛淇濆瓨
+ [Route("Gy_UnitConvertRateController/SaveGy_UnitConvertRateAPI")]
+ [HttpPost]
+ public object SaveGy_UnitConvertRateAPI([FromBody] JObject oMain)
+ {
+ try
+ {
+ var model = oMain["model"].ToString();
+ LogService.Write("1" + model);
+ //鍙嶅簭鍒楀寲
+ model = "[" + model + "]";
+ List<ClsGy_UnitConvertRate_Model> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_UnitConvertRate_Model>>(model);
+ LogService.Write("2" );
+ string sql = string.Empty;
+ oCn.BeginTran();
+ foreach (var item in lsmain)
+ {
+ LogService.Write("3");
+ // 浣跨敤褰撳墠item鐨凥ItemID鍒犻櫎
+ sql = $"delete from Gy_UnitConvertRate where HItemID = {item.HItemID}";
+ oCn.RunProc(sql);
+ // 寮�鍚痠dentity_insert
+ sql = "set identity_insert Gy_UnitConvertRate on";
+ oCn.RunProc(sql);
+
+ LogService.Write("鍗曚綅鎹㈢畻" + @"Insert into Gy_UnitConvertRate " +
+ "(HItemID,HNumber,HName,HShortNumber,HParentID,HLevel," +
+ "HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID," +
+ "HBILLNO,HMATERID,HCURRENTUNITID,HDESTUNITID,HCONVERTTYPE,HCONVERTNUMERATOR," +
+ "HCONVERTDENOMINATOR,HFORBIDSTATUS,HUnitID,HMaterNumber," +
+ "HMakeEmp,HMakeTime,HCheckEmp,HCheckTime,HModifyEmp,HModifyTime,HStopEmp,HStopTime) " +
+ "values('" + item.HItemID + "','" + item.HNumber + "','" + item.HName + "','" + item.HShortNumber + "'," + item.HParentID + "," + item.HLevel + "," +
+ item.HEndFlag + ",'" + item.HStopflag + "','CLD-ERP瀵煎叆','宸蹭娇鐢�','" + item.HUSEORGID + "','" + item.HCREATEORGID + "'" +
+ ",'" + item.HBILLNO + "','" + item.HMATERID + "','" + item.HCURRENTUNITID + "','" + item.HDESTUNITID + "','" + item.HCONVERTTYPE + "','" + item.HCONVERTNUMERATOR + "'" +
+ ",'" + item.HCONVERTDENOMINATOR + "','" + item.HFORBIDSTATUS + "','" + item.HUnitID + "','" + item.HMaterNumber + "'" +
+ ",'" + item.HMakeEmp + "','" + item.HMakeTime + "','" + item.HCheckEmp + "','" + item.HCheckTime + "','" +
+ item.HModifyEmp + "','" + item.HModifyTime + "','" + item.HStopEmp + "','" + item.HStopTime + "')");
+
+ // 鎻掑叆褰撳墠item鐨勮褰�
+ sql = "Insert into Gy_UnitConvertRate " +
+ "(HItemID,HNumber,HName,HShortNumber,HParentID,HLevel," +
+ "HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID," +
+ "HBILLNO,HMATERID,HCURRENTUNITID,HDESTUNITID,HCONVERTTYPE,HCONVERTNUMERATOR," +
+ "HCONVERTDENOMINATOR,HFORBIDSTATUS,HUnitID,HMaterNumber," +
+ "HMakeEmp,HMakeTime,HCheckEmp,HCheckTime,HModifyEmp,HModifyTime,HStopEmp,HStopTime) " +
+ "values('" + item.HItemID + "','" + item.HNumber + "','" + item.HName + "','" + item.HShortNumber + "'," + item.HParentID + "," + item.HLevel + ",'" +
+ item.HEndFlag + "','" + item.HStopflag + "','CLD-ERP瀵煎叆','宸蹭娇鐢�','" + item.HUSEORGID + "','" + item.HCREATEORGID + "'" +
+ ",'" + item.HBILLNO + "','" + item.HMATERID + "','" + item.HCURRENTUNITID + "','" + item.HDESTUNITID + "','" + item.HCONVERTTYPE + "','" + item.HCONVERTNUMERATOR + "'" +
+ ",'" + item.HCONVERTDENOMINATOR + "','" + item.HFORBIDSTATUS + "','" + item.HUnitID + "','" + item.HMaterNumber + "'" +
+ ",'" + item.HMakeEmp + "','" + item.HMakeTime + "','" + item.HCheckEmp + "','" + item.HCheckTime + "','" +
+ item.HModifyEmp + "','" + item.HModifyTime + "','" + item.HStopEmp + "','" + item.HStopTime + "')";
+ oCn.RunProc(sql);
+ // 鍏抽棴identity_insert
+ sql = "set identity_insert Gy_UnitConvertRate 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;
+ LogService.Write("2"+ e.Message);
+ objJsonResult.data = null;
+ return objJsonResult;
+
+ }
+ }
+ #endregion
}
}
--
Gitblit v1.9.1