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