/// <summary>
/// 数据绑定
/// </summary>
private void BindGrid()
{
string sortField = BlacklistGrid.Columns[BlacklistGrid.SortColumnIndex].SortField;
string sortDirection = BlacklistGrid.SortDirection;
string starttime = "";
if (!string.IsNullOrEmpty(dpStartDate.Text))
{
starttime = dpStartDate.Text + " 0:00:00";
}
string endtime = "";
if (!string.IsNullOrEmpty(dpEndDate.Text))
{
endtime = dpEndDate.Text + " 23:59:59";
}
if (!string.IsNullOrEmpty(dpStartDate.Text) && !string.IsNullOrEmpty(dpEndDate.Text) && DateTime.Parse(starttime) >= DateTime.Parse(endtime))
{
FineUI.Alert.Show("结束日期必须大于等于开始日期");
return;
}
DataTable table = GetUserInfoDateTable(starttime, endtime);
DataView TableView = table.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
BlacklistGrid.DataSource = TableView;
BlacklistGrid.DataBind();
}
/// <summary>
/// 数据绑定
/// </summary>
private void BindGrid()
{
string sortField = BlacklistGrid.Columns[BlacklistGrid.SortColumnIndex].SortField;
string sortDirection = BlacklistGrid.SortDirection;
DateTime starttime = dpStartDate.SelectedDate.Value;
DateTime endtime = dpEndDate.SelectedDate.Value;
if (!string.IsNullOrEmpty(dpStartDate.Text) && !string.IsNullOrEmpty(dpEndDate.Text) && starttime >= endtime)
{
FineUI.Alert.Show("结束日期必须大于等于开始日期");
return;
}
DataTable table = GetUserInfoDateTable(starttime.ToString(), string.Format("{0} {1}", endtime.ToShortDateString(), "23:59:59"));
DataView TableView = table.DefaultView;
TableView.Sort = String.Format("{0} {1}", sortField, sortDirection);
BlacklistGrid.DataSource = TableView;
BlacklistGrid.DataBind();
}