//导出数据 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; } } }