/// <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(); }