//统计 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 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.Dw1 = "单位:万千瓦、万千伏安"; frma.GridDataTable = ResultDataTable1(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(); 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_ElecPHByConn", con); AddTotalRow(ref listTypes); DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_ElecPH)); Form21Print frma = new Form21Print(); frma.IsSelect = _isSelect; frma.Text = "电量平衡表"; frma.Dw1 = "亿千瓦时"; 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_Table_ElecPHByConn", con); DataTable dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(Ps_Table_ElecPH)); 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; } } }