From 94d0b18fa47a92a1cb4d1fef4520d35ef2c2c322 Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期二, 16 十二月 2025 21:56:49 +0800
Subject: [PATCH] 产能排产相关后端更新
---
WebApi/Gs.Sys/Services/MesConfigController.cs | 139 ++++++++++++++++++++++-----------------------
1 files changed, 68 insertions(+), 71 deletions(-)
diff --git a/WebApi/Gs.Sys/Services/MesConfigController.cs b/WebApi/Gs.Sys/Services/MesConfigController.cs
index c6d0cf3..1ccb2ee 100644
--- a/WebApi/Gs.Sys/Services/MesConfigController.cs
+++ b/WebApi/Gs.Sys/Services/MesConfigController.cs
@@ -1,5 +1,4 @@
锘縰sing System.Data;
-using System.Dynamic;
using System.Text;
using Gs.Toolbox;
using Gs.Toolbox.ApiCore.Abstract.Mvc;
@@ -9,89 +8,87 @@
using Microsoft.AspNetCore.Mvc;
using static Gs.Toolbox.UtilityHelper;
-namespace Gs.Sys.Services;
-
-/// <summary>
-/// 閰嶇疆绯荤粺鍙傛暟
-/// </summary>
-[ApiGroup(ApiGroupNames.Sys)]
-public class MesConfigController : IRomteService
+namespace Gs.Sys.Services
{
- private readonly IHttpContextAccessor _http;
- private readonly string _userCode, _userGuid, _orgFids;
-
- public MesConfigController(IHttpContextAccessor httpContextAccessor)
- {
- _http = httpContextAccessor;
- (_userCode, _userGuid, _orgFids) =
- GetUserGuidAndOrgGuid(_http);
- }
-
/// <summary>
+ /// 閰嶇疆绯荤粺鍙傛暟
/// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<int?> SetModel([FromBody] dynamic model)
+
+ [ApiGroup(ApiGroupNames.Sys)]
+ public class MesConfigController : IRomteService
{
- string sql = model.sql;
- var rtnInt = (int)ReturnCode.Default;
- try
+
+ private readonly IHttpContextAccessor _http;
+ private readonly string _userCode, _userGuid, _orgFids;
+
+ public MesConfigController(IHttpContextAccessor httpContextAccessor)
{
- var strSql = new StringBuilder();
- strSql.Append(sql);
- var rows = DbHelperSQL.ExecuteSql(strSql.ToString());
- rtnInt = rows;
- }
- catch (Exception ex)
- {
- LogHelper.Debug(ToString(), "SetSql error锛�" + ex.Message);
- rtnInt = (int)ReturnCode.Exception;
- return ReturnDto<int>.QuickReturn(default(int?),
- ReturnCode.Exception, "鍒犻櫎澶辫触锛�" + ex.Message);
+ _http = httpContextAccessor;
+ (_userCode, _userGuid, _orgFids) =
+ GetUserGuidAndOrgGuid(_http);
}
- if (rtnInt > 0)
- return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Success,
- "鎿嶄綔鎴愬姛锛�");
- return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception,
- "鍒犻櫎澶辫触锛岃閲嶈瘯锛�");
- }
- /// <summary>
- /// 璇诲彇瀹炰綋
- /// </summary>
- /// <param name="guid"></param>
- /// <returns></returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<ExpandoObject> GetModel([FromBody] dynamic model)
- {
- dynamic m = new ExpandoObject();
- m.list = new List<dynamic>();
- var sbSql = new StringBuilder();
- sbSql.Append(" select * from MES_CONFIG");
- try
+ /// <summary>
+ ///
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<int?> SetModel([FromBody] dynamic model)
{
- var dset = new DataSet();
- dset = DbHelperSQL.Query(sbSql.ToString());
- if (dset != null && dset.Tables.Count > 0 &&
- dset.Tables[0].Rows.Count > 0)
+ string sql = model.sql;
+ int rtnInt = (int)ReturnCode.Default;
+ try
{
- var _tb = dset.Tables[0].TableToDynamicList();
- m.list = _tb;
- return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success,
- "璇诲彇鎴愬姛锛�");
+ StringBuilder strSql = new StringBuilder();
+ strSql.Append(sql);
+ int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
+ rtnInt = rows;
}
-
- return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
- "璇诲彇澶辫触锛�");
+ catch (Exception ex)
+ {
+ LogHelper.Debug(this.ToString(), "SetSql error锛�" + ex.Message);
+ rtnInt = (int)ReturnCode.Exception;
+ return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception, "鍒犻櫎澶辫触锛�" + ex.Message);
+ }
+ if (rtnInt > 0)
+ return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Success, "鎿嶄綔鎴愬姛锛�");
+ else
+ return ReturnDto<int>.QuickReturn(default(int?), ReturnCode.Exception, "鍒犻櫎澶辫触锛岃閲嶈瘯锛�");
}
- catch (Exception ex)
+
+ /// <summary>
+ /// 璇诲彇瀹炰綋
+ /// </summary>
+ /// <param name="guid"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<System.Dynamic.ExpandoObject> GetModel([FromBody] dynamic model)
{
- LogHelper.Debug(ToString(), "GetModel error:" + ex.Message);
- return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
- "璇诲彇澶辫触锛�");
+ dynamic m = new System.Dynamic.ExpandoObject();
+ m.list = new List<dynamic>();
+ System.Text.StringBuilder sbSql = new StringBuilder();
+ sbSql.Append(" select * from MES_CONFIG");
+ try
+ {
+ DataSet dset = new DataSet();
+ dset = DbHelperSQL.Query(sbSql.ToString());
+ if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0)
+ {
+ var _tb = dset.Tables[0].TableToDynamicList();
+ m.list = _tb;
+ return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "璇诲彇鎴愬姛锛�");
+ }
+ else
+ return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�");
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Debug(this.ToString(), "GetModel error:" + ex.Message);
+ return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, "璇诲彇澶辫触锛�");
+ }
}
}
-}
\ No newline at end of file
+}
--
Gitblit v1.9.3