/// <summary>
/// 条件查询
/// </summary>
/// <param name="input"></param>
/// <returns></returns>
public async Task <PageOutput <TView> > QueryAsync(ObjFilterInput input)
{
var query = _repository.Select <TView>().QueryByGroupInput(input.Condition);
var total = await query.CountAsync();
var page = PageInput.Convert(total, input.Page, _orderMap);
var data = await query.QueryByPageInput(page).ToArrayAsync();
return(PageOutput.Convert(total, page, data));
}
public async Task ObjQueryAsyncTest()
{
var input = new ObjFilterInput
{
Condition = new GroupInput
{
Logic = ConstantOptions.LogicConstant.And,
Items = new ItemInput[]
{
new ItemInput
{
Field = nameof(v_syscompany.scy_ccompanyid),
Value = "112",
Compare = ConstantOptions.CompareConstant.Contains
},
new ItemInput
{
Field = nameof(v_syscompany.scy_ccompanyname),
Value = "admin",
Compare = ConstantOptions.CompareConstant.Contains
}
}
},
Page = new PageInput
{
Index = 1,
Size = 20,
Sort = new SortInput[]
{
new SortInput
{
OrderBy = nameof(v_syscompany.scy_ccompanyid),
Desc = false
},
new SortInput
{
OrderBy = nameof(v_syscompany.scy_ccompanyname),
Desc = true
}
}
}
};
var api = BackUrl(nameof(SyscompanyController), nameof(SyscompanyController.ObjQueryAsync));
var res = await _client.PostAsync(api, CreateHttpContent(input));
if (res.StatusCode is not(HttpStatusCode.OK or HttpStatusCode.NoContent))
{
Assert.Fail();
}
}
public Task <PageOutput <v_fieldfilter> > ObjQueryMainAsync([FromBody] ObjFilterInput input)
{
return(_fieldFilterService.ObjQueryMainAsync(input));
}
/// <summary> /// 主视图条件查询 /// </summary> /// <param name="input"></param> /// <returns></returns> public virtual Task <PageOutput <TMainView> > ObjQueryMainAsync(ObjFilterInput input) => QueryMain(_queryFactory).QueryAsync(input);
public Task <PageOutput <v_syscompany> > ObjQueryAsync([FromBody] ObjFilterInput input)
{
return(_sysCompanyService.ObjQueryAsync(input));
}
public async Task <PageOutput <object> > ObjQueryAsync([FromBody] ObjFilterInput input)
{
var page = await _userinfoService.ObjQueryAsync(input);
return(PageOutput.Convert(page, _filterProvider.FilterRange(page.DataList)));
}
