yili-onemap/api/QM.KJGH.CGGL/QM.KJGH.CGGL.Repository/NmCityCghj/CityCghjCgsbrwRepository.cs

using QM.KJGH.CGGL.IRepository;
using QM.KJGH.CGGL.Model.NMCghj;
using QM.KJGH.CGGL.Model.QxCghj;
using QM.KJGH.Model.KJGH.CGHJ;
using QM.OrmSqlSugar;
using System.Threading.Tasks;
using WS.AutoMapper;
using WS.Orm;

namespace QM.KJGH.CGGL.Repository
{
    /// <summary>
    /// 市
    /// </summary>
    public class CityCghjCgsbrwRepository : SqlSugarRepository<CityCghjCgsbrw>, ICityCghjCgsbrwRepository
    {

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<PageData> GetPage(CghjCgsbrwPage input)
        {
            var query = DbClient().Queryable<CityCghjCgsbrw>();
            query.WhereIF(!string.IsNullOrWhiteSpace(input.FILENAME), t => t.FILENAME.Contains(input.FILENAME));
            query.WhereIF(!string.IsNullOrWhiteSpace(input.XZQDM), t => t.XZQDM.Contains(input.XZQDM));
            query.WhereIF(!string.IsNullOrWhiteSpace(input.GHLX), t => t.GHLX == input.GHLX);
            query.WhereIF(input.RWZT != null, t => t.RWZT == input.RWZT.Value);
            //query.WhereIF(!string.IsNullOrWhiteSpace(input.GHJB), t => t.GHJB == input.GHJB);
            var page = await query.OrderBy(t => t.CREATETIME, SqlSugar.OrderByType.Desc).ToPageAsync(input.page, input.limit);
            //page.Data = ((List<CghjCgsbrw>)page.Data).MapTo<CghjQxcg, CghjQxcgView>();
            return page;
        }

        /// <summary>
        /// 查询详情
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public async Task<CghjCgsbrwView> QueryById(string id)
        {
            var model = await GetAsync(t => t.ID == id);

            return model.MapTo<CghjCgsbrwView>();
        }
    }
}