From c9ddf07c010e3b3b1bb4169f3ac34f684937d257 Mon Sep 17 00:00:00 2001
From: sjz <1240968267@qq.com>
Date: 星期二, 11 十一月 2025 17:08:16 +0800
Subject: [PATCH] 优化
---
WebApi/Gs.Warehouse/Services/MesInvItemMovesManager.cs | 75 +++++++++++++++++++++----------------
1 files changed, 43 insertions(+), 32 deletions(-)
diff --git a/WebApi/Gs.Warehouse/Services/MesInvItemMovesManager.cs b/WebApi/Gs.Warehouse/Services/MesInvItemMovesManager.cs
index 04720d6..56c2f08 100644
--- a/WebApi/Gs.Warehouse/Services/MesInvItemMovesManager.cs
+++ b/WebApi/Gs.Warehouse/Services/MesInvItemMovesManager.cs
@@ -215,8 +215,7 @@
}
catch (Exception ex)
{
- LogHelper.Debug(ToString(),
- "prc_move_edt error锛�" + ex.Message);
+ LogHelper.Debug(ToString(),"prc_move_edt error锛�" + ex.Message);
mObj.outMsg = ex.Message;
mObj.outSum = -1;
}
@@ -257,26 +256,23 @@
{
new("@outMsg", SqlDbType.NVarChar, 300),
new("@outSum", SqlDbType.Int),
- new("@inOrderGuid",
- CheckGuid(guid)
- ? guid
- : DBNull.Value),
+ new("@inOrderGuid", CheckGuid(guid)? guid : DBNull.Value),
new("@inEdtUserGuid", _userGuid),
new("@inMxGuid", mxGuid)
};
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(),
- "prc_move_del error锛�" + ex.Message);
+ LogHelper.Debug(ToString(),"prc_move_del error锛�" + ex.Message);
_outMsg = ex.Message;
_outSum = -1;
}
@@ -288,8 +284,7 @@
}
if (_outSum <= 0)
- return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception,
- _outMsg);
+ return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Exception,_outMsg);
return ReturnDto<int>.QuickReturn(rtnInt, ReturnCode.Success, _outMsg);
}
@@ -317,7 +312,7 @@
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] parameters =
{
- new("@outMsg", SqlDbType.NVarChar, 300),
+ new("@outMsg", SqlDbType.NVarChar, 300),
new("@outSum", SqlDbType.Int),
new("@inEdtUserGuid", _userGuid),
new("@inOrderGuid", _guid),
@@ -328,7 +323,9 @@
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
foreach (var parameter in parameters)
+ {
cmd.Parameters.Add(parameter);
+ }
cmd.ExecuteNonQuery();
m.outMsg = parameters[0].Value.ToString();
m.outSum = int.Parse(parameters[1].Value.ToString());
@@ -337,8 +334,7 @@
{
LogHelper.Debug(ToString(), "prc_move_submit:" + ex.Message);
m.outMsg = ex.Message;
- return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,
- ex.Message);
+ return ReturnDto<dynamic>.QuickReturn(m, ReturnCode.Default,ex.Message);
}
finally
{
@@ -362,6 +358,7 @@
string sortName = model.sortName;
string keyWhere = model.keyWhere;
string workId = model.workId;
+ string ftype = model.ftype;
var dset = new DataSet();
try
{
@@ -375,17 +372,19 @@
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] parameters =
{
- new("@inCurrentPage", currentPage),
- new("@inEveryPageSize", everyPageSize),
- new("@inSortName", sortName),
- new("@inSortOrder", ""),
- new("@inQueryWhere", keyWhere),
- new("@workId", workId),
- new("@inP1", ""),
- new("@inP2", "")
- };
+ new("@inCurrentPage", currentPage),
+ new("@inEveryPageSize", everyPageSize),
+ new("@inSortName", sortName),
+ new("@inSortOrder", ""),
+ new("@inQueryWhere", keyWhere),
+ new("@workId", workId),
+ new("@inP1", ""),
+ new("@inP2", "")
+ };
foreach (var parameter in parameters)
+ {
cmd.Parameters.Add(parameter);
+ }
using (var dt = new SqlDataAdapter(cmd))
{
dt.Fill(dset, "0");
@@ -401,17 +400,20 @@
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] parameters =
{
- new("@inCurrentPage", currentPage),
- new("@inEveryPageSize", everyPageSize),
- new("@inSortName", sortName),
- new("@inSortOrder", ""),
- new("@inQueryWhere", keyWhere),
- new("@workId", workId),
- new("@inP1", ""),
- new("@inP2", "")
- };
+ new("@inCurrentPage", currentPage),
+ new("@inEveryPageSize", everyPageSize),
+ new("@inSortName", sortName),
+ new("@inSortOrder", ""),
+ new("@inQueryWhere", keyWhere),
+ new("@workId", workId),
+ new("@inP1", ""),
+ new("@inP2", "")
+ };
foreach (var parameter in parameters)
+ {
cmd.Parameters.Add(parameter);
+ }
+
using (var dt = new SqlDataAdapter(cmd))
{
dt.Fill(dset, "0");
@@ -535,6 +537,7 @@
{
var intArray = model.lst.ToObject<string[]>();
string workId = model.workId;
+ string ftype = model.ftype;
var sbLine = new StringBuilder();
foreach (var str in intArray)
{
@@ -548,6 +551,10 @@
{
if (workId == "1")
{
+ if (ftype == "濮斿(WW)")
+ {
+ return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Exception, "濮斿");
+ }
using (var cmd = new SqlCommand("[prc_db_scdd_select_to_grid]", conn))
{
try
@@ -577,6 +584,10 @@
}
else
{
+ if (ftype == "鏍囧噯(NORMAL)")
+ {
+ return ReturnDto<List<dynamic>>.QuickReturn(lst, ReturnCode.Exception, "鐢熶骇");
+ }
using (var cmd = new SqlCommand("[prc_db_wwdd_select_to_grid]", conn))
{
try
--
Gitblit v1.9.3