private void bỆNHÁNNGOẠITRÚToolStripMenuItem_Click(object sender, EventArgs e)
{
if (frmReport == null || frmReport.IsDisposed)
{
frmReport = new ReportForm();
frmReport.frmMain = this;
frmReport.MdiParent = this;
frmReport.arrReport = new ArrayList();
Todieutri bant = new Todieutri();
frmReport.arrReport.Add(bant);
frmReport.Show();
}
else
{
frmReport.Focus();
}
}
private void button_print_todieutri_Click(object sender, EventArgs e)
{
int idBenhnhan = -1;
try
{
idBenhnhan = int.Parse(textBox_MaBN.Text);
}
catch (Exception ex)
{
}
if (idBenhnhan == -1)
{
return;
}
Hashtable currentObject = get_CurrentObject(idBenhnhan);
if (currentObject.Count == 0)
{
return;
}
frmMain.frmReport = new ReportForm();
frmMain.frmReport.frmMain = this.frmMain;
frmMain.frmReport.MdiParent = this.frmMain;
frmMain.frmReport.arrReport = new ArrayList();
frmMain.frmReport.typeReport = "todieutri";
try
{
MySqlCommand com = new MySqlCommand();
com.Connection = Util.con;
com.Parameters.Add("@id", MySqlDbType.Int32, 11).Value = int.Parse(currentObject["idBenhnhan"].ToString());
com.CommandText = @"SELECT benhnhan.Ten, benhnhan.Ngaysinh, todieutri_noidung.*, ngoaitru.*, ylenh.Mota, bacsi.TenBacsi
FROM todieutri_noidung
LEFT OUTER JOIN todieutri
ON todieutri_noidung.Todieutri_id=todieutri.id
LEFT OUTER JOIN phieukhambenh
ON phieukhambenh.id=todieutri.Phieukhambenh_id
LEFT OUTER JOIN ngoaitru
ON ngoaitru.Phieukhambenh_id=phieukhambenh.id
LEFT OUTER JOIN benhnhan
ON benhnhan.id=phieukhambenh.Benhnhan_id
LEFT OUTER JOIN ylenh
ON ylenh.id=todieutri_noidung.Ylenh_id
LEFT OUTER JOIN bacsi
ON bacsi.id=ylenh.Bacsi_id
WHERE benhnhan.id=@id AND ngoaitru.Tinhtrangravien=0";
Util.con.Open();
MySqlDataReader read = com.ExecuteReader();
while (read.Read())
{
Todieutri obj = new Todieutri();
obj.Mabenhnhan = idBenhnhan;
obj.Tenbenhnhan = read["Ten"].ToString();
obj.Ngaysinh = DateTime.Parse(read["Ngaysinh"].ToString());
obj.Chandoan = read["Benhchinh"].ToString() + " - " + read["Benhkemtheo"].ToString();
obj.Ngaygio = DateTime.Parse(read["Ngaygio"].ToString());
obj.Dientienbenh = read["Dientienbenh"].ToString();
obj.Ylenh = read["Mota"].ToString();
obj.Bacsi = read["TenBacsi"].ToString();
frmMain.frmReport.arrReport.Add(obj);
}
Util.con.Close();
frmMain.frmReport.Show();
}
catch (MySqlException sqlE)
{
MessageBox.Show("in to dieu tri");
return;
}
}