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