//loadHoaDon
public List <LapHoaDonDTO> loadHoaDon()
{
string query = "SELECT MaHD,MaPK,TienKham,TienThuoc,TongTien FROM dbo.HOADON where TrangThai='1'";
List <LapHoaDonDTO> lstHoaDon = new List <LapHoaDonDTO>();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 0)
{
return(null);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
ThongTinDto.Mahd = int.Parse(dt.Rows[i]["MaHD"].ToString());
ThongTinDto.Mapk = int.Parse(dt.Rows[i]["MaPK"].ToString());
ThongTinDto.Chiphikham = float.Parse(dt.Rows[i]["TienKham"].ToString());
ThongTinDto.Chiphithuoc = float.Parse(dt.Rows[i]["TienThuoc"].ToString());
ThongTinDto.Tongtien = float.Parse(dt.Rows[i]["TongTien"].ToString());
lstHoaDon.Add(ThongTinDto);
}
connection.Close();
return(lstHoaDon);
}
public List <LapHoaDonDTO> loadCTTT(LapHoaDonDTO a)
{
string query = "select CTTT.TenThuoc, CTTT.SoLuong, THUOC.DonViTinh, CTTT.DonGia from CTTT, THUOC where CTTT.TenThuoc = THUOC.TenThuoc and CTTT.MaPK = '" + a.Mapk + "'and THUOC.TrangThai='1'";
List <LapHoaDonDTO> lstCTTT = new List <LapHoaDonDTO>();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 0)
{
return(null);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
ThongTinDto.Tenthuoc = dt.Rows[i]["TenThuoc"].ToString();
ThongTinDto.Soluong = int.Parse(dt.Rows[i]["SoLuong"].ToString());
ThongTinDto.Donvitinh = dt.Rows[i]["DonViTinh"].ToString();
ThongTinDto.Dongia = float.Parse(dt.Rows[i]["DonGia"].ToString());
lstCTTT.Add(ThongTinDto);
}
connection.Close();
return(lstCTTT);
}
//load du lieu
public List <LapHoaDonDTO> loadMaPK()
{
string query = "select top 20 MaPK from PHIEUKHAM where TrangThai='1' order by NgayKham desc";
List <LapHoaDonDTO> lstMaPK = new List <LapHoaDonDTO>();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 0)
{
return(null);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
LapHoaDonDTO dto = new LapHoaDonDTO();
dto.Mapk = int.Parse(dt.Rows[i]["MaPK"].ToString());
lstMaPK.Add(dto);
}
connection.Close();
return(lstMaPK);
}
public bool luu(LapHoaDonDTO a)
{
string query = "INSERT INTO HOADON (MaPK, TienKham, TienThuoc, TongTien,TrangThai) VALUES('" + a.Mapk.ToString() + "', " + a.Chiphikham.ToString() + ", " + a.Chiphithuoc.ToString() + ", " + a.Tongtien.ToString() + ",'" + '1' + "')";
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
if (DataProvider.ThucThiNonQuery(query, connection) == true)
{
connection.Close();
return(true);
}
return(false);
}
//xoa
public bool xoa(LapHoaDonDTO a)
{
string query = "update HOADON set TrangThai='0' where MaHD='" + a.Mahd + "'";
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
if (DataProvider.ThucThiNonQuery(query, connection) == true)
{
connection.Close();
return(true);
}
return(false);
}
public LapHoaDonDTO LayMaHD()
{
string query = "select top 1 MaHD from HOADON where TrangThai='1' order by MaHD desc";
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 1)
{
ThongTinDto.Mahd = int.Parse(dt.Rows[0]["MaHD"].ToString());
connection.Close();
return(ThongTinDto);
}
connection.Close();
return(null);
}
public LapHoaDonDTO KtMaPK(LapHoaDonDTO a)
{
string query = "select MaPK from PHIEUKHAM where MaPK='" + a.Mapk + "'and TrangThai='1'";
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 1)
{
ThongTinDto.Mapk = int.Parse(dt.Rows[0]["MaPK"].ToString());
connection.Close();
return(ThongTinDto);
}
connection.Close();
return(null);
}
public LapHoaDonDTO TinhTienThuoc(LapHoaDonDTO a)
{
string query = "select sum(DonGia) as TienThuoc from CTTT where MaPK='" + a.Mapk + "'and TrangThai='1'";
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 1)
{
ThongTinDto.Chiphithuoc = float.Parse(dt.Rows[0]["TienThuoc"].ToString());
connection.Close();
return(ThongTinDto);
}
connection.Close();
return(null);
}
public LapHoaDonDTO loadThongTin(LapHoaDonDTO a)
{
string query = "select TenBN from BENHNHAN, PHIEUKHAM where BENHNHAN.MaBN = PHIEUKHAM.MaBN and MaPK='" + a.Mapk + "'and BENHNHAN.TrangThai='1'";
LapHoaDonDTO ThongTinDto = new LapHoaDonDTO();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
DataTable dt = DataProvider.LoadTable(query, connection);
if (dt.Rows.Count == 1)
{
ThongTinDto.Tenbn = dt.Rows[0]["TenBN"].ToString();
connection.Close();
return(ThongTinDto);
}
connection.Close();
return(null);
}
private void luu()
{
LapHoaDonDTO a = new LapHoaDonDTO();
if (cmbMaPhieuKham.Text == "" || txtChiPhiKham.Text == "" || txtChiPhiThuoc.Text == "" || txtTongTien.Text == "")
{
MessageBox.Show("Bạn cần nhập đủ thông tin", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
a.Mapk = int.Parse(cmbMaPhieuKham.Text);
a.Chiphikham = float.Parse(txtChiPhiKham.Text);
a.Chiphithuoc = float.Parse(txtChiPhiThuoc.Text);
a.Tongtien = float.Parse(txtTongTien.Text);
if (lhdBus.luu(a) == false)
{
MessageBox.Show("Bạn nhập sai thông tin", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Bạn đã lưu thành công với mã hóa đơn là:" + lhdBus.LayMaHD().Mahd.ToString(), "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMaHoaDon.Text = lhdBus.LayMaHD().Mahd.ToString();
loadHoaDon();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
LapHoaDonDTO a = new LapHoaDonDTO();
try
{
DataGridViewRow dr = dgvThongTinHoaDon.SelectedRows[0];
a.Mahd = int.Parse(dr.Cells["MaHD"].Value.ToString());
if (lhdBus.xoa(a) == false)
{
MessageBox.Show("Xóa không thành công", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Bạn đã xóa hóa đơn thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
loadHoaDon();
}
}
catch
{
MessageBox.Show("Bạn cần chọn mã hóa đơn cần xóa", "Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public LapHoaDonDTO loadThongTin(LapHoaDonDTO a)
{
return(lhdDao.loadThongTin(a));
}
public bool luu(LapHoaDonDTO a)
{
return(lhdDao.luu(a));
}
public LapHoaDonDTO TinhTienThuoc(LapHoaDonDTO a)
{
return(lhdDao.TinhTienThuoc(a));
}
public LapHoaDonDTO KtMaPK(LapHoaDonDTO a)
{
return(lhdDao.KtMaPK(a));
}
public List <LapHoaDonDTO> loadCTTT(LapHoaDonDTO a)
{
return(lhdDao.loadCTTT(a));
}
private void loadThongTin()
{
LapHoaDonDTO a = new LapHoaDonDTO();
a.Mapk = int.Parse(cmbMaPhieuKham.Text);
if (lhdBus.KtMaPK(a) == null)
{
MessageBox.Show("Không tồn tại mã phiếu khám", "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (lhdBus.loadThongTin(a) == null)
{
MessageBox.Show("Không có thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
txtTenBenhNhan.Text = lhdBus.loadThongTin(a).Tenbn;
}
if (lhdBus.loadCTTT(a) == null)
{
MessageBox.Show("Không có chi tiết toa thuốc!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.dgvThongTinChiTiet.Columns.Clear();
}
else
{
this.dgvThongTinChiTiet.Columns.Clear();
this.dgvThongTinChiTiet.DataSource = null;
this.dgvThongTinChiTiet.AutoGenerateColumns = false;
this.dgvThongTinChiTiet.AllowUserToAddRows = false;
dgvThongTinChiTiet.DataSource = lhdBus.loadCTTT(a);
DataGridViewTextBoxColumn tenthuocCol = new DataGridViewTextBoxColumn();
tenthuocCol.Name = "TenThuoc";
tenthuocCol.HeaderText = "Tên thuốc";
tenthuocCol.DataPropertyName = "TenThuoc";
tenthuocCol.Width = 200;
this.dgvThongTinChiTiet.Columns.Add(tenthuocCol);
DataGridViewTextBoxColumn soluongCol = new DataGridViewTextBoxColumn();
soluongCol.Name = "SoLuong";
soluongCol.HeaderText = "Số lượng";
soluongCol.DataPropertyName = "SoLuong";
soluongCol.Width = 200;
this.dgvThongTinChiTiet.Columns.Add(soluongCol);
DataGridViewTextBoxColumn donvitinhCol = new DataGridViewTextBoxColumn();
donvitinhCol.Name = "DonViTinh";
donvitinhCol.HeaderText = "Đơn vị tính";
donvitinhCol.DataPropertyName = "DonViTinh";
donvitinhCol.Width = 200;
this.dgvThongTinChiTiet.Columns.Add(donvitinhCol);
DataGridViewTextBoxColumn dongiaCol = new DataGridViewTextBoxColumn();
dongiaCol.Name = "DonGia";
dongiaCol.HeaderText = "Đơn giá";
dongiaCol.DataPropertyName = "DonGia";
dongiaCol.Width = 200;
this.dgvThongTinChiTiet.Columns.Add(dongiaCol);
CurrencyManager myCurrencyManager = (CurrencyManager)this.BindingContext[this.dgvThongTinChiTiet.DataSource];
myCurrencyManager.Refresh();
txtChiPhiThuoc.Text = lhdBus.TinhTienThuoc(a).Chiphithuoc.ToString();
txtTongTien.Text = (float.Parse(txtChiPhiThuoc.Text) + float.Parse(txtChiPhiKham.Text)).ToString();
}
}
public bool xoa(LapHoaDonDTO a)
{
return(lhdDao.xoa(a));
}
