| | |
| | | { |
| | | // var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList(); |
| | | var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0).OrderBy(x => x.TagOverTime).ToList(); |
| | | if (LocLock(WJ_BQ.RK_BBHJQ)) |
| | | { |
| | | |
| | | //标签入库 |
| | | YwlBQ_CreInwork(locsFirst, WJ_BQ.RK_BQDDQ, WJ_BQ.RK_BBHJQ); |
| | | } |
| | | |
| | | if (yuworders.Any()) |
| | | { |
| | | LogHelper.Info($" 无菌出库 工单开启中 "); |
| | |
| | | { |
| | | // var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "无菌标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).OrderBy(x => x.TagOverTime).ToList(); |
| | | var yuworders = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == "中水标签出库" && x.WorkType == 6 && x.SQL_State == "执行中").FindAll(x => x.OutNum > 0).OrderBy(x => x.TagOverTime).ToList(); |
| | | if (LocLock(SX_BQ.RK_BBHJQ)) |
| | | { |
| | | |
| | | //水标入库 |
| | | YwlBQ_CreInwork(SblocsFirst, SX_BQ.RK_BQDDQ, SX_BQ.RK_BBHJQ); |
| | | } |
| | | |
| | | if (yuworders.Any()) |
| | | { |
| | | LogHelper.Info($" 无菌出库 工单开启中 "); |
| | |
| | | var cir = cirs.OrderByDescending(x => x.T_CREATE).FirstOrDefault(); |
| | | if (CNTR.FirstOrDefault().S_TYPE == BQ_PRA.B) |
| | | { |
| | | if (cirs.FirstOrDefault().S_ITEM_NAME.Contains("空框"))//空框 退到空框缓存区 |
| | | { |
| | | var hjs = LocationHelper.GetAreaNormalLocList(WJ_BQ.RK_BBHJQ, false, false); |
| | | } |
| | | else |
| | | { |
| | | var s_type = ContainerHelper.GetCntrItemRel(CNTR.FirstOrDefault().S_CNTR_CODE).FirstOrDefault()?.N_BQ_TRAY_TYPE ?? 0; |
| | | Location Endbit = null; |
| | | //if (area == area/* WJ_BQ.RK_BQJBQ*/) |
| | |
| | | var re = TaskProcess.CreateTransport("", lastfull.S_LOC_CODE.Trim(), Endbit.S_LOC_CODE, "标签叉运-线边标签退库", CNTR.Select(x => x.S_CNTR_CODE).ToList(), 1, 1, 1, 62); |
| | | LogHelper.CSucessLog($"from {lastfull.S_LOC_CODE} to {Endbit.S_LOC_CODE} 标签叉运-接驳标签退库 ,创建{re}"); |
| | | } |
| | | } |
| | | |
| | | // } |
| | | |
| | | //else |
| | |
| | | if (PLC.deviceName.Contains("T2")) |
| | | pline = "T2提升机-纸箱"; |
| | | |
| | | var orkOrd = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中"); |
| | | var orkOrd = LocationHelper.GetList<YWLWorkOrder>(x => x.SQL_PLineNo == pline && x.WorkType == 6 && x.SQL_State == "执行中").ToList(); |
| | | bool can = false; |
| | | if (orkOrd.Any()) |
| | | { |
| | |
| | | can = true; |
| | | } |
| | | |
| | | orkOrd = orkOrd.FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10); |
| | | orkOrd = orkOrd.FindAll(x => x.OutNum > 0 && DateTime.Now.Subtract(x.SQL_Modify_TIme ?? DateTime.Now).TotalSeconds > 10).ToList(); |
| | | ReadCCK = can; |
| | | if (orkOrd.Any()) |
| | | foreach (var od in orkOrd.OrderBy(x => x.TagOverTime).ThenBy(x => x.OutNum)) |
| | | foreach (var od in orkOrd.OrderBy(x => x.TagOverTime).ThenBy(x => x.OutNum).ToList()) |
| | | //foreach (var od in od2.ToList()) |
| | | { |
| | | var l2 = new List<string>() { "YWLAQWJ", "YWLBQWJ" };//, "YWLCQSX", "YWLDQWJ" }; |
| | |
| | | var db = new SqlHelper<object>().GetInstance(); |
| | | od.TagOverTime = DateTime.Now; |
| | | od.TagOver = StartBit.S_AREA_CODE; |
| | | if (od.OutNum >= StartBit.N_CURRENT_NUM) |
| | | { |
| | | od.OutNum = od.OutNum - StartBit.N_CURRENT_NUM; |
| | | } |
| | | var ggf = db.Updateable(od).UpdateColumns(it => new { it.TagOverTime, it.TagOver, it.OutNum }).ExecuteCommand(); |
| | | //if (od.OutNum >= StartBit.N_CURRENT_NUM) |
| | | //{ |
| | | // od.OutNum = od.OutNum - StartBit.N_CURRENT_NUM; |
| | | //} |
| | | var ggf = db.Updateable(od).UpdateColumns(it => new { it.TagOverTime, it.TagOver }).ExecuteCommand(); |
| | | LogHelper.Info($"上提升机任务 更新工单的时间影响行数: {ggf}"); |
| | | |
| | | // var r = new RowLock { S_LOCK_SRC = od.SQL_ItemCode, T_LOCK_TIME = DateTime.Now, S_LOCK_STATE = "出库锁", S_AREA_CODE = StartBit.S_AREA_CODE, N_ROW = StartBit.N_ROW }; |