计算=静音房良品数/总数=静音房合格率，包括今天在内往前推共3天的数值加到线头看板上，字段为：线体、日期、静音房合格率

fcx

2025-11-25 6257b90ed14829999c01e01253ca56ef86a9aaf9

计算=静音房良品数/总数=静音房合格率，包括今天在内往前推共3天的数值加到线头看板上，字段为：线体、日期、静音房合格率

 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; }
        }