using iWare_SCADA_BusinessLogical.Utils;
using iWare_SCADA_Model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace iWare_SCADA_BusinessLogical.BLL.Important
{
public class WorkingProcedureCompleteManager
{
///
/// 工序完成
///
///
///
public static void WorkingProcedureComplete(WorkPieceLogMiddle logMiddle, LogType type)
{
using (DbModel db = new DbModel())
{
if (logMiddle.WorkingProcedure.Equals("OP70"))
{
logMiddle.QualityState = (int)QualityStateEnum.OK; //如果是OP70,则默认是合格 【Editby shaocx,2024-06-25】
}
WorkPieceLog loginfo2 = new WorkPieceLog();
loginfo2 = EntityPropHelper.Mapper(logMiddle);
try
{
if (logMiddle.WorkPieceID != null && logMiddle.WorkPieceID.Trim('\0').Length == 22)
{
bool isAddWorkPieceInfo = false;
WorkPieceInfo db_info = new WorkPieceInfo();
db_info = db.WorkPieceInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault();
if (db_info == null || db_info.WorkPieceID.Length < 1)
{//没有工件信息,不做更新 (为了测试先先新增)
Log4NetHelper.WriteErrorLog(type, $"工件{logMiddle.WorkPieceID} 工件推出工序{logMiddle.WorkingProcedure} 没有获取到工件信息不做更新");
//db.WorkPieceLog.Add(GetAddWorkPieceLog(loginfo));//插入工件采集日志表
//db.SaveChanges();
loginfo2 = CommonManager.Instance.GetWorkPieceID(logMiddle, type);
db_info = EntityPropHelper.Mapper(logMiddle);
//EntityPropHelper.CopyProp(loginfo, info, loginfo.GetWorkPieceInfoDict());
if (!logMiddle.WorkingProcedure.Equals("OP05"))
{//当工件二维码第一次出现的工序不是OP05,则设置为可疑状态
db_info.QualityState = (int)QualityStateEnum.Suspected;
db_info.QualityErrorInfo = $"工件二维码第一次出现的工序{logMiddle.MonitoringPoint}不是OP05,数据缺失,请确认情况并做相应处理!";
db_info.Remarks = $"工件二维码第一次出现的工序{logMiddle.MonitoringPoint}不是OP05,数据缺失,请确认情况并做相应处理!";
}
else
{
db_info.QualityState = (int)QualityStateEnum.OK;//此处需要注意,判断所有工序质量,然后再赋值 //默认合格,OP05默认是合格
db_info.Remarks = "OP05新增工件信息";
}
db_info.WorkPieceinitOnlineTime = DateTimeHelper.GetDateTime();//WorkPieceInitOnlineTime
db_info.WorkingProcedurePlan = ConfigHelper.GetConfigString("WorkingProcedureAllStr") ?? "OP05OP10OP20OP30OP35OP40OP50OP60OP70OP80";
db_info.CreatedUserName = logMiddle.MonitoringPoint;
SystemBussinessHelper.SetWorkPieceInfoMiddleForCreatedUserName(ref db_info, logMiddle.DataCapturePointCname);
db_info.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local);
db_info.WorkingProcedureCurrent = logMiddle.WorkingProcedure;
db_info.WorkingProcedureEndTime = null;
db_info = WorkPieceInfoManager.ParseQRCode(db_info);
isAddWorkPieceInfo = true;
}
if (logMiddle.WorkingProcedure.Equals("OP10"))
{
//var WorkingProcedure = (loginfo.MonitoringPoint.Equals("OP1002") ? "OP10" : "OP40");
loginfo2.WorkingProcedure = db_info.WorkingProcedureCurrent;//解决OP10,OP40同一个的问题
logMiddle.WorkingProcedure = db_info.WorkingProcedureCurrent; //解决OP10,OP40同一个的问题
}
db_info.WorkingProcedureCurrent = logMiddle.WorkingProcedure;//赋值最新工序 【Editby shaocx,2024-09-03】
db_info.UpdatedUserName = logMiddle.MonitoringPoint;
SystemBussinessHelper.SetWorkPieceInfoMiddleForUpdateDataCapturePointCname(ref db_info, logMiddle.DataCapturePointCname);
db_info.UpdatedTime = DateTimeHelper.GetDateTime();
db_info.WorkingProcedureCompleted = db_info.WorkingProcedureCompleted + logMiddle.WorkingProcedure;//已完成工序
if (!(db_info.WorkingProcedureStartTime.HasValue && db_info.WorkingProcedureStartTime > DateTime.Parse("1900/01/01")))
{//若一直没有工序开始时间,则赋值当前时间
db_info.WorkingProcedureStartTime = DateTimeHelper.GetDateTime();
}
db_info.WorkingProcedureEndTime = DateTimeHelper.GetDateTime();
db_info.WorkPieceCurrentPositionOrder = db_info.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure) / 2;
db_info.Remarks = $"{logMiddle.WorkingProcedure}工序完成";
long op80id = 0;
if (logMiddle.WorkingProcedure.Equals("OP80"))
{
db_info.WorkPieceState = (int)WorkPieceState.FinishedProducts;
db_info.WorkPieceLastOfflineTime = DateTimeHelper.GetDateTime();
db_info.WorkPieceCurrentPosition = "OP80";
db_info.CompleteTime = DateTimeHelper.GetDateTime();
db_info.OP80NewCode = logMiddle.OP80NewCode;
//质检数据改为 获取文件后修改 【Editby shaocx,2024-06-15】
/*
info.QualityState = (int)((loginfo.QualityStateStr.Equals("OK") || loginfo.QualityStateStr.Equals("0K")) ? QualityState.OK : QualityState.NG);
loginfo.QualityState = info.QualityState;
info.QualityStateUpdateUser = loginfo.UpdatedUserName;
info.QualityStateUpdateTime = loginfo.UpdatedTime.Value.LocalDateTime;
info.QualityStateUpdateMode = QualityStateUpdateMode.Auto.ToString();
//*/
var qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault();
if (qualityData == null || qualityData.WorkPieceID.Length < 1 || qualityData.WorkingProcedure.Length < 1)
{//插入QualityDataInfo表
qualityData = EntityPropHelper.Mapper(logMiddle);
db.QualityDataInfo.Add(WorkPieceInfoManager.GetAddQualityDataInfo(qualityData));
}
//修改QualityDataInfo表 //重复收到质量信息,会覆盖之前的
EntityPropHelper.CopyProp(logMiddle, qualityData, WorkPieceInfoManager.GetQualityDataInfoUpdate(logMiddle, logMiddle.WorkingProcedure, logMiddle.MonitoringPoint));//指定修改字段
//质检数据改为 获取文件后修改 【Editby shaocx,2024-06-15】
/*
qualityData.QualityStateUpdateUser = info.UpdatedUserName;
qualityData.QualityReceiveTime = info.UpdatedTime.Value.LocalDateTime;
qualityData.QualityStateUpdateMode = info.QualityStateUpdateMode;
qualityData.OP80QualityState = loginfo.QualityState.HasValue ? loginfo.QualityState.Value.ToString() : "3";
qualityData.OP80QualityReceiveTime = DateTimeHelper.GetDateTime();
qualityData.OP80QualityFilePath = loginfo.OP80QualityFilePath;
op80id = qualityData.Id;
loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量:{loginfo.QualityStateStr ?? "空"}";
if (!info.QualityState.Equals(((int)QualityState.OK).ToString()))
{
info.QualityErrorInfo = $"{loginfo.WorkingProcedure}工序质量采集数据不合格";
}
else
{
info.QualityErrorInfo = "";
}
//*/
loginfo2.Remarks = $"测量合格状态:{logMiddle.St3_Means_OK},称重状态:{logMiddle.St4_Weight_OK}";
}
else if (logMiddle.WorkingProcedure.Equals("OP30"))
{
db_info.QualityState = (int)((logMiddle.QualityStateStr.Equals("OK") || logMiddle.QualityStateStr.Equals("0K")) ? QualityStateEnum.OK : QualityStateEnum.NG);
logMiddle.QualityState = db_info.QualityState;
db_info.QualityStateUpdateUser = logMiddle.UpdatedUserName;
db_info.QualityStateUpdateTime = logMiddle.UpdatedTime.Value.LocalDateTime;
db_info.QualityStateUpdateMode = QualityStateUpdateMode.Auto.ToString();
var qualityData = db.QualityDataInfo.Where(o => o.WorkPieceID == logMiddle.WorkPieceID).FirstOrDefault();
if (qualityData == null || qualityData.WorkPieceID.Length < 1 || qualityData.WorkingProcedure.Length < 1)
{//插入QualityDataInfo表
qualityData = EntityPropHelper.Mapper(logMiddle);
db.QualityDataInfo.Add(WorkPieceInfoManager.GetAddQualityDataInfo(qualityData));
}
qualityData.QualityStateUpdateUser = db_info.UpdatedUserName;
qualityData.QualityReceiveTime = db_info.UpdatedTime.Value.LocalDateTime;
qualityData.QualityStateUpdateMode = db_info.QualityStateUpdateMode;
qualityData.OP30QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value.ToString() : "3";
qualityData.OP30QualityReceiveTime = DateTimeHelper.GetDateTime();
loginfo2.Remarks = (loginfo2.Remarks ?? "") + $"质量:{logMiddle.QualityStateStr ?? "空"}";
if (!db_info.QualityState.Equals(((int)QualityStateEnum.OK).ToString()))
{
db_info.QualityErrorInfo = $"{logMiddle.WorkingProcedure}工序质量采集数据不合格";
}
else
{
db_info.QualityErrorInfo = "";
}
}
else
{
//这里修复OP10、OP40 因为PLC先推 SPC推出、再推 产品下线问题,导致 产品下线更新数据时,把SPC数据覆盖的问题 【Editby shaocx,2024-08-27】
var isAlow = SystemBussinessHelper.IsAllowUpdateWorkPieceStateToWip(db_info, db, logMiddle);
if (isAlow)
{
db_info.WorkPieceState = (int)WorkPieceState.WIP;
}
if (db_info.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure) + 4 <= db_info.WorkingProcedurePlan.Length)
{
db_info.WorkPieceCurrentPosition = db_info.WorkingProcedurePlan.Substring(db_info.WorkingProcedurePlan.IndexOf(logMiddle.WorkingProcedure), 8);
}
}
var pro = db.WorkPieceProcess.Where(o => o.WorkPieceID == logMiddle.WorkPieceID
&& o.WorkingProcedureCurrent == db_info.WorkingProcedureCurrent
&& o.OperationType == OperationType.生产.ToString()).OrderByDescending(o => o.StartTime).FirstOrDefault();
if (pro == null || pro.WorkPieceID.Length < 1)
{
WorkPieceProcess add_process = new WorkPieceProcess();
add_process = EntityPropHelper.Mapper(db_info);
QualityStateHelper.ResetQualityNoOkForNewProcess(ref add_process);
add_process.Id = Yitter.IdGenerator.YitIdHelper.NextId();
add_process.StartTime = DateTimeHelper.GetDateTime().AddSeconds(-SystemBussinessHelper.MoNiTimeForWorkingProcedure(logMiddle.WorkingProcedure));
add_process.EndTime = DateTimeHelper.GetDateTime();
if (logMiddle.WorkingProcedure.Equals("OP80"))
{//OP80的质量数据是后来获取文件搞的
//质检数据,再考虑 另外两种状态 【Editby shaocx,2024-08-27】
QualityStateHelper.SetQualityStateForOP80(logMiddle, ref db_info, ref add_process);
}
else
{
//不再默认赋值为合格 【Editby shaocx,2024-08-16】
//process.QualityState = logMiddle.QualityState.HasValue ? logMiddle.QualityState.Value : (int)QualityState.OK;//默认合格,已处理
add_process.QualityState = WorkPieceInfoManager.GetQualityStateValue(logMiddle.QualityState);
}
add_process.CreatedUserName = logMiddle.MonitoringPoint;
add_process.DataCapturePointCname = logMiddle.DataCapturePointCname;
add_process.CreatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local);
add_process.UpdatedUserName = logMiddle.MonitoringPoint;
add_process.UpdateDataCapturePointCname = logMiddle.DataCapturePointCname;
add_process.UpdatedTime = DateTime.SpecifyKind(DateTime.Now, DateTimeKind.Local);
add_process.OperationType = OperationType.生产.ToString();
add_process.Remarks = "";
add_process.MyRemarks = "工序完成时,如果找不到就新建";
if (logMiddle.WorkingProcedure.Equals("OP80"))
{
add_process.GetQcDataFlag = logMiddle.GetQcDataFlag;//赋值标记 [Editby shaocx,2024-06-15]
}
if (op80id > 0)
{
add_process.QualityDataInfoID = op80id;
}
db.WorkPieceProcess.Add(add_process);
}
else
{
if (logMiddle.WorkingProcedure.Equals("OP80"))
{//OP80的质量数据是后来获取文件搞的
//质检数据,再考虑 另外两种状态 【Editby shaocx,2024-08-27】
QualityStateHelper.SetQualityStateForOP80(logMiddle, ref db_info, ref pro);
}
if (op80id > 0)
{
pro.QualityDataInfoID = op80id;
}
pro.EndTime = DateTimeHelper.GetDateTime();
pro.UpdatedUserName = logMiddle.MonitoringPoint;
pro.UpdateDataCapturePointCname = logMiddle.DataCapturePointCname;
pro.UpdatedTime = DateTimeHelper.GetDateTime();
if (logMiddle.WorkingProcedure.Equals("OP80"))
{
if (pro.GetQcDataFlag != 0)
{
pro.GetQcDataFlag = logMiddle.GetQcDataFlag;//赋值标记 [Editby shaocx,2024-06-15]
}
}
}
if (isAddWorkPieceInfo)
{
db.WorkPieceInfo.Add(db_info);
}
db.WorkPieceInfoLog.Add(WorkPieceInfoManager.GetAddWorkPieceInfoLog(db_info));
}
else
{
loginfo2.Remarks = $"下线完成读取二维码{logMiddle.WorkPieceID ?? "空"}异常";
Log4NetHelper.WriteErrorLog(type, $" {logMiddle.WorkingProcedure}工序下线 读取工件码数据[{logMiddle.WorkPieceID ?? "空"}]时异常:");
}
}
catch (Exception e)
{
loginfo2.Remarks = $"读取二维码{logMiddle.WorkPieceID ?? "空"}更新数据异常{e.Message}";
}
db.WorkPieceLog.Add(WorkPieceInfoManager.GetAddWorkPieceLog(loginfo2));//插入工件采集日志表
db.SaveChanges();
}
}
}
}