public void TestDepartmentComletionRateViewModelByYear()
{
DateTime today = DateTime.Now;
AlarmDepartmentCompletionRateService service = new AlarmDepartmentCompletionRateService();
AlarmDepartmentCompletionRateViewModel ViewModel = service.GetViewModel("000001G003", "01000", "YY", "2018-8");
Console.WriteLine(UtilTest.GetJson(ViewModel));
}
public void TestAlarmDepartmentComletionRateByUserName()
{
AlarmDepartmentCompletionRateService service = new AlarmDepartmentCompletionRateService();
AlarmDepartmentCompletionRateViewModel model = service.GetViewModelByUserName("admin");
Console.WriteLine(UtilTest.GetJson(model));
}
/// <summary>
/// 部门-部门用能总量,单位面积 同比大于 -2%（下降小于2%）
/// </summary>
/// <param name="buildId">建筑ID</param>
/// <param name="energyCode">分类能耗</param>
/// <param name="type">类型：MM：月度； QQ：季度； YY：年度 </param>
/// <param name="date">传入时间格式：月度：yyyy-MM (具体到月份)
/// 季度：yyyy-MM (具体到月份，每个季度最后一个月)
/// 年度：yyyy-MM (具体到月份)
/// </param>
/// <returns></returns>
public AlarmDepartmentCompletionRateViewModel GetViewModel(string buildId, string energyCode, string type, string date)
{
DateTime dateTime;
string startDay, endDay;
List <CompareData> totalCompareData = new List <CompareData>();
List <CompareData> areaAvgCompareData = new List <CompareData>();
switch (type)
{
case "MM":
dateTime = Util.ConvertString2DateTime(date, "yyyy-MM-dd");
startDay = dateTime.ToString("yyyy-MM-01");
endDay = dateTime.AddMonths(1).AddDays(-dateTime.Day).ToString("yyyy-MM-dd");
totalCompareData = context.GetDeptTotalValueCompareMonthList(buildId, energyCode, startDay, endDay);
areaAvgCompareData = context.GetDeptAreaAvgCompareMonthList(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");
totalCompareData = context.GetDeptTotalValueCompareQuarterList(buildId, energyCode, startDay, endDay);
areaAvgCompareData = context.GetDeptAreaAvgCompareQuarterList(buildId, energyCode, startDay, endDay);
break;
case "YY":
dateTime = Util.ConvertString2DateTime(date, "yyyy-MM-dd");
startDay = dateTime.ToString("yyyy-01-01");
endDay = dateTime.AddMonths(1).AddDays(-dateTime.Day).ToString("yyyy-MM-dd");
totalCompareData = context.GetDeptTotalValueCompareYearList(buildId, energyCode, startDay, endDay);
areaAvgCompareData = context.GetDeptAreaAvgCompareYearList(buildId, energyCode, startDay, endDay);
break;
default:
dateTime = Util.ConvertString2DateTime(date, "yyyy-MM-dd");
startDay = dateTime.ToString("yyyy-MM-01");
endDay = dateTime.AddMonths(1).AddDays(-dateTime.Day).ToString("yyyy-MM-dd");
totalCompareData = context.GetDeptTotalValueCompareMonthList(buildId, energyCode, startDay, endDay);
areaAvgCompareData = context.GetDeptAreaAvgCompareMonthList(buildId, energyCode, startDay, endDay);
break;
}
List <DeptCompletionRate> deptCompletionRate = context.GetDeptCompletionRateList(buildId);
AlarmDepartmentCompletionRateViewModel viewModel = new AlarmDepartmentCompletionRateViewModel();
viewModel.DeptCompletionRate = deptCompletionRate;
viewModel.TotalCompareData = totalCompareData;
viewModel.AreaAvgCompareData = areaAvgCompareData;
return(viewModel);
}
/// <summary>
/// 部门-月度用能总量,单位面积 同比大于 -2%（下降小于2%）
/// 初始加载：获取用户名查询建筑列表，第一栋建筑对应的分类
/// </summary>
/// <param name="userName">用户名</param>
/// <returns>包含建筑列表，能源按钮列表，月度用能总量,单位面积 同比大于 -2%</returns>
public AlarmDepartmentCompletionRateViewModel GetViewModelByUserName(string userName)
{
DateTime today = DateTime.Now;
string startDay = today.ToString("yyyy-MM-01");
string endDay = today.AddMonths(1).AddDays(-today.Day).ToString("yyyy-MM-dd");
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 <DeptCompletionRate> deptCompletionRate = context.GetDeptCompletionRateList(buildId);
List <CompareData> totalCompareData = context.GetDeptTotalValueCompareMonthList(buildId, energyCode, startDay, endDay);
List <CompareData> areaAvgCompareData = context.GetDeptAreaAvgCompareMonthList(buildId, energyCode, startDay, endDay);
AlarmDepartmentCompletionRateViewModel viewModel = new AlarmDepartmentCompletionRateViewModel();
viewModel.Builds = builds;
viewModel.Energys = energys;
viewModel.DeptCompletionRate = deptCompletionRate;
viewModel.TotalCompareData = totalCompareData;
viewModel.AreaAvgCompareData = areaAvgCompareData;
return(viewModel);
}
