Exemplo n.º 1
0
 /// <summary>
 /// 界面数据提取
 /// </summary>
 public RefreshData getdatas(int port, int untotal)
 {
     RefreshData refreshData = new RefreshData();
     DataTable currentDt = ledShowBll.getRegistrationInfos("where workstate='2' and port='" + port + "'");
     DataTable waitCars = ledShowBll.getRegistrationInfos("where workstate='1' and port='" + port + "'");
     refreshData.AllWaitCas = ledShowBll.getRegistrationInfos("where workstate<'2'").Rows.Count;
     if (currentDt.Rows.Count > 0)
     {
         refreshData.Total = int.Parse(currentDt.Rows[0]["quantity"].ToString());
         refreshData.Untotal = untotal;
         refreshData.CurrentCarcode = currentDt.Rows[0]["carcode"].ToString();
     }
     else
     {
         refreshData.Total = 0;
         refreshData.Untotal = 0;
         refreshData.CurrentCarcode = "无";
     }
     if (waitCars.Rows.Count > 0)
     {
         refreshData.WaitCarcode = waitCars.Rows[0]["carcode"].ToString();
     }
     else
     {
         refreshData.WaitCarcode = "暂无任务!";
     }
     refreshData.UnWorktotalCars = waitCars.Rows.Count;
     return refreshData;
 }
Exemplo n.º 2
0
        private void Run()
        {
            try
            {
                //lblTimeTxt.Text = DateTime.Now.ToString("yyyy年MM月dd日hh时mm分");
                lblTimeTxt.Text = DateTime.Now.ToString();
                using (PersistentManager pm = new PersistentManager("DefaultConnection"))
                {

                    TimeDao timeshow = new TimeDao();
                    timeshow.SetPersistentManager(pm);
                    //一号
                    string sortNo = Convert.ToString("one");

                    DataTable infoTable = timeshow.FindSortTime(sortNo);
                    RefreshAgv refreshAgv = new RefreshAgv();
                    int nu = 0;
                    RefreshData2 re = new RefreshData2();
                    if (infoTable.Rows.Count > 1)
                    {
                        nu = Convert.ToInt32(infoTable.Rows[0]["Times"]);

                        double a = nu * 0.0 / 3600;
                        re.CompleteQuantity2 = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]) / Convert.ToInt32(a);
                    }
                    else
                    {
                        re.CompleteQuantity2 = 0;
                    }

                }

                using (PersistentManager pm = new PersistentManager("DefaultConnection2"))
                {
                    LedShowDao ledShowDao = new LedShowDao();
                    ledShowDao.SetPersistentManager(pm);
                    string sortNo = Convert.ToString("all");

                    DataTable infoTable = ledShowDao.FindOrderInfo(sortNo);
                    RefreshData refreshData = new RefreshData();
                    refreshData.TotalCustomer = Convert.ToInt32(infoTable.Rows[0]["CUSTOMERNUM"]);
                    refreshData.TotalRoute = Convert.ToInt32(infoTable.Rows[0]["ROUTENUM"]);
                    refreshData.TotalQuantity = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]);

                    //已分拣
                    infoTable = ledShowDao.FindOrderInfo("");
                    refreshData.CompleteCustomer = Convert.ToInt32(infoTable.Rows[0]["CUSTOMERNUM"]);
                    refreshData.CompleteRoute = Convert.ToInt32(infoTable.Rows[0]["ROUTENUM"]);
                    refreshData.CompleteQuantity = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]);

                    if (refreshData.CompleteQuantity >= 1)
                    {
                        refreshData.Average = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]) / ledShowDao.FindSortingAverage();
                    }
                    else
                    {
                        refreshData.Average = 0;
                    }
                    if (ledShowDao.FindCurrentRoute().Rows.Count != 0)
                    {
                        refreshData.RouteName = ledShowDao.FindCurrentRoute().Rows[0]["ROUTENAME"].ToString();
                    }
                    else
                    {
                        refreshData.RouteName = "";
                    }

                    refreshData.Batch = Convert.ToDateTime(ledShowDao.FindOrderdate().Rows[0]["ORDERDATE"]).ToString("yyyy-MM-dd") + "批次:" + ledShowDao.FindOrderdate().Rows[0]["BATCHNO"].ToString();
                    Refresh(refreshData);
                }
                using (PersistentManager pm = new PersistentManager("DefaultConnection3"))
                {

                    LedShowDao ledShowDao = new LedShowDao();
                    ledShowDao.SetPersistentManager(pm);
                    string sortNo = Convert.ToString("all"); ;

                    DataTable infoTable = ledShowDao.FindOrderInfo(sortNo);
                    RefreshData2 refreshData2 = new RefreshData2();
                    refreshData2.TotalCustomer2 = Convert.ToInt32(infoTable.Rows[0]["CUSTOMERNUM"]);
                    refreshData2.TotalRoute2 = Convert.ToInt32(infoTable.Rows[0]["ROUTENUM"]);
                    refreshData2.TotalQuantity2 = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]);

                    infoTable = ledShowDao.FindOrderInfo("");
                    refreshData2.CompleteCustomer2 = Convert.ToInt32(infoTable.Rows[0]["CUSTOMERNUM"]);
                    refreshData2.CompleteRoute2 = Convert.ToInt32(infoTable.Rows[0]["ROUTENUM"]);
                    refreshData2.CompleteQuantity2 = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]);
                    if (refreshData2.CompleteQuantity2 >= 1)
                    {
                        refreshData2.Average2 = Convert.ToInt32(infoTable.Rows[0]["QUANTITY"]) / ledShowDao.FindSortingAverage();
                    }
                    else
                    {
                        refreshData2.Average2 = 0;
                    }
                    if (ledShowDao.FindCurrentRoute().Rows.Count != 0)
                    {
                        refreshData2.RouteName2 = ledShowDao.FindCurrentRoute().Rows[0]["ROUTENAME"].ToString();
                    }
                    else
                    {
                        refreshData2.RouteName2 = "";
                    }
                    refreshData2.Batch2 = Convert.ToDateTime(ledShowDao.FindOrderdate().Rows[0]["ORDERDATE"]).ToString("yyyy-MM-dd") + "批次:" + ledShowDao.FindOrderdate().Rows[0]["BATCHNO"].ToString();
                    Refresh2(refreshData2);

                }

            }
            catch (Exception ex)
            {
                MessageBox.Show("无法连接数据库");

            }
        }
Exemplo n.º 3
0
        private void Refresh(RefreshData refreshData)
        {
            lblCompleteRoute.Text = refreshData.CompleteRoute.ToString();
            lblCompleteCustomer.Text = refreshData.CompleteCustomer.ToString();
            lblCompleteQuantity.Text = refreshData.CompleteQuantity.ToString();
            lblTotalRoute.Text = refreshData.TotalRoute.ToString();
            lblTotalCustomer.Text = refreshData.TotalCustomer.ToString();
            lblTotalQuantity.Text = refreshData.TotalQuantity.ToString();
            lblRoute.Text = (refreshData.TotalRoute - refreshData.CompleteRoute).ToString();
            lblCustomer.Text = (refreshData.TotalCustomer - refreshData.CompleteCustomer).ToString();
            lblQuantity.Text = (refreshData.TotalQuantity - refreshData.CompleteQuantity).ToString();

            lblAverageSpeed.Text = refreshData.Average.ToString();
            lblCurrentRouteTxt.Text = refreshData.RouteName.ToString();

            PbarBatch.Value = (int)(Convert.ToDouble(refreshData.CompleteQuantity) / refreshData.TotalQuantity * 100);
            lblBatchValue.Text = PbarBatch.Value.ToString() + "%";
        }