//添加 private void barButtonItem7_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MessageBox.Show("您没有权限进行此项操作!"); return; } FrmTableReportEdit frm = new FrmTableReportEdit(); Ps_Table_Report newptr = new Ps_Table_Report(); newptr.ProjectID = MIS.ProgUID; newptr.Num1 = Convert.ToInt32(Common.Services.BaseService.GetObject("SelectPs_Table_ReportMaxNum1", " ProjectID='" + MIS.ProgUID + "'")) + 1; frm.ptr = newptr; frm.Text = "添加报表管理信息"; frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { try { Common.Services.BaseService.Create <Ps_Table_Report>(frm.ptr); InitData(); } catch (Exception) { throw; } } }
//删除 private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (gridView1.FocusedRowHandle < 0) { return; } if (!base.DeleteRight) { MessageBox.Show("您没有权限进行此项操作!"); return; } try { if (MessageBox.Show("确定要删除数据?", "询问", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { Ps_Table_Report newptr = (Ps_Table_Report)gridView1.GetRow(gridView1.FocusedRowHandle); Common.Services.BaseService.Delete <Ps_Table_Report>(newptr); InitData(); } } catch (Exception) { throw; } }
//导入数据 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("格式有误,导入失败!"); } } }