private void simpleButton2_Click(object sender, EventArgs e) { PSP_GDPYeas psp_Year = new PSP_GDPYeas(); psp_Year.Flag = _flag2; psp_Year.Year = _getvalue = (int)spinEdit1.Value; try { if (Common.Services.BaseService.GetObject("SelectPSP_YeasByFlagYear", psp_Year) == null) { try { Common.Services.BaseService.Create<PSP_GDPYeas>(psp_Year); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MsgBox.Show("��������" + ex.Message); } } else { MsgBox.Show("������Ѿ����ڣ����������룡"); } } catch (Exception ex) { MsgBox.Show("��������" + ex.Message); } }
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 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 barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FormGDP_Compute_BaseYear baseyear = new FormGDP_Compute_BaseYear(); baseyear.Text = "设置基准年!"; if (baseyear.ShowDialog() == DialogResult.OK) { PSP_GDPYeas psp_Year = new PSP_GDPYeas(); psp_Year.Flag = typeFlag2; Hashtable ha = new Hashtable(); ha.Add("Flag", typeFlag2); ha.Add("Year",Convert.ToInt32( baseyear.BaseYear)); PSP_GDPYeas listYears = (PSP_GDPYeas)Common.Services.BaseService.GetObject("SelectPSP_YeasByFlagYear", ha); if (listYears == null) { MsgBox.Show("年份数据中不存在此记录,请添加后在操作!"); return; } treeList1.BeginUpdate(); ReLoadData(baseyear.BaseYear); treeList1.EndUpdate(); treeList1.Columns[3].AppearanceCell.BackColor = Color.GreenYellow; this.Cursor = Cursors.Default; } else { baseyear.Close(); } // treeList1.SaveLayoutToXml(@"C:\Documents and Settings\tongxl\桌面\kk.xml"); }
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(); }