public void loadData(int p)
{
try
{
Common.NhaCungCapTableAdapter.Connection = Common.CTDatHangTableAdapter.Connection = Common.NhanVienTableAdapter.Connection = Common.MatHangTableAdapter.Connection = Common.connection;
Common.NhaCungCapTableAdapter.Fill(Common.NhaCungCapDataTable);
Common.NhanVienTableAdapter.Fill(Common.NhanVienDataTable);
Common.MatHangTableAdapter.Fill(Common.MatHangDataTable);
Common.CTDatHangTableAdapter.Fill(Common.CTDatHangDataTable);
page = new Paging(Common.connection, "DatHang", "DatHangId desc");
QLVTDataSet.DatHangDataTable khos = new QLVTDataSet.DatHangDataTable();
DataTable dataTable = page.getPage(p);
if (dataTable != null)
{
khos.Merge(dataTable);
}
dgContent.ItemsSource = khos;
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, "DatHang where DatHangId = '" + txbSearch.Text + "'", "DatHangId desc");
QLVTDataSet.DatHangDataTable khos = new QLVTDataSet.DatHangDataTable();
DataTable dataTable = page.getPage(0);
if (dataTable != null)
{
khos.Merge(dataTable);
}
dgContent.ItemsSource = khos;
tblNumPage.Text = (page.currentIndex + 1) + "/" + (page.totalPage + 1);
}
