using DevExpress.XtraCharts;
|
using DevExpress.XtraExport.Helpers;
|
using DevExpress.XtraGrid.Views.Grid;
|
using IStation.BLL;
|
using IStation.CalcModel;
|
using IStation.Model;
|
using System;
|
using System.Collections.Generic;
|
using System.Globalization;
|
|
namespace IStation.WinFrmUI.Monitor
|
{
|
public partial class ResultChartControl : DevExpress.XtraEditors.XtraUserControl
|
{
|
public ResultChartControl()
|
{
|
InitializeComponent();
|
}
|
|
private class CurrentModel
|
{
|
/// <summary>
|
/// 名称
|
/// </summary>
|
public string Name { get; set; }
|
/// <summary>
|
/// 泵台数
|
/// </summary>
|
public string PumpCount { get; set; }
|
/// <summary>
|
/// 开机时间段
|
/// </summary>
|
public string Time { get; set; }
|
/// <summary>
|
/// 电费
|
/// </summary>
|
public double ElectricityPrice { get; set; }
|
/// <summary>
|
/// 用电量
|
/// </summary>
|
public double Electricity { get; set; }
|
/// <summary>
|
/// 取水量
|
/// </summary>
|
public double Water { get; set; }
|
/// <summary>
|
/// 持续时间
|
/// </summary>
|
public double TimeSpan { get; set; }
|
/// <summary>
|
/// 总取水量
|
/// </summary>
|
public double TotalWater { get; set; }
|
/// <summary>
|
/// 总电费
|
/// </summary>
|
public double TotalElePrice { get; set; }
|
/// <summary>
|
/// 总用电量
|
/// </summary>
|
public double TotalEle { get; set; }
|
/// <summary>
|
/// 千吨水能耗
|
/// </summary>
|
public double QDSLN { get; set; }
|
|
}
|
|
|
|
bool isSetData = false;
|
|
DateTime DateTime; //api查询需要的日期
|
DateTime ListDayTime; //listBox当前选择的日期
|
List<CurrentModel> _CurrentModel = new List<CurrentModel>();
|
PumpRunHelper _PumpRunHelper = new PumpRunHelper();
|
CalcModel.AnaPrj _Ana = null; //方案数据
|
Model.RunParasData _LastYeay = null; //去年同期
|
Model.RunParasData _CurrentData = null; //实际数据
|
List<PumpWater> _HistorypumpWater = new List<PumpWater>(); //历史参数日期重构
|
|
|
|
List<Model.PumpWater> _CurrentPumpWater =new List<PumpWater>(); //实际参数日期重构
|
/// <summary>
|
/// 绑定数据
|
/// </summary>
|
/// <param name="datetime"></param>
|
public void SetBindingData(DateTime datetime)
|
{
|
WaitFrmHelper.ShowWaitForm();
|
ListDayTime = datetime;
|
if (checkEditCalendar.SelectedIndex == 0)
|
{
|
DateTime = datetime.AddDays(-366);
|
}
|
else
|
{
|
DateTime = ConvertDateTime(datetime);
|
}
|
SetTextToCheckBtn(datetime);
|
_Ana = IStation.BLL.AnaPrj.GetPrj(datetime); //方案数据
|
_LastYeay = _PumpRunHelper.GetByHistoryOneData(DateTime, out string error); //去年同期
|
_CurrentData = _PumpRunHelper.GetPumpRunParasOneDay(DateTime, out string err); //实际数据
|
MergeCurrentModel(_Ana, _LastYeay, _CurrentData);
|
//GetTideData(Model.eTideSouce.Book, 2, datetime, new DateTime(datetime.Year, datetime.Month, datetime.Day, 23, 59, 59));
|
// GetTideData(Model.eTideSouce.Web, 3, datetime, new DateTime(datetime.Year, datetime.Month, datetime.Day, 23, 59, 59));
|
SetHistoryPumpWaterParas(new DateTime(datetime.Year, datetime.Month, datetime.Day)); //历史取水量
|
SetCurretnPumpWaterParas(new DateTime(datetime.Year, datetime.Month, datetime.Day)); //实际取水量
|
GetAnaWater();
|
SetSeriseEle();
|
WaitFrmHelper.HideWaitForm();
|
}
|
|
|
private void SetSeriseEle()
|
{
|
var SeriesHistory = this.chartControlEle.Series[1];
|
var SeriesCurrent = this.chartControlEle.Series[0];
|
var SeriesAna = this.chartControlEle.Series[2];
|
SeriesHistory.Points.Clear();
|
SeriesCurrent.Points.Clear();
|
SeriesAna.Points.Clear();
|
if (_HistorypumpWater != null)
|
{
|
foreach (var item in _HistorypumpWater)
|
{
|
SeriesHistory.Points.Add(new SeriesPoint(item.DateTime, Math.Round(item.TotalEle), 2));
|
}
|
}
|
if (_CurrentPumpWater != null)
|
{
|
foreach (var item in _CurrentPumpWater)
|
{
|
SeriesCurrent.Points.Add(new SeriesPoint(item.DateTime, Math.Round(item.TotalEle), 2));
|
}
|
}
|
if (_Ana != null&& isSetData)
|
{
|
foreach (var item in _Ana.PointTimes)
|
{
|
SeriesAna.Points.Add(new SeriesPoint(item.Time, Math.Round(item.SumPower), 2));
|
}
|
}
|
if (SeriesHistory.Points.Count == 0)
|
{
|
SeriesHistory.ShowInLegend = false;
|
}
|
else SeriesHistory.ShowInLegend = true;
|
if (SeriesCurrent.Points.Count == 0)
|
{
|
SeriesCurrent.ShowInLegend = false;
|
}
|
else SeriesAna.ShowInLegend = true;
|
if (SeriesAna.Points.Count == 0)
|
{
|
SeriesAna.ShowInLegend = false;
|
}
|
else SeriesAna.ShowInLegend = true;
|
}
|
|
|
|
//checkbtn添加item
|
private void SetTextToCheckBtn(DateTime dateTime)
|
{
|
this.checkEditCalendar.Properties.Items.Clear();
|
this.checkEditCalendar.Properties.Items.Add($"阳历({dateTime.ToString("yyyy-MM-dd")})");
|
this.checkEditCalendar.Properties.Items.Add($"阴历({ConvertDateTime(dateTime).ToString("yyyy-MM-dd")})");
|
}
|
|
|
//合并所有开始时间-结束时间
|
private List<(DateTime, DateTime, double, double, double)> MergeList(Model.RunParasData runParasData)
|
{
|
if (runParasData == null) return null;
|
List<(DateTime, DateTime, double, double, double)> values = new List<(DateTime, DateTime, double, double, double)>();
|
foreach (var item in runParasData.Pump1)
|
{
|
values.Add((item.StartTime, item.EndTime, item.Money, item.FlowIn, item.Electric));
|
}
|
foreach (var item in runParasData.Pump2)
|
{
|
values.Add((item.StartTime, item.EndTime, item.Money, item.FlowIn, item.Electric));
|
}
|
foreach (var item in runParasData.Pump3)
|
{
|
values.Add((item.StartTime, item.EndTime, item.Money, item.FlowIn, item.Electric));
|
}
|
foreach (var item in runParasData.Pump4)
|
{
|
values.Add((item.StartTime, item.EndTime, item.Money, item.FlowIn, item.Electric));
|
}
|
foreach (var item in runParasData.Pump5)
|
{
|
values.Add((item.StartTime, item.EndTime, item.Money, item.FlowIn, item.Electric));
|
}
|
return values;
|
}
|
|
|
//农历阴历日期转换
|
private DateTime ConvertDateTime(DateTime lastYearDay)
|
{
|
// 创建一个 ChineseLunisolarCalendar 实例
|
ChineseLunisolarCalendar chineseCalendar = new ChineseLunisolarCalendar();
|
int thisYear = chineseCalendar.GetYear(lastYearDay);
|
int thisMonth = chineseCalendar.GetMonth(lastYearDay);
|
int thisDay = chineseCalendar.GetDayOfMonth(lastYearDay);
|
// 将阴历日期减去一年
|
DateTime lastYearLunarDate = new DateTime(thisYear, thisMonth, thisDay, 0, 0, 0, 0).AddYears(-1);
|
DateTime gregorianDate = chineseCalendar.ToDateTime(lastYearLunarDate.Year, lastYearLunarDate.Month, lastYearLunarDate.Day, 0, 0, 0, 0);
|
return gregorianDate;
|
}
|
|
|
//获取水位数据
|
/* private void GetTideData(Model.eTideSouce eTideSouce, int sort, DateTime Startday, DateTime Endday)
|
{
|
XYDiagram main_diagram = chartControl实时数据.Diagram as XYDiagram;
|
var axisTime = main_diagram.AxisX;
|
axisTime.VisualRange.Auto = true;
|
axisTime.WholeRange.Auto = true;
|
axisTime.WholeRange.SideMarginsValue = 0;
|
axisTime.VisualRange.SideMarginsValue = 0;
|
axisTime.WholeRange.SetMinMaxValues(Startday, Startday.AddDays(1));
|
axisTime.VisualRange.SetMinMaxValues(Startday, Startday.AddDays(1));
|
var tidelist = BLL.TideHelper.GetByDayRange(eTideSouce, Startday, Endday, out string a);
|
var SeriseMonitor = this.chartControl实时数据.Series[sort];
|
SeriseMonitor.Points.Clear();
|
if (tidelist != null)
|
{
|
foreach (var item in tidelist)
|
{
|
SeriseMonitor.Points.Add(new SeriesPoint(item.Time, item.Level));
|
}
|
}
|
if (SeriseMonitor.Points.Count == 0)
|
{
|
SeriseMonitor.ShowInLegend = false;
|
}
|
else SeriseMonitor.ShowInLegend = true;
|
|
}*/
|
|
|
//添加历史取水量
|
private void SetHistoryPumpWaterParas(DateTime dateTime)
|
{
|
_HistorypumpWater.Clear();
|
var LastYearTime = dateTime.AddDays(-366);
|
XYDiagram main_diagram = chartControl实时数据.Diagram as XYDiagram;
|
var axisTime = main_diagram.AxisX;
|
axisTime.VisualRange.Auto = true;
|
axisTime.WholeRange.Auto = true;
|
axisTime.WholeRange.SideMarginsValue = 0;
|
axisTime.VisualRange.SideMarginsValue = 0;
|
// axisTime.WholeRange.SetMinMaxValues(LastYearTime, LastYearTime.AddDays(1));
|
// axisTime.VisualRange.SetMinMaxValues(LastYearTime, LastYearTime.AddDays(1));
|
var waterParas = _PumpRunHelper.GetByPumpOneDayWaterData(LastYearTime, out string error);
|
if (waterParas == null) return;
|
foreach (var item in waterParas)
|
{
|
_HistorypumpWater.Add(new PumpWater { DateTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, item.DateTime.Hour, item.DateTime.Minute, 0), TotalWater = item.TotalWater, TotalEle = item.TotalEle });
|
}
|
var SeriseMonitor = this.chartControl实时数据.Series[1];
|
SeriseMonitor.Points.Clear();
|
if (_HistorypumpWater != null)
|
{
|
foreach (var item in _HistorypumpWater)
|
{
|
SeriseMonitor.Points.Add(new SeriesPoint(item.DateTime, Math.Round(item.TotalWater), 2));
|
}
|
}
|
if (SeriseMonitor.Points.Count == 0)
|
{
|
SeriseMonitor.ShowInLegend = false;
|
}
|
else SeriseMonitor.ShowInLegend = true;
|
}
|
|
|
//添加实际取水量
|
private void SetCurretnPumpWaterParas(DateTime dateTime)
|
{
|
// List<PumpWater> pumpWater = new List<PumpWater>();
|
XYDiagram main_diagram = chartControl实时数据.Diagram as XYDiagram;
|
var axisTime = main_diagram.AxisX;
|
axisTime.VisualRange.Auto = true;
|
axisTime.WholeRange.Auto = true;
|
axisTime.WholeRange.SideMarginsValue = 0;
|
axisTime.VisualRange.SideMarginsValue = 0;
|
// axisTime.WholeRange.SetMinMaxValues(LastYearTime, LastYearTime.AddDays(1));
|
// axisTime.VisualRange.SetMinMaxValues(LastYearTime, LastYearTime.AddDays(1));
|
var CurrentPumpWater = _PumpRunHelper.GetByPumpOneDayWaterData(dateTime.AddMonths(-6), out string error);
|
var SeriseMonitor = this.chartControl实时数据.Series[0];
|
if (CurrentPumpWater == null) return;
|
_CurrentPumpWater.Clear();
|
foreach (var item in CurrentPumpWater)
|
{
|
_CurrentPumpWater.Add(new PumpWater { DateTime = new DateTime(dateTime.Year, dateTime.Month, dateTime.Day, item.DateTime.Hour, item.DateTime.Minute, 0), TotalWater = item.TotalWater, TotalEle = item.TotalEle });
|
}
|
|
SeriseMonitor.Points.Clear();
|
if (_CurrentPumpWater != null)
|
{
|
foreach (var item in _CurrentPumpWater)
|
{
|
SeriseMonitor.Points.Add(new SeriesPoint(item.DateTime, Math.Round(item.TotalWater), 2));
|
}
|
}
|
if (SeriseMonitor.Points.Count == 0)
|
{
|
SeriseMonitor.ShowInLegend = false;
|
}
|
else SeriseMonitor.ShowInLegend = true;
|
}
|
|
|
|
//添加方案取水量
|
private void GetAnaWater()
|
{
|
XYDiagram main_diagram = chartControl实时数据.Diagram as XYDiagram;
|
var axisTime = main_diagram.AxisX;
|
axisTime.VisualRange.Auto = true;
|
axisTime.WholeRange.Auto = true;
|
axisTime.WholeRange.SideMarginsValue = 0;
|
axisTime.VisualRange.SideMarginsValue = 0;
|
var SeriseMonitor = this.chartControl实时数据.Series[2];
|
SeriseMonitor.Points.Clear();
|
if (_Ana == null || !isSetData)
|
{
|
SeriseMonitor.ShowInLegend = false;
|
return;
|
}
|
foreach (var item in _Ana.PointTimes)
|
{
|
SeriseMonitor.Points.Add(new SeriesPoint(item.Time, item.RealFlow));
|
}
|
SeriseMonitor.ShowInLegend = true;
|
}
|
|
|
|
//比较
|
private void barBtnCompare_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
|
{
|
var dlg = new HistoryDlg();
|
dlg.SetBindingData(_Ana);
|
dlg.ShowDialog();
|
}
|
|
//日历check选择变换事件
|
private void checkEditCalendar_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
this.SetBindingData(ListDayTime);
|
}
|
|
//显示方案数据
|
private void barCheckData_CheckedChanged(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
|
{
|
isSetData = this.barCheckData.Checked;
|
var a = new CalcModel.AnaPrj();
|
GetAnaWater();
|
SetSeriseEle();
|
MergeCurrentModel(a, _LastYeay, _CurrentData);
|
if (this.barCheckData.Checked)
|
{
|
this.barCheckData.Caption = "隐藏方案数据";
|
}
|
else this.barCheckData.Caption = "显示方案数据";
|
}
|
|
|
//页面类合并
|
private void MergeCurrentModel(CalcModel.AnaPrj anaPrj, Model.RunParasData LastYeay, RunParasData currentData)
|
{
|
HistoryDataAPiHelper historyDataAPiHelper = new HistoryDataAPiHelper();
|
var LastYearIsOpen = historyDataAPiHelper.MergeTimeSlots(MergeList(LastYeay));
|
var CurrentDateOpen = historyDataAPiHelper.MergeTimeSlots(MergeList(currentData));
|
if (DateTime.Now.Date > ListDayTime && CurrentDateOpen != null && LastYearIsOpen != null && anaPrj != null)
|
{
|
_CurrentModel.Clear();
|
foreach (var model in CurrentDateOpen)
|
{
|
var CurrentDate = new CurrentModel
|
{
|
Name = "实际" + ListDayTime.ToString("(yyyy-MM-dd)"),
|
PumpCount = string.Format("{0}台泵", model.Item3.ToString()),
|
Time = model.Item1.ToString("HH:mm") + "-" + model.Item2.ToString("HH:mm"),
|
ElectricityPrice = model.Item4,
|
Water = model.Item5,
|
Electricity = model.Item6,
|
TimeSpan = (model.Item2 - model.Item1).TotalMinutes,
|
TotalEle = _CurrentData.Electric,
|
TotalElePrice = _CurrentData.Money,
|
TotalWater = _CurrentData.FlowIn,
|
QDSLN = Math.Round(model.Item6 * 1000 / model.Item5, 1)
|
};
|
_CurrentModel.Add(CurrentDate);
|
}
|
}
|
if (LastYearIsOpen != null && _Ana != null)
|
{
|
foreach (var model in LastYearIsOpen)
|
{
|
var LastYear = new CurrentModel
|
{
|
Name = "去年同期" + model.Item1.ToString("(yyyy-MM-dd)"),
|
PumpCount = string.Format("{0}台泵", model.Item3.ToString()),
|
Time = model.Item1.ToString("HH:mm") + "-" + model.Item2.ToString("HH:mm"),
|
ElectricityPrice = model.Item4,
|
Water = model.Item5,
|
Electricity = model.Item6,
|
TimeSpan = (model.Item2 - model.Item1).TotalMinutes,
|
TotalEle = _LastYeay.Electric,
|
TotalElePrice = _LastYeay.Money,
|
TotalWater = _LastYeay.FlowIn,
|
QDSLN = Math.Round(model.Item6 * 1000 / model.Item5, 1)
|
};
|
_CurrentModel.Add(LastYear);
|
}
|
}
|
if (_Ana != null && isSetData)
|
{
|
foreach (var item in _Ana.BlockTimes)
|
{
|
if (item.OpenPumpCount == 0)
|
{
|
continue;
|
}
|
var project = new CurrentModel
|
{
|
Name = "方案" + item.StartTime.ToString("(yyyy-MM-dd)"),
|
PumpCount = string.Format("{0}台泵", item.OpenPumpCount),
|
Time = item.StartTime.ToString("HH:mm") + "-" + item.EndTime.ToString("HH:mm"),
|
Electricity = Math.Round(item.SumPower / 1000, 2),
|
ElectricityPrice = Math.Round(item.SumMoney / 1000, 2),
|
Water = Math.Round(item.SumFlow, 2),
|
TimeSpan = (item.EndTime - item.StartTime).TotalMinutes,
|
TotalEle = Math.Round(_Ana.SumPower4Disp / 1000, 2),
|
TotalWater = _Ana.SumFlow4Disp,
|
TotalElePrice = Math.Round(_Ana.SumMoney / 1000, 2),
|
QDSLN = _Ana.QDSLN
|
|
};
|
_CurrentModel.Add(project);
|
}
|
}
|
this.bindingSource1.DataSource = _CurrentModel;
|
this.bindingSource1.ResetBindings(false);
|
}
|
|
|
//自定义合并
|
private void gridView2_CellMerge(object sender, CellMergeEventArgs e)
|
{
|
var gridViewPumpID1 = gridView2.GetRow(e.RowHandle1) as CurrentModel;
|
var gridViewPumpID2 = gridView2.GetRow(e.RowHandle2) as CurrentModel;
|
if (gridViewPumpID1 == gridViewPumpID2)
|
{
|
return;
|
}
|
if (gridViewPumpID1.Name != gridViewPumpID2.Name)
|
{
|
e.Merge = false;
|
e.Handled = true;
|
}
|
}
|
}
|
}
|
