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(); } }