//�������� private void barButtonItem12_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { IList<string> filedList = new List<string>(); IList<string> capList = new List<string>(); for (int i = 0; i < gridView1.Columns.Count; i++) { if (gridView1.Columns[i].Visible == true) { capList.Add(gridView1.Columns[i].Caption); filedList.Add(gridView1.Columns[i].FieldName); } } OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel�ļ�(*.xls)|*.xls"; string Message = ""; 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) continue; Ps_Table_Report area = new Ps_Table_Report(); area.ProjectID = MIS.ProgUID; foreach (DataColumn col in table.Columns) { if (col.ColumnName == "Num1" || col.ColumnName == "image1" || col.ColumnName == "image2") { //area.GetType().GetProperty(col.ColumnName).SetValue(area, Convert.ToInt32(table.Rows[i][col]), null); } else if (col.ColumnName == "TableID") { string con = " TableID='" + table.Rows[i][col].ToString() +"' and ProjectID='" + MIS.ProgUID + "'"; IList<Ps_Table_Report> templist = Common.Services.BaseService.GetList<Ps_Table_Report>("SelectPs_Table_ReportListByConn", con); if (templist.Count > 0) { Message = "[" + table.Rows[i][col].ToString() + "]"; } else { area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null); } } else { area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col], null); } } area.Num1 = Convert.ToInt32(Common.Services.BaseService.GetObject("SelectPs_Table_ReportMaxNum1", " ProjectID='" + MIS.ProgUID + "'")) + 1; area.image1 = new byte[0]; area.image2 = new byte[0]; Common.Services.BaseService.Create<Ps_Table_Report>(area); } InitData(); MessageBox.Show("������ɣ�"); if (Message.Length != 0) { MessageBox.Show("���ʶ" + Message + " �Ѿ����ڣ�δ�ظ���ӣ�"); } } catch { MessageBox.Show("��ʽ������ʧ�ܣ�"); } } }