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; }
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; 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; 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 barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { 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.Flag2 = typeFlag2; psp_Type.ProjectID = ProjectUID; 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 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 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 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 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 (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 barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListMultiSelection tm = treeList1.Selection; if (tm.Count == 0) { return; } // TreeListNode tln = treeList1.FocusedNode; //if (tln == null) // return; DataRow dr = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dr == null) { return; } int id1 = (int)dr["ID"]; fl2 = id1; hs.Clear(); li.Clear(); foreach (TreeListNode tln in tm) { PSP_P_Types pt1 = new PSP_P_Types(); if (id1 == 999999 || id1 == 888888) { IsJingJi = true; PSP_Types pt = Services.BaseService.GetOneByKey <PSP_Types>((int)tln["ID"]); if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } //UpdateData(pt, pt1); //li.Add(pt1); ////////Get(pt, li, hs); } else { pt1 = Services.BaseService.GetOneByKey <PSP_P_Types>((int)tln["ID"]); if (!hs.ContainsValue(pt1)) { hs.Add(Guid.NewGuid().ToString(), pt1); } //li.Add(pt1); ////////////Get1(pt1, li, hs); } } if (hs.Count > 0) { this.DialogResult = DialogResult.OK; } }
private void LoadData() { if (dataTable != null) { dataTable.Columns.Clear(); treeList1.Columns.Clear(); } PSP_Types psp_Type = new PSP_Types(); //psp_Type.Flag = 4; psp_Type.ID = 32; //IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag", psp_Type); IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag3", psp_Type); dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types)); psp_Type.Flag = 5; listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag", psp_Type); DataTable dt = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types)); foreach (DataRow dr in dt.Rows) { DataRow newRow = dataTable.NewRow(); newRow.ItemArray = dr.ItemArray; dataTable.Rows.Add(newRow); } 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; for (int i = forecastReport.StartYear + 1; i <= forecastReport.EndYear; i++) { AddColumn(i); } foreach (TreeListNode nd in treeList1.Nodes) { SetDefaultValues(nd); } treeList1.ExpandAll(); }
//添加年份后,新增一列 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 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 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 barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); 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["Flag"]; psp_Type.Flag2 = typeFlag2; psp_Type.ParentID = (int)focusedNode.GetValue("TypeID"); try { psp_Type.ID = (int)Common.Services.BaseService.Create("InsertPSP_Types", psp_Type); treeList1.BeginUpdate(); int year = (int)focusedNode.GetValue("Year"); foreach (TreeListNode nd in treeList1.Nodes) { AddChildRegion(nd, psp_Type.Title, psp_Type.ParentID, psp_Type.ID, psp_Type.Flag); } treeList1.EndUpdate(); DataRow newRegionRow = dtRegion.NewRow(); Itop.Common.DataConverter.ObjectToRow(psp_Type, newRegionRow); dtRegion.Rows.Add(newRegionRow); } catch (Exception ex) { MsgBox.Show("增加下级地区出错:" + ex.Message); } } }
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 barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (focusedNode.GetValue("Title").ToString() == "线损") { MsgBox.Show("此行不允许添加子分类!"); 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"); psp_Type.ProjectID = ProjectUID; 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 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 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 barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PSP_ForecastReports ct = (PSP_ForecastReports)this.ctrlPSP_ForecastReports1.GridView.GetRow(this.ctrlPSP_ForecastReports1.GridView.FocusedRowHandle); if (ct == null) { return; } typeFlag2 = ct.ID; Form1_Fs ffs = new Form1_Fs(); ffs.Type = type; if (ffs.ShowDialog() != DialogResult.OK) { return; } int fl2 = ffs.FL2; bool bl = ffs.IsJingJi; Hashtable hs = ffs.HS; if (hs.Count == 0) { return; } if (bl) { fl2 = 1; PSP_Years py = new PSP_Years(); py.Flag = fl2; IList <PSP_Years> listyear = Services.BaseService.GetList <PSP_Years>("SelectPSP_YearsListByFlag", py); Hashtable hsa = new Hashtable(); foreach (DictionaryEntry de3 in hs) { PSP_Types pt = (PSP_Types)de3.Value; PSP_P_Types ppta = new PSP_P_Types(); ppta.ID = pt.ID; ppta.Flag2 = typeFlag2; IList <PSP_P_Types> listppt = Services.BaseService.GetList <PSP_P_Types>("SelectPSP_P_TypesByFlag2ID", ppta); if (listppt.Count > 0) { continue; } PSP_P_Types ppt = new PSP_P_Types(); InitTypes(pt, ppt); Services.BaseService.Create <PSP_P_Types>(ppt); hsa.Add(Guid.NewGuid().ToString(), ""); PSP_Values pv = new PSP_Values(); pv.TypeID = pt.ID; IList <PSP_Values> listppt1 = Services.BaseService.GetList <PSP_Values>("SelectPSP_ValuesList", pv); Hashtable httss = new Hashtable(); foreach (PSP_Values pv1 in listppt1) { PSP_P_Values ppv = new PSP_P_Values(); InitValues(pv1, ppv); try { Services.BaseService.Create <PSP_P_Values>(ppv); } catch { } } } if (hsa.Count > 0) { foreach (PSP_Years py1 in listyear) { PSP_P_Years ppy = new PSP_P_Years(); InitYears(py1, ppy); try { Services.BaseService.Create <PSP_P_Years>(ppy); } catch { } } } } else { PSP_P_Years py = new PSP_P_Years(); py.Flag = fl2; IList <PSP_P_Years> listyear = Services.BaseService.GetList <PSP_P_Years>("SelectPSP_P_YearsListByFlag", py); Hashtable hsa = new Hashtable(); foreach (DictionaryEntry de3 in hs) { PSP_P_Types pt = (PSP_P_Types)de3.Value; pt.Flag2 = typeFlag2; IList <PSP_P_Types> listppt = Services.BaseService.GetList <PSP_P_Types>("SelectPSP_P_TypesByFlag2ID", pt); if (listppt.Count > 0) { continue; } Services.BaseService.Create <PSP_P_Types>(pt); hsa.Add(Guid.NewGuid().ToString(), ""); PSP_P_Values pv = new PSP_P_Values(); pv.TypeID = pt.ID; IList <PSP_P_Values> listppt1 = Services.BaseService.GetList <PSP_P_Values>("SelectPSP_P_ValuesList", pv); foreach (PSP_P_Values pv1 in listppt1) { try { pv1.Flag2 = typeFlag2; Services.BaseService.Create <PSP_P_Values>(pv1); } catch { } } } if (hsa.Count > 0) { foreach (PSP_P_Years py1 in listyear) { try { py1.Flag = typeFlag2; Services.BaseService.Create <PSP_P_Years>(py1); } catch { } } } } Application.DoEvents(); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; }
private void Form7_BaseYearRate_Load(object sender, EventArgs e) { if (dt1 != null) { dt1.Columns.Clear(); treeList1.Columns.Clear(); } //this.gridColumn2.ColumnEdit = this.repositoryItemTextEdit1; PSP_Types psp_Type = new PSP_Types(); psp_Type.Flag2 = typeFlag2; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type); dt1 = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types)); treeList1.DataSource = dt1; 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; string baseyear = ""; 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 { MsgBox.Show("没有添加基准年,请添加后再操作!"); return; } if (listYears.Count > 1) { endyear = listYears[listYears.Count - 1].Year; } else { MsgBox.Show("没有添加预测年,请添加后再操作!"); this.DialogResult = DialogResult.OK; return; } foreach (PSP_Years item in listYears) { if (item.Year.ToString() == baseyear) { continue; } AddColumn(item.Year); PSP_BaseYearRate psp_Yeartemp = new PSP_BaseYearRate(); foreach (PSP_Types psp_Typetemp in listTypes) { psp_Yeartemp.BaseYear = item.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 == 1) { TreeListNode node = treeList1.FindNodeByFieldValue("ID", Convert.ToInt32(list1[0].TypeID)); if (node != null) { if (list1[0].YearRate != "") { node.SetValue(list1[0].BaseYear + "年", Convert.ToDouble(list1[0].YearRate)); } else { node.SetValue(psp_Yeartemp.BaseYear + "年", "0"); } } } else if (list1.Count == 0) { try { psp_Yeartemp.UID = Guid.NewGuid().ToString(); psp_Yeartemp.YearRate = "0"; Common.Services.BaseService.Create <PSP_BaseYearRate>(psp_Yeartemp); TreeListNode node = treeList1.FindNodeByFieldValue("ID", psp_Yeartemp.TypeID); if (node != null) { node.SetValue(psp_Yeartemp.BaseYear + "年", "0"); } } catch (Exception ex) { // MsgBox.Show("出错啦:" + ex.Message); } } } catch (Exception ex) { // MsgBox.Show(ex.ToString()); } } } treeList1.ExpandAll(); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListMultiSelection tm = treeList1.Selection; if (tm.Count == 0) { return; } DataRow dr = this.gridView1.GetDataRow(this.gridView1.FocusedRowHandle); if (dr == null) { return; } int id1 = (int)dr["ID"]; hs.Clear(); li.Clear(); if (Flag == "1")//旧版分区县供电实绩 { if (id1 != 4) { foreach (TreeListNode tln in tm) { Ps_History pt1 = new Ps_History(); Ps_History pt = Services.BaseService.GetOneByKey <Ps_History>((string)tln["ID"]); if (tln["Title"].ToString() == "常规用电量" || tln["Title"].ToString() == "常规负荷") { pt.Title = pt.Title + "-" + tln.ParentNode["Title"]; } else if (!tln["Title"].ToString().Contains("电量") && !tln["Title"].ToString().Contains("负荷")) { if (id1 == 2) { pt.Title = pt.Title + "电量"; } else if (id1 == 3) { pt.Title = pt.Title + "负荷"; } } if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } } } else { foreach (TreeListNode tln in tm) { PSP_Types pt = Services.BaseService.GetOneByKey <PSP_Types>((int)tln["ID"]); if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } } } } else//新版分区县供电实绩 { foreach (TreeListNode tln in tm) { Ps_History pt1 = new Ps_History(); Ps_History pt = Services.BaseService.GetOneByKey <Ps_History>((string)tln["ID"]); if (tln["Title"].ToString() == "常规用电量" || tln["Title"].ToString() == "常规负荷") { pt.Title = pt.Title + "-" + tln.ParentNode["Title"]; } else if (!tln["Title"].ToString().Contains("电量") && !tln["Title"].ToString().Contains("负荷")) { if (id1 == 2) { pt.Title = pt.Title + "电量"; } else if (id1 == 3) { pt.Title = pt.Title + "负荷"; } } if (!hs.ContainsValue(pt)) { hs.Add(Guid.NewGuid().ToString(), pt); } } } if (hs.Count > 0) { this.DialogResult = DialogResult.OK; } }
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 barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } if (!base.EditRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (focusedNode.ParentNode == null) { MsgBox.Show("全地区名称不能修改!"); return; } FormTypeTitle frm = new FormTypeTitle(); frm.TypeTitle = focusedNode.GetValue("Title").ToString(); frm.Text = "修改地区名称"; if (frm.ShowDialog() == DialogResult.OK) { PSP_Types psp_Type = new PSP_Types(); psp_Type.Flag = (int)focusedNode["Flag"]; psp_Type.Flag2 = typeFlag2; psp_Type.ParentID = Convert.ToInt32(focusedNode.GetValue("ParentID").ToString().Remove(0, focusedNode.GetValue("Year").ToString().Length)); psp_Type.Title = frm.TypeTitle; psp_Type.ID = (int)focusedNode.GetValue("TypeID"); try { Common.Services.BaseService.Update <PSP_Types>(psp_Type); treeList1.BeginUpdate(); foreach (TreeListNode nd in treeList1.Nodes) { UpdateNodeText(nd, psp_Type.Title, psp_Type.ID); } treeList1.EndUpdate(); foreach (DataRow dr in dtRegion.Rows) { if ((int)dr["ID"] == psp_Type.ID) { dr["Title"] = psp_Type.Title; break; } } } catch (Exception ex) { MsgBox.Show("修改出错:" + ex.Message); } } }
private void LoadData() { _isLoadingData = true; this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); if (dataTable != null) { treeList1.Columns.Clear(); } PSP_Types psp_Type = new PSP_Types(); psp_Type.Flag2 = typeFlag2; IList listTypes = Common.Services.BaseService.GetList("SelectPSP_TypesByFlag2", psp_Type); if (listTypes == null || listTypes.Count == 0) { MsgBox.Show("地区分类不存在,程序无法继续执行!"); Application.ExitThread(); return; } dtRegion = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PSP_Types)); dtRegion.PrimaryKey = new DataColumn[] { dtRegion.Columns["ID"] }; dataTable = new DataTable(); dataTable.Columns.Add("ID", typeof(string)); //ID.ToString()+Year.ToString() dataTable.Columns.Add("ParentID", typeof(string)); //ParentID.ToString()+Year.ToString() dataTable.Columns.Add("Year", typeof(int)); dataTable.Columns.Add("TypeID", typeof(int)); dataTable.Columns.Add("Flag", typeof(int)); dataTable.Columns.Add("Title", typeof(string)); for (int i = 1; i <= maxCols; i++) { dataTable.Columns.Add("Col" + i, typeof(double)); } treeList1.DataSource = dataTable; treeList1.Columns["Year"].VisibleIndex = -1; treeList1.Columns["Year"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["TypeID"].VisibleIndex = -1; treeList1.Columns["TypeID"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Flag"].VisibleIndex = -1; treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false; treeList1.Columns["Title"].Caption = ""; treeList1.Columns["Title"].OptionsColumn.AllowEdit = false; treeList1.Columns["Title"].OptionsColumn.AllowSort = false; treeList1.Columns["Col1"].Caption = "最高负荷"; treeList1.Columns["Col1"].Width = 80; treeList1.Columns["Col2"].Caption = "220kV直供35/10kV容量"; treeList1.Columns["Col2"].Width = 140; treeList1.Columns["Col3"].Caption = "35kV及以下装机"; treeList1.Columns["Col3"].Width = 100; treeList1.Columns["Col4"].Caption = "需110kV变电容量"; treeList1.Columns["Col4"].Width = 110; treeList1.Columns["Col5"].Caption = "本年已有变电容量"; treeList1.Columns["Col5"].Width = 110; treeList1.Columns["Col6"].Caption = "本年已有变电项目"; treeList1.Columns["Col6"].Width = 110; treeList1.Columns["Col7"].Caption = "需新增变电容量"; treeList1.Columns["Col7"].Width = 100; treeList1.Columns["Col8"].Caption = "新增项目"; treeList1.Columns["Col8"].Width = 70; treeList1.Columns["Title"].Width = 160; for (int i = 1; i <= maxCols; i++) { treeList1.Columns["Col" + i].OptionsColumn.AllowSort = false; treeList1.Columns["Col" + i].ColumnEdit = repositoryItemTextEdit1; } treeList1.Columns["Year"].SortOrder = SortOrder.Ascending; Application.DoEvents(); LoadValues(); treeList1.ExpandAll(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; _isLoadingData = false; }