private bool LoadReportWeight() { bool vRet = false; Thread.Sleep(2000); PrintGovProjectAttach(); //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); PrintStepProcessWeight = _PrintStepProcessWeight.InitialReport; } vDataset = null; dt = null; // } return(vRet); }
private void PrintGovProjectAttach()//ปริ้นเอกสารแแนบกรมทาง { DataSet DatasetGov = null; DataTable dtGov; string vCheck; //Thread.Sleep(1000); string strSQLGov = "select t.*" + " from RPT.DAILY_LOADING_DETAIL t " + " where t.LOAD_HEADER_NO=" + LoadHeader_NO; if (fMain.OraDb.OpenDyns(strSQLGov, "table_name", ref DatasetGov)) { dtGov = DatasetGov.Tables["table_name"]; vCheck = dtGov.Rows[0]["GOV_PROJECT"].ToString(); if (vCheck.Equals("1")) { //if (CheckPrinterOnline(out_PrinterNameGovProject)) ////{ string strSQL = "select t.*" + " from rpt.VIEW_GOV_PROJECT_ATTACHAS t " + " where t.LOAD_HEADER_NO=" + LoadHeader_NO; DataSet vDataset = null; DataTable dt; try { if (fMain.OraDb.OpenDyns(strSQL, "VIEW_GOV_PROJECT_ATTACHAS", ref vDataset)) { dt = vDataset.Tables["VIEW_GOV_PROJECT_ATTACHAS"]; if (dt != null && dt.Rows.Count != 0) { ReportDocument cr = new ReportDocument(); string reportPath = fMain.App_Path + "\\Report File\\" + out_ReportPathGovProject; RaiseEvents(reportPath); if (!File.Exists(reportPath)) { fMain.AddListBox = "The specified report does not exist."; } Application.DoEvents(); cr.Load(reportPath); cr.Database.Tables["VIEW_GOV_PROJECT_ATTACHAS"].SetDataSource((DataTable)dt); cr.SetDatabaseLogon("tas", "tam"); cr.SetParameterValue(out_ParameternameGovProject, LoadHeader_NO); cr.PrintOptions.PrinterName = out_PrinterNameGovProject; cr.PrintToPrinter(1, false, 0, 0); cr.Dispose(); RaiseEvents("Print เอกสารแนบกรมทาง " + LoadHeader_NO); RaiseEvents(reportPath); } } Thread.Sleep(2000); } catch (Exception exp) { RaiseEvents("[Print เอกสารแนบกรมทาง] " + exp.Message); PrintStepProcessWeight = _PrintStepProcessWeight.InitialReport; } vDataset = null; dt = null; //} } } }
private void RunProcess() { thrRunning = true; thrShutdown = false; PrintStepProcessWeight = _PrintStepProcessWeight.InitialReport; chkResponse = DateTime.Now; while (thrRunning) { try { if (thrShutdown) { return; } switch (PrintStepProcessWeight) { case _PrintStepProcessWeight.InitialReport: if (GetConfigReport()) { GetConfigReporGovProjectAttach(); PrintStepProcessWeight = _PrintStepProcessWeight.CheckStatusReport; } break; case _PrintStepProcessWeight.CheckStatusReport: //if (CheckPrinterOnline(out_PrinterName)) if (CheckStatusReport()) { PrintStepProcessWeight = _PrintStepProcessWeight.LoadReport; //connect via Kepware OPC Server } break; case _PrintStepProcessWeight.LoadReport: if (LoadReportWeight()) { //PrintGovProjectAttach(); UpdateToDatabase(LoadHeader_NO); PrintStepProcessWeight = _PrintStepProcessWeight.ChangeProcess; } else { PrintStepProcessWeight = _PrintStepProcessWeight.CheckStatusReport; } break; //case _PrintStepProcessWeight.UpdateStatus: // UpdateToDatabase(LoadHeader_NO); // break; case _PrintStepProcessWeight.ChangeProcess: PrintStepProcessWeight = _PrintStepProcessWeight.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); } }