From 0aa54059b26e6641196e9953490dd18616e916e3 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 10 九月 2025 17:26:47 +0800
Subject: [PATCH] 精简修正代码
---
service/Warehouse/MesKwcxManager.cs | 60 +++++++++++++++++++++++++++---------------------------------
1 files changed, 27 insertions(+), 33 deletions(-)
diff --git a/service/Warehouse/MesKwcxManager.cs b/service/Warehouse/MesKwcxManager.cs
index 74b7559..f4c72cb 100644
--- a/service/Warehouse/MesKwcxManager.cs
+++ b/service/Warehouse/MesKwcxManager.cs
@@ -1,12 +1,7 @@
-锘縰sing Masuit.Tools;
+锘縰sing System.Text;
using NewPdaSqlServer.DB;
-using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using SqlSugar;
-using System.Data;
-using System.Data.SqlClient;
-using System.Text;
-using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
namespace NewPdaSqlServer.service.Warehouse;
@@ -15,44 +10,44 @@
public dynamic GetBarInfoList(dynamic unity)
{
var sqlParams = new List<SugarParameter>
- {
- new("@deptSectionCode", unity.deptSectionCode),
- new("@rkDate", string.IsNullOrWhiteSpace(unity.rkDate?.ToString()) ? DBNull.Value : unity.rkDate),
- new("@zkChecked", unity.zkChecked?.ToString() == "True" ? 1 : unity.zkChecked?.ToString() == "False" ? 0 : DBNull.Value)
- };
+ {
+ new("@deptSectionCode", unity.deptSectionCode),
+ new("@rkDate",
+ string.IsNullOrWhiteSpace(unity.rkDate?.ToString())
+ ? DBNull.Value
+ : unity.rkDate),
+ new("@zkChecked",
+ unity.zkChecked?.ToString() == "True" ? 1 :
+ unity.zkChecked?.ToString() == "False" ? 0 : DBNull.Value)
+ };
- var sql2 = new StringBuilder("exec prc_pda_kwcx_barInfoList @deptSectionCode, @rkDate, @zkChecked");
+ var sql2 = new StringBuilder(
+ "exec prc_pda_kwcx_barInfoList @deptSectionCode, @rkDate, @zkChecked");
var list = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);
- if (list.Count < 1)
- {
- throw new Exception("璇ユ潯浠朵笅鏃犲搴斿簱浣嶄俊鎭紒");
- }
+ if (list.Count < 1) throw new Exception("璇ユ潯浠朵笅鏃犲搴斿簱浣嶄俊鎭紒");
return list;
}
+
public dynamic GetBarInfo(dynamic unity)
{
- var sqlParams = new List<SugarParameter> { };
+ var sqlParams = new List<SugarParameter>();
var sql2 = new StringBuilder(@"exec prc_pda_kwcx_barInfo @BARCODE");
sqlParams.Add(new("@BARCODE", unity.barcode));
var list = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);
- if (list.Count < 1)
- {
- throw new Exception("璇ユ潯浠朵笅鏃犲搴旀潯鐮佷俊鎭紒");
- }
+ if (list.Count < 1) throw new Exception("璇ユ潯浠朵笅鏃犲搴旀潯鐮佷俊鎭紒");
return list[0];
}
public dynamic GetKWList(dynamic unity)
{
-
- var sqlParams = new List<SugarParameter> { };
+ var sqlParams = new List<SugarParameter>();
var sql2 = new StringBuilder(@"
select depot_code as code, depot_name as name from MES_DEPOTS");
@@ -66,9 +61,9 @@
public dynamic GetKWInfo(dynamic unity)
{
var sqlParams = new List<SugarParameter>
- {
- new("@depot_code", unity.code)
- };
+ {
+ new("@depot_code", unity.code)
+ };
var sql2 = new StringBuilder("exec prc_pda_kwcx_kwInfo @depot_code");
@@ -77,22 +72,21 @@
return KWInfo;
}
- public dynamic GetItemInfoList(dynamic unity,dynamic RequestInfo)
+ public dynamic GetItemInfoList(dynamic unity, dynamic RequestInfo)
{
- var sqlParams = new List<SugarParameter> { };
+ var sqlParams = new List<SugarParameter>();
var orgId = RequestInfo.OrgId;
- var sql2 = new StringBuilder(@"exec prc_pda_kwcx_itemInfo @barCode,@itemNo,@orgId");
+ var sql2 =
+ new StringBuilder(
+ @"exec prc_pda_kwcx_itemInfo @barCode,@itemNo,@orgId");
sqlParams.Add(new("@barCode", unity.barCode));
sqlParams.Add(new("@itemNo", unity.itemNo));
sqlParams.Add(new("@orgId", orgId));
var list = Db.Ado.SqlQuery<dynamic>(sql2.ToString(), sqlParams);
- if (list.Count < 1)
- {
- throw new Exception("璇ユ潯浠朵笅鏃犲搴旀潯鐮佷俊鎭紒");
- }
+ if (list.Count < 1) throw new Exception("璇ユ潯浠朵笅鏃犲搴旀潯鐮佷俊鎭紒");
return list;
}
--
Gitblit v1.9.3