//导出数据
private void barButtonItem4_ItemClick_1(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
for (int i = yAnge.StartYear; i <= yAnge.FinishYear; i++)
{
frm.ListYearsForChoose.Add(i);
}
frm.NoIncreaseRate = true;
if (frm.ShowDialog() == DialogResult.OK)
{
FrmResultPrint frma = new FrmResultPrint();
frma.IsSelect = _isSelect;
frma.Text = "220千伏供电平衡表";
frma.Dw1 = "单位：万千瓦";
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1, false), frm.ListChoosedYears);
frma.YearList = frm.ListChoosedYears;
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
DialogResult = DialogResult.OK;
}
}
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
for (int i = yAnge.StartYear; i <= yAnge.FinishYear; i++)
{
frm.ListYearsForChoose.Add(i);
}
frm.NoIncreaseRate = true;
if (frm.ShowDialog() == DialogResult.OK)
{
string con = "ProjectID='" + GetProjectID + "' ORDER BY Sort";
listTypes = Common.Services.BaseService.GetList("SelectPs_Table_220ResultByConn", con);
AddTotalRow(ref listTypes);
DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_220Result));
FrmResultPrint frma = new FrmResultPrint();
frma.IsSelect = _isSelect;
frma.Text = "220千伏电力平衡结果表";
frma.Dw1 = "单位：万千瓦";
treeList1.DataSource = dt;
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1,false), frm.ListChoosedYears);
listTypes = Common.Services.BaseService.GetList("SelectPs_Table_220ResultByConn", con);
DataTable dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_220Result));
treeList1.DataSource = dt1;
// SetValueNull();
//treeList1.ExpandAll();
frma.YearList = frm.ListChoosedYears;
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
//gcontrol = frm.gridControl1;
//title = frm.Title;
//unit = "单位：万元";
DialogResult = DialogResult.OK;
}
}
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Ps_YearRange range = oper.GetYearRange("Col5='" + GetProjectID + "' and Col4='" + OperTable.ph110 + "'");
FormChooseYears frm = new FormChooseYears();
for (int i = range.StartYear; i <= range.FinishYear; i++)
{
frm.ListYearsForChoose.Add(i);
}
frm.NoIncreaseRate = true;
if (frm.ShowDialog() == DialogResult.OK)
{
//////////Form1Result f = new Form1Result();
//////////f.CanPrint = base.PrintRight;
//////////f.Text = Title = "本地区电力平衡表";// + frm.ListChoosedYears[0].Year + "～" + frm.ListChoosedYears[frm.ListChoosedYears.Count - 1].Year + "年经济和电力发展实绩";
//////////f.ColTitleWidth = 250;
//////////f.ColTitleAlign = DevExpress.Utils.HorzAlignment.Default;
//////////f.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1), frm.ListChoosedYears);
//////////f.IsSelect = IsSelect;
//////////DialogResult dr = f.ShowDialog();
//////////if (IsSelect && dr == DialogResult.OK)
//////////{
////////// Gcontrol = f.gridControl1;
////////// Unit = "单位：万千瓦";
////////// DialogResult = DialogResult.OK;
//////////}
Form21Print frma = new Form21Print();
frma.IsSelect = _isSelect;
frma.Text = "110千伏分区分年电容量计算表";
frma.Dw1 = "单位：万千瓦、万千伏安";
DataTable dt = ConvertTreeListToDataTable(treeList1,false);
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1,false), frm.ListChoosedYears);
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
//gcontrol = frm.gridControl1;
//title = frm.Title;
//unit = "单位：万元";
DialogResult = DialogResult.OK;
}
}
}
private void print()
{
FormChooseYears frm = new FormChooseYears();
frm.NoIncreaseRate = true;
foreach (TreeListColumn column in treeList1.Columns)
{
if (column.Caption.IndexOf("年") > 0)
{
frm.ListYearsForChoose.Add((int)column.Tag);
}
}
if (frm.ShowDialog() == DialogResult.OK)
{
Form1ResultTJ f = new Form1ResultTJ();
f.CanPrint = base.PrintRight;
f.Text = Title = "本地区无功平衡表";// +frm.ListChoosedYears[0].Year + "～" + frm.ListChoosedYears[frm.ListChoosedYears.Count - 1].Year + "年经济和电力发展实绩";
f.UnitHeader = Unit = "单位：万千瓦、万千乏";
f.ColTitleWidth = 230;
Ps_Table_WG table_yd = new Ps_Table_WG();
f.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1, false), frm.ListChoosedYears);
f.IsSelect = IsSelect;
DialogResult dr = f.ShowDialog();
if (IsSelect && dr == DialogResult.OK)
{
Gcontrol = f.gridControl1;
DialogResult = DialogResult.OK;
}
}
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
Ps_YearRange range = oper.GetYearRange("Col5='" + GetProjectID + "' and Col4='" + OperTable.power + "'");
FormChooseYears frm = new FormChooseYears();
for (int i = range.StartYear; i <= range.FinishYear; i++)
{
frm.ListYearsForChoose.Add(i);
}
frm.NoIncreaseRate = true;
if (frm.ShowDialog() == DialogResult.OK)
{
string con = "ProjectID='" + GetProjectID + "' ORDER BY Sort";
listTypes = Common.Services.BaseService.GetList("SelectPs_PowerBuildByConn", con);
//AddTotalRow(ref listTypes);
AddRows(ref listTypes);
DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_PowerBuild));
FrmPowerPrint frma = new FrmPowerPrint();
frma.IsSelect = _isSelect;
frma.Text = "电源建设规划表";
frma.IsBand = false;
// frma.BHe = false;
frma.SetGridWidth(70, "序号", 250);
treeList1.DataSource = dt;
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1, false), frm.ListChoosedYears);
listTypes = Common.Services.BaseService.GetList("SelectPs_PowerBuildByConn", con);
DataTable dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_PowerBuild));
treeList1.DataSource = dt1;
SetValueNull();
//treeList1.ExpandAll();
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
//gcontrol = frm.gridControl1;
//title = frm.Title;
//unit = "单位：万元";
DialogResult = DialogResult.OK;
}
}
}
private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
for (int i = yAnge.StartYear; i <= yAnge.FinishYear; i++)
{
frm.ListYearsForChoose.Add(i);
}
frm.NoIncreaseRate = true;
if (frm.ShowDialog() == DialogResult.OK)
{
Form21Print frma = new Form21Print();
frma.IsSelect = _isSelect;
frma.Text = "110千伏分区分年容载比计算表";
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1, true), frm.ListChoosedYears);
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
DialogResult = DialogResult.OK;
}
}
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
foreach (TreeListColumn column in treeList1.Columns)
{
if (column.FieldName.IndexOf("年") > 0)
{
frm.ListYearsForChoose.Add((int)column.Tag);
}
}
if(frm.ShowDialog() == DialogResult.OK)
{
Form1Result f = new Form1Result();
f.CanPrint = base.EditRight;
f.Text = Title = "本地区" + frm.ListChoosedYears[0].Year + "～" + frm.ListChoosedYears[frm.ListChoosedYears.Count - 1].Year + "年分区县供电实绩";
f.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1), frm.ListChoosedYears);
f.IsSelect = IsSelect;
DialogResult dr = f.ShowDialog();
if (IsSelect && dr == DialogResult.OK)
{
Gcontrol = f.gridControl1;
Unit = "单位：万千瓦时";
DialogResult = DialogResult.OK;
}
}
}
