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