private async void loadBan() { picBoxLoadingTable.Show(); picBoxLoadingTable.Update(); OptimizedPerformance.fromTableToDgv(await objBan.loadTableBan(), dgvban, "ban"); picBoxLoadingTable.Hide(); }
private async void loadNhanVien(String input) { picBoxLoadingStaff.Show(); picBoxLoadingStaff.Update(); DataTable table = await objNhanVien.loadTableNhanVien(input, cbbtimtheonhanvien.Text); OptimizedPerformance.fromTableToDgv(table, dgvnhanvien, "nhanvien"); picBoxLoadingStaff.Hide(); }
//-------------------------------------------- #region Khách hàng public async void loadKhachHang(string input) { picBoxKhachHang.Show(); picBoxKhachHang.Update(); DataTable table = await new KhachHang().loadTableKhachHang(input, cbbtimtheokh.Text); OptimizedPerformance.fromTableToDgv(table, dgvKhachhang, "khachhang"); picBoxKhachHang.Hide(); }
private async void loadMonan(String input = "") { picBoxLoadingFoods.Show(); picBoxLoadingFoods.Update(); if (String.IsNullOrWhiteSpace(input)) { String query = "select * from monan"; DataTable table = await ConnectDataBase.SessionConnect.executeQueryAsync(query); OptimizedPerformance.fromTableToDgv(table, dgvmonan, "monan"); } else { String query = ""; if (cbbtimtheomonan.Text.Contains("Tên")) { query = "select * from monan where tenmon like N'%" + input.Trim() + "%'"; } else if (cbbtimtheomonan.Text.Contains("Mã")) { query = "select * from monan where mamon like '%" + input.Trim() + "%'"; } DataTable table = await ConnectDataBase.SessionConnect.executeQueryAsync(query); OptimizedPerformance.fromTableToDgv(table, dgvmonan, "monan"); } for (int i = 0; i < dgvmonan.Columns.Count; i++) { if (dgvmonan.Columns[i] is DataGridViewImageColumn) { ((DataGridViewImageColumn)dgvmonan.Columns[i]).ImageLayout = DataGridViewImageCellLayout.Zoom; break; } } picBoxLoadingFoods.Hide(); }