private int GetRecordCount() { #region 得到日志记录数 if (ViewState["condition"] == null) { return(AdminMedalLogs.RecordCount()); } else { return(AdminMedalLogs.RecordCount(ViewState["condition"].ToString())); } #endregion }
private void SearchLog_Click(object sender, EventArgs e) { #region 指定查询条件搜索日志信息 if (this.CheckCookie()) { string sqlstring = AdminMedalLogs.GetSearchMedalLogCondition(postdatetimeStart.SelectedDate, postdatetimeEnd.SelectedDate, Username.Text, reason.Text); ViewState["condition"] = sqlstring; DataGrid1.CurrentPageIndex = 0; BindData(); } #endregion }
public void BindData() { #region 数据绑定 DataGrid1.AllowCustomPaging = true; DataGrid1.VirtualItemCount = GetRecordCount(); if (ViewState["condition"] == null) { DataGrid1.DataSource = AdminMedalLogs.LogList(DataGrid1.PageSize, DataGrid1.CurrentPageIndex + 1); } else { DataGrid1.DataSource = AdminMedalLogs.LogList(DataGrid1.PageSize, DataGrid1.CurrentPageIndex + 1, ViewState["condition"].ToString()); } DataGrid1.DataBind(); #endregion }
private void DelRec_Click(object sender, EventArgs e) { #region 除指定条件的日志信息 if (this.CheckCookie()) { string condition = ""; condition = AdminMedalLogs.GetDelMedalLogCondition(Request.Form["deleteMode"].ToString(), DNTRequest.GetString("id").ToString(), deleteNum.Text.ToString(), deleteFrom.SelectedDate.ToString()); if (condition != "") { AdminMedalLogs.DeleteLog(condition); Response.Redirect("forum_medalsloggird.aspx"); } else { base.RegisterStartupScript("", "<script>alert('您未选中任何选项或输入参数错误!');window.location.href='forum_medalsloggird.aspx';</script>"); } } #endregion }
private void DelRec_Click(object sender, EventArgs e) { #region 删除指定条件的日志信息 if (this.CheckCookie()) { string condition = ""; //switch (Request.Form["deleteMode"]) //{ // case "chkall": // if (DNTRequest.GetString("id") != "") // condition = " [id] IN(" + DNTRequest.GetString("id") + ")"; // break; // case "deleteNum": // if (deleteNum.Text != "" && Utils.IsNumeric(deleteNum.Text)) // condition = " [id] not in (select top " + deleteNum.Text + " [id] from [" + BaseConfigs.GetTablePrefix + "medalslog] order by [id] desc)"; // break; // case "deleteFrom": // if (deleteFrom.SelectedDate.ToString() != "") // condition = " [postdatetime]<'" + deleteFrom.SelectedDate.ToString() + "'"; // break; //} condition = DatabaseProvider.GetInstance().DelMedalLogCondition(Request.Form["deleteMode"].ToString(), DNTRequest.GetString("id").ToString(), deleteNum.Text.ToString(), deleteFrom.SelectedDate.ToString()); if (condition != "") { AdminMedalLogs.DeleteLog(condition); Response.Redirect("forum_medalsloggird.aspx"); } else { base.RegisterStartupScript( "", "<script>alert('您未选中任何选项或输入参数错误!');window.location.href='forum_medalsloggird.aspx';</script>"); } } #endregion }