private void updateAccessDB()
{
//dgvAccessInfo.DataSource = m_accessDB.GetAccessInfoDBTable(m_user.Id);
dgvAccessInfo.DataSource = m_accessDB.GetAccessInfoDBTable(m_user.Id, currentPage, GetPageCount());
dgvAccessInfo.Refresh();
total = Int32.Parse(dgvAccessInfo.Rows[0].Cells["count"].Value.ToString());
}
private void RebindGridForPageChange(string keyword)
{
total = 0;
try
{
DataTable tmp;
if (tabAvg.IsSelected)
{
tmp = m_avrMgr.SelectAccessHistoryInfo(dtpAvgDate.SelectedDate.Value);
dgvAvgInfo.ItemsSource = tmp.DefaultView;
}
else if (tabAccess.IsSelected)
{
//dt = m_userDB.GetUserDBTable(keyword, currentPage, GetPageCount());
//dgvAccessUser.DataSource = dt;
//dgvAccessUser.Refresh();
//total = Int32.Parse(dgvAccessUser.Rows[0].Cells["count"].Value.ToString());
tmp = m_accessDB.GetAccessInfoDBTable(m_user.Id, currentPage, GetPageCount());
dgvAccessInfo.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[6].ToString());
}
else if (tabUser.IsSelected)
{
tmp = m_userDB.GetUserDBTable(keyword, currentPage, GetPageCount());
dgvUser.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[6].ToString());
}
else if (tabCar.IsSelected)
{
tmp = m_carDB.GetCarInfoDBTable(keyword, currentPage, GetPageCount());
dgvCar.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[3].ToString());
}
else if (tabHistory.IsSelected)
{
tmp = m_historyDB.GetAccessHisDBTable(keyword, currentPage, GetPageCount());
dgvHistory.ItemsSource = tmp.DefaultView;
Total = Int32.Parse(tmp.Rows[0].ItemArray[5].ToString());
}
pageTotal = Convert.ToInt32(Math.Ceiling(Total * 1.0 / ((GetPageCount()) < 1 ? 1 : GetPageCount())));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}