Example #1
0
        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            Summary = false; Detail = true; MER = false; MLC1 = true; MLC2 = false;
            R_SeabaseDetailed1.Load(@"C:\Report\R_SeabaseDetailed.rpt");
            crystalReportViewer3.ReportSource     = R_SeabaseDetailed1;
            crystalReportViewer3.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 = '12'", txt_ForNo, "Form");
            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '12'", txt_RevNo, "Revision");
            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '12'", txt_ISO, "ISO");
            TextObject FormNo = (TextObject)R_SeabaseDetailed1.ReportDefinition.ReportObjects["txt_formNo"];
            TextObject RevNo  = (TextObject)R_SeabaseDetailed1.ReportDefinition.ReportObjects["txt_RevNo"];
            TextObject ISO    = (TextObject)R_SeabaseDetailed1.ReportDefinition.ReportObjects["txt_iso"];

            FormNo.Text = txt_ForNo.Text;
            RevNo.Text  = txt_RevNo.Text;
            ISO.Text    = txt_ISO.Text;

            //R_SeabaseDetailed1.Refresh();
            crystalReportViewer3.RefreshReport();
            RemoveTab(crystalReportViewer3);
            wizard1.SelectedTab = tabPage3;
        }
Example #2
0
        public void Load_mlc()
        {
            //Summary = false; Detail = false; MER = false; MLC1 = true ; MLC2 = false;
            R_Seabase_MLC1.Load(@"C:\Report\R_Seabase_MLC.rpt");
            crystalReportViewer2.ReportSource     = R_Seabase_MLC1;
            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 = '14'", txt_ForNo, "Form");
            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '14'", txt_RevNo, "Revision");
            TextObject FormNo      = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_formNo"];
            TextObject RevNo       = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_RevNo"];
            TextObject CompanyName = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_CompanyName"];
            TextObject CompanyAdd  = (TextObject)R_Seabase_MLC1.ReportDefinition.ReportObjects["txt_CompanyAdd"];

            FormNo.Text      = txt_ForNo.Text;
            RevNo.Text       = txt_RevNo.Text;
            CompanyName.Text = Properties.Settings.Default.CompanyName.ToString();
            CompanyAdd.Text  = Properties.Settings.Default.CompanyAdd.ToString();
            //R_Seabase_MLC1.Refresh();
            crystalReportViewer2.RefreshReport();
            RemoveTab(crystalReportViewer2);
            wizard1.SelectedTab = tabPage2;
        }
Example #3
0
        private void radioButton4_CheckedChanged(object sender, EventArgs e)
        {
            R_Seabase_MER1.Load(@"C:\Report\R_Seabase_MER.rpt");
            crystalReportViewer4.ReportSource     = R_Seabase_MER1;
            crystalReportViewer4.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 = '13'", txt_ForNo, "Form");
            a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '13'", txt_RevNo, "Revision");
            TextObject FormNo = (TextObject)R_Seabase_MER1.ReportDefinition.ReportObjects["txt_formNo"];
            TextObject RevNo  = (TextObject)R_Seabase_MER1.ReportDefinition.ReportObjects["txt_RevNo"];

            FormNo.Text = txt_ForNo.Text;
            RevNo.Text  = txt_RevNo.Text;
            // /R_Seabase_MER1.Refresh();
            crystalReportViewer4.RefreshReport();
            RemoveTab(crystalReportViewer4);

            wizard1.SelectedTab = tabPage4;

            tabControl1.SelectedTab = tabPage5;

            Seabase_MER_Page21.Load(@"C:\Report\Seabase_MER_Page2.rpt");
            crystalReportViewer5.ReportSource     = Seabase_MER_Page21;
            crystalReportViewer5.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'";
            //ClassSql a = new ClassSql();
            //TextBox txt_ForNo2 = new TextBox(); TextBox txt_RevNo2 = new TextBox();
            //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '13'", txt_ForNo, "Form");
            //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '13'", txt_RevNo, "Revision");
            //TextObject FormNo2 = (TextObject)Seabase_MER_Page21.ReportDefinition.ReportObjects["txt_formNo"];
            //TextObject RevNo2 = (TextObject)Seabase_MER_Page21.ReportDefinition.ReportObjects["txt_RevNo"];
            //FormNo2.Text = txt_ForNo2.Text;
            //RevNo2.Text = txt_RevNo2.Text;

            // /R_Seabase_MER1.Refresh();
            crystalReportViewer5.RefreshReport();
            RemoveTab(crystalReportViewer5);
            // wizard1.SelectedTab = tabPage4;
        }