void Detailed_LAND()
{
this.Text = "Landbase Medical Examination Certificate Print-Out";
IniFile ini = new IniFile(ClassSql.MMS_Path);
R_Landbase_Detailed1.SetDatabaseLogon(ini.IniReadValue("CONNECTIONSTRING", "Uid"), ini.IniReadValue("CONNECTIONSTRING", "Pwd"), ini.IniReadValue("CONNECTIONSTRING", "Server"), ini.IniReadValue("CONNECTIONSTRING", "Database"));
R_Landbase_Detailed1.Load(@"C:\Report\R_Landbase_Detailed.rpt");
Viewer_land_detailed.ReportSource = R_Landbase_Detailed1;
Viewer_land_detailed.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 = '16'", txt_ForNo, "Form");
//a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '16'", txt_RevNo, "Revision");
//a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '16'", txt_ISO, "ISO");
TextObject FormNo = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_formNo"];
TextObject RevNo = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_RevNo"];
TextObject Iso = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_iso"];
FormNo.Text = ini.IniReadValue("FORM", "Landbase_Detailed");
RevNo.Text = ini.IniReadValue("REVISION", "Landbase_Detailed");
Iso.Text = ini.IniReadValue("ISO", "Landbase_Detailed");
//R_Landbase_Detailed1.Refresh();
Viewer_land_detailed.RefreshReport();
RemoveTab(Viewer_land_detailed);
// wizard1.SelectedTab = tabPage12;
}
void Detailed_LAND()
{
this.Text = "Landbase Medical Examination Certificate Print-Out";
R_Landbase_Detailed1.Load(@"C:\Report\R_Landbase_Detailed.rpt");
crystalReportViewer12.ReportSource = R_Landbase_Detailed1;
crystalReportViewer12.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 = '16'", txt_ForNo, "Form");
a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '16'", txt_RevNo, "Revision");
a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '16'", txt_ISO, "ISO");
TextObject FormNo = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_formNo"];
TextObject RevNo = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_RevNo"];
TextObject Iso = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_iso"];
FormNo.Text = txt_ForNo.Text;
RevNo.Text = txt_RevNo.Text;
Iso.Text = txt_ISO.Text;
//R_Landbase_Detailed1.Refresh();
crystalReportViewer12.RefreshReport();
RemoveTab(crystalReportViewer12);
// wizard1.SelectedTab = tabPage12;
}
void load_Detailed()
{
R_Landbase_Detailed1.Load(@"C:\Report\R_Landbase_Detailed.rpt");
crystalReportViewer3.ReportSource = R_Landbase_Detailed1;
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 = '16'", txt_ForNo, "Form");
a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '16'", txt_RevNo, "Revision");
a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '16'", txt_ISO, "ISO");
TextObject FormNo = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_formNo"];
TextObject RevNo = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_RevNo"];
TextObject Iso = (TextObject)R_Landbase_Detailed1.ReportDefinition.ReportObjects["txt_iso"];
FormNo.Text = txt_ForNo.Text;
RevNo.Text = txt_RevNo.Text;
Iso.Text = txt_ISO.Text;
// R_Landbase_Detailed1.Refresh();
crystalReportViewer3.RefreshReport();
RemoveTab(crystalReportViewer3);
}
private void button10_Click(object sender, EventArgs e)
{
R_Landbase_Detailed1.PrintOptions.PrinterName = Tool.PrinterPath();
R_Landbase_Detailed1.PrintToPrinter(1, false, 0, 0);
}
