From 3de16083a8f92fb30f4dcca90b1daa51556cf450 Mon Sep 17 00:00:00 2001 From: cnf <3200815559@qq.com> Date: 星期六, 30 八月 2025 14:54:31 +0800 Subject: [PATCH] 去掉空格 --- WebApi/Gs.Wom/Service/WomdaaManager.cs | 70 +++++++++++++++++++++++++++++++++++ 1 files changed, 70 insertions(+), 0 deletions(-) diff --git a/WebApi/Gs.Wom/Service/WomdaaManager.cs b/WebApi/Gs.Wom/Service/WomdaaManager.cs index 6606a62..d380820 100644 --- a/WebApi/Gs.Wom/Service/WomdaaManager.cs +++ b/WebApi/Gs.Wom/Service/WomdaaManager.cs @@ -720,4 +720,74 @@ "璇诲彇鎴愬姛锛�"); } + /// <summary> + /// 鎾ゅ洖鎶ュ伐 + /// </summary> + /// <param name="mode"></param> + /// <returns></returns> + [RequestMethod(RequestMethods.POST)] + public ReturnDto<ExpandoObject> EditModelChbg([FromBody] dynamic mode) + { + string _billNo = mode.billNo; + string _inFieldValue = mode.inFieldValue; + string _proName = "prc_pda_scbg_withdraw"; + dynamic m = new ExpandoObject(); + m.outSum = -1; + m.outMsg = ""; + + if (!Guid.TryParse(_userGuid, out Guid userGuid)) + throw new ArgumentException("鏃犳晥鐨� UserGuid"); + using (var conn = new SqlConnection(DbHelperSQL.strConn)) + { + using (var cmd = new SqlCommand(_proName, conn)) + { + try + { + conn.Open(); + cmd.CommandType = CommandType.StoredProcedure; + // 鎸夌収瀛樺偍杩囩▼瀹氫箟鐨勯『搴忔坊鍔犲弬鏁� + SqlParameter[] parameters = + { + // 杈撳叆鍙傛暟锛堟寜椤哄簭锛� + new SqlParameter("@inEdtUserGuid", SqlDbType.UniqueIdentifier) { Value = userGuid }, + new SqlParameter("@inOrderGuid", SqlDbType.UniqueIdentifier) { Value = DBNull.Value }, // 浼犲叆null + new SqlParameter("@pi_inventoryAppBillNo", SqlDbType.NVarChar, 100) { Value = string.Empty }, + new SqlParameter("@inBarcodeGuids", SqlDbType.NVarChar, -1) { Value = _billNo ?? (object)DBNull.Value }, + new SqlParameter("@in1", SqlDbType.NVarChar, 100) { Value = string.Empty }, + new SqlParameter("@in2", SqlDbType.NVarChar, 100) { Value = string.Empty }, + new SqlParameter("@in3", SqlDbType.NVarChar, 100) { Value = string.Empty }, + + // 杈撳嚭鍙傛暟锛堟渶鍚庯級 + new SqlParameter("@outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output }, + new SqlParameter("@outSum", SqlDbType.Int) { Direction = ParameterDirection.Output } + }; + + foreach (var parameter in parameters) + cmd.Parameters.Add(parameter); + + cmd.ExecuteNonQuery(); + + m.outMsg = parameters[7].Value?.ToString() ?? ""; // @outMsg鏄8涓弬鏁帮紙绱㈠紩7锛� + if (parameters[8].Value != DBNull.Value && parameters[8].Value != null) + { + m.outSum = Convert.ToInt32(parameters[8].Value); // @outSum鏄9涓弬鏁帮紙绱㈠紩8锛� + } + } + catch (Exception ex) + { + LogHelper.Debug(ToString(), + "prc_pda_scbg_withdraw error锛�" + ex.Message); + m.outMsg = ex.Message; + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default, + ex.Message); + } + finally + { + conn.Close(); + } + } + } + return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Success, "鎿嶄綔鎴愬姛锛�"); + } + } \ No newline at end of file -- Gitblit v1.9.3