void LoadReport() { // DataSet2 ds = new DataSet2(); // ds.Tables[0].Merge(dt); this.Text = "Medical Examination Certificate Print-Out"; R_TumorImmunological1.Load(@"C:\Report\R_TumorImmunological.rpt"); // R_TumorImmunological1.SetDataSource(ds); Viewer_01.ReportSource = R_TumorImmunological1; Viewer_01.SelectionFormula = "{t_result_main1.resultid} = '" + this.Tag.ToString() + "'"; IniFile ini = new IniFile(ClassSql.MMS_Path); TextObject a = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["a"]; TextObject b = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["b"]; TextObject c = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["c"]; TextObject d = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["d"]; TextObject e = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["e"]; TextObject f = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["f"]; TextObject g = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["g"]; TextObject h = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["h"]; TextObject i = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["i"]; TextObject FormNo = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["txt_formNO"]; TextObject RevNo = (TextObject)R_TumorImmunological1.ReportDefinition.ReportObjects["txt_RevNo"]; a.Text = ini.IniReadValue("NormalValue", "PSA"); b.Text = ini.IniReadValue("NormalValue", "AFP"); c.Text = ini.IniReadValue("NormalValue", "TumorOther"); d.Text = ini.IniReadValue("NormalValue", "HBS"); e.Text = ini.IniReadValue("NormalValue", "HBC"); f.Text = ini.IniReadValue("NormalValue", "HCV"); g.Text = ini.IniReadValue("NormalValue", "HBSAG"); h.Text = ini.IniReadValue("NormalValue", "Blank"); i.Text = ini.IniReadValue("NormalValue", "ImmuOther"); FormNo.Text = ini.IniReadValue("FORM", "Lab_33"); RevNo.Text = ini.IniReadValue("REVISION", "Lab_33"); Viewer_01.RefreshReport(); RemoveTab(Viewer_01); }
public void load_lab06() { IniFile ini = new IniFile(ClassSql.MMS_Path); R_lab_061.SetDatabaseLogon(ini.IniReadValue("CONNECTIONSTRING", "Uid"), ini.IniReadValue("CONNECTIONSTRING", "Pwd"), ini.IniReadValue("CONNECTIONSTRING", "Server"), ini.IniReadValue("CONNECTIONSTRING", "Database")); R_lab_061.Load(@"C:\Report\R_lab_06.rpt"); Viewer_01.ReportSource = R_lab_061; Viewer_01.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 = '1'", txt_ForNo, "Form"); //a.PutDataTOTextBox("SELECT * FROM tbl_formno WHERE cn = '1'", txt_RevNo, "Revision"); TextObject FormNo = (TextObject)R_lab_061.ReportDefinition.ReportObjects["txt_formNo"]; TextObject RevNo = (TextObject)R_lab_061.ReportDefinition.ReportObjects["txt_RevNo"]; FormNo.Text = ini.IniReadValue("FORM", "Lab_06"); RevNo.Text = ini.IniReadValue("REVISION", "Lab_06"); TextObject aa = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text134"]; TextObject b = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text133"]; TextObject c = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text125"]; TextObject d = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text98"]; TextObject e = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text97"]; TextObject f = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text96"]; TextObject g = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text95"]; TextObject h = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text144"]; TextObject i = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text143"]; TextObject j = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text142"]; TextObject k = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text141"]; TextObject l = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text140"]; TextObject m = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text139"]; TextObject n = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text145"]; TextObject o = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text146"]; TextObject p = (TextObject)R_lab_061.ReportDefinition.ReportObjects["Text147"]; aa.Text = ini.IniReadValue("NormalValue", "hemoglobin") + "gm/dl"; b.Text = ini.IniReadValue("NormalValue", "hematocrit") + "vol%"; c.Text = ini.IniReadValue("NormalValue", "RBC") + " m/cumm"; d.Text = ini.IniReadValue("NormalValue", "WBC") + " /cumm"; e.Text = ini.IniReadValue("NormalValue", "Platelet") + "/cumm"; f.Text = ini.IniReadValue("NormalValue", "BloodType"); g.Text = ini.IniReadValue("NormalValue", "ESR") + "mm/hr(MALE)/" + ini.IniReadValue("NormalValue", "textBox1") + "mm/hr(FEMALE)"; h.Text = ini.IniReadValue("NormalValue", "Lympho") + "%"; i.Text = ini.IniReadValue("NormalValue", "Segmenters") + "%"; j.Text = ini.IniReadValue("NormalValue", "Easinophils") + "%"; k.Text = ini.IniReadValue("NormalValue", "MonoCytes") + "%"; l.Text = ini.IniReadValue("NormalValue", "Myelocytes"); m.Text = ini.IniReadValue("NormalValue", "Juveniles"); n.Text = ini.IniReadValue("NormalValue", "StabCells") + "%"; o.Text = ini.IniReadValue("NormalValue", "BasoPhils") + "%"; p.Text = ini.IniReadValue("NormalValue", "Hema_Other"); //R_lab_061.Refresh(); Viewer_01.RefreshReport(); RemoveTab(Viewer_01); wizard1.SelectedTab = tabPage1; }