public static void UpdateEfficincy() { DateTime?starttime = null; double second = 0; double passt = 0; double pnum = 0; double totolnum = 0; int ordernum = 0; try { List <PrintInfo> printinfos = PrintBarCodes.GetAVGPrintEffice(); List <PrintInfo> cutprintinfos = PrintBarCodes.GetCUTPrintEffice(); //Dictionary<string, double> effice = new Dictionary<string, double>(); foreach (PrintInfo printinfo in printinfos) { if (starttime == null) { pnum = printinfo.allnum; starttime = printinfo.starttime; } else { second = Convert.ToDouble(ExecDateDiff(Convert.ToDateTime(starttime), printinfo.starttime)); if (second < AppUtility.AppUtil._IgnoreSecond) { totolnum += pnum; passt += second; ordernum++; } pnum = printinfo.allnum; starttime = printinfo.starttime; } } double efficincy = Math.Round((Math.Round((totolnum / passt), 9) * 3600), 0); using (var cn = new MySqlConnection(AppUtility.AppUtil._LocalConnectionString)) { cn.Open(); using (var cm = cn.CreateCommand()) { cm.CommandText = "UPDATE t_sortline_process set EFFICIENCY = " + efficincy + " WHERE ORDERDATE = '" + SortingLineTask.GetSortingLineTaskDate() + "' AND PICKLINECODE = '" + SortingLine.GetSortingLineCode() + "' AND SORTINGTASKNO = '" + SortingLineTask.GetMinSortingLineTask().SORTINGTASKNO + "'"; cm.ExecuteNonQuery(); } } double maxavgeffic = 0; double maxcuteffic = 0; using (var cn = new MySqlConnection(AppUtility.AppUtil._LocalConnectionString)) { cn.Open(); using (var cm = cn.CreateCommand()) { cm.CommandText = "select MaxavgEFFICIENCY from t_sortline_process WHERE ORDERDATE = '" + SortingLineTask.GetSortingLineTaskDate() + "' AND PICKLINECODE = '" + SortingLine.GetSortingLineCode() + "' AND SORTINGTASKNO = '" + SortingLineTask.GetMinSortingLineTask().SORTINGTASKNO + "'"; using (var dr = new SafeDataReader(cm.ExecuteReader())) { while (dr.Read()) { maxavgeffic = dr.GetDouble("MaxavgEFFICIENCY"); } } } } if (efficincy > maxavgeffic) { using (var cn = new MySqlConnection(AppUtility.AppUtil._LocalConnectionString)) { cn.Open(); using (var cm = cn.CreateCommand()) { cm.CommandText = "UPDATE t_sortline_process set MaxavgEFFICIENCY = " + efficincy + ",MaxavgEFFICIENCYTime = '" + DateTime.Now + "' WHERE ORDERDATE = '" + SortingLineTask.GetSortingLineTaskDate() + "' AND PICKLINECODE = '" + SortingLine.GetSortingLineCode() + "' AND SORTINGTASKNO = '" + SortingLineTask.GetMinSortingLineTask().SORTINGTASKNO + "'"; cm.ExecuteNonQuery(); } } } starttime = null; second = 0; passt = 0; pnum = 0; totolnum = 0; ordernum = 0; foreach (PrintInfo printinfo in cutprintinfos) { if (starttime == null) { pnum = printinfo.allnum; starttime = printinfo.starttime; } else { second = Convert.ToDouble(ExecDateDiff(Convert.ToDateTime(starttime), printinfo.starttime)); if (second < AppUtility.AppUtil._IgnoreSecond) { totolnum += pnum; passt += second; ordernum++; } pnum = printinfo.allnum; starttime = printinfo.starttime; } } efficincy = Math.Round((Math.Round((totolnum / passt), 9) * 3600), 0); using (var cn = new MySqlConnection(AppUtility.AppUtil._LocalConnectionString)) { cn.Open(); using (var cm = cn.CreateCommand()) { cm.CommandText = "select MaxcutEFFICIENCY from t_sortline_process WHERE ORDERDATE = '" + SortingLineTask.GetSortingLineTaskDate() + "' AND PICKLINECODE = '" + SortingLine.GetSortingLineCode() + "' AND SORTINGTASKNO = '" + SortingLineTask.GetMinSortingLineTask().SORTINGTASKNO + "'"; using (var dr = new SafeDataReader(cm.ExecuteReader())) { while (dr.Read()) { maxcuteffic = dr.GetDouble("MaxcutEFFICIENCY"); } } } } if (efficincy > maxcuteffic) { using (var cn = new MySqlConnection(AppUtility.AppUtil._LocalConnectionString)) { cn.Open(); using (var cm = cn.CreateCommand()) { cm.CommandText = "UPDATE t_sortline_process set MaxcutEFFICIENCY = " + efficincy + ",MaxcutEFFICIENCYTime = '" + DateTime.Now + "' WHERE ORDERDATE = '" + SortingLineTask.GetSortingLineTaskDate() + "' AND PICKLINECODE = '" + SortingLine.GetSortingLineCode() + "' AND SORTINGTASKNO = '" + SortingLineTask.GetMinSortingLineTask().SORTINGTASKNO + "'"; cm.ExecuteNonQuery(); } } } } catch { } }
private void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e) { try { //获取当前,上一个,下一个客户的基本信息 GetOutPortInfo(); GetPOutPortInfo(); GetNOutPortInfo(); //获取平均效率的列表(当天所有打完码的客户) List <PrintInfo> printinfos = PrintBarCodes.GetAVGPrintEffice(); //获取当前效率的列表(现在系统所有打完码的客户) List <PrintInfo> cutprintinfos = PrintBarCodes.GetCUTPrintEffice(); //计算当前效率 double tzeff = SetEff(cutprintinfos); labavgeffice.Text = tzeff.ToString() + "条/小时"; if (labavgeffice.Text.Contains("非数字")) { labavgeffice.Text = "0" + "条/小时"; } using (var cn = new MySqlConnection(AppUtility.AppUtil._LocalConnectionString)) { cn.Open(); using (var cm = cn.CreateCommand()) { cm.CommandText = "select MaxcutEFFICIENCY from t_sortline_process WHERE ORDERDATE = '" + SortingLineTask.GetSortingLineTaskDate() + "' AND PICKLINECODE = '" + SortingLine.GetSortingLineCode() + "' AND SORTINGTASKNO = '" + SortingLineTask.GetMinSortingLineTask().SORTINGTASKNO + "'"; using (var dr = new SafeDataReader(cm.ExecuteReader())) { while (dr.Read()) { labcuteffice.Text = dr.GetDouble("MaxcutEFFICIENCY").ToString() + "条/小时"; } } } } //计算平均效率 //tzeff = SetEff(printinfos); //labavgeffice.Text = tzeff.ToString() + "条/小时";; //if (labavgeffice.Text.Contains("非数字")) // labavgeffice.Text = "0" + "条/小时"; //计算分拣进度 SortingProgress sortingprogress = SortingProgress.GetSortingTaskProgress(); prosorting.Maximum = sortingprogress.TotQty; prosorting.Value = sortingprogress.Qty; prosorting.Text = (sortingprogress.Qty + "/" + sortingprogress.TotQty).PadRight(15, ' ') + Math.Round( Convert.ToDouble(sortingprogress.Qty) / Convert.ToDouble(sortingprogress.TotQty), 3) * 100 + "%"; } catch { } }
/// <summary> /// 分拣任务下达流程 /// </summary> private void ScanTask() { SortingLineTask sortingLineTask = null; while (taskStatus == TaskStatus.Run) { try { //是否有未完成的订单 if (!SortingLineTaskList.IsSortingFinish()) { //判断标识是否可以下达任务,表示上一次任务是否已经完成 SortingTaskIssued sortingTaskIssued = SortingTaskIssued.GetSortingTaskIssued("0"); if (sortingTaskIssued.PLCFLAG == 0) { //PLC信息小车是否走到位,或者已扫描到分户盒 //分拣工可能先放分户盒,但程序必须判断上次任务是否完成 //if (operateOpcAndSoft.GetCubeReady()) //{ // if(operateOpcAndSoft.GetCubeIndexno > FJMainForm.Instance.CSortingMain.c_Cubes.Last().labindexno) // int a = operateOpcAndSoft.GetCubeReady() - // FJMainForm.Instance.CSortingMain.c_Cubes.Last().labindexno; //} if (operateOpcAndSoft.GetCubeReady()) { SortingLineTaskQueue.GetInstance().Move(); //重新加载一次任务队列 SortingLineTaskQueue.GetInstance().LoadSortingLineTasks(); //获取最小排序号的订单 sortingLineTask = SortingLineTask.GetMinSortingLineTask(); //将最小订单放入队列中进行分拣 SortingLineTaskQueue.GetInstance().Enqueue(sortingLineTask); SortingLineTaskQueue.GetInstance().CreateCubesModel(); //发送卷烟数量到数码管 ATOPTagSdk.instance.SetOrderNixielight(SortingLineTaskQueue.GetInstance().SortingLineTasks); //通知前台界面显示数码管数量 if (OnUpdateCSortingMainNumEvent != null) { OnUpdateCSortingMainNumEvent.Invoke(null, new UpdateCSortingMainNumEventArgs(ATOPTagSdk.Tags)); } //如果不是用用来补足的空任务 if (sortingLineTask.INDEXNO > 0) { //保存任务状态为已下达 sortingLineTask.Status = 1; sortingLineTask.SaveSortingTaskProcess(sortingLineTask.ID); } //将下达任务标志位设置成已下达 sortingTaskIssued.PLCFLAG = 1; sortingTaskIssued.PLCTASKNO = sortingLineTask.INDEXNO.ToString(); sortingTaskIssued.ORDERNUMBER = sortingLineTask.SumOrderNumber(); sortingTaskIssued.Save(); //写日志 monitorLog = MonitorLog.NewMonitorLog(); monitorLog.LOGNAME = "任务下达"; monitorLog.LOGINFO = " 任务号:" + sortingLineTask.INDEXNO.ToString().PadRight(10); monitorLog.LOGLOCATION = "数据库"; monitorLog.LOGTYPE = 0; monitorLog.Save(); this.BeginInvoke(new MethodInvoker(LoadOrder)); //FJMainForm.Instance.CSortingMain.UpdateLineboxCapacity(); } } } else { //写日志 MonitorLog monitorLog = MonitorLog.NewMonitorLog(); monitorLog.LOGNAME = "任务下达"; monitorLog.LOGINFO = "分拣任务全部完成"; monitorLog.LOGLOCATION = "数据库"; monitorLog.LOGTYPE = 0; monitorLog.Save(); //发送分拣完成到上位机 //FJMainForm.Instance.SortingFinish(); SortingLineTaskQueue.GetInstance().CubesModel.Clear(); Array.Clear(SortingLineTaskQueue.GetInstance().SortingLineTasks, 0, SortingLineTaskQueue.GetInstance().QueueMaxCount); SortingLineTaskQueue.GetInstance().InvokeOnUpdateCubeEvent(); SoundPlayer player = new SoundPlayer(); player.SoundLocation = Application.StartupPath + "\\Sound\\分拣结束.wav"; player.Load(); player.Play(); break;//跳出下达循环 } Thread.Sleep(500); } catch (Exception e) { //写日志 monitorLog = MonitorLog.NewMonitorLog(); if (sortingLineTask != null) { monitorLog.LOGNAME = "任务号" + sortingLineTask.INDEXNO + " 分拣任务下达异常"; } else { monitorLog.LOGNAME = "任务号未知" + " 分拣任务下达异常"; } monitorLog.LOGINFO = e.Message; monitorLog.LOGLOCATION = "数据库"; monitorLog.LOGTYPE = 0; monitorLog.Save(); } } }