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); }