private bool LoadReportDelivery() { bool vRet = false; Thread.Sleep(2000); //if (CheckPrinterOnline(out_PrinterName)) //{ string strSQL = "select t.*" + " from rpt.VIEW_DELIV_HEADER t " + //VIEW_DATA_WEIGHT " where t.LOAD_HEADER_NO=" + LoadHeader_NO; DataSet vDataset = null; DataTable dt; try { if (fMain.OraDb.OpenDyns(strSQL, "VIEW_DELIV_HEADER", ref vDataset)) { dt = vDataset.Tables["VIEW_DELIV_HEADER"]; if (dt != null && dt.Rows.Count != 0) { ReportDocument cr = new ReportDocument(); string reportPath = fMain.App_Path + "\\Report File\\" + out_ReportPath; RaiseEvents(reportPath); if (!File.Exists(reportPath)) { fMain.AddListBox = "The specified report does not exist."; } Application.DoEvents(); cr.Load(reportPath); cr.Database.Tables["VIEW_DELIV_HEADER"].SetDataSource((DataTable)dt); cr.SetDatabaseLogon("tas", "tam"); //cr.SetDataSource((DataTable)dt); cr.SetParameterValue(out_Parametername, LoadHeader_NO); cr.PrintOptions.PrinterName = out_PrinterName; cr.PrintToPrinter(1, false, 0, 0); cr.Dispose(); RaiseEvents("Print Report Loading NO " + LoadHeader_NO); RaiseEvents(reportPath); vRet = true; } } Thread.Sleep(2000); } catch (Exception exp) { RaiseEvents("[Print Loading, Load data report] " + exp.Message); PrintStepProcess = _PrintStepProcess.InitialReport; } vDataset = null; dt = null; // } return(vRet); }
private void RunProcess() { thrRunning = true; thrShutdown = false; PrintStepProcess = _PrintStepProcess.InitialReport; chkResponse = DateTime.Now; // APP_PATH(); while (thrRunning) { try { if (thrShutdown) { return; } switch (PrintStepProcess) { case _PrintStepProcess.InitialReport: if (GetConfigReport()) { PrintStepProcess = _PrintStepProcess.CheckStatusReport; } break; case _PrintStepProcess.CheckStatusReport: if (CheckStatusReport()) { PrintStepProcess = _PrintStepProcess.LoadReport; // } break; case _PrintStepProcess.LoadReport: if (LoadReportDelivery()) { UpdateToDatabase(LoadHeader_NO); PrintStepProcess = _PrintStepProcess.ChangeProcess; } else { PrintStepProcess = _PrintStepProcess.CheckStatusReport; } break; case _PrintStepProcess.ChangeProcess: PrintStepProcess = _PrintStepProcess.CheckStatusReport; break; } Thread.Sleep(1000); } catch (Exception exp) { RaiseEvents(exp.Message + "[source>" + exp.Source + "]"); Thread.Sleep(3000); } //finally //{ // mShutdown = true; // mRunning = false; //} Thread.Sleep(500); } }