private void barButtonItem13_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } //if (treeList1.FocusedNode.ParentNode == null) //{ // MsgBox.Show("一级分类名称不能修改!"); // return; //} FormTypeTitle frm = new FormTypeTitle(); frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改项目名"; if (frm.ShowDialog() == DialogResult.OK) { try { PowerStuffTypes psp_Type = Services.BaseService.GetOneByKey <PowerStuffTypes>(treeList1.FocusedNode["ID"].ToString()); psp_Type.Title = frm.TypeTitle; Common.Services.BaseService.Update <PowerStuffTypes>(psp_Type); treeList1.FocusedNode.SetValue("Title", frm.TypeTitle); } catch (Exception ex) { MsgBox.Show("修改出错:" + ex.Message); } } }
private void barButtonItem11_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FormTypeTitle frm = new FormTypeTitle(); frm.Text = "增加项目"; if (frm.ShowDialog() == DialogResult.OK) { PowerStuffTypes psp_Type = new PowerStuffTypes(); psp_Type.Title = frm.TypeTitle; psp_Type.Flag = 0; psp_Type.Flag2 = typeFlag2; psp_Type.ParentID = 0; try { psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPowerStuffTypes", psp_Type); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow())); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } } }
private void barButtonItem12_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } FormTypeTitle frm = new FormTypeTitle(); frm.Text = "增加" + focusedNode.GetValue("Title") + "的子项目"; if (frm.ShowDialog() == DialogResult.OK) { PowerStuffTypes psp_Type = new PowerStuffTypes(); psp_Type.Title = frm.TypeTitle; psp_Type.Flag = (int)focusedNode.GetValue("Flag"); psp_Type.Flag2 = (string)focusedNode.GetValue("Flag2"); psp_Type.ParentID = (int)focusedNode.GetValue("ID"); try { psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPowerStuffTypes", psp_Type); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow())); } catch (Exception ex) { MsgBox.Show("增加子项目出错:" + ex.Message); } } }
//加载设备情况表列字段 private void LoadData() { try { if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } PowerStuffTypes psp_Type = new PowerStuffTypes(); psp_Type.Flag2 = typeFlag2; IList listTypes = new ArrayList(); try { listTypes = Common.Services.BaseService.GetList("SelectPowerStuffTypesByFlag2", psp_Type); } catch (Exception ex) { MsgBox.Show(ex.Message); } dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PowerStuffTypes)); treeList1.DataSource = dataTable; treeList1.Columns["Title"].Caption = "项目名称"; treeList1.Columns["Title"].Width = 180; treeList1.Columns["Title"].OptionsColumn.AllowEdit = false; treeList1.Columns["Title"].OptionsColumn.AllowSort = false; treeList1.Columns["Flag"].VisibleIndex = -1; treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag2"].VisibleIndex = -1; treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false; PowerStuffYears psp_Year = new PowerStuffYears(); psp_Year.Flag = typeFlag2; IList <PowerStuffYears> listYears = Common.Services.BaseService.GetList <PowerStuffYears>("SelectPowerStuffYearsListByFlag", psp_Year); foreach (PowerStuffYears item in listYears) { AddColumn(item.Year); } AddColumn1(); Application.DoEvents(); LoadValues(); treeList1.ExpandAll(); } catch { } }
private void barButtonItem14_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (treeList1.FocusedNode.HasChildren) { MsgBox.Show("此项目下有子项目,请先删除子项目!"); return; } if (MsgBox.ShowYesNo("是否删除项目 " + treeList1.FocusedNode.GetValue("Title") + "?") == DialogResult.Yes) { PowerStuffTypes psp_Type = Services.BaseService.GetOneByKey <PowerStuffTypes>(treeList1.FocusedNode["ID"].ToString()); PowerStuffValues PowerValues = new PowerStuffValues(); PowerValues.TypeID = psp_Type.ID; try { //DeletePowerValuesByType里面删除数据和分类 Common.Services.BaseService.Update("DeletePowerStuffValuesByType", PowerValues); TreeListNode brotherNode = null; try { if (treeList1.FocusedNode.ParentNode.Nodes.Count > 1) { brotherNode = treeList1.FocusedNode.PrevNode; if (brotherNode == null) { brotherNode = treeList1.FocusedNode.NextNode; } } } catch { } treeList1.DeleteNode(treeList1.FocusedNode); LoadData(); } catch //(Exception ex) { //MsgBox.Show("删除出错:" + ex.Message); } } }
private bool SaveRemarkValue(int typeID, string value) { PowerStuffTypes ps = Services.BaseService.GetOneByKey <PowerStuffTypes>(typeID); ps.Remark = value; //PowerStuffValues PowerValues = new PowerStuffValues(); //PowerValues.TypeID = typeID; //PowerValues.Value = value; //PowerValues.Year = year; try { Common.Services.BaseService.Update <PowerStuffTypes>(ps); } catch (Exception ex) { MsgBox.Show("保存数据出错:" + ex.Message); return(false); } return(true); }
/// <summary> /// 删除焦点对象 /// </summary> public void DeleteObject(string lb) { //获取焦点对象 PowerEachList obj = FocusedObject; if (obj == null) { bl = false; return; } int coun = 0; switch (lb) { case "xuqiu": PowerTypes pt = new PowerTypes(); pt.Flag2 = obj.UID; IList <PowerTypes> li = Services.BaseService.GetList <PowerTypes>("SelectPowerTypesByFlag2", pt); coun = li.Count; break; case "xihua": PowerProjectTypes pt1 = new PowerProjectTypes(); pt1.Flag2 = obj.UID; IList <PowerProjectTypes> li1 = Services.BaseService.GetList <PowerProjectTypes>("SelectPowerProjectTypesByFlag2", pt1); coun = li1.Count; break; case "shebei": PowerStuffTypes pt2 = new PowerStuffTypes(); pt2.Flag2 = obj.UID; IList <PowerStuffTypes> li2 = Services.BaseService.GetList <PowerStuffTypes>("SelectPowerStuffTypesByFlag2", pt2); coun = li2.Count; break; case "fanwei": PowersTypes pt3 = new PowersTypes(); pt3.Flag2 = obj.UID; IList <PowersTypes> li3 = Services.BaseService.GetList <PowersTypes>("SelectPowersTypesByFlag2", pt3); coun = li3.Count; break; case "sb": PowerProTypes pt4 = new PowerProTypes(); pt4.Flag2 = obj.UID; IList <PowerProTypes> li4 = Services.BaseService.GetList <PowerProTypes>("SelectPowerProTypesByFlag2INParent", pt4); coun = li4.Count; break; case "gusuan": PSP_PowerProValues_LangFang pt5 = new PSP_PowerProValues_LangFang(); pt5.Flag2 = obj.UID; IList <PSP_PowerProValues_LangFang> li5 = Services.BaseService.GetList <PSP_PowerProValues_LangFang>("SelectPSP_PowerProValues_LangFangByFlag2INParent", pt5); coun = li5.Count; break; } if (coun > 0) { MsgBox.Show("该分类下面有记录,无法删除"); bl = false; return; } //请求确认 if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes) { bl = false; return; } //执行删除操作 try { Services.BaseService.Delete <PowerEachList>(obj); if (lb == "sb") { Services.BaseService.Update("DeletePowerPicSelect1", obj.UID); Services.BaseService.Update("DeletePowerProTypesInFlag2", obj.UID); } if (lb == "gusuan") { Services.BaseService.Update("DeletePowerPicSelect1", obj.UID); Services.BaseService.Update("DeletePowerProTypesInFlag2", obj.UID); } } catch { //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(); }
private void simpleButton1_Click(object sender, EventArgs e) { type = psp_Year.Year = spinEdit1.Text; if (type.ToString() == "") { MsgBox.Show("类别名称不能为空"); return; } try { if (!IsUpdate) { if (Common.Services.BaseService.GetObject("SelectPowerStuffYearsByYearFlag", psp_Year) == null) { try { Common.Services.BaseService.Create <PowerStuffYears>(psp_Year); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MsgBox.Show("出错啦:" + ex.Message); } } else { MsgBox.Show("此分类已经存在,请重新输入!"); } } else { try { PowerStuffTypes psp_Type = new PowerStuffTypes(); psp_Type.Flag2 = type1; IList <PowerStuffTypes> listTypes = new List <PowerStuffTypes>(); try { listTypes = Common.Services.BaseService.GetList <PowerStuffTypes>("SelectPowerStuffTypesByFlag2", psp_Type); } catch (Exception ex) { MsgBox.Show(ex.Message); } foreach (PowerStuffTypes pstt in listTypes) { PowerStuffValues psv = new PowerStuffValues(); psv.ID = pstt.ID; psv.Year = psp_Year.Year; psv.Value = year2; Common.Services.BaseService.Update("UpdatePowerStuffValuesByYear", psv); } Common.Services.BaseService.Update <PowerStuffYears>(psp_Year); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MsgBox.Show("出错啦:" + ex.Message); } } } catch (Exception ex) { MsgBox.Show("出错啦:" + ex.Message); } }