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();
}
}
}
