public void loadData(int p)
{
try
{
Common.CTHoaDonTableAdapter.Connection = Common.KhoTableAdapter.Connection = Common.KhachHangTableAdapter.Connection = Common.MatHangTableAdapter.Connection = Common.connection;
Common.CTHoaDonTableAdapter.Fill(Common.CTHoaDonDataTable);
Common.KhoTableAdapter.Fill(Common.KhoDataTable);
Common.KhachHangTableAdapter.Fill(Common.KhachHangDataTable);
Common.MatHangTableAdapter.Fill(Common.MatHangDataTable);
page = new Paging(Common.connection, "HoaDon", "HoaDonId desc");
QLVTDataSet.HoaDonDataTable hds = new QLVTDataSet.HoaDonDataTable();
DataTable dataTable = page.getPage(p);
if (dataTable != null)
{
hds.Merge(dataTable);
}
dgContent.ItemsSource = hds;
tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
page = new Paging(Common.connection, "HoaDon where HoaDonId = '" + txbSearch.Text + "'", "HoaDonId desc");
QLVTDataSet.HoaDonDataTable hds = new QLVTDataSet.HoaDonDataTable();
DataTable dataTable = page.getPage(0);
if (dataTable != null)
{
hds.Merge(dataTable);
}
dgContent.ItemsSource = hds;
//tableLog = new DataTableLog((DataTable)khos);
tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
}