多码合一

llj

8 天以前 2bf6de5d4748d28f7f3a098af25503d6a0c619d1

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

@@ -1,4 +1,5 @@
using DBUtility;
using Model;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
@@ -181,7 +182,8 @@
                            FormId = "BD_UNITCONVERTRATE",
                            FieldKeys = "FUNITCONVERTRATEID,FBILLNO,FMATERIALID,FUSEORGID,FCREATEORGID,FFORBIDSTATUS" +
                            ",FCURRENTUNITID,FDESTUNITID,FCONVERTTYPE,FCONVERTNUMERATOR,FCONVERTDENOMINATOR" +
                            ",FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE",
                            ",FCREATORID,FCREATEDATE,FMODIFIERID,FMODIFYDATE,FAPPROVERID,FAPPROVEDATE,FFORBIDDERID,FFORBIDDATE" +
                            ",FMATERIALID.FNUMBER",
                            FilterString = "",
                            OrderString = "",
                            TopRowCount = 0,
@@ -245,6 +247,7 @@
                                HModifyTime = DBUtility.ClsPub.isDate(arr[i, 14]),
                                HStopEmp = DBUtility.ClsPub.isStrNull(arr[i, 17]),
                                HStopTime = DBUtility.ClsPub.isDate(arr[i, 18]),
                                HMaterNumber = DBUtility.ClsPub.isStrNull(arr[i, 19]),
                            };

                            //写入单位换算表数据
@@ -253,7 +256,7 @@
                                    (HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
                                    ,HEndFlag,HStopflag,HRemark,HUseFlag,HUSEORGID,HCREATEORGID
                                    ,HBILLNO,HMATERID,HCURRENTUNITID,HDESTUNITID,HCONVERTTYPE,HCONVERTNUMERATOR
                                    ,HCONVERTDENOMINATOR,HFORBIDSTATUS,HUnitID
                                    ,HCONVERTDENOMINATOR,HFORBIDSTATUS,HUnitID,HMaterNumber
                                    ,HMakeEmp,HMakeTime
                                    ,HCheckEmp,HCheckTime
                                    ,HModifyEmp,HModifyTime
@@ -261,7 +264,7 @@
                                    Values({subData.HItemID},'{subData.HNumber}','{subData.HName}','{subData.HShortNumber}',{subData.HParentID},{subData.HLevel}
                                    ,{subData.HEndFlag},{subData.HStopflag},'{subData.HRemark}','{subData.HUseFlag}',{subData.HUSEORGID},{subData.HCREATEORGID}
                                    ,'{subData.HBILLNO}',{subData.HMATERID},{subData.HCURRENTUNITID},{subData.HDESTUNITID},{subData.HCONVERTTYPE},{subData.HCONVERTNUMERATOR}
                                    ,{subData.HCONVERTDENOMINATOR},'{subData.HFORBIDSTATUS}',{subData.HUnitID}
                                    ,{subData.HCONVERTDENOMINATOR},'{subData.HFORBIDSTATUS}',{subData.HUnitID},'{subData.HMaterNumber}'
                                    ,'{subData.HMakeEmp}',case when '{subData.HMakeTime}' = '1900/1/1 0:00:00' then NULL else '{subData.HMakeTime}' end
                                    ,'{subData.HCheckEmp}',case when '{subData.HCheckTime}' = '1900/1/1 0:00:00' then NULL else '{subData.HCheckTime}' end
                                    ,'{subData.HModifyEmp}',case when '{subData.HModifyTime}' = '1900/1/1 0:00:00' then NULL else '{subData.HModifyTime}' end
@@ -306,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
    }
}