private void dgv_danhsachck_SelectionChanged(object sender, EventArgs e)
{
try
{
int now = dgv_danhsachck.CurrentCell.RowIndex;
int k = int.Parse(dgv_danhsachck.Rows[now].Cells[0].Value.ToString());
int MaBenhNhan = int.Parse(PHIEUKHAMBENH_BUS.LoadChoKham().Rows[k - 1][0].ToString());
XuLyMaBN(MaBenhNhan);
dt_ngaysinh.Value = Convert.ToDateTime(PHIEUKHAMBENH_BUS.HienThongTin(MaBenhNhan).Rows[0][0].ToString());
txt_diachi.Text = PHIEUKHAMBENH_BUS.HienThongTin(MaBenhNhan).Rows[0][1].ToString();
int n = dgv_thuoc.Rows.Count;
for (int i = 1; i < n; i++)
{
dgv_thuoc.Rows.RemoveAt(0);
}
txt_dudoan.Text = "";
txt_trieuchung.Text = "";
txt_thuoc.Text = "";
txt_soluong.Text = "";
cbo_cachdung.SelectedItem = cbo_cachdung.Items[0];
cbo_cachdung.Text = cbo_cachdung.SelectedItem.ToString();
cbo_donvi.SelectedItem = cbo_donvi.Items[0];
cbo_donvi.Text = cbo_donvi.SelectedItem.ToString();
}
catch (Exception ex)
{ }
}
private void dgv_danhsachdk_SelectionChanged(object sender, EventArgs e)
{
try
{
int chiso = 1;
int n = dgv_thuoc.Rows.Count;
for (int i = 1; i < n; i++)
{
dgv_thuoc.Rows.RemoveAt(0);
}
int now = dgv_danhsachdk.CurrentCell.RowIndex;
int k = int.Parse(dgv_danhsachdk.Rows[now].Cells[0].Value.ToString());
int MaBenhNhan = int.Parse(PHIEUKHAMBENH_BUS.LoadDaKham().Rows[k - 1][0].ToString());
XuLyMaBN(MaBenhNhan);
dt_ngaysinh.Value = Convert.ToDateTime(PHIEUKHAMBENH_BUS.HienThongTin(MaBenhNhan).Rows[0][0].ToString());
txt_diachi.Text = PHIEUKHAMBENH_BUS.HienThongTin(MaBenhNhan).Rows[0][1].ToString();
foreach (DataRow row in CT_PHIEUKHAMBENH_BUS.LoadThongTin(int.Parse(PHIEUKHAMBENH_BUS.LoadDaKham().Rows[k - 1][2].ToString())).Rows)
{
txt_trieuchung.Text = row[1].ToString();
txt_dudoan.Text = row[0].ToString();
ThemHangThuoc(chiso, row[2].ToString(), row[3].ToString(), row[5].ToString(), row[4].ToString());
}
}
catch (Exception ex)
{ }
}
private void rd_luu_Click(object sender, EventArgs e)
{
if (dgv_thuoc.Rows.Count > 0)
{
int now = dgv_danhsachck.CurrentCell.RowIndex;
int k = int.Parse(dgv_thuoc.Rows[now].Cells[0].Value.ToString());
int MaBN = int.Parse(PHIEUKHAMBENH_BUS.LoadChoKham().Rows[k - 1][0].ToString());
int MaBE = HAMPHU_BUS.FMaBenh(txt_dudoan.Text);
PHIEUKHAMBENH_DTO PKB = new PHIEUKHAMBENH_DTO(MaBN, MaBE, txt_trieuchung.Text);
PHIEUKHAMBENH_BUS.ThemPhieuKhamBenh(PKB);
foreach (DataGridViewRow row in dgv_thuoc.Rows)
{
if (row.Cells[1].Value != null)
{
int MaTH = HAMPHU_BUS.FMaThuoc(row.Cells[1].Value.ToString());
int MaDV = HAMPHU_BUS.FMaDonVi(row.Cells[2].Value.ToString());
int MaCD = HAMPHU_BUS.FMaCachDung(row.Cells[4].Value.ToString());
int MaPK = HAMPHU_BUS.FMaPhieuKham(MaBN, MaBE);
CT_PHIEUKHAMBENH_DTO CTPKB = new CT_PHIEUKHAMBENH_DTO(MaPK, MaTH, MaDV, int.Parse(row.Cells[3].Value.ToString()), MaCD);
CT_PHIEUKHAMBENH_BUS.ThemChiTiet(CTPKB);
}
}
HOADON_BUS.TaoHoaDon(MaBN);
CTHD_BUS.TaoCTHoaDon(MaBN);
int n = dgv_danhsachck.Rows.Count;
for (int i = 1; i < n; i++)
{
dgv_danhsachck.Rows.RemoveAt(0);
}
LoadData();
dgv_danhsachck_SelectionChanged(sender, e);
luu = 1;
rd_luu_MouseLeave(sender, e);
timer1.Start();
timer1.Enabled = true;
lbl_thongbao.ForeColor = Color.Red;
lbl_thongbao.Text = "Lưu thành công";
timer1_Tick(sender, e);
}
else
{
if (txt_trieuchung.Text == "" || txt_dudoan.Text == "")
{
DevComponents.DotNetBar.MessageBoxEx.Show("Bạn chưa nhập đầy đủ thông tin của một phiếu khám bệnh!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (txt_trieuchung.Text == "")
{
txt_trieuchung.Focus();
}
else
{
txt_dudoan.Focus();
}
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("Bạn chưa nhập chi tiết phiếu khám bệnh!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txt_thuoc.Focus();
}
}
}
public void LoadDataDaKham()
{
//load benh nhan da kham
int chiso = dgv_danhsachdk.Rows.Count;
foreach (DataRow row in PHIEUKHAMBENH_BUS.LoadDaKham().Rows)
{
ThemHangDaKham(chiso, row[1].ToString());
chiso++;
}
}
public void LoadData()
{
//load dữ liệu vào datagridview
int chiso = dgv_danhsachck.Rows.Count;
foreach (DataRow row in PHIEUKHAMBENH_BUS.LoadChoKham().Rows)
{
ThemHang(chiso, row[1].ToString());
chiso++;
}
}
public void LoadDataBenhNhan()
{
int n = dgv_benhnhan.Rows.Count;
for (int i = 1; i < n; i++)
{
dgv_benhnhan.Rows.RemoveAt(0);
}
//load benh nhan da kham
int chiso = 1;
foreach (DataRow row in PHIEUKHAMBENH_BUS.LoadDaKham().Rows)
{
ThemHangBenhNhan(chiso, row[1].ToString());
chiso++;
}
}
private void radialMenu1_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "|*.pdf";
sfd.RestoreDirectory = true;
sfd.InitialDirectory = Path.GetFullPath(startInfo.Arguments);
int now = dgv_benhnhan.CurrentCell.RowIndex;
int k = int.Parse(dgv_benhnhan.Rows[now].Cells[0].Value.ToString());
int MaBenhNhan = int.Parse(PHIEUKHAMBENH_BUS.LoadDaKham().Rows[k - 1][0].ToString());
sfd.FileName = MaBN(MaBenhNhan).ToString();
if (sfd.ShowDialog() == DialogResult.OK)
{
lbl_path.Text = Path.GetDirectoryName(sfd.FileName);
}
startInfo.Arguments = Path.GetDirectoryName(sfd.FileName);
}
catch (Exception ex)
{ }
}
private void dgv_benhnhan_SelectionChanged(object sender, EventArgs e)
{
try
{
lbl_thanhchu.Text = "Thành chữ: ";
int now = dgv_benhnhan.CurrentCell.RowIndex;
int k = int.Parse(dgv_benhnhan.Rows[now].Cells[0].Value.ToString());
int MaBenhNhan = int.Parse(PHIEUKHAMBENH_BUS.LoadDaKham().Rows[k - 1][0].ToString());
XuLyMaBN(MaBenhNhan);
dt_ngaysinh.Value = Convert.ToDateTime(PHIEUKHAMBENH_BUS.HienThongTin(MaBenhNhan).Rows[0][0].ToString());
txt_diachi.Text = PHIEUKHAMBENH_BUS.HienThongTin(MaBenhNhan).Rows[0][1].ToString();
lbl_hoten.Text = "Họ tên: " + dgv_benhnhan.Rows[now].Cells[1].Value.ToString();
lbl_tienkham.Text = "Tiền khám: " + string.Format("{0:0,0}", QUYDINH_BUS.TienKham());
lbl_ngaykham.Text = "Ngày khám: " + Convert.ToDateTime(HOADON_BUS.XuatHoaDon(MaBenhNhan).Rows[0][1].ToString()).Date.ToShortDateString();
LoadDataThuoc(int.Parse(HOADON_BUS.XuatHoaDon(MaBenhNhan).Rows[0][0].ToString()));
lbl_tienthuoc.Text = "Tiền thuốc: " + string.Format("{0:0,0}", (int)float.Parse(HOADON_BUS.XuatHoaDon(MaBenhNhan).Rows[0][2].ToString()));
lbl_tong.Text = "Tổng tiền: " + string.Format("{0:0,0}", ((int)float.Parse(HOADON_BUS.XuatHoaDon(MaBenhNhan).Rows[0][2].ToString()) + QUYDINH_BUS.TienKham()));
DocTien(((int)float.Parse(HOADON_BUS.XuatHoaDon(MaBenhNhan).Rows[0][2].ToString()) + QUYDINH_BUS.TienKham()).ToString());
lbl_thanhchu.Text = lbl_thanhchu.Text + "Đồng";
}
catch (Exception ex)
{ }
}
private void rd_xuat_Click(object sender, EventArgs e)
{
if (dgv_thuoc.Rows.Count > 1)
{
int now = dgv_benhnhan.CurrentCell.RowIndex;
int k = int.Parse(dgv_benhnhan.Rows[now].Cells[0].Value.ToString());
int MaBenhNhan = int.Parse(PHIEUKHAMBENH_BUS.LoadDaKham().Rows[k - 1][0].ToString());
PDFDocument4 pdf = new PDFDocument4();
pdf.PageSize = PaperFormat.pfA4;
pdf.PageOrientation = PaperOrientation.pPortrait;
int fnt = pdf.AddFont("Times New Roman", true, false, false, false, fontCharset.fcDefault);
pdf.UseFont(fnt, 25);
pdf.ShowUnicodeTextAt(lbl_hoadon.Location.X + 20, lbl_hoadon.Location.Y + 20, lbl_hoadon.Text);
pdf.UseFont(fnt, 12);
pdf.ShowUnicodeTextAt(lbl_hoten.Location.X + 20, lbl_hoten.Location.Y + 20, lbl_hoten.Text);
pdf.ShowUnicodeTextAt(lbl_ngaykham.Location.X + 20, lbl_ngaykham.Location.Y + 20, lbl_ngaykham.Text);
pdf.ShowUnicodeTextAt(lbl_tienkham.Location.X + 20, lbl_tienkham.Location.Y + 20, lbl_tienkham.Text);
pdf.ShowUnicodeTextAt(lbl_tienthuoc.Location.X + 20, lbl_tienthuoc.Location.Y + 20, lbl_tienthuoc.Text);
int n = dgv_thuoc.Rows.Count;
int hoadon = pdf.AddTable(4, n, fnt, 12);
pdf.SetTableColumnSize(hoadon, 0, 50);
pdf.SetTableColumnSize(hoadon, 1, 200);
pdf.SetTableColumnSize(hoadon, 2, 70);
pdf.SetTableColumnSize(hoadon, 3, 70);
pdf.SetCellTableText(hoadon, 0, 0, "STT");
pdf.SetCellTableText(hoadon, 1, 0, "Tên thuốc");
pdf.SetCellTableText(hoadon, 2, 0, "Số Lượng");
pdf.SetCellTableText(hoadon, 3, 0, "Đơn giá");
pdf.SetCellTableTextAlign(hoadon, 0, 0, TextAlign.taCenter);
pdf.SetCellTableTextAlign(hoadon, 1, 0, TextAlign.taCenter);
pdf.SetCellTableTextAlign(hoadon, 2, 0, TextAlign.taCenter);
pdf.SetCellTableTextAlign(hoadon, 3, 0, TextAlign.taCenter);
int temp = 1;
foreach (DataGridViewRow row in dgv_thuoc.Rows)
{
if (row.Cells[0].Value != null)
{
pdf.SetCellTableText(hoadon, 0, temp, row.Cells[0].Value.ToString());
pdf.SetCellTableText(hoadon, 1, temp, row.Cells[1].Value.ToString());
pdf.SetCellTableText(hoadon, 2, temp, row.Cells[2].Value.ToString());
pdf.SetCellTableText(hoadon, 3, temp, row.Cells[3].Value.ToString());
pdf.SetCellTableTextAlign(hoadon, 0, temp, TextAlign.taCenter);
pdf.SetCellTableTextAlign(hoadon, 1, temp, TextAlign.taLeft);
pdf.SetCellTableTextAlign(hoadon, 2, temp, TextAlign.taCenter);
pdf.SetCellTableTextAlign(hoadon, 3, temp, TextAlign.taCenter);
temp++;
}
}
pdf.ShowTable(hoadon, dgv_thuoc.Location.X + 70, dgv_thuoc.Location.Y + 20, 1, 1);
pdf.ShowUnicodeTextAt(lbl_tong.Location.X + 20, dgv_thuoc.Location.Y + 30 + 20 * n, lbl_tong.Text);
pdf.ShowUnicodeTextAt(lbl_thanhchu.Location.X + 20, dgv_thuoc.Location.Y + 50 + 20 * n, lbl_thanhchu.Text);
pdf.ShowUnicodeTextAt(dgv_thuoc.Location.X + 300, dgv_thuoc.Location.Y + 70 + 20 * n, "Tp.Hồ Chí Minh, ngày " + string.Format("{0:dd}", DateTime.Now.Date) + " tháng " + string.Format("{0:MM}", DateTime.Now.Date) + " năm " + DateTime.Now.Year.ToString());
pdf.ShowUnicodeTextAt(dgv_thuoc.Location.X + 380, dgv_thuoc.Location.Y + 90 + 20 * n, "Chữ ký bác sỹ");
timer1.Start();
timer1.Enabled = true;
lbl_thongbao.ForeColor = Color.Red;
lbl_thongbao.Text = "Lưu thành công";
timer1_Tick(sender, e);
pdf.SaveToFile(lbl_path.Text + "\\" + MaBN(MaBenhNhan) + ".pdf", true);
}
else
{
DevComponents.DotNetBar.MessageBoxEx.Show("Chưa chọn bệnh nhân cần in hóa đơn!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
txt_ten.Focus();
}
}
