OA2023/OASystem/OASystem.Infrastructure/Repositories/System/JobPostRepository.cs

using OASystem.Domain.Dtos.System;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace OASystem.Infrastructure.Repositories.System
{
    public class JobPostRepository : BaseRepository<Sys_JobPost, JobPostView>
    {
        public JobPostRepository(SqlSugarClient sqlSugar) : base(sqlSugar)
        {

        }

        public async Task<List<Sys_JobPostI>> QueryJobPost(string sqlWhere)
        {
            string sql = string.Format(@"select jp.*,dep.DepName as 'DepName',cmp.CompanyName as 'CompanyName' from Sys_JobPost jp left join 
                                                 Sys_Company cmp on jp.CompanyId=cmp.Id left join Sys_Department dep on jp.DepId=dep.Id  {0}", sqlWhere);
            return await _sqlSugar.SqlQueryable<Sys_JobPostI>(sql).ToListAsync();
        }

    }
}