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 void bt_LapHoaDon_Click(object sender, EventArgs e)
{
try
{
if (dgv_HoaDon.Rows.Count == 0 || tb_maKH.Text == "" || dgv_KhachHang.Rows.Count == 0)
{
MessageBox.Show("Bạn chưa nhập mã khách hàng, hoặc hóa đơn chưa có mặt hàng!", "Thông báo");
}
else
{
string temp = dgv_KhachHang.Rows[0].Cells["tileGG"].Value.ToString();
dgv_DTB.DataSource = HoaDon_BUS.lapHoaDon(int.Parse(tb_maKH.Text), typeHD, float.Parse(temp), float.Parse(lb_TongTien.Text));
lb_ThongBao.Text = dgv_DTB[0, 0].Value.ToString();
for (int i = 0; i < dgv_HoaDon.Rows.Count; i++)
{
string masp = dgv_HoaDon.Rows[i].Cells["masp2"].Value.ToString();
string soLuong = dgv_HoaDon.Rows[i].Cells["soluong2"].Value.ToString();
string dongia = dgv_HoaDon.Rows[i].Cells["dongia"].Value.ToString();
string thanhtien = dgv_HoaDon.Rows[i].Cells["tien"].Value.ToString();
ChiTietHoaDon_BUS.InsertChiTietHoaDon(int.Parse(lb_ThongBao.Text), int.Parse(masp), int.Parse(soLuong), int.Parse(dongia), int.Parse(thanhtien));
}
MessageBox.Show("Thiết lập đơn hàng thành công!", "Thông báo");
ReSet_Form(sender, e);
}
}
catch
{
MessageBox.Show("Hệ thống mất kết nối, vui lòng quay lại sau!", "Thông báo");
ReSet_Form(sender, e);
}
}
private void dataGridView1_Click_1(object sender, EventArgs e)
{
try
{
Ban_DTO Table = listView1.Tag as Ban_DTO;
int MaHD = HoaDon_BUS.KTHoaDon(Table.Ma_Ban);
DataGridViewRow dgvr = dataGridView1.CurrentRow;
string MaSP = dgvr.Cells["MaSP"].Value.ToString();
string TenSP = dgvr.Cells["TenSP"].Value.ToString();
int SL = 1;
if (MaHD == -1)
{
HoaDon_BUS.InsertHoaDon(Table.Ma_Ban);
int Ma_HDD = ChiTietHD_DAO.GetMaHD();
ChiTietHoaDon_BUS.InsertChiTietHoaDon(Ma_HDD, MaSP, TenSP, SL);
MessageBox.Show("Thêm món thành công!");
}
else
{
ChiTietHoaDon_BUS.InsertChiTietHoaDon(MaHD, MaSP, TenSP, SL);
MessageBox.Show("Thêm món thành công!");
}
ShowThongTin_Ban(Table.Ma_Ban);
LoadBan();
}
catch
{
MessageBox.Show("Vui lòng chọn bàn trước khi chọn món");
}
}
private void load_GridviewCTHD()
{
dtCTHD.Rows.Clear();
if (maHD == -1)
{
return;
}
lsCTHD = ChiTietHoaDon_BUS.SelectCTHDtheoMaHD(maHD, Mode);
int n = lsCTHD.Count;
double TongTienMonAn = 0;
for (int i = 0; i < n; i++)
{
DataRow row = dtCTHD.NewRow();
row[0] = lsCTHD[i].MaMon;
row[1] = lsCTHD[i].TenMon;
row[2] = lsCTHD[i].Gia;
row[3] = lsCTHD[i].Donvitinh;
row[4] = lsCTHD[i].Soluong;
row[5] = lsCTHD[i].Soluong * lsCTHD[i].Gia;
dtCTHD.Rows.Add(row);
TongTienMonAn += (double)row[5];
}
gridDSMon.DataSource = dtCTHD;
textEditTT1.Text = String.Format("{0:n}", TongTienMonAn);
textEditTT2.Text = ((double.Parse(textEditVAT.Text) / 100) * TongTienMonAn).ToString();
textEditTT3.Text = ((double.Parse(textEditGiamGia.Text) / 100) * TongTienMonAn).ToString();
TextEditTongTien.Text = String.Format("{0:n}", TongTienMonAn + double.Parse(textEditTT2.Text) - double.Parse(textEditTT3.Text));
}
private void btnTru_Click(object sender, EventArgs e)
{
if (maHD != -1)
{
DataRow row = dtCTHD.Rows[indexChiTiet];
int mamon = (int)row.ItemArray[0];
ChiTietHoaDon_BUS.UpdateSoLuongCTHD(maHD, mamon, -1, Mode);
load_GridviewCTHD();
}
}
private void btnDongY_Click(object sender, EventArgs e)
{
foreach (DataRow row in dtMonAnChon.Rows)
{
int mamon = (int)row.ItemArray[0];
int soluong = (int)row.ItemArray[3];
ChiTietHoaDon_BUS.insertCTHD(maHD, mamon, soluong, Mode);
}
reloadGridViewCTHD();
this.Close();
}
private void simpleButton5_Click(object sender, EventArgs e)
{
try
{
DataRow row = dtCTHD.Rows[indexChiTiet];
int mamon = (int)row.ItemArray[0];
ChiTietHoaDon_BUS.DeleteCTHD(maHD, mamon);
dtCTHD.Rows.RemoveAt(indexChiTiet);
load_GridviewCTHD();
}
catch (Exception) {}
}
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);
}
}
private void btnDongY_Click(object sender, EventArgs e)
{
int count = listViewDSBanGhep.Items.Count;
if (count <= 1)
{
MessageBox.Show("Ban phai chon it nhat 2 ban de ghep.");
return;
}
if (indexBan != -1)
{
int mabanNew = lsBan[indexBan].MaBan;
int maHDchon = int.Parse(listViewDSBanGhep.Items[0].SubItems[2].Text);
int maBanchon_old = int.Parse(listViewDSBanGhep.Items[0].SubItems[0].Text);
BanAn_BUS.UpdateTrangThaiBanAn(maBanchon_old, 0);
//doc lai cthd cua maHDchon de len danh sach kiem tra trung khoa chinh
DataTable dtCthdChon = ChiTietHoaDon_BUS.SelectTableCTHD(maHDchon);
for (int i = 1; i < count; i++)
{
int maHDold = int.Parse(listViewDSBanGhep.Items[i].SubItems[2].Text);
int maBanold = int.Parse(listViewDSBanGhep.Items[i].SubItems[0].Text);
//giai phong cac ban cu
BanAn_BUS.UpdateTrangThaiBanAn(maBanold, 0);
//voi moi maHDold, cong don chi tiet hoa don, kiem tra khoa chinh
DataTable dtCthdOld = ChiTietHoaDon_BUS.SelectTableCTHD(maHDold);
foreach (DataRow row in dtCthdOld.Rows)
{
int n = dtCthdChon.Rows.Count;
bool duplicate = false;
//chen cac dong cua cthoadon cu vao ct hoa don chung
//cong don so luong va thanh tien neu co mon an trung nhau
for (int j = 0; j < n; j++)
{
if ((int)dtCthdChon.Rows[j].ItemArray[1] == (int)row.ItemArray[1])
{
duplicate = true;
int tongsl = (int)dtCthdChon.Rows[j].ItemArray[2] + (int)row.ItemArray[2];
DataRow newRow = dtCthdChon.NewRow();
newRow[0] = maHDchon;
newRow[1] = (int)dtCthdChon.Rows[j].ItemArray[1];
newRow[2] = tongsl;
newRow[3] = 0; //tong tien se duoc tu dong tinh lai khi insert CTHD
dtCthdChon.Rows.Add(newRow);
dtCthdChon.Rows.RemoveAt(j);
break;
}
}
if (!duplicate)
{
//chen dong
DataRow newRow = dtCthdChon.NewRow();
newRow[0] = maHDchon;
newRow[1] = (int)row.ItemArray[1];
newRow[2] = (int)row.ItemArray[2];
newRow[3] = (double)row.ItemArray[3];
dtCthdChon.Rows.Add(newRow);
}
}
//xoa cthd cu
ChiTietHoaDon_BUS.DeleteCTHDtheoMaHD(maHDold);
//xoa hoa don cu
HoaDon_BUS.DeleteHoaDon(maHDold);
} //ket thuc vong lap cho cac ban ghep (tru ban dau)
//xoa cthd moi (vi dtCthdChon da chua tat ca) ; nhu vay toan bo CTHD da dc xoa
ChiTietHoaDon_BUS.DeleteCTHDtheoMaHD(maHDchon);
//cap nhat hoa don chung
HoaDon_BUS.UpdateMaBan(maHDchon, mabanNew);
BanAn_BUS.UpdateTrangThaiBanAn(mabanNew, 1);
//insert cac cthd moi
foreach (DataRow row in dtCthdChon.Rows)
{
ChiTietHoaDon_BUS.insertCTHD((int)row.ItemArray[0], (int)row.ItemArray[1], (int)row.ItemArray[2], Mode);
}
reloadListboxBanAn();
this.Close();
}
else
{
MessageBox.Show("Vui long chon ban muon ghep den.");
}
}
