/// <summary> /// 添加对象 /// </summary> public void AddObject() { //检查对象链表是否已经加载 if (ObjectList == null) { return; } //新建对象 PW_tb3b obj = new PW_tb3b(); obj.UID = Guid.NewGuid().ToString(); obj.col7 = type; //执行添加操作 using (FrmPW3bDialog dlg = new FrmPW3bDialog()) { dlg.IsCreate = true; //设置新建标志 dlg.Object = obj; if (dlg.ShowDialog() != DialogResult.OK) { return; } } //将新对象加入到链表中 ObjectList.Add(obj); //刷新表格,并将焦点行定位到新对象上。 gridControl.RefreshDataSource(); GridHelper.FocuseRow(this.gridView, obj); }
/// <summary> /// 修改焦点对象 /// </summary> public void UpdateObject() { //获取焦点对象 PW_tb3b obj = FocusedObject; if (obj == null) { return; } //创建对象的一个副本 PW_tb3b objCopy = new PW_tb3b(); DataConverter.CopyTo <PW_tb3b>(obj, objCopy); //执行修改操作 using (FrmPW3bDialog dlg = new FrmPW3bDialog()) { dlg.Object = objCopy; //绑定副本 if (dlg.ShowDialog() != DialogResult.OK) { return; } } //用副本更新焦点对象 DataConverter.CopyTo <PW_tb3b>(objCopy, obj); //刷新表格 gridControl.RefreshDataSource(); }
private void InsertInfo() { string columnname = ""; try { DataTable dts = new DataTable(); OpenFileDialog op = new OpenFileDialog(); op.Filter = "Excel文件(*.xls)|*.xls"; if (op.ShowDialog() == DialogResult.OK) { dts = GetExcel(op.FileName); IList <PW_tb3b> lii = new List <PW_tb3b>(); DateTime s8 = DateTime.Now; for (int i = 0; i < dts.Rows.Count; i++) { PW_tb3b l1 = new PW_tb3b(); foreach (DataColumn dc in dts.Columns) { columnname = dc.ColumnName; //if (dts.Rows[i][dc.ColumnName].ToString() == "") // continue; l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName].ToString(), null); } lii.Add(l1); } foreach (PW_tb3b lll in lii) { PW_tb3b l1 = new PW_tb3b(); IList <PW_tb3b> list = new List <PW_tb3b>(); //{ lll.UID = Guid.NewGuid().ToString(); lll.col7 = type; Services.BaseService.Create <PW_tb3b>(lll); //} } this.ctrlProject_Sum1.RefreshData(); } } catch (Exception ex) { MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确!"); } }
/// <summary> /// 刷新表格中的数据 /// </summary> /// <returns>ture:成功 false:失败</returns> public bool RefreshData() { try { this.gridView.GroupPanelText = "线路导线截面详情表"; PW_tb3b p = new PW_tb3b(); p.col7 = type; IList <PW_tb3b> list = Services.BaseService.GetList <PW_tb3b>("SelectPW_tb3bListbyCol7", p); this.gridControl.DataSource = list; } catch (Exception exc) { Debug.Fail(exc.Message); HandleException.TryCatch(exc); return(false); } return(true); }
/// <summary> /// 删除焦点对象 /// </summary> public void DeleteObject() { //获取焦点对象 PW_tb3b obj = FocusedObject; if (obj == null) { return; } //请求确认 if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes) { return; } //执行删除操作 try { Services.BaseService.Delete <PW_tb3b>(obj); } catch (Exception exc) { Debug.Fail(exc.Message); HandleException.TryCatch(exc); return; } this.gridView.BeginUpdate(); //记住当前焦点行索引 int iOldHandle = this.gridView.FocusedRowHandle; //从链表中删除 ObjectList.Remove(obj); //刷新表格 gridControl.RefreshDataSource(); //设置新的焦点行索引 GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle); this.gridView.EndUpdate(); }