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}工序打标完成标记，读取工控机中打印二维码信息，不做校验，请确认配置异常");
|
}
|
|
}
|
|
}
|
}
|
