private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FileClass.ExportExcel(this.gridControl1); //IList<string> col = new List<string>();//SelectAreaNameGroupByConn //IList<string> area = new List<string>(); //FrmOutput frm = new FrmOutput(); //AddCol(ref col, ref area); //frm.Column = col; frm.Area = area; //if (frm.ShowDialog() == DialogResult.OK) //{ // for (int i = 0; i < gridView1.Columns.Count; i++) // { // for (int j = 0; j < frm.Column.Count; j++) // { // if (frm.Column[j] == gridView1.Columns[i].Caption) // gridView1.Columns[i].Visible = false; // } // } // string conn = " and ("; // for (int j = 0; j < frm.VolLev.Count; j++) // { // if (j == frm.VolLev.Count - 1) // conn += "L1=" + frm.VolLev[j] + ")"; // else // conn += "L1=" + frm.VolLev[j] + " or "; // } // if (frm.Area.Count > 0) // conn += " and ("; // for (int i = 0; i < frm.Area.Count; i++) // { // if (frm.Area[i] == "空") // frm.Area[i] = ""; // if (i == frm.Area.Count - 1) // conn += "AreaName='" + frm.Area[i] + "')"; // else // { // conn += "AreaName='" + frm.Area[i] + "' or "; // } // } // //this.ctrlSubstation_Info1.RefreshDataOut(conn); // //this.ctrlSubstation_Info1.CalcTotal(conn); // FileClass.ExportExcel(this.gridControl1); // for (int i = 0; i < gridView1.Columns.Count; i++) // { // gridView1.Columns[i].Visible = true; // } // //this.ctrlSubstation_Info1.RefreshData1(); // //this.ctrlSubstation_Info1.CalcTotal(); //} }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FileClass.ExportExcel(this.ctrlProject_Sum1.GridControl); }
private void barButtonItem4_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FileClass.ExportExcel(this.Text, _unitHeader, this.gridControl1); }