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; }
void Detailed_SEA() { this.Text = "Seafarer's Medical Examination Certificate Print-Out"; IniFile ini = new IniFile(ClassSql.MMS_Path); R_SeabaseDetailed1.SetDatabaseLogon(ini.IniReadValue("CONNECTIONSTRING", "Uid"), ini.IniReadValue("CONNECTIONSTRING", "Pwd"), ini.IniReadValue("CONNECTIONSTRING", "Server"), ini.IniReadValue("CONNECTIONSTRING", "Database")); R_SeabaseDetailed1.Load(@"C:\Report\R_SeabaseDetailed.rpt"); Viewer_Detailed_Sea.ReportSource = R_SeabaseDetailed1; Viewer_Detailed_Sea.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 = ini.IniReadValue("FORM", "Seafarer_Detailed"); RevNo.Text = ini.IniReadValue("REVISION", "Seafarer_Detailed"); ISO.Text = ini.IniReadValue("ISO", "Seafarer_Detailed"); //R_SeabaseDetailed1.Refresh(); Viewer_Detailed_Sea.RefreshReport(); RemoveTab(Viewer_Detailed_Sea); // wizard1.SelectedTab = tabPage8; }
void Detailed_SEA() { this.Text = "Seafarer's Medical Examination Certificate Print-Out"; R_SeabaseDetailed1.Load(@"C:\Report\R_SeabaseDetailed.rpt"); crystalReportViewer8.ReportSource = R_SeabaseDetailed1; crystalReportViewer8.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 = '12'", txt_ForNo, "Form"); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '12'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_SeabaseDetailed1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_SeabaseDetailed1.ReportDefinition.ReportObjects["txt_RevNo"]; FormNo.Text = txt_ForNo.Text; RevNo.Text = txt_RevNo.Text; //R_SeabaseDetailed1.Refresh(); crystalReportViewer8.RefreshReport(); RemoveTab(crystalReportViewer8); // wizard1.SelectedTab = tabPage8; }
private void button7_Click(object sender, EventArgs e) { R_SeabaseDetailed1.PrintOptions.PrinterName = Tool.PrinterPath(); R_SeabaseDetailed1.PrintToPrinter(1, false, 0, 0); }