From b98df034707a61fd2857dbccd5a232605076ca59 Mon Sep 17 00:00:00 2001
From: lg <123456>
Date: 星期四, 20 十一月 2025 10:26:08 +0800
Subject: [PATCH] 标准版初始化
---
WebApi/GS.QC/Service/IpqcShouManager.cs | 285 +++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 278 insertions(+), 7 deletions(-)
diff --git a/WebApi/GS.QC/Service/IpqcShouManager.cs b/WebApi/GS.QC/Service/IpqcShouManager.cs
index 78cd33b..05864fc 100644
--- a/WebApi/GS.QC/Service/IpqcShouManager.cs
+++ b/WebApi/GS.QC/Service/IpqcShouManager.cs
@@ -1,13 +1,15 @@
-锘縰sing System.Data;
-using System.Data.SqlClient;
-using System.Dynamic;
-using System.Text;
-using Gs.Toolbox;
+锘縰sing 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,275 @@
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 + " , fcheck_By='" + _userCode + "',fcheck_Date=getdate() where guid='" + guid + "'");
+ else
+ {
+ sbSql.Append(" update dbo.MES_QA_ITEMS_DETECT_DETAIL5 set " + strSql + " where guid='" + guid + "'");
+ sbSql.Append(" update dbo.MES_QA_ITEMS_DETECT_01 set fcheck_By='" + _userCode + "',fcheck_Date=getdate() where guid=( select top 1 d5.parent_guid from MES_QA_ITEMS_DETECT_DETAIL5 d5 where d5.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, "璇诲彇澶辫触锛�");
+ }
+
}
}
--
Gitblit v1.9.3