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() { //计算大头孔直径,大头孔直径=(大头上面X方向直径+大头上面Y方向直径+大头下面X方向直径+大头下面Y方向直径)/4 List valueList = new List() { SystemHelper.GetDecimal(""), SystemHelper.GetDecimal("sss"), SystemHelper.GetDecimal("12.365"), SystemHelper.GetDecimal("201.24557"), SystemHelper.GetDecimal("100"), }; var bb = SystemHelper.CalcDecimalAvg(valueList, 3); Assert.Fail(); } [TestMethod] public void xx() { string path = ConfigHelper.GetConfigString("OP80QualityData_Test");//OP80的地址 var newFiles = FileHelper.DetectNewFilesCSV(path, 300, DateTime.Now.AddDays(-10), DateTime.Now.AddDays(1)); foreach (System.IO.FileInfo file in newFiles) { File.Move(file.FullName, "../CA4GC20TD_COPY/" + file.Name);//移动 } } [TestMethod] public void bb() { var aa = "-2024-06-16_08_43_23__part_"; var bb = aa.Split('-'); string cc = bb[0]; } [TestMethod] public void zzz() { WorkPieceLogMiddle logMiddle = new WorkPieceLogMiddle( ) { WorkingProcedure = "OP30" } ; QualityDataInfo qualityData = new QualityDataInfo(); //修改QualityDataInfo表 //重复收到质量信息,会覆盖之前的 EntityPropHelper.CopyProp(logMiddle, qualityData, WorkPieceInfoManager.GetQualityDataInfoUpdate(logMiddle, logMiddle.WorkingProcedure, logMiddle.MonitoringPoint));//指定修改字段 string cc = ""; } [TestMethod] public void pp() { Yitter.IdGenerator.IdGeneratorOptions options = new Yitter.IdGenerator.IdGeneratorOptions(1); Yitter.IdGenerator.YitIdHelper.SetIdGenerator(options); WorkPieceLogMiddle logMiddle = new WorkPieceLogMiddle( ) { WorkingProcedure = "OP30", WorkPieceID = "DZ045L2406240103521TAS", UpdatedTime = DateTime.Now, QualityState = (int)QualityStateEnum.NG, QualityNoOk = (int)QualityNoOkEnum.OP30涨断工位力矩超差, QualityNoOkReason = QualityNoOkEnum.OP30涨断工位力矩超差.ToString(), MonitoringPoint = "", QualityStateStr = "NG" } ; string WorkingProcedure = logMiddle.WorkingProcedure; //根据质量数据判断是否合格/不合格 【Editby shaocx,2024-06-25】 WorkPieceInfoManager.SetLogMiddleForQuality(ref logMiddle); //更新WorkPieceInfo表以及插入WorkPieceLog表和WorkPieceInfoLog表 QualityInfoCompleteManager.QualityInfoComplete(logMiddle, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure)); string cc = ""; } [TestMethod] public void aaaaa() { //获取OP70未结束的工件列表 var ooDateTime = Convert.ToDateTime("0001-01-01"); List 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 = ""; } } }