//using iWare_SCADA_BusinessLogical.BLL;
|
//using iWare_SCADA_BusinessLogical.Utils;
|
//using iWare_SCADA_Model;
|
//using System;
|
//using System.Collections.Generic;
|
//using System.Data;
|
//using System.Globalization;
|
//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
|
//{
|
// /// <summary>
|
// /// OP05 打标完成标记，读取工控机中打印二维码信息
|
// /// </summary>
|
// public class DataCaptureHandler_OP0501 : DataCaptureHandler
|
// {
|
// public static readonly DataCaptureHandler_OP0501 Instance = new DataCaptureHandler_OP0501();
|
|
// public DataCaptureHandler_OP0501()
|
// {
|
// }
|
|
// 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> dataCaptureConfig)
|
// {
|
|
// }
|
// public override void DataCaptureStart()
|
// {
|
// if (IsCaptureflag)
|
// {
|
// //// plc连接
|
// //var plcService = PLCManger.GetSinglePLCService(_dataCaptureConfig);
|
// //if (plcService == null)
|
// //{
|
// // SystemValue.lbl_Alert_OP0501 = $"{RandomHelper.GenerateRandomCode(4)} 没有找到{_dataCaptureConfig.WorkingProcedure}的PLC设备";
|
// // return;
|
// //}
|
// //if (plcService != null && !plcService.IsConnected)
|
// //{
|
// // plcService.Close();
|
// // plcService.OpenService();
|
// //}
|
|
// string lastHandlerWorkPileIDForOP0501 = "";//最后一次处理的工件号
|
|
// while (true)
|
// {
|
// ThreadStatusMonitor threadStatusMonitor = new ThreadStatusMonitor();
|
// 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)
|
// //{
|
// // SystemValue.lbl_Alert_OP0501 = $" {RandomHelper.GenerateRandomCode(4)} {_dataCaptureConfig.WorkingProcedure} PLC连接已断开，正在尝试打开!";
|
// // plcService.Close();
|
// // plcService.OpenService();
|
// // Thread.Sleep(100);
|
// // continue;
|
// //}
|
// //else
|
// {
|
// //var value = plcService.ReadValuePoint(_dataCaptureConfig.DbNumber, _dataCaptureConfig.Offset, PLCManger.GetTypeForString(_dataCaptureConfig.DataCaptureColumnType));
|
// //if (SystemValue.value_OP0501.Equals("0") && value.ToString().Equals("1"))
|
// {//当上一标记位0，当前获取标记为1时，
|
// //触发操作, 并给静态变量赋值为1
|
// //业务代码
|
// //读码完成没啥业务操作，获取二维码，然后放到队列中
|
// #region 从工控机获取相关二维码
|
// var path = ConfigHelper.GetConfigString("WorkPeiceIDPath");//打码机打码二维码路径
|
// //扫描共享目录并将新的文件扫描返回 一般节拍在15秒左右（可以确认一下）
|
// //扫描修改时间在上次扫描时间之前10秒到当前时间的之间的文件
|
// var dataTime = CommonManager.Instance.CheackPath(Environment.CurrentDirectory + "\\LastModifyTime\\OP05-LastScapTime.txt", 4, -10);
|
// var scapEndTime = DateTimeHelper.GetDateTime();
|
// var newFiles = FileHelper.DetectNewFilesCSV(path, 60, Convert.ToDateTime(dataTime), scapEndTime);
|
|
|
// Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure),
|
// $"{_dataCaptureConfig.WorkingProcedure}工序读取工控机中二维码信息开始:{dataTime}");
|
|
// foreach (System.IO.FileInfo file in newFiles)
|
// {
|
// threadStatusMonitor.Threadlastmodifytime = DateTime.Now;
|
// Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure),
|
// $"{_dataCaptureConfig.WorkingProcedure}工序读取工控机中二维码信息,文件名:{file.FullName}");
|
// DataTable dt = null;
|
// dt = CSVHelper.ReadCSV(file.FullName);
|
// if (dt == null)
|
// {
|
// continue;
|
// }
|
// lock (SystemValue.lock5QRcodeList)
|
// {
|
// #region 清过期缓存
|
// try
|
// {
|
// //清过期缓存
|
// var lstRemoveKey = SystemValue.QRcodeList
|
// .Where(p => p.Value < DateTimeHelper.GetDateTime().AddMinutes(-600))
|
// .Select(p => p.Key).ToList();
|
// if (lstRemoveKey.Count > 0)
|
// {
|
// foreach (var key in lstRemoveKey) SystemValue.QRcodeList.Remove(key);
|
// Log4NetHelper.WriteInfoLog(LogType.PLCOP05, $"清除缓存数量：（{lstRemoveKey.Count}） 剩余缓存数量：（{SystemValue.QRcodeList.Count}）");
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// Log4NetHelper.WriteErrorLog(LogType.PLCOP05, "清除告警报文ID缓存错误！", ex);
|
// }
|
// #endregion
|
|
// ////筛选需要处理的二维码信息
|
// //DataRow[] drArr = dt.Select(" 扫码结果='成功'"); //查询
|
// //DataTable dtNew = dt.Clone();
|
// //for (int i = 0; i < drArr.Length; i++)
|
// //{
|
// // var now = DateTime.Now;
|
// // var list = drArr[i]["时间"].ToString().Split(':');
|
// // var d = new DateTime(now.Year, now.Month, now.Day, Convert.ToInt32(list[0]), Convert.ToInt32(list[1]), Convert.ToInt32(list[2]), DateTimeKind.Local);
|
// // //and 时间> '19:19:34:547'
|
// // if (Convert.ToDateTime(DateTime.Now.ToShortDateString() + " " +drArr[i]["时间"]).TimeOfDay> Convert.ToDateTime(DateTime.Now.ToShortDateString() + " 19:19:34:547").TimeOfDay)
|
// // dtNew.ImportRow(drArr[i]);
|
// // //获取到的工件号异常
|
// // SystemValue.lbl_Alert_OP0501 = $"{_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息：【" + WorkPieceID + "】长度异常，长度不等于22位";
|
// // Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure),
|
// // $"{_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息：【" + WorkPieceID + "】长度异常，长度不等于22位");
|
// //}
|
// DataTable newDt = new DataTable();
|
// var dates = file.Name.Split('-', '.');
|
// var date = string.Format("{0:D4}-{1:D2}-{2:D2}", int.Parse(dates[0]), int.Parse(dates[1]), int.Parse(dates[2]));
|
// if (DateTimeHelper.GetDateTime().Date != Convert.ToDateTime(date) && DateTimeHelper.GetDateTime().AddDays(-1).Date != Convert.ToDateTime(date))
|
// {
|
// continue;
|
// }
|
// DataRow[] filteredRows = new DataRow[dt.Rows.Count];
|
// if (dt.Rows.Count > 0)
|
// {
|
// int j = 0;
|
// var cache = DataCache.GetCache("OP501-LastTime");
|
// DateTime? lasttime = null;
|
// if (cache != null)
|
// {
|
// lasttime = Convert.ToDateTime(cache);
|
// }
|
|
// Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure),
|
// $"{_dataCaptureConfig.WorkingProcedure}工序读取工控机中二维码信息,工件最新时间:{(cache == null ? "无缓存" : cache.ToString())}");
|
// for (int i = dt.Rows.Count - 1; i >= 0; i--)
|
// {//降序，即优先读取最后一条数据
|
// string timeValue = " ";
|
// try
|
// {
|
// timeValue = dt.Rows[i]["时间"].ToString();
|
// string[] timeComponents = timeValue.Split(':');
|
// string correctedTime = string.Format("{0:D2}:{1:D2}:{2:D2}", int.Parse(timeComponents[0]), int.Parse(timeComponents[1]), int.Parse(timeComponents[2]));
|
// var newTime = date + " " + correctedTime;
|
// dt.Rows[i]["时间"] = newTime;
|
|
// var currrentTime = Convert.ToDateTime(dt.Rows[i]["时间"]);
|
// if (cache == null)
|
// {
|
// if (j == 0)
|
// {
|
// if (currrentTime > DateTimeHelper.GetDateTime().AddHours(-10))
|
// {
|
// lasttime = currrentTime;
|
// }
|
// }
|
// var oldTime = DateTime.Now.AddMinutes(-10);
|
// // if (currrentTime <= oldTime)
|
// if (lastHandlerWorkPileIDForOP0501 == Convert.ToString(dt.Rows[i]["打标内容"]))
|
// {//如果excel里的时间要比 当前前10分钟时间要早，那么我就忽略不处理。
|
// break;
|
// }
|
// filteredRows[j] = dt.Rows[i];
|
// }
|
// else
|
// {
|
// var cacheTime = Convert.ToDateTime(cache);
|
// //if (currrentTime <= cacheTime)
|
// if (lastHandlerWorkPileIDForOP0501 == Convert.ToString(dt.Rows[i]["打标内容"]))
|
// {//如果excel里的时间要比 我缓存中的时间要早，那么我就忽略不处理。
|
// break;
|
// }
|
// filteredRows[j] = dt.Rows[i];
|
// }
|
|
// if (currrentTime > DateTimeHelper.GetDateTime().AddHours(-10))
|
// {
|
// if (lasttime != null && lasttime < currrentTime)
|
// {
|
// lasttime = currrentTime;
|
// }
|
// }
|
// j++;
|
// }
|
// catch (Exception ex)
|
// {
|
// SystemValue.lbl_Alert_OP0501 = $" {_dataCaptureConfig.WorkingProcedure}文件打标时间[{timeValue}]异常，请查看日志！";
|
// Log4NetHelper.WriteErrorLog(LogType.PLCOP05, $" {_dataCaptureConfig.WorkingProcedure}文件打标时间,出现异常：", ex);
|
// }
|
// }
|
|
// filteredRows = filteredRows.Where(item => item != null).ToArray();
|
// // 设置缓存值
|
// DateTime absoluteExpiration = DateTime.Now.AddDays(30);
|
// TimeSpan slidingExpiration = TimeSpan.FromMinutes(20);
|
// if (slidingExpiration == TimeSpan.Zero)
|
// {
|
// absoluteExpiration = DateTime.Now.AddDays(30);
|
// }
|
// else
|
// {
|
// absoluteExpiration = DateTime.MaxValue;
|
// }
|
// DataCache.SetCache("OP501-LastTime", lasttime, absoluteExpiration, slidingExpiration);
|
// if (filteredRows.Count() <= 0)
|
// {
|
// continue;
|
// }
|
// if (file.LastAccessTime < Convert.ToDateTime(dataTime)) continue;
|
// using (StreamWriter writer = new StreamWriter(Environment.CurrentDirectory + "\\OP05-LastScapTime.txt", false))
|
// {
|
// dataTime = file.LastAccessTime.ToString();
|
// writer.Write(dataTime);
|
// }
|
// Log4NetHelper.WriteInfoLog(LogType.PLCOP05, $"读取到{filteredRows.Count()}行数据，时间范围是{filteredRows[j - 1]["时间"]}-{filteredRows[0]["时间"]}");
|
// }
|
|
// //// 工件号（二维码值）
|
// //string WorkPieceID = dt.Rows[0][""].ToString();
|
// //if (WorkPieceID.Length != 22)
|
// //{
|
// // //获取到的工件号异常
|
// // SystemValue.lbl_Alert_HMI01 = $"{_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息：【" + WorkPieceID + "】长度异常，长度不等于22位";
|
// // Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure),
|
// // $"{_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息：【" + WorkPieceID + "】长度异常，长度不等于22位");
|
// //}
|
|
|
// //SystemValue.QRcodeList.Add("", DateTimeHelper.GetDateTime());//二维码添加到列表中
|
|
// WorkPieceLog wplog = new WorkPieceLog();
|
// wplog.Id = Yitter.IdGenerator.YitIdHelper.NextId();
|
// wplog.WorkingProcedure = _dataCaptureConfig.WorkingProcedure; ;
|
// //wplog.EquipmentID = WorkingProcedure;
|
// wplog.Remarks = "cs";
|
// wplog.MonitoringPoint = DataCapturePointCode;
|
// //wplog.CreatedUserName = DataCapturePointCode;
|
// SystemBussinessHelper.SetWorkPieceLogMiddleForCreatedUserName(ref wplog, DataCapturePointCode, DataCapturePointCname);
|
// wplog.CreatedTime = DateTimeHelper.GetDateTime();
|
// wplog.UpdatedTime = DateTimeHelper.GetDateTime();
|
// wplog.UpdatedUserName = Environment.MachineName + "自动" + Thread.CurrentThread.ManagedThreadId.ToString();
|
// wplog.IsDeleted = false;
|
// wplog.EquipmentID = _dataCaptureConfig.EquipmentID;
|
|
// wplog.OnlineTime = DateTimeHelper.GetDateTime();//给上线时间用
|
|
// //wplog.QualityState = 1;
|
// wplog.QualityState = (int)QualityStateEnum.OK;//默认合格，OP05默认合格
|
|
// wplog.ProcessingDuration = 1;
|
// wplog.MachineToolState = 1;
|
// wplog.AlertType = 1;
|
// wplog.WorkPieceNumber = 1;
|
// wplog.WorkPieceOnlineTime = Convert.ToDateTime(dataTime);
|
// wplog.WorkPieceOfflineTime = Convert.ToDateTime(dataTime).AddHours(1);
|
// wplog.WorkPieceStartMachiningTime = Convert.ToDateTime(dataTime);
|
// wplog.WorkPieceEndMachiningTime = DateTime.Now.AddDays(7);
|
// wplog.KnifeEdgeNumber = 10;
|
// wplog.KnifeToolLife = 10;
|
// wplog.KnifeToolEarlyWarningLife = 3;
|
// wplog.KnifeToolSurplusLife = 10;
|
|
// //快速处理
|
// List<WorkPieceLog> wplogs = new List<WorkPieceLog>();
|
|
// foreach (var item in filteredRows)
|
// {
|
// if (item == null) break;
|
// wplog.Id = Yitter.IdGenerator.YitIdHelper.NextId();
|
// wplog.WorkPieceID = item["打标内容"].ToString();
|
// wplog.OfflineTime = Convert.ToDateTime(dataTime);
|
// wplog.Remarks = item["时间"].ToString() + "|" + item["打标内容"].ToString() + "|" + item["打标内容"].ToString() + "|" + item["扫码等级"].ToString() + "|" + item["扫码结果"].ToString();
|
// //转换
|
// WorkPieceLog newLog = EntityPropHelper.Mapper<WorkPieceLog, WorkPieceLog>(wplog);
|
// wplogs.Add(newLog);
|
// }
|
// //查询数据，过滤
|
// var queryList = wplogs.Select(x => x.WorkPieceID).ToList();
|
// List<WorkPieceProcess> new_exist_WorkPieceProcess = new List<WorkPieceProcess>();
|
// using (DbModel db = new DbModel())
|
// {
|
// //找到数据库中已有这个工序的数据
|
// new_exist_WorkPieceProcess = db.WorkPieceProcess.Where(o => queryList.Contains(o.WorkPieceID)
|
// && o.WorkingProcedureCurrent == _dataCaptureConfig.WorkingProcedure).ToList();
|
// }
|
// var querynew__exist_WorkPieceProcessList = new_exist_WorkPieceProcess.Select(x => x.WorkPieceID).ToList();
|
// //找到需要新增的数据
|
// wplogs = wplogs.Where(x => !querynew__exist_WorkPieceProcessList.Contains(x.WorkPieceID)).ToList();
|
// foreach (var item in wplogs)
|
// {
|
// Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure),
|
// $"{_dataCaptureConfig.WorkingProcedure}工序读取工控机中二维码信息,读取工件二维码:{item.WorkPieceID.ToString()}");
|
|
// WorkPieceInfoManager.ReadQRcode(wplog, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), null, _dataCaptureConfig.IsFeedback);
|
|
// threadStatusMonitor.Threadstatue = 1;
|
// }
|
|
// //记录下最后一个码
|
// lastHandlerWorkPileIDForOP0501 = Convert.ToString(dt.Rows[dt.Rows.Count - 1]["打标内容"]);
|
// }
|
// }
|
|
|
// #endregion
|
// //var fileCount = ((iWare_SCADA_BusinessLogical.Utils.FindFiles)newFiles).;
|
// //Log4NetHelper.WriteInfoLog(LogType.PLCOP05, $"扫描完成，共扫描到：（{fileCount.Count()}）个文件");
|
// }
|
// //SystemValue.value_OP0501 = value.ToString();
|
// }
|
// }
|
// catch (Exception ex)
|
// {
|
// threadStatusMonitor.ErrorMsg = $" {_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息,出现异常，请查看日志！";
|
|
// SystemValue.lbl_Alert_OP0501 = $" {_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息,出现异常，请查看日志！";
|
// Log4NetHelper.WriteErrorLog(LogType.PLCOP05, $" {_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息,出现异常：", ex);
|
// }
|
// finally
|
// {
|
// WorkPieceInfoManager.ThreadMonitor(threadStatusMonitor);
|
// }
|
// //线程多久执行一次（不包含业务处理时间）
|
// if (!_dataCaptureConfig.DataCaptureFrequency.HasValue || _dataCaptureConfig.DataCaptureFrequency < 10)
|
// {
|
// Thread.Sleep(3000);
|
// }
|
// else
|
// {
|
// Thread.Sleep(_dataCaptureConfig.DataCaptureFrequency.Value);
|
// }
|
// }
|
// }
|
// else
|
// {
|
// SystemValue.lbl_Alert_OP0501 = $"{_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息，不做校验，请确认配置信息！";
|
// Log4NetHelper.WriteInfoLog(LogType.PLCOP05, $"{_dataCaptureConfig.WorkingProcedure}工序打标完成标记，读取工控机中打印二维码信息，不做校验，请确认配置异常");
|
// }
|
|
// }
|
|
// }
|
//}
|
