public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
R_Landbade_MER rpt = new R_Landbade_MER();
rpt.Site = this.Site;
return(rpt);
}
public void Load_MER()
{
Cursor.Current = Cursors.WaitCursor;
wizard1.SelectedTab = tabPage4;
tabControl1.SelectedTab = tabPage5;
IniFile ini = new IniFile(ClassSql.MMS_Path);
DataClasses1DataContext db = new DataClasses1DataContext(Properties.Settings.Default.MyConString);
DataTable dt = new ds_report2.sp_Landbase_MER1DataTable();
R_Landbade_MER R_Landbase_MER = new R_Landbade_MER();
var list = db.sp_Landbase_MER1(this.Tag.ToString()).ToList();
foreach (var i in list)
{
dt.Rows.Add(
i.lastname, i.firstname, i.middlename, i.address_1, i.position, i.marital_status, i.gender, i.birthdate, i.place_of_birth, i.employer, i.passport_no, i.nationality, i.religion, i.country_destination, i.picture.ToArray(), i.resultid, i.head_injury, i.frequent_headaches, i.frequent_dizziness, i.fainting_spells, i.insomnia, i.depression, i.trachoma, i.deafness, i.nose_throat_disorder, i.tuberculosis, i.other_lung_disorder, i.high_blood_pressure, i.heart_disease, i.rheumatic_fever, i.diabetes_mellitus, i.other_endocrine_disorder, i.cancer_tumor, i.blood_disorders, i.stomach_pain, i.other_abdominal_disorder, i.kidney_bladder_disorder, i.back_injury, i.genetic_hereditary, i.sexually_transmit_disease, i.tropical_disease, i.asthma, i.allergies, i.gynecological_disorder, i.operations, i.operations_specify, i.others, i.schistosomiasis, i.last_menstrual_period, i.allergies_specify, i.other_abdominal_specify, i.column1, i.column2, i.column3, i.column4, i.column5, i.column6, i.column7, i.column7_comment, i.column8, i.column8_comment, i.column1_comment, i.column2_comment, i.column3_comment, i.column4_comment, i.column5_comment, i.column6_comment);
}
R_Landbase_MER.SetDataSource(dt);
TextObject FormNo = (TextObject)R_Landbase_MER.ReportDefinition.ReportObjects["txt_formNo"];
TextObject RevNo = (TextObject)R_Landbase_MER.ReportDefinition.ReportObjects["txt_RevNo"];
TextObject Iso = (TextObject)R_Landbase_MER.ReportDefinition.ReportObjects["txt_iso"];
FormNo.Text = ini.IniReadValue("FORM", "Landbase_MER");
RevNo.Text = ini.IniReadValue("REVISION", "Landbase_MER");
Iso.Text = ini.IniReadValue("ISO", "Landbase_MER");
Viewer4_1.ReportSource = R_Landbase_MER;
RemoveTab(Viewer4_1);
Cursor.Current = Cursors.Default;
}
