private void timKiem(string value)
{
dgvDanhSach.Rows.Clear();
DataTable dt = HoaDonBanControl.timKiem(value);// tìm kiếm
for (int i = 0; i < dt.Rows.Count; ++i)
{
int idTrangThai = Convert.ToInt32(dt.Rows[i][4].ToString());
string tenTrangThai = "";
if (idTrangThai == 1)
{
tenTrangThai = "Đã thanh toán";
}
else if (idTrangThai == 2)
{
tenTrangThai = "Đang giao";
}
else if (idTrangThai == 3)
{
tenTrangThai = "Chưa thanh toán";
}
else if (idTrangThai == 4)
{
tenTrangThai = "Hoàn trả";
}
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3], tenTrangThai });
}
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = HoaDonBanControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; ++i)
{
int idTrangThai = Convert.ToInt32(dt.Rows[i]["TrangThai"].ToString());
string tenTrangThai = "";
if (idTrangThai == 1)
{
tenTrangThai = "Đã thanh toán";
}
else if (idTrangThai == 2)
{
tenTrangThai = "Đang giao";
}
else if (idTrangThai == 3)
{
tenTrangThai = "Chưa thanh toán";
}
else if (idTrangThai == 4)
{
tenTrangThai = "Hoàn trả";
}
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i]["TenKH"], dt.Rows[i]["TenNV"], dt.Rows[i]["NgayLap"], tenTrangThai });
}
}
private void loadChiTiet(int id) // lấy danh sách hóa đơn có mã là id
{
DataTable data = HoaDonBanControl.layDanhSachSP(id);
listSanPham = new List <SanPham>();
for (int i = 0; i < data.Rows.Count; ++i)
{
SanPham sanPham = new SanPham(data.Rows[i]);
listSanPham.Add(sanPham);
}
}
private void loadKhuyenMai()
{
DataTable dt = HoaDonBanControl.layThongTinHDB(HDB.Id);
HDB.KhuyenMai = new KhuyenMai(dt.Rows[0]["MaKM"].ToString().Length == 0 ? 0 : Convert.ToInt32(dt.Rows[0]["MaKM"].ToString()));
if (HDB.KhuyenMai.TenKM.Length > 0)
{
cbKhuyenMai.Text = HDB.KhuyenMai.TenKM;
return;
}
cbKhuyenMai.SelectedItem = "-----none-----";
}
public HoaDonBan(int id)
{
chiTiet = new ChiTietHDB(id);
this.id = id;
DataTable dt = HoaDonBanControl.layThongTinHDB(id);
idKH = dt.Rows[0]["MaKH"].ToString().Length == 0 ? 0 : Convert.ToInt32(dt.Rows[0]["MaKH"].ToString());
idNV = dt.Rows[0]["MaNV"].ToString().Length == 0 ? 0 : Convert.ToInt32(dt.Rows[0]["MaNV"].ToString());
trangThai = Convert.ToInt32(dt.Rows[0]["TrangThai"].ToString());
khuyenMai = new KhuyenMai(dt.Rows[0]["MaKM"].ToString().Length == 0 ? 0 : Convert.ToInt32(dt.Rows[0]["MaKM"].ToString()));
thanhToan = double.Parse(dt.Rows[0]["ThanhToan"].ToString());
ngayLap = DateTime.Parse(dt.Rows[0]["NgayLap"].ToString());
}
private void loadNhanVien()
{
DataTable dt = HoaDonBanControl.layThongTinHDB(HDB.Id);
HDB.IdNV = dt.Rows[0]["MaNV"].ToString().Length == 0 ? 0 : Convert.ToInt32(dt.Rows[0]["MaNV"].ToString());
NhanVien nv = new NhanVien(HDB.IdNV);
if (nv.TenNV.Length > 0)
{
cbNhanVien.Text = nv.TenNV;
return;
}
}
private void btnLuu_Click(object sender, EventArgs e)
{ // còn thiếu lưu các thông tin khác
if (HDB.Id == 0) // neu la hd moi
{
int ketqua = HoaDonBanControl.themDuLieu(HDB.IdKH, HDB.IdNV, HDB.NgayLap, HDB.KhuyenMai.MaKM, HDB.TrangThai, HDB.ThanhToan);
if (ketqua <= 0)
{
return;
} //
ketqua = 0;
// lay ma hoa don vua nhap
HDB.Id = HoaDonBanControl.layMaHDBMoi();
if (HDB.Id == 0)
{
return;
}
for (int i = 0; i < HDB.ChiTiet.ListSanPham.Count; ++i)
{
ketqua += HoaDonBanControl.themChiTietHDB(HDB.Id, HDB.ChiTiet.ListSanPham[i].IdSP, HDB.ChiTiet.ListSanPham[i].SoLuong, HDB.ChiTiet.ListSanPham[i].DonGia);
}
if (ketqua > 0)
{
MessageBox.Show("them thanh cong");
this.Close();
}
}
else // neu hd cu
{
//sua
HoaDonBanControl.suaThongTin(HDB.Id, HDB.IdKH, HDB.IdNV, HDB.KhuyenMai.MaKM, HDB.TrangThai, HDB.ThanhToan);
// xoa het chitiet cu
HoaDonBanControl.xoaChiTietHDB(HDB.Id);
//
int ketqua = 0;
for (int i = 0; i < HDB.ChiTiet.ListSanPham.Count; ++i)
{
ketqua += HoaDonBanControl.themChiTietHDB(HDB.Id, HDB.ChiTiet.ListSanPham[i].IdSP, HDB.ChiTiet.ListSanPham[i].SoLuong, HDB.ChiTiet.ListSanPham[i].DonGia);
}
if (ketqua > 0)
{
MessageBox.Show("sua thanh cong");
this.Close();
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
int ketQua = 0;
for (int i = 0; i < dgvDanhSach.Rows.Count - 1; ++i)
{
if (Convert.ToBoolean(dgvDanhSach.Rows[i].Cells["colCheck"].Value.ToString()))
{
ketQua += HoaDonBanControl.xoaThongTin(Convert.ToInt32(dgvDanhSach.Rows[i].Cells["colMa"].Value.ToString()));
}
}
if (ketQua > 0)
{
MessageBox.Show("xóa thành công " + ketQua);
loadDuLieu();
}
else
{
MessageBox.Show("xóa thất bại");
}
}
private void dgvDanhSach_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvDanhSach.Rows.Count == e.RowIndex + 1)
{
return;
}
int id = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells[1].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colSua"].Index)
{
frmThemHDB f = new frmThemHDB(id);
f.ShowDialog();
loadDuLieu();
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colXoa"].Index)
{
HoaDonBanControl.xoaThongTin(id);
loadDuLieu();
}
}
