/// <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> /// <param name="sender"></param> /// <param name="e"></param> protected void BlacklistGrid_OnPreRowDataBound(object sender, FineUI.GridPreRowEventArgs e) { LinkButtonField lbfshow = BlacklistGrid.FindColumn("BlacklistInfo") as LinkButtonField; DataRowView row = e.DataItem as DataRowView; string status = row[5].ToString(); lbfshow.OnClientClick = WindowEdit.GetShowReference("../LogManage/BlacklistInfo.aspx?id=" + row[0].ToString() + "", "黑名单详情"); }
/// <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(); }
/// <summary> /// 行绑定事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void BlacklistGrid_OnPreRowDataBound(object sender, FineUI.GridPreRowEventArgs e) { LinkButtonField lbf = BlacklistGrid.FindColumn("Blacklistdelete") as LinkButtonField; LinkButtonField lbfshow = BlacklistGrid.FindColumn("BlacklistInfo") as LinkButtonField; DataRowView row = e.DataItem as DataRowView; string status = row[6].ToString(); lbfshow.OnClientClick = WindowEdit.GetShowReference("BlacklistInfo.aspx?id=" + row[0].ToString() + "", "黑名单详情"); if (status == "已过期") { lbf.Enabled = false; lbf.Icon = FineUI.Icon.None; lbf.ToolTip = "此记录已过期"; } else { lbf.Enabled = true; lbf.Icon = FineUI.Icon.Delete; lbf.ToolTip = "读者移出黑名单"; } }