/// <summary> /// 日志列表 /// </summary> /// <param name="pagination">分页</param> /// <param name="queryJson">查询参数</param> /// <returns></returns> public IEnumerable <LogEntity> GetPageList(Pagination pagination, string queryJson) { var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Log where 1=1"); var queryParam = queryJson.ToJObject(); //日志分类 if (!queryParam["Category"].IsEmpty()) { int categoryId = queryParam["CategoryId"].ToInt(); sql.Append(" and CategoryId=@0", categoryId); } //操作时间 if (!queryParam["StartTime"].IsEmpty() && !queryParam["EndTime"].IsEmpty()) { DateTime startTime = queryParam["StartTime"].ToDate(); DateTime endTime = queryParam["EndTime"].ToDate().AddDays(1); sql.Append(" and OperateTime>=@0", startTime); sql.Append(" and OperateTime<=@0", endTime); } //操作用户Id if (!queryParam["OperateUserId"].IsEmpty()) { string operateUserId = queryParam["OperateUserId"].ToString(); sql.Append(" and OperateUserId=@0", operateUserId); } //操作用户账户 if (!queryParam["OperateAccount"].IsEmpty()) { string OperateAccount = queryParam["OperateAccount"].ToString(); sql.Append(" and (charindex(@0,OperateAccount)>0)", OperateAccount); } //操作类型 if (!queryParam["OperateType"].IsEmpty()) { string operateType = queryParam["OperateType"].ToString(); sql.Append(" and OperateType=@0", operateType); } //功能模块 if (!queryParam["Module"].IsEmpty()) { string module = queryParam["Module"].ToString(); sql.Append(" and (charindex(@0,Module)>0)", module); } if (!string.IsNullOrWhiteSpace(pagination.sidx)) { sql.OrderBy(new object[] { pagination.sidx + " " + pagination.sord }); } var currentpage = Base_Log.Page(pagination.page, pagination.rows, sql); //数据对象 var pageList = currentpage.Items; //分页对象 pagination.records = Converter.ParseInt32(currentpage.TotalItems); return(EntityConvertTools.CopyToList <Base_Log, LogEntity>(pageList)); }