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;
|
using static System.Net.WebRequestMethods;
|
|
namespace iWare_SCADA_BusinessLogical
|
{
|
/// <summary>
|
/// 工序完成
|
/// </summary>
|
public class DataCaptureHandler_05 : DataCaptureHandler
|
{
|
public static readonly DataCaptureHandler_05 Instance = new DataCaptureHandler_05();
|
|
public DataCaptureHandler_05()
|
{
|
}
|
|
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 (SystemValue.isStartedModel)
|
{
|
var plcService = PLCManger.GetSinglePLCService(_dataCaptureConfig);
|
WorkPieceLogMiddle wplog = new WorkPieceLogMiddle();
|
wplog.Id = Yitter.IdGenerator.YitIdHelper.NextId();
|
wplog.WorkingProcedure = WorkingProcedure;
|
wplog.EquipmentID = WorkingProcedure;
|
wplog.Remarks = WorkingProcedure;
|
wplog.MonitoringPoint = DataCapturePointCode;
|
wplog.WorkPieceID = "123456";
|
wplog.CreatedTime = DateTimeHelper.GetDateTime();
|
wplog.CreatedUserName = DataCapturePointCode;
|
wplog.IsDeleted = false;
|
|
|
wplog.WorkPieceID = WorkPieceID;
|
wplog.EquipmentID = _dataCaptureConfig.EquipmentID;
|
wplog.UpdatedTime = DateTimeHelper.GetDateTime();
|
wplog.UpdatedUserName = DataCapturePointCode;
|
//更新WorkPieceInfo表以及插入WorkPieceLog表和WorkPieceInfoLog表
|
WorkPieceInfoManager.WorkingProcedureComplete(wplog, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure));
|
|
return;
|
}
|
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 value_05 = "";
|
string path = ConfigHelper.GetConfigString("OP80QualityData");//OP80的地址
|
//string path = "C:\\Users\\SY-PC\\Desktop\\FO";//OP80的地址
|
DateTime? fileFindTime = null;
|
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
|
{
|
Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(_dataCaptureConfig.WorkingProcedure), $" {DataCapturePointCode}工序开始获取标志位");
|
var value = plcService.ReadValuePoint(_dataCaptureConfig.DbNumber, _dataCaptureConfig.Offset, PLCManger.GetTypeForString(_dataCaptureConfig.DataCaptureColumnType));
|
if (value_05.ToUpper().Equals("FALSE") && value.ToString().ToUpper().Equals("TRUE"))
|
{//当上一标记位0，当前获取标记为1时，
|
//触发操作, 并给静态变量赋值为1
|
//业务代码
|
Log4NetHelper.WriteInfoLog(PLCManger.GetLogTypeForWorkingProcedure(_dataCaptureConfig.WorkingProcedure), $" {DataCapturePointCode}工序获取到下线标志位");
|
|
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.UpdatedTime = DateTimeHelper.GetDateTime();
|
wplog.UpdatedUserName = Environment.MachineName + "自动" + Thread.CurrentThread.ManagedThreadId.ToString();
|
wplog.IsDeleted = false;
|
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(_dataCaptureConfig.WorkingProcedure), $" {DataCapturePointCode}工序监控读码标记 读取工件码动态由于字段名没找到，赋值【{_dataCaptureConfig.WorkingProcedure ?? "空字符串"}】失败{wplog.Id}");
|
}
|
set.SetValue(wplog, valuecol);//给动态字段赋值
|
}
|
catch (Exception setex)
|
{
|
Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(_dataCaptureConfig.WorkingProcedure), $" {DataCapturePointCode}工序监控读码标记 读取工件码动态赋值【{_dataCaptureConfig.WorkingProcedure ?? "空字符串"}】异常{wplog.Id},赋值列名[{col.DataCaptureColumnTabelName ?? "空字符串"}]", setex);
|
}
|
}
|
|
//特殊处理OP80 【Editby shaocx,2024-06-15】
|
if (WorkingProcedure.Equals("OP80"))
|
{
|
wplog.GetQcDataFlag = 0;
|
}
|
//注释下面的方法，优化程序 【Editby shaocx,2024-06-15】
|
/*
|
try
|
{
|
if (WorkingProcedure.Equals("OP80"))
|
{
|
var time = DateTimeHelper.GetDateTime();
|
if (fileFindTime == null)
|
{
|
fileFindTime = time.AddMinutes(-10);
|
}
|
//OP80 需要扫描文件读取质量信息
|
//扫描修改时间在上次扫描时间之前30秒到当前时间的之间的文件
|
List<FileInfo> files = new List<FileInfo>();
|
var newFiles = FileHelper.DetectNewFilesCSV(path, 300, fileFindTime.Value, time.AddHours(2));
|
foreach (var file in newFiles)
|
{
|
files.Add((FileInfo)file);
|
}
|
files = files.OrderByDescending(o => o.LastWriteTime).ToList();
|
Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"OP80下线完成读取到文件{files.Count()}个工件{wplog.WorkPieceID} 时间{fileFindTime.Value.ToString()}");
|
|
foreach (var file in files)
|
{//取倒序匹配的文件名为工件号的文件
|
if (file.Name.Contains(wplog.WorkPieceID))
|
{
|
Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"OP80下线完成读取到文件{file.Name}，是指定的工件{wplog.WorkPieceID}");
|
|
var datatable = CSVHelper.ReadCSVList(file.FullName);
|
List<string> rowFirst = new List<string>();
|
List<string> rowSecond = new List<string>();
|
if (datatable.Count == 2)
|
{
|
rowFirst = datatable[0].Split(',').ToList();
|
rowSecond = datatable[1].Split(',').ToList();
|
if (rowSecond.Count < 11)
|
{
|
continue;
|
}
|
//日期和时间 批号/标识号 嵌套号/主轴号 操作符 文本 测量机 过程参数 测量系统 过程参数值 序列号 零件识别号 1
|
OP80Info oP80Info = new OP80Info();
|
oP80Info.日期和时间 = rowSecond[0];
|
oP80Info.批号 = rowSecond[1];
|
oP80Info.嵌套号 = rowSecond[2];
|
oP80Info.操作符 = rowSecond[3];
|
oP80Info.文本 = rowSecond[4];
|
oP80Info.测量机 = rowSecond[5];
|
oP80Info.过程参数 = rowSecond[6];
|
oP80Info.测量系统 = rowSecond[7];
|
oP80Info.过程参数值 = rowSecond[8];
|
oP80Info.序列号 = rowSecond[9];
|
oP80Info.零件识别号 = rowSecond[10];
|
for (int i = 1; i <= (rowSecond.Count - 11) / 10; i++)
|
{
|
if (rowSecond.Count < (11 + i * 10))
|
{
|
break;
|
}
|
//名称 相对值 相对值单位 绝对值 绝对值单位 名义值 上限 下限 状态/等级 分隔符
|
OP80ItemInfo item = new OP80ItemInfo();
|
item.分隔符 = rowSecond[1 + i * 10];//例如：* 表头：状态
|
item.名称 = rowSecond[2 + i * 10];//例如：Weight Big End 表头：*
|
item.相对值 = rowSecond[3 + i * 10];//例如：-2.8 表头：简述
|
item.相对值单位 = rowSecond[4 + i * 10];//例如：gr 表头：Weight Big End
|
item.绝对值 = rowSecond[5 + i * 10];//例如：371.66 表头：测量单位
|
item.绝对值单位 = rowSecond[6 + i * 10];//例如：gr 表头：绝对值
|
item.名义值 = rowSecond[7 + i * 10];//例如：374.5 表头：绝对值测量单位（UoM）
|
item.上限 = rowSecond[8 + i * 10];//例如：10.5 表头：名义值
|
item.下限 = rowSecond[9 + i * 10];//例如：-10.5 表头：USL值
|
item.状态 = rowSecond[10 + i * 10];//例如：3 表头：LSL值
|
oP80Info.OP80ItemInfolist.Add(item);
|
if (item.名称.Equals("Weight Class") || item.名称.Equals("Weight Small End")
|
|| item.名称.Equals("Weight Big End") || item.名称.Equals("Dime Small_End Class")
|
|| item.名称.Equals("Dime Big_End Class"))
|
{
|
}
|
else
|
{
|
if (!string.IsNullOrEmpty(item.状态))
|
{
|
oP80Info.OP80ItemStatusInfolist.Add(item);
|
}
|
}
|
}
|
if (oP80Info.OP80ItemStatusInfolist.Count > 0)
|
{
|
if (oP80Info.OP80ItemStatusInfolist.Any(o => !o.状态.Equals("OK")))
|
{
|
wplog.QualityStateStr = "NG";
|
}
|
else
|
{
|
wplog.QualityStateStr = "OK";
|
}
|
}
|
else
|
{
|
wplog.QualityStateStr = "OK";
|
}
|
|
|
wplog.OP80QualityFilePath = file.FullName;
|
wplog.OP80NewCode = oP80Info.批号?.Replace("#", "");
|
//大头重量
|
wplog.QualityOP80To1 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Weight Big End")).FirstOrDefault()?.绝对值;
|
//小头重量
|
wplog.QualityOP80To2 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Weight Small End")).FirstOrDefault()?.绝对值;
|
//总重
|
wplog.QualityOP80To3 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Total Weight")).FirstOrDefault()?.绝对值;
|
//弯曲
|
wplog.QualityOP80To4 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Bend to A")).FirstOrDefault()?.绝对值;
|
//扭度
|
wplog.QualityOP80To5 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Twist to A")).FirstOrDefault()?.绝对值;
|
//大头垂直度
|
wplog.QualityOP80To6 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_C_Squareness")).FirstOrDefault()?.绝对值;
|
//小头垂直度
|
wplog.QualityOP80To10 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Sma_End_C_Squareness")).FirstOrDefault()?.绝对值;
|
//大头孔分组级别
|
wplog.QualityOP80To7 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Dime Big_End Class")).FirstOrDefault()?.状态;
|
//小头孔分组级别
|
wplog.QualityOP80To8 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Dime Small_End Class")).FirstOrDefault()?.状态;
|
//重量组别
|
wplog.QualityOP80To9 = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Weight Class")).FirstOrDefault()?.状态;
|
//wplog.Remarks = (wplog.Remarks ?? "") + $"OP80下线完成读取文件{file.FullName},数据【{wplog.OP80NewCode??"空"}】【{wplog.QualityOP80To1 ?? "空"}】【{wplog.QualityOP80To2 ?? "空"}】【{wplog.QualityOP80To3 ?? "空"}】【{wplog.QualityOP80To4 ?? "空"}】【{wplog.QualityOP80To5 ?? "空"}】";
|
|
//新增OP80的一些质量数据 【Editby shaocx,2024-06-13】
|
wplog.QualityOP80_Houdu = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_Thickness")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_ZXJ = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Distance of Two Head")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_DTKYZD = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_Cylindricity")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_XTSMYD = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Small_End_Top_Roundn")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_XTXMYD = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Small_End_Bot_Roundn")).FirstOrDefault()?.绝对值;
|
|
|
wplog.QualityOP80_D_S_X = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_Top_X_Dia.")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_D_S_Y = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_Top_Y_Dia.")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_D_X_X = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_Bot_X_Dia.")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_D_X_Y = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Big_End_Bot_Y_Dia.")).FirstOrDefault()?.绝对值;
|
//计算大头孔直径,大头孔直径=（大头上面X方向直径+大头上面Y方向直径+大头下面X方向直径+大头下面Y方向直径）/4
|
List<decimal> valueList = new List<decimal>() {
|
SystemHelper.GetDecimal(wplog.QualityOP80_D_S_X),
|
SystemHelper.GetDecimal(wplog.QualityOP80_D_S_Y),
|
SystemHelper.GetDecimal(wplog.QualityOP80_D_X_X),
|
SystemHelper.GetDecimal(wplog.QualityOP80_D_X_Y),
|
};
|
wplog.QualityOP80_D_TKZJ = SystemHelper.CalcDecimalAvg(valueList, 3);
|
|
|
wplog.QualityOP80_X_S_X = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Small_End_Top_X_Dia.")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_X_S_Y = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Small_End_Top_Y_Dia.")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_X_X_X = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Small_End_Bot_X_Dia.")).FirstOrDefault()?.绝对值;
|
wplog.QualityOP80_X_X_Y = oP80Info.OP80ItemInfolist.Where(o => o.名称.Equals("Small_End_Bot_Y_Dia.")).FirstOrDefault()?.绝对值;
|
//计算小头孔直径,小头孔直径=（小头上面X方向直径+小头上面Y方向直径+小头下面X方向直径+小头下面Y方向直径）/4
|
valueList = new List<decimal>();
|
valueList = new List<decimal>() {
|
SystemHelper.GetDecimal(wplog.QualityOP80_X_S_X),
|
SystemHelper.GetDecimal(wplog.QualityOP80_X_S_Y),
|
SystemHelper.GetDecimal(wplog.QualityOP80_X_X_X),
|
SystemHelper.GetDecimal(wplog.QualityOP80_X_X_Y),
|
};
|
wplog.QualityOP80_X_TKZJ = SystemHelper.CalcDecimalAvg(valueList, 3);
|
|
}
|
else
|
{
|
wplog.Remarks = (wplog.Remarks ?? "") + $"OP80下线完成读取文件{file.FullName}异常，行数不是2行";
|
}
|
fileFindTime = files[0].LastWriteTime;
|
break;
|
}
|
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.WorkingProcedureComplete(wplog, PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure));
|
threadStatusMonitor.Threadstatue = 1;
|
|
}
|
value_05 = 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 (System.Data.Entity.Validation.DbEntityValidationException ex)
|
{
|
threadStatusMonitor.ErrorMsg = $" {RandomHelper.GenerateRandomCode(4)} 读取{DataCapturePointCode}下线标记 出现异常，请查看日志！";
|
Log4NetHelper.WriteErrorLog(PLCManger.GetLogTypeForWorkingProcedure(WorkingProcedure), $"读取 {DataCapturePointCode}下线标记数据时异常：", ex);
|
}
|
catch (Exception ex)
|
{
|
threadStatusMonitor.ErrorMsg = $" {RandomHelper.GenerateRandomCode(4)} 读取{WorkingProcedure}下线标记 出现异常，请查看日志！";
|
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}下线标记 不做校验，请确认是否配置异常");
|
}
|
}
|
|
}
|
}
|
