123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092 |
- using SqlSugar;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Threading;
- using WCS.Data;
- using WCS.Data.Models;
- using WCS.Data.Utils;
- using WCS.PLC.Model.Equipment;
- namespace WCS.PLC
- {
- public class Base_Srm2 : Base_EquPlc
- {
- private int task_no_Last = 0;//上一次的任务号
- private readonly string SrmOutInInfo_in = "in";
- private readonly string SrmOutInInfo_out = "out";
- private readonly string SrmOutInInfo_outIn = "outIn";
- private readonly string WriteSrmSignalException = "520写入取放货信号失败";
- private readonly string WriteSrmTriggerException = "520写入触发信号失败";
- #region Properties
- /// <summary>
- /// 任务要执行的当前路由信息
- /// </summary>
- //protected WCS_EQUIPMENTROUTE CurrentRoute { get; set; }
- /// <summary>
- /// 堆垛机信号
- /// </summary>
- protected SrmSignal EquSignal
- {
- get
- {
- return WCS_PLCItem.WCS_EquipmentInfoSet[0].EquSignal_Srm;
- }
- }
- /// <summary>
- /// 写入DB名称
- /// </summary>
- protected int WriteDbName
- {
- get
- {
- return WCS_PLCItem.WCS_DBSet[0].DB_NAME;
- }
- }
- /// <summary>
- /// 堆垛机出入库口设置列表
- /// </summary>
- protected List<WCS_SrmOutInInfo> SrmOutInInfoSet = new List<WCS_SrmOutInInfo>();
- #endregion;
- #region Constructor
- public Base_Srm2() : base()
- {
- }
- #endregion;
- #region Method
- private int _locExecute = 0;
- public override void Run()
- {
- if (Interlocked.Exchange(ref _locExecute, 1) == 0)
- {
- try
- {
- //加载刷新堆垛机执行需要的最新参数设置
- Init_Refresh();
- //分配入库货位
- ThreadHelper.TaskThread(AssignInWareCell);
- if (WCS_PLCItem.IsConnSuccess == false) return;
- if (string.IsNullOrWhiteSpace(PlcName)) return;
- //写入心跳
- //WriteHandShake();
- //完成任务
- SRMCompleteTask();
- //执行任务
- SRMStartExecuteTask();
- }
- catch (Exception ex)
- {
- string errormsg = string.Format("堆垛机[{0}]执行异常,消息:{1}", PlcName, ex.ToString());
- LogMessageHelper.RecordLogMessage(errormsg, ex);
- }
- finally
- {
- Interlocked.Exchange(ref _locExecute, 0);
- }
- }
- }
- /// <summary>
- /// 堆垛机任务完成
- /// </summary>
- protected virtual void SRMCompleteTask()
- {
- try
- {
- //当前任务完成
- if (EquSignal.DB521_Task_Finishi == false) return;
- //查询任务
- var task = SugarBase.DB.Queryable<WCS_TASK>().First(v => v.TASK_NO == EquSignal.DB521_Taskfinishi_ID);
- if (task == null) return;
- if (task.TASK_WKSTATUS >= 99) return;
- if ((task.TASK_COMTYPE == (int)ComTypeEnum.入库 && task.TASK_POSIDTO.Length > 5) || task.TASK_COMTYPE == (int)ComTypeEnum.移库)
- {
- //完成任务
- string result = TryCachHelper.TryTranExecute((db) =>
- {
- //修改任务的状态
- db.Updateable<WCS_TASK>(it => new WCS_TASK() { TASK_WKSTATUS = 99, TASK_EDITUSERNO = "WCS", TASK_EDITDATETIME = DateTime.Now })
- .Where(it => it.TASK_NO == task.TASK_NO)
- .ExecuteCommand();
- //添加修改明细
- string msg = string.Format("任务[{0}]完成", task.TASK_NO);
- CommonData.AddWCS_TASK_DTL(db, task.TASK_NO, task.TASK_NO, task.TASK_POSIDCUR, task.TASK_POSIDTO, msg);
- });
- if (string.IsNullOrWhiteSpace(result))
- {
- if (task.TASK_COMTYPE == (int)ComTypeEnum.入库)
- {
- SrmConvNoMoveToLast(task.TASK_POSIDCUR);
- }
- }
- }
- else if (task.TASK_COMTYPE == (int)ComTypeEnum.出库 || task.TASK_COMTYPE == (int)ComTypeEnum.搬运)
- {
- if (task.TASK_WKSTATUS == (int)WkStatus.堆垛机执行)
- {
- //var routeSet = EquRouteHelper.QueryRoute(task.TASK_SRMNO, task.TASK_POSIDTO);
- //var routes = routeSet.Where(v => v.ROUTE_STARTPOS == task.TASK_SRMNO).ToList();
- //var route = QueryOutEquRouteItem(task, routes);
- int wksstatus = 6;
- //if (route.ISEND)
- //{
- // wksstatus = 99;
- //}
- string result = TryCachHelper.TryTranExecute((db) =>
- {
- //修改任务的状态
- db.Updateable<WCS_TASK>(it => new WCS_TASK() { TASK_WKSTATUS = wksstatus, TASK_POSIDCUR = task.TASK_POSIDNEXT, TASK_EDITUSERNO = "WCS", TASK_EDITDATETIME = DateTime.Now })
- .Where(it => it.TASK_NO == task.TASK_NO)
- .ExecuteCommand();
- //添加修改明细
- string msg = string.Format("任务[{0}]堆垛机完成,修改当前地址为[{1}]", task.TASK_NO, task.TASK_POSIDNEXT);
- CommonData.AddWCS_TASK_DTL(db, task.TASK_NO, task.TASK_NO, task.TASK_POSIDNEXT, task.TASK_POSIDNEXT, msg);
- });
- if (string.IsNullOrWhiteSpace(result))
- {
- SrmConvNoMoveToLast(task.TASK_POSIDNEXT);
- }
- }
- }
- //TaskComplete(task.TASK_SRMNO, task.TASK_ID, task.TASK_COMTYPE);
- }
- catch (Exception ex)
- {
- LogMessageHelper.RecordLogMessage(ex);
- }
- }
- private void SRMStartExecuteTask()
- {
- //检测堆垛机模式
- if (EquSignal.DB521_Auto_status != (int)SrmModeEnum.远程) return;
- //检测堆垛机报警
- if (EquSignal.SrmDB541_Alarm) return;
- //检测堆垛机状态
- if (EquSignal.DB521_Srm_Status != (int)SrmStateFork1Enum.空闲) return;
- if (EquSignal.DB520_Task_trigger != 0) return;
- //检测堆垛机禁用
- //if (Current.SysSets.FirstOrDefault(v => v.SET_ID == SrmNo).SET_VALUE.Trim() == "1") return;
- TryCachHelper.TryExecute((db) =>
- {
- var taskSet = db.Queryable<WCS_TASK>().Where(v => v.TASK_SRMNO == PlcName).ToList();
- var task = taskSet.FirstOrDefault(v => (v.TASK_WKSTATUS == (int)WkStatus.堆垛机执行));
- if (task == null)
- {
- //移库
- if (MoveStock(db)) return;
- taskSet = taskSet.Where(v => v.TASK_WKSTATUS <= 2).ToList();
- OutInStock(db, taskSet);
- }
- else
- {
- Log4netHelper.Logger_Error.ErrorFormat(string.Format("堆垛机[{0}]状态正常,但是存在执行中的任务[{1}]", PlcName, task.TASK_NO));
- }
- });
- }
- private void OutInStock(SqlSugarClient db, List<WCS_TASK> tasks)
- {
- if (tasks.Count == 0) return;
- var tasktemp = tasks.FirstOrDefault(v => v.TASK_NO == task_no_Last);
- if (tasktemp != null)
- {
- if ((tasktemp.TASK_COMTYPE == 1 && tasktemp.TASK_WKSTATUS == 2) ||
- (tasktemp.TASK_COMTYPE == 2 && tasktemp.TASK_WKSTATUS <= 1) ||
- (tasktemp.TASK_COMTYPE == 3 && tasktemp.TASK_WKSTATUS <= 1) ||
- (tasktemp.TASK_COMTYPE == 4 && tasktemp.TASK_WKSTATUS == 2))
- {
- if (ExecuteTask(db, tasktemp)) return;
- }
- }
- else
- {
- tasktemp = SugarBase.DB.Queryable<WCS_TASK>()
- .First(v => !SqlFunc.IsNullOrEmpty(v.TASK_POSIDMOVE) &&
- v.TASK_COMTYPE == 2 &&
- v.TASK_WKSTATUS <= 1 &&
- v.TASK_WMSNO == PlcName);
- if (tasktemp != null)
- {
- if (ExecuteTask(db, tasktemp)) return;
- }
- }
- int taskMaxPriority = tasks.Max(v => v.TASK_PRIORITY);
- for (int index = taskMaxPriority; index >= 0; index--)
- {
- var tasks_Temp = tasks.Where(v => v.TASK_PRIORITY == index).ToList();
- if (tasks_Temp.Count > 0)
- {
- //查询硬件条件满足的可用出入库任务
- var taskSet = QueryTask(db, tasks_Temp);
- //调用扩展函数返回可用出入库任务
- var taskList = QueryOutTasks(db, taskSet);
- //克隆集合
- List<WCS_SrmOutInInfo> outininfoSet = SrmOutInInfoSet.GetRange(0, SrmOutInInfoSet.Count);
- bool isEixt = false;
- foreach (var outininfo in outininfoSet)
- {
- if (outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_in || outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_outIn)
- {
- var taskitem = taskList.SingleOrDefault(v => v.TASK_POSIDCUR == outininfo.SRMOUTIN_CONVNO);
- if (taskitem != null)
- {
- if (taskitem.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_InStorage)
- {
- if (InStock(db, taskitem))
- {
- task_no_Last = taskitem.TASK_NO;
- isEixt = true;
- break;
- }
- }
- else if (taskitem.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_Carry)
- {
- if (Carry(db, taskitem))
- {
- task_no_Last = taskitem.TASK_NO;
- isEixt = true;
- break;
- }
- }
- }
- }
- if (outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_out || outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_outIn)
- {
- var tasktempList = taskList.Where(v => v.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_OutStorage).ToList();
- bool iscreateSuccess = false;
- foreach (var item in tasktempList)
- {
- //检测是否允许出库
- if (QueryOutTask(db, item))
- {
- if (OutStock(db, item))
- {
- task_no_Last = item.TASK_NO;
- iscreateSuccess = true;
- break;
- }
- }
- }
- if (iscreateSuccess)
- {
- isEixt = true;
- break;
- }
- }
- }
- if (isEixt)
- {
- break;
- }
- }
- }
- }
- protected virtual bool QueryOutTask(SqlSugarClient db, WCS_TASK task) { return true; }
- private bool ExecuteTask(SqlSugarClient db, WCS_TASK task)
- {
- bool isExecuteFinish = false;
- if (task.TASK_COMTYPE == (int)ComTypeEnum.入库)
- {
- if (InStock(db, task)) isExecuteFinish = true;
- }
- else if (task.TASK_COMTYPE == (int)ComTypeEnum.出库)
- {
- if (OutStock(db, task)) isExecuteFinish = true;
- }
- else if (task.TASK_COMTYPE == (int)ComTypeEnum.搬运)
- {
- if (Carry(db, task)) isExecuteFinish = true;
- }
- return isExecuteFinish;
- }
- protected virtual List<WCS_TASK> QueryOutTasks(SqlSugarClient db, List<WCS_TASK> taskSet) { return taskSet.OrderBy(n => n.TASK_ADDDATETIME).ToList(); }
- private List<WCS_TASK> QueryTask(SqlSugarClient db, List<WCS_TASK> tasks)
- {
- List<WCS_TASK> wcs_taskSet = new List<WCS_TASK>();
- //克隆集合
- List<WCS_SrmOutInInfo> outininfoSet = SrmOutInInfoSet.GetRange(0, SrmOutInInfoSet.Count);
- foreach (var outininfo in outininfoSet)
- {
- if (outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_in || outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_outIn)
- {
- var intasks = tasks.SingleOrDefault(v => v.TASK_WKSTATUS != (int)WkStatus.堆垛机执行 &&
- v.TASK_POSIDCUR == outininfo.SRMOUTIN_CONVNO &&
- //v.TASK_POSIDNEXT == outininfo.SRMOUTIN_CONVNO &&
- (v.TASK_COMTYPE == 1 || v.TASK_COMTYPE == 4));
- if (intasks != null)
- {
- var temptask = QueryInConvTask(outininfo, intasks);
- if (temptask != null)
- {
- wcs_taskSet.Add(temptask);
- continue;
- }
- }
- }
- if (outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_out || outininfo.SRMOUTIN_OUTINTYPE == SrmOutInInfo_outIn)
- {
- //检测出口状态
- var convSignal = ConveyorHelper.GetConveyorSignal(outininfo.SRMOUTIN_CONVPLCNAME, outininfo.SRMOUTIN_CONVNO);
- if (convSignal.DB521_Request == false && convSignal.DB521_Tasknum <= 0 && convSignal.CvDB51_PH_Status == false)
- {
- var outTask = db.Queryable<WCS_TASK>().First(v => v.TASK_POSIDCUR == outininfo.SRMOUTIN_CONVNO);
- if (outTask == null ||
- ((outTask.TASK_WKSTATUS != (int)WkStatus.输送机执行) && (outTask.TASK_WKSTATUS != (int)WkStatus.堆垛机完成)))
- {
- //检测是否存在该出口的任务列表
- List<WCS_TASK> list = new List<WCS_TASK>();
- var taskList = tasks.Where(v => v.TASK_COMTYPE == 2 && v.TASK_WKSTATUS <= 1).ToList();
- foreach (var task in taskList)
- {
- var routes = EquRouteHelper.QueryRoute(task.TASK_SRMNO, task.TASK_POSIDTO).Where(v => v.ROUTE_STARTPOS == PlcName).ToList();
- var routeitem = routes.FirstOrDefault(v => v.ROUTE_SONPOS == outininfo.SRMOUTIN_CONVNO);
- if (routeitem != null && CheckAreaOutAddress(task, routeitem))
- {
- if (wcs_taskSet.Any(v => v.TASK_NO == task.TASK_NO) == false)
- {
- list.Add(task);
- }
- }
- }
- if (list.Count() > 0) wcs_taskSet.AddRange(list);
- }
- }
- }
- }
- return wcs_taskSet;
- }
- /// <summary>
- /// 检测区域出口地址(弯轨堆垛机,多项道转换堆垛机)
- /// </summary>
- protected virtual bool CheckAreaOutAddress(WCS_TASK task, WCS_EQUIPMENTROUTE route)
- {
- return true;
- }
- protected virtual WCS_EQUIPMENTROUTE QueryOutEquRouteItem(WCS_TASK task, List<WCS_EQUIPMENTROUTE> routeSet)
- {
- return routeSet.Single();
- }
- /// <summary>
- /// 查询堆垛机入库口任务
- /// </summary>
- protected virtual WCS_TASK QueryInConvTask(WCS_SrmOutInInfo outininfo, WCS_TASK task)
- {
- WCS_TASK wcs_task = null;
- var convSignal = ConveyorHelper.GetConveyorSignal(outininfo.SRMOUTIN_CONVPLCNAME, outininfo.SRMOUTIN_CONVNO);
- if (convSignal.DB521_Tasknum == task.TASK_NO && convSignal.CvDB51_PH_Status
- //&& convSignal.DB521_Goodsend.ToString() == outininfo.SRMOUTIN_CONVNO
- )
- {
- if (task.TASK_COMTYPE == 1)
- {
- if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == PlcName)
- {
- wcs_task = null;
- }
- else
- {
- wcs_task = task;
- }
- }
- else if (task.TASK_COMTYPE == 4)
- {
- var route = EquRouteHelper.QueryRoute(task.TASK_SRMNO, task.TASK_POSIDTO).FirstOrDefault(v => v.ROUTE_STARTPOS == PlcName);
- var srmoutin = SrmOutInInfoSet.SingleOrDefault(v => v.SRMOUTIN_CONVNO == route.ROUTE_NEXTPOS && v.SRMOUTIN_SRMNO == PlcName);
- //检测出口状态
- var outConv = ConveyorHelper.GetConveyorSignal(srmoutin.SRMOUTIN_CONVPLCNAME, srmoutin.SRMOUTIN_CONVNO);
- if (outConv.DB521_Tasknum == 0 && outConv.CvDB51_PH_Status == false)
- {
- wcs_task = task;
- }
- }
- }
- return wcs_task;
- }
- protected bool InStock(SqlSugarClient db, WCS_TASK task)
- {
- bool result = true;
- try
- {
- if (task != null)
- {
- //检测任务当前位置存在于srm当前入口输送线列表中
- if (SrmOutInInfoSet.Any(v => v.SRMOUTIN_CONVNO == task.TASK_POSIDCUR && (v.SRMOUTIN_OUTINTYPE == SrmOutInInfo_in || v.SRMOUTIN_OUTINTYPE ==SrmOutInInfo_outIn)))
- {
- if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == PlcName)
- {
- //分配货位
- //bool assignresult = GetWareCell(task); //WareCell_Assign(db, task);
- //if (assignresult == false) return false;
- Log4netHelper.Logger_Error.ErrorFormat(string.Format("任务[{0}]未分配货位,堆垛机不能执行", task.TASK_NO));
- return false;
- }
- //task = db.Queryable<WCS_TASK>().First(v => v.TASK_NO == task.TASK_NO);
- //if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == SrmNo)
- //{
- // throw new Exception(string.Format("任务[{0}]未分配货位。", task.TASK_NO));
- //}
- //else
- //{
- // Log4netHelper.Logger_Info.InfoFormat("任务[{0}]货位分配成功", task.TASK_NO);
- //}
- var writeSignal = new WCSWriteToSrmSignal();
- writeSignal.Start_number = 0;
- writeSignal.Goodtype = 0;
- if (task.TASK_COMTYPE == 4)//移动
- {
- //var startCvToEnd = ConveyorHelper.SrmMoveCvSet.FirstOrDefault(v => v.StartConveyor == task.TASK_POSIDCUR);
- //writeSignal.RowPos1 = startCvToEnd.SrmStartRow;
- //writeSignal.Travelpos1 = startCvToEnd.SrmStartColumn;
- //writeSignal.Liftpos1 = startCvToEnd.SrmStartLayer;
- //writeSignal.Fork_start_pos1 = startCvToEnd.SrmStartDepth;
- //writeSignal.RowPos2 = startCvToEnd.SrmEndRow;
- //writeSignal.Travelpos2 = startCvToEnd.SrmEndColumn;
- //writeSignal.Liftpos2 = startCvToEnd.SrmEndLayer;
- //writeSignal.Fork_dest_pos2 = startCvToEnd.SrmEndDepth;
- }
- else
- {
- var route = Current.EquRouteSet.FirstOrDefault(v => v.ROUTE_STARTPOS == task.TASK_POSIDCUR);
- writeSignal.RowPos1 = (int)route.SRMROW;
- writeSignal.Travelpos1 = (int)route.SRMCOLUMN;
- writeSignal.Liftpos1 = (int)route.SRMLAYER;
- //writeSignal.Fork_start_pos1 = (int)route.DEPTH;
- //查询货位表巷道,深度
- //var location = db.Queryable<Base_Location>().First(v => v.Loc_No == task.TASK_POSIDTO);
- writeSignal.RowPos2 = task.ToRow;// location.Loc_Tunnel;
- writeSignal.Travelpos2 = task.ToCol;
- writeSignal.Liftpos2 = task.ToLayer;
- //writeSignal.Fork_dest_pos2 = task.ToDepth; //location.Loc_Depth;
- }
- //if (task.TASK_COMTYPE == 5)
- //{
- // var warecell = db.Queryable<BASE_WARECELL>().First(v => v.F_NO == task.TASK_POSIDTO);
- // int count = db.Queryable<BILL_INVCONTR>().Where(v => v.F_CONTRGRPNO == warecell.F_CNTRGRPNO).Count();
- // writeSignal.End_number = count;
- //}
- writeSignal.TaskID = task.TASK_NO;
- //执行任务
- SrmOutIn(writeSignal, task.TASK_POSIDCUR, task.TASK_POSIDTO);
- }
- }
- }
- catch (Exception ex)
- {
- if (ex.Message.Contains(WriteSrmSignalException) == false &&
- ex.Message.Contains(WriteSrmTriggerException) == false)
- {
- result = false;
- }
- }
- return result;
- }
- protected bool OutStock(SqlSugarClient db, WCS_TASK task)
- {
- bool result = true;
- try
- {
- var writeSignal = new WCSWriteToSrmSignal();
- writeSignal.Start_number = 0;
- writeSignal.End_number = 0;
- writeSignal.Goodtype = 0;
- //查询货位表巷道,深度
- //var location = db.Queryable<Base_Location>().First(v => v.Loc_No == outtask.TASK_POSIDFROM);
- if (task.TASK_POSIDCUR == task.TASK_POSIDFROM)
- {
- //堆垛机出库
- writeSignal.RowPos1 = task.FromRow;//location.Loc_Tunnel;
- writeSignal.Travelpos1 = task.FromCol;//outtask.ToCol;
- writeSignal.Liftpos1 = task.FromLayer;//outtask.ToLayer;
- }
- else
- {
- //堆垛机搬运任务
- var routeSet = Current.EquRouteSet.Where(v => v.ROUTE_STARTPOS == task.TASK_POSIDCUR).ToList();
- var routes = routeSet.Where(v => v.ROUTE_SONPOS == PlcName).ToList();
- var route = QueryOutEquRouteItem(task, routes);
- writeSignal.RowPos1 = (int)route.SRMROW;//location.Loc_Tunnel;
- writeSignal.Travelpos1 = (int)route.SRMCOLUMN;//outtask.ToCol;
- writeSignal.Liftpos1 = (int)route.SRMLAYER;//outtask.ToLayer;
- }
- //writeSignal.Fork_start_pos1 = outtask.FromDepth;// location.Loc_Depth; location.Loc_EquimentNo
- if (task.TASK_COMTYPE == 2)
- {
- var routeSet = EquRouteHelper.QueryRoute(task.TASK_SRMNO, task.TASK_POSIDTO);
- var routes = routeSet.Where(v => v.ROUTE_STARTPOS == task.TASK_SRMNO).ToList();
- var route = QueryOutEquRouteItem(task, routes);
- writeSignal.RowPos2 = (int)route.SRMROW;
- writeSignal.Travelpos2 = (int)route.SRMCOLUMN;
- writeSignal.Liftpos2 = (int)route.SRMLAYER;
- //writeSignal.Fork_dest_pos2 = (int)route.DEPTH;
- writeSignal.TaskID = task.TASK_NO;
- //执行任务
- SrmOutIn(writeSignal, task.TASK_POSIDFROM, route.ROUTE_SONPOS);
- }
- else if (task.TASK_COMTYPE == 3)
- {
- if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == WCS_PLCItem.PLC_NAME)
- {
- bool assignresult = GetWareCell(task);
- if (assignresult == false) return result;
- }
- writeSignal.RowPos2 = task.ToRow;
- writeSignal.Travelpos2 = task.ToCol;
- writeSignal.Liftpos2 = task.ToLayer;
- //writeSignal.Fork_dest_pos2 = outtask.ToDepth;
- writeSignal.TaskID = task.TASK_NO;
- //执行任务
- SrmOutIn(writeSignal, task.TASK_POSIDFROM, task.TASK_POSIDTO);
- }
- }
- catch (Exception ex)
- {
- LogMessageHelper.RecordLogMessage(ex);
- if (ex.Message.Contains(WriteSrmSignalException) == false &&
- ex.Message.Contains(WriteSrmTriggerException) == false)
- {
- result = false;
- }
- }
- return result;
- }
- protected bool Carry(SqlSugarClient db, WCS_TASK task)
- {
- bool result = true;
- try
- {
- var writeSignal = new WCSWriteToSrmSignal();
- writeSignal.Start_number = 0;
- writeSignal.End_number = 0;
- writeSignal.Goodtype = 0;
- var routeItem = Current.EquRouteSet.SingleOrDefault(v => v.ROUTE_STARTPOS == task.TASK_POSIDNEXT && v.ROUTE_SONPOS == PlcName);
- //查询货位表巷道,深度
- //var location = db.Queryable<Base_Location>().First(v => v.Loc_No == outtask.TASK_POSIDFROM);
- writeSignal.RowPos1 = (int)routeItem.SRMROW;//task.FromRow;//location.Loc_Tunnel;
- writeSignal.Travelpos1 = (int)routeItem.SRMCOLUMN; //task.FromCol;//outtask.ToCol;
- writeSignal.Liftpos1 = (int)routeItem.SRMLAYER;//task.FromLayer;//outtask.ToLayer;
- //writeSignal.Fork_start_pos1 = outtask.FromDepth;// location.Loc_Depth; location.Loc_EquimentNo
- var routeSet = EquRouteHelper.QueryRoute(task.TASK_SRMNO, task.TASK_POSIDTO);
- var route = routeSet.FirstOrDefault(v => v.ROUTE_STARTPOS == task.TASK_SRMNO);
- writeSignal.RowPos2 = (int)route.SRMROW;
- writeSignal.Travelpos2 = (int)route.SRMCOLUMN;
- writeSignal.Liftpos2 = (int)route.SRMLAYER;
- //writeSignal.Fork_dest_pos2 = (int)route.DEPTH;
- writeSignal.TaskID = task.TASK_NO;
- //执行任务
- SrmOutIn(writeSignal, task.TASK_POSIDNEXT, route.ROUTE_SONPOS);
- }
- catch (Exception ex)
- {
- LogMessageHelper.RecordLogMessage(ex);
- if (ex.Message.Contains(WriteSrmSignalException) == false &&
- ex.Message.Contains(WriteSrmTriggerException) == false)
- {
- result = false;
- }
- }
- return result;
- }
- protected bool MoveStock(SqlSugarClient db)
- {
- bool result = false;
- var task = QueryMoveTask(db);
- if (task == null) return result;
- if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == WCS_PLCItem.PLC_NAME)
- {
- //分配货位
- bool assignresult = GetWareCell(task);
- if (assignresult == false) return result;
- //分配货位
- //bool assignresult = WareCell_Assign(db, task);
- //if (assignresult == false) return result;
- }
- var writeSignal = new WCSWriteToSrmSignal();
- writeSignal.Start_number = 0;
- writeSignal.End_number = 0;
- writeSignal.Goodtype = 0;
- //查询货位表巷道,深度
- //var location1 = db.Queryable<BASE_WARECELL>().First(v => v.F_NO == task.TASK_POSIDFROM);
- writeSignal.RowPos1 = task.FromRow; // location1.F_LINE;
- writeSignal.Travelpos1 = task.FromCol;
- writeSignal.Liftpos1 = task.FromLayer;
- //writeSignal.Fork_start_pos1 = location1.F_DEPTH;
- writeSignal.End_number = 0;
- //查询货位表巷道,深度
- //var location2 = db.Queryable<BASE_WARECELL>().First(v => v.F_NO == task.TASK_POSIDTO);
- writeSignal.RowPos2 = task.ToRow;//location2.F_LINE;
- writeSignal.Travelpos2 = task.ToCol;
- writeSignal.Liftpos2 = task.ToLayer;
- //writeSignal.Fork_dest_pos2 = location2.F_DEPTH;
- writeSignal.TaskID = task.TASK_NO;
- writeSignal.End_number = 0;
- //执行任务
- SrmOutIn(writeSignal, task.TASK_POSIDFROM, task.TASK_POSIDTO);
- result = true;
- return result;
- }
- private void SrmOutIn(WCSWriteToSrmSignal srmSignal, string startPos, string posIdnext)
- {
- var task = Current.TaskSet.First(v => v.TASK_NO == srmSignal.TaskID);
- WCS_CacheInfo cahcheinfo = null;//Current.WCS_CacheInfoSet.FirstOrDefault(v => v.Cache_ConvNo == task.TASK_POSIDTO || v.Cache_AreaName == task.TASK_POSIDTO);
- string cacheAreaName = cahcheinfo == null ? srmSignal.TaskID.ToString() : cahcheinfo.Cache_AreaName;
- //string errorMsg = ThreadLockHelper.SrmOutIn(EquSignal, srmSignal, WCS_PLCItem.Plc, WriteDbName, startPos, posIdnext, cacheAreaName, PlcName);
- string errorMsg = SrmOutIn(EquSignal, srmSignal, startPos, posIdnext, cacheAreaName);
- if (!string.IsNullOrWhiteSpace(errorMsg)) throw new Exception(errorMsg);
- }
- public string SrmOutIn(SrmSignal equSignal, WCSWriteToSrmSignal srmSignal, string startPos, string posIdnext, string cacheAreaName)
- {
- using (var mutex = new Mutex(false, cacheAreaName))
- {
- string resultMsg = string.Empty;
- try
- {
- if (mutex.WaitOne(-1, false))
- {
- SrmTaskRun(equSignal, srmSignal, startPos, posIdnext, cacheAreaName);
- }
- }
- catch (Exception ex)
- {
- resultMsg = ex.Message;
- }
- finally
- {
- mutex.ReleaseMutex();
- }
- return resultMsg;
- }
- }
- private void SrmTaskRun(SrmSignal equSignal, WCSWriteToSrmSignal srmSignal, string startPos, string posIdnext, string cacheAreaName)
- {
- //检测并生成移库任务
- CheckCreateMoveTask(srmSignal,ref startPos,ref posIdnext);
- bool isExecute = CheckIsExecuteTask(cacheAreaName);
- if (isExecute)
- {
- if (equSignal.DB520_Start_number == srmSignal.Start_number &&
- equSignal.DB520_End_number == srmSignal.End_number &&
- equSignal.DB520_Goodtype == srmSignal.Goodtype &&
- equSignal.DB520_Runmode == srmSignal.Runmode &&
- equSignal.DB520_FromRowPos == srmSignal.RowPos1 &&
- equSignal.DB520_FromColumnPos == srmSignal.Travelpos1 &&
- equSignal.DB520_FromLayerPos == srmSignal.Liftpos1 &&
- equSignal.DB520_Fork_start_pos1 == srmSignal.Fork_start_pos1 &&
- equSignal.DB520_ToRowPos == srmSignal.RowPos2 &&
- equSignal.DB520_ToColumnPos == srmSignal.Travelpos2 &&
- equSignal.DB520_ToLayerPos == srmSignal.Liftpos2 &&
- equSignal.DB520_Fork_dest_pos2 == srmSignal.Fork_dest_pos2 &&
- equSignal.DB520_TaskID == srmSignal.TaskID)
- {
- string convNo = string.Empty;
- string result = TryCachHelper.TryTranExecute((db) =>
- {
- var task = db.Queryable<WCS_TASK>().First(t => t.TASK_NO == srmSignal.TaskID);
- if (task.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_OutStorage)
- {
- convNo = posIdnext;
- }
- else if (task.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_InStorage ||
- task.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_Carry)
- {
- convNo = task.TASK_POSIDCUR;
- }
- db.Updateable<WCS_TASK>(it => new WCS_TASK() { TASK_WKSTATUS = (int)WkStatus.堆垛机执行, TASK_POSIDNEXT = posIdnext, TASK_EDITUSERNO = "WCS", TASK_EDITDATETIME = DateTime.Now })
- .Where(it => it.TASK_NO == srmSignal.TaskID).ExecuteCommand();
- string msg = string.Format("任务[{0}]已下发给堆垛机执行,起点位置[{1}]目标地址[{2}]", task.TASK_NO, startPos, posIdnext);
- CommonData.AddWCS_TASK_DTL(db, task.TASK_NO, task.TASK_NO, task.TASK_POSIDCUR, posIdnext, msg);
- if (equSignal.DB520_Task_trigger != 1)
- {
- string mes = string.Format("读取plc信息:任务号[{0}]起始行[{1}]起始列[{2}]起始层[{3}]目标行[{4}]目标列[{5}]目标层[{6}]",
- equSignal.DB520_TaskID, equSignal.DB520_FromRowPos, equSignal.DB520_FromColumnPos, equSignal.DB520_FromLayerPos,
- equSignal.DB520_ToRowPos, equSignal.DB520_ToColumnPos, equSignal.DB520_ToLayerPos);
- Log4netHelper.Logger_Info.InfoFormat(mes);
- if (WCS_PLCItem.Plc.WriteSignal((ushort)WriteDbName, 30, 2, 1))
- {
- Log4netHelper.Logger_Info.InfoFormat(string.Format("任务[{0}]写入触发信号成功。", srmSignal.TaskID));
- }
- else
- {
- throw new Exception(string.Format("任务[{0}]520写入触发信号失败。", srmSignal.TaskID));
- }
- }
- });
- if (string.IsNullOrWhiteSpace(result))
- {
- task_no_Last = 0;
- //移动到最后
- SrmConvNoMoveToLast(convNo);
- }
- else
- {
- throw new Exception(string.Format("任务[{0}]堆垛机执行失败,原因:[{1}]", srmSignal.TaskID, result));
- }
- }
- else
- {
- WriteTaskToSrm(srmSignal);
- }
- }
- else
- {
- throw new Exception(string.Format("目标地址[{0}]交通管制,暂无法执行出库任务,将优先执行其它任务。", cacheAreaName));
- }
- }
- private void CheckCreateMoveTask(WCSWriteToSrmSignal srmSignal,ref string startPos,ref string posIdnext)
- {
- var task = SugarBase.DB.Queryable<WCS_TASK>().Single(v => v.TASK_NO == srmSignal.TaskID);
- if (task != null &&
- task.FromDepth == 2 &&
- task.TASK_POSIDCUR == task.TASK_POSIDFROM &&
- string.IsNullOrWhiteSpace(task.TASK_POSIDMOVE))
- {
- var tasktemps = SugarBase.DB.Queryable<WCS_TASK>().Where(v => v.TASK_SRMNO == PlcName).ToList();
- var task_DepthOne = tasktemps.FirstOrDefault(v => v.FromNo == task.FromNo &&
- v.FromCol == task.FromCol &&
- v.FromLayer == task.FromLayer &&
- v.FromDepth == 1 &&
- v.TASK_WKSTATUS <= 1 &&
- v.TASK_COMTYPE == 2 || v.TASK_COMTYPE == 3);
- if (task_DepthOne == null)
- {
- //调用生成移库任务接口
- var moveTaskresult = Current.WmsInterface.I_WCS_GetMoveTask(new GetMoveTaskParam() { WMSTaskNum = task.TASK_WMSNO });
- if (moveTaskresult.ResType == 0)
- {
- throw new Exception(string.Format("任务[{0}]调用移库接口报错:[{1}]", task.TASK_NO, moveTaskresult.ResMessage));
- }
- else if (moveTaskresult.ResType == 2)
- {
- //创建移库任务并执行
- var moveTask = new WCS_TASK()
- {
- TASK_WMSNO = moveTaskresult.WMSTaskNum,
- TASK_COMTYPE = 3,
- TASK_SYSTYPE = "wcs",
- TASK_POSIDFROM = moveTaskresult.MoveStartWareCell,
- TASK_POSIDCUR = moveTaskresult.MoveStartWareCell,
- TASK_POSIDNEXT = moveTaskresult.MoveStartWareCell,
- TASK_POSIDTO = moveTaskresult.MoveEndWareCell,
- TASK_POSIDMOVE = moveTaskresult.MoveEndWareCell,
- TASK_PRIORITY = 0,
- TASK_WKSTATUS = 0,
- TASK_WHID = moveTaskresult.WareHouseName,
- TASK_ADDUSERNO = "wcs",
- TASK_ADDDATETIME = SugarBase.DB.GetDate(),
- TASK_EDITUSERNO = "wcs",
- TASK_EDITDATETIME = SugarBase.DB.GetDate(),
- TASK_NOTES = string.Empty,
- TASK_SRMNO = PlcName,
- TASK_BOXBARCODE = moveTaskresult.ContainerBarCode,
- TASK_FromTunnelNum = moveTaskresult.FromTunnelNum,
- TASK_EndTunnelNum = moveTaskresult.EndTunnelNum
- };
- string result = TryCachHelper.TryTranExecute((db) =>
- {
- int inserttask = db.Insertable(moveTask).ExecuteCommand();
- if (inserttask <= 0)
- {
- throw new Exception(string.Format("任务[{0}]生成移库添加移库任务失败.", task.TASK_NO));
- }
- //修改任务的移库字段
- int updatetask = db.Updateable<WCS_TASK>(it => new WCS_TASK() { TASK_POSIDMOVE = moveTask.TASK_POSIDMOVE, TASK_PRIORITY = 111, TASK_EDITUSERNO = "WCS", TASK_EDITDATETIME = DateTime.Now })
- .Where(it => it.TASK_NO == task.TASK_NO)
- .ExecuteCommand();
- if (updatetask <= 0)
- {
- throw new Exception(string.Format("任务[{0}]生成移库时修改需要移库的任务失败.", task.TASK_NO));
- }
- });
- if (!string.IsNullOrWhiteSpace(result))
- {
- throw new Exception(result);
- }
- task = SugarBase.DB.Queryable<WCS_TASK>().First(v => v.TASK_WMSNO == moveTask.TASK_WMSNO);
- }
- else if (moveTaskresult.ResType == 3)
- {
- if (string.IsNullOrWhiteSpace(moveTaskresult.Memo1.Trim()))
- {
- throw new Exception(string.Format("调用移库接口报错:堆垛机[{0}]优先执行的入库任务号不能为空。", PlcName));
- }
- else
- {
- int task_no = Convert.ToInt16(moveTaskresult.Memo1.Trim());
- if (task_no <= 0)
- {
- throw new Exception(string.Format("调用移库接口报错:堆垛机[{0}]优先执行的入库任务号不能为零。", PlcName));
- }
- SugarBase.DB.Updateable<WCS_TASK>(it => new WCS_TASK() { TASK_PRIORITY = 10, TASK_EDITDATETIME = DateTime.Now })
- .Where(it => it.TASK_NO == task_no)
- .ExecuteCommand();
- }
- }
- }
- else if (task_DepthOne.TASK_WKSTATUS <= 1)
- {
- task = task_DepthOne;
- }
- }
- if (task == null)
- {
- throw new Exception(string.Format("堆垛机[{0}]执行的任务[{1}]不存在", PlcName, srmSignal.TaskID));
- }
- if (task.TASK_COMTYPE == 3)
- {
- #region 堆垛机取货地址
- srmSignal.RowPos1 = task.FromRow;
- srmSignal.Travelpos1 = task.FromCol;
- srmSignal.Liftpos1 = task.FromLayer;
- #endregion;
- #region 堆垛机放货地址
- if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == WCS_PLCItem.PLC_NAME)
- {
- bool assignresult = GetWareCell(task);
- if (assignresult == false)
- throw new Exception(string.Format("移库任务[{0}]分配货位失败。", task.TASK_NO));
- }
- var routeSet = EquRouteHelper.QueryRoute(task.TASK_SRMNO, task.TASK_POSIDTO);
- var routes = routeSet.Where(v => v.ROUTE_STARTPOS == task.TASK_SRMNO).ToList();
- var route = QueryOutEquRouteItem(task, routes);
- srmSignal.RowPos2 = (int)route.SRMROW;
- srmSignal.Travelpos2 = (int)route.SRMCOLUMN;
- srmSignal.Liftpos2 = (int)route.SRMLAYER;
- //writeSignal.Fork_dest_pos2 = (int)route.DEPTH;
- srmSignal.TaskID = task.TASK_NO;
- #endregion;
- startPos = task.TASK_POSIDFROM;
- posIdnext = task.TASK_POSIDTO;
- }
- }
- private static bool CheckIsExecuteTask(string cacheAreaName)
- {
- bool isExecute = false;
- var cacheInfoSet = Current.WCS_CacheInfoSet.Where(v => v.Cache_AreaName == cacheAreaName).ToList();
- if (cacheInfoSet.Count <= 0)
- {
- isExecute = true;
- }
- else
- {
- int cacheCount = cacheInfoSet.Sum(v => v.Cache_Count);
- var tasks = SugarBase.DB.Queryable<WCS_TASK>()
- .Where(v => v.TASK_COMTYPE == (int)TaskTypeEnum.TaskType_OutStorage &&
- (v.TASK_WKSTATUS > 1 || (v.TASK_WKSTATUS <= 1 && SqlFunc.IsNullOrEmpty(v.TASK_POSIDMOVE) == false)))
- .ToList();
- int curTaskCount = tasks.Count(v => v.TASK_POSIDTO == cacheAreaName || cacheInfoSet.Any(t => t.Cache_ConvNo == v.TASK_POSIDNEXT || t.Cache_ConvNo == v.TASK_POSIDTO));
- if (curTaskCount < cacheCount)
- {
- int ph_StatusCount = 0;//光电信号数量
- foreach (var item in cacheInfoSet)
- {
- var cv = ConveyorHelper.GetConveyorSignal(item.Cache_PlcName, item.Cache_ConvNo);
- if (cv.DB521_Tasknum > 0 || cv.CvDB51_PH_Status)
- {
- if (tasks.Any(v => v.TASK_NO == cv.DB521_Tasknum) == false)
- {
- ph_StatusCount++;
- }
- }
- }
- if ((curTaskCount + ph_StatusCount) < cacheCount)
- {
- isExecute = true;
- }
- }
- }
- return isExecute;
- }
- private void WriteTaskToSrm(WCSWriteToSrmSignal srmSignal)
- {
- List<byte> list = new List<byte>();
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Start_number).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.End_number).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Goodtype).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Runmode).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.RowPos1).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Travelpos1).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Liftpos1).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Fork_start_pos1).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.RowPos2).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Travelpos2).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Liftpos2).ToList());
- list.AddRange(ExtendsUtil.UshortToByte((ushort)srmSignal.Fork_dest_pos2).ToList());
- list.AddRange(ExtendsUtil.UintToByte((uint)srmSignal.TaskID).ToList());
- Log4netHelper.Logger_Info.InfoFormat(string.Format("写入任务[{0}]信息", srmSignal.TaskID));
- bool result = WCS_PLCItem.Plc.Write((ushort)WriteDbName, 2, list.ToArray());
- if (result)
- {
- Log4netHelper.Logger_Info.InfoFormat(string.Format("堆垛机[{0}]写入任务[{1}]信息成功", PlcName, srmSignal.TaskID));
- }
- else
- {
- throw new Exception(string.Format("堆垛机[{0}]写入任务[{1}]信息失败", PlcName, srmSignal.TaskID));
- }
- }
- private WCS_TASK QueryMoveTask(SqlSugarClient db)
- {
- WCS_TASK task = null;
- var movetaskSet = db.Queryable<WCS_TASK>().Where(v => v.TASK_COMTYPE == (int)ComTypeEnum.移库 && v.TASK_WKSTATUS <= 1 && v.TASK_SRMNO == WCS_PLCItem.PLC_NAME).ToList();
- if (movetaskSet.Count > 0) task = movetaskSet[0];
- return task;
- }
- /// <summary>
- /// 调整堆垛机出入口顺序
- /// </summary>
- /// <param name="convNo"></param>
- private void SrmConvNoMoveToLast(string convNo)
- {
- try
- {
- if (!string.IsNullOrWhiteSpace(convNo))
- {
- //检测是否是最后一项
- if (SrmOutInInfoSet[SrmOutInInfoSet.Count() - 1].SRMOUTIN_CONVNO == convNo) return;
- //查询要调整执行顺序的输送线
- var outininfo = SrmOutInInfoSet.FirstOrDefault(v => v.SRMOUTIN_CONVNO == convNo);
- //删除当前
- SrmOutInInfoSet.Remove(outininfo);
- //添加到最后
- SrmOutInInfoSet.Add(outininfo);
- }
- }
- catch (Exception ex)
- {
- Log4netHelper.Logger_Info.ErrorFormat(ex.ToString());
- }
- }
- /// <summary>
- /// 加载堆垛机刷新数据
- /// </summary>
- private void Init_Refresh()
- {
- var srmconvinfoset = Current.WCS_SrmOutInInfoSet.Where(v => v.SRMOUTIN_SRMNO == PlcName && v.SRMOUTIN_ISSTOP == false).OrderBy(p => p.SRMOUTIN_PRIORITY).OrderBy(t => t.SRMOUTIN_SEQUENCE).ToList();
- if (SrmOutInInfoSet.Count != srmconvinfoset.Count || //元素个数不相同
- srmconvinfoset.Any(v => v.SRMOUTIN_ISUPDATE)) //元素已更新
- {
- SrmOutInInfoSet = srmconvinfoset;
- SugarBase.DB.Updateable<WCS_SrmOutInInfo>(it => new WCS_SrmOutInInfo() { SRMOUTIN_ISUPDATE = false })
- .Where(it => it.SRMOUTIN_SRMNO == PlcName)
- .ExecuteCommand();
- }
- }
- private int _assignInWareCell = 0;
- /// <summary>
- /// 分配入库货位
- /// </summary>
- private void AssignInWareCell()
- {
- if (Interlocked.Exchange(ref _assignInWareCell, 1) == 0)
- {
- try
- {
- var taskSet = SugarBase.DB.Queryable<WCS_TASK>().Where(v => v.TASK_SRMNO == PlcName && v.TASK_WKSTATUS != 5 && v.TASK_WKSTATUS > 1).ToList().OrderByDescending(v => v.TASK_PRIORITY).ToList();
- var taskSet_In = taskSet.Where(v => v.TASK_COMTYPE == 1).ToList();
- foreach (var task in taskSet_In)
- {
- if (SrmOutInInfoSet.Any(v => v.SRMOUTIN_CONVNO == task.TASK_POSIDCUR && (v.SRMOUTIN_OUTINTYPE == "in" || v.SRMOUTIN_OUTINTYPE == "outIn")) || task.TASK_POSIDCUR == "1025")
- {
- if (string.IsNullOrWhiteSpace(task.TASK_POSIDTO) || task.TASK_POSIDTO == PlcName)
- {
- //入库任务分配货位
- GetWareCell(task);
- }
- }
- }
- }
- catch (Exception ex)
- {
- LogMessageHelper.RecordLogMessage(string.Format("分配入库货位异常:[{0}]", ex.Message), ex);
- }
- finally
- {
- Interlocked.Exchange(ref _assignInWareCell, 0);
- }
- }
- }
- public bool GetWareCell(WCS_TASK task)
- {
- string resultMsg = string.Empty;
- //调度接口获取货位
- var getWareCell = Current.WmsInterface.I_WCS_GetWareCell(new GetWareCellParam() { WMSTaskNum = task.TASK_WMSNO.ToString(), TunnelNum = task.TASK_EndTunnelNum, PickUpEquipmentNo = task.TASK_POSIDNEXT });
- if (getWareCell.ResType)
- {
- resultMsg = TryCachHelper.TryTranExecute((db) =>
- {
- //修改任务分配货位
- db.Updateable<WCS_TASK>(it => new WCS_TASK() { TASK_WKSTATUS = 2, TASK_POSIDNEXT = getWareCell.CellNo, TASK_POSIDTO = getWareCell.CellNo, TASK_EDITUSERNO = "WCS", TASK_EDITDATETIME = DateTime.Now })
- .Where(it => it.TASK_NO == task.TASK_NO)
- .ExecuteCommand();
- //添加修改明细
- string msg = string.Format("任务[{0}]分配货位[{1}]成功。", task.TASK_NO, getWareCell.CellNo);
- CommonData.AddWCS_TASK_DTL(db, task.TASK_NO, task.TASK_NO, task.TASK_POSIDCUR, task.TASK_POSIDNEXT, msg);
- });
- }
- else
- {
- resultMsg = string.Format("任务[{0}]调用接口分配货位[{1}]失败,原因:{2}", task.TASK_NO, getWareCell.CellNo, getWareCell.ResMessage);
- LogMessageHelper.RecordLogMessage(resultMsg);
- }
- if (string.IsNullOrWhiteSpace(resultMsg))
- {
- task.TASK_POSIDNEXT = getWareCell.CellNo;
- task.TASK_POSIDTO = getWareCell.CellNo;
- return true;
- }
- else
- {
- return false;
- }
- }
- #endregion;
- }
- }
|