private void FrmBurdenMaxYear_Load(object sender, EventArgs e)
{
string pjt = " ProjectID='" + MIS.ProgUID + "'";
AreaList = Common.Services.BaseService.GetList<PS_Table_AreaWH>("SelectPS_Table_AreaWHByConn", pjt);
bandedGridView1.GroupPanelText = this.Text;
//IList<BurdenLine> list = Services.BaseService.GetStrongList<BurdenLine>();
IList<BurdenLine> list = Services.BaseService.GetList<BurdenLine>("SelectBurdenLineByWhere", " uid like '%" + Itop.Client.MIS.ProgUID + "%' order by BurdenDate");
int i = 1;
int yeardata = 0;
//IList<BurdenYear> li = new List<BurdenYear>();
BurdenYear by = new BurdenYear();
foreach (BurdenLine bl in list)
{
double burmax = 0;
burmax = Math.Max(bl.Hour1, bl.Hour2);
burmax = Math.Max(burmax, bl.Hour3);
burmax = Math.Max(burmax, bl.Hour4);
burmax = Math.Max(burmax, bl.Hour5);
burmax = Math.Max(burmax, bl.Hour6);
burmax = Math.Max(burmax, bl.Hour7);
burmax = Math.Max(burmax, bl.Hour8);
burmax = Math.Max(burmax, bl.Hour9);
burmax = Math.Max(burmax, bl.Hour10);
burmax = Math.Max(burmax, bl.Hour11);
burmax = Math.Max(burmax, bl.Hour12);
burmax = Math.Max(burmax, bl.Hour13);
burmax = Math.Max(burmax, bl.Hour14);
burmax = Math.Max(burmax, bl.Hour15);
burmax = Math.Max(burmax, bl.Hour16);
burmax = Math.Max(burmax, bl.Hour17);
burmax = Math.Max(burmax, bl.Hour18);
burmax = Math.Max(burmax, bl.Hour19);
burmax = Math.Max(burmax, bl.Hour20);
burmax = Math.Max(burmax, bl.Hour21);
burmax = Math.Max(burmax, bl.Hour22);
burmax = Math.Max(burmax, bl.Hour23);
burmax = Math.Max(burmax, bl.Hour24);
if (yeardata != bl.BurdenDate.Year)
{
if (yeardata == 0)
{
yeardata = bl.BurdenDate.Year;
by = new BurdenYear();
by.BurdenYears = yeardata;
by.Values = burmax;
by.BurdenDate = bl.BurdenDate;
by.AreaID = bl.AreaID;
}
else
{
li.Add(by);
yeardata = bl.BurdenDate.Year;
by = new BurdenYear();
by.BurdenYears = yeardata;
by.Values = burmax;
by.BurdenDate = bl.BurdenDate;
by.AreaID = bl.AreaID;
}
}
else
{
if (by.Values < burmax)
{
by.Values = burmax;
by.BurdenDate = bl.BurdenDate;
by.AreaID = bl.AreaID;
}
//by.Values = Math.Max(by.Values,burmax);
//by.BurdenDate = bl.BurdenDate;
}
if(i==list.Count)
li.Add(by);
i++;
}
DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand1 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
gridBand1.Caption = "ʱ��";
gridBand1.Width = 100;
gridBand1.Name = "gridBand1";
gridBand1.AppearanceHeader.Options.UseTextOptions = true;
gridBand1.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.bandedGridView1.Bands.Add(gridBand1);
//DevExpress.XtraGrid.Views.BandedGrid.GridBand gridBand2 = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
//gridBand2.Caption = "ʱ��";
//gridBand2.Name = "gridBand2";
//gridBand2.AppearanceHeader.Options.UseTextOptions = true;
//gridBand2.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
//gridBand1.Children.Add(gridBand2);
DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn gridColumn1 = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
gridColumn1.Caption = "ʱ��";
gridColumn1.FieldName = "s" ;
gridColumn1.Name = "gridColumn1";
gridColumn1.Visible = true;
gridColumn1.AppearanceCell.Options.UseTextOptions = true;
gridColumn1.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandedGridView1.Columns.Add(gridColumn1);
gridBand1.Columns.Add(gridColumn1);
DataTable dt = new DataTable();
dt.Columns.Add("s", typeof(string));
int listCount = li.Count;
int numi = 0;
int numj = 0;
int numk = 0;
DevExpress.XtraGrid.Views.BandedGrid.GridBand[] gridBand = new DevExpress.XtraGrid.Views.BandedGrid.GridBand[listCount];
DevExpress.XtraGrid.Views.BandedGrid.GridBand[] gridBandDate = new DevExpress.XtraGrid.Views.BandedGrid.GridBand[listCount];
DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] gridColumn = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[listCount];
foreach (BurdenYear bys in li)
{
gridBand[numi] = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
gridBand[numi].Caption = FindArea(bys.AreaID)+"_"+ bys.BurdenYears.ToString() + "��";
gridBand[numi].Width = 100;
gridBand[numi].Name = "gridBand" + bys.BurdenYears.ToString();
gridBand[numi].AppearanceHeader.Options.UseTextOptions = true;
gridBand[numi].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
this.bandedGridView1.Bands.Add(gridBand[numi]);
gridBandDate[numj] = new DevExpress.XtraGrid.Views.BandedGrid.GridBand();
gridBandDate[numj].Caption = bys.BurdenDate.ToString("MM��dd��");
gridBandDate[numj].Name = "gridBand" + bys.BurdenDate.ToString("yyyyMMdd");
gridBandDate[numj].AppearanceHeader.Options.UseTextOptions = true;
gridBandDate[numj].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
gridBand[numi].Children.Add(gridBandDate[numj]);
gridColumn[numk] = new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn();
gridColumn[numk].Caption = "Year" + bys.BurdenYears.ToString();
gridColumn[numk].FieldName = "Year" + bys.BurdenYears.ToString();
gridColumn[numk].Name = "Year" + bys.BurdenYears.ToString();
gridColumn[numk].Visible = true;
gridColumn[numk].Width = 130;
gridColumn[numk].AppearanceCell.Options.UseTextOptions = true;
gridColumn[numk].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bandedGridView1.Columns.Add(gridColumn[numk]);
gridBandDate[numj].Columns.Add(gridColumn[numk]);
numi++;
numj++;
numk++;
dt.Columns.Add("Year" + bys.BurdenYears.ToString(), typeof(double));
}
DataRow row = dt.NewRow();
row["s"] = "����";
foreach (BurdenYear bys1 in li)
{
row["Year" + bys1.BurdenYears.ToString()] = bys1.Values;
}
dt.Rows.Add(row);
gridControl1.DataSource = dt;
chart1.Series.Clear();
string seriesName = "���";
chart1.Series.Add(seriesName);
chart1.Series[seriesName].Type = SeriesChartType.Line;
chart1.Series[seriesName].BorderWidth = 2;
chart1.Series[seriesName].MarkerSize = 7;
chart1.Series[seriesName].MarkerStyle = (Dundas.Charting.WinControl.MarkerStyle)(2);
foreach (DataColumn dc in dt.Columns)
{
if (dc.ColumnName == "s")
continue;
try { if (int.Parse(dc.ColumnName.Replace("Year", "")) > 10000)continue; }
catch { }
string coname = dc.ColumnName.Replace("Year", "");
double YVal = 0;
try
{
YVal = (double)dt.Rows[0][dc.ColumnName];
}
catch { }
chart1.Series[seriesName].Points.AddXY(coname, YVal);
}
if(!PrintRight)
barButtonItem2.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
}
private void build_YearMAX()
{
string pjt = " ProjectID='" + MIS.ProgUID + "'";
IList<PS_Table_AreaWH> AreaList = Common.Services.BaseService.GetList<PS_Table_AreaWH>("SelectPS_Table_AreaWHByConn", pjt);
Dictionary<string, Columqk> viscol = new Dictionary<string, Columqk>();
string title = "年最大负荷数据";
IList<BurdenLine> list = Services.BaseService.GetList<BurdenLine>("SelectBurdenLineByWhere", " uid like '%" + Itop.Client.MIS.ProgUID + "%' order by BurdenDate");
int i = 1;
int yeardata = 0;
//IList<BurdenYear> li = new List<BurdenYear>();
BurdenYear by = new BurdenYear();
foreach (BurdenLine bl in list)
{
double burmax = 0;
burmax = Math.Max(bl.Hour1, bl.Hour2);
burmax = Math.Max(burmax, bl.Hour3);
burmax = Math.Max(burmax, bl.Hour4);
burmax = Math.Max(burmax, bl.Hour5);
burmax = Math.Max(burmax, bl.Hour6);
burmax = Math.Max(burmax, bl.Hour7);
burmax = Math.Max(burmax, bl.Hour8);
burmax = Math.Max(burmax, bl.Hour9);
burmax = Math.Max(burmax, bl.Hour10);
burmax = Math.Max(burmax, bl.Hour11);
burmax = Math.Max(burmax, bl.Hour12);
burmax = Math.Max(burmax, bl.Hour13);
burmax = Math.Max(burmax, bl.Hour14);
burmax = Math.Max(burmax, bl.Hour15);
burmax = Math.Max(burmax, bl.Hour16);
burmax = Math.Max(burmax, bl.Hour17);
burmax = Math.Max(burmax, bl.Hour18);
burmax = Math.Max(burmax, bl.Hour19);
burmax = Math.Max(burmax, bl.Hour20);
burmax = Math.Max(burmax, bl.Hour21);
burmax = Math.Max(burmax, bl.Hour22);
burmax = Math.Max(burmax, bl.Hour23);
burmax = Math.Max(burmax, bl.Hour24);
if (yeardata != bl.BurdenDate.Year)
{
if (yeardata == 0)
{
yeardata = bl.BurdenDate.Year;
by = new BurdenYear();
by.BurdenYears = yeardata;
by.Values = burmax;
by.BurdenDate = bl.BurdenDate;
by.AreaID = bl.AreaID;
}
else
{
li.Add(by);
yeardata = bl.BurdenDate.Year;
by = new BurdenYear();
by.BurdenYears = yeardata;
by.Values = burmax;
by.BurdenDate = bl.BurdenDate;
by.AreaID = bl.AreaID;
}
}
else
{
if (by.Values < burmax)
{
by.Values = burmax;
by.BurdenDate = bl.BurdenDate;
by.AreaID = bl.AreaID;
}
//by.Values = Math.Max(by.Values,burmax);
//by.BurdenDate = bl.BurdenDate;
}
if (i == list.Count)
li.Add(by);
i++;
}
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add("s", typeof(string));
viscol["s"] = new Columqk("时间",3,2);
int listCount = li.Count;
int numi = 0;
int numj = 0;
int numk = 0;
foreach (BurdenYear bys in li)
{
numi++;
numj++;
numk++;
dt.Columns.Add("Year" + bys.BurdenYears.ToString(), typeof(double));
viscol["Year" + bys.BurdenYears.ToString()] = new Columqk(FindArea(bys.AreaID,AreaList) + "_" + bys.BurdenYears.ToString() + "年", 3, 2);
}
DataRow row = dt.NewRow();
row["s"] = "负荷";
foreach (BurdenYear bys1 in li)
{
row["Year" + bys1.BurdenYears.ToString()] = bys1.Values;
}
dt.Rows.Add(row);
if(!shjjbyyear)
{
creatsheetbydt(title, dt, viscol);
}
else
{
recreatsheetbydt(title, dt, viscol, 8);
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DataTable dataTable = new DataTable();
dataTable.Columns.Add("A", typeof(string));
dataTable.Columns.Add("B", typeof(bool));
dataTable.Columns.Add("C", typeof(bool));
dataTable.Rows.Clear();
foreach (BurdenYear bl in li)
{
DataRow newRow = dataTable.NewRow();
newRow["A"] = bl.BurdenYears;
newRow["B"] = false;
newRow["C"] = false;
dataTable.Rows.Add(newRow);
}
FormYears cy = new FormYears();
cy.DT = dataTable;
if (cy.ShowDialog() != DialogResult.OK)
return;
IList<BurdenYear> li1 = new List<BurdenYear>();
double values = 0;
int years = 0;
bool iszzl = false;
foreach (DataRow row in dataTable.Rows)
{
foreach (BurdenYear bl1 in li)
{
if ((bool)row["B"] && row["A"].ToString() == bl1.BurdenYears.ToString())
{
li1.Add(bl1);
if ((bool)row["C"])
{
BurdenYear by = new BurdenYear();
by.BurdenYears = 10000 + bl1.BurdenYears;
by.Values = Math.Round(Math.Pow(bl1.Values / values, 1.0 / (bl1.BurdenYears-years)) - 1, 4);
by.Values=Math.Round(by.Values, 3);
li1.Add(by);
iszzl = true;
values = bl1.Values;
years = bl1.BurdenYears;
}
if (!iszzl)
{
values = bl1.Values;
years = bl1.BurdenYears;
}
}
}
}
FrmBurdenMaxYear1 frm = new FrmBurdenMaxYear1();
if (!PrintRight)
{
frm.print = false;
}
frm.Text = this.Text;
frm.ObjList = li1;
frm.IsSelect = isSelect;
if (frm.ShowDialog() == DialogResult.OK && isSelect)
{
gcontrol = frm.Gcontrol;
title = frm.Title;
//unit = "��λ����ǧ��";
DialogResult = DialogResult.OK;
}
}