void MLC_LAND()
        {
            this.Text = "Landbase Medical Examination Certificate Print-Out";
            IniFile ini = new IniFile(ClassSql.MMS_Path);

            R_landbaseMLC1.SetDatabaseLogon(ini.IniReadValue("CONNECTIONSTRING", "Uid"), ini.IniReadValue("CONNECTIONSTRING", "Pwd"), ini.IniReadValue("CONNECTIONSTRING", "Server"), ini.IniReadValue("CONNECTIONSTRING", "Database"));

            R_landbaseMLC1.Load(@"C:\Report\R_landbaseMLC.rpt");
            VIEWER_LAND_MLC.ReportSource     = R_landbaseMLC1;
            VIEWER_LAND_MLC.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'";

            //ClassSql a = new ClassSql();
            //TextBox txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox(); TextBox txt_ISO = new TextBox();
            //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_ForNo, "Form");
            //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_RevNo, "Revision");
            //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_ISO, "ISO");

            TextObject FormNo = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_formNo"];
            TextObject RevNo  = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_RevNo"];
            TextObject Iso    = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_iso"];

            FormNo.Text = ini.IniReadValue("FORM", "Landbase_MLC");
            RevNo.Text  = ini.IniReadValue("REVISION", "Landbase_MLC");
            Iso.Text    = ini.IniReadValue("ISO", "Landbase_MLC");
            //R_landbaseMLC1.Refresh();
            VIEWER_LAND_MLC.RefreshReport();
            RemoveTab(VIEWER_LAND_MLC);
            // wizard1.SelectedTab = tabPage13;
        }
Example #2
0
        void Load_MLC()
        {
            R_landbaseMLC1.Load(@"C:\Report\R_landbaseMLC.rpt");
            crystalReportViewer2.ReportSource     = R_landbaseMLC1;
            crystalReportViewer2.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'";

            ClassSql a = new ClassSql();
            TextBox  txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox();

            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_ForNo, "Form");
            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_RevNo, "Revision");
            TextObject FormNo = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_formNo"];
            TextObject RevNo  = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_RevNo"];

            FormNo.Text = txt_ForNo.Text;
            RevNo.Text  = txt_RevNo.Text;
            // R_landbaseMLC1.Refresh();
            crystalReportViewer2.RefreshReport();
            RemoveTab(crystalReportViewer2);
        }
Example #3
0
        void MLC_LAND()
        {
            this.Text = "Landbase Medical Examination Certificate Print-Out";
            R_landbaseMLC1.Load(@"C:\Report\R_landbaseMLC.rpt");
            crystalReportViewer13.ReportSource     = R_landbaseMLC1;
            crystalReportViewer13.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'";

            ClassSql a = new ClassSql();
            TextBox  txt_ForNo = new TextBox(); TextBox txt_RevNo = new TextBox();

            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_ForNo, "Form");
            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '18'", txt_RevNo, "Revision");
            TextObject FormNo = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_formNo"];
            TextObject RevNo  = (TextObject)R_landbaseMLC1.ReportDefinition.ReportObjects["txt_RevNo"];

            FormNo.Text = txt_ForNo.Text;
            RevNo.Text  = txt_RevNo.Text;
            //R_landbaseMLC1.Refresh();
            crystalReportViewer13.RefreshReport();
            RemoveTab(crystalReportViewer13);
            // wizard1.SelectedTab = tabPage13;
        }
Example #4
0
 private void button11_Click(object sender, EventArgs e)
 {
     R_landbaseMLC1.PrintOptions.PrinterName = Tool.PrinterPath();
     R_landbaseMLC1.PrintToPrinter(1, false, 0, 0);
 }