分支合并

chenhaozhe

2025-10-19 fcc99f2648369ea6aa20e59f59653ac872bba091

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_UnitConvertRateController.cs

@@ -1,4 +1,5 @@
using 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的HItemID删除
                    sql = $"delete from  Gy_UnitConvertRate where HItemID = {item.HItemID}";
                    oCn.RunProc(sql);
                    // å¼€å¯identity_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
    }
}