using DevExpress.XtraCharts;
|
using DevExpress.XtraEditors;
|
using NPOI.HSSF.UserModel;
|
using NPOI.SS.UserModel;
|
using System.IO;
|
using Yw;
|
using Yw.WinFrmUI;
|
|
namespace IBox.WinFrmUI
|
{
|
public partial class IBoxFormEnergyAnalysis : DocumentPage
|
{
|
|
|
public IBoxFormEnergyAnalysis()
|
{
|
this.PageTitle.Caption = "能耗分析";
|
InitializeComponent();
|
|
_series_ysl.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
|
_series_ydl.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
|
_series_qds.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True;
|
|
((SideBySideBarSeriesLabel)_series_ysl.Label).Position = BarSeriesLabelPosition.Top;
|
((SideBySideBarSeriesLabel)_series_ydl.Label).Position = BarSeriesLabelPosition.Top;
|
|
_series_ysl.CrosshairLabelPattern = "用水量:{V:N2} m³";
|
_series_ydl.CrosshairLabelPattern = "用电量:{V:N2} kW·h";
|
_series_qds.CrosshairLabelPattern = "千吨水能耗:{V:N2} kW·h/km³";
|
}
|
|
public void InitDate()
|
{
|
this.dateEditStartDate.Text = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
|
this.dateEditEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
|
}
|
|
public void HideButton()
|
{
|
//simpleButton1.Visible = simpleButton2.Visible = simpleButton5.Visible = false;
|
layoutControlItem3.Visibility = layoutControlItem4.Visibility = layoutControlItem10.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
|
}
|
|
List<PumpEnergyViewModel> _models;
|
/// <summary>
|
/// 绑定数据
|
/// </summary>
|
/// <param name="models"></param>
|
public void BindData(List<PumpEnergyViewModel> models)
|
{
|
_models = models;
|
this.pumpEnergyViewModelBindingSource.DataSource = models;
|
this.gridView4.RefreshData();
|
SetChart(models);
|
}
|
|
// private XYDiagram _diagram_xy { get { return this.chartControl1.Diagram as XYDiagram; } }
|
private Series _series_ysl { get { return this.chartControl1.Series[1]; } }
|
private Series _series_ydl { get { return this.chartControl1.Series[0]; } }
|
private Series _series_qds { get { return this.chartControl1.Series[2]; } }
|
|
public void SetChart(List<PumpEnergyViewModel> models)
|
{
|
this.chartControl1.BeginInit();
|
|
_series_ysl.Points.Clear();
|
_series_ydl.Points.Clear();
|
_series_qds.Points.Clear();
|
foreach (var item in models)
|
{
|
_series_ysl.Points.Add(new SeriesPoint(item.Day, item.Supply));
|
_series_ydl.Points.Add(new SeriesPoint(item.Day, item.Electricity));
|
_series_qds.Points.Add(new SeriesPoint(item.Day, item.EnergyOfWater));
|
}
|
|
|
this.chartControl1.EndInit();
|
}
|
|
private void EboxFormEnergyAnalysis_Load(object sender, EventArgs e)
|
{
|
InitDate();
|
Search();
|
}
|
|
public void Search()
|
{
|
var m = new GetCalcValueModel()
|
{
|
StartDate = DateTime.Parse(this.dateEditStartDate.EditValue.ToString()),
|
EndDate = DateTime.Parse(this.dateEditEndDate.EditValue.ToString()),
|
};
|
|
SendText(IBoxHelper.startCode + IBoxHelper.getenergyanalyCode + IBoxHelper.paramCode + JsonHelper.Object2Json(m) + IBoxHelper.endCode);
|
}
|
|
public event EventHandler<string> SendData;
|
private void SendText(string content)
|
{
|
if (SendData != null)
|
{
|
SendData?.Invoke(null, content);
|
|
}
|
else
|
{
|
if (IBoxHelper.Ping())
|
{
|
var smsg = content.Split(new string[] { IBoxHelper.paramCode,IBoxHelper.startCode }, StringSplitOptions.RemoveEmptyEntries);
|
if (smsg.Length < 2)
|
{
|
return;
|
}
|
switch (smsg[0].Trim())
|
{
|
case IBoxHelper.getenergyanalyCode:
|
{
|
var order = IBoxHelper.HttpGet(content);
|
var result = IBoxHelper.GetContent(order);
|
if (!string.IsNullOrEmpty(result))
|
{
|
var model = JsonHelper.Json2Object<List<PumpEnergyViewModel>>(result);
|
BindData(model);
|
}
|
break;
|
}
|
default:
|
IBoxHelper.HttpGet(content);
|
break;
|
}
|
}
|
else
|
{
|
MessageBoxHelper.ShowWarning("网络连接失败，请检查网络");
|
}
|
}
|
}
|
/// <summary>
|
/// 查询
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void simpleButton1_Click(object sender, EventArgs e)
|
{
|
Search();
|
}
|
|
/// <summary>
|
/// 导出
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void simpleButton2_Click(object sender, EventArgs e)
|
{
|
ExportXLS();
|
}
|
|
public void ExportXLS()
|
{
|
try
|
{
|
if (_models == null || _models.Count == 0)
|
{
|
XtraMessageBox.Show("没有可导出的数据!");
|
return;
|
}
|
|
var dlg = new SaveFileDialog();
|
dlg.Filter = "EXCEL 文件(*.xls)|*.xls";
|
if (dlg.ShowDialog() != DialogResult.OK)
|
return;
|
|
HSSFWorkbook theBook = new HSSFWorkbook();
|
var theSheet1 = theBook.CreateSheet("Sheet1");
|
|
IRow rowTile = theSheet1.CreateRow(0);
|
rowTile.CreateCell(0).SetCellValue("日期");
|
rowTile.CreateCell(1).SetCellValue("用水量(m³)");
|
rowTile.CreateCell(2).SetCellValue("用电量(kW·h)");
|
rowTile.CreateCell(3).SetCellValue("千吨水能耗(kW·h/km³)");
|
|
|
for (int rowIndex = 1; rowIndex <= _models.Count; rowIndex++)
|
{
|
int col = 0;
|
IRow row = theSheet1.CreateRow(rowIndex);
|
var celValue = _models[rowIndex - 1].Day;
|
var dt = DateTime.Parse(celValue);
|
row.CreateCell(col).SetCellValue(celValue + " " + dt.ToString("dddd"));
|
col++;
|
row.CreateCell(col).SetCellValue((double)_models[rowIndex - 1].Supply);
|
col++;
|
row.CreateCell(col).SetCellValue((double)_models[rowIndex - 1].Electricity);
|
col++;
|
row.CreateCell(col).SetCellValue((double)_models[rowIndex - 1].EnergyOfWater);
|
col++;
|
}
|
|
//强制Excel在打开时重新计算所有公式
|
theSheet1.ForceFormulaRecalculation = true;
|
using (FileStream fs = File.OpenWrite(dlg.FileName))
|
{
|
theBook.Write(fs);
|
}
|
XtraMessageBox.Show("导出成功");
|
|
}
|
catch (Exception ex)
|
{
|
XtraMessageBox.Show(ex.ToString());
|
}
|
}
|
|
/// <summary>
|
/// 前三个月
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void simpleButton3_Click(object sender, EventArgs e)
|
{
|
this.dateEditStartDate.Text = DateTime.Now.AddMonths(-3).ToString("yyyy-MM-dd");
|
this.dateEditEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
|
Search();
|
}
|
|
/// <summary>
|
/// 前一个月
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void simpleButton4_Click(object sender, EventArgs e)
|
{
|
this.dateEditStartDate.Text = DateTime.Now.AddMonths(-1).ToString("yyyy-MM-dd");
|
this.dateEditEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
|
Search();
|
}
|
|
/// <summary>
|
/// 前半个月
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void simpleButton6_Click(object sender, EventArgs e)
|
{
|
this.dateEditStartDate.Text = DateTime.Now.AddDays(-15).ToString("yyyy-MM-dd");
|
this.dateEditEndDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
|
Search();
|
}
|
|
private void simpleButton5_Click(object sender, EventArgs e)
|
{
|
Check();
|
}
|
|
/// <summary>
|
/// 校验
|
/// </summary>
|
public void Check()
|
{
|
var dlg = new AnalyDayForm();
|
if (dlg.ShowDialog() == DialogResult.OK)
|
{
|
var dt = dlg.CurrDateTime;
|
SendText(IBoxHelper.startCode + IBoxHelper.analydayCode + IBoxHelper.paramCode + dt + IBoxHelper.endCode);
|
MessageBoxHelper.ShowInfo("操作成功");
|
}
|
}
|
|
private void gridView4_CustomColumnDisplayText(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDisplayTextEventArgs e)
|
{
|
if (e.Column.FieldName == "Day")
|
{
|
var celValue = e.Value.ToString();
|
var dt = DateTime.Parse(celValue);
|
e.DisplayText = celValue + " " + dt.ToString("dddd");
|
}
|
}
|
}
|
|
}
|
