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="userName">用户名</param>
/// <returns>返回完整的数据：包含建筑列表，能源按钮列表，回路列表，以及第一支路数据</returns>
public CircuitOverviewViewModel GetCircuitOverviewViewModel(string userName)
{
DateTime today = DateTime.Now;
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
string buildId = builds.First().BuildID;
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
string energyCode = energys.First().EnergyItemCode;
List <CircuitList> circuits = reportContext.GetCircuitListByBIdAndEItemCode(buildId, energyCode);
string circuitId = circuits.First().CircuitId;
List <CircuitValue> loadData = context.GetCircuitLoadValueList(buildId, circuitId, today.ToString());
List <CircuitValue> dayData = context.GetCircuitMomDayValueList(buildId, circuitId, today.ToString());
List <CircuitValue> monthData = context.GetCircuitMomMonthValueList(buildId, circuitId, today.ToString());
List <CircuitValue> last48HoursData = context.GetCircuit48HoursValueList(buildId, circuitId, today.ToString());
List <CircuitValue> last31DayData = context.GetCircuit31DaysValueList(buildId, circuitId, today.ToString());
List <CircuitValue> last12MonthData = context.GetCircuit12MonthValueList(buildId, circuitId, today.ToString());
List <CircuitValue> last3YearData = context.GetCircuit3YearValueList(buildId, circuitId, today.ToString());
CircuitOverviewViewModel circuitOverviewView = new CircuitOverviewViewModel();
circuitOverviewView.Builds = builds;
circuitOverviewView.Energys = energys;
circuitOverviewView.Circuits = circuits;
circuitOverviewView.LoadData = loadData;
circuitOverviewView.MomDayData = dayData;
circuitOverviewView.MomMonthData = monthData;
circuitOverviewView.Last48HoursData = last48HoursData;
circuitOverviewView.Last31DaysData = last31DayData;
circuitOverviewView.Last12MonthData = last12MonthData;
circuitOverviewView.Last3YearData = last3YearData;
return(circuitOverviewView);
}
public MultiRateViewModel GetViewModel(string userName)
{
DateTime today = DateTime.Now;
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
string buildId = builds.First().BuildID;
List <EnergyItemDict> energys = context.GetEnergyItemDictByBuild(buildId);
string energyCode = "01000";
List <EMS.DAL.Entities.CircuitList> circuits = context.GetCircuitListByBIdAndEItemCode(buildId, energyCode);
string[] circuitIds = GetCircuitIds(circuits);
List <TreeViewModel> treeView = GetTreeListViewModel(buildId, energyCode);
List <MultiRateData> data = context.GetReportValueList(buildId, energyCode, "MM", today.ToShortDateString());
MultiRateViewModel circuitReportView = new MultiRateViewModel();
circuitReportView.Builds = builds;
circuitReportView.Energys = energys;
circuitReportView.TreeView = treeView;
circuitReportView.Data = data;
circuitReportView.ReportType = "MM";
return(circuitReportView);
}
public DepartmentCompareViewModel GetViewModelByBuild(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;
if (energys.Count > 0)
{
energyCode = energys.First().EnergyItemCode;
}
else
{
energyCode = "";
}
ITreeViewDbContext treeViewDb = new TreeViewDbContext();
List <TreeViewModel> treeView = treeViewDb.GetDepartmentTreeViewList(buildId, energyCode);
string departmentID = treeView.First().Id;
List <EMSValue> CompareValue = context.GetDepartmentCompareValueList(buildId, energyCode, departmentID, today.ToString("yyyy-MM-dd"));
DepartmentCompareViewModel CompareViewModel = new DepartmentCompareViewModel();
CompareViewModel.Builds = builds;
CompareViewModel.Energys = energys;
CompareViewModel.TreeView = treeView;
CompareViewModel.CompareData = CompareValue;
return(CompareViewModel);
}
public DepartmentRankViewModel GetViewModelByBuild(string userName, string buildId)
{
DateTime today = DateTime.Now;
DateTime monthBegin = new DateTime(today.Year, today.Month, 1);
DateTime monthEnd = monthBegin.AddMonths(1).AddDays(-1);
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
string energyCode;
if (energys.Count > 0)
{
energyCode = energys.First().EnergyItemCode;
}
else
{
energyCode = "";
}
List <EMSValue> list = context.GetRankList(buildId, monthBegin.ToString("yyyy-MM-dd"), monthEnd.ToString("yyyy-MM-dd"), energyCode);
DepartmentRankViewModel model = new DepartmentRankViewModel();
model.Builds = builds;
model.Energys = energys;
model.RankValues = list;
return(model);
}
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 TestGetBuildsByUserName()
{
HomeDbContext context = new HomeDbContext();
List <BuildViewModel> list = context.GetBuildsByUserName("admin");
foreach (BuildViewModel item in list)
{
Console.WriteLine("建筑ID:{0},建筑名称：{1}", item.BuildID, item.BuildName);
}
}
public EnergyItemOverviewModel GetEnergyItemOverviewViewModelByBuild(string userName, string buildId)
{
DateTime today = DateTime.Now;
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
List <EnergyItemValue> momDay = context.GetEnergyItemMomDayValueList(buildId, today.ToString());
List <EnergyItemValue> rankByMonth = context.GetEnergyItemRankByMonthValueList(buildId, today.ToString());
List <EnergyItemValue> last31DayPieChart = context.GetEnergyItemLast31DayPieChartValueList(buildId, today.ToString());
List <EnergyItemValue> last31Day = context.GetEnergyItemLast31DayValueList(buildId, today.ToString());
EnergyItemOverviewModel energyItemOverviewView = new EnergyItemOverviewModel();
energyItemOverviewView.Builds = builds;
energyItemOverviewView.EnergyItemMomDay = momDay;
energyItemOverviewView.EnergyItemRankByMonth = rankByMonth;
energyItemOverviewView.EnergyItemLast31DayPieChart = last31DayPieChart;
energyItemOverviewView.EnergyItemLast31Day = last31Day;
return(energyItemOverviewView);
}
public NoWorkDayViewModel GetViewModel(string userName)
{
DateTime today = DateTime.Now;
string beginDate = today.ToString("yyyy-MM-01 00:00:00");
string endDate = today.ToString("yyyy-MM-dd HH:mm:00");
string energyCode = "";
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
string buildID = "";
if (builds.Count > 0)
{
buildID = builds.First().BuildID;
}
List <EnergyItemDict> energys = tvcontext.GetEnergyItemDictByBuild(buildID);
if (energys.Count > 0)
{
energyCode = energys.First().EnergyItemCode;
}
List <TreeViewModel> treeView = tvcontext.GetCircuitTreeListViewModel(buildID, energyCode);
List <NoWorkDay> data = context.GetCircuitData(buildID, energyCode, beginDate, endDate);
NoWorkDayViewModel viewModel = new NoWorkDayViewModel();
viewModel.Builds = builds;
viewModel.Energys = energys;
viewModel.TreeView = treeView;
viewModel.Data = data;
return(viewModel);
}
/// <summary>
/// 部门用能统计报表
/// 初始加载：获取用户名查询建筑列表，第一栋建筑对应的分类，第一个分类对应的所有部门的用能天报表
/// </summary>
/// <param name="userName">用户名</param>
/// <returns>返回完整的数据：包含建筑列表，能源按钮列表，部门列表，以及用能数据天报表</returns>
public DepartmentReportViewModel GetViewModel(string userName)
{
DateTime today = DateTime.Now;
IHomeDbContext homeContext = new HomeDbContext();
List <BuildViewModel> builds = homeContext.GetBuildsByUserName(userName);
string buildId = builds.First().BuildID;
List <EnergyItemDict> energys = reportContext.GetEnergyItemDictByBuild(buildId);
//增加分类能耗过滤信息
//修改方法参数，修改SQL语句
string energyCode;
if (energys.Count > 0)
{
energyCode = energys.First().EnergyItemCode;
}
else
{
energyCode = "";
}
ITreeViewDbContext treeViewDb = new TreeViewDbContext();
List <TreeViewModel> treeView = treeViewDb.GetDepartmentTreeViewList(buildId, energyCode);
string[] departmentIDs = treeViewDb.GetDepartmentIDs(buildId, energyCode);
List <ReportValue> reportValue = context.GetReportValueList(energyCode, departmentIDs, today.ToString("yyyy-MM-dd 00:00:00"), "DD");
DepartmentReportViewModel reportView = new DepartmentReportViewModel();
reportView.Builds = builds;
reportView.Energys = energys;
reportView.TreeView = treeView;
reportView.Data = reportValue;
reportView.ReportType = "DD";
return(reportView);
}
public CircuitCompareViewModel GetCircuitCompareVMWithBuild(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;
List <TreeViewModel> treeView = GetTreeListViewModel(buildId, energyCode);
List <EMS.DAL.Entities.CircuitList> circuits = reportContext.GetCircuitListByBIdAndEItemCode(buildId, energyCode);
string circuitId = circuits.First().CircuitId;
List <CircuitValue> compareData = context.GetCircuitCompareValueList(buildId, circuitId, today.ToString());
CircuitCompareViewModel circuitCompareView = new CircuitCompareViewModel();
circuitCompareView.Builds = builds;
circuitCompareView.Energys = energys;
circuitCompareView.TreeView = treeView;
circuitCompareView.CompareData = compareData;
return(circuitCompareView);
}