Esempio n. 1
0
        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);
        }
Esempio n. 2
0
        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);
            }
        }