//统计
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)
{
//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_TZGSByConn", con);
CalcYearVol();
AddTotalRow(ref listTypes);
DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_TZGS));
FrmResultPrint frma = new FrmResultPrint();
IList<string> strTe = new List<string>();
for (int k = yAnge.StartYear + 1; k <= yAnge.StartYear + 5; k++)
strTe.Add(k.ToString());
frma.YearList1 = strTe;
frma.IsSelect = _isSelect;
frma.Text = "电网建设项目投资估算表";
frma.Dw1 = "单位:千米、万千伏安、万元";
treeList1.DataSource = dt;
frma.bTzgs = true;
frma.IsBand = false;
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1, false), strTe);
listTypes = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", con);
CalcYearVol();
DataTable dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_TZGS));
treeList1.DataSource = dt1;
// SetValueNull();
//treeList1.ExpandAll();
if (frma.ShowDialog() == DialogResult.OK)
{
//gcontrol = frm.gridControl1;
//title = frm.Title;
//unit = "单位：万元";
DialogResult = DialogResult.OK;
}
// }
}
//导出数据
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 = tong + "ProjectID='" + GetProjectID + "' ORDER BY Sort";
string con = "ProjectID='" + GetProjectID + "' ORDER BY Sort";
listTypes = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", con);
CalcYearVol();
AddTotalRow(ref listTypes);
DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_TZGS));
FrmResultPrint frma = new FrmResultPrint();
IList<string> strTe = new List<string>();
if (xtraTabControl1.SelectedTabPageIndex == 0)
frma.Line = true;
else
frma.Line = false;
for (int k = yAnge.StartYear + 1; k <= yAnge.StartYear + 5; k++)
strTe.Add(k.ToString());
frma.YearList1 = strTe;
frma.IsSelect = _isSelect;
frma.Text = "电网建设项目投资估算表";
frma.Dw1 = "单位:千米、万千伏安、万元";
treeList1.DataSource = dt;
frma.bTzgs = true;
frma.IsBand = false;
frma.GridDataTable = ResultDataTable(ConvertTreeListToDataTable(treeList1, false), strTe);
listTypes = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", con);
CalcYearVol();
DataTable dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_TZGS));
// SetValueNull();
//treeList1.ExpandAll();
//if (== DialogResult.OK)
//{
// //gcontrol = frm.gridControl1;
// //title = frm.Title;
// //unit = "单位：万元";
// DialogResult = DialogResult.OK;
//}
frma.ShowDialog();
//Application.DoEvents();
//this.Cursor = Cursors.WaitCursor;
//treeList1.BeginUpdate();
//LoadData();
//treeList1.EndUpdate();
//this.Cursor = Cursors.Default;
//if (!base.AddRight)
//{
// barButtonItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
//}
treeList1.DataSource = dataTable;
// }
}