private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (this.gridView2.FocusedRowHandle > -1) { IList<string> filedList = new List<string>(); IList<string> capList = new List<string>(); for (int i = 0; i < gridView1.Columns.Count; i++) { capList.Add(gridView1.Columns[i].Caption); filedList.Add(gridView1.Columns[i].FieldName); } OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel文件(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { try { DataTable table = OperTable.GetExcel(op.FileName, filedList, capList); for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i][0].ToString().IndexOf("合计") > 0 || table.Rows[i][1].ToString().IndexOf("合计") > 0) continue; Ps_Table_AreaData area = new Ps_Table_AreaData(); area.ID += "|" + ProjectID; area.SortID = OperTable.GetAreaMaxSort()+1; area.ParentID = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "ID").ToString(); area.ProjectID = ProjectID; foreach (DataColumn col in table.Columns) { if(col.ColumnName=="Yearf") area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(table.Rows[i][col].ToString()), null); else area.GetType().GetProperty(col.ColumnName).SetValue(area, double.Parse(table.Rows[i][col].ToString()), null); } Common.Services.BaseService.Create<Ps_Table_AreaData>(area); } } catch { } InitGrid1(); } } else MessageBox.Show("没有选择地区(如果没有请添加一个)","导入EXCEL",MessageBoxButtons.OK); }