using Admin.NET.Application;
using iWareCC.Common.Helper;
using iWareCC.StationService;
using iWareCommon.Common.Globle;
using iWareCommon.Utils;
using iWareModel;
using iWareSql.DBModel;
using iWareSql.WmsDBModel;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net.NetworkInformation;
using System.Reflection.Emit;
using System.ServiceModel.Configuration;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using XiGang.Core.Model;
namespace iWareCC.ThreadService
{
///
/// BZ01工位(清灰,洗板后工位)
///
public static class DataProcess_BZ01
{
///
/// BZ01工位(清灰,洗板后工位)
///
public static async void Handler()
{
var alertMsg = "";
LogType logType = LogType.DataProcess_BZ01;
string lastUpi = "";//最后记录的UPI数据
while (true)
{
Thread.Sleep(1000);//休眠2秒,将休眠写到前面,是为了下面的continue方法执行后不显示错误信息的提示!!!【EditBy shaocx,2022-05-24】
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = string.Empty;
try
{
if (SystemValue.isStartedModel)//SystemValue.isAllowRuning_DataProcess_BZ01 &&
{
if (FormCC.IsAllowRunOutMode == true)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"正在干出库模式,此方法暂停。。 ";
continue;
}
var rgvLocation = StationLocationEnum.BZ01.ToString();
/*
* 1、从数据库中判断是否齐套
* 2、根据齐套结果,推送给PLC
*/
if (FormCC.stationView == null)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()}-获取PLC对象为null";
continue;
}
var obj = FormCC.stationView.R_StationForReadCommList.Where(x => x.StationCode == rgvLocation.ToString()).FirstOrDefault();
if (obj.R_ReqParseData)
{
var result = obj.R_ReadCodeResult;
if (string.IsNullOrEmpty(result))
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()}-请求了解码,但是结果是空的,此次循环结束";
continue;
}
if (lastUpi == result)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()}-重复的UPI{result}";
continue;
}
var upiCode = result;
lastUpi = upiCode;
var qitaoReault = false;//齐包结果
using (WmsDBModel wmsDB = new WmsDBModel())
{
var upiObj = wmsDB.mes_batchOrderUPI_new.Where(x => x.UPI == upiCode).FirstOrDefault();
if (upiObj == null)
{
//写入报警信息
await MyExtendHelper.WriteBoolPlcDataForWarning(PlcWarningAddressGloble.Num_BZ01_1);
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()},根据UPI:{upiCode}没有找到对象 ";
continue;
}
var isAllow = IsAllloRunOutTaskMode(wmsDB, upiObj);
if (isAllow)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()},判断要执行出库模式了,此方法暂停。。 ";
continue;
}
//增加对参数配置的管理 【Editby shaocx,2024-12-13】
var sysConfig = wmsDB.SysConfig.Where(x => x.Code == "LastUpi_BZ01").FirstOrDefault();
if (sysConfig == null)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"没有获取到 LastUpi_BZ01的配置信息 ";
continue;
}
var config_value = sysConfig.Value;
if (config_value.IndexOf('|') > -1)
{//格式为 包号|UPI|次序|齐包状态
var arr = config_value.Split('|');
var lastPackageCode = arr[0];
var lastUpi_BZ01 = arr[1];
var lastShelf = Convert.ToInt32(arr[2]);
var lastQitaoReault = arr[3];
if (upiObj.PackageCode == lastPackageCode)
{
if (upiObj.Shelf == (lastShelf + 1))
{
//齐包状态
if (lastQitaoReault == "齐包")
{
qitaoReault = true;
}
else
{
qitaoReault = false;
}
}
else
{//不齐包
qitaoReault = false;
}
}
else
{//说明是换了包号,重新验证 齐包状态
#region 计算是否齐包
qitaoReault = ValidateQiBao(wmsDB, upiObj);
#endregion
}
}
else
{//表示还没有配置 ,重新验证 齐包状态
#region 计算是否齐包
qitaoReault = ValidateQiBao(wmsDB, upiObj);
#endregion
}
if (qitaoReault == false)
{
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
}
else
{
upiObj.AreaCode = (int)AreaCodeEnum.码垛区域;
}
/*
//查询是否齐包
var allList = wmsDB.mes_batchOrderUPI_new.Where(x => x.PackageCode == upiObj.PackageCode).ToList();
var isQiTaoList = allList.Where(x => x.AreaCode == (int)AreaCodeEnum.待缓存分拣区
||
x.AreaCode == (int)AreaCodeEnum.缓存分拣区
||
x.AreaCode == (int)AreaCodeEnum.码垛区域
).ToList();
if (isQiTaoList.Count() != allList.Count())
{//不齐包
qitaoReault = false;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
}
else
{//齐包
//这里再增加个逻辑,必须是按照次序进入的才真正的算齐包 [Editby shaocx,2024-12-06]
//寻找本包内的前一块板的位置
int queryAreaCode = (int)AreaCodeEnum.待缓存分拣区;
var lastUpiLineQueue = wmsDB.mes_upi_linequeue.Where(x => x.PackageCode == upiObj.PackageCode && x.AreaCode == queryAreaCode)
.OrderBy(x => x.Id).FirstOrDefault();//查询该包队列的第一块板
if (lastUpiLineQueue == null)
{//说明 队列中没有该包的数据
qitaoReault = false;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
}
else
{
if (lastUpiLineQueue.Shelf != upiObj.Shelf)
{
qitaoReault = false;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
}
else
{
var isJiXuValidate = true;
if (upiObj.Shelf != 1)
{
var qianmianList = allList.Where(x => x.Shelf < upiObj.Shelf).ToList();
//看以前的板在哪里,必须都在 码垛区域
var yiqianQuyu = AreaCodeEnum.码垛区域;
var count_MD = qianmianList.Where(x => x.AreaCode == (int)yiqianQuyu).Count();
if (count_MD != qianmianList.Count())
{
isJiXuValidate = false;
qitaoReault = false;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
}
}
if (isJiXuValidate)
{//是否继续验证
//还需要验证在这些区域中,是否正确排队,如果没有正确排队,那么就认为不齐套 【Editby shaocx,2024-12-12】
var queueList = wmsDB.mes_upi_linequeue.Where(x => x.PackageCode == upiObj.PackageCode && x.AreaCode == queryAreaCode)
.OrderBy(x => x.Id).ToList();
var fisrtId = queueList.OrderBy(x => x.Id).First().Id;
var endId = queueList.OrderByDescending(x => x.Id).First().Id;
//继续查询这个时间段内的队列数据
//重写该队列
queueList = wmsDB.mes_upi_linequeue.Where(x => x.Id >= fisrtId && x.Id <= endId).OrderBy(x => x.Id).ToList();
var syCount = allList.Where(x => x.Shelf >= upiObj.Shelf).Count();
if (queueList.Count() != syCount)
{
qitaoReault = false;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
}
else
{
//判断是否乱序
bool isLuanXuan = false;
int temp_shelf = 0;
for (int i = 0; i < queueList.Count; i++)
{
if (i == 0)
{
temp_shelf = queueList[i].Shelf;
if (temp_shelf != upiObj.Shelf)
{
qitaoReault = false;
isLuanXuan = true;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
break;//跳出循环
}
if (queueList[i].Upi != upiObj.UPI)
{
qitaoReault = false;
isLuanXuan = true;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
break;//跳出循环
}
}
else
{
temp_shelf = temp_shelf + 1;
if (temp_shelf != queueList[i].Shelf)
{//认为乱序了
qitaoReault = false;
isLuanXuan = true;
upiObj.AreaCode = (int)AreaCodeEnum.缓存分拣区;
break;//跳出循环
}
}
}
if (isLuanXuan == false)
{
qitaoReault = true;
upiObj.AreaCode = (int)AreaCodeEnum.码垛区域;
}
}
}
}
//注意:要删除该队列数据哦
wmsDB.mes_upi_linequeue.Remove(lastUpiLineQueue);
}
}
//*/
//if (qitaoReault == false) {
// //临时
// SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"模拟啊啊,暂停啊啊";
// continue;
//}
using (StationServiceClient client = new StationServiceClient())
{
var res = await client.WriteQiTaoInfoAsync((int)EDevice.Station, rgvLocation, qitaoReault);
if (!res.result)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()}-推送齐套结果失败,WriteQiTaoInfoAsync返回:{res.resMsg}";
continue;
}
else
{
Log4NetHelper.WriteInfoLog(logType, $"{rgvLocation.ToString()}-推送齐套结果成功,WriteQiTaoInfoAsync,参数: 站点{rgvLocation},齐套结果:{qitaoReault}");
}
}
var str_qitaoReault = (qitaoReault ? "齐包" : "不齐包");
//记录下结果
sysConfig.Value = upiObj.PackageCode + "|" + upiObj.UPI + "|" + upiObj.Shelf + "|" + str_qitaoReault;
//删除该UPI的缓存队列数据
int queryAreaCode2 = (int)AreaCodeEnum.待缓存分拣区;
var curUpiLineQueue = wmsDB.mes_upi_linequeue.Where(x => x.Upi == upiObj.UPI && x.AreaCode == queryAreaCode2)
.FirstOrDefault();
if (curUpiLineQueue != null)
{
wmsDB.mes_upi_linequeue.Remove(curUpiLineQueue);
}
//更新UPI状态
var upiObjList = wmsDB.mes_batchOrderUPI_new.Where(x => x.UPI == upiCode).ToList();
foreach (var item in upiObjList)
{
if (qitaoReault)
{
item.UpiStatus = (int)UpiStatusEnum.已齐包;
}
else
{
item.UpiStatus = (int)UpiStatusEnum.不齐包;
}
}
//更新 最后一次在 BZ_01的系统处理的板件 数据
var rbRunMode = wmsDB.wms_rbline_runmode.FirstOrDefault();
rbRunMode.UPI = upiObj.UPI;
rbRunMode.PlanNo = upiObj.PlanNo;
rbRunMode.OrderId = upiObj.OrderId;
rbRunMode.PackageCode = upiObj.PackageCode;
WmsRecordUpiProcessHandler.SaveWmsRecordUpiProcess(wmsDB, upiObj, "BZ01", "齐包验证:" + str_qitaoReault);
wmsDB.SaveChanges();
}
}
else
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 = $"{rgvLocation.ToString()}-没有要处理的数据";
using (WmsDBModel wmsDB = new WmsDBModel())
{
var isAllow = IsAllloRunOutTaskMode(wmsDB, null);
}
}
}
}
catch (Exception ex)
{
SystemWarningMsg._lbl_alert_DataProcess_BZ01 += " 出现异常:" + ex.Message + SysGloble.SPLIT_STR;
Log4NetHelper.WriteErrorLog(logType, " 出现异常:" + ex.Message, ex);
}
}
}
///
/// 是否可以执行出库模式
///
///
///
///
private static bool IsAllloRunOutTaskMode(WmsDBModel wmsDB, mes_batchOrderUPI_new curUpiObj)
{
//不再判断 【Editby shaocx,2024-12-14】
return false;
/*
//首先查询数据库中是否有 要出库的数据
var isExistOutTaskForNewCreated = wmsDB.wms_rbline_task.Where(x =>
(x.RbTaskType == (int)RbTaskTypeEnum.齐包出库任务 || x.RbTaskType == (int)RbTaskTypeEnum.强制出库任务)
&& x.TaskStatus == (int)TaskStatusEnum.新建
).Count();
if (isExistOutTaskForNewCreated == 0)
{
FormCC.IsAllowRunOutMode = false;
return false;//不能执行 出库模式
}
var rbRunMode = wmsDB.wms_rbline_runmode.FirstOrDefault();
var lastUpi = rbRunMode.UPI;
var lastPackageCode = rbRunMode.PackageCode;
if (curUpiObj == null)
{//表示此时无新板过来
if (!string.IsNullOrEmpty(lastUpi))
{
var lastObj = wmsDB.mes_batchOrderUPI_new.Where(x => x.UPI == lastUpi).FirstOrDefault();
if (lastObj.UpiStatus == (int)UpiStatusEnum.不齐包 || lastObj.UpiStatus == (int)UpiStatusEnum.初始)
{//表示最后过去的板是不齐包的板
//可以运行执行 出库模式
}
else
{//表示最后过去的板是齐包的板
//要继续判断后面 待分拣区域还存在相同包的板数据吗
var isExistSamePackageCode = wmsDB.mes_batchOrderUPI_new.Where(x => x.PackageCode == lastPackageCode
&& x.AreaCode == (int)AreaCodeEnum.待缓存分拣区).Count();
if (isExistSamePackageCode > 0)
{
FormCC.IsAllowRunOutMode = false;
return false;//不能执行 出库模式
}
else
{
//可以运行执行 出库模式
}
}
}
else
{
//可以运行执行 出库模式
}
}
else
{//表示此时有新板过来
if (!string.IsNullOrEmpty(lastUpi))
{
if (lastPackageCode == curUpiObj.PackageCode)
{
FormCC.IsAllowRunOutMode = false;
return false;//不能执行 出库模式
}
else
{//新包过来了
//可以运行执行 出库模式
}
}
else
{
//可以运行执行 出库模式
}
}
FormCC.IsAllowRunOutMode = true;
return true;
//*/
}
///
/// 判断是否齐包
///
///
///
///
private static bool ValidateQiBao(WmsDBModel wmsDB, mes_batchOrderUPI_new upiObj)
{
if (upiObj.Shelf != 1)
{
return false;
}
//查询是否齐包
var allList = wmsDB.mes_batchOrderUPI_new.Where(x => x.PackageCode == upiObj.PackageCode).ToList();
var isQiTaoList = allList.Where(x => x.AreaCode == (int)AreaCodeEnum.待缓存分拣区
||
x.AreaCode == (int)AreaCodeEnum.码垛区域
).ToList();
if (isQiTaoList.Count() != allList.Count())
{//不齐包
return false;
}
else
{//齐包
//这里再增加个逻辑,必须是按照次序进入的才真正的算齐包 [Editby shaocx,2024-12-06]
//寻找本包内的前一块板的位置
int queryAreaCode = (int)AreaCodeEnum.待缓存分拣区;
var lastUpiLineQueue = wmsDB.mes_upi_linequeue.Where(x => x.PackageCode == upiObj.PackageCode && x.AreaCode == queryAreaCode)
.OrderBy(x => x.Id).FirstOrDefault();//查询该包队列的第一块板
if (lastUpiLineQueue == null)
{//说明 队列中没有该包的数据
return false;
}
else
{
if (lastUpiLineQueue.Shelf != upiObj.Shelf)
{
return false;
}
else
{
var isJiXuValidate = true;
if (upiObj.Shelf != 1)
{
var qianmianList = allList.Where(x => x.Shelf < upiObj.Shelf).ToList();
//看以前的板在哪里,必须都在 码垛区域
var yiqianQuyu = AreaCodeEnum.码垛区域;
var count_MD = qianmianList.Where(x => x.AreaCode == (int)yiqianQuyu).Count();
if (count_MD != qianmianList.Count())
{
isJiXuValidate = false;
return false;
}
}
if (isJiXuValidate)
{//是否继续验证
//还需要验证在这些区域中,是否正确排队,如果没有正确排队,那么就认为不齐套 【Editby shaocx,2024-12-12】
var queueList = wmsDB.mes_upi_linequeue.Where(x => x.PackageCode == upiObj.PackageCode && x.AreaCode == queryAreaCode)
.OrderBy(x => x.Id).ToList();
var fisrtId = queueList.OrderBy(x => x.Id).First().Id;
var endId = queueList.OrderByDescending(x => x.Id).First().Id;
//继续查询这个时间段内的队列数据
//重写该队列
queueList = wmsDB.mes_upi_linequeue.Where(x => x.Id >= fisrtId && x.Id <= endId).OrderBy(x => x.Id).ToList();
var syCount = allList.Where(x => x.Shelf >= upiObj.Shelf).Count();
if (queueList.Count() != syCount)
{
return false;
}
else
{
//判断是否乱序
bool isLuanXuan = false;
int temp_shelf = 0;
for (int i = 0; i < queueList.Count; i++)
{
if (i == 0)
{
temp_shelf = queueList[i].Shelf;
if (temp_shelf != upiObj.Shelf)
{
isLuanXuan = true;
return false;
}
if (queueList[i].Upi != upiObj.UPI)
{
isLuanXuan = true;
return false;
}
}
else
{
temp_shelf = temp_shelf + 1;
if (temp_shelf != queueList[i].Shelf)
{//认为乱序了
isLuanXuan = true;
return false;
}
}
}
if (isLuanXuan == false)
{
return true;
}
}
}
}
}
}
return false;
}
}
}