public EnergyItemCompareViewModel GetEnergyItemCompareViewModelByBuild(string userName, string buildId)
{
DateTime today = DateTime.Now;
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
//string energyCode = energys.First().EnergyItemCode;
IEnergyItemTreeViewDbContext energyItemtreeView = new EnergyItemTreeViewDbContext();
List <TreeViewModel> treeView = energyItemtreeView.GetEnergyItemTreeViewList(buildId);
string treeId;
if (treeView.Count == 0)
{
treeId = "";
}
else
{
treeId = treeView.First().Id;
}
List <EnergyItemValue> energyItemCompareValue = context.GetEnergyItemCompareValueList(buildId, treeId, today.ToString());
EnergyItemCompareViewModel energyItemCompareView = new EnergyItemCompareViewModel();
energyItemCompareView.Builds = builds;
energyItemCompareView.Energys = energys;
energyItemCompareView.TreeView = treeView;
energyItemCompareView.CompareData = energyItemCompareValue;
return(energyItemCompareView);
}
/// <summary>
/// 分项用能同比分析
/// </summary>
/// <param name="buildId">建筑ID</param>
/// <param name="date"> 传入的日期("yyyy-MM-dd HH:mm:ss")</param>
/// <returns>返回完整的数据：能源按钮列表，分项列表，以及第一个分项用能数据</returns>
public EnergyItemCompareViewModel GetEnergyItemCompareViewModel(string buildId, string date)
{
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
//string energyCode = energys.First().EnergyItemCode;
IEnergyItemTreeViewDbContext energyItemtreeView = new EnergyItemTreeViewDbContext();
List <TreeViewModel> treeView = energyItemtreeView.GetEnergyItemTreeViewList(buildId);
string treeId;
if (treeView.Count == 0)
{
treeId = "";
}
else
{
treeId = treeView.First().Id;
}
List <EnergyItemValue> energyItemCompareValue = context.GetEnergyItemCompareValueList(buildId, treeId, date);
EnergyItemCompareViewModel energyItemCompareView = new EnergyItemCompareViewModel();
energyItemCompareView.Energys = energys;
energyItemCompareView.TreeView = treeView;
energyItemCompareView.CompareData = energyItemCompareValue;
return(energyItemCompareView);
}
public EnergyItemReportViewModel GetEnergyItemReportViewModelByBuild(string userName, string buildId)
{
DateTime today = DateTime.Now;
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
IEnergyItemTreeViewDbContext energyItemtreeView = new EnergyItemTreeViewDbContext();
List <TreeViewModel> treeView = energyItemtreeView.GetEnergyItemTreeViewList(buildId);
List <EnergyItemInfo> EnergyItemInfos = energyItemtreeView.GetEnergyItemInfoList(buildId);
string[] formulaIDs = GetEnergyItemCodes(EnergyItemInfos);
List <ReportValue> reportValue = context.GetReportValueList(formulaIDs, today.ToString(), "DD");
EnergyItemReportViewModel energyItemReportView = new EnergyItemReportViewModel();
energyItemReportView.Builds = builds;
energyItemReportView.Energys = energys;
energyItemReportView.TreeView = treeView;
energyItemReportView.Data = reportValue;
energyItemReportView.ReportType = "DD";
return(energyItemReportView);
}
public void TestGetEnergyItemReportDayValue()
{
IEnergyItemReportDbContext context = new EnergyItemReportDbContext();
IEnergyItemTreeViewDbContext TreeViewcontext = new EnergyItemTreeViewDbContext();
DateTime today = DateTime.Now.AddDays(-1);
string buildID = "000001G001";
List <EnergyItemInfo> energyItemInfos = TreeViewcontext.GetEnergyItemInfoList(buildID);
string[] energyCodes = GetEnergyItemCodes(energyItemInfos);
List <ReportValue> reportValue = context.GetReportValueList(energyCodes, today.ToString(), "DD");
Console.WriteLine(UtilTest.GetJson(reportValue));
}
public void TestGetEnergyItemTreeView()
{
IEnergyItemTreeViewDbContext context = new EnergyItemTreeViewDbContext();
//DateTime today = DateTime.Now;
List <TreeViewModel> treeViewModel = context.GetEnergyItemTreeViewList("000001G008");
string treeView = UtilTest.GetJson(treeViewModel);
Console.WriteLine("分项用能列表：{0}", treeView);
//foreach (var item in treeViewModel)
//{
// Console.WriteLine("分项ID：{0}, 分项名称：{1}, 子节点：{2}；", item.Id, item.Text,item.Nodes);
//}
}
public void TestGetEnergyItemReportViewModelByEnergyItemIDAndTypeYear()
{
DateTime today = DateTime.Now;
string buildId = "000001G001";
IEnergyItemTreeViewDbContext energyItemtreeView = new EnergyItemTreeViewDbContext();
List <TreeViewModel> treeView = energyItemtreeView.GetEnergyItemTreeViewList(buildId);
List <EnergyItemInfo> EnergyItemInfos = energyItemtreeView.GetEnergyItemInfoList(buildId);
string[] formulaIDs = GetEnergyItemCodes(EnergyItemInfos);
EnergyItemReportService service = new EnergyItemReportService();
EnergyItemReportViewModel EnergyReportViewDay = service.GetEnergyItemReportViewModel(formulaIDs, today.ToString(), "YY");
Console.WriteLine(UtilTest.GetJson(EnergyReportViewDay));
}
/// <summary>
/// 分项用能统计
/// 根据建筑ID和日期，获取第一个分类对应的所有分项当日的用能概况
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="date">时间</param>
/// <returns>返回完整的数据：能源按钮列表，分项列表，以及第一分类的当日用能数据</returns>
public EnergyItemReportViewModel GetEnergyItemReportViewModel(string buildId, string date)
{
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
IEnergyItemTreeViewDbContext energyItemtreeView = new EnergyItemTreeViewDbContext();
List <TreeViewModel> treeView = energyItemtreeView.GetEnergyItemTreeViewList(buildId);
List <EnergyItemInfo> EnergyItemInfos = energyItemtreeView.GetEnergyItemInfoList(buildId);
string[] formulaIDs = GetEnergyItemCodes(EnergyItemInfos);
List <ReportValue> reportValue = context.GetReportValueList(formulaIDs, date, "DD");
EnergyItemReportViewModel energyItemReportView = new EnergyItemReportViewModel();
energyItemReportView.Energys = energys;
energyItemReportView.TreeView = treeView;
energyItemReportView.Data = reportValue;
energyItemReportView.ReportType = "DD";
return(energyItemReportView);
}