private void GetDataSet() { try { using (PersistentManager pmServer = new PersistentManager("ServerConnection")) { ServerDao serverDao = new ServerDao(); serverDao.SetPersistentManager(pmServer); channelReport = new SortChannelReport(); DataTable printBatchTable = serverDao.FindPrintBatchTable(); PrintSelectDialog printSelectDialog = new PrintSelectDialog(printBatchTable); if (printSelectDialog.ShowDialog() == DialogResult.OK) { string orderDate = ""; string batchNo = ""; string lineCode = ""; orderDate = printSelectDialog.SelectedPrintBatch.Split("|"[0])[0]; batchNo = printSelectDialog.SelectedPrintBatch.Split("|"[0])[1]; lineCode = printSelectDialog.SelectedPrintBatch.Split("|"[0])[2]; DataTable table = serverDao.FindChannelUSED(orderDate, batchNo, lineCode); if (table.Rows.Count == 0) { throw new Exception("没有数据"); } channelReport.SetDataSource(table); SetReportToCrv(channelReport); } } } catch (Exception ex) { SetLblInfo(ex.Message); } finally { //t.Abort(); } }
/// <summary> /// 下载数据 最后修改日期 2010-10-30 /// </summary> private void DownloadData() { try { using (PersistentManager pm = new PersistentManager()) { ChannelDao channelDao = new ChannelDao(); StockOutBatchDao stockOutBatchDao = new StockOutBatchDao(); StockInBatchDao stockInBatchDao = new StockInBatchDao(); StockOutDao stockOutDao = new StockOutDao(); StockInDao stockInDao = new StockInDao(); SupplyDao supplyDao = new SupplyDao(); if (supplyDao.FindCount() != stockOutDao.FindOutQuantity()) { if (DialogResult.Cancel == MessageBox.Show("还有未处理的数据,您确定要重新下载数据吗?", "询问", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)) { return; } } using (PersistentManager pmServer = new PersistentManager("ServerConnection")) { ServerDao serverDao = new ServerDao(); serverDao.SetPersistentManager(pmServer); //ORDER BY ORDERDATE,BATCHNO 查找第一批次(符合已优化,并已上传一号工程,未下载的批次) DataTable table = serverDao.FindBatch(); if (table.Rows.Count != 0) { using (PersistentManager pmWES = new PersistentManager("WESConnection")) { StockInBatchDao stockInBatchDaoWES = new StockInBatchDao(); stockInBatchDaoWES.SetPersistentManager(pmWES); stockInBatchDaoWES.Delete(); } string batchID = table.Rows[0]["BATCHID"].ToString(); string orderDate = table.Rows[0]["ORDERDATE"].ToString(); string batchNo = table.Rows[0]["BATCHNO"].ToString(); Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState("清空作业表", 5, 1)); channelDao.Delete(); stockOutBatchDao.Delete(); stockOutDao.Delete(); stockInBatchDao.Delete(); stockInDao.Delete(); supplyDao.Delete(); System.Threading.Thread.Sleep(100); Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState("下载补货烟道表", 5, 2)); table = serverDao.FindStockChannel(orderDate, batchNo); channelDao.InsertChannel(table); System.Threading.Thread.Sleep(100); Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState("下载补货混合烟道表", 5, 3)); table = serverDao.FindMixChannel(orderDate, batchNo); channelDao.InsertMixChannel(table); System.Threading.Thread.Sleep(100); Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState("下载分拣烟道表", 5, 4)); table = serverDao.FindChannelUSED(orderDate, batchNo); channelDao.InsertChannelUSED(table); System.Threading.Thread.Sleep(100); Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState("下载补货计划表", 5, 5)); table = serverDao.FindSupply(orderDate, batchNo); supplyDao.Insert(table); System.Threading.Thread.Sleep(100); serverDao.UpdateBatchStatus(batchID); Context.ProcessDispatcher.WriteToProcess("monitorView", "ProgressState", new ProgressState()); Logger.Info("数据下载完成"); //初始化PLC数据(叠垛线PLC,补货线PLC) Context.ProcessDispatcher.WriteToService("StockPLC_01", "RestartData", 3); Context.ProcessDispatcher.WriteToService("StockPLC_02", "RestartData", 1); //初始化入库扫码器 Context.ProcessDispatcher.WriteToProcess("ScanProcess", "Init", null); //初始化状态管理器 Context.ProcessDispatcher.WriteToProcess("LedStateProcess", "Init", null); Context.ProcessDispatcher.WriteToProcess("OrderDataStateProcess", "Init", null); Context.ProcessDispatcher.WriteToProcess("ScannerStateProcess", "Init", null); //生成入库请求任务数据 Context.ProcessDispatcher.WriteToProcess("StockInRequestProcess", "FirstBatch", null); //生成补货请求任务数据 //Context.ProcessDispatcher.WriteToProcess("SupplyFirstRequestProcess", "FirstBatch", null); } else { MessageBox.Show("没有补货计划数据!", "消息", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } catch (Exception e) { Logger.Error("数据下载处理失败,原因:" + e.Message); } }