From b646b9bee3991eb91fb916a290e5efb33eb5f68c Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期五, 18 四月 2025 19:13:40 +0800
Subject: [PATCH] 代码提交
---
StandardPda/MES.Service/service/QC/RKJService.cs | 66 ++++++++++++++-------------------
1 files changed, 28 insertions(+), 38 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/RKJService.cs b/StandardPda/MES.Service/service/QC/RKJService.cs
index 6ad9bb9..ef3aa9d 100644
--- a/StandardPda/MES.Service/service/QC/RKJService.cs
+++ b/StandardPda/MES.Service/service/QC/RKJService.cs
@@ -319,15 +319,10 @@
.Where(o => o.Id == detail.Gid)
.First();
- if (qsItemOqcReq == null)
- {
- throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
- }
+ if (qsItemOqcReq == null) throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu))
- {
throw new Exception("璇ユ楠屽崟宸�" + qsItemOqcReq.FcheckResu + "锛屼笉杩愯淇敼缁撴灉");
- }
var oracle = SqlSugarHelper.UseTransactionWithOracle(db =>
{
@@ -439,12 +434,12 @@
}
/// <summary>
- /// 褰撴楠屽崟涓嶅悎鏍兼椂锛�
- /// 鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG
- /// womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
- /// MES_SCGD_GX 妫�楠屾爣璇� CHECK_FLAG锛�('鈭�','脳')
- /// 閫氳繃mes_inv_item_in_c_details2鐨凪ES_SCGD_GX_ID杩炴帴
- ///</summary>
+ /// 褰撴楠屽崟涓嶅悎鏍兼椂锛�
+ /// 鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG
+ /// womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
+ /// MES_SCGD_GX 妫�楠屾爣璇� CHECK_FLAG锛�('鈭�','脳')
+ /// 閫氳繃mes_inv_item_in_c_details2鐨凪ES_SCGD_GX_ID杩炴帴
+ /// </summary>
private void setBarCodes(string? FcheckResu, QsItemOqcItemDetail detail,
SqlSugarClient db)
{
@@ -458,14 +453,13 @@
.Select((a, b, c) =>
new
{
- a.Id, a.BillNo, c.Daa001
+ a.Id,
+ a.BillNo,
+ c.Daa001
})
.ToList();
- if (oqcReqList.Count <= 0)
- {
- return;
- }
+ if (oqcReqList.Count <= 0) return;
var qsItemOqcReq = oqcReqList.First(); // 鑾峰彇绗竴涓厓绱�
@@ -477,7 +471,7 @@
JoinType.Left, a.Id == b.ItemInId))
.Where((a, b) => a.BillNo == qsItemOqcReq.BillNo)
.Select((a, b) => new
- { b.ItemBarcode, b.Quantity, b.MesScgdGxId })
+ { b.ItemBarcode, b.Quantity, b.MesScgdGxId })
.ToList();
var barCodes = mesInvItemInsList.Select(s => s.ItemBarcode).ToList();
@@ -499,7 +493,7 @@
.ExecuteCommand();
if (count <= 0) return;
-
+
//鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG 浣跨敤鏉＄爜
var executeCommand = db.Updateable<MesInvItemBarcodes>()
.SetColumns(a => a.WorkFlg == 1)
@@ -507,13 +501,11 @@
.ExecuteCommand();
if (executeCommand > 0)
- {
//womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
db.Updateable<Womdaa>()
.SetColumns(b => b.Daa011 == b.Daa011 + sumQty)
.Where(b => b.Daa001 == qsItemOqcReq.Daa001)
.ExecuteCommand();
- }
}
else if ("涓嶅悎鏍�".Equals(FcheckResu))
{
@@ -530,13 +522,11 @@
.ExecuteCommand();
if (executeCommand > 0)
- {
//womdaa 宸茬敓浜ч噺 DAA011鍔犲洖鏉＄爜鎶ュ伐鏁伴噺
db.Updateable<Womdaa>()
.SetColumns(b => b.Daa011 == b.Daa011 - sumQty)
.Where(b => b.Daa001 == qsItemOqcReq.Daa001)
.ExecuteCommand();
- }
}
}
@@ -609,8 +599,8 @@
c.Factory == ca.Factory,
JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo,
JoinType.Left, da.Daa001 == c.RbillNo,
- JoinType.Left, da.Daa015 == z.LineNo//,
- //JoinType.Left,c.Bgr == d.UserNo
+ JoinType.Left, da.Daa015 == z.LineNo //,
+ //JoinType.Left,c.Bgr == d.UserNo
))
// .WhereIF(lineNo != null && lineNo.Length > 0,
// (a, b, c, ca, m, da) => lineNo.Contains(da.Daa015))
@@ -629,8 +619,11 @@
//鍔犵瓫閫夋潯浠�,鏍规嵁渚涘簲鍟嗭紝鐗╂枡缂栫爜锛岀墿鏂欏悕绉版悳绱�
//.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue )
.WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "",
- (a, b, c, ca, m, da, z) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower())
- || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))
+ (a, b, c, ca, m, da, z) =>
+ b.ItemName.ToLower()
+ .Contains(queryObj.SearchValue.ToLower())
+ || a.ItemNo.ToLower()
+ .Contains(queryObj.SearchValue.ToLower()))
.Select((a, b, c, ca, m, da, z) => new QsItemOqcReq
{
BillNo = a.BillNo,
@@ -650,7 +643,7 @@
ItemInId = m.ItemInId,
Daa015 = da.Daa015,
LineNo = c.LineNo,
- Quantity = m.Quantity,
+ Quantity = m.Quantity
//Bgr = d.UserName
})
.OrderBy(a => a.CreateDate, OrderByType.Desc)
@@ -727,15 +720,10 @@
.Where(o => o.Id == detail.Gid)
.First();
- if (qsItemOqcReq == null)
- {
- throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
- }
+ if (qsItemOqcReq == null) throw new Exception("璇ユ楠屽崟涓嶅瓨鍦紝璇峰洖鍒板叆搴撴鍒楄〃閲嶆柊鏌ョ湅");
if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu))
- {
throw new Exception("璇ユ楠屽崟宸�" + qsItemOqcReq.FcheckResu + "锛屼笉杩愯淇敼缁撴灉");
- }
var withOracle = SqlSugarHelper.UseTransactionWithOracle(db =>
{
@@ -852,13 +840,15 @@
private bool isRk(int? gid)
{
var db = SqlSugarHelper.GetInstance();
- return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,MesInvItemStocks>(
- (a, b, c,d) => new JoinQueryInfos(
+ return db
+ .Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,
+ MesInvItemStocks>(
+ (a, b, c, d) => new JoinQueryInfos(
JoinType.Inner, a.BillNo == b.BillNo,
JoinType.Inner, b.Id == c.ItemInId,
- JoinType.Inner,c.ItemBarcode == d.ItemBarcode
+ JoinType.Inner, c.ItemBarcode == d.ItemBarcode
))
- .Where((a, b, c,d) => a.Id == gid)
+ .Where((a, b, c, d) => a.Id == gid)
.Count() > 0;
}
}
\ No newline at end of file
--
Gitblit v1.9.3