public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
R_Landbase_Detailed rpt = new R_Landbase_Detailed();
rpt.Site = this.Site;
return(rpt);
}
public void load_Detailed()
{
Cursor.Current = Cursors.WaitCursor;
wizard1.SelectedTab = tabPage3;
IniFile ini = new IniFile(ClassSql.MMS_Path);
DataClasses1DataContext db = new DataClasses1DataContext(Properties.Settings.Default.MyConString);
DataTable dt = new ds_report2.sp_landbase_DetailDataTable();
R_Landbase_Detailed R_Landbase_detailed = new R_Landbase_Detailed();
var list = db.sp_landbase_Detail(this.Tag.ToString()).ToList();
var count = list.Count();
foreach (var i in list)
{
dt.Rows.Add(i.lastname, i.firstname, i.middlename, i.address_1, i.contact_1, i.position, i.marital_status, i.gender, i.birthdate, i.place_of_birth, i.employer, i.passport_no, i.seamansbook_no, i.nationality, i.religion, i.country_destination, i.picture.ToArray(), i.resultid, i.result_date, i.pathologist, i.fitness_date, i.valid_until, i.remMain, i.recommendation, i.specimen_no, i.medtech, i.cxr, i.ecg, i.cbc, i.pregnancy_test, i.urinalysis, i.stool_exam, i.hbsag, i.hiv, i.rpr, i.blood_type, i.blood_chemistries, i.psychological_exam, i.additional_test, i.remarks, i.additional_test2, i.SKIN_TAG, i.SKIN, i.HEAD_NECK_SCALP_TAG, i.HEAD_NECK_SCALP, i.EYES_TAG, i.EYES, i.PUPILS_TAG, i.PUPILS, i.EARS_EARDRUM_TAG, i.EARS_EARDRUM, i.NOSE_SINUSES_TAG, i.NOSE_SINUSES, i.MOUTH_THROAT_TAG, i.MOUTH_THROAT, i.NECK_LN_THYROID_TAG, i.NECK_LN_THYROID, i.CHEST_BREAST_AXILLA_TAG, i.CHEST_BREAST_AXILLA, i.LUNGS_TAG, i.LUNGS, i.HEART_TAG, i.HEART, i.ABDOMEN_TAG, i.ABDOMEN, i.BACK_FLANK_TAG, i.BACK_FLANK, i.ANUS_RECTUM_TAG, i.ANUS_RECTUM, i.GU_SYSTEM_TAG, i.GU_SYSTEM, i.INGUINALS_GENITALS_TAG, i.INGUINALS_GENITALS, i.REFLEXES_TAG, i.REFLEXES, i.EXTREMITIES_TAG, i.EXTREMITIES, i.DENTAL, i.DENTAL_TAG, i.HEIGHT, i.WEIGHT, i.BP, i.PULSE, i.RESPIRATION, i.BODY_BUILD, i.FAR_OD_U, i.FAR_OD_C, i.FAR_OS_U, i.FAR_OS_C, i.NEAR_ODJ_U, i.NEAR_ODJ_C, i.NEAR_OSJ_U, i.NEAR_OSJ_C, i.ISHIHARA_U, i.ISHIHARA_C, i.HEARING_AD, i.HEARING_AS, i.CONVERSATIONAL_AD, i.BP_DIASTOLIC, 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.consulted, i.consulted_specify, i.maintenance_meds);
}
R_Landbase_detailed.SetDataSource(dt);
TextObject FormNo = (TextObject)R_Landbase_detailed.ReportDefinition.ReportObjects["txt_formNo"];
TextObject RevNo = (TextObject)R_Landbase_detailed.ReportDefinition.ReportObjects["txt_RevNo"];
TextObject Iso = (TextObject)R_Landbase_detailed.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");
Viewer3.ReportSource = R_Landbase_detailed;
RemoveTab(Viewer3);
Cursor.Current = Cursors.Default;
}
