From 6257b90ed14829999c01e01253ca56ef86a9aaf9 Mon Sep 17 00:00:00 2001
From: fcx <2246384483@qq.com>
Date: 星期二, 25 十一月 2025 20:24:33 +0800
Subject: [PATCH] 计算=静音房良品数/总数=静音房合格率，包括今天在内往前推共3天的数值加到线头看板上，字段为：线体、日期、静音房合格率
---
StandardPda/MES.Service/service/Warehouse/WorkdaaManager .cs | 17 ++++++++++++++---
1 files changed, 14 insertions(+), 3 deletions(-)
diff --git a/StandardPda/MES.Service/service/Warehouse/WorkdaaManager .cs b/StandardPda/MES.Service/service/Warehouse/WorkdaaManager .cs
index a28807d..1ef8074 100644
--- a/StandardPda/MES.Service/service/Warehouse/WorkdaaManager .cs
+++ b/StandardPda/MES.Service/service/Warehouse/WorkdaaManager .cs
@@ -48,6 +48,10 @@
//string lineNo = apiResult.data.lineNo;
int quantity = apiResult.data.qualifiedQuantity; // 鍚堟牸鏁伴噺
+ int mUTEROOMTESTQUANTITY = apiResult.data.MUTEROOMTESTQUANTITY; // 闈欓煶鎴挎娴嬫暟
+
+ int mUTEROOMTESTPASSQUANTITY = apiResult.data.MUTEROOMTESTPASSQUANTITY; // 闈欓煶鎴垮悎鏍兼暟
+
//2.1鏂拌〃
@@ -57,6 +61,9 @@
//2.3 璁＄畻闇�瑕佹彃鍏ョ殑鏁伴噺
int insertQty = quantity - existedQty;
+
+ //璁＄畻闈欓煶鎴垮悎鏍肩巼
+ double Passrate = mUTEROOMTESTPASSQUANTITY / mUTEROOMTESTQUANTITY;
//2.4 鎻掑叆鏂拌褰�
if (insertQty >= 0)
@@ -84,15 +91,15 @@
if (count == 0)
{
// 鎻掑叆鏂版暟鎹�
- var insertSql = $"INSERT INTO mes_Report (ID, CREATE_DATE, Production_line, Quantity) " +
- $"VALUES (SEQ_MES_REPORT_ID.NEXTVAL,SYSDATE, '{lineNo}', {quantity})";
+ var insertSql = $"INSERT INTO mes_Report (ID, CREATE_DATE, Production_line, Quantity,MUTEROOMTESTQUANTITY,MUTEROOMTESTPASSQUANTITY,Passrate) " +
+ $"VALUES (SEQ_MES_REPORT_ID.NEXTVAL,SYSDATE, '{lineNo}','{quantity}','{mUTEROOMTESTQUANTITY}','{mUTEROOMTESTPASSQUANTITY}','{Passrate}')";
SQLHelper.ExecuteQuery(insertSql);
}
else
{
// 鏇存柊褰撳ぉ鐨勬暟鎹� 褰撳ぉ宸茬粡鏈夎繖涓嚎浣� 鈫� 鏇存柊璇ョ嚎浣撶殑鏁版嵁
var updateSql = $"UPDATE mes_Report " +
- $"SET Production_line = '{lineNo}', Quantity = {quantity} , CREATE_DATE = SYSDATE " +
+ $"SET Production_line = '{lineNo}', Quantity = '{quantity}',mUTEROOMTESTQUANTITY='{mUTEROOMTESTQUANTITY}',mUTEROOMTESTPASSQUANTITY='{mUTEROOMTESTPASSQUANTITY}' ,Passrate='{Passrate}', CREATE_DATE = SYSDATE " +
$"WHERE TRUNC(CREATE_DATE) = TRUNC(SYSDATE) and Production_line = '{lineNo}' ";
SQLHelper.ExecuteQuery(updateSql);
}
@@ -124,6 +131,10 @@
{
public string lineNo { get; set; }
public int qualifiedQuantity { get; set; }
+
+ public int MUTEROOMTESTQUANTITY { get; set; }
+
+ public int MUTEROOMTESTPASSQUANTITY { get; set; }
}
--
Gitblit v1.9.3