subsonic 级联查询

最新推荐文章于 2018-08-27 10:50:00 发布

zzginfo

最新推荐文章于 2018-08-27 10:50:00 发布

阅读量678

点赞数

文章标签： statistics dataset

本文链接：https://blog.csdn.net/zzginfo/article/details/5812257

版权

public DataSet Test(List<string> areaCodeList, DateTime startTime_Statistics, DateTime endTime_Statistics)
{
 SqlQuery q = new Select(
 new Aggregate(BuildingTradeInfo.Columns.BargainOnSum, AggregateFunction.Sum)
 , new Aggregate(BuildingTableInfo.Columns.FSpaceBulit, AggregateFunction.Sum)
 )
 .From(ProjectBaseInfo.Schema)
 .InnerJoin(BuildingTableInfo.ProjectCodeColumn, ProjectBaseInfo.ProjectCodeColumn)
 .InnerJoin(BuildingTradeInfo.HouseIDColumn, BuildingTableInfo.HouseIDColumn)
 .Where(ProjectBaseInfo.Columns.AreaCode).In(areaCodeList)
 .And(BuildingTradeInfo.Columns.ContractTime).IsGreaterThanOrEqualTo(startTime_Statistics)
 .And(BuildingTradeInfo.Columns.ContractTime).IsLessThanOrEqualTo(endTime_Statistics)
 .And(BuildingTradeInfo.Columns.CurrentState).IsEqualTo("3");

DataSet dataSet = q.ExecuteDataSet();
return dataSet;
}

参考：http://wolfmaster.javaeye.com/category/45387?show_full=true