首检巡检

kyy

6 天以前 5c45b5f97c1365b6f89da2a0897a7c93fe16cb63

 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>
@@ -131,42 +132,367 @@
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败！");
        }

        /*        /// <summary>
                ///     读取
                /// </summary>
                /// <param name="guid"></param>
                /// <returns></returns>
                [RequestMethod(RequestMethods.POST)]
                public ReturnDto<ExpandoObject> GetModel12([FromBody] dynamic model)
                {
                    Guid guid = model.guid;
                    string parentGuid = model.parentGuid;
                    dynamic m = new ExpandoObject();
                    m.list = new List<dynamic>();
                    m.list2 = new List<dynamic>();
                    StringBuilder sb = new StringBuilder();
                    sb.Append("select * from  MES_QA_ITEMS_DETECT_DETAIL12 where parent_guid='" + guid + "' order by fstand asc");
                    sb.Append("   select d13.*,d5.fcheck_item as  fcheckItemd5,d5.ybsl from  MES_QA_ITEMS_DETECT_DETAIL13 d13 left join[dbo].[MES_QA_ITEMS_DETECT_DETAIL5] d5 on d13.parent_guid = d5.guid");
                    sb.Append("  where d13.parent_guid = '" + guid + "'");
                    sb.Append(" order by d13.fcheck_item asc");
                    try
                    {
                        DataSet dset = new DataSet();
                        dset = DbHelperSQL.Query(sb.ToString());
                        var _tb = dset.Tables[0].TableToDynamicList();
                        m.list = _tb;
                        var _tb2 = dset.Tables[1].TableToDynamicList();
                        m.list2 = _tb2;
                    }
                    catch (Exception ex)
                    {
                        LogHelper.Debug(ToString(), "GetModel12 error：" + 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?> EdtModel12([FromBody] dynamic model)
        {
            string inOrderGuid1 = model.inOrderGuid1; //这是检验单guid
            string inOrderGuid5 = model.inOrderGuid5; //这是抽样的guid
            string inP1 = model.inP1; //这是9，有可能是19，或者0k-19,或者ng-19
            var _outMsg = "";
            int? _outSum = -1;
            using (var conn = new SqlConnection(DbHelperSQL.strConn))
            {
                using (var cmd = new SqlCommand("[ipqc_detect01_panding]", conn))
                {
                    try
                    {
                        conn.Open();
                        cmd.CommandType = CommandType.StoredProcedure;
                        SqlParameter[] parameters =
                        {
                        new("@outMsg", SqlDbType.NVarChar, 300),
                        new("@outSum", SqlDbType.Int),
                        new("@inEdtUserGuid", _userGuid),
                        new("@inOrderGuid1", inOrderGuid1),
                        new("@inOrderGuid5", inOrderGuid5),
                        new("@inP1", inP1),
                    };
                        parameters[0].Direction = ParameterDirection.Output;
                        parameters[1].Direction = ParameterDirection.Output;
                        foreach (var parameter in parameters)
                            cmd.Parameters.Add(parameter);
                        cmd.ExecuteNonQuery();
                        _outMsg = parameters[0].Value.ToString();
                        _outSum = int.Parse(parameters[1].Value.ToString());
                    }
                    catch (Exception ex)
                    {
                        LogHelper.Debug(ToString(),
                            "prc_iqc_panding error：" + ex.Message);
                        _outMsg = ex.Message;
                        _outSum = -1;
                    }
                    finally
                    {
                        conn.Close();
                    }
                }
            }
            if (_outSum <= 0)
                return ReturnDto<string>.QuickReturn(_outSum,
                    ReturnCode.Exception, _outMsg);
            return ReturnDto<string>.QuickReturn(_outSum,
                ReturnCode.Success, _outMsg);
        }

        /// <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> GetModel12([FromBody] dynamic model)
        public ReturnDto<ExpandoObject> GetModelWebMx([FromBody] dynamic model)
        {
            Guid guid = model.guid;
            string parentGuid = model.parentGuid;
            string mxGuid = model.mxGuid.ToString();
            dynamic m = new ExpandoObject();
            m.list = new List<dynamic>();
            m.list2 = new List<dynamic>();
            StringBuilder sb = new StringBuilder();
            sb.Append("select * from  MES_QA_ITEMS_DETECT_DETAIL12 where parent_guid='" + guid + "' order by fstand asc");
            sb.Append("   select d13.*,d5.fcheck_item as  fcheckItemd5,d5.ybsl from  MES_QA_ITEMS_DETECT_DETAIL13 d13 left join[dbo].[MES_QA_ITEMS_DETECT_DETAIL5] d5 on d13.parent_guid = d5.guid");
            sb.Append("  where d13.parent_guid = '" + guid + "'");
            sb.Append(" order by d13.fcheck_item asc");
            var dset = new DataSet();
            try
            {
                DataSet dset = new DataSet();
                dset = DbHelperSQL.Query(sb.ToString());
                var _tb = dset.Tables[0].TableToDynamicList();
                m.list = _tb;
                var _tb2 = dset.Tables[1].TableToDynamicList();
                m.list2 = _tb2;
                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(), "GetModel12 error：" + ex.Message);
                LogHelper.Debug(ToString(), ex.Message);
            }
            if (m != null)
                return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
                    "读取成功！");
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
                "读取失败！");
            return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "读取失败！");
        }

    }
}