修复 hmid更改合格状态，没清理 不合格原因的问题

schangxiang@126.com

2024-12-19 4422008672f79f74841e11f20430c5e76686e293

 DataCapture/iWare_SCADA_DataCapture/iWare_SCADA_Test/UnitTest1.cs

@@ -1,17 +1,131 @@
using iWare_SCADA_BusinessLogical;
using iWare_SCADA_BusinessLogical.BLL;
using iWare_SCADA_BusinessLogical.BLL.Important;
using iWare_SCADA_BusinessLogical.Utils;
using iWare_SCADA_Model;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Data.Entity.Validation;
using System.IO;
using System.Linq;

namespace iWare_SCADA_Test
{
    [TestClass]
    public class UnitTest1
    {


        [TestMethod]
        public void TestMethoEntityValidati2222zzz()
        {
            var hour = DateTime.Now.Hour;
            if (!(hour == 1 || hour == 3 || hour == 5 || hour == 6))
            {
                var ss = "";
            }
            else
            {
                var dd = "";
            }
        }

        [TestMethod]
        public void TestMethoEntityValidatizzz()
        {
            try
            {
                WorkPieceLog aa = null;
                using (DbModel db = new DbModel())
                {
                    aa = db.WorkPieceLog.Where(x => x.Id == 588877956636741).FirstOrDefault();
                }

                // aa.WorkPieceID = "DZ045L2409100102791PAT";
                var isRight = SystemBussinessHelper.ValidateIsRightWorkPieceID(aa.WorkPieceID);
                if (isRight)
                {
                }
            }
            catch (DbEntityValidationException dbEx)
            {
                //var bb = dbEx.EntityValidationErrors.ToList();
                //var pp = bb.First().ValidationErrors.ToList();
                //var z = JsonConvert.SerializeObject(pp);

                var errorMessages =
                    dbEx.EntityValidationErrors
                        .SelectMany(validationResult => validationResult.ValidationErrors)
                        .Select(m => m.ErrorMessage);

                var fullErrorMessage = string.Join(", ", errorMessages);

                //throw new DbEntityValidationException(exceptionMessage, exception.EntityValidationErrors);
            }
            catch (Exception)
            {

                throw;
            }


        }

        [TestMethod]
        public void TestMethoEntityValidationErrors()
        {
            var aa = "";
            WorkPieceInfo cur_db_info = new WorkPieceInfo()
            {
                WorkingProcedureCurrent = "OP05"
            };

            try
            {
                using (DbModel db = new DbModel())
                {
                    db.WorkPieceInfo.Add(cur_db_info);
                    db.SaveChanges();
                }
            }
            catch (DbEntityValidationException dbEx)
            {
                //var bb = dbEx.EntityValidationErrors.ToList();
                //var pp = bb.First().ValidationErrors.ToList();
                //var z = JsonConvert.SerializeObject(pp);

                var errorMessages =
                    dbEx.EntityValidationErrors
                        .SelectMany(validationResult => validationResult.ValidationErrors)
                        .Select(m => m.ErrorMessage);

                var fullErrorMessage = string.Join(", ", errorMessages);

                //throw new DbEntityValidationException(exceptionMessage, exception.EntityValidationErrors);
            }
            catch (Exception)
            {

                throw;
            }


        }


        [TestMethod]
        public void TestMetho22()
        {
            var aa = "";
            WorkPieceInfo cur_db_info = new WorkPieceInfo()
            {
                WorkingProcedureCurrent = "OP05"
            };
            WorkPieceInfoManager.SetWorkingProcedureCurrentForOP10(cur_db_info, ref aa);
        }

        [TestMethod]
        public void TestMethod1()
        {
@@ -79,19 +193,38 @@
                WorkingProcedure = "OP30",
                WorkPieceID = "DZ045L2406240103521TAS",
                UpdatedTime = DateTime.Now,
                QualityState = (int)QualityState.NG,
                QualityNoOk=(int)QualityNoOkEnum.OP30涨断工位力矩大,
                QualityNoOkReason= QualityNoOkEnum.OP30涨断工位力矩大.ToString(),
                QualityState = (int)QualityStateEnum.NG,
                QualityNoOk = (int)QualityNoOkEnum.OP30涨断工位力矩超差,
                QualityNoOkReason = QualityNoOkEnum.OP30涨断工位力矩超差.ToString(),
                MonitoringPoint = "",
                QualityStateStr="NG"
                QualityStateStr = "NG"
            }
           ;
            string WorkingProcedure = logMiddle.WorkingProcedure;
            //根据质量数据判断是否合格/不合格 【Editby shaocx,2024-06-25】
            WorkPieceInfoManager.SetLogMiddleForQuality(ref logMiddle);
           

            //更新WorkPieceInfo表以及插入WorkPieceLog表和WorkPieceInfoLog表
            WorkPieceInfoManager.QualityInfoComplete(logMiddle, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure));
            QualityInfoCompleteManager.QualityInfoComplete(logMiddle, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure));


            string cc = "";
        }

        [TestMethod]
        public void aaaaa()
        {
            //获取OP70未结束的工件列表
            var ooDateTime = Convert.ToDateTime("0001-01-01");
            List<WorkPieceProcess> noFinishWorkPieceProcessList = null;
            using (DbModel db = new DbModel())
            {
                var dateTime = DateTime.Now;
                noFinishWorkPieceProcessList = db.WorkPieceProcess.Where(x =>
                1 == 1
                  && x.WorkingProcedureCurrent == "OP70"
                  && x.EndTime == ooDateTime).ToList();
            }


            string cc = "";