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();
}
