omega_source/Services/DatabaseTableService.cs

using Attribute;
using Model;
using Model.Base;
using Repository;
using Service;
using Microsoft.AspNetCore.Mvc;
using Vo.Admin;
using Dto.Admin;


namespace Services
{
    /// <summary>
    /// 数据表Service业务层处理
    /// </summary>
    [AppService(ServiceType = typeof(IDatabaseTableService), ServiceLifetime = LifeTime.Transient)]
    public class DatabaseTableService : BaseService<DatabaseTable>, IDatabaseTableService
    {
        /// <summary>
        /// 数据表-列表
        /// </summary>
        /// <param name="param">参数请求体</param>
        /// <param name="page">分页参数</param>
        /// <returns>列表</returns>
        public PagedInfo<GetDatabaseTableListVo> getDatabaseTableList([FromQuery] PagerInfo page, [FromQuery] DatabaseTable param)
        {
            //拼装查询条件
            var predicate = Expressionable.Create<DatabaseTable>();
            predicate = predicate.AndIF(param.databaseId > 0, m => m.databaseId == param.databaseId);
            predicate = predicate.AndIF(!string.IsNullOrEmpty(param.tableTitle), m => m.tableTitle.Contains(param.tableTitle));
            predicate = predicate.AndIF(!string.IsNullOrEmpty(param.tableName), m => m.tableName.Contains(param.tableName));
            predicate = predicate.AndIF(param.splitKind > 0, m => m.splitKind == param.splitKind);
            var response = Queryable()
                .Where(predicate.ToExpression())
                .OrderByDescending(m => m.id)
                .ToPage<DatabaseTable, GetDatabaseTableListVo>(page);
            return response;
        }


        /// <summary>
        /// 数据表-根据服务ID查询列表
        /// </summary>
        /// <param name="param">参数请求体</param>
        /// <param name="page">分页参数</param>
        /// <returns>根据服务ID查询列表</returns>
        public PagedInfo<GetDatabaseTableListByIdsVo> getDatabaseTableListByIds([FromQuery] PagerInfo page, [FromQuery] GetDatabaseTableListByIdsDto param)
        {
            //拼装查询条件
            var predicate = Expressionable.Create<DatabaseTable>();
            // predicate = predicate.AndIF(param.serviceId > 0, m => m.serviceId == param.serviceId);
            var response = Queryable()
            .Where(predicate.ToExpression())
            .OrderByDescending(m => m.id)
            .ToPage<DatabaseTable, GetDatabaseTableListByIdsVo>(page);
            return response;
        }



    }
}