/// <summary>
/// 部门人均用能-单位面积用能
/// </summary>
/// <param name="buildId"></param>
/// <param name="energyCode"></param>
/// <param name="departmentID"></param>
/// <param name="type"> 查询类型：月度平均值:"MM"; 季度平均值："QQ"; 年度平均值："YY"</param>
/// <param name="date">结束时间(yyyy-MM-dd)</param>
/// <returns></returns>
public DepartmentEnergyAverageViewModel GetViewModel(string buildId, string energyCode, string type, string date)
{
DateTime dateTime;
string startDay, endDay;
List <EnergyAverage> averageData = new List <EnergyAverage>();
List <CompareData> compareData = new List <CompareData>();
switch (type)
{
case "MM":
dateTime = Util.ConvertString2DateTime(date, "yyyy-MM-dd");
startDay = dateTime.AddDays(-dateTime.Day + 1).ToString("yyyy-MM-dd");
endDay = dateTime.AddMonths(1).AddDays(-dateTime.Day).ToString("yyyy-MM-dd");
averageData = context.GetDeptMonthEnergyAverageList(buildId, energyCode, startDay, endDay);
compareData = context.GetDeptMonthCompareList(buildId, energyCode, startDay, endDay);
break;
case "QQ":
dateTime = Util.ConvertString2DateTime(date, "yyyy-MM");
startDay = dateTime.AddDays(-dateTime.Day + 1).AddMonths(-2).ToString("yyyy-MM-dd");
endDay = dateTime.AddMonths(1).AddDays(-dateTime.Day).ToString("yyyy-MM-dd");
averageData = context.GetDeptQuarterEnergyAverageList(buildId, energyCode, startDay, endDay);
compareData = context.GetDeptQuarterCompareList(buildId, energyCode, startDay, endDay);
break;
case "YY":
startDay = date + "-01-01";
endDay = date + "-12-31";
averageData = context.GetDeptYearEnergyAverageList(buildId, energyCode, startDay, endDay);
compareData = context.GetDeptYearCompareList(buildId, energyCode, startDay, endDay);
break;
default:
dateTime = Util.ConvertString2DateTime(date, "yyyy-MM-dd");
startDay = dateTime.AddDays(-dateTime.Day + 1).ToString("yyyy-MM-dd");
endDay = dateTime.AddMonths(1).AddDays(-dateTime.Day).ToString("yyyy-MM-dd");
averageData = context.GetDeptMonthEnergyAverageList(buildId, energyCode, startDay, endDay);
compareData = context.GetDeptMonthCompareList(buildId, energyCode, startDay, endDay);
break;
}
DepartmentEnergyAverageViewModel viewModel = new DepartmentEnergyAverageViewModel();
viewModel.AverageData = averageData;
viewModel.CompareData = compareData;
return(viewModel);
}
/// <summary>
/// 部门 月份 单位面积能耗
/// 初始加载：获取用户名查询建筑列表，第一栋建筑对应的分类，第一个分类对应的所有部门
/// </summary>
/// <param name="userName">用户名</param>
/// <returns>包含建筑列表，能源按钮列表，部门单位面积能耗</returns>
public DepartmentAreaAvgRankViewModel GetViewModelByUserName(string userName)
{
DateTime today = DateTime.Now;
List <BuildViewModel> builds = context.GetBuildsByUserName(userName);
string buildId;
if (builds.Count > 0)
{
buildId = builds.First().BuildID;
}
else
{
buildId = "";
}
List <EnergyItemDict> energys = context.GetEnergyItemDictByBuild(buildId);
string energyCode;
if (energys.Count > 0)
{
energyCode = energys.First().EnergyItemCode;
}
else
{
energyCode = "";
}
List <EnergyAverage> averageData = new List <EnergyAverage>();
averageData = context.GetDeptMonthEnergyAverageList(buildId, energyCode, DateTime.Now.ToString("yyyy-MM-01"), DateTime.Now.ToString("yyyy-MM-dd"));
DepartmentAreaAvgRankViewModel viewModel = new DepartmentAreaAvgRankViewModel();
viewModel.Builds = builds;
viewModel.Energys = energys;
viewModel.AverageData = averageData;
return(viewModel);
}