public PageModel <LogInfo> GetPlatformOperationLogs(OperationLogQuery query)
{
int num = 0;
IQueryable <LogInfo> userName = context.LogInfo.FindBy((LogInfo item) => item.ShopId == query.ShopId);
if (!string.IsNullOrWhiteSpace(query.UserName))
{
userName =
from item in userName
where query.UserName == item.UserName
select item;
}
if (query.StartDate.HasValue)
{
userName =
from item in userName
where item.Date >= query.StartDate.Value
select item;
}
if (query.EndDate.HasValue)
{
userName =
from item in userName
where item.Date <= query.EndDate.Value
select item;
}
userName = userName.GetPage(out num, query.PageNo, query.PageSize, null);
return(new PageModel <LogInfo>()
{
Models = userName,
Total = num
});
}
public async Task <PagedList <OperationLog> > GetLogsAsync(OperationLogQuery query, int pageSize, int pageIndex)
{
Sql builder = Sql.Builder;
if (!string.IsNullOrEmpty(query.Description))
{
builder.Where("OperationObjectName like @0 or Description like @0", new object[] { '%' + query.Description + '%' });
}
if (!string.IsNullOrEmpty(query.OperationType))
{
builder.Where("OperationType = @0", new object[] { query.OperationType });
}
if (!string.IsNullOrEmpty(query.Operator))
{
builder.Where("Operator like @0", new object[] { "%" + query.Operator + "%" });
}
if (query.StartDateTime.HasValue)
{
builder.Where("CreateDate >= @0", new object[] { ValueUtility.GetSafeSqlDateTime(query.StartDateTime.Value) });
}
if (query.EndDateTime.HasValue)
{
builder.Where("CreateDate <= @0", new object[] { ValueUtility.GetSafeSqlDateTime(query.EndDateTime.Value) });
}
if (query.OperatorUserId.HasValue)
{
builder.Where("OperatorUserId = @0", new object[] { query.OperatorUserId.Value });
}
if (!string.IsNullOrEmpty(query.Source))
{
builder.Where("Source like @0", new object[] { "%" + query.Source + "%" });
}
builder.OrderBy(new object[] { "Id desc" });
return(await GetPagingEntitiesAsync(pageSize, pageIndex, builder));
}
private OperationLogQuery GetOperationLogQuery()
{
OperationLogQuery query = new OperationLogQuery();
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["OperationUserName"]))
{
query.OperationUserName = base.Server.UrlDecode(this.Page.Request.QueryString["OperationUserName"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["Description"]))
{
query.Description = base.Server.UrlDecode(this.Page.Request.QueryString["Description"]);
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["FromDate"]))
{
query.FromDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Request.QueryString["FromDate"]));
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["ToDate"]))
{
query.ToDate = new System.DateTime?(System.Convert.ToDateTime(this.Page.Request.QueryString["ToDate"]));
}
query.Page.PageIndex = this.pager.PageIndex;
query.Page.PageSize = this.pager.PageSize;
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["SortBy"]))
{
query.Page.SortBy = this.Page.Request.QueryString["SortBy"];
}
if (!string.IsNullOrEmpty(this.Page.Request.QueryString["SortOrder"]))
{
query.Page.SortOrder = SortAction.Desc;
}
return(query);
}
public DbQueryResult GetLogs(OperationLogQuery query)
{
StringBuilder builder = new StringBuilder();
Pagination page = query.Page;
if (query.FromDate.HasValue)
{
builder.AppendFormat("AddedTime >= '{0}'", DataHelper.GetSafeDateTimeFormat(query.FromDate.Value));
}
if (query.ToDate.HasValue)
{
if (!string.IsNullOrEmpty(builder.ToString()))
{
builder.Append(" AND");
}
builder.AppendFormat(" AddedTime <= '{0}'", DataHelper.GetSafeDateTimeFormat(query.ToDate.Value));
}
if (!string.IsNullOrEmpty(query.OperationUserName))
{
if (!string.IsNullOrEmpty(builder.ToString()))
{
builder.Append(" AND");
}
builder.AppendFormat(" UserName = '******'", DataHelper.CleanSearchString(query.OperationUserName));
}
return(DataHelper.PagingByTopsort(page.PageIndex, page.PageSize, page.SortBy, page.SortOrder, page.IsCount, "Hishop_Logs", "LogId", builder.ToString(), "*"));
}
public QueryPageModel <LogInfo> GetPlatformOperationLogs(OperationLogQuery query)
{
var logs = DbFactory.Default.Get <LogInfo>().Where(item => item.ShopId == query.ShopId);
if (!string.IsNullOrWhiteSpace(query.UserName))
{
logs.Where(item => query.UserName == item.UserName);
}
if (query.StartDate.HasValue)
{
logs.Where(item => item.Date >= query.StartDate.Value);
}
if (query.EndDate.HasValue)
{
var end = query.EndDate.Value.AddDays(1);
logs.Where(item => item.Date <= end);
}
var rets = logs.OrderByDescending(o => o.Id).ToPagedList(query.PageNo, query.PageSize);
QueryPageModel <LogInfo> pageModel = new QueryPageModel <LogInfo>()
{
Models = rets, Total = rets.TotalRecordCount
};
return(pageModel);
}
private void GetList(HttpContext context)
{
int num = 1;
int num2 = 10;
num = base.GetIntParam(context, "page", false).Value;
if (num < 1)
{
num = 1;
}
num2 = base.GetIntParam(context, "rows", false).Value;
if (num2 < 1)
{
num2 = 10;
}
OperationLogQuery operationLogQuery = new OperationLogQuery();
operationLogQuery.OperationUserName = context.Request["OperationUserName"];
operationLogQuery.FromDate = base.GetDateTimeParam(context, "FromDate");
operationLogQuery.ToDate = base.GetDateTimeParam(context, "ToDate");
if (operationLogQuery.ToDate.HasValue && operationLogQuery.ToDate.HasValue)
{
operationLogQuery.ToDate = (operationLogQuery.ToDate.Value.ToString("yyyy-MM-dd") + " 23:59:59").ToDateTime();
}
operationLogQuery.Page.SortBy = context.Request["SortBy"];
operationLogQuery.Page.SortOrder = SortAction.Desc;
operationLogQuery.Page.PageIndex = num;
operationLogQuery.Page.PageSize = num2;
DataGridViewModel <Dictionary <string, object> > dataList = this.GetDataList(operationLogQuery);
string s = base.SerializeObjectToJson(dataList);
context.Response.Write(s);
context.Response.End();
}
public void BindLogs()
{
OperationLogQuery operationLogQuery = this.GetOperationLogQuery();
DbQueryResult logs = EventLogs.GetLogs(operationLogQuery);
this.dlstLog1.DataSource = logs.Data;
this.dlstLog1.DataBind();
this.SetSearchControl();
this.pager.TotalRecords = logs.TotalRecords;
}
/// <summary>
/// 根据DiscussQuestionQuery查询获取可分页的数据集合
/// </summary>
/// <param name="query">OperationLog查询对象</param>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页码(从1开始)</param>
public PagingDataSet <OperationLogEntry> GetLogs(OperationLogQuery query, int pageSize, int pageIndex)
{
var sql = PetaPoco.Sql.Builder;
if (query.ApplicationId.HasValue)
{
sql.Where("ApplicationId = @0", query.ApplicationId);
}
if (!string.IsNullOrEmpty(query.Keyword))
{
sql.Where("OperationObjectName like @0 or Description like @0", '%' + query.Keyword + '%');
}
if (!string.IsNullOrEmpty(query.OperationType))
{
sql.Where("OperationType = @0", query.OperationType);
}
if (!string.IsNullOrEmpty(query.Operator))
{
sql.Where("Operator like @0", "%" + query.Operator + "%");
}
if (query.StartDateTime.HasValue)
{
sql.Where("DateCreated >= @0", query.StartDateTime.Value);
}
if (query.EndDateTime.HasValue)
{
sql.Where("DateCreated <= @0", query.EndDateTime.Value);
}
if (query.OperatorUserId.HasValue)
{
sql.Where("OperatorUserId = @0", query.OperatorUserId.Value);
}
if (!string.IsNullOrEmpty(query.Source))
{
sql.Where("Source like @0", "%" + query.Source + "%");
}
sql.OrderBy("Id desc");
PagingEntityIdCollection peic = CreateDAO().FetchPagingPrimaryKeys <OperationLogEntry>(PrimaryMaxRecords, pageSize, pageIndex, sql);
IEnumerable <OperationLogEntry> entitiesOfPage = PopulateEntitiesByEntityIds(peic.GetPagingEntityIds(pageSize, pageIndex));
PagingDataSet <OperationLogEntry> pagingEntities = new PagingDataSet <OperationLogEntry>(entitiesOfPage)
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalRecords = peic.TotalRecords
};
return(pagingEntities);
}
private DataGridViewModel <Dictionary <string, object> > GetDataList(OperationLogQuery query)
{
DataGridViewModel <Dictionary <string, object> > dataGridViewModel = new DataGridViewModel <Dictionary <string, object> >();
if (query != null)
{
DbQueryResult logs = EventLogs.GetLogs(query);
dataGridViewModel.rows = DataHelper.DataTableToDictionary(logs.Data);
dataGridViewModel.total = logs.TotalRecords;
foreach (Dictionary <string, object> row in dataGridViewModel.rows)
{
}
}
return(dataGridViewModel);
}
public JsonResult List(int page, string userName, int rows, DateTime?startDate, DateTime?endDate)
{
OperationLogQuery operationLogQuery = new OperationLogQuery()
{
UserName = userName,
PageNo = page,
PageSize = rows,
StartDate = startDate,
EndDate = endDate
};
PageModel <LogInfo> platformOperationLogs = ServiceHelper.Create <IOperationLogService>().GetPlatformOperationLogs(operationLogQuery);
var list =
from item in platformOperationLogs.Models.ToList()
select new { Id = item.Id, UserName = item.UserName, PageUrl = item.PageUrl, Description = item.Description, Date = item.Date.ToString("yyyy-MM-dd HH:mm"), IPAddress = item.IPAddress };
return(Json(new { rows = list, total = platformOperationLogs.Total }));
}
public JsonResult List(int page, string userName, int rows, DateTime?startDate, DateTime?endDate)
{
var query = new OperationLogQuery()
{
UserName = userName, PageNo = page, ShopId = CurrentSellerManager.ShopId, PageSize = rows, StartDate = startDate, EndDate = endDate
};
var result = _iOperationLogService.GetPlatformOperationLogs(query);
var logs = result.Models.ToList().Select(item => new
{
Id = item.Id,
UserName = item.UserName,
PageUrl = item.PageUrl,
Description = item.Description,
Date = item.Date.ToString("yyyy-MM-dd HH:mm"),
IPAddress = item.IPAddress
});
var model = new { rows = logs, total = result.Total };
return(Json(model));
}
public PagingDataSet <OperationLogEntry> GetLogs(OperationLogQuery query, int pageSize, int pageIndex)
{
Sql builder = Sql.Builder;
if (query.ApplicationId.HasValue)
{
builder.Where("ApplicationId = @0", new object[]
{
query.ApplicationId
});
}
if (!string.IsNullOrEmpty(query.Keyword))
{
builder.Where("OperationObjectName like @0 or Description like @0", new object[]
{
'%' + query.Keyword + '%'
});
}
if (!string.IsNullOrEmpty(query.OperationType))
{
builder.Where("OperationType = @0", new object[]
{
query.OperationType
});
}
if (!string.IsNullOrEmpty(query.Operator))
{
builder.Where("Operator like @0", new object[]
{
"%" + query.Operator + "%"
});
}
if (query.StartDateTime.HasValue)
{
builder.Where("DateCreated >= @0", new object[]
{
query.StartDateTime.Value
});
}
if (query.EndDateTime.HasValue)
{
builder.Where("DateCreated <= @0", new object[]
{
query.EndDateTime.Value
});
}
if (query.OperatorUserId.HasValue)
{
builder.Where("OperatorUserId = @0", new object[]
{
query.OperatorUserId.Value
});
}
if (!string.IsNullOrEmpty(query.Source))
{
builder.Where("Source like @0", new object[]
{
"%" + query.Source + "%"
});
}
builder.OrderBy(new object[]
{
"Id desc"
});
PagingEntityIdCollection pagingEntityIdCollection = this.CreateDAO().FetchPagingPrimaryKeys <OperationLogEntry>((long)this.PrimaryMaxRecords, pageSize, pageIndex, builder);
System.Collections.Generic.IEnumerable <OperationLogEntry> entities = this.PopulateEntitiesByEntityIds <object>(pagingEntityIdCollection.GetPagingEntityIds(pageSize, pageIndex));
return(new PagingDataSet <OperationLogEntry>(entities)
{
PageIndex = pageIndex,
PageSize = pageSize,
TotalRecords = pagingEntityIdCollection.TotalRecords
});
}
public abstract DbQueryResult GetLogs(OperationLogQuery query);
/// <summary>
/// 根据查询条件分页获取操作日志信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static ObsoletePageModel <LogInfo> GetPlatformOperationLogs(OperationLogQuery query)
{
return(_iOperationLogService.GetPlatformOperationLogs(query));
}
public static DbQueryResult GetLogs(OperationLogQuery query)
{
return(new LogDao().GetLogs(query));
}
public static DbQueryResult GetLogs(OperationLogQuery query)
{
return(StoreProvider.Instance().GetLogs(query));
}
/// <summary>
/// 根据查询条件分页获取操作日志信息
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public static QueryPageModel <Entities.LogInfo> GetPlatformOperationLogs(OperationLogQuery query)
{
return(_iOperationLogService.GetPlatformOperationLogs(query));
}
/// <summary>
/// 展示页面
/// </summary>
/// <param name="Source">来源</param>
/// <param name="Operator">操作人（可以模糊搜索）</param>
/// <param name="Keyword">操作说明(搜索操作对象)</param>
/// <param name="StartDateTime">开始时间</param>
/// <param name="EndDateTime">结束时间</param>
/// <param name="pageSize">页大小</param>
/// <param name="pageIndex">页码</param>
/// <returns></returns>
public ActionResult ManageOperationLogs(string Source, string Operator, string Keyword, DateTime? StartDateTime, DateTime? EndDateTime, int pageSize = 20, int pageIndex = 1)
{
//实例化检索器
OperationLogQuery query = new OperationLogQuery();
query.Source = Source;
query.Operator = Operator;
query.Keyword = Keyword;
query.StartDateTime = StartDateTime;
//如果结束时间不为空则加一天
if (EndDateTime != null)
query.EndDateTime = EndDateTime.Value.AddDays(1);
//获取检索后实体数组
PagingDataSet<OperationLogEntry> logs = logService.GetLogs(query, pageSize, pageIndex);
return View(logs);
}
