/// <summary>
/// 关闭AGV配送PTL服务
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCloseAgv_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("是否要关闭AGV配送PTL服务？", "提示", MessageBoxButton.YesNo, MessageBoxImage.Question, MessageBoxResult.No) == MessageBoxResult.Yes)
{
using (GeelyPtlEntities dbContext = new GeelyPtlEntities())
{
DST_AgvSwitch dstAgvSwitch = dbContext.DST_AgvSwitchs.FirstOrDefault();
if (dstAgvSwitch != null)
{
dstAgvSwitch.isOpen = false;
dstAgvSwitch.lastCloseTime = DateTime.Now;
int result = dbContext.SaveChanges();
if (result <= 0)
{
MessageBox.Show("关闭失败");
return;
}
//this.viewModel.CloseAgvService();
MessageBox.Show("关闭成功");
this.btnOpenAgv.IsEnabled = true;
this.btnCloseAgv.IsEnabled = false;
this.txtAgvStatusDesc.Text = "● AGV配送PTL服务已关闭";
}
}
}
}
private void UserControl_Initialized(object sender, EventArgs e)
{
//主题切换会引发多次 Loaded 事件，所以改到 Initialized 事件里
if (DesignerProperties.GetIsInDesignMode(this))
{
return;
}
try
{
//开发早期启用重建数据库
//Database.SetInitializer(new DropCreateDatabaseIfModelChanges<GeelyPtlEntities>());
//之后使用数据迁移
Database.SetInitializer(new MigrateDatabaseToLatestVersion <GeelyPtlEntities, DataAccess.Migrations.Configuration>());
this.passwordBoxConnectionStingPassword.Password = this.viewModel.ConnectionStringPassword;
this.viewModel.StartServices();
//初始化AGV开关服务
using (GeelyPtlEntities dbContext = new GeelyPtlEntities())
{
DST_AgvSwitch dstAgvSwitch = dbContext.DST_AgvSwitchs.FirstOrDefault();
if (dstAgvSwitch != null)
{
if (dstAgvSwitch.isOpen)
{
this.btnOpenAgv.IsEnabled = false;
this.btnCloseAgv.IsEnabled = true;
this.txtAgvStatusDesc.Text = "● AGV配送PTL服务已开启";
}
else
{
this.btnOpenAgv.IsEnabled = true;
this.btnCloseAgv.IsEnabled = false;
this.txtAgvStatusDesc.Text = "● AGV配送PTL服务已关闭";
}
}
}
//初始化AGV物料超市配送服务
string StartMaterialMarketDistributeFlag = System.Configuration.ConfigurationManager.AppSettings["StartMaterialMarketDistribute"];
if (StartMaterialMarketDistributeFlag.Equals("yes"))
{
this.btnOpenMaterialMarketDistribute.IsEnabled = false;
this.btnCloseMaterialMarketDistribute.IsEnabled = true;
this.txtMaterialMarketDistributeDesc.Text = "● AGV物料超市配送服务已开启";
}
else
{
this.btnOpenMaterialMarketDistribute.IsEnabled = true;
this.btnCloseMaterialMarketDistribute.IsEnabled = false;
this.txtMaterialMarketDistributeDesc.Text = "● AGV物料超市配送服务已关闭";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "服务设置", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
void ptl900U_Pressed(object sender, Ptl900UPressedEventArgs e, bool pickAll)
{
while (true)
{
try
{
using (GeelyPtlEntities dbContext = new GeelyPtlEntities())
{
CFG_WorkStation cfgWorkStation = dbContext.CFG_WorkStations
.First(ws => ws.Id == this.CFG_WorkStationId);
ASM_TaskItem asmTaskItem = dbContext.ASM_TaskItems
.First(ti => ti.Id == this.CurrentAsmTaskItemId.Value);
ASM_AssembleIndicationItem asmAssembleIndicationItem = asmTaskItem.ASM_AssembleIndicationItem;
ASM_AssembleIndication asmAssembleIndication = asmAssembleIndicationItem.ASM_AssembleIndication;
List <ASM_TaskItem> otherAsmTaskItems = asmAssembleIndicationItem.ASM_TaskItems
.Where(ti => ti.Id != asmTaskItem.Id)
.ToList();
CFG_Cart cfgCart = asmTaskItem.CFG_Cart;
List <CFG_CartCurrentMaterial> cfgCartCurrentMaterials = cfgCart.CFG_CartCurrentMaterials
.OrderBy(ccm => ccm.Position)
.ToList();
CFG_CartCurrentMaterial cfgCartCurrentMaterial = cfgCartCurrentMaterials.First(ccm => ccm.Position == asmTaskItem.CartPosition);
CFG_WorkStationCurrentCart cfgWorkStationCurrentCart = dbContext.CFG_WorkStationCurrentCarts
.FirstOrDefault(wscc => wscc.CFG_WorkStationId == this.CFG_WorkStationId && wscc.CFG_CartId == cfgCart.Id);
if (asmTaskItem.AssembledQuantity == null)
{
asmTaskItem.AssembledQuantity = 0;
}
int pickedCount = 1;
if (pickAll)
{
pickedCount = asmTaskItem.ToAssembleQuantity - asmTaskItem.AssembledQuantity.Value;
}
asmTaskItem.AssembledQuantity += pickedCount;
asmTaskItem.AssembledTime = DateTime.Now;
if (asmAssembleIndicationItem.AssembledQuantity == null)
{
asmAssembleIndicationItem.AssembledQuantity = 0;
}
asmAssembleIndicationItem.AssembledQuantity += pickedCount;
asmAssembleIndicationItem.AssembledTime = DateTime.Now;
bool currentItemFinished = asmTaskItem.AssembledQuantity == asmTaskItem.ToAssembleQuantity;
if (currentItemFinished)
{
asmTaskItem.AssembleStatus = AssembleStatus.Finished;
if (otherAsmTaskItems.All(ti => ti.AssembleStatus == AssembleStatus.Finished))
{
asmAssembleIndicationItem.AssembleStatus = AssembleStatus.Finished;
}
}
if (cfgCartCurrentMaterial.Quantity != null && cfgCartCurrentMaterial.Quantity > 0)
{
cfgCartCurrentMaterial.Quantity -= pickedCount;
}
//料车上物料消耗完则施放料车并通知 AGV 回收，再尝试补充一辆料车
if (cfgCartCurrentMaterials.All(ccm => ccm.Quantity == null || ccm.Quantity == 0))
{
cfgCart.CartStatus = CartStatus.Free;
foreach (CFG_CartCurrentMaterial innerCfgCartCurrentMaterial in cfgCartCurrentMaterials)
{
innerCfgCartCurrentMaterial.AST_CartTaskItemId = null;
innerCfgCartCurrentMaterial.ProjectCode = null;
innerCfgCartCurrentMaterial.WbsId = null;
innerCfgCartCurrentMaterial.ProjectStep = null;
innerCfgCartCurrentMaterial.CFG_WorkStationId = null;
innerCfgCartCurrentMaterial.BatchCode = null;
innerCfgCartCurrentMaterial.CFG_ChannelId = null;
innerCfgCartCurrentMaterial.CFG_PalletId = null;
innerCfgCartCurrentMaterial.BoxCode = null;
innerCfgCartCurrentMaterial.FromPalletPosition = null;
innerCfgCartCurrentMaterial.MaterialCode = null;
innerCfgCartCurrentMaterial.MaterialName = null;
innerCfgCartCurrentMaterial.MaterialBarcode = null;
innerCfgCartCurrentMaterial.Quantity = null;
innerCfgCartCurrentMaterial.AssortedTime = null;
innerCfgCartCurrentMaterial.CFG_EmployeeId = null;
if (innerCfgCartCurrentMaterial.Usability != CartPositionUsability.DisableByOffLineDevice)
{
innerCfgCartCurrentMaterial.Usability = CartPositionUsability.Enable;
}
}
if (cfgWorkStationCurrentCart != null)
{
//通知 AGV 回收当前车，尝试空满切换下一辆车
DST_AgvSwitch dstAgvSwitch = dbContext.DST_AgvSwitchs.FirstOrDefault(t => t.isOpen);
if (dstAgvSwitch != null)
{
int nCurPosition = cfgWorkStationCurrentCart.Position;
string sWorkStationCode = cfgWorkStationCurrentCart.CFG_WorkStation.Code;
if (nCurPosition <= 4) //内侧
{
//如果对应外侧没有正在执行的物料超市配送任务，才生成里侧的线边配送任务
string sOutPosition = sWorkStationCode + "-" + (nCurPosition + 4);
DST_DistributeTask outDistributeTask = dbContext.DST_DistributeTasks.FirstOrDefault(t => t.DistributeReqTypes == DistributeReqTypes.MaterialMarketDistribute &&
t.endPosition.Equals(sOutPosition) &&
t.sendErrorCount < 5 &&
t.arriveTime == null);
if (outDistributeTask == null)
{
CFG_WorkStationCurrentCart cfgOutWorkStationCurrentCart = dbContext.CFG_WorkStationCurrentCarts
.FirstOrDefault(wscc => wscc.CFG_WorkStationId == this.CFG_WorkStationId && wscc.Position == nCurPosition + 4 && wscc.CFG_CartId != null);
if (cfgOutWorkStationCurrentCart != null)
{
//生成料架转换任务
List <DST_DistributeTask> distributeTasks = DistributingTaskGenerator.Instance.GenerateProductCartSwitchTask(cfgCart);
foreach (DST_DistributeTask distributeTask in distributeTasks)
{
dbContext.DST_DistributeTasks.Add(distributeTask);
}
}
else
{
//生成线边自动清线配送任务
List <DST_DistributeTask> distributeTasks = DistributingTaskGenerator.Instance.GenerateProductAreaAutoClearTask(sWorkStationCode, nCurPosition.ToString(), cfgCart.Code);
foreach (DST_DistributeTask distributeTask in distributeTasks)
{
dbContext.DST_DistributeTasks.Add(distributeTask);
}
}
}
}
else //外侧
{
//如果对应里侧没有正在执行的空满转换任务，才生成外侧的线边配送任务
string sInPosition = sWorkStationCode + "-" + (nCurPosition - 4);
DST_DistributeTask inDistributeTask = dbContext.DST_DistributeTasks.FirstOrDefault(t => t.DistributeReqTypes == DistributeReqTypes.ProductCartSwitch &&
t.startPosition.Equals(sInPosition) &&
t.sendErrorCount < 5 &&
t.arriveTime == null);
if (inDistributeTask == null)
{
//生成线边配送任务
string sTaskSendType = "自动";
List <DST_DistributeTask> distributeTasks = DistributingTaskGenerator.Instance.GenerateProductAreaDistributeTask(sWorkStationCode, nCurPosition.ToString(), cfgCart.Code, sTaskSendType, true, dbContext);
foreach (DST_DistributeTask distributeTask in distributeTasks)
{
dbContext.DST_DistributeTasks.Add(distributeTask);
}
}
}
}
else
{
//解除停靠
cfgWorkStationCurrentCart.CFG_CartId = null;
cfgWorkStationCurrentCart.DockedTime = null;
}
}
//尝试发起下一车的拉料任务
CFG_Cart nextCfgCart = dbContext.CFG_Carts
.FirstOrDefault(c => c.CartStatus == CartStatus.ArrivedAtBufferArea &&
c.CFG_CartCurrentMaterials.Any(ccm => ccm.CFG_WorkStationId == this.CFG_WorkStationId &&
ccm.Quantity > 0));
if (nextCfgCart != null)
{
nextCfgCart.CartStatus = CartStatus.NeedToWorkStation;
CFG_CartCurrentMaterial firstCfgCartFirstCartCurrentMaterial = nextCfgCart.CFG_CartCurrentMaterials
.First(ccm => ccm.Quantity > 0);
FND_Task fndTask = new FND_Task();
fndTask.ProjectCode = firstCfgCartFirstCartCurrentMaterial.ProjectCode;
fndTask.ProjectStep = firstCfgCartFirstCartCurrentMaterial.ProjectStep;
fndTask.BatchCode = firstCfgCartFirstCartCurrentMaterial.BatchCode;
fndTask.MaxNeedArrivedTime = DateTime.Now.AddHours(1);
fndTask.RequestTime = DateTime.Now;
fndTask.CFG_WorkStationId = firstCfgCartFirstCartCurrentMaterial.CFG_WorkStationId.Value;
fndTask.CFG_CartId = nextCfgCart.Id;
fndTask.LightColor = (byte)LightColor.Off;
fndTask.FindingStatus = FindingStatus.New;
dbContext.FND_Tasks.Add(fndTask);
}
}
dbContext.SaveChanges();
CartPtl cartPtl = CartPtlHost.Instance.GetCartPtl(asmTaskItem.CFG_CartId);
Ptl900U ptl900UPublisher = cartPtl.GetPtl900UPublisher();
Ptl900U ptl900U = cartPtl.GetPtl900UByPosition(asmTaskItem.CartPosition);
Ptl900U ptl900ULight = cartPtl.GetPtl900ULight();
if (currentItemFinished)
{
Display900UItem cartPublisherDisplay900UItem = new Display900UItem();
cartPublisherDisplay900UItem.Name = "抵达工位 " + cfgWorkStation.Name;
cartPublisherDisplay900UItem.Description = string.Format(CultureInfo.InvariantCulture, @"项目：{0}
阶段：{1}
批次：{2}", cfgCartCurrentMaterial.ProjectCode, cfgCartCurrentMaterial.ProjectStep, cfgCartCurrentMaterial.BatchCode);
if (cfgWorkStationCurrentCart != null)
{
cartPublisherDisplay900UItem.Count = (ushort)cfgWorkStationCurrentCart.Position;
}
cartPublisherDisplay900UItem.Unit = "位";
ptl900UPublisher.Pressed -= this.ptl900UPublisher_Pressed;
ptl900UPublisher.Clear(true);
ptl900UPublisher.Lock();
ptl900UPublisher.Display(cartPublisherDisplay900UItem, LightColor.Off);
ptl900U.Pressed -= this.ptl900U_Pressed;
ptl900ULight.Clear();
this.CurrentAsmTaskItemId = null;
}
else
{
Display900UItem publisherDisplay900UItem = new Display900UItem();
publisherDisplay900UItem.Name = asmAssembleIndicationItem.MaterialName;
publisherDisplay900UItem.Description = string.Format(CultureInfo.InvariantCulture, @"项目：{0}，{1}
车号：{2}
量产工位：{3}", asmAssembleIndicationItem.ProjectCode, asmAssembleIndicationItem.ProjectStep, asmAssembleIndication.ProductSequence, asmAssembleIndicationItem.Gzz);
publisherDisplay900UItem.LongSubLocation = asmTaskItem.ToAssembleQuantity.ToString(CultureInfo.InvariantCulture);
publisherDisplay900UItem.Count = (ushort)asmTaskItem.AssembledQuantity.Value;
Display900UItem display900UItem = new Display900UItem();
display900UItem.Count = (ushort)(asmTaskItem.ToAssembleQuantity - asmTaskItem.AssembledQuantity.Value);
LightMode lightMode = new LightMode();
lightMode.Color = LightColor.Green;
if (asmAssembleIndicationItem.Qtxbs == "1")
{
lightMode.Color = LightColor.Magenta;
lightMode.Ratio = LightOnOffRatio.RatioP1V1;
lightMode.Period = LightOnOffPeriod.Period500;
}
ptl900UPublisher.Clear(true);
//ptl900UPublisher.Unlock();
ptl900UPublisher.Lock();
ptl900UPublisher.Display(publisherDisplay900UItem, LightColor.Off, true);
ptl900U.Display(display900UItem, lightMode, true);
//如果长时间无法交互，则自动交互
this.AutoPressByDeviceErrorAsync(this.CurrentAsmTaskItemId.Value, ptl900U, display900UItem);
}
string logMessage = (pickAll ? " 拣选所有：" : " 拣选一个：")
+ asmAssembleIndication.ProductSequence + ", "
+ asmAssembleIndication.GzzList + ", "
+ asmAssembleIndicationItem.MaterialCode + ", "
+ asmAssembleIndicationItem.MaterialName + ", "
+ cfgCart.Name + ", "
+ asmTaskItem.CartPosition;
if (currentItemFinished)
{
logMessage += ", 明细完成";
}
Logger.Log(this.GetType().Name + "." + cfgWorkStation.Code, DateTime.Now.ToString("HH:mm:ss") + logMessage + Environment.NewLine);
}
break;
}
catch (Exception ex)
{
string message = ex.Message;
DbEntityValidationException dbEntityValidationException = ex as DbEntityValidationException;
if (dbEntityValidationException != null)
{
foreach (DbEntityValidationResult validationResult in dbEntityValidationException.EntityValidationErrors)
{
foreach (DbValidationError validationError in validationResult.ValidationErrors)
{
message += Environment.NewLine + validationError.ErrorMessage;
}
}
}
message += Environment.NewLine + ex.StackTrace;
Logger.Log("IndicatingExecutor.ptl900U_Pressed", DateTime.Now.ToString("HH:mm:ss") + Environment.NewLine
+ message + Environment.NewLine
+ Environment.NewLine);
Thread.Sleep(1000);
}
}
}
/// <summary>
/// 显式或定时刷新。
/// </summary>
public void Refresh()
{
lock (this.refreshSyncRoot)
{
using (GeelyPtlEntities dbContext = new GeelyPtlEntities())
{
List <FND_Task> needToDoFndTasks = dbContext.FND_Tasks
.Where(t => t.FindingStatus == FindingStatus.NeedDisplay ||
t.FindingStatus == FindingStatus.NeedBlink ||
t.FindingStatus == FindingStatus.NeedClear)
.ToList();
//获取是否开启AGV配送PTL料架
DST_AgvSwitch dstAgvSwitch = dbContext.DST_AgvSwitchs.FirstOrDefault(t => t.isOpen);
foreach (FND_Task fndTask in needToDoFndTasks)
{
CFG_WorkStation cfgWorkStation = fndTask.CFG_WorkStation;
CFG_Cart cfgCart = fndTask.CFG_Cart;
string gzzList = this.GetGzzListFromCfgCartMaterial(cfgCart);
CartPtl cartPtl = CartPtlHost.Instance.GetCartPtl(fndTask.CFG_CartId);
Ptl900U ptl900UPublisher = cartPtl.GetPtl900UPublisher();
Ptl900U ptl900ULight = cartPtl.GetPtl900ULight();
Display900UItem publisherDisplay900UItem = new Display900UItem();
publisherDisplay900UItem.Name = string.Format(CultureInfo.InvariantCulture, "{0}：{1}", cfgWorkStation.Name, gzzList);
publisherDisplay900UItem.Description = string.Format(CultureInfo.InvariantCulture, @"项目：{0}，{1}
批次：{2}
最迟抵达：{3:HH:mm:ss}", fndTask.ProjectCode, fndTask.ProjectStep, fndTask.BatchCode, fndTask.MaxNeedArrivedTime);
publisherDisplay900UItem.Count = (ushort)cfgCart.CFG_CartCurrentMaterials
.Where(ccm => ccm.Quantity != null)
.Select(ccm => ccm.Quantity.Value)
.Sum();
publisherDisplay900UItem.Unit = "个";
Display900UItem lightDisplay900UItem = new Display900UItem();
LightColor lightColor = (LightColor)fndTask.LightColor;
LightMode lightMode = new LightMode();
lightMode.Color = lightColor;
lightMode.Period = LightOnOffPeriod.Period200;
lightMode.Ratio = LightOnOffRatio.RatioP1V1;
if (fndTask.FindingStatus == FindingStatus.NeedDisplay)
{
//先保证数据库更新成功
fndTask.DisplayTime = DateTime.Now;
fndTask.FindingStatus = FindingStatus.Displaying;
cfgCart.CartStatus = CartStatus.WaitingToWorkStation;
dbContext.SaveChanges();
//再控制设备
ptl900UPublisher.Clear(true);
ptl900UPublisher.Lock();
ptl900UPublisher.Display(publisherDisplay900UItem, LightColor.Off);
ptl900ULight.Clear();
ptl900ULight.Display(lightDisplay900UItem, lightColor);
}
else if (fndTask.FindingStatus == FindingStatus.NeedBlink)
{
if (fndTask.DisplayTime == null)
{
fndTask.CFG_EmployeeId = 1;
fndTask.DisplayTime = DateTime.Now;
}
fndTask.DepartedTime = DateTime.Now;
fndTask.FindingStatus = FindingStatus.Blinking;
if (dstAgvSwitch == null)
{
cfgCart.CartStatus = CartStatus.InCarriageToWorkStation;
}
//当前请求可以分小车提交
FND_DeliveryResult fndDeliveryResult = new FND_DeliveryResult();
fndDeliveryResult.FND_TaskId = fndTask.Id;
fndDeliveryResult.ProjectCode = fndTask.ProjectCode;
fndDeliveryResult.ProjectStep = fndTask.ProjectStep;
fndDeliveryResult.CFG_WorkStationId = fndTask.CFG_WorkStationId;
fndDeliveryResult.BatchCode = fndTask.BatchCode;
fndDeliveryResult.MaxNeedArrivedTime = fndTask.MaxNeedArrivedTime;
fndDeliveryResult.CFG_CartId = fndTask.CFG_CartId;
fndDeliveryResult.DepartedTime = DateTime.Now;
fndDeliveryResult.CFG_EmployeeId = fndTask.CFG_EmployeeId.Value;
dbContext.FND_DeliveryResults.Add(fndDeliveryResult);
FND_DeliveryResultMessage fndDeliveryResultMessage = new FND_DeliveryResultMessage();
fndDeliveryResultMessage.FND_DeliveryResult = fndDeliveryResult;
fndDeliveryResultMessage.SentSuccessful = false;
dbContext.FND_DeliveryResultMessages.Add(fndDeliveryResultMessage);
List <CFG_CartCurrentMaterial> cfgCartCurrentMaterials = fndTask.CFG_Cart.CFG_CartCurrentMaterials
.Where(ccm => ccm.Quantity > 0)
.ToList();
foreach (CFG_CartCurrentMaterial cfgCartCurrentMaterial in cfgCartCurrentMaterials)
{
FND_DeliveryResultItem fndDeliveryResultItem = new FND_DeliveryResultItem();
fndDeliveryResultItem.FND_DeliveryResult = fndDeliveryResult;
fndDeliveryResultItem.CartPosition = cfgCartCurrentMaterial.Position;
fndDeliveryResultItem.MaterialCode = cfgCartCurrentMaterial.MaterialCode;
fndDeliveryResultItem.MaterialName = cfgCartCurrentMaterial.MaterialName;
fndDeliveryResultItem.MaterialBarcode = cfgCartCurrentMaterial.MaterialBarcode;
fndDeliveryResultItem.Quantity = cfgCartCurrentMaterial.Quantity.Value;
dbContext.FND_DeliveryResultItems.Add(fndDeliveryResultItem);
}
dbContext.SaveChanges();
ptl900ULight.Clear();
ptl900ULight.Display(lightDisplay900UItem, lightMode, false);
}
else if (fndTask.FindingStatus == FindingStatus.NeedClear)
{
fndTask.FindingStatus = FindingStatus.Finished;
dbContext.SaveChanges();
ptl900ULight.Clear();
}
}
//运输一段时间后自动进入 NeedClear 状态
DateTime maxBlinkingTime = DateTime.Now.Subtract(this.autoClearPeriod);
List <FND_Task> autoClearFndTasks = dbContext.FND_Tasks
.Where(t => t.FindingStatus == FindingStatus.Blinking &&
t.DisplayTime < maxBlinkingTime)
.ToList();
foreach (FND_Task fndTask in autoClearFndTasks)
{
fndTask.FindingStatus = FindingStatus.NeedClear;
dbContext.SaveChanges();
}
if (dstAgvSwitch == null)
{
//运输一段时间后自动抵达生产线
DateTime maxCarriageTime = DateTime.Now.Subtract(this.autoReachedPeriod);
List <FND_Task> autoReachedFndTasks = dbContext.FND_Tasks
.Where(t => t.CFG_Cart.CartStatus == CartStatus.InCarriageToWorkStation &&
t.FindingStatus == FindingStatus.Finished &&
t.DepartedTime < maxCarriageTime)
.ToList();
foreach (FND_Task fndTask in autoReachedFndTasks)
{
CFG_WorkStationCurrentCart cfgWorkStationCurrentCart = dbContext.CFG_WorkStationCurrentCarts
.Where(wscc => wscc.CFG_WorkStationId == fndTask.CFG_WorkStationId &&
wscc.CFG_CartId == null)
.OrderBy(wscc => wscc.Position)
.FirstOrDefault();
if (cfgWorkStationCurrentCart != null)
{
CFG_Cart cfgCart = fndTask.CFG_Cart;
cfgWorkStationCurrentCart.CFG_CartId = cfgCart.Id;
cfgWorkStationCurrentCart.DockedTime = DateTime.Now;
cfgCart.CartStatus = CartStatus.ArrivedAtWorkStation;
}
dbContext.SaveChanges();
}
}
}
}
}
/// <summary>
/// 确保基础数据已经初始化。
/// </summary>
public static void EnsureInitialized()
{
using (GeelyPtlEntities dbContext = new GeelyPtlEntities())
{
if (!dbContext.CFG_Employees.Any())
{
//操作员
CFG_Employee cfgEmployee = new CFG_Employee();
cfgEmployee.Code = "Administrator";
cfgEmployee.Name = "管理员";
cfgEmployee.LoginName = "admin";
cfgEmployee.Password = string.Empty;
cfgEmployee.IsEnabled = true;
dbContext.CFG_Employees.Add(cfgEmployee);
//巷道
//转台上的标签，托盘有 5 个库位，但只在单侧使用 3 个标签
//7 个巷道共用 1 个 4 口 XGate，按现场走线，总线 1 对应 1、2 巷道，总线 2 对应 3 巷道，总线 3 对应 4、5 巷道，总线 4 对应 6、7 巷道
//标签地址分别为：1、2、3，4、5、6，51、52、53，101、102、103，104、105、106，151、152、153，154、155、156。
//托盘库位定义为：1、2 在远端需旋转，3、4、5 在近段
string channelXGateIP = "10.34.36.17";
Dictionary <int, byte[]> channelPtl900UAddressesByChannelNumber = new Dictionary <int, byte[]>();
channelPtl900UAddressesByChannelNumber.Add(1, new byte[] { 3, 1, 1, 2, 3 });
channelPtl900UAddressesByChannelNumber.Add(2, new byte[] { 6, 4, 4, 5, 6 });
channelPtl900UAddressesByChannelNumber.Add(3, new byte[] { 53, 51, 51, 52, 53 });
channelPtl900UAddressesByChannelNumber.Add(4, new byte[] { 103, 101, 101, 102, 103 });
channelPtl900UAddressesByChannelNumber.Add(5, new byte[] { 106, 104, 104, 105, 106 });
channelPtl900UAddressesByChannelNumber.Add(6, new byte[] { 153, 151, 151, 152, 153 });
channelPtl900UAddressesByChannelNumber.Add(7, new byte[] { 156, 154, 154, 155, 156 });
for (int channelNumber = 1; channelNumber <= channelPtl900UAddressesByChannelNumber.Count; channelNumber++)
{
CFG_Channel cfgChannel = new CFG_Channel();
cfgChannel.Code = string.Format(CultureInfo.InvariantCulture, "{0}", channelNumber);
cfgChannel.Name = string.Format(CultureInfo.InvariantCulture, "巷道 {0}", channelNumber);
dbContext.CFG_Channels.Add(cfgChannel);
//转台上的标签
byte[] deviceAddresses = channelPtl900UAddressesByChannelNumber[channelNumber];
for (int position = 1; position <= 5; position++)
{
byte deviceAddress = deviceAddresses[position - 1];
byte busIndex = (byte)(deviceAddress / 50);
CFG_ChannelPtlDevice cfgChannelPtlDevice = new CFG_ChannelPtlDevice();
cfgChannelPtlDevice.CFG_Channel = cfgChannel;
cfgChannelPtlDevice.Position = position;
cfgChannelPtlDevice.XGateIP = channelXGateIP;
cfgChannelPtlDevice.RS485BusIndex = busIndex;
cfgChannelPtlDevice.Ptl900UAddress = deviceAddress;
dbContext.CFG_ChannelPtlDevices.Add(cfgChannelPtlDevice);
}
//巷道边的 4 个车位，多加两个备用车位
for (int position = 1; position <= 6; position++)
{
CFG_ChannelCurrentCart cfgChannelCurrentCart = new CFG_ChannelCurrentCart();
cfgChannelCurrentCart.CFG_Channel = cfgChannel;
cfgChannelCurrentCart.Position = position;
dbContext.CFG_ChannelCurrentCarts.Add(cfgChannelCurrentCart);
}
//巷道上的 1 个托盘
CFG_ChannelCurrentPallet cfgChannelCurrentPallet = new CFG_ChannelCurrentPallet();
cfgChannelCurrentPallet.CFG_Channel = cfgChannel;
dbContext.CFG_ChannelCurrentPallets.Add(cfgChannelCurrentPallet);
}
//小车
for (int cartNumber = 1; cartNumber <= 100; cartNumber++)
{
CFG_Cart cfgCart = new CFG_Cart();
cfgCart.Code = string.Format(CultureInfo.InvariantCulture, "{0:000000}", 100000 + cartNumber);
cfgCart.Name = string.Format(CultureInfo.InvariantCulture, "料车 {0}", cartNumber);
cfgCart.Rfid1 = "AABBCCDDEEFF";
cfgCart.XGateIP = "192.168.0.10";
cfgCart.CartStatus = CartStatus.Free;
dbContext.CFG_Carts.Add(cfgCart);
//小车上的 8 个库位
for (int position = 1; position <= 8; position++)
{
CFG_CartCurrentMaterial cfgCartCurrentMaterial = new CFG_CartCurrentMaterial();
cfgCartCurrentMaterial.CFG_Cart = cfgCart;
cfgCartCurrentMaterial.Position = position;
cfgCartCurrentMaterial.Usability = CartPositionUsability.Enable;
dbContext.CFG_CartCurrentMaterials.Add(cfgCartCurrentMaterial);
}
//小车上的 10 个标签
for (byte deviceAddress = 1; deviceAddress <= 10; deviceAddress++)
{
CFG_CartPtlDevice cfgCartPtlDevice = new CFG_CartPtlDevice();
cfgCartPtlDevice.CFG_Cart = cfgCart;
cfgCartPtlDevice.DeviceAddress = deviceAddress;
dbContext.CFG_CartPtlDevices.Add(cfgCartPtlDevice);
}
}
//dbContext.SaveChanges();
}
////线边工位的8个车位
//List<CFG_WorkStation> cfgWorkStations = dbContext.CFG_WorkStations.ToList();
//foreach (CFG_WorkStation cfgWorkStation in cfgWorkStations)
//{
// if (cfgWorkStation.CFG_WorkStationCurrentCarts != null && cfgWorkStation.CFG_WorkStationCurrentCarts.Count > 0)
// {
// continue;
// }
// for (int position = 1; position <= 8; position++)
// {
// CFG_WorkStationCurrentCart cfgWorkStationCurrentCart = new CFG_WorkStationCurrentCart();
// cfgWorkStationCurrentCart.CFG_WorkStation = cfgWorkStation;
// cfgWorkStationCurrentCart.Position = position;
// dbContext.CFG_WorkStationCurrentCarts.Add(cfgWorkStationCurrentCart);
// }
//}
//AGV开关信息
if (!dbContext.DST_AgvSwitchs.Any())
{
DST_AgvSwitch dstAgvSwitch = new DST_AgvSwitch();
dstAgvSwitch.isOpen = false;
dstAgvSwitch.lastCloseTime = DateTime.Now;
dbContext.DST_AgvSwitchs.Add(dstAgvSwitch);
}
dbContext.SaveChanges();
}
}
