void ReleaseDesignerOutlets()
{
if (ButtonQuery != null)
{
ButtonQuery.Dispose();
ButtonQuery = null;
}
if (ImageCollection != null)
{
ImageCollection.Dispose();
ImageCollection = null;
}
if (LabelResults != null)
{
LabelResults.Dispose();
LabelResults = null;
}
if (ProgressBar != null)
{
ProgressBar.Dispose();
ProgressBar = null;
}
if (TextFieldSearch != null)
{
TextFieldSearch.Dispose();
TextFieldSearch = null;
}
}
/// <summary>
/// 分页获取按钮列表
/// </summary>
/// <param name="baseQuery"></param>
/// <param name="Total"></param>
/// <returns></returns>
public (List <ButtonViewMoel>, int) GetQueryByPage(ButtonQuery buttonQuery)
{
var query = ExpressionBuilder.True <SysButton>();
query = query.And(menu => menu.IsDrop == false);
var menuquery = ExpressionBuilder.True <SysMenu>();
menuquery = menuquery.And(menu => menu.IsDrop == false);
if (!buttonQuery.Name.IsNullOrEmpty())
{
query = query.And(m => m.Name.Contains(buttonQuery.Name.Trim()));
}
if (!buttonQuery.JSKeyCode.IsNullOrEmpty())
{
query = query.And(m => m.KeyCode.Contains(buttonQuery.JSKeyCode.Trim()));
}
if (!buttonQuery.APIAddress.IsNullOrEmpty())
{
query = query.And(m => m.APIAddress.Contains(buttonQuery.APIAddress.Trim()));
}
if (!buttonQuery.MenuName.IsNullOrEmpty())
{
menuquery = menuquery.And(m => m.Name.Contains(buttonQuery.MenuName.Trim()));
}
var list = (from a in _buttonRepositoty.GetAll(query)
join b in _menuRepositoty.GetAll(menuquery) on a.MenuId equals b.Id
select new ButtonViewMoel
{
Id = a.Id,
Name = a.Name,
APIAddress = a.APIAddress,
KeyCode = a.KeyCode,
Memo = a.Memo,
ButtonStyle = a.ButtonStyle,
IsShow = a.IsShow,
CreatedDate = a.CreatedDate,
MenuId = b.Id,
MenuName = b.Name,
});
int Total = list.Count();//查询符合添加的总数执行一次
//添加排序
OrderCondition <ButtonViewMoel>[] orderConditions = new OrderCondition <ButtonViewMoel>[]
{
new OrderCondition <ButtonViewMoel>(x => x.CreatedDate, SortDirectionEnum.Descending)
};
Parameters parameters = new Parameters();
parameters.PageIndex = buttonQuery.PageIndex;
parameters.PageSize = buttonQuery.PageSize;
parameters.OrderConditions = orderConditions;
return(list.PageBy(parameters).ToList(), Total); //再查询符合条件的数据在查一次
}
public async Task <ButtonCollection> List(ButtonQuery query)
{
var dbQuery = await query.Create(this.Entities);
var total = await dbQuery.CountAsync();
dbQuery = dbQuery.Skip(query.SkipTo(total)).Take(query.Limit);
var results = await dbQuery.ToListAsync();
return(new ButtonCollection(query, total, results.Select(i => mapper.MapButton(i, new Button()))));
}
public MessageModel <PageModel <ButtonViewMoel> > GetButtonByPage([FromQuery] ButtonQuery buttonQuery)
{
var role = RoleIds;
var list = _buttonServer.GetQueryByPage(buttonQuery);
return(new MessageModel <PageModel <ButtonViewMoel> >()
{
success = true,
msg = "数据获取成功",
response = new PageModel <ButtonViewMoel>()
{
TotalCount = list.Item2,
data = list.Item1,
}
});
}
/// <summary>
/// 分页获取按钮列表
/// </summary>
/// <param name="baseQuery"></param>
/// <param name="Total"></param>
/// <returns></returns>
public (List <ButtonViewMoel>, int) GetQueryByPage(ButtonQuery buttonQuery)
{
var query = ExpressionBuilder.True <SysButton>();
query = query.And(menu => menu.IsDrop == false);
var menuquery = ExpressionBuilder.True <SysMenu>();
menuquery = menuquery.And(menu => menu.IsDrop == false);
if (!buttonQuery.Name.IsNullOrEmpty())
{
query = query.And(m => m.Name.Contains(buttonQuery.Name.Trim()));
}
if (!buttonQuery.JSKeyCode.IsNullOrEmpty())
{
query = query.And(m => m.KeyCode.Contains(buttonQuery.JSKeyCode.Trim()));
}
if (!buttonQuery.APIAddress.IsNullOrEmpty())
{
query = query.And(m => m.APIAddress.Contains(buttonQuery.APIAddress.Trim()));
}
if (!buttonQuery.MenuName.IsNullOrEmpty())
{
menuquery = menuquery.And(m => m.Name.Contains(buttonQuery.MenuName.Trim()));
}
var list = (from a in _buttonRepositoty.GetAll(query)
join b in _menuRepositoty.GetAll(menuquery) on a.MenuId equals b.Id
select new ButtonViewMoel
{
Id = a.Id,
Name = a.Name,
APIAddress = a.APIAddress,
KeyCode = a.KeyCode,
Memo = a.Memo,
ButtonStyle = a.ButtonStyle,
IsShow = a.IsShow,
CreatedDate = a.CreatedDate,
MenuId = b.Id,
MenuName = b.Name,
});
int Total = list.Count(); //查询符合添加的总数执行一次
return(list.PageBy(buttonQuery.PageSize, buttonQuery.PageSize * (buttonQuery.PageIndex - 1)).ToList(), Total); //再查询符合条件的数据在查一次
}
public async Task <ButtonCollection> List([FromQuery] ButtonQuery query)
{
return(await repo.List(query));
}
