public void DataLoad()
{
dbCTHoaDon = new DBChiTietHoaDon();
dgvDanhMucCTHoaDon.DataSource = dbCTHoaDon.GetAllCTHoaDon();
dgvDanhMucCTHoaDon.Columns["HoaDon"].Visible = false;
dgvDanhMucCTHoaDon.Columns["SanPham"].Visible = false;
foreach (DataGridViewRow row in dgvDanhMucCTHoaDon.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
dgvDanhMucCTHoaDon.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
if (dgvDanhMucCTHoaDon.Rows.Count == 0)
{
btnXoa.Enabled = false;
}
cmMaHoaDon.DataSource = new DBHoaDon().GetAllHoaDon();
cmMaHoaDon.DisplayMember = "MaHoaDon";
cmMaHoaDon.ValueMember = "MaHoaDon";
cmMaSP.DataSource = new DBSanPham().GetAllProduct();
cmMaSP.DisplayMember = "MaSP";
cmMaSP.ValueMember = "MaSP";
DataBind();
}
private void LuuThongTinChiTietHoaDon()
{
foreach (DataRow row in dtCTHD.Rows)
{
string err = "";
string maSP = row["MaSP"].ToString();
int soLuong = int.Parse(row["SoLuong"].ToString());
decimal donGia = decimal.Parse(row["ThanhTien"].ToString());
int chietKhau = int.Parse(row["ChietKhau"].ToString());
DBChiTietHoaDon dbCTHoaDon = new DBChiTietHoaDon();
dbCTHoaDon.InsertCTHoaDon(ref err, maHoaDon, maSP, soLuong, donGia, chietKhau);
}
}
private void frmXemDanhMucChiTietHoaDon_Load(object sender, EventArgs e)
{
dbCTHoaDon = new DBChiTietHoaDon();
dgvDanhMucCTHoaDon.DataSource = dbCTHoaDon.GetAllCTHoaDon();
dgvDanhMucCTHoaDon.Columns["HoaDon"].Visible = false;
dgvDanhMucCTHoaDon.Columns["SanPham"].Visible = false;
foreach (DataGridViewRow row in dgvDanhMucCTHoaDon.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
dgvDanhMucCTHoaDon.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
cmCotTimKiem.DataSource = new string[] { "MaHoaDon", "MaSP" };
}