/// <summary>
/// 联表查询
/// 三表查询
/// </summary>
/// <param name="leagueTables"></param>
/// <returns></returns>
public async Task <List <TEntity> > LeagueTables(LeagueTables leagueTables)
{
string relation = $"s1.{leagueTables.ForeignKey} = s2.{leagueTables.RightKey}";
string relation2 = $"s2.{leagueTables.RightKey} = s3.{leagueTables.ThreeKey}";
return(await Task.Run(() => Db.Queryable(leagueTables.LeftTable, "s1")
.AddJoinInfo(leagueTables.RightTable, "s2", relation)
.AddJoinInfo(leagueTables.ThreeTable, "s3", relation2)
.Select <TEntity>(MonogramHelper.GetQueryField(leagueTables.QueryField))
.ToPageList(leagueTables.IntPageIndex, leagueTables.IntPageSize)));
}
public async Task <List <TEntity> > LeagueTables(LeagueTables leagueTables)
{
return(await baseDal.LeagueTables(leagueTables));
}
