From 13b875793c17b3eb9437a8d2db65bab04f027e39 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 18 三月 2025 14:00:54 +0800
Subject: [PATCH] 111
---
StandardPda/MES.Service/service/QC/RKJService.cs | 58 +++++++++++++++++++++++-----------------------------------
1 files changed, 23 insertions(+), 35 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/RKJService.cs b/StandardPda/MES.Service/service/QC/RKJService.cs
index 6ad9bb9..20008bb 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)
{
@@ -462,10 +457,7 @@
})
.ToList();
- if (oqcReqList.Count <= 0)
- {
- return;
- }
+ if (oqcReqList.Count <= 0) return;
var qsItemOqcReq = oqcReqList.First(); // 鑾峰彇绗竴涓厓绱�
@@ -499,7 +491,7 @@
.ExecuteCommand();
if (count <= 0) return;
-
+
//鍙栨秷mes_inv_item_barcodes 鐨勬姤宸ユ爣璇� WORK_FLG 浣跨敤鏉＄爜
var executeCommand = db.Updateable<MesInvItemBarcodes>()
.SetColumns(a => a.WorkFlg == 1)
@@ -507,13 +499,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 +520,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,7 +597,7 @@
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, da.Daa015 == z.LineNo //,
//JoinType.Left,c.Bgr == d.UserNo
))
// .WhereIF(lineNo != null && lineNo.Length > 0,
@@ -629,8 +617,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 +641,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 +718,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 +838,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