From 1cc3df41303aab8216e211e81b4582791e469e90 Mon Sep 17 00:00:00 2001 From: kyy <3283105747@qq.com> Date: 星期六, 26 七月 2025 17:43:55 +0800 Subject: [PATCH] 工序维护更新 --- WebApi/Gs.Wom/WorkService/WorkTechniqueController.cs | 61 ++++++++++++++++++++++++++++++ 1 files changed, 61 insertions(+), 0 deletions(-) diff --git a/WebApi/Gs.Wom/WorkService/WorkTechniqueController.cs b/WebApi/Gs.Wom/WorkService/WorkTechniqueController.cs index 25c4145..805642a 100644 --- a/WebApi/Gs.Wom/WorkService/WorkTechniqueController.cs +++ b/WebApi/Gs.Wom/WorkService/WorkTechniqueController.cs @@ -292,6 +292,67 @@ return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); } + /// <summary> + /// 鍒犻櫎涓昏〃鎴栨槑缁� + /// </summary> + /// <param name="model"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<int?> DeleteMode2OrMx([FromBody] dynamic model) + { + int? rtnInt = (int)ReturnCode.Default; + Guid? guid = model.guid; + string mxGuid2 = model.mxGuid2; + var _outMsg = ""; + var _outSum = -1; + using (var conn = new SqlConnection(DbHelperSQL.strConn)) + { + //using (var cmd = new SqlCommand("[work_technique_del]", conn)) + using (var cmd = new SqlCommand("[mes_prod_gx_del2]", conn)) + { + try + { + conn.Open(); + cmd.CommandType = CommandType.StoredProcedure; + SqlParameter[] parameters = + { + new("@outMsg", SqlDbType.NVarChar, 300), + new("@outSum", SqlDbType.Int), + new("@inOrderGuid", + CheckGuid(guid) + ? guid + : DBNull.Value), + new("@inEdtUserGuid", _userGuid), + new("@inMxGuid", mxGuid2) + }; + 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(), + "work_technique error锛�" + ex.Message); + _outMsg = ex.Message; + _outSum = -1; + } + finally + { + conn.Close(); + } + } + } + + if (_outSum <= 0) + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception, + _outMsg); + return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg); + } /// <summary> /// 澶嶅埗鐗╂枡椤圭洰 -- Gitblit v1.9.3