public async Task <List <HostilityListDto> > GetAllHostility(QueryHostilityDto dto)
{
using (var connection = DapperHandle.OpenConnection())
{
var sqlstr = @"select HostilityId,QQNumber,HostilityName,RoleLevel,
MilitaryPower,HostilityLevel,IsSurpass,Remark,CreateTime
from Hostility where 1=1";
//模仿城里人微软的玩法
var(sql, param) = DapperHandle.CreateQueryHandle(sqlstr, dto)
.AddCondition(a => !string.IsNullOrEmpty(a.QQNumber), " and QQNumber like @QQNumber")
.AddCondition(a => !string.IsNullOrEmpty(a.HostilityName), " and HostilityName like @HostilityName")
.BuilderPage(orderby: "HostilityId");
return((List <HostilityListDto>) await connection.QueryAsync <HostilityListDto>(sql, param));
}
}
public async Task <ActionResult> GetHostilityInfo([FromQuery] QueryHostilityDto dto)
{
return(Ok(await _hostilityService.GetAllHostility(dto)));
}
