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