132 lines
4.1 KiB
C#
132 lines
4.1 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Web;
|
|
using System.Web.UI;
|
|
using System.Web.UI.WebControls;
|
|
using System.Text;
|
|
using Telerik.Web.UI;
|
|
|
|
namespace VRS.Util
|
|
{
|
|
public partial class Logs : BaseListPage
|
|
{
|
|
DataService.BLL.admin_log bll = new DataService.BLL.admin_log();
|
|
|
|
protected override void Page_Load(object sender, EventArgs e)
|
|
{
|
|
if (!IsPostBack)
|
|
{
|
|
start.SelectedDate = DateTime.Today.AddDays(-2);
|
|
end.SelectedDate = DateTime.Today;
|
|
DataLoad();
|
|
}
|
|
}
|
|
|
|
protected override void DataLoad()
|
|
{
|
|
if (!start.SelectedDate.HasValue)
|
|
{
|
|
RadAjaxManager1.Alert("请选择开始日期！");
|
|
return;
|
|
}
|
|
if (!end.SelectedDate.HasValue)
|
|
{
|
|
RadAjaxManager1.Alert("请选择结束日期！");
|
|
return;
|
|
}
|
|
|
|
|
|
|
|
var dtStart = start.SelectedDate.Value;
|
|
var dtEnd = end.SelectedDate.Value;
|
|
TimeSpan sp = dtEnd.Subtract(dtStart);
|
|
//if (sp.Days > 180)
|
|
//{
|
|
// RadAjaxManager1.Alert("查询日期间隔不超过半年！");
|
|
// return;
|
|
//}
|
|
|
|
var query = new StringBuilder(" 1 = 1 ");
|
|
if (!string.IsNullOrWhiteSpace(content.Text.Trim()))
|
|
{
|
|
//query.AppendFormat(" AND ( content LIKE '%{0}%' or login_name LIKE '%{0}%' )", content.Text.Trim());
|
|
query.AppendFormat(" AND ( content LIKE '%{0}%' )", content.Text.Trim());
|
|
}
|
|
var start_date = start.SelectedDate.HasValue ? start.SelectedDate.Value.ToString("yyyy-MM-dd") : "";
|
|
var end_date = end.SelectedDate.HasValue ? end.SelectedDate.Value.ToString("yyyy-MM-dd") : "";
|
|
|
|
if (!string.IsNullOrEmpty(start_date))
|
|
{
|
|
query.AppendFormat(" and create_time>='{0}' ", start_date);
|
|
}
|
|
if (!string.IsNullOrEmpty(end_date))
|
|
{
|
|
DateTime dt;
|
|
if (DateTime.TryParse(end_date, out dt))
|
|
{
|
|
query.AppendFormat(" and create_time<'{0}' ", dt.AddDays(1).ToString("yyyy-MM-dd"));
|
|
}
|
|
}
|
|
|
|
|
|
|
|
var data = bll.GetModelList(query.ToString()).OrderByDescending(s => s.create_time).ToList();
|
|
dataList.DataSource = data;
|
|
dataList.Rebind();
|
|
}
|
|
|
|
protected override void GridList_PageIndexChanged(object sender, GridPageChangedEventArgs e)
|
|
{
|
|
DataLoad();
|
|
}
|
|
|
|
protected override void GridList_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
|
|
{
|
|
DataLoad();
|
|
}
|
|
|
|
protected override void GridList_SortCommand(object sender, GridSortCommandEventArgs e)
|
|
{
|
|
DataLoad();
|
|
}
|
|
|
|
protected override void GrdList_DeleteCommand(object sender, GridCommandEventArgs e)
|
|
{
|
|
string Id = (e.Item as GridDataItem).OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString();
|
|
bll.Delete(Id);
|
|
DataLoad();
|
|
}
|
|
|
|
protected override void AjaxManager_AjaxRequest(object sender, AjaxRequestEventArgs e)
|
|
{
|
|
|
|
}
|
|
|
|
protected void btnSelect_Click(object sender, EventArgs e)
|
|
{
|
|
DataLoad();
|
|
}
|
|
|
|
|
|
protected void btnClear_Click(object sender, EventArgs e)
|
|
{
|
|
var count = bll.clear_log();
|
|
RadAjaxManager1.Alert("共清理" + count + "条日志！");
|
|
if (count > 0)
|
|
{
|
|
DataLoad();
|
|
}
|
|
}
|
|
|
|
protected void dataList_ItemDataBound(object sender, GridItemEventArgs e)
|
|
{
|
|
if (e.Item is GridDataItem)
|
|
{
|
|
GridDataItem item = e.Item as GridDataItem;
|
|
Label lbno = e.Item.FindControl("lbno") as Label;
|
|
lbno.Text = (e.Item.ItemIndex + 1).ToString();
|
|
}
|
|
}
|
|
}
|
|
} |