private string GetQueryString(string query)
{
var queryJson = new LogSearchQuery()
{
Query = query,
Top = 100,
Start = new DateTime(2017, 7, 10),
End = DateTime.UtcNow
};
return(JsonConvert.SerializeObject(queryJson,
new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
}));
}
public List <UploadBarCodeLog> QueryUploadBarCodeLogModel(LogSearchQuery query)
{
try
{
return(handler.QueryUploadBarCodeLogModel(query));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "QueryUploadBarCodeLogModel", ex);
Logger.Log(Level.Error, exception, "QueryUploadBarCodeLogModel");
throw ex;
}
}
public PartialViewResult UploadBarCodeLogList(LogSearchQuery query)
{
List <UploadBarCodeLog> list = new List <UploadBarCodeLog>();
list = TireSecurityCodeConfigManager.QueryUploadBarCodeLogModel(query);
var pager = new PagerModel(query.PageIndex, query.PageDataQuantity);
ViewBag.query = query;
pager.TotalItem = query.TotalCount;
return(PartialView(new ListModel <UploadBarCodeLog>()
{
Pager = pager,
Source = list
}));
}
public IPagedList <Log> GetEntriesPaged(LogSearchQuery searchQuery)
{
using (new SiteFilterDisabler(_session))
{
IQueryOver <Log, Log> query = BaseQuery();
if (searchQuery.Type.HasValue)
{
query = query.Where(log => log.Type == searchQuery.Type);
}
if (!string.IsNullOrWhiteSpace(searchQuery.Message))
{
query =
query.Where(
log =>
log.Message.IsInsensitiveLike(searchQuery.Message, MatchMode.Anywhere));
}
if (!string.IsNullOrWhiteSpace(searchQuery.Detail))
{
query = query.Where(log => log.Detail.IsInsensitiveLike(searchQuery.Detail, MatchMode.Anywhere));
}
if (searchQuery.SiteId.HasValue)
{
query = query.Where(log => log.Site.Id == searchQuery.SiteId);
}
if (searchQuery.From.HasValue)
{
query = query.Where(log => log.CreatedOn >= searchQuery.From);
}
if (searchQuery.To.HasValue)
{
query = query.Where(log => log.CreatedOn <= searchQuery.To);
}
return(query.Paged(searchQuery.Page));
}
}
public List <UploadBarCodeLog> QueryUploadBarCodeLogModel(LogSearchQuery query)
{
Func <SqlConnection, List <UploadBarCodeLog> > action = (connection) => DalTireSecurityCodeConfig.QueryUploadBarCodeLogModel(connection, query);
return(dbManager.Execute(action));
}
public ViewResult Index(LogSearchQuery searchQuery)
{
ViewData["site-options"] = _adminService.GetSiteOptions();
ViewData["logs"] = _adminService.GetEntriesPaged(searchQuery);
return(View(searchQuery));
}
public static List <UploadSecurityCodeLog> QueryUploadSecurityCodeLogModel(SqlConnection conn, LogSearchQuery query)
{
string countSql = @"SELECT Count(1)
FROM [Configuration].dbo.UploadSecurityCodeLog WITH ( NOLOCK)";
string sql = @"SELECT *
FROM [Configuration].dbo.UploadSecurityCodeLog WITH ( NOLOCK)
ORDER BY CreateTime DESC OFFSET @pagesdata ROWS FETCH NEXT @pagedataquantity ROWS ONLY";
var sqlParam = new[]
{
new SqlParameter("@pagesdata", (query.PageIndex - 1) * query.PageDataQuantity),
new SqlParameter("@pagedataquantity", query.PageDataQuantity),
};
query.TotalCount = (int)SqlHelper.ExecuteScalar(conn, CommandType.Text, countSql, sqlParam);
return(SqlHelper.ExecuteDataTable(conn, CommandType.Text, sql, sqlParam).ConvertTo <UploadSecurityCodeLog>().ToList());
}
