using System.Collections.Generic;
|
using System;
|
using System.Drawing.Drawing2D;
|
using System.IO;
|
using System.Text;
|
using System.Linq;
|
using System.Runtime.InteropServices.ComTypes;
|
using DevExpress.XtraCharts.Native;
|
using DevExpress.Utils.MVVM;
|
|
namespace IStation.WinFrmUI.Monitor
|
{
|
public partial class HistoryDataDlg : DocumentPage
|
{
|
public HistoryDataDlg()
|
{
|
InitializeComponent();
|
this.PageTitle.Caption = "历史数据";
|
this.SurfaceGuid = new SurfaceGuid()
|
{
|
Modular = eModular.Basic,
|
Function = this.PageTitle.Caption
|
};
|
this.gridView1.SetNormalView();
|
this.gridView1.OptionsView.ShowDetailButtons = true;
|
this.gridView1.OptionsDetail.ShowDetailTabs = false;
|
}
|
|
|
private List<HistoryDataHelper> _historyDatas =new List<HistoryDataHelper>();
|
string connect1;
|
string connect2;
|
string connect3;
|
string connect4;
|
string connect5;
|
|
List<HistoryDataHelper> filteredList = new List<HistoryDataHelper>(); //过滤选择后绑定的list
|
//初始化
|
private void HistoryDataDlg_Load(object sender, System.EventArgs e)
|
{
|
WaitFrmHelper.ShowWaitForm();
|
HistoryDataHelper historyDataHelper = new HistoryDataHelper();
|
filteredList = historyDataHelper.GetHistoryData();
|
foreach (var item in filteredList)
|
{
|
string[] arr1 = item.pump1.Split(new char[] { ';' });
|
if (arr1.Length > 1)
|
connect1 = arr1[0] + Environment.NewLine + arr1[1];
|
else connect1 = arr1[0];
|
string[] arr2 = item.pump2.Split(new char[] { ';' });
|
if (arr2.Length > 1)
|
connect2 = arr2[0]+ Environment.NewLine + arr2[1];
|
else connect2 = arr2[0];
|
string[] arr3 = item.pump3.Split(new char[] { ';' });
|
if (arr3.Length > 1)
|
connect3 = arr3[0] + Environment.NewLine + arr3[1];
|
else connect3 = arr3[0];
|
string[] arr4 = item.pump4.Split(new char[] { ';' });
|
if (arr4.Length > 1)
|
connect4 = arr4[0] + Environment.NewLine + arr4[1];
|
else connect4 = arr4[0];
|
string[] arr5 = item.pump5.Split(new char[] { ';' });
|
if (arr5.Length > 1)
|
connect5 = arr5[0] + Environment.NewLine + arr5[1];
|
else connect5 = arr5[0];
|
var a = new HistoryDataHelper
|
{
|
DateTime = item.DateTime,
|
electricity = item.electricity,
|
water = item.water,
|
pump1 = connect1,
|
pump2 = connect2,
|
pump3 = connect3,
|
pump4 = connect4,
|
pump5 = connect5,
|
};
|
_historyDatas.Add(a);
|
connect1 = null; connect2=null; connect3=null; connect4=null;
|
connect5= null;
|
}
|
RefreshByDay();
|
WaitFrmHelper.HideWaitForm();
|
}
|
|
|
//刷新时间
|
private void BtnRefresh_Click(object sender, EventArgs e)
|
{
|
RefreshByDay();
|
}
|
|
private void RefreshByDay()
|
{
|
HistoryDataHelper historyDataHelper = new HistoryDataHelper();
|
string Starttime=this.BtnStartYear.EditValue + "/"+this.BtnStartMonth.EditValue;
|
int daysInMonth = DateTime.DaysInMonth(Convert.ToInt32( BtnEndYear.EditValue), Convert.ToInt32( BtnEndMonth.EditValue));
|
// 构建新的日期对象，将日期设置为该月的最后一天
|
DateTime EndTimeLastDay = new DateTime(Convert.ToInt32(BtnEndYear.EditValue), Convert.ToInt32(BtnEndMonth.EditValue), daysInMonth);
|
filteredList = _historyDatas
|
.Where(item => item.DateTime >= Convert.ToDateTime( Starttime) && item.DateTime <=Convert.ToDateTime(EndTimeLastDay))
|
.ToList();
|
this.HistorybindingSource.DataSource = filteredList;
|
this.HistorybindingSource.ResetBindings(true);
|
TimeSpan timeSpan1=TimeSpan.FromHours(0);
|
TimeSpan timeSpan2 = TimeSpan.FromHours(0);
|
TimeSpan timeSpan3 = TimeSpan.FromHours(0); ;
|
TimeSpan timeSpan4 = TimeSpan.FromHours(0); ;
|
TimeSpan timeSpan5 = TimeSpan.FromHours(0);
|
double arevageElectricity=0; //平均用电量
|
double waterElectricity = 0; //平均取水量
|
foreach (var item in filteredList)
|
{
|
arevageElectricity += item.electricity;
|
}
|
foreach (var item in filteredList)
|
{
|
waterElectricity += item.water;
|
}
|
var timeList=historyDataHelper.GetDataModel(filteredList);
|
foreach (var item in timeList)
|
{
|
foreach (var time in item.timespan1)
|
{
|
timeSpan1+= Convert.ToDateTime( time.EndTime) -Convert.ToDateTime( time.StartTime);
|
}
|
foreach (var time in item.timespan2)
|
{
|
timeSpan2 += Convert.ToDateTime(time.EndTime) - Convert.ToDateTime(time.StartTime);
|
}
|
foreach (var time in item.timespan3)
|
{
|
timeSpan3 += Convert.ToDateTime(time.EndTime) - Convert.ToDateTime(time.StartTime);
|
}
|
foreach (var time in item.timespan4)
|
{
|
timeSpan4 += Convert.ToDateTime(time.EndTime) - Convert.ToDateTime(time.StartTime);
|
}
|
foreach (var time in item.timespan5)
|
{
|
timeSpan5 += Convert.ToDateTime(time.EndTime) - Convert.ToDateTime(time.StartTime);
|
}
|
}
|
this.TimeSpan1.Text = Math.Round(timeSpan1.TotalHours/timeList.Count,0).ToString();
|
this.TimeSpan2.Text = Math.Round(timeSpan2.TotalHours / timeList.Count, 0).ToString();
|
this.TimeSpan3.Text = Math.Round(timeSpan3.TotalHours / timeList.Count, 0).ToString();
|
this.TimeSpan4.Text = Math.Round(timeSpan4.TotalHours / timeList.Count, 0).ToString();
|
this.TimeSpan5.Text = Math.Round(timeSpan5.TotalHours / timeList.Count, 0).ToString();
|
|
this.arevageWater.Text= Math.Round( waterElectricity/ filteredList.Count,2).ToString();
|
this.arevageElectricity.Text = Math.Round(arevageElectricity/filteredList.Count, 2).ToString();
|
|
}
|
}
|
|
}
|
