public void DataLoad() { BuidHoaDonMoi(); dbSanPham = new DBSanPham(); dbHoaDon = new DBHoaDon(); dbNhanVien = new DBNhanVien(); dgvDanhMucSanPham.DataSource = dbSanPham.GetAllProduct(); dgvDanhMucSanPham.Columns["GiaMua"].Visible = false; dgvDanhMucSanPham.Columns["ChiTietHoaDons"].Visible = false; dgvDanhMucSanPham.Columns["ChiTietHopDongs"].Visible = false; SetMaHoaDon(); // 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(); // Đổ dữ liệu lên cmNhanVien cmNhanVien.DataSource = dbNhanVien.GetAllEmployee(); cmNhanVien.DisplayMember = "HoTenNV"; cmNhanVien.ValueMember = "MaNV"; btnGiamSP.Enabled = false; btnXoaSP.Enabled = false; btnThanhToan.Enabled = false; toolStrip2.Enabled = false; }
private void frmXemTon_Load(object sender, EventArgs e) { db = new DBSanPham(); DataTable dt = new DataTable(); dt = db.XemTon(tenSP).Tables[0]; dgvXemTon.DataSource = dt; dgvXemTon.Columns["GiaMua"].Visible = false; dgvXemTon.Columns["GiaBan"].Visible = false; foreach (DataGridViewRow row in dgvXemTon.Rows) { row.HeaderCell.Value = (row.Index + 1).ToString(); } dgvXemTon.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); int tongTon = 0; for (int i = 0; i < dgvXemTon.Rows.Count; i++) { tongTon += int.Parse(dgvXemTon.Rows[i].Cells["SoLuong"].Value.ToString()); } lblTongTon.Text = tongTon.ToString(); }
private void frmThem_EditSanPham_Load(object sender, EventArgs e) { dbSanPham = new DBSanPham(); this.ActiveControl = txtMaSP; string[] DVTs = new string[] { "Bông", "Chậu", "Cành" }; cmDVT.DataSource = DVTs; }
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 frmXemDanhMucSanPham_Load(object sender, EventArgs e) { dbSanPham = new DBSanPham(); dgvDanhMucSanPham.DataSource = dbSanPham.GetAllProduct(); dgvDanhMucSanPham.Columns["ChiTietHoaDons"].Visible = false; dgvDanhMucSanPham.Columns["ChiTietHopDongs"].Visible = false; foreach (DataGridViewRow row in dgvDanhMucSanPham.Rows) { row.HeaderCell.Value = (row.Index + 1).ToString(); } dgvDanhMucSanPham.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); cmCotTimKiem.DataSource = new string[] { "TenSP", "MaSP", "DonViTinh", "SoLuong", "GiaBan", "GiaMua" }; }
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; }
public void RefreshDgvDanhMucSanPham(string maSP) { dbSanPham = new DBSanPham(); dgvDanhMucSanPham.DataSource = dbSanPham.GetAllProduct(); dgvDanhMucSanPham.Columns["GiaMua"].Visible = false; dgvDanhMucSanPham.Columns["ChiTietHoaDons"].Visible = false; dgvDanhMucSanPham.Columns["ChiTietHopDongs"].Visible = false; foreach (DataGridViewRow row in dgvDanhMucSanPham.Rows) { row.HeaderCell.Value = (row.Index + 1).ToString(); } dgvDanhMucSanPham.AutoResizeRowHeadersWidth(DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders); foreach (DataGridViewRow row in dgvDanhMucSanPham.Rows) { if (row.Cells["MaSP"].Value.ToString() == maSP) { row.Selected = true; dgvDanhMucSanPham.CurrentCell = dgvDanhMucSanPham.Rows[row.Index].Cells[0]; break; } } }
private void frmDatSoLuong_Load(object sender, EventArgs e) { nudSoLuong.Value = currsl; dbSanPham = new DBSanPham(); }
public BLSanPham() { dbSP = new DBSanPham(); }