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