private void Insertdata()
{
//LayoutList ll1 = this.ctrlLayoutList1.FocusedObject;
//if (ll1 == null)
// return;
string columnname = "";
DataTable dts = new DataTable();
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
WaitDialogForm wait = new WaitDialogForm("", "正在导入数据, 请稍候...");
try
{
dts = GetExcel(op.FileName);
IList<PSP_Types> lii = new List<PSP_Types>();
IList<PSP_Values> liiValues = new List<PSP_Values>();
DateTime s8 = DateTime.Now;
PSP_Values psp_Values = new PSP_Values();
int x = 0;
for (int i = 0; i < dts.Rows.Count; i++)
{
this.Cursor = Cursors.WaitCursor;
PSP_Types l1 = new PSP_Types();
l1.ID = i;
l1.Flag2 = typeFlag2;
l1.ProjectID = ProjectUID;
foreach (DataColumn dc in dts.Columns)
{
columnname = dc.ColumnName;
//if (dts.Rows[i][dc.ColumnName].ToString() == "")
// continue;
psp_Values = new PSP_Values();
switch (dc.ColumnName)
{
case "Title":
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, dts.Rows[i][dc.ColumnName], null);
break;
case "ParentID":
if (dts.Rows[i][dc.ColumnName] == null || dts.Rows[i][dc.ColumnName].ToString() == "" || dts.Rows[i][dc.ColumnName] == DBNull.Value)
{
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, 0, null);
break;
}
l1.GetType().GetProperty(dc.ColumnName).SetValue(l1, Convert.ToInt32(dts.Rows[i][dc.ColumnName]), null);
break;
default:
if (dts.Rows[i][dc.ColumnName] == null || dts.Rows[i][dc.ColumnName].ToString() == "" || dts.Rows[i][dc.ColumnName] == DBNull.Value)
{
psp_Values.Value = 0;
}
else
psp_Values.Value= Convert.ToDouble(dts.Rows[i][dc.ColumnName]);
psp_Values.Year = Convert.ToInt32(dc.ColumnName.Replace("年",""));
psp_Values.TypeID = i;
psp_Values.ID = typeFlag2;
liiValues.Add(psp_Values);
break;
}
}
lii.Add(l1);
}
int parenti = -4;
//foreach (Ps_History l1 in lii)
PSP_Types psl1;
PSP_Values psp_values;
int ti = 0;
for (int i = 0,j=0; i < lii.Count; i++)
{
psl1 = lii[i];
ti = psl1.ID;
string con = "Flag2='" + typeFlag2 + "' and Title='" + psl1.Title + "'and ParentID ='" + psl1.ParentID + "' and ProjectID='"+ProjectUID+"'";
object obj = Services.BaseService.GetObject("SelectPSP_TypesByWhere", con);
if (obj != null)
{
psl1.ID = ((PSP_Types)obj).ID;
if (psl1.ParentID < 0)
{
psl1.ParentID = ((PSP_Types)obj).ParentID;
psl1.Flag = ((PSP_Types)obj).Flag;
}
Services.BaseService.Update<PSP_Types>(psl1);
}
else
{
Services.BaseService.Create<PSP_Types>(psl1);
obj = Services.BaseService.GetObject("SelectPSP_TypesByWhere", con);
if (obj != null)
{
psl1.ID = ((PSP_Types)obj).ID;
}
}
for (int jtemp = i + 1; jtemp < lii.Count; jtemp++)
{
if (lii[jtemp].ParentID == parenti)
{
lii[jtemp].ParentID = psl1.ID;
lii[jtemp].Flag = psl1.Flag;
}
}
for (; j < liiValues.Count; j++)
{
psp_values = liiValues[j];
if (psp_values.TypeID > ti)
break;
con = "TypeID='" + psl1.ID + "' and Year='" + psp_values.Year + "'";
obj = Services.BaseService.GetObject("SelectPSP_ValuesByWhere", con);
psp_values.TypeID = psl1.ID;
if (obj != null)
{
psp_values.ID = ((PSP_Values)obj).ID;
Services.BaseService.Update<PSP_Values>(psp_values);
}
else
{
Services.BaseService.Create<PSP_Values>(psp_values);
}
}
parenti--;
}
this.Cursor = Cursors.Default;
wait.Close();
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
MsgBox.Show("导入成功！");
}
catch (Exception ex)
{
this.Cursor = Cursors.Default;
wait.Close();
MsgBox.Show(columnname + ex.Message); MsgBox.Show("导入格式不正确！");
}
}
}
private void barButtonItem11_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//typeFlag2 = this.ctrlPSP_EachList1.FocusedObject.UID;
//if (this.ctrlPSP_EachList1.FocusedObject == null)
//{
// MsgBox.Show("没有指定的项目存在，请先添加项目分类管理！");
// return;
//}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加项目";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
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("InsertPSP_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加项目出错：" + ex.Message);
}
}
// ReLoad();
}
private void barButtonItem13_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (treeList1.FocusedNode.ParentNode == null)
{
MsgBox.Show("一级分类名称不能修改！");
return;
}
////FrmEditProject5 frm = new FrmEditProject5();
////frm.FlagId = typeFlag2.ToString();
////frm.Type = type;
////frm.PowerUId = treeList1.FocusedNode["ID"].ToString();
////frm.Isupdate = true;
FormTypeTitle frm = new FormTypeTitle();
frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString();
frm.Text = "修改项目名";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update<PSP_Types>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
catch (Exception ex)
{
//MsgBox.Show("修改出错：" + ex.Message);
}
}
ReLoad();
}
private void Get(PSP_Types pt, IList<PSP_P_Types> li,Hashtable hs)
{
IList<PSP_Types> li1 = Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByParentID", pt);
foreach (PSP_Types pt1 in li1)
{
if (hs.ContainsValue(pt1))
continue;
hs.Add(Guid.NewGuid().ToString(), pt1);
//PSP_P_Types ppt=new PSP_P_Types();
//UpdateData(pt1,ppt);
//li.Add(ppt);
Get(pt1, li, hs);
}
}
private void UpdateData(PSP_Types pt, PSP_P_Types pt1)
{
pt1.Flag = pt.Flag;
pt1.Flag2 = pt.Flag2;
pt1.ID = pt.ID;
pt1.ParentID = pt.ParentID;
pt1.Title = pt.Title;
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (!base.EditRight)
{
MsgBox.Show("您没有权限进行此项操作！");
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)
{
PSP_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update<PSP_Types>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
catch(Exception ex)
{
MsgBox.Show("修改出错：" + ex.Message);
}
}
}
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!base.AddRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
int cou = treeList1.Nodes.Count;
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
psp_Type.Flag = cou + 1;
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = 0;
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加分类出错：" + ex.Message);
}
}
}
private void AddFixedVoltageRows(PSP_Types psp_Type)
{
int i = 0;
for (i = 0; i < hash.Count; i++)
{
PSP_Types psp_Typetemp = new PSP_Types();
psp_Typetemp.Title = hash[i].ToString();
psp_Typetemp.Flag = psp_Type.Flag;
psp_Typetemp.Flag2 = psp_Type.Flag2;
psp_Typetemp.ParentID = psp_Type.ID;
try
{
psp_Typetemp.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Typetemp);
//dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Typetemp, dataTable.NewRow()));
}
catch { }
for (int j = 0; j < hash2.Count; j++)
{
PSP_Types psp_Typetemp2 = new PSP_Types();
psp_Typetemp2.Title = hash2[j].ToString();
psp_Typetemp2.Flag = psp_Typetemp.Flag;
psp_Typetemp2.Flag2 = psp_Typetemp.Flag2;
psp_Typetemp2.ParentID = psp_Typetemp.ID;
try
{
psp_Typetemp2.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Typetemp2);
//dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Typetemp, dataTable.NewRow()));
}
catch { }
}
}
}
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();
}
private void LoadData(TreeListNode nd)
{
List<PSP_Types> Ilisttemp = new List<PSP_Types>();
if(dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ID =Convert.ToInt32( nd["ID"]) ;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp in listTypes)
Ilisttemp.Add(psp_Typetemp);
foreach (PSP_Types psp_Typetemp in listTypes)
{
psp_Type.Flag2 = typeFlag2;
psp_Type.ID = psp_Typetemp.ID;
IList<PSP_Types> listTypestemp = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp2 in listTypestemp)
Ilisttemp.Add(psp_Typetemp2);
}
dataTable = Itop.Common.DataConverter.ToDataTable(Ilisttemp, typeof(PSP_Types));
treeList1.DataSource = dataTable;
treeList1.Columns["Title"].Caption = "分类名";
treeList1.Columns["Title"].Width = 250;
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_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues();
treeList1.ExpandAll();
}
private void LoadData2()
{
List<PSP_Types> Ilisttemp = new List<PSP_Types>();
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = 0;
IList<PSP_Types> listTypes = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp in listTypes)
Ilisttemp.Add(psp_Typetemp);
psp_Type.Flag2 = typeFlag2;
psp_Type.ID = listTypes[0].ID;
listTypes = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp in listTypes)
Ilisttemp.Add(psp_Typetemp);
foreach (PSP_Types psp_Typetemp in listTypes)
{
psp_Type.ID= psp_Typetemp.ID;
psp_Type.Flag2 = typeFlag2;
IList<PSP_Types> listTypestemp = Common.Services.BaseService.GetList<PSP_Types>("SelectPSP_TypesByParentID", psp_Type);
foreach (PSP_Types psp_Typetemp2 in listTypestemp)
Ilisttemp.Add(psp_Typetemp2);
}
dataTable2 = Itop.Common.DataConverter.ToDataTable(Ilisttemp, typeof(PSP_Types));
treeList2.DataSource = dataTable2;
treeList2.Columns["Title"].Caption = "分类名";
treeList2.Columns["Title"].Width = 250;
treeList2.Columns["Title"].OptionsColumn.AllowEdit = false;
treeList2.Columns["Title"].OptionsColumn.AllowSort = false;
treeList2.Columns["Flag"].VisibleIndex = -1;
treeList2.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList2.Columns["Flag2"].VisibleIndex = -1;
treeList2.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
}
private void DeletFixedVoltageRows(TreeListNode node)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ID = Convert.ToInt32(node["ID"]);
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psp_Type);
try
{
foreach (PSP_Types psp_Typetemp in listTypes)
{
PSP_Values psp_Values = new PSP_Values();
psp_Values.TypeID = psp_Typetemp.ID;
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
PSP_Types psp_Type2 = new PSP_Types();
psp_Type2.Flag2 = typeFlag2;
psp_Type2.ID = psp_Typetemp.ID;
IList listTypes2 = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psp_Type2);
foreach (PSP_Types psp_Typetemp2 in listTypes2)
{
psp_Values.TypeID = psp_Typetemp2.ID;
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
}
}
}
catch(Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
//统计
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FormChooseYears frm = new FormChooseYears();
foreach (TreeListColumn column in treeList1.Columns)
{
if (column.FieldName.IndexOf("年") > 0)
{
frm.ListYearsForChoose.Add((int)column.Tag);
}
}
frm.NoIncreaseRate = true;
DataTable dt = new DataTable();
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
dt.Columns.Add(item.Year + "年", typeof(double));
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = typeFlag2;//用ID字段存放Flag2的值
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values psptemp in listValues)
{
foreach (DataRow dttemp in dt.Rows)
{
if (Convert.ToInt32(dttemp["ID"].ToString()) == psptemp.TypeID)
dttemp[psptemp.Year + "年"] = psptemp.Value;
}
}
if(frm.ShowDialog() == DialogResult.OK)
{
FrmBalanceOfPowerRegionPrint frma = new FrmBalanceOfPowerRegionPrint();
frma.IsSelect = _isSelect;
frma.HASH = hash;
frma.HASH2 = hash2;
frma.Text = "南北区电力平衡表";
frma.GridDataTable = ResultDataTable(dt, frm.ListChoosedYears);
frma.ISPrint = PrintRight;
if (frma.ShowDialog() == DialogResult.OK && _isSelect)
{
DialogResult = DialogResult.OK;
}
}
}
private void LoadData()
{
if(dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
psp_Type.ProjectID = ProjectUID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2AndProjectID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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;
treeList1.Columns["ProjectID"].VisibleIndex = -1;
treeList1.Columns["ProjectID"].OptionsColumn.ShowInCustomizationForm = false;
//treeList1.Columns["ParentID"].VisibleIndex = -1;
//treeList1.Columns["ParentID"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues();
//foreach (PSP_Years item in listYears)
//{
// ComputeXianSun(item.Year);
// // ComputeXianSun1(item.Year,treeList1.Nodes[0],treeList1.Nodes[1],treeList1.Nodes[2]);
//}
treeList1.ExpandAll();
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
//if (treeList1.FocusedNode.ParentNode == null)
//{
// MsgBox.Show("一级分类名称不能修改！");
// return;
//}
string parentid = treeList1.FocusedNode["ParentID"].ToString();
string flag = treeList1.FocusedNode["flag"].ToString();
//if (parentid == "0" && (flag == "2" || flag == "3" || flag == "5" || flag == "7"))
//{
// MsgBox.Show("固定分类，不能修改！");
// return;
//}
//if (treeList1.FocusedNode["Title"].ToString().IndexOf("居民") > -1 && parentid == "233")
//{
// 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_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Type.Title = frm.TypeTitle;
try
{
Common.Services.BaseService.Update<PSP_Types>(psp_Type);
treeList1.FocusedNode.SetValue("Title", frm.TypeTitle);
}
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 barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!base.AddRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
TreeListNode focusedNode = treeList1.FocusedNode;
if (focusedNode == null)
{
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加分类";
if (frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
int flag = psp_Type.ID + 1;
if (focusedNode != null)
{
flag = (int)focusedNode.GetValue("Flag");
}
psp_Type.Flag = flag;
psp_Type.Flag2 = typeFlag2;
psp_Type.ParentID = 0;
try
{
psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
catch (Exception ex)
{
MsgBox.Show("增加分类出错：" + ex.Message);
}
}
}
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 (MsgBox.ShowYesNo("�Ƿ�ɾ������ " + treeList1.FocusedNode.GetValue("Title") + "��") == DialogResult.Yes)
{
PSP_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
PSP_Values psp_Values = new PSP_Values();
psp_Values.TypeID = psp_Type.ID;
try
{
//DeletePSP_ValuesByType����ɾ�����ݺͷ���
Common.Services.BaseService.Update("DeletePSP_ValuesByType", 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 barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
//if(treeList1.FocusedNode.ParentNode == null)
//{
// MsgBox.Show("一级分类为固定内容，不能删除！");
// return;
//}
if (treeList1.FocusedNode.HasChildren)
{
MsgBox.Show("此分类下有子分类，请先删除子分类！");
return;
}
if(MsgBox.ShowYesNo("是否删除分类 " + treeList1.FocusedNode.GetValue("Title") + "？") == DialogResult.Yes)
{
PSP_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
PSP_Values psp_Values = new PSP_Values();
psp_Values.TypeID = psp_Type.ID;
try
{
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
TreeListNode brotherNode = null;
if (treeList1.FocusedNode.ParentNode!=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 LoadData()
{
string baseyear = "";
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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;
baseyear = EnsureBaseYear(baseyear);
PSP_Years psp_Year = new PSP_Years();
IList<PSP_Years> listYears;
if (baseyear != "")
{
psp_Year.Flag = typeFlag2;
psp_Year.Year = Convert.ToInt32(baseyear);
listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlagAndYear", psp_Year);
}
else
{
psp_Year.Flag = typeFlag2;
listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
}
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues(true);
treeList1.ExpandAll();
if (baseyear != "")
{
treeList1.Columns[3].AppearanceCell.BackColor = Color.GreenYellow;
this.Cursor = Cursors.Default;
}
}
private void NewDemandLata2(ref DataTable datatemp)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = 1;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
foreach (PSP_Types psptemp in listTypes)
{
if (psptemp.Title != "")
if (!psptemp.Title.Contains("ȫ����õ���"))
continue;
IList listTypes2 = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psptemp);
foreach (PSP_Types psptemp2 in listTypes2)
{
if (psptemp2.Title.Contains("ȫ��ҵ�õ�ϼ�"))
{
IList listTypes3 = Common.Services.BaseService.GetList("SelectPSP_TypesByParentID", psptemp2);
foreach (PSP_Types psptemp3 in listTypes3)
{
DataRow dt = datatemp.NewRow();
dt["Title"] = psptemp3.Title;
dt["TypeID"] = psptemp3.ID;
datatemp.Rows.Add(dt);
}
}
else if (psptemp2.Title.Contains("������������õ�ϼ�"))
{
DataRow dt = datatemp.NewRow();
dt["Title"] = psptemp2.Title;
dt["TypeID"] = psptemp2.ID;
datatemp.Rows.Add(dt);
}
}
}
PSP_Values psp_Values = new PSP_Values();
psp_Values.ID = 1;//��ID�ֶδ��Flag2��ֵ
IList<PSP_Values> listValues = Common.Services.BaseService.GetList<PSP_Values>("SelectPSP_ValuesListByFlag2", psp_Values);
foreach (PSP_Values value in listValues)
{
DataRow[] drselc = datatemp.Select("TypeID=" + value.TypeID);
if(drselc!=null)
if (drselc.Length == 1)
{
if (datatemp.Columns.Contains(value.Year + "��"))
{
drselc[0][value.Year + "��"] = value.Value;
}
}
}
}
//�����ݺ�����һ��
private void AddColumn(int year)
{
int nInsertIndex = GetInsertIndex(year);
dataTable.Columns.Add(year + "��", typeof(double));
TreeListColumn column = treeList1.Columns.Insert(nInsertIndex);
column.FieldName = year + "��";
column.Tag = year;
column.Caption = year + "��";
column.Width = 70;
column.OptionsColumn.AllowSort = false;
column.VisibleIndex = nInsertIndex - 2;//������������
column.ColumnEdit = repositoryItemTextEdit1;
//treeList1.RefreshDataSource();
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
foreach (PSP_Types psp_Typetemp in listTypes)
{
PSP_BaseYearRate psp_Yeartemp = new PSP_BaseYearRate();
psp_Yeartemp.BaseYear = year.ToString();
psp_Yeartemp.TypeID = psp_Typetemp.ID;
try
{
IList<PSP_BaseYearRate> list1 = Common.Services.BaseService.GetList<PSP_BaseYearRate>("SelectPSP_BaseYearRateByYear", psp_Yeartemp);
if (list1.Count == 0)
{
try
{
psp_Yeartemp.UID = Guid.NewGuid().ToString();
psp_Yeartemp.YearRate = "0";
Common.Services.BaseService.Create<PSP_BaseYearRate>(psp_Yeartemp);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MsgBox.Show("��������" + ex.Message);
}
}
}
catch (Exception ex)
{
MsgBox.Show(ex.ToString());
}
}
}
private void LoadData1(int id)
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
switch (id)
{
case 999999:
typeFlag2 = 1;
break;
case 888888:
typeFlag2 = 2;
break;
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
Hashtable htt = new Hashtable();
foreach (PSP_Years item in listYears)
{
if(!htt.ContainsValue(item.Year))
htt.Add(Guid.NewGuid().ToString(),item.Year);
AddColumn1(item.Year);
}
Application.DoEvents();
LoadValues1(htt);
treeList1.ExpandAll();
}
private void LoadData2()
{
//��ʾ�ɰ�����ع���ʵ�����������һ��
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = 2;
psp_Type.ProjectID = Itop.Client.MIS.ProgUID;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2AndProjectID", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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["ProjectID"].VisibleIndex = -1;
treeList1.Columns["ProjectID"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag"].VisibleIndex = -1;
treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
treeList1.Columns["Flag2"].VisibleIndex = -1;
treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;
//treeList1.Columns["ParentID"].VisibleIndex = -1;
//treeList1.Columns["ParentID"].OptionsColumn.ShowInCustomizationForm = false;
PSP_Years psp_Year = new PSP_Years();
psp_Year.Flag = 2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn2(item.Year);
}
Application.DoEvents();
LoadValues();
treeList1.ExpandAll();
}
private void LoadData()
{
try
{
if (dataTable != null)
{
dataTable.Columns.Clear();
treeList1.Columns.Clear();
}
PSP_Types psp_Type = new PSP_Types();
psp_Type.Flag2 = typeFlag2;
IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type);
dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types));
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_Years psp_Year = new PSP_Years();
psp_Year.Flag = typeFlag2;
IList<PSP_Years> listYears = Common.Services.BaseService.GetList<PSP_Years>("SelectPSP_YearsListByFlag", psp_Year);
foreach (PSP_Years item in listYears)
{
AddColumn(item.Year);
}
Application.DoEvents();
LoadValues();
treeList1.ExpandAll();
}
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;
}
FindNodes(treeList1.FocusedNode);
string nodestr = treenode.GetValue("Title").ToString();
if (nodestr == "GDP(万元)" || nodestr == "全社会用电量(万千瓦时)" || nodestr == "单产耗能(万千瓦时/万元)")
{
MsgBox.Show( focusedNode.GetValue("Title").ToString()+"不允许添加子分类！");
return;
}
FormTypeTitle frm = new FormTypeTitle();
frm.Text = "增加" + focusedNode.GetValue("Title") + "的子分类";
if(frm.ShowDialog() == DialogResult.OK)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
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_Types", 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)
{
PSP_Types psp_Type = new PSP_Types();
psp_Type.Title = frm.TypeTitle;
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_Types", psp_Type);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(psp_Type, dataTable.NewRow()));
}
catch (Exception ex)
{
MsgBox.Show("增加子项目出错：" + ex.Message);
}
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
if (treeList1.FocusedNode.ParentNode == null)
{
MsgBox.Show("一级分类为固定内容，不能删除！");
return;
}
string parentid = treeList1.FocusedNode["ParentID"].ToString();
string flag = treeList1.FocusedNode["flag"].ToString();
if (parentid == "0" && (flag == "2" || flag == "3" || flag == "5" || flag == "7"))
{
MsgBox.Show("固定分类，不能删除！");
return;
}
if (treeList1.FocusedNode["Title"].ToString().IndexOf("居民") > -1 && parentid == "233")
{
MsgBox.Show("固定分类，不能删除！");
return;
}
string nodestr = treeList1.FocusedNode.GetValue("Title").ToString();
if (nodestr == "B、城乡居民生活用电合计")
{
MsgBox.Show("不允许删除" + treeList1.FocusedNode.GetValue("Title").ToString() + "名称！");
return;
}
if (treeList1.FocusedNode.HasChildren)
{
MsgBox.Show("此分类下有子分类，请先删除子分类！");
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if(MsgBox.ShowYesNo("是否删除分类 " + treeList1.FocusedNode.GetValue("Title") + "？") == DialogResult.Yes)
{
PSP_Types psp_Type = new PSP_Types();
Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
PSP_Values psp_Values = new PSP_Values();
psp_Values.TypeID = psp_Type.ID;
try
{
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", 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);
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
}
}
private void InitTypes(PSP_Types pv, PSP_P_Types pv1)
{
pv1.ID = pv.ID;
pv1.Flag = pv.Flag;
pv1.Flag2 = typeFlag2;
pv1.ParentID = pv.ParentID;
pv1.Title = pv.Title;
}
private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (MsgBox.ShowYesNo("该操作将清除所有数据，清除数据以后无法恢复,可能对其他用户的数据产生影响，请谨慎操作，你确定继续吗？") == DialogResult.No)
return;
PSP_Types psp_Type = new PSP_Types();
PSP_Values psp_Values = new PSP_Values();
foreach (DataRow dr in dataTable.Rows)
{
if (dr["Title"].ToString().Contains("全社会"))
continue;
// Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode);
psp_Values.TypeID = Convert.ToInt32(dr["id"]);
//DeletePSP_ValuesByType里面删除数据和分类
Common.Services.BaseService.Update("DeletePSP_ValuesByType", psp_Values);
}
Application.DoEvents();
SetValuesTo0();
this.Cursor = Cursors.WaitCursor;
treeList1.BeginUpdate();
LoadData();
treeList1.EndUpdate();
this.Cursor = Cursors.Default;
}
