/// <summary> /// In Bênh an ngoai tru /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// private void button_Inbenhanngoaitru_Click(object sender, EventArgs e) { frmMain.frmReport = new ReportForm(); frmMain.frmReport.frmMain = this.frmMain; frmMain.frmReport.MdiParent = this.frmMain; frmMain.frmReport.arrReport = new ArrayList(); frmMain.frmReport.typeReport = "benhanngoaitru"; try { MySqlCommand com = new MySqlCommand(); com.Connection = Util.con; com.Parameters.Add("@id", MySqlDbType.Int32, 11).Value = int.Parse(textBox_MaBN.Text); com.CommandText = @"SELECT benhnhan.*,phieukhambenh.*,ngoaitru.* FROM benhnhan LEFT OUTER JOIN phieukhambenh ON benhnhan.id=phieukhambenh.Benhnhan_id LEFT OUTER JOIN ngoaitru ON phieukhambenh.id=ngoaitru.Phieukhambenh_id WHERE benhnhan.id=@id AND ngoaitru.Tinhtrangravien=0 GROUP BY benhnhan.id"; Util.con.Open(); MySqlDataReader read = com.ExecuteReader(); while (read.Read()) { Benhanngoaitru bant = new Benhanngoaitru(); bant.Tenbenhnhan = read["Ten"].ToString(); bant.Ngaysinh = DateTime.Parse(read["Ngaysinh"].ToString()); // ngay thang nam string a; if (bant.Ngaysinh.Day.ToString().Length == 1) a = "0" + bant.Ngaysinh.Day.ToString(); else a = bant.Ngaysinh.Day.ToString(); bant.Ngay1 = a.Substring(0, 1); bant.Ngay2 = a.Substring(1, 1); if (bant.Ngaysinh.Month.ToString().Length == 1) a = "0" + bant.Ngaysinh.Month.ToString(); else a = bant.Ngaysinh.Month.ToString(); bant.Thang1 = a.Substring(0, 1); bant.Thang2 = a.Substring(1, 1); bant.Nam1 = bant.Ngaysinh.Year.ToString().Substring(0, 1); bant.Nam2 = bant.Ngaysinh.Year.ToString().Substring(1, 1); bant.Nam3 = bant.Ngaysinh.Year.ToString().Substring(2, 1); bant.Nam4 = bant.Ngaysinh.Year.ToString().Substring(3, 1); bant.Tuoi = DateTime.Today.Year - DateTime.Parse(read["Ngaysinh"].ToString()).Year; if (int.Parse(read["Gioitinh"].ToString()) == 0) bant.Gioitinh = 1; else bant.Gioitinh = 2; bant.Nghenghiep = read["Nghenghiep"].ToString(); bant.Dantoc = read["Dantoc"].ToString(); bant.Ngoaikieu = read["Ngoaikieu"].ToString(); bant.Sonha = read["Sonha"].ToString(); bant.Duong = read["Duong"].ToString(); bant.Phuong = read["Phuong"].ToString(); bant.Quan = read["Quan"].ToString(); bant.Thanhpho = read["Thanhpho"].ToString(); bant.Noilamviec = read["Noilamviec"].ToString(); bant.Doituong = int.Parse(read["Doituong"].ToString()); bant.Bhytgiatritu = read["Bhytgiatritu"].ToString(); bant.Bhytgiatritu = read["Bhytgiatritu"].ToString(); bant.Sobhyt = read["Sobhyt"].ToString(); bant.Nguoithan = read["Nguoithan"].ToString(); bant.Diachinguoithan = read["Diachinguoithan"].ToString(); bant.Dienthoai = read["Dienthoai"].ToString(); bant.Thoigiandenkham = read["Thoigiandenkham"].ToString(); bant.Noigioithieu = read["Noigioithieu"].ToString(); bant.Lydovaovien = read["Lydovaovien"].ToString(); bant.Quatrinhbenhly = read["Quatrinhbenhly"].ToString(); bant.Tiensubenhbanthan = read["Tiensubenhbanthan"].ToString(); bant.Tiensubenhgiadinh = read["Tiensubenhgiadinh"].ToString(); bant.Mach = read["Mach"].ToString(); bant.Nhietdo = read["Nhietdo"].ToString(); bant.Huyetap = read["Huyetap"].ToString(); bant.Nhiptho = read["Nhiptho"].ToString(); bant.Trongluong = read["Trongluong"].ToString(); bant.Toanthan = read["Toanthan"].ToString(); bant.Cacbophan = read["Cacbophan"].ToString(); bant.Tomtatketqualamsan = read["Tomtatketqualamsan"].ToString(); bant.Chuandoanvaovien = read["Chuandoanvaovien"].ToString(); bant.Xuli = read["Xuli"].ToString(); bant.Dieutritaikhoa = read["Dieutritaikhoa"].ToString(); bant.Chuy = read["Chuy"].ToString(); bant.Dieutritu = DateTime.Parse(read["Dieutritu"].ToString()); // bant.Dieutriden = DateTime.Parse(read["Dieutriden"].ToString()); bant.Bacsikham= read["Bacsikhambenh"].ToString(); frmMain.frmReport.arrReport.Add(bant); } Util.con.Close(); frmMain.frmReport.Show(); } catch (MySqlException sqlE) { MessageBox.Show("in benh an ngoai tru"); return; } }
private void button_print_Click(object sender, EventArgs e) { frmMain.frmReport = new ReportForm(); frmMain.frmReport.frmMain = this.frmMain; frmMain.frmReport.MdiParent = this.frmMain; frmMain.frmReport.arrReport = new ArrayList(); frmMain.frmReport.typeReport = "benhanngoaitru"; try { MySqlCommand com = new MySqlCommand(); com.Connection = Util.con; com.Parameters.Add("@id", MySqlDbType.Int32, 11).Value = int.Parse(listView_searchresult.SelectedItems[0].SubItems[0].Text); com.CommandText = "SELECT * FROM phieukhambenh pkb LEFT OUTER JOIN benhnhan bn ON pkb.Benhnhan_id=bn.id LEFT OUTER JOIN ngoaitru ngt ON pkb.id = ngt.Phieukhambenh_id WHERE ngt.phieukhambenh_id=@id"; Util.con.Open(); MySqlDataReader read = com.ExecuteReader(); while (read.Read()) { Benhanngoaitru bant = new Benhanngoaitru(); bant.Tenbenhnhan = read["Ten"].ToString(); bant.Ngaysinh = DateTime.Parse(read["Ngaysinh"].ToString()); bant.Tuoi = DateTime.Today.Year - DateTime.Parse(read["Ngaysinh"].ToString()).Year; bant.Gioitinh = bool.Parse(read["Gioitinh"].ToString()) ? 1 : 2; bant.Nghenghiep = read["Nghenghiep"].ToString(); bant.Dantoc = read["Dantoc"].ToString(); bant.Ngoaikieu = read["Ngoaikieu"].ToString(); bant.Sonha = read["Sonha"].ToString(); bant.Duong = read["Duong"].ToString(); bant.Phuong = read["Phuong"].ToString(); bant.Quan = read["Quan"].ToString(); bant.Thanhpho = read["Thanhpho"].ToString(); bant.Noilamviec = read["Noilamviec"].ToString(); bant.Doituong = int.Parse(read["Doituong"].ToString()); bant.Bhytgiatritu = read["Bhytgiatritu"].ToString(); bant.Bhytgiatritu = read["Bhytgiatritu"].ToString(); bant.Sobhyt = read["Sobhyt"].ToString(); bant.Nguoithan = read["Nguoithan"].ToString(); bant.Diachinguoithan = read["Diachinguoithan"].ToString(); bant.Dienthoai = read["Dienthoai"].ToString(); bant.Thoigiandenkham = read["Thoigiandenkham"].ToString(); bant.Noigioithieu = read["Noigioithieu"].ToString(); bant.Lydovaovien = read["Lydovaovien"].ToString(); bant.Quatrinhbenhly = read["Quatrinhbenhly"].ToString(); bant.Tiensubenhbanthan = read["Tiensubenhbanthan"].ToString(); bant.Tiensubenhgiadinh = read["Tiensubenhgiadinh"].ToString(); bant.Mach = read["Mach"].ToString(); bant.Nhietdo = read["Nhietdo"].ToString(); bant.Huyetap = read["Huyetap"].ToString(); bant.Nhiptho = read["Nhiptho"].ToString(); bant.Trongluong = read["Trongluong"].ToString(); bant.Toanthan = read["Toanthan"].ToString(); bant.Cacbophan = read["Cacbophan"].ToString(); bant.Tomtatketqualamsan = read["Tomtatketqualamsan"].ToString(); bant.Chuandoanvaovien = read["Chuandoanvaovien"].ToString(); bant.Xuli = read["Xuli"].ToString(); bant.Dieutritaikhoa = read["Dieutritaikhoa"].ToString(); bant.Chuy = read["Chuy"].ToString(); frmMain.frmReport.arrReport.Add(bant); } Util.con.Close(); frmMain.frmReport.Show(); } catch (MySqlException sqlE) { return; } }