private void LoadData() { if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } PSP_GDPTypes psp_Type = new PSP_GDPTypes(); psp_Type.Flag2 = typeFlag2; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_GDPTypesByFlag2", psp_Type); dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_GDPTypes)); 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; PSP_GDPYeas psp_Year = new PSP_GDPYeas(); psp_Year.Flag = typeFlag2; IList<PSP_GDPYeas> listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_GDPYeasListByFlag", psp_Year); foreach (PSP_GDPYeas item in listYears) { AddColumn(item.Year); } Application.DoEvents(); LoadValues(); LoadValues1();//增长率 treeList1.ExpandAll(); }
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if(treeList1.FocusedNode.ParentNode == null) { MsgBox.Show("一级分类为固定内容,不能删除!"); return; } if (treeList1.FocusedNode.HasChildren) { MsgBox.Show("此分类下有子分类,请先删除子分类!"); return; } if (base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (!base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if(MsgBox.ShowYesNo("是否删除分类 " + treeList1.FocusedNode.GetValue("Title") + "?") == DialogResult.Yes) { PSP_GDPTypes psp_Type = new PSP_GDPTypes(); Class1.TreeNodeToDataObject<PSP_GDPTypes>(psp_Type, treeList1.FocusedNode); PSP_GDPValues psp_Values = new PSP_GDPValues(); psp_Values.TypeID = psp_Type.ID; try { //DeletePSP_ValuesByType里面删除数据和分类 Common.Services.BaseService.Update("DeletePSP_GDPValuesByType", psp_Values); TreeListNode brotherNode = null; if(treeList1.FocusedNode.ParentNode.Nodes.Count > 1) { brotherNode = treeList1.FocusedNode.PrevNode; if(brotherNode == null) { brotherNode = treeList1.FocusedNode.NextNode; } } treeList1.DeleteNode(treeList1.FocusedNode); //删除后,如果同级还有其它分类,则重新计算此类的所有年份数据 if(brotherNode != null) { foreach(TreeListColumn column in treeList1.Columns) { if (column.FieldName.IndexOf("年") > 0) { CalculateSum(brotherNode, column); } } } } catch (Exception ex) { MsgBox.Show("删除出错:" + ex.Message); } } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (treeList1.FocusedNode.ParentNode == null) { MsgBox.Show("一级分类名称不能修改!"); return; } if (!base.EditRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } FormTypeTitle frm = new FormTypeTitle(); frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改分类名"; if (frm.ShowDialog() == DialogResult.OK) { PSP_GDPTypes psp_Type = new PSP_GDPTypes(); Class1.TreeNodeToDataObject<PSP_GDPTypes>(psp_Type, treeList1.FocusedNode); psp_Type.Title = frm.TypeTitle; try { Common.Services.BaseService.Update<PSP_GDPTypes>(psp_Type); treeList1.FocusedNode.SetValue("Title", frm.TypeTitle); } catch(Exception ex) { MsgBox.Show("修改出错:" + ex.Message); } } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } if (base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } Form_Add_GDPTitle frm = new Form_Add_GDPTitle(); frm.Text = "增加" + focusedNode.GetValue("Title") + "的子分类"; if(frm.ShowDialog() == DialogResult.OK) { PSP_GDPTypes psp_Type = new PSP_GDPTypes(); psp_Type.Title = frm.GDPTitle; psp_Type.Flag = (int)focusedNode.GetValue("Flag"); psp_Type.Flag2 = (int)focusedNode.GetValue("Flag2"); psp_Type.ParentID = (int)focusedNode.GetValue("ID"); try { psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_GDPTypes", psp_Type); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow())); } catch(Exception ex) { MsgBox.Show("增加子分类出错:" + ex.Message); } } }
private void ReLoadData(string baseyear) { int year = Convert.ToInt32(baseyear); if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } PSP_GDPTypes psp_Type = new PSP_GDPTypes(); psp_Type.Flag2 = typeFlag2; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_GDPTypes", null); dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_GDPTypes)); 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; PSP_GDPYeas psp_Year = new PSP_GDPYeas(); psp_Year.Flag = typeFlag2; Hashtable ha = new Hashtable(); ha.Add("Flag", typeFlag2); ha.Add("Year", year); IList<PSP_GDPYeas> listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha); al.Clear(); foreach (PSP_GDPYeas item in listYears) { al.Add(item.Year); } Application.DoEvents(); if (al.Contains(year)) { PSP_GDPBaseYear byear = new PSP_GDPBaseYear(); byear.BaseYear = baseyear; Common.Services.BaseService.Update("UpdatePSP_GDPBaseYearbyid", byear); } if (!al.Contains(year)) { MessageBox.Show("数据库中不存在"+year+"年!"); PSP_GDPBaseYear BaseYear = (PSP_GDPBaseYear)Common.Services.BaseService.GetObject("SelectPSP_GDPBaseYearList", null); if (BaseYear == null) { ha.Clear(); ha.Add("Flag", typeFlag2); ha.Add("Year", "1990"); listYears.Clear(); listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha); year = 1990; } else { ha.Clear(); ha.Add("Flag", typeFlag2); ha.Add("Year", BaseYear.BaseYear); listYears.Clear(); listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha); year = Convert.ToInt32( BaseYear.BaseYear); } } foreach (PSP_GDPYeas item in listYears) { AddColumn(item.Year); } LoadValues(year); firstyearValues(year); foreach (PSP_GDPYeas item in listYears) { if (item.Year > year) { ComputeValues(item.Year); } } PSP_Types psp_T = new PSP_Types(); psp_T.Flag2 = typeFlag2; IList<PSP_Types> listT = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByFlag2", psp_T); PSP_Values pspval = new PSP_Values(); pspval.TypeID = -1; foreach (PSP_Types psp in listT) { if (psp.Title == "人口(万人)") { pspval.TypeID = psp.ID; break; } } if (pspval.TypeID != -1) { ha.Clear(); ha.Add("TypeID", pspval.TypeID); // ha.Add("Year", year); IList<PSP_Values> listvalue = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesList", ha); foreach (PSP_Values it in listvalue) { if (al.Contains(it.Year)) { if (treeList1.Nodes[2][it.Year + "年"].ToString() != "") { treeList1.Nodes[3].SetValue(it.Year + "年", Convert.ToDouble(treeList1.Nodes[2].GetValue(it.Year + "年")) / it.Value); } } } } foreach (PSP_GDPYeas item in listYears) { ComputeBiZhong(item.Year); } treeList1.ExpandAll(); }
private void LoadData( string baseyear ) { int year = Convert.ToInt32(baseyear); if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } PSP_GDPTypes psp_Type = new PSP_GDPTypes(); psp_Type.Flag2 = typeFlag2; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_GDPTypes", null); dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_GDPTypes)); 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; PSP_GDPYeas psp_Year = new PSP_GDPYeas(); psp_Year.Flag = typeFlag2; Hashtable ha = new Hashtable(); ha.Add("Flag",typeFlag2); ha.Add("Year", year); IList<PSP_GDPYeas> listYears = Common.Services.BaseService.GetList<PSP_GDPYeas>("SelectPSP_YeasListByFlagAndYear", ha); // PSP_YearVisibleIndex yvi = new PSP_YearVisibleIndex(); // yvi.ModuleFlag = ModuleFlag; // yvi.Year = year.ToString() ; // IList<PSP_YearVisibleIndex> yearvisi = Common.Services.BaseService.GetList<PSP_YearVisibleIndex>("SelectPSP_YearVisibleIndexByModuleFlagSort", yvi); //if (yearvisi.Count == 0) // { al.Clear(); foreach (PSP_GDPYeas item in listYears) { AddColumn(item.Year); al.Add(item.Year); } // } // else //{ // foreach (PSP_YearVisibleIndex item in yearvisi) // { // AddColumn(Convert.ToInt32(item.Year),item.VisibleIndex); // } // } Application.DoEvents(); LoadValues(year); firstyearValues(year); foreach (PSP_GDPYeas item in listYears) { if (item.Year > year) { ComputeValues(item.Year); } } PSP_Types psp_T = new PSP_Types(); psp_T.Flag2 = typeFlag2; IList<PSP_Types> listT = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByFlag2", psp_T); PSP_Values pspval = new PSP_Values(); pspval.TypeID = -1; foreach (PSP_Types psp in listT) { if (psp.Title == "人口(万人)") { pspval.TypeID = psp.ID; break; } } if (pspval.TypeID != -1) { ha.Clear(); ha.Add("TypeID", pspval.TypeID); // ha.Add("Year", year); IList<PSP_Values> listvalue = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesList", ha); foreach (PSP_Values it in listvalue) { if (al.Contains(it.Year)) { if (treeList1.Nodes[2][it.Year + "年"].ToString() != "") { treeList1.Nodes[3].SetValue(it.Year + "年",Convert.ToInt32(Convert.ToDouble(treeList1.Nodes[2].GetValue(it.Year + "年"))/ it.Value)); } } } } foreach (PSP_GDPYeas item in listYears) { ComputeBiZhong(item.Year); } LoadValues1(); treeList1.ExpandAll(); }