using iWare_SCADA_BusinessLogical.BLL; using iWare_SCADA_BusinessLogical.Utils; using iWare_SCADA_Model; using iWare_SCADA_Model.MiddleModel; using System; using System.Collections.Generic; using System.IO; using System.Linq; using System.Text; using System.Threading; using System.Threading.Tasks; using System.Web.UI.WebControls; namespace iWare_SCADA_BusinessLogical { /// /// 测量完成标记 /// public class DataCaptureHandler_OP3002: DataCaptureHandler { public static readonly DataCaptureHandler_OP3002 Instance = new DataCaptureHandler_OP3002(); public DataCaptureHandler_OP3002() { } public override string WorkingProcedure { get { return _dataCaptureConfig.WorkingProcedure; } } public override string DataCapturePointCode { get { return _dataCaptureConfig.DataCapturePointCode; } } public override string DataCapturePointCname { get { return _dataCaptureConfig.DataCapturePointCname; } } public override void RefreshDataList(List dataCaptureConfig) { } public override void DataCaptureStart() { ThreadStatusMonitorMiddle threadStatusMonitor = new ThreadStatusMonitorMiddle(); if (IsCaptureflag) { //var plcService = PLCManger.GetSinglePLCService(_dataCaptureConfig); var plcService = SystemValue.GetPLCService(_dataCaptureConfig); if (plcService == null) { threadStatusMonitor.ErrorMsg = $"{RandomHelper.GenerateRandomCode(4)} 没有找到{_dataCaptureConfig.WorkingProcedure}的PLC设备"; return; } if (plcService != null && !plcService.IsConnected) { SystemValue.PLCServiceReconnect(plcService); //plcService.Close(); //plcService.OpenService(); } string Station = "03"; string value_02 = ""; string path = ConfigHelper.GetConfigString("OP30QualityDataForStation");//打码机打码二维码路径 if(string.IsNullOrEmpty(path)) { path = @"Z:\"; } if(DataCapturePointCode.Contains("CH3")) {//工位3 涨断力矩 path = path + "kistler_crack"; } else if (DataCapturePointCode.Contains("CH4")) {//工位4 预拧紧力矩 path = path + "Bosch_Rexroth"; } else if (DataCapturePointCode.Contains("CH5")) {//工位5 拧紧力矩 path = path + "Bosch_Rexroth"; } else if (DataCapturePointCode.Contains("CH6")) {//工位6 衬套压装力矩 path = path + "kistler_bush"; } // 质量信息:涨断力矩... 预拧紧力矩 预拧紧角度 终拧紧力矩 终拧紧角度 //kistler_crack 涨断力矩 工位3 涨断力矩(Y - Maximum) 质量结果(Result) //kistler_bush 压装力矩 工位6 衬套压装力矩(Y - Maximum) 衬套压装位移(Block X) 质量结果(Result) //Bosch_Rexroth /(Ch_0_1.csv / Ch_0_2.csv 两通道 同时取最新的(或者id对应?)) 预拧紧力矩工位4 预拧紧力矩(T + Nm) 质量结果(结果) 目前文件不能自动生成 博世 力士乐拧紧系统 //Bosch_Rexroth /(Ch_0_3.csv / Ch_0_4.csv 两通道 同时取最新的(或者id对应?)) 终拧紧工位5 拧紧力矩(T + Nm) 终拧紧角度 while (true) { threadStatusMonitor.ErrorMsg = ""; threadStatusMonitor.Threadcode = DataCapturePointCode; threadStatusMonitor.Threadcname = DataCapturePointCname; threadStatusMonitor.Threadendtime = DateTime.Now; //threadStatusMonitor.Threadlastmodifytime = DateTime.Now; threadStatusMonitor.Threadstatue = 0; threadStatusMonitor.ThreadId = Thread.CurrentThread.ManagedThreadId.ToString(); try { //_dataCaptureConfig if (plcService == null || !plcService.IsConnected) { threadStatusMonitor.ErrorMsg = $" {RandomHelper.GenerateRandomCode(4)} {_dataCaptureConfig.WorkingProcedure} PLC连接已断开,正在尝试打开!"; WorkPieceInfoManager.ThreadMonitor(threadStatusMonitor); SystemValue.PLCServiceReconnect(plcService); //plcService.Close(); //plcService.OpenService(); Thread.Sleep(100); continue; } else { var value = plcService.ReadValuePoint(_dataCaptureConfig.DbNumber, _dataCaptureConfig.Offset, PLCManger.GetTypeForString(_dataCaptureConfig.DataCaptureColumnType)); if (value_02.ToUpper().Equals("FALSE") && value.ToString().ToUpper().Equals("TRUE")) {//当上一标记位0,当前获取标记为1时, //触发操作, 并给静态变量赋值为1 //业务代码 threadStatusMonitor.Threadlastmodifytime = DateTime.Now; WorkPieceLogMiddle wplog = new WorkPieceLogMiddle(); wplog.Id = Yitter.IdGenerator.YitIdHelper.NextId(); wplog.WorkingProcedure = WorkingProcedure; wplog.EquipmentID = _dataCaptureConfig.EquipmentID; ; wplog.Remarks = WorkingProcedure; wplog.MonitoringPoint = DataCapturePointCode; wplog.CreatedTime = DateTimeHelper.GetDateTime(); wplog.CreatedUserName = DataCapturePointCode; wplog.UpdatedUserName = Environment.MachineName+"自动" + Thread.CurrentThread.ManagedThreadId.ToString(); wplog.UpdatedTime = DateTimeHelper.GetDateTime(); wplog.IsDeleted = false; wplog.QualityType = QualityType.Online.ToString(); ////扫描共享目录并将新的文件扫描返回 一般节拍在15秒左右(可以确认一下) ////扫描修改时间在上次扫描时间之前10秒到当前时间的之间的文件 //var startTime = CommonManager.Instance.CheackPath(Environment.CurrentDirectory + $"\\LastModifyTime\\OP30Station{Station}-LastScapTime.txt", 6, -10); //var endTime = DateTimeHelper.GetDateTime(); //var newFiles = FileHelper.DetectNewFilesCSV(path, 10, Convert.ToDateTime(startTime), endTime); //foreach (System.IO.FileInfo file in newFiles) //{ //} foreach (var col in colConfig.Where(o => o.DataCapturePointCode == DataCapturePointCode)) { try { var valuecol = plcService.ReadValuePoint(col.DbNumber, col.Offset, col.DataCaptureColumnLength.Value, PLCManger.GetTypeForString(col.DataCaptureColumnType)); //wplog.GetType().GetProperty(col.DataCaptureColumnTabelName).SetValue(wplog, valuecol);//给动态字段赋值 var set = wplog.GetType().GetProperty(col.DataCaptureColumnTabelName); if (set == null) { Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $" {DataCapturePointCode}工序监控测量完成标记 读取工件码动态由于字段名没找到,赋值【{WorkingProcedure ?? "空字符串"}】失败{wplog.Id}"); } set.SetValue(wplog, valuecol);//给动态字段赋值 } catch (Exception setex) { Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $" {DataCapturePointCode}工序监控测量完成标记 读取工件码动态赋值【{WorkingProcedure ?? "空字符串"}】异常{wplog.Id}", setex); } } try { if (WorkingProcedure.Equals("OP80")) { //OP80 需要扫描文件读取质量信息 //扫描修改时间在上次扫描时间之前60秒到当前时间的之间的文件 List files = new List(); var newFiles = FileHelper.DetectNewFilesCSV(path, 60, DateTimeHelper.GetDateTime(), DateTimeHelper.GetDateTime().AddHours(1)); foreach (var file in newFiles) { files.Add((FileInfo)file); } files = files.OrderByDescending(o => o.LastAccessTime).ToList(); foreach (var file in files) {//取倒序匹配的文件名为工件号的文件 if (file.Name.Contains(wplog.WorkPieceID)) { var datatable = CSVHelper.ReadCSVList(file.FullName); List rowFirst = new List(); List rowSecond = new List(); if (datatable.Count == 2) { rowFirst = datatable[0].Split(',').ToList(); rowSecond = datatable[1].Split(',').ToList(); //给相应质量数据赋值 wplog.OP80NewCode = rowSecond[1]; wplog.QualityOP80To1 = rowFirst[13]; } else { wplog.Remarks = (wplog.Remarks ?? "") + $"OP80下线完成读取文件{file.FullName}异常,行数不是2行"; } } else { Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"OP80下线完成读取文件{file.FullName}不是指定工件{wplog.WorkPieceID}"); } } } } catch (Exception ex) { threadStatusMonitor.ErrorMsg = $" {RandomHelper.GenerateRandomCode(4)} 读取{DataCapturePointCode}下线标记 出现异常,请查看日志!"; Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"OP80下线完成读取文件数据时异常,避免工序完成异常:", ex); } //更新WorkPieceInfo表以及插入WorkPieceLog表和WorkPieceInfoLog表 WorkPieceInfoManager.QualityInfoComplete(wplog, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure)); threadStatusMonitor.Threadstatue = 1; } value_02 = value.ToString(); } threadStatusMonitor.Remarks = $"abcdefg:{RandomHelper.GenerateRandomCode(4)}"; if (!_dataCaptureConfig.DataCaptureFrequency.HasValue || _dataCaptureConfig.DataCaptureFrequency < 10) { threadStatusMonitor.ThreadFrequency = 5000; Thread.Sleep(5000); } else { threadStatusMonitor.ThreadFrequency = _dataCaptureConfig.DataCaptureFrequency.Value; Thread.Sleep(_dataCaptureConfig.DataCaptureFrequency.Value); } } catch (Exception ex) { threadStatusMonitor.ErrorMsg = $" {RandomHelper.GenerateRandomCode(4)} 读取{DataCapturePointCode}工序监控测量标记 出现异常,请查看日志!"; Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"读取 {DataCapturePointCode}工序监控测量标记数据时异常:", ex); } finally { WorkPieceInfoManager.ThreadMonitor(threadStatusMonitor); } } } else { threadStatusMonitor.ErrorMsg = ""; threadStatusMonitor.Threadcode = DataCapturePointCode; threadStatusMonitor.Threadcname = DataCapturePointCname; threadStatusMonitor.Threadendtime = DateTime.Now; threadStatusMonitor.Threadlastmodifytime = DateTime.Now; threadStatusMonitor.Threadstatue = 0; threadStatusMonitor.ThreadId = Thread.CurrentThread.ManagedThreadId.ToString(); threadStatusMonitor.Remarks = $" {RandomHelper.GenerateRandomCode(4)} {DataCapturePointCode}工序监控测量标记 不做校验,请确认配置信息!"; WorkPieceInfoManager.ThreadMonitor(threadStatusMonitor); Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"读{DataCapturePointCode}工序监控测量标记 不做校验,请确认是否配置异常"); } } } }