/// <summary>
/// 服务器列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns></returns>
public async Task <IActionResult> Index(ServicePageQueryWhere queryWhere)
{
var operateResult = await _servicerApplication.GetServiceListAsync(queryWhere);
ViewBag.QueryWhere = queryWhere;
return(View(operateResult.Value));
}
/// <summary>
/// 分页获取服务器列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns>服务器列表</returns>
public Task <IPageResult <ServicerListDto> > GetServiceListAsync(ServicePageQueryWhere queryWhere)
{
SqlWhereBuilder whereBuilder = new SqlWhereBuilder("FIsDeleted=0", ReaderDataType);
whereBuilder.AppendEqual("FMacAddress", queryWhere.MacAddress, paramKey: nameof(queryWhere.MacAddress))
.AppendLike("FIP", queryWhere.IP, paramKey: nameof(queryWhere.IP))
.AppendLike("FName", queryWhere.Name, paramKey: nameof(queryWhere.Name))
;
const string selectTable = TABLE_NAME_SERVCER + SQLSERVER_WITHNOLOCK;
const string selectColumn = "FID,FMacAddress,FIP,FName,FComment,ISNULL(FLastModifyTime,FCreateTime) AS FLastModifyTime";
const string order = "ISNULL(FLastModifyTime,FCreateTime) DESC";
return(QueryPageListAsync <ServicerListDto>(selectColumn, selectTable, whereBuilder.ToString(), order, queryWhere.PageIndex, queryWhere.PageSize, cmdParms: queryWhere));
}
/// <summary>
/// 分页获取服务器列表
/// </summary>
/// <param name="queryWhere">查询条件</param>
/// <returns>服务器列表</returns>
public Task <OperateResult <IPageResult <ServicerListDto> > > GetServiceListAsync(ServicePageQueryWhere queryWhere)
{
return(OperateUtil.ExecuteAsync(() =>
{
return _servcerRepository.GetServiceListAsync(queryWhere);
}, callMemberName: "ServicerApplication-GetServiceListAsync"));
}
