From 1b3db8f5683373dd8e179b006e7314783dd1f9db Mon Sep 17 00:00:00 2001 From: cnf <3200815559@qq.com> Date: 星期三, 10 九月 2025 14:42:12 +0800 Subject: [PATCH] 文件补充 --- WebApi/Gs.Pda/Service/PqcManager.cs | 257 +++++++++++++++++++++++++------------------------- 1 files changed, 128 insertions(+), 129 deletions(-) diff --git a/WebApi/Gs.Pda/Service/PqcManager.cs b/WebApi/Gs.Pda/Service/PqcManager.cs index e193c52..f9fc23e 100644 --- a/WebApi/Gs.Pda/Service/PqcManager.cs +++ b/WebApi/Gs.Pda/Service/PqcManager.cs @@ -8,149 +8,148 @@ using Microsoft.AspNetCore.Mvc; using static Gs.Toolbox.UtilityHelper; -namespace Gs.Pda.Service; - -[ApiGroup(ApiGroupNames.PDA)] -public class PqcManager : IRomteService +namespace Gs.Pda.Service { - private readonly IHttpContextAccessor _http; - /// <summary> - /// 鐢ㄦ埛Code,鐢ㄦ埛Guid,缁勭粐ID - /// </summary> - private readonly string _userCode, _userGuid, _orgFids; - - public PqcManager(IHttpContextAccessor httpContextAccessor) + [ApiGroup(ApiGroupNames.PDA)] + public class PqcManager: IRomteService { - _http = httpContextAccessor; - (_userCode, _userGuid, _orgFids) = GetUserGuidAndOrgGuid(_http); - } - - // LogHelper.Debug("GetUserGuidAndOrgGuid:", ex.Message); - - /// <summary> - /// 棣栨/宸℃杈撳叆妫�楠屽�� - /// </summary> - /// <param name="model"></param> - /// <returns></returns> - /// <summary> - /// 褰曞叆妫�楠岀粨鏋� - /// </summary> - /// <param name="model"></param> - /// <returns></returns> - [RequestMethod(RequestMethods.POST)] - public ReturnDto<int?> AddIpqcJyz([FromBody] dynamic model) - { - string inOrderGuid1 = model.inOrderGuid1; //杩欐槸妫�楠屽崟guid - string inOrderGuid5 = model.inOrderGuid5; //杩欐槸鎶芥牱鐨刧uid - string inP1 = model.inP1; //杩欐槸9锛屾湁鍙兘鏄�19锛屾垨鑰�0k-19,鎴栬�卬g-19 - var _outMsg = ""; - int? _outSum = -1; - using (var conn = new SqlConnection(DbHelperSQL.strConn)) + private readonly IHttpContextAccessor _http; + /// <summary> + /// 鐢ㄦ埛Code,鐢ㄦ埛Guid,缁勭粐ID + /// </summary> + private readonly string _userCode, _userGuid, _orgFids; + public PqcManager(IHttpContextAccessor httpContextAccessor) { - 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(), - "ipqc_detect01_panding error锛�" + ex.Message); - _outMsg = ex.Message; - _outSum = -1; - } - finally - { - conn.Close(); - } - } + _http = httpContextAccessor; + (_userCode, _userGuid, _orgFids) = GetUserGuidAndOrgGuid(_http); } - if (_outSum <= 0) - return ReturnDto<string>.QuickReturn(_outSum, - ReturnCode.Exception, _outMsg); - return ReturnDto<string>.QuickReturn(_outSum, - ReturnCode.Success, _outMsg); - } + // LogHelper.Debug("GetUserGuidAndOrgGuid:", ex.Message); - - /// <summary> - /// 鍒犻櫎妫�楠岀粨鏋� - /// </summary> - /// <param name="model"></param> - /// <returns></returns> - [RequestMethod(RequestMethods.POST)] - public ReturnDto<int?> DeleteIpqcJyz([FromBody] dynamic model) - { - string inOrderGuid1 = model.inOrderGuid1; //杩欐槸妫�楠屽崟guid - string inOrderGuid5 = model.inOrderGuid5; //杩欐槸鎶芥牱鐨刧uid - string inOrderGuid12 = model.inOrderGuid12; //杩欐槸鎶芥牱鐨刧uid - string inP1 = model.inP1; //杩欐槸9锛屾湁鍙兘鏄�19锛屾垨鑰�0k-19,鎴栬�卬g-19 - var _outMsg = ""; - int? _outSum = -1; - using (var conn = new SqlConnection(DbHelperSQL.strConn)) + /// <summary> + /// 棣栨/宸℃杈撳叆妫�楠屽�� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + /// <summary> + /// 褰曞叆妫�楠岀粨鏋� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> AddIpqcJyz([FromBody] dynamic model) { - using (var cmd = new SqlCommand("[ipqc_QADETAIL12_DELETE]", conn)) + string inOrderGuid1 = model.inOrderGuid1; //杩欐槸妫�楠屽崟guid + string inOrderGuid5 = model.inOrderGuid5; //杩欐槸鎶芥牱鐨刧uid + string inP1 = model.inP1; //杩欐槸9锛屾湁鍙兘鏄�19锛屾垨鑰�0k-19,鎴栬�卬g-19 + var _outMsg = ""; + int? _outSum = -1; + using (var conn = new SqlConnection(DbHelperSQL.strConn)) { - try + using (var cmd = new SqlCommand("[ipqc_detect01_panding]", conn)) { - conn.Open(); - cmd.CommandType = CommandType.StoredProcedure; - SqlParameter[] parameters = + try { - new("@outMsg", SqlDbType.NVarChar, 300), - new("@outSum", SqlDbType.Int), - new("@inEdtUserGuid", _userGuid), - new("@inOrderGuid1", inOrderGuid1), - new("@inOrderGuid5", inOrderGuid5), - new("@inOrderGuid12", inOrderGuid12), - 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(), - "ipqc_detect01_panding error锛�" + ex.Message); - _outMsg = ex.Message; - _outSum = -1; - } - finally - { - conn.Close(); + 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(), + "ipqc_detect01_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); } - if (_outSum <= 0) + + + /// <summary> + /// 鍒犻櫎妫�楠岀粨鏋� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteIpqcJyz([FromBody] dynamic model) + { + string inOrderGuid1 = model.inOrderGuid1; //杩欐槸妫�楠屽崟guid + string inOrderGuid5 = model.inOrderGuid5; //杩欐槸鎶芥牱鐨刧uid + string inOrderGuid12 = model.inOrderGuid12; //杩欐槸鎶芥牱鐨刧uid + string inP1 = model.inP1; //杩欐槸9锛屾湁鍙兘鏄�19锛屾垨鑰�0k-19,鎴栬�卬g-19 + var _outMsg = ""; + int? _outSum = -1; + using (var conn = new SqlConnection(DbHelperSQL.strConn)) + { + using (var cmd = new SqlCommand("[ipqc_QADETAIL12_DELETE]", 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("@inOrderGuid12", inOrderGuid12), + 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(), + "ipqc_detect01_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.Exception, _outMsg); - return ReturnDto<string>.QuickReturn(_outSum, - ReturnCode.Success, _outMsg); + ReturnCode.Success, _outMsg); + } } -} \ No newline at end of file +} -- Gitblit v1.9.3