private void BtnXoa_Click(object sender, EventArgs e)
{
int blresult;
blresult = 0;
blresult = Convert.ToInt16(MessageBox.Show("Bạn có muốn xóa thuốc", "Xóa Thuốc", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation));
//MessageBox.Show(blresult.ToString());
if (blresult == 1)
{
hd_DTO = new HoaDon_DTO();
hd_BUS = new HoaDon_BUS();
hd_DTO.MaHoaDon = mahoadon;
cthd_DTO = new ChiTietHoaDon_DTO();
cthd_BUS = new ChiTietHoaDon_BUS();
cthd_DTO.MaHoaDon = mahoadon;
hd_BUS.XoaHoaDon(hd_DTO);
cthd_BUS.XoaChiTietHoaDon(cthd_DTO);
FrmHoaDon_GUI FrmHoaDon = new FrmHoaDon_GUI();
Close();
FrmHoaDon.Show();
}
}
private List <ChiTietHoaDon_DTO> ConvertToList(DataTable dt)
{
List <ChiTietHoaDon_DTO> ls = new List <ChiTietHoaDon_DTO>();
foreach (DataRow row in dt.Rows)
{
ChiTietHoaDon_DTO cthd = new ChiTietHoaDon_DTO();
cthd.MaHD = (int)row.ItemArray[0];
cthd.MaMon = (int)row.ItemArray[1];
cthd.TenMon = (String)row.ItemArray[2];
cthd.Gia = (double)row.ItemArray[3];
cthd.Donvitinh = (String)row.ItemArray[4];
cthd.Soluong = (int)row.ItemArray[5];
cthd.Thanhtien = (double)row.ItemArray[6];
ls.Add(cthd);
}
return(ls);
}
private void btnThem_Click(object sender, EventArgs e)
{
int blresult;
blresult = 0;
tienthuoc = Int32.Parse(strtienthuoc);
// string tong = (txtTienKham.Text + txtTienThuoc.Text).ToString();
tongtien = tienthuoc + tienkham;
blresult = Convert.ToInt16(MessageBox.Show("Bạn có muốn thêm hoa don", "Thêm Hoa Don", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation));
//MessageBox.Show(blresult.ToString());
//Tổng tiền
if (blresult == 1)
{
hd_DTO = new HoaDon_DTO();
hd_BUS = new HoaDon_BUS();
hd_DTO.MaHoaDon = mahoadon;
hd_DTO.MaPhieuKham = cbxPhieuKham.Text;
hd_DTO.MaBenhNhan = mabn;
hd_DTO.Tienkham = txtTienKham.Text;
hd_DTO.Tienthuoc = txtTienThuoc.Text;
hd_DTO.NgayKham = txtNgayKham.Text;
hd_BUS.NhapThongTinHoaDonMoi(hd_DTO);
cthd_DTO = new ChiTietHoaDon_DTO();
cthd_BUS = new ChiTietHoaDon_BUS();
cthd_DTO.MaHoaDon = mahoadon;
cthd_DTO.MaNhanSu = manhansu;
cthd_DTO.Ngaykham = txtNgayKham.Text;
cthd_DTO.Tongtien = tongtien.ToString();
cthd_BUS.NhapThongTinChiTietHoaDonMoi(cthd_DTO);
FrmHoaDon_GUI FrmHoaDon = new FrmHoaDon_GUI();
Close();
FrmHoaDon.Show();
}
}
private void btnThemSP_Click(object sender, EventArgs e)
{
if (txtTenGiay.Text != "")
{
txtSDTKH.Enabled = false;
HoaDon_BUS hd_bus = new HoaDon_BUS();
ChiTietHoaDon_BUS cthd_bus = new ChiTietHoaDon_BUS();
HoaDon_DTO hd = new HoaDon_DTO();
hd = hd_bus.LayHoaDonChuaThanhToanTheoSDTKH(txtSDTKH.Text);
if (hd.id == -1)
{
HoaDon_DTO hd_moi = new HoaDon_DTO(-1, BienToanCuc.nvDangNhap.idNhanVien, txtSDTKH.Text, DateTime.Now, 0, (int)numGiamGia.Value, 0, 0);
if (hd_bus.Them(hd_moi))
{
ChiTietHoaDon_DTO cthd = new ChiTietHoaDon_DTO(hd_bus.LastID(), idGiay, cbSize.Text, (int)numSoLuong.Value);
cthd_bus.Them(cthd);
HienThiCTHoaDon(hd_bus.LastID());
LoadSL();
lvHoaDon.Tag = hd_bus.LayHoaDonChuaThanhToanTheoSDTKH(txtSDTKH.Text);
LoadHD();
}
}
else
{
ChiTietHoaDon_DTO cthd = new ChiTietHoaDon_DTO(hd.id, idGiay, cbSize.Text, (int)numSoLuong.Value);
cthd_bus.Them(cthd);
HienThiCTHoaDon(hd.id);
LoadSL();
lvHoaDon.Tag = hd;
LoadHD();
}
}
else
{
MessageBox.Show("Vui lòng chọn sản phẩm !!", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public bool ThemCTHD(ChiTietHoaDon_DTO cthd)
{
SqlConnection con = DataProvider.TaoKetNoi();
string query = "ThemCTHD";
SqlCommand cm = new SqlCommand(query, con);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.AddWithValue("@idHoaDon", cthd.idHoaDon);
cm.Parameters.AddWithValue("@idGiay", cthd.idGiay);
cm.Parameters.AddWithValue("@sizeGiay", cthd.size);
cm.Parameters.AddWithValue("@soLuong", cthd.soLuong);
int NumOfRow = cm.ExecuteNonQuery();
con.Close();
if (NumOfRow > 0)
{
return(true);
}
else
{
return(false);
}
}
public void SuaThongTinChiTietHoaDon(ChiTietHoaDon_DTO cthd)
{
}
public void XoaChiTietHoaDon(ChiTietHoaDon_DTO cthd)
{
cthd.Delete();
}
public void NhapThongTinChiTietHoaDonMoi(ChiTietHoaDon_DTO cthd)
{
cthd.Insert();
}
public bool Them(ChiTietHoaDon_DTO cthd)
{
ChiTietHoaDon_DAO objChiTietHoaDon_DAO = new ChiTietHoaDon_DAO();
return(objChiTietHoaDon_DAO.ThemCTHD(cthd));
}
