From 8b7abd97e7b69800789134ed8e809e19a5b5ba74 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期三, 17 九月 2025 00:30:27 +0800
Subject: [PATCH] 111
---
service/Warehouse/MesCgthSqManager.cs | 87 +++++++++++++++++++++++++------------------
1 files changed, 50 insertions(+), 37 deletions(-)
diff --git a/service/Warehouse/MesCgthSqManager.cs b/service/Warehouse/MesCgthSqManager.cs
index 4c92478..feadad4 100644
--- a/service/Warehouse/MesCgthSqManager.cs
+++ b/service/Warehouse/MesCgthSqManager.cs
@@ -5,8 +5,8 @@
using NewPdaSqlServer.Dto.service;
using NewPdaSqlServer.entity;
using NewPdaSqlServer.entity.Base;
+using NewPdaSqlServer.util;
using SqlSugar;
-using static Microsoft.EntityFrameworkCore.DbLoggerCategory;
namespace NewPdaSqlServer.service.Warehouse;
@@ -24,10 +24,12 @@
{
if (string.IsNullOrEmpty(query.billNo)) throw new Exception("鐢宠鍗曞彿涓虹┖");
- var mesInvItemOuts = base.GetSingle(it => it.BillNo == query.billNo && it.Status == true);
+ var mesInvItemOuts = base.GetSingle(it =>
+ it.BillNo == query.billNo && it.Status == true);
if (mesInvItemOuts == null) throw new Exception("閲囪喘閫�璐х敵璇峰崟涓嶅瓨鍦ㄦ垨鏈鏍�");
- var sql = string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.SQ_NUM FQty,A.YS_NUM SQty,A.SQ_NUM - A.YS_NUM DSQty,
+ var sql = string.Format(
+ @"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,A.SQ_NUM FQty,A.YS_NUM SQty,A.SQ_NUM - A.YS_NUM DSQty,
dbo.F_QX_GETRECODEPOTSE(A.ITEM_ID,A.depot_id,'','') as RecoKw
fROM MES_CGTH_SQ_DETAIL A
LEFT JOIN MES_CGTH_SQ B ON A.MID = B.ID
@@ -36,10 +38,7 @@
var womdabs = Db.Ado.SqlQuery<ItemDetailModel>(sql);
- if(womdabs.Count < 1)
- {
- throw new Exception("璇ラ噰璐��璐х敵璇峰崟鏄庣粏涓嶅瓨鍦�");
- }
+ if (womdabs.Count < 1) throw new Exception("璇ラ噰璐��璐х敵璇峰崟鏄庣粏涓嶅瓨鍦�");
var DS_list = womdabs.Where(s => s.DSQty > 0).ToList();
@@ -69,11 +68,11 @@
throw new ApplicationException("GUID杞崲閿欒"); // 濡傛灉杞崲澶辫触锛屽垯鎶涘嚭寮傚父
// 浣跨敤SqlSugar妗嗘灦鏌ヨMesInvItemOutItems鍜孧esItems琛紝鏍规嵁ItemId杩涜鍐呰繛鎺�
- var mesInvItemOutItemsList = Db.Queryable<MesCgthSqDetail, MesItems>(
- (c, s) => new object[]
- {
- JoinType.Inner, c.ItemId == s.Id // 鍐呰繛鎺ユ潯浠�
- }).Where((c, s) => c.Mid == parsedGuid) // 鏍规嵁ItemOutId杩囨护
+ var mesInvItemOutItemsList = Db
+ .Queryable<MesCgthSqDetail, MesItems>((c, s) => new object[]
+ {
+ JoinType.Inner, c.ItemId == s.Id // 鍐呰繛鎺ユ潯浠�
+ }).Where((c, s) => c.Mid == parsedGuid) // 鏍规嵁ItemOutId杩囨护
.Select<MesCgthSqDetail>((c, s) =>
new MesCgthSqDetail // 閫夋嫨骞舵槧灏勫埌MesInvItemOutItems瀵硅薄
{
@@ -104,7 +103,8 @@
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
if (query.userName.IsNullOrEmpty()) throw new Exception("鐢ㄦ埛鍚嶄笉鍏佽涓虹┖");
- if (query.billNo.IsNullOrEmpty()) throw new Exception("鐢宠鍗曞彿涓嶅厑璁镐负绌�"); if (query.barcode.IsNullOrEmpty()) throw new Exception("鏉＄爜涓嶅厑璁镐负绌�");
+ if (query.billNo.IsNullOrEmpty()) throw new Exception("鐢宠鍗曞彿涓嶅厑璁镐负绌�");
+ if (query.barcode.IsNullOrEmpty()) throw new Exception("鏉＄爜涓嶅厑璁镐负绌�");
using (var cmd = new SqlCommand("[prc_pda_CGTH]", conn))
{
@@ -172,7 +172,7 @@
var _strMsg = "";
var _intSum = "";
- var _cfBar = "";//鎷嗗垎鍚庢潯鐮�
+ var _cfBar = ""; //鎷嗗垎鍚庢潯鐮�
using (var conn = new SqlConnection(DbHelperSQL.strConn))
{
using (var cmd = new SqlCommand("[prc_pda_CGTH_CF]", conn))
@@ -208,8 +208,8 @@
var dto = new ProductionPickDto
{
daa001 = query.billNo,
- barcode = query.barcode,//鍘熸潯鐮�
- cfBarcode = _cfBar//鎷嗗垎鍚庢潯鐮�
+ barcode = query.barcode, //鍘熸潯鐮�
+ cfBarcode = _cfBar //鎷嗗垎鍚庢潯鐮�
};
return dto;
@@ -228,7 +228,7 @@
/// <summary>
- /// 閲囪喘鎵爜楠岄��
+ /// 閲囪喘鎵爜楠岄��
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
@@ -237,7 +237,8 @@
/// <exception cref="Exception"></exception>
public dynamic ScanCgyt(dynamic query)
{
- if (query == null) throw new ArgumentNullException(nameof(query), "鍙傛暟瀵硅薄涓嶈兘涓� null");
+ if (query == null)
+ throw new ArgumentNullException(nameof(query), "鍙傛暟瀵硅薄涓嶈兘涓� null");
// 2. 浣跨敤 string.IsNullOrEmpty 鐩存帴鍒ゆ柇瀛楃涓插睘鎬э紙閬垮厤 NullReferenceException锛�
if (string.IsNullOrEmpty(query.userName?.ToString()))
@@ -253,11 +254,16 @@
cmd.CommandType = CommandType.StoredProcedure;
var parameters = new SqlParameter[]
{
- new("@pi_user", SqlDbType.NVarChar, 100) { Value = query.userName },
- new("@pi_barcode", SqlDbType.NVarChar, 100) { Value = query.barcode },
- new("@po_outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
- new("@po_outSum", SqlDbType.Int) { Direction = ParameterDirection.Output },
- new("@po_ygdh", SqlDbType.NVarChar, 200) { Direction = ParameterDirection.Output }
+ new("@pi_user", SqlDbType.NVarChar, 100)
+ { Value = query.userName },
+ new("@pi_barcode", SqlDbType.NVarChar, 100)
+ { Value = query.barcode },
+ new("@po_outMsg", SqlDbType.NVarChar, 2000)
+ { Direction = ParameterDirection.Output },
+ new("@po_outSum", SqlDbType.Int)
+ { Direction = ParameterDirection.Output },
+ new("@po_ygdh", SqlDbType.NVarChar, 200)
+ { Direction = ParameterDirection.Output }
};
cmd.Parameters.AddRange(parameters);
@@ -267,7 +273,7 @@
var result = new
{
result = parameters[3].Value.ToString(),
- barcode = query.barcode,
+ query.barcode,
ytdh = parameters[4].Value.ToString(),
msg = parameters[2].Value.ToString()
};
@@ -281,7 +287,7 @@
}
/// <summary>
- /// 鍒犻櫎楠岄��鍗�
+ /// 鍒犻櫎楠岄��鍗�
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
@@ -290,7 +296,8 @@
/// <exception cref="Exception"></exception>
public dynamic deleteCgyt(dynamic query)
{
- if (query == null) throw new ArgumentNullException(nameof(query), "鍙傛暟瀵硅薄涓嶈兘涓� null");
+ if (query == null)
+ throw new ArgumentNullException(nameof(query), "鍙傛暟瀵硅薄涓嶈兘涓� null");
// 2. 浣跨敤 string.IsNullOrEmpty 鐩存帴鍒ゆ柇瀛楃涓插睘鎬э紙閬垮厤 NullReferenceException锛�
if (string.IsNullOrEmpty(query.userName?.ToString()))
@@ -306,10 +313,14 @@
cmd.CommandType = CommandType.StoredProcedure;
var parameters = new SqlParameter[]
{
- new("@pi_user", SqlDbType.NVarChar, 100) { Value = query.userName },
- new("@pi_ytdh", SqlDbType.NVarChar, 100) { Value = query.ytdh },
- new("@po_outMsg", SqlDbType.NVarChar, 2000) { Direction = ParameterDirection.Output },
- new("@po_outSum", SqlDbType.Int) { Direction = ParameterDirection.Output }
+ new("@pi_user", SqlDbType.NVarChar, 100)
+ { Value = query.userName },
+ new("@pi_ytdh", SqlDbType.NVarChar, 100)
+ { Value = query.ytdh },
+ new("@po_outMsg", SqlDbType.NVarChar, 2000)
+ { Direction = ParameterDirection.Output },
+ new("@po_outSum", SqlDbType.Int)
+ { Direction = ParameterDirection.Output }
};
cmd.Parameters.AddRange(parameters);
@@ -319,7 +330,7 @@
var result = new
{
result = parameters[3].Value.ToString(),
- msg = parameters[2].Value.ToString(),
+ msg = parameters[2].Value.ToString()
};
if (result.result == "-1")
@@ -331,18 +342,19 @@
}
/// <summary>
- /// 鑾峰彇楠岄��鍗曞凡鎵墿鏂欎俊鎭�
+ /// 鑾峰彇楠岄��鍗曞凡鎵墿鏂欎俊鎭�
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic getYtItem(string ytdh)
{
- if (string.IsNullOrEmpty(ytdh?.ToString()))
+ if (string.IsNullOrEmpty(ytdh))
throw new ArgumentException("楠岄��鍗曞彿涓嶅厑璁镐负绌�", nameof(ytdh));
var sqlParams = new List<SugarParameter> { new("@ytdh", ytdh) };
- var sql1 = @"SELECT C.item_id,C.item_no,C.item_name,C.item_model,A.quantity
+ var sql1 =
+ @"SELECT C.item_id,C.item_no,C.item_name,C.item_model,A.quantity
FROM MES_INV_ITEM_CGYT_ITEMS A
LEFT JOIN MES_INV_ITEM_CGYT B ON A.item_cgyt_id = B.GUID
LEFT JOIN MES_ITEMS C ON A.item_id = C.item_id
@@ -359,18 +371,19 @@
}
/// <summary>
- /// 鑾峰彇楠岄��鍗曞凡鎵潯鐮佷俊鎭�
+ /// 鑾峰彇楠岄��鍗曞凡鎵潯鐮佷俊鎭�
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public dynamic getYtBarInfo(string ytdh)
{
- if (string.IsNullOrEmpty(ytdh?.ToString()))
+ if (string.IsNullOrEmpty(ytdh))
throw new ArgumentException("楠岄��鍗曞彿涓嶅厑璁镐负绌�", nameof(ytdh));
var sqlParams = new List<SugarParameter> { new("@ytdh", ytdh) };
- var sql1 = @"SELECT C.item_id,C.item_no,C.item_name,C.item_model,A.quantity,A.ITEM_BARCODE
+ var sql1 =
+ @"SELECT C.item_id,C.item_no,C.item_name,C.item_model,A.quantity,A.ITEM_BARCODE
FROM MES_INV_ITEM_CGYT_C_DETAILS A
LEFT JOIN MES_INV_ITEM_CGYT B ON A.item_cgyt_id = B.GUID
LEFT JOIN MES_ITEMS C ON A.item_id = C.item_id
--
Gitblit v1.9.3