From 0aa54059b26e6641196e9953490dd18616e916e3 Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期三, 10 九月 2025 17:26:47 +0800 Subject: [PATCH] 精简修正代码 --- service/Warehouse/MesStrkManager.cs | 25 ++++++++++--------------- 1 files changed, 10 insertions(+), 15 deletions(-) diff --git a/service/Warehouse/MesStrkManager.cs b/service/Warehouse/MesStrkManager.cs index 3f684ad..c5f74be 100644 --- a/service/Warehouse/MesStrkManager.cs +++ b/service/Warehouse/MesStrkManager.cs @@ -1,16 +1,12 @@ -锘縰sing Masuit.Tools; -using MES.Service.Models; -using MES.Service.Modes; +锘縰sing System.Data; +using System.Data.SqlClient; +using Masuit.Tools; 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; namespace NewPdaSqlServer.service.Warehouse; @@ -39,8 +35,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, @@ -66,7 +62,7 @@ } /// <summary> - /// 鍙楁墭鍏ュ簱鍏ュ簱 + /// 鍙楁墭鍏ュ簱鍏ュ簱 /// </summary> /// <param name="unity"></param> /// <returns></returns> @@ -78,7 +74,8 @@ 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("鐢宠鍗曞彿涓嶅厑璁镐负绌�"); @@ -96,12 +93,11 @@ 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); @@ -115,7 +111,6 @@ return _strMsg; //return 0; - } catch (Exception ex) { -- Gitblit v1.9.3