public void DataLoad()
{
dbCTNhapHang = new DBChiTietNhapHang();
dtCTNhapHang = new DataTable();
dtCTNhapHang = dbCTNhapHang.GetAllChiTietNhapHang().Tables[0];
dgvDanhMucCTNhapHang.DataSource = dtCTNhapHang;
foreach (DataGridViewRow row in dgvDanhMucCTNhapHang.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
dgvDanhMucCTNhapHang.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
DBSanPham dbSanPham;
DataSet dsSanPham;
dbSanPham = new DBSanPham();
dsSanPham = new DataSet();
dsSanPham = dbSanPham.GetGiaBan();
DBHopDong dbHopDong = new DBHopDong();
DataSet dsHopDong = new DataSet();
dsHopDong = dbHopDong.GetSoHopDong();
cmSoHopDong.DataSource = dsHopDong.Tables[0];
cmSoHopDong.DisplayMember = "SoHopDong";
cmSoHopDong.ValueMember = "SoHopDong";
cmMaSP.DataSource = dsSanPham.Tables[0];
cmMaSP.DisplayMember = "MaSP";
cmMaSP.ValueMember = "MaSP";
txtMaNhapHang.DataBindings.Clear();
cmSoHopDong.DataBindings.Clear();
cmMaSP.DataBindings.Clear();
txtSoLuong.DataBindings.Clear();
dtpNgayNhapHang.DataBindings.Clear();
txtMaNhapHang.DataBindings.Add("Text", dtCTNhapHang, "MaNhapHang");
cmSoHopDong.DataBindings.Add("Text", dtCTNhapHang, "SoHopDong");
cmMaSP.DataBindings.Add("Text", dtCTNhapHang, "MaSP");
txtSoLuong.DataBindings.Add("Text", dtCTNhapHang, "SoLuong");
dtpNgayNhapHang.DataBindings.Add("Text", dtCTNhapHang, "NgayNhapHang");
if (dgvDanhMucCTNhapHang.Rows.Count == 0)
{
btnXoa.Enabled = false;
}
string[] strs = new string[dtCTNhapHang.Columns.Count];
int idx = 0;
foreach (DataColumn col in dtCTNhapHang.Columns)
{
strs[idx++] += col.ColumnName;
}
cmCotTimKiem.DataSource = strs;
}
private void frmXemDanhMucHopDong_Load(object sender, EventArgs e)
{
dbHopDong = new DBHopDong();
dgvDanhMucHopDong.DataSource = dbHopDong.GetAllHopDong();
dgvDanhMucHopDong.Columns["NhaCungCap"].Visible = false;
dgvDanhMucHopDong.Columns["ChiTietHopDongs"].Visible = false;
foreach (DataGridViewRow row in dgvDanhMucHopDong.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
dgvDanhMucHopDong.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
cmCotTimKiem.DataSource = new string[] { "SoHopDong", "MaNCC", "NgayKy", "ThoiHanHopDong" };
}
private void DataLoad()
{
dbHopDong = new DBHopDong();
dgvDanhMucHopDong.DataSource = dbHopDong.GetAllHopDong();
dgvDanhMucHopDong.Columns["NhaCungCap"].Visible = false;
dgvDanhMucHopDong.Columns["ChiTietHopDongs"].Visible = false;
foreach (DataGridViewRow row in dgvDanhMucHopDong.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
dgvDanhMucHopDong.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
cmMaNCC.DataSource = new DBNhaCungCap().GetAllNhaCC();
cmMaNCC.DisplayMember = "MaNCC";
cmMaNCC.ValueMember = "MaNCC";
cmCotTimKiem.DataSource = new string[] { "SoHopDong", "MaNCC", "NgayKy", "ThoiHanHopDong" };
DataBind();
}
public void DataLoad()
{
dbSanPham = new DBSanPham();
dbNCC = new DBNhaCungCap();
dbHopDong = new DBHopDong();
BuidHopDong();
SetMaHopDong();
dgvDanhMucSanPham.DataSource = dbSanPham.GetAllProduct();
dgvDanhMucSanPham.Columns["ChiTietHoaDon"].Visible = false;
dgvDanhMucSanPham.Columns["ChiTietHopDong"].Visible = false;
dgvDanhMucSanPham.Columns["GiaBan"].Visible = false;
// Tạo số thứ tự đầu dòng của dgvDanhMucSanPham và tự auto size
foreach (DataGridViewRow row in dgvDanhMucSanPham.Rows)
{
row.HeaderCell.Value = (row.Index + 1).ToString();
}
dgvDanhMucSanPham.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders);
var numbers = from n in Enumerable.Range(1, 20)
select n;
cmSoLuong.DataSource = numbers.ToList();
cmNhaCC.DataSource = dbNCC.GetAllNhaCC();
cmNhaCC.DisplayMember = "TenNCC";
cmNhaCC.ValueMember = "MaNCC";
cmNhaCC.Text = "";
txtMaNCC.Text = "";
txtTenNCC.Text = "";
btnGiamSP.Enabled = false;
btnXoaSP.Enabled = false;
btnThanhToan.Enabled = false;
toolStrip2.Enabled = false;
}
private void SetMaHopDong()
{
dbHopDong = new DBHopDong();
txtSoPhieu.Text = dbHopDong.SetNewPrimaryKey();
}
