private void frmQuanLyHangHoa_Load(object sender, EventArgs e) { cboDonViTinh.SelectedIndex = 0; //load danh sách nhà cung cấp vào combobox cboNhaCungCap.DisplayMember = "tennhacungcap"; cboNhaCungCap.ValueMember = "manhacungcap"; cboNhaCungCap.DataSource = nhaCungCapDAO.LayDanhSachNhaCC(); //load danh sach nhom hang cboNhomHangHoa.DisplayMember = "tennhomhanghoa"; cboNhomHangHoa.ValueMember = "manhomhanghoa"; cboNhomHangHoa.DataSource = nhomHangHoaDAO.LayTatCaNhomHangHoa(); // Set the Format type and the CustomFormat string. datePickerNgaySX.Format = DateTimePickerFormat.Custom; datePickerNgaySX.CustomFormat = "dd-MM-yyyy"; datePickerHetHan.Format = DateTimePickerFormat.Custom; datePickerHetHan.CustomFormat = "dd-MM-yyyy"; dgvHangHoa.DataSource = hangHoaDAO.LayDanhSachMatHang(); this.getMaxMaHangHoa(); }
private void frmNhapHang_Load(object sender, EventArgs e) { if (frmMainDB.UserLogin1 != null) { txtNhanVien.Text = frmMainDB.UserLogin1.Manhanvien.Tennhanvien; } //formate datetime picker dtNgayNhap.Format = DateTimePickerFormat.Custom; dtNgayNhap.CustomFormat = "dd-MM-yyyy"; txtPhieuNhap.Text = phieuNhapDAO.SinhMaPhieuNhap(); //create datatable hang nhap dtHangNhap = new DataTable(); dtHangNhap.Columns.Add("mamathang", typeof(String)); dtHangNhap.Columns.Add("tenmathang", typeof(String)); dtHangNhap.Columns.Add("soluong", typeof(String)); dtHangNhap.Columns.Add("dongia", typeof(String)); dtHangNhap.Columns.Add("thanhtien", typeof(String)); dgvHangNhap.DataSource = dtHangNhap; dtHanghoa = hangHoaDAO.LayDanhSachMatHang(); dtNhomhanghoa = nhomHangHoaDAO.LayTatCaNhomHangHoa(); dtNhaCung = nhaCungCapDAO.LayDanhSachNhaCC(); cboLoaiHang.DisplayMember = "tennhomhanghoa"; cboLoaiHang.ValueMember = "manhomhanghoa"; cboLoaiHang.DataSource = dtNhomhanghoa; cboNhaCungCap.DisplayMember = "tennhacungcap"; cboNhaCungCap.ValueMember = "manhacungcap"; cboNhaCungCap.DataSource = dtNhaCung; AutoCompleteStringCollection sourceMaHang = new AutoCompleteStringCollection(); foreach (DataRow datarow in dtHanghoa.Rows) { sourceMaHang.Add(datarow["mamathang"].ToString()); } txtMaHang.AutoCompleteCustomSource = sourceMaHang; txtMaHang.AutoCompleteMode = AutoCompleteMode.Suggest; txtMaHang.AutoCompleteSource = AutoCompleteSource.CustomSource; AutoCompleteStringCollection sourceTenHang = new AutoCompleteStringCollection(); foreach (DataRow datarow in dtHanghoa.Rows) { sourceTenHang.Add(datarow["tenmathang"].ToString()); } txtTenHang.AutoCompleteCustomSource = sourceTenHang; txtTenHang.AutoCompleteMode = AutoCompleteMode.Suggest; txtTenHang.AutoCompleteSource = AutoCompleteSource.CustomSource; }
private void frmQuanLyNhaCungCap_Load(object sender, EventArgs e) { dgvNhaCC.DataSource = nhaCungCapDAO.LayDanhSachNhaCC(); }