From 1f558de770e0e0517bc852c3e044e5147283c57f Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期三, 12 十一月 2025 14:31:44 +0800
Subject: [PATCH] 采购到货拒收功能
---
WebApi/Gs.Warehouse/Services/MesInvItemArnManager.cs | 175 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 175 insertions(+), 0 deletions(-)
diff --git a/WebApi/Gs.Warehouse/Services/MesInvItemArnManager.cs b/WebApi/Gs.Warehouse/Services/MesInvItemArnManager.cs
index 038af6c..9da5323 100644
--- a/WebApi/Gs.Warehouse/Services/MesInvItemArnManager.cs
+++ b/WebApi/Gs.Warehouse/Services/MesInvItemArnManager.cs
@@ -607,6 +607,7 @@
}
+
/// <summary>
/// 鏍规嵁鐢ㄦ埛閫夋嫨鐨勯噰璐槑缁唃uid锛岃鍙栭渶瑕佷綔鍏ュ簱鍒拌揣鍗曠殑鏄庣粏
/// </summary>
@@ -667,6 +668,180 @@
}
+
+ /// <summary>
+ /// 璇诲彇鍒楄〃锛屾敮鎸佸垎椤�
+ /// </summary>
+ /// <param name="model"></param>
+ /// <returns></returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<PageList<dynamic>> SelectMxForm([FromBody] dynamic model)
+ {
+ int currentPage = model.currentPage;
+ int everyPageSize = model.everyPageSize;
+ string sortName = model.sortName;
+ string keyWhere = model.keyWhere;
+ string inBusType = model.inBusType;
+ string inSupId = model.inSupId;
+ string inReceiveOrgId = model.inReceiveOrgId;
+ var dset = new DataSet();
+ try
+ {
+ using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ {
+ using (var cmd = new SqlCommand("[prc_cgdhdmx_select]", conn))
+ {
+ conn.Open();
+ cmd.CommandType = CommandType.StoredProcedure;
+ SqlParameter[] parameters =
+ {
+ new("@inCurrentPage", currentPage),
+ new("@inEveryPageSize", everyPageSize),
+ new("@inSortName", sortName),
+ new("@inSortOrder", ""),
+ new("@inQueryWhere", keyWhere),
+ new("@inBusType", inBusType),
+ new("@inSupId", inSupId),
+ new("@inP1", inReceiveOrgId),//缁勭粐
+ new("@inP2", "")
+ };
+ foreach (var parameter in parameters)
+ cmd.Parameters.Add(parameter);
+ using (var dt =
+ new SqlDataAdapter(cmd))
+ {
+ dt.Fill(dset, "0");
+ }
+ }
+ conn.Close();
+ }
+ }
+ catch (Exception ex)
+ {
+ LogHelper.Debug(ToString(), "GetListPage error锛�" + ex.Message);
+ return ReturnDto<PageList<dynamic>>.QuickReturn(
+ default(PageList<dynamic>), ReturnCode.Exception, "璇诲彇澶辫触");
+ }
+
+ var _pglist = new PageList<dynamic>
+ {
+ total = 0,
+ everyPageSize = 0,
+ pages = 0,
+ list = new List<dynamic>()
+ };
+ if (dset != null && dset.Tables.Count > 0 &&
+ dset.Tables[0].Rows.Count > 0) //鏈夋暟鎹�
+ {
+ var intTotal =
+ int.Parse(dset.Tables[1].Rows[0]["intTotal"].ToString());
+ var pages = intTotal % everyPageSize != 0
+ ? intTotal / everyPageSize + 1
+ : intTotal / everyPageSize;
+ _pglist.total = intTotal;
+ _pglist.everyPageSize = everyPageSize;
+ _pglist.pages = pages;
+ var _dy = dset.Tables[0].TableToDynamicList();
+ _pglist.list = _dy;
+ }
+
+ return ReturnDto<PageList<dynamic>>.QuickReturn(_pglist,
+ ReturnCode.Success, "璇诲彇鎴愬姛");
+ }
+
+
+ /// <summary>
+ /// 澶勭悊鍕鹃�夌殑閲囪喘鍒拌揣鏄庣粏鏁版嵁锛堟牴鎹甮uid闆嗗悎鎵ц鎿嶄綔锛�
+ /// </summary>
+ /// <param name="model">鍖呭惈鍕鹃�夌殑guid鍒楄〃锛堝姩鎬佺被鍨嬶紝閫傞厤鍓嶇浼犲叆鏍煎紡锛�</param>
+ /// <returns>澶勭悊缁撴灉锛堢鍚堥」鐩甊eturnDto<ExpandoObject>瑙勮寖锛�</returns>
+ [RequestMethod(RequestMethods.POST)]
+ public ReturnDto<ExpandoObject> SelectMxBtn([FromBody] dynamic model)
+ {
+ // 鍒濆鍖栬繑鍥炵殑鍔ㄦ�佺粨鏋滃璞�
+ dynamic result = new ExpandoObject();
+ result.outSum = -1; // 榛樿澶辫触鐘舵��
+ result.outMsg = "";
+
+ try
+ {
+ // 1. 瑙ｆ瀽鍓嶇浼犲叆鐨刧uid闆嗗悎
+ List<string> guidList = new List<string>();
+ if (model.guidList == null)
+ {
+ result.outMsg = "鏈紶鍏uid闆嗗悎";
+ return ReturnDto<ExpandoObject>.QuickReturn(result, ReturnCode.Default, result.outMsg);
+ }
+
+ foreach (var item in model.guidList)
+ {
+ string guid = item?.ToString()?.Trim();
+ if (!string.IsNullOrEmpty(guid))
+ {
+ guidList.Add(guid);
+ }
+ }
+
+ // 2. 鍙傛暟鏍￠獙
+ if (guidList.Count == 0)
+ {
+ result.outMsg = "鏈紶鍏ユ湁鏁堢殑guid鏁版嵁";
+ return ReturnDto<ExpandoObject>.QuickReturn(result, ReturnCode.Default, result.outMsg);
+ }
+
+ // 3. 璋冪敤瀛樺偍杩囩▼澶勭悊鍕鹃�夋暟鎹�
+ using (var conn = new SqlConnection(DbHelperSQL.strConn))
+ {
+ using (var cmd = new SqlCommand("[prc_cgdhdmx_handle_selected]", conn))
+ {
+ cmd.CommandType = CommandType.StoredProcedure;
+
+ // 澶勭悊guid闆嗗悎锛氳浆涓洪�傞厤瀛樺偍杩囩▼鐨勬牸寮�// 鐩存帴鎷兼帴绾疓UID锛岀敤|鍒嗛殧锛堟棤鍗曞紩鍙凤級
+ string guidStr = string.Join("|", guidList);
+ //string guidStr = string.Join("|", guidList.Select(g => $"'{g.Replace("'", "''")}'"));
+
+ // 瀹氫箟鍙傛暟锛堜笌瀛樺偍杩囩▼涓ユ牸鍖归厤锛岃緭鍑哄弬鏁板悗缁缃柟鍚戯級
+ SqlParameter[] parameters =
+ {
+ new SqlParameter("@outMsg", SqlDbType.NVarChar, 2500),
+ new SqlParameter("@outSum", SqlDbType.Int),
+ new SqlParameter("@inEdtUserGuid", _userGuid),
+ new SqlParameter("@inGuidList", guidStr),
+ new SqlParameter("@in1", "")
+ };
+
+ // 璁剧疆杈撳嚭鍙傛暟鏂瑰悜
+ parameters[0].Direction = ParameterDirection.Output;
+ parameters[1].Direction = ParameterDirection.Output;
+
+ // 寰幆娣诲姞鍙傛暟
+ foreach (var parameter in parameters)
+ {
+ cmd.Parameters.Add(parameter);
+ }
+
+ // 鎵ц瀛樺偍杩囩▼
+ conn.Open();
+ cmd.ExecuteNonQuery();
+
+ // 鑾峰彇瀛樺偍杩囩▼杈撳嚭缁撴灉
+ result.outSum = parameters[1].Value?.ToString();
+ result.outMsg = parameters[0].Value?.ToString();
+ }
+ }
+
+ // 4. 杩斿洖鏈�缁堢粨鏋�
+ return ReturnDto<ExpandoObject>.QuickReturn(result, ReturnCode.Success, result.outMsg);
+ }
+ catch (Exception ex)
+ {
+ // 寮傚父澶勭悊
+ LogHelper.Debug(ToString(), "SelectMxBtn鎺ュ彛澶勭悊寮傚父锛�" + ex.Message);
+ result.outMsg = "澶勭悊澶辫触锛�" + ex.Message;
+ return ReturnDto<ExpandoObject>.QuickReturn(result, ReturnCode.Exception, result.outMsg);
+ }
+ }
+
#endregion
--
Gitblit v1.9.3