From e19f8a13e2b35e6836ce46c17402c44327814a00 Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期四, 18 十二月 2025 09:14:36 +0800
Subject: [PATCH] 产能排产漏更新
---
WebApi/Gs.Wom/WorkService/WorkWeightController.cs | 318 +++++++++++++++++++++++++---------------------------
1 files changed, 154 insertions(+), 164 deletions(-)
diff --git a/WebApi/Gs.Wom/WorkService/WorkWeightController.cs b/WebApi/Gs.Wom/WorkService/WorkWeightController.cs
index 5293ad3..3c9ca88 100644
--- a/WebApi/Gs.Wom/WorkService/WorkWeightController.cs
+++ b/WebApi/Gs.Wom/WorkService/WorkWeightController.cs
@@ -8,205 +8,195 @@
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using static Gs.Toolbox.UtilityHelper;
-
-namespace Gs.Wom.WorkService;
-
-[ApiGroup(ApiGroupNames.WOM)]
-public class WorkWeightController : IRomteService
+namespace Gs.Wom.WorkService
{
- private readonly IHttpContextAccessor _http;
- private readonly string _userCode, _userGuid, _orgFids;
- public WorkWeightController(IHttpContextAccessor httpContextAccessor)
+ [ApiGroup(ApiGroupNames.WOM)]
+ public class WorkWeightController : IRomteService
{
- _http = httpContextAccessor;
- (_userCode, _userGuid, _orgFids) =
- GetUserGuidAndOrgGuid(_http);
- }
+ private readonly IHttpContextAccessor _http;
+ private readonly string _userCode, _userGuid, _orgFids;
-
- /// <summary>
- /// 璇诲彇绉伴噸鍒楄〃
- /// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<List<dynamic>> GetModelList([FromBody] dynamic model)
- {
- string lineId = model.lineId;
- var lst = new List<dynamic>();
- var dset = new DataSet();
- try
+ public WorkWeightController(IHttpContextAccessor httpContextAccessor)
{
- SqlParameter[] parameters =
- {
- new("@inLineId", lineId)
- };
- dset = DbHelperSQL.RunProcedure("work_weight_lst", parameters, "0");
- }
- catch (Exception ex)
- {
- LogHelper.Debug(ToString(), "work_weight_lst error锛�" + ex.Message);
+ _http = httpContextAccessor;
+ (_userCode, _userGuid, _orgFids) =
+ GetUserGuidAndOrgGuid(_http);
}
- if (dset != null && dset.Tables.Count > 0 &&
- dset.Tables[0].Rows.Count > 0)
- lst = dset.Tables[0].TableToDynamicList();
- return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Success,
- "璇诲彇鎴愬姛锛�");
- }
-
- /// <summary>
- /// 澧炲姞涓�鏉￠噸閲忎俊鎭�
- /// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model)
- {
- string lineId = model.lineId;
- string realWeight = model.realWeight;
- string realWeightTxt = model.realWeightTxt;
- dynamic mObj = new ExpandoObject();
- mObj.outMsg = "";
- mObj.outSum = -1;
- using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ /// <summary>
+ /// 璇诲彇绉伴噸鍒楄〃
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<List<dynamic>> GetModelList([FromBody] dynamic model)
{
- using (var cmd = new SqlCommand("[work_weight_add]", conn))
+ string lineId = model.lineId;
+ List<dynamic> lst = new List<dynamic>();
+ var dset = new DataSet();
+ try
{
- try
+ SqlParameter[] parameters =
+ {
+ new("@inLineId",lineId)
+ };
+ dset = DbHelperSQL.RunProcedure("work_weight_lst", parameters, "0");
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Debug(ToString(), "work_weight_lst error锛�" + ex.Message);
+ }
+ if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0)
+ lst = dset.Tables[0].TableToDynamicList();
+ return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Success,
+ "璇诲彇鎴愬姛锛�");
+ }
+
+
+ /// <summary>
+ /// 澧炲姞涓�鏉￠噸閲忎俊鎭�
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<ExpandoObject> EditModel([FromBody] dynamic model)
+ {
+ string lineId = model.lineId;
+ string realWeight = model.realWeight;
+ string realWeightTxt = model.realWeightTxt;
+ dynamic mObj = new ExpandoObject();
+ mObj.outMsg = "";
+ mObj.outSum = -1;
+ using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ {
+ using (var cmd = new SqlCommand("[work_weight_add]", conn))
{
- conn.Open();
- cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters =
+ try
{
+ conn.Open();
+ cmd.CommandType = CommandType.StoredProcedure;
+ SqlParameter[] parameters =
+ {
new("@outMsg", SqlDbType.NVarChar, 300),
new("@outSum", SqlDbType.Int),
new("@lineId", lineId),
new("@realWeight", realWeight),
new("@realWeightTxt", realWeightTxt),
- new("@inEdtUserGuid", _userGuid)
+ new("@inEdtUserGuid", _userGuid),
};
- parameters[0].Direction = ParameterDirection.Output;
- parameters[1].Direction = ParameterDirection.Output;
- foreach (var parameter in parameters)
- cmd.Parameters.Add(parameter);
- cmd.ExecuteNonQuery();
- mObj.outMsg = parameters[0].Value.ToString();
- mObj.outSum = int.Parse(parameters[1].Value.ToString());
- }
- catch (Exception ex)
- {
- LogHelper.Debug(ToString(),
- "work_weight_add error锛�" + ex.Message);
- mObj.outMsg = ex.Message;
- mObj.outSum = -1;
- }
- finally
- {
- conn.Close();
+ parameters[0].Direction = ParameterDirection.Output;
+ parameters[1].Direction = ParameterDirection.Output;
+ foreach (var parameter in parameters)
+ cmd.Parameters.Add(parameter);
+ cmd.ExecuteNonQuery();
+ mObj.outMsg = parameters[0].Value.ToString();
+ mObj.outSum = int.Parse(parameters[1].Value.ToString());
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Debug(ToString(),
+ "work_weight_add error锛�" + ex.Message);
+ mObj.outMsg = ex.Message;
+ mObj.outSum = -1;
+ }
+ finally
+ {
+ conn.Close();
+ }
}
}
+ if (mObj.outSum <= 0)
+ return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg);
+ return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg);
}
- if (mObj.outSum <= 0)
- return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception,
- mObj.outMsg);
- return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success,
- mObj.outMsg);
- }
-
- /// <summary>
- /// 璇诲彇iqc绉伴噸
- /// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<string?> GetIqcWeight([FromBody] dynamic model)
- {
- var rtnInt = "";
- var dset = new DataSet();
- try
+ /// <summary>
+ /// 璇诲彇iqc绉伴噸
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<string?> GetIqcWeight([FromBody] dynamic model)
{
- SqlParameter[] parameters =
+ string? rtnInt = "";
+ var dset = new DataSet();
+ try
{
- new("@inLineId", "")
- };
- dset = DbHelperSQL.RunProcedure("iqc_detect01_get_weight",
- parameters, "0");
- }
- catch (Exception ex)
- {
- LogHelper.Debug(ToString(), "GetIqcWeight error锛�" + ex.Message);
- }
-
- if (dset != null && dset.Tables.Count > 0 &&
- dset.Tables[0].Rows.Count > 0)
- rtnInt = dset.Tables[0].Rows[0]["realWeight"].ToString();
- return ReturnDto<string>.QuickReturn(rtnInt, ReturnCode.Success,
- "璇诲彇鎴愬姛锛�");
- }
-
-
- /// <summary>
- /// 缂栬緫iqc閲嶉噺
- /// </summary>
- /// <param name="model"></param>
- /// <returns></returns>
- [RequestMethod(RequestMethods.POST)]
- public ReturnDto<ExpandoObject> EditIqcWeight([FromBody] dynamic model)
- {
- string iqcGuid = model.iqcGuid;
- string weightType = model.weightType;
- string weight = model.weight;
- dynamic mObj = new ExpandoObject();
- mObj.outMsg = "";
- mObj.outSum = -1;
- using (var conn = new SqlConnection(DbHelperSQL.strConn))
- {
- using (var cmd = new SqlCommand("[iqc_detect01_edt_weight]", conn))
+ SqlParameter[] parameters =
+ {
+ new("@inLineId","")
+ };
+ dset = DbHelperSQL.RunProcedure("iqc_detect01_get_weight", parameters, "0");
+ }
+ catch (Exception ex)
{
- try
+ LogHelper.Debug(ToString(), "GetIqcWeight error锛�" + ex.Message);
+ }
+ if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0)
+ {
+ rtnInt = dset.Tables[0].Rows[0]["realWeight"].ToString();
+ }
+ return ReturnDto<string>.QuickReturn(rtnInt, ReturnCode.Success, "璇诲彇鎴愬姛锛�");
+ }
+
+
+ /// <summary>
+ /// 缂栬緫iqc閲嶉噺
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<ExpandoObject> EditIqcWeight([FromBody] dynamic model)
+ {
+ string iqcGuid = model.iqcGuid;
+ string weightType = model.weightType;
+ string weight = model.weight;
+ dynamic mObj = new ExpandoObject();
+ mObj.outMsg = "";
+ mObj.outSum = -1;
+ using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ {
+ using (var cmd = new SqlCommand("[iqc_detect01_edt_weight]", conn))
{
- conn.Open();
- cmd.CommandType = CommandType.StoredProcedure;
- SqlParameter[] parameters =
+ try
{
+ conn.Open();
+ cmd.CommandType = CommandType.StoredProcedure;
+ SqlParameter[] parameters =
+ {
new("@outMsg", SqlDbType.NVarChar, 300),
new("@outSum", SqlDbType.Int),
new("@weightType", weightType),
new("@weight", weight),
new("@iqcGuid", iqcGuid),
- new("@inEdtUserGuid", _userGuid)
+ new("@inEdtUserGuid", _userGuid),
};
- parameters[0].Direction = ParameterDirection.Output;
- parameters[1].Direction = ParameterDirection.Output;
- foreach (var parameter in parameters)
- cmd.Parameters.Add(parameter);
- cmd.ExecuteNonQuery();
- mObj.outMsg = parameters[0].Value.ToString();
- mObj.outSum = int.Parse(parameters[1].Value.ToString());
- }
- catch (Exception ex)
- {
- LogHelper.Debug(ToString(),
- "iqc_detect01_edt_weight error锛�" + ex.Message);
- mObj.outMsg = ex.Message;
- mObj.outSum = -1;
- }
- finally
- {
- conn.Close();
+ parameters[0].Direction = ParameterDirection.Output;
+ parameters[1].Direction = ParameterDirection.Output;
+ foreach (var parameter in parameters)
+ cmd.Parameters.Add(parameter);
+ cmd.ExecuteNonQuery();
+ mObj.outMsg = parameters[0].Value.ToString();
+ mObj.outSum = int.Parse(parameters[1].Value.ToString());
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Debug(ToString(), "iqc_detect01_edt_weight error锛�" + ex.Message);
+ mObj.outMsg = ex.Message;
+ mObj.outSum = -1;
+ }
+ finally
+ {
+ conn.Close();
+ }
}
}
+ if (mObj.outSum <= 0)
+ return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception, mObj.outMsg);
+ return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success, mObj.outMsg);
}
-
- if (mObj.outSum <= 0)
- return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Exception,
- mObj.outMsg);
- return ReturnDto<dynamic>.QuickReturn(mObj, ReturnCode.Success,
- mObj.outMsg);
}
-}
\ No newline at end of file
+}
--
Gitblit v1.9.3