void Summary_LAND() { IniFile ini = new IniFile(ClassSql.MMS_Path); this.Text = "Landbase Medical Examination Certificate Print-Out"; R_lanabase_Summary1.SetDatabaseLogon(ini.IniReadValue("CONNECTIONSTRING", "Uid"), ini.IniReadValue("CONNECTIONSTRING", "Pwd"), ini.IniReadValue("CONNECTIONSTRING", "Server"), ini.IniReadValue("CONNECTIONSTRING", "Database")); R_lanabase_Summary1.Load(@"C:\Report\R_lanabase_Summary.rpt"); Viewer_Summary.ReportSource = R_lanabase_Summary1; Viewer_Summary.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 = '15'", txt_ForNo, "Form"); //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '15'", txt_RevNo, "Revision"); //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '15'", txt_ISO, "ISO"); TextObject FormNo = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_RevNo"]; TextObject Iso = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_iso"]; FormNo.Text = ini.IniReadValue("FORM", "Landbase_Summary"); RevNo.Text = ini.IniReadValue("REVISION", "Landbase_Summary"); Iso.Text = ini.IniReadValue("ISO", "Landbase_Summary"); //R_lanabase_Summary1.Refresh(); Viewer_Summary.RefreshReport(); RemoveTab(Viewer_Summary); //wizard1.SelectedTab = tabPage9; }
public void Load_Summary() { R_lanabase_Summary1.Load(@"C:\Report\R_lanabase_Summary.rpt"); crystalReportViewer1.ReportSource = R_lanabase_Summary1; crystalReportViewer1.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 = '15'", txt_ForNo, "Form"); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '15'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_RevNo"]; FormNo.Text = txt_ForNo.Text; RevNo.Text = txt_RevNo.Text; // R_lanabase_Summary1.Refresh(); crystalReportViewer1.RefreshReport(); RemoveTab(crystalReportViewer1); wizard1.SelectedTab = tabPage1; }
void Summary_LAND() { this.Text = "Landbase Medical Examination Certificate Print-Out"; R_lanabase_Summary1.Load(@"C:\Report\R_lanabase_Summary.rpt"); crystalReportViewer9.ReportSource = R_lanabase_Summary1; crystalReportViewer9.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 = '15'", txt_ForNo, "Form"); a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '15'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_lanabase_Summary1.ReportDefinition.ReportObjects["txt_RevNo"]; FormNo.Text = txt_ForNo.Text; RevNo.Text = txt_RevNo.Text; //R_lanabase_Summary1.Refresh(); crystalReportViewer9.RefreshReport(); RemoveTab(crystalReportViewer9); //wizard1.SelectedTab = tabPage9; }
private void button8_Click(object sender, EventArgs e) { R_lanabase_Summary1.PrintOptions.PrinterName = Tool.PrinterPath(); R_lanabase_Summary1.PrintToPrinter(1, false, 0, 0); }