From 00a72fff219241eb5b0405a066cc859d07cf7735 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 17 九月 2025 10:23:44 +0800
Subject: [PATCH] 1111
---
service/Warehouse/MesKwcxManager.cs | 60 +++++++++++++++++++++++++++++++++---------------------------
1 files changed, 33 insertions(+), 27 deletions(-)
diff --git a/service/Warehouse/MesKwcxManager.cs b/service/Warehouse/MesKwcxManager.cs
index f4c72cb..74b7559 100644
--- a/service/Warehouse/MesKwcxManager.cs
+++ b/service/Warehouse/MesKwcxManager.cs
@@ -1,7 +1,12 @@
-锘縰sing System.Text;
+锘縰sing Masuit.Tools;
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;
@@ -10,44 +15,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");
@@ -61,9 +66,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");
@@ -72,21 +77,22 @@
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