public IActionResult Search(SchedulePostModel model)
{
IQueryable <TaskScheduleModel> query = null;
query = query.AddStringContainsFilter(o => o.Name, model.Name);
query = query.AddStringContainsFilter(o => o.Group, model.Group);
query = query.AddStringContainsFilter(o => o.Url, model.Url);
query = query.AddStringContainsFilter(o => o.CronExpression, model.Cron);
query = query.AddDateTimeBetweenFilter(model.StartTime, model.EndTime, o => o.StartTime);
query = query.AddDateTimeBetweenFilter(model.StartTime, model.EndTime, o => o.EndTime);
var list = query.ToList();
list = this.GetAllJobAsync(list).Result;
ScheduleGridConfiguration <TaskScheduleModel> grid = new ScheduleGridConfiguration <TaskScheduleModel>(list);
return(this.HtmlResult(grid.Render()));
}
public IQueryable <Entity.User> GenerateQuery(IQueryable <Entity.User> query)
{
query = query.AddFilter(o => o.UserRoleMapping.Any(x => x.RoleId == this.RoleId), this.RoleId);
query = query.AddFilter(o => o.IsEnable == this.IsEnable, this.IsEnable);
query = query.AddFilter(o => o.IsLocked, this.IsLocked);
query = query.AddFilter(o => o.DisplayName.Contains(this.DisplayName), this.DisplayName);
query = query.AddFilter(o => o.LoginName.Contains(this.LoginName), this.LoginName);
query = query.AddDateTimeBetweenFilter(this.StartCreateTime, this.EndCreateTime, o => o.CreateTime);
query = query.OrderByDescending(o => o.CreateTime);
return(query);
}
public IActionResult Search(MenuPostModel model)
{
using (this.DbContext)
{
IQueryable <Menu> query = this.DbContext.Menu.AsNoTracking();
query = query.AddStringContainsFilter(o => o.Name, model.Name);
query = query.AddStringContainsFilter(o => o.Description, model.Description);
query = query.AddFilter(o => o.Status, model.Status);
query = query.AddDateTimeBetweenFilter(model.StartCreateTime, model.EndCreateTime, o => o.CreateTime);
query = query.OrderByDescending(o => o.CreateTime);
return(this.StandardSearchResponse(query, model, MenuModel.Convert));
}
}
public IActionResult Search(LogPostModel model)
{
using (this.DbContext)
{
IQueryable <Log> query = this.DbContext.Log.AsNoTracking();
query = query.AddFilter(o => o.LogLevel == (int?)model.LogLevel, model.LogLevel);
query = query.AddFilter(o => o.SqlOperateType == (int?)model.SqlType, model.SqlType);
query = query.AddFilter(o => o.Message.Contains(model.Message), model.Message);
query = query.AddDateTimeBetweenFilter(model.StartTime, model.EndTime, o => o.CreateTime);
query = query.OrderByDescending(o => o.CreateTime);
return(this.StandardSearchResponse(query, model, LogModel.Convert));
}
}
public IActionResult Search(RolePostModel model)
{
using (this.DbContext)
{
IQueryable <Role> query = this.DbContext.Role.AsNoTracking();
query = query.AddStringContainsFilter(o => o.Name, model.RoleName);
query = query.AddStringContainsFilter(o => o.Description, model.Description);
query = query.AddDateTimeBetweenFilter(model.StartCreateTime, model.EndCreateTime, o => o.CreateTime);
query = query.OrderBy(o => o.IsForbidden).ThenByDescending(o => o.CreateTime);
if (model.PageIndex < 1)
{
model.PageIndex = 1;
}
return(this.StandardSearchResponse(query, model, RoleModel.Convert));
}
}
