private void ChiTietDonThuoc_Load(object sender, EventArgs e)
{
lblMaDonThuoc.Text = hdx.MaHDX.ToString();
lblNgayLap.Text = DateTimeConvert.FormatVN(hdx.NgayLap, "dd/MM/yyyy");
lblTienThuoc.Text = String.Format("{0:0,0}", Convert.ToInt32(hdx.TongTienThuoc)) + " VND";
lblTienThue.Text = hdx.TongThue.ToString();
lblTienHoaDon.Text = String.Format("{0:0,0}", Convert.ToInt32(hdx.TongTienHD)) + " VND";
benhNhan = busBenhNhan.GetBenhNhanDetails(hdx.MaBN);
lblMaBN_DT.Text = benhNhan.MaBN;
lblTenBN_DT.Text = benhNhan.HoTen;
lblTuoiBN_DT.Text = benhNhan.Tuoi.ToString();
lblSoDienThoaiBN_DT.Text = benhNhan.DienThoai;
lblDiaChiBN_DT.Text = benhNhan.DiaChi;
ArrayList arrChiTietHDX = busHDX.GetAllChiTietHDX(hdx.MaHDX);
foreach (ChiTietHoaDonXuat chiTietHDX in arrChiTietHDX)
{
ListViewItem lVItem = new ListViewItem(chiTietHDX.TenThuoc);
lVItem.SubItems.Add(chiTietHDX.SoLuong.ToString());
lVItem.SubItems.Add(String.Format("{0:0,0}", Convert.ToInt32(chiTietHDX.GiaBan)) + " VND");
lVItem.SubItems.Add(chiTietHDX.Thue.ToString());
lVItem.SubItems.Add(chiTietHDX.DonVi);
lVDanhSachChiTietHDX.Items.Add(lVItem);
}
}
public int UpdateBenhNhan(BenhNhan benhNhan)
{
List<SqlParameter> paramList = new List<SqlParameter>();
SqlParameter param = new SqlParameter();
param = new SqlParameter("@IDBN", SqlDbType.Int);
param.Value = benhNhan.IDBN;
paramList.Add(param);
param = new SqlParameter("@MaBN", SqlDbType.NVarChar);
param.Value = benhNhan.MaBN.Replace("'", "''"); ;
paramList.Add(param);
param = new SqlParameter("@HoTen", SqlDbType.NVarChar);
param.Value = benhNhan.HoTen.Replace("'", "''"); ;
paramList.Add(param);
param = new SqlParameter("@Tuoi", SqlDbType.Int);
param.Value = benhNhan.Tuoi;
paramList.Add(param);
param = new SqlParameter("@DiaChi", SqlDbType.NVarChar);
param.Value = benhNhan.DiaChi.Replace("'", "''"); ;
paramList.Add(param);
param = new SqlParameter("@DienThoai", SqlDbType.NVarChar);
param.Value = benhNhan.DienThoai;
paramList.Add(param);
int i = dbHelper.ExecuteNonQuery("UpdateBenhNhan_Haitx", paramList);
return i;
}
public Them_Sua_BenhNhan(BenhNhan benhNhan, int index, int mode)
{
InitializeComponent();
busBN = new BusBenhNhan();
this.benhNhan = benhNhan;
this.mode = mode;
this.index = index;
busUser = new BusUser();
}
public BenhNhan SelectBenhNhanDetails(int _IDBN)
{
SqlDataReader rd = dbHelper.ExecuteQuery("GetBenhNhan_IDBN "+_IDBN+"");
if (rd.Read())
{
BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5));
rd.Close();
return benhNhan;
}
rd.Close();
return null;
}
public BenhNhan SelectBenhNhanDetails(string _MaBN)
{
_MaBN = _MaBN.Replace("'", "''");
SqlDataReader rd = dbHelper.ExecuteQuery("GetBenhNhanDetails N'%" + _MaBN + "%'");
if (rd.Read())
{
BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5));
rd.Close();
return benhNhan;
}
rd.Close();
return null;
}
public ArrayList SelectAllBenhNhanByMaBN(string _MaBN)
{
_MaBN = _MaBN.Replace("'", "''");
SqlDataReader rd = dbHelper.ExecuteQuery("GetBenhNhanDetails N'%"+_MaBN+"%'");
ArrayList arrLBenhNhan = new ArrayList();
while (rd.Read())
{
BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0),rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5));
arrLBenhNhan.Add(benhNhan);
}
rd.Close();
return arrLBenhNhan;
}
private void button1_Click(object sender, EventArgs e)
{
if (mode == 1)
{
if (CheckFrom())
{
BenhNhan benhNhan = new BenhNhan(txtMaBN.Text, txtHoTen.Text, Convert.ToInt32(txtTuoi.Text),txtDiaChi.Text,txtDienThoai.Text);
int i = busBN.InsertBenhNhan(benhNhan);
if (i > 0)
{
SystemLog systemLog = new SystemLog(SellMedicine.IDUser, DateTime.Now.ToString(), "Thêm bệnh nhân");
busUser.SetSystemLog(systemLog);
MessageBox.Show(this,"Thêm bệnh nhân thành công!","Thông báo");
BenhNhan lastBenhNhan = busBN.GetLastBenhNhan();
dgBN(lastBenhNhan, index);
this.Close();
}
}
}
else if (mode == 2)
{
if (CheckFrom())
{
BenhNhan benhNhan = new BenhNhan(this.benhNhan.IDBN, txtMaBN.Text, txtHoTen.Text, Convert.ToInt32(txtTuoi.Text), txtDiaChi.Text, txtDienThoai.Text);
int i = busBN.UpdateBenhNhan(benhNhan);
if (i > 0)
{
SystemLog systemLog = new SystemLog(SellMedicine.IDUser, DateTime.Now.ToString(), "Sửa thông tin bệnh nhân");
busUser.SetSystemLog(systemLog);
MessageBox.Show(this, "Sửa thông tin bệnh nhân thành công!", "Thông báo");
dgBN(benhNhan,index);
this.Close();
}
}
}
}
public int UpdateBenhNhan(BenhNhan benhNhan)
{
return benhNhanQ.UpdateBenhNhan(benhNhan);
}
public int InsertBenhNhan(BenhNhan benhNhan)
{
return benhNhanQ.InsertBenhNhan(benhNhan);
}
private void lVDanhSachBenhNhan_DoubleClick(object sender, EventArgs e)
{
benhNhanHDX = (BenhNhan)arrLDSBenhNhan.ToArray()[lVDanhSachBenhNhan.FocusedItem.Index];
FillBenhNhanDetails(benhNhanHDX);
plDSKQTimKiemBN.Visible = false;
this.btnLuuHD.Focus();
}
public void SuaBenhNhan(BenhNhan benhNhan,int index)
{
arrLDSBenhNhan.RemoveAt(index);
arrLDSBenhNhan.Insert(index, benhNhan);
RefreshListBenhNhan();
}
public void GetNewBenhNhan(BenhNhan benhNhan,int index)
{
arrLDSBenhNhan.Insert(index,benhNhan);
RefreshListBenhNhan();
}
public void ClearHoaDon()
{
arrLlVChiTietHDX.Clear();
this.ThemThuocVaoDS();
txtMaThuoc.Text = "";
txtNTBSoLuongMua.Text = "";
txtMaBN.Text = "";
lblTienThue.Text = "---";
lblTienThuoc.Text = "---";
lblTongTien.Text = "---";
benhNhanHDX = null;
lblMaBN_DT.Text = "---";
lblTenBN_DT.Text = "---";
lblTuoiBN_DT.Text = "---";
lblDiaChiBN_DT.Text = "---";
lblSoDienThoaiBN_DT.Text = "---";
}
public void NhanBanDonThuoc()
{
if (lVSanhSachHDX.SelectedItems.Count > 0)
{
HoaDonXuat hdxOLD = (HoaDonXuat)arrLAllHDX.ToArray()[lVSanhSachHDX.FocusedItem.Index];
if (MessageBox.Show("Bạn có muốn tạo thêm một hóa đơn như này không?!", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
tabControl1.TabPages.Clear();
tabControl1.TabPages.Add(tPTaoDon);
tPTaoDon.Text = "Tạo Đơn Thuốc Mới";
lblbtnCopy.Visible = false;
lblbtnXemChiTiet.Visible = false;
lblbtnXoa.Visible = true;
lblbtnSua.Visible = true;
benhNhanHDX = busBenhNhan.GetBenhNhanDetails(hdxOLD.IDBN);
txtMaBN.Text = benhNhanHDX.MaBN;
lblMaBN_DT.Text = benhNhanHDX.MaBN;
lblTenBN_DT.Text = benhNhanHDX.HoTen;
lblTuoiBN_DT.Text = benhNhanHDX.Tuoi.ToString();
lblDiaChiBN_DT.Text = benhNhanHDX.DiaChi;
lblSoDienThoaiBN_DT.Text = benhNhanHDX.DienThoai;
arrLlVChiTietHDX.Clear();
ArrayList arrlTemp = busHDX.GetAllChiTietHDX(hdxOLD.MaHDX);
foreach (ChiTietHoaDonXuat chiTietHDX in arrlTemp)
{
Thuoc thuoc = new Thuoc(chiTietHDX.IDThuoc,chiTietHDX.MaThuoc, chiTietHDX.TenThuoc, chiTietHDX.SoLuong, chiTietHDX.GiaBan, chiTietHDX.DonVi, chiTietHDX.Thue);
arrLlVChiTietHDX.Add(thuoc);
}
this.ThemThuocVaoDS();
this.TinhTienHDX();
}
}
else
{
MessageBox.Show(this, "Chọn một hóa đơn", "Thông báo");
}
}
public void FillBenhNhanDetails(BenhNhan benhNhan)
{
txtMaBN.Text = benhNhan.MaBN;
lblMaBN_DT.Text = benhNhan.MaBN;
lblTenBN_DT.Text = benhNhan.HoTen;
lblTuoiBN_DT.Text = benhNhan.Tuoi.ToString();
lblDiaChiBN_DT.Text = benhNhan.DiaChi;
lblSoDienThoaiBN_DT.Text = benhNhan.DienThoai;
}
public BenhNhan SelectLastBenhNhan()
{
SqlDataReader rd = dbHelper.ExecuteQuery("SelectLastBenhNhan_Haitx");
if (rd.Read())
{
BenhNhan benhNhan = new BenhNhan(rd.GetInt32(0), rd.GetString(1), rd.GetString(2), rd.GetInt32(3), rd.GetString(4), rd.GetString(5));
rd.Close();
return benhNhan;
}
rd.Close();
return null;
}
