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; }
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; }
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; }