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/MesStrkManager.cs | 26 ++++++++++++++++----------
1 files changed, 16 insertions(+), 10 deletions(-)
diff --git a/service/Warehouse/MesStrkManager.cs b/service/Warehouse/MesStrkManager.cs
index c5f74be..4152ae9 100644
--- a/service/Warehouse/MesStrkManager.cs
+++ b/service/Warehouse/MesStrkManager.cs
@@ -1,12 +1,17 @@
-锘縰sing System.Data;
-using System.Data.SqlClient;
-using Masuit.Tools;
+锘縰sing Masuit.Tools;
+using MES.Service.Models;
+using MES.Service.Modes;
using NewPdaSqlServer.DB;
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.entity.Base;
using NewPdaSqlServer.util;
+using OracleInternal.Sharding;
using SqlSugar;
+using SqlSugar.Extensions;
+using System.Data;
+using System.Data.SqlClient;
+using DbHelperSQL = NewPdaSqlServer.DB.DbHelperSQL;
namespace NewPdaSqlServer.service.Warehouse;
@@ -35,8 +40,8 @@
{
// 鍏宠仈鏌ヨ鐗╂枡琛ㄣ�佺墿鏂欐槑缁嗚〃鍜岀墿鏂欏熀纭�淇℃伅琛�
var mesItemTblDetails = Db
- .Queryable<MesShouTuo, MesShouTuoDetail, MesItems>((a, b, c) =>
- new JoinQueryInfos(
+ .Queryable<MesShouTuo, MesShouTuoDetail, MesItems>(
+ (a, b, c) => new JoinQueryInfos(
JoinType.Left,
a.Guid == b.PGuid,
JoinType.Left,
@@ -62,7 +67,7 @@
}
/// <summary>
- /// 鍙楁墭鍏ュ簱鍏ュ簱
+ /// 鍙楁墭鍏ュ簱鍏ュ簱
/// </summary>
/// <param name="unity"></param>
/// <returns></returns>
@@ -74,8 +79,7 @@
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
if (unity.userName.IsNullOrEmpty()) throw new Exception("鐢ㄦ埛鍚嶄笉鍏佽涓虹┖");
- if (unity.sectionCode.IsNullOrEmpty())
- throw new Exception("搴撲綅缂栧彿涓嶅厑璁镐负绌�");
+ if (unity.sectionCode.IsNullOrEmpty()) throw new Exception("搴撲綅缂栧彿涓嶅厑璁镐负绌�");
if (unity.barcode.IsNullOrEmpty()) throw new Exception("鏉＄爜涓嶅厑璁镐负绌�");
if (unity.billNo.IsNullOrEmpty()) throw new Exception("鐢宠鍗曞彿涓嶅厑璁镐负绌�");
@@ -93,11 +97,12 @@
new("@pi_user", unity.userName),
new("@pi_barcode", unity.barcode),
new("@pi_sectionCode", unity.sectionCode),
- new("@pi_billno", unity.billNo)
+ new("@pi_billno", unity.billNo),
+
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Direction = ParameterDirection.Output;
- // parameters[2].Direction = ParameterDirection.Output;
+ // parameters[2].Direction = ParameterDirection.Output;
foreach (var parameter in parameters)
cmd.Parameters.Add(parameter);
@@ -111,6 +116,7 @@
return _strMsg;
//return 0;
+
}
catch (Exception ex)
{
--
Gitblit v1.9.3