/// <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)); }