同步为祈禧的代码

啊鑫

昨天 eb65436c2312821e3e513ab9ada41dd486d6d7cf

 WebApi/GS.QC/Service/IpqcShouManager.cs

@@ -1,13 +1,15 @@
using System.Data;
using System.Data.SqlClient;
using System.Dynamic;
using System.Text;
using Gs.Toolbox;
using Gs.Toolbox;
using Gs.Toolbox.ApiCore.Abstract.Mvc;
using Gs.Toolbox.ApiCore.Common.Mvc;
using Gs.Toolbox.ApiCore.Group;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Data;
using System.Data.SqlClient;
using System.Dynamic;
using System.Text;
using static Gs.Toolbox.UtilityHelper;

namespace GS.QC.Service
@@ -24,7 +26,6 @@
            (_userCode, _userGuid, _orgFids) =
                GetUserGuidAndOrgGuid(_http);
        }


        /// <summary>
        ///     读取列表，支持分页
@@ -88,7 +89,7 @@
        }

        /// <summary>
        ///     读取
        ///     读取实体
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
@@ -168,5 +169,271 @@
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                "读取失败！");
        }

        /// <summary>
        ///     读取web实体
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
        [RequestMethod(RequestMethods.POST)]
        public ReturnDto<ExpandoObject> GetModelWeb([FromBody] dynamic model)
        {
            string guid = model.guid.ToString();
            dynamic m = new ExpandoObject();
            SqlParameter[] parameters =
            {
            new("@inMainGuid", guid),
            new("@inP1", ""),
            new("@inP2", ""),
            new("@inP3", ""),
            new("@inP4", "")
        };
            var dset = new DataSet();
            try
            {
                dset = DbHelperSQL.RunProcedure("[ipqc_shou_get_web]", parameters, "0");
                if (dset != null && dset.Tables.Count > 0 &&
                    dset.Tables[0].Rows.Count > 0)
                {
                    var dr = dset.Tables[0].Rows[0];
                    m = dr.RowToDynamic();
                    m.list = new List<dynamic>();
                    DataTable dtDistinct = (new DataView(dset.Tables[1])).ToTable(true, new string[] { "groupName" });
                    foreach (DataRow DataRow in dtDistinct.Rows)
                    {
                        dynamic _obj = new System.Dynamic.ExpandoObject();
                        _obj.groupName = DataRow["groupName"].ToString();
                        _obj.child = new List<dynamic>();
                        DataRow[] _dtRows = dset.Tables[1].Select("groupName='" + _obj.groupName.ToString() + "'");
                        if (_dtRows.Length == 0)
                            continue;
                        foreach (DataRow _row in _dtRows)
                        {
                            dynamic _dy = _row.RowToDynamic();
                            if (_obj.groupName.ToString() == "制热性能")
                            {
                                //水温选择
                                if (!string.IsNullOrEmpty(_row["ipqc_zrxn_sel1"].ToString()))
                                    _dy.selectedWater = JsonConvert.DeserializeObject(_row["ipqc_zrxn_sel1"].ToString());
                                else
                                    _dy.selectedWater = Array.Empty<string>();
                                //流量选择
                                if (!string.IsNullOrEmpty(_row["ipqc_zrxn_sel2"].ToString()))
                                    _dy.selectedFlow = JsonConvert.DeserializeObject(_row["ipqc_zrxn_sel2"].ToString());
                                else
                                    _dy.selectedFlow = Array.Empty<string>();
                                //表格数据
                                if (!string.IsNullOrEmpty(_row["ipqc_zrxn_table"].ToString()))
                                    _dy.selecteTable = JsonConvert.DeserializeObject(_row["ipqc_zrxn_table"].ToString());
                                else
                                    _dy.selecteTable = new { };
                            }
                            _obj.child.Add(_dy);
                        }
                        m.list.Add(_obj);
                    }
                }
            }
            catch (Exception ex)
            {
                LogHelper.Debug(ToString(), ex.Message);
            }
            if (m != null)
                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
                    "读取成功！");
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败！");
        }

        /// <summary>
        /// 设置
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        [RequestMethod(RequestMethods.POST)]
        public ReturnDto<int?> SetModelWeb([FromBody] dynamic model)
        {
            string guid = model.guid;
            string strSql = model.strSql;
            string ziduan = model.ziduan;
            int? rtnInt = (int)ReturnCode.Default;
            try
            {
                System.Text.StringBuilder sbSql = new StringBuilder();
                if (ziduan == "bpwym" || ziduan == "sjwym" || ziduan == "sjtxm")
                    sbSql.Append("update dbo.MES_QA_ITEMS_DETECT_01 set " + strSql + " where guid='" + guid + "'");
                else
                    sbSql.Append("update dbo.MES_QA_ITEMS_DETECT_DETAIL5 set " + strSql + " where guid='" + guid + "'");
                rtnInt = DbHelperSQL.ExecuteSql(sbSql.ToString());
            }
            catch (Exception ex)
            {
                LogHelper.Debug(this.ToString(), "SetModelWeb  error：" + ex.Message);
                rtnInt = (int)ReturnCode.Exception;
            }
            if (rtnInt > 0)
                return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Success, "操作成功!");
            else
                return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception, "操作失败，请重试！");
        }


        /// <summary>
        /// 提交检验
        /// </summary>
        /// <param name="mode"></param>
        /// <returns></returns>
        [RequestMethod(RequestMethods.POST)]
        public ReturnDto<ExpandoObject> EditModelSubmit([FromBody] dynamic mode)
        {
            string _guid = mode.guid;
            string _inFieldValue = mode.submitType;
            dynamic m = new ExpandoObject();
            m.outSum = -1;
            m.outMsg = "";
            using (var conn = new SqlConnection(DbHelperSQL.strConn))
            {
                using (var cmd = new SqlCommand("ipqc_shou_submit", conn))
                {
                    try
                    {
                        conn.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        SqlParameter[] parameters =
                        {
                                new("@outMsg", SqlDbType.NVarChar, 300),
                                new("@outSum", SqlDbType.Int),
                                new("@inEdtUserGuid", _userGuid),
                                new("@inOrderGuid", _guid),
                                new("@inFieldValue", _inFieldValue),
                                new("@in1", ""),
                                new("@in2", "")
                            };
                        parameters[0].Direction = ParameterDirection.Output;
                        parameters[1].Direction = ParameterDirection.Output;
                        foreach (var parameter in parameters)
                            cmd.Parameters.Add(parameter);
                        cmd.ExecuteNonQuery();
                        m.outMsg = parameters[0].Value.ToString();
                        m.outSum = int.Parse(parameters[1].Value.ToString());
                    }
                    catch (Exception ex)
                    {
                        m.outMsg = ex.Message;
                        LogHelper.Debug(this.ToString(), "ipqc_shou_submit error：" + ex.Message);
                        return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, ex.Message);
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
            }
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "操作成功！");
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        [RequestMethod(RequestMethods.POST)]
        public ReturnDto<int?> UpdateTableConfig([FromBody] dynamic model)
        {
            string guid = model.guid;
            string mxguid = model.mxguid;
            JArray arrayWater = model.selectedWater;
            JArray arrayFlow = model.selectedFlow;
            JObject arrayTable = model.selectedTable;
            string selectedWater = arrayWater.ToString();
            string selectedFlow = arrayFlow.ToString();
            System.Text.StringBuilder tableData = new StringBuilder();
            tableData.Append("{");
            foreach (JValue jsonitem in arrayWater)
            {
                string jv = jsonitem.ToString().Trim();
                var _temp = arrayTable[jv]["temp"];
                if (tableData.Length > 2)
                    tableData.Append(",");
                tableData.Append("'" + jv + "':");
                tableData.Append("{");
                tableData.Append("'temp':'" + _temp + "'");
                foreach (JValue volume in arrayFlow)
                {
                    var _temp2 = arrayTable[jv][volume.ToString().Trim()];
                    tableData.Append(",'" + volume.ToString().Trim() + "':'" + _temp2 + "'");
                }
                tableData.Append("}");
            }
            tableData.Append("}");
            int? rtnInt = (int)ReturnCode.Default;
            try
            {
                System.Text.StringBuilder sbSql = new StringBuilder();
                sbSql.Append("UPDATE MES_QA_ITEMS_DETECT_DETAIL5 SET ipqc_zrxn_sel1 = @selectedWater,ipqc_zrxn_sel2 = @selectedFlow, ipqc_zrxn_table = @tableData  WHERE guid = @mxguid");
                rtnInt = Gs.Toolbox.DbHelperSQL.ExecuteSql(sbSql.ToString(), new SqlParameter[] {
                    new SqlParameter("@selectedWater", selectedWater),
                    new SqlParameter("@selectedFlow", selectedFlow),
                    new SqlParameter("@tableData", tableData.ToString()),
                    new SqlParameter("@mxguid", mxguid),
                });
            }
            catch (Exception ex)
            {
                LogHelper.Debug(this.ToString(), "SetModelWeb  error：" + ex.Message);
                rtnInt = (int)ReturnCode.Exception;
            }
            if (rtnInt > 0)
                return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Success, "操作成功!");
            else
                return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception, "操作失败，请重试！");
        }

        /// <summary>
        ///     读取
        /// </summary>
        /// <param name="guid"></param>
        /// <returns></returns>
        [RequestMethod(RequestMethods.POST)]
        public ReturnDto<ExpandoObject> GetModelWebMx([FromBody] dynamic model)
        {
            string mxGuid = model.mxGuid.ToString();
            dynamic m = new ExpandoObject();
            var dset = new DataSet();
            try
            {
                System.Text.StringBuilder sbSql = new StringBuilder();
                sbSql.Append("select * from [dbo].[MES_QA_ITEMS_DETECT_DETAIL5] where guid='" + mxGuid + "'");
                dset = DbHelperSQL.Query(sbSql.ToString());
                if (dset != null && dset.Tables.Count > 0 &&
                    dset.Tables[0].Rows.Count > 0)
                {
                    var _row = dset.Tables[0].Rows[0];
                    //水温选择
                    if (!string.IsNullOrEmpty(_row["ipqc_zrxn_sel1"].ToString()))
                        m.selectedWater = JsonConvert.DeserializeObject(_row["ipqc_zrxn_sel1"].ToString());
                    else
                        m.selectedWater = Array.Empty<string>();
                    //流量选择
                    if (!string.IsNullOrEmpty(_row["ipqc_zrxn_sel2"].ToString()))
                        m.selectedFlow = JsonConvert.DeserializeObject(_row["ipqc_zrxn_sel2"].ToString());
                    else
                        m.selectedFlow = Array.Empty<string>();
                    //表格数据
                    if (!string.IsNullOrEmpty(_row["ipqc_zrxn_table"].ToString()))
                        m.selecteTable = JsonConvert.DeserializeObject(_row["ipqc_zrxn_table"].ToString());
                    else
                        m.selecteTable = new { };
                }
            }
            catch (Exception ex)
            {
                LogHelper.Debug(ToString(), ex.Message);
            }
            if (m != null)
                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
                    "读取成功！");
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败！");
        }

    }
}