//添加地区 private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "添加地区"; frm.SetLabelName = "地区名称"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_GDP data = new Ps_Table_GDP(); data.ID += "|" + ProjectID; data.ParentID = "0"; data.ProjectID = ProjectID; data.SortID = OperTable.GetGDPMaxSort()+1; data.Area = frm.ParentName; Common.Services.BaseService.Create<Ps_Table_GDP>(data); } InitGrid2(); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (this.gridView2.FocusedRowHandle >= 0) { FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "修改地区"; frm.SetLabelName = "地区名称"; frm.ParentName = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Area").ToString(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_GDP data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as Ps_Table_GDP;// new Ps_Table_GDP(); data.Area = frm.ParentName; Common.Services.BaseService.Update <Ps_Table_GDP>(data); } } InitGrid2(); }
//添加地区 private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "添加地区"; frm.SetLabelName = "地区名称"; if (frm.ShowDialog() == DialogResult.OK) { PS_Table_AreaWH data = new PS_Table_AreaWH(); data.ID += "|" + ProjectID; data.ProjectID = ProjectID; data.Title = frm.ParentName; data.Col1 = frm.Col1; data.Col2 = frm.Col2; Common.Services.BaseService.Create <PS_Table_AreaWH>(data); } InitGrid2(); }
//添加地区 private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "添加地区"; frm.SetLabelName = "地区名称"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_GDP data = new Ps_Table_GDP(); data.ID += "|" + ProjectID; data.ParentID = "0"; data.ProjectID = ProjectID; data.SortID = OperTable.GetGDPMaxSort() + 1; data.Area = frm.ParentName; Common.Services.BaseService.Create <Ps_Table_GDP>(data); } InitGrid2(); }
//添加子分类 private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } //string nodestr = (treenode.GetValue("SortId") == null) ? "" : treenode.GetValue("SortId").ToString(); if (focusedNode.GetValue("SortId") != null && focusedNode.GetValue("SortId").ToString() == "1") { MsgBox.Show(focusedNode.GetValue("CompName").ToString() + "不允许添加子分类!"); return; } FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "增加" + focusedNode.GetValue("CompName").ToString() + "的子分类"; frm.SetLabelName = "子分类名称:"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_Yd table_yd = new Ps_Table_Yd(); table_yd.CompName = frm.ParentName; table_yd.ParentId = focusedNode.GetValue("Suid").ToString(); table_yd.Col1 = DateTime.Now.ToString(); try { Common.Services.BaseService.Create("InsertPs_Table_Yd", table_yd); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(table_yd, 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; } TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_Yd table_yd = new Ps_Table_Yd(); table_yd.CompName = frm.ParentName; table_yd.ParentId = "0"; table_yd.Col1 = DateTime.Now.ToString(); try { Common.Services.BaseService.Create("InsertPs_Table_Yd", table_yd); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(table_yd, dataTable.NewRow())); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } } }
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } Ps_YearRange range = yAnge; TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); string ParId = "",Heid=""; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_220Result table_yd = new Ps_Table_220Result(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.Get220ResultMaxSort() + 1; table_yd.ProjectID = GetProjectID; for (int i = range.BeginYear; i <= range.EndYear; i++) { table_yd.GetType().GetProperty("yf" + i.ToString()).SetValue(table_yd, null, null); table_yd.GetType().GetProperty("yk" + i.ToString()).SetValue(table_yd, null, null); } try { Common.Services.BaseService.Create("InsertPs_Table_220Result", table_yd); } catch (Exception ex) { MsgBox.Show("增加城区出错:" + ex.Message); } string[] lei = new string[7] { "一、110千伏以下负荷", "二、110千伏直供负荷","三、220千伏变电站低压侧供电负荷","四、110千伏及以下地方电源出力", "五、外网110千伏及以下送入电力", "六、外网110千伏及以下送出电力", "七、220千伏供电负荷" }; for (int i = 0; i < lei.Length; i++) { Ps_Table_220Result table1 = new Ps_Table_220Result(); table1.ID += "|" + GetProjectID; table1.Title = lei[i]; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = Convert.ToString(i+1); if (i == 6) { table1.Col1 = "no"; Heid = table1.ID; } if (i == 3) ParId = table1.ID;//,table_yd.Title); table1.Sort = i+1; try { Common.Services.BaseService.Create("InsertPs_Table_220Result", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } } AddModelChild(ParId, table_yd.Title, Heid); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); //treeList1.ExpandAll(); LoadData1(); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
//添加父分类 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_200PH table_yd = new Ps_Table_200PH(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.GetMaxSort() + 1; table_yd.ProjectID = GetProjectID; try { Common.Services.BaseService.Create("InsertPs_Table_200PH", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } string[] lei = new string[16] { "综合最大负荷", "直接供电负荷", "(1)110kV及以下电源直接供电负荷", "(2)外网供电", "需220kV降压供电负荷", "现有220kV降压变电容量", "220kV容载比", "需220kV变电容量", "变电容量盈亏", "目前已立项的变电容量", "注:", "规划新增变电容量", "注:", "变电容量合计", "容载比", "备 注" }; for (int i = 0; i < lei.Length; i++) { Ps_Table_200PH table1 = new Ps_Table_200PH(); table1.ID += "|" + GetProjectID; table1.Title = lei[i]; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = "0"; table1.Sort = i+1; try { Common.Services.BaseService.Create("InsertPs_Table_200PH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } } UpdateFuHe(table_yd.Title, table_yd.ID,"yf"); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData1(table_yd.ID); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (this.gridView2.FocusedRowHandle >= 0) { FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "修改地区"; frm.SetLabelName = "地区名称"; frm.ParentName = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Area").ToString(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_GDP data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as Ps_Table_GDP;// new Ps_Table_GDP(); data.Area = frm.ParentName; Common.Services.BaseService.Update<Ps_Table_GDP>(data); } } InitGrid2(); }
//添加父分类 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_100PH table_yd = new Ps_Table_100PH(); table_yd.ID = table_yd.ID + "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.Get100MaxSort() + 1; table_yd.ProjectID = GetProjectID; try { Common.Services.BaseService.Create("InsertPs_Table_100PH", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } Ps_Table_100PH table1 = new Ps_Table_100PH(); table1.ID += "|" + GetProjectID; table1.Title = "110千伏公用变电站供电负荷"; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = "0"; table1.Sort = 1; try { Common.Services.BaseService.Create("InsertPs_Table_100PH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } UpdateFuHe(table_yd.Title, table_yd.ID); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData1(table_yd.ID); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
//添加城区 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { if (treeList1.Nodes.Count>0) { for (int i = 0; i < treeList1.Nodes.Count; i++) { if (treeList1.Nodes[i].GetValue("Title").ToString() == frm.ParentName && treeList1.Nodes[i].GetValue("ParentID").ToString() == "0") { MessageBox.Show(frm.ParentName + " 地区已存在!"); return; } } AddArea(frm.ParentName); } else { AddArea(frm.ParentName); } } }
//添加地区 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; FrmAddPN frm = new FrmAddPN(); frm.SetCheckVisible(); frm.SetCheckText("不计特殊"); frm.checkEdit1.Visible = false; if (frm.ShowDialog() == DialogResult.OK) { string title = frm.ParentName; string connstr=" Title='"+title+"' and ProjectID='"+GetProjectID+"'"; IList templist = Common.Services.BaseService.GetList("SelectPs_Table_100PHListByConn", connstr); if (templist.Count>0) { MessageBox.Show(title + " 地区已存在!", "提示"); return; } Ps_Table_100PH table_yd = new Ps_Table_100PH(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.Get100MaxSort() + 1; table_yd.ProjectID = GetProjectID; try { Common.Services.BaseService.Create("InsertPs_Table_100PH", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); return; } string[] lei = new string[14] { "分区综合最高负荷", "本区220kV主变35kV侧可供负荷", "本区35kV及以下小电源直接供电负荷", "110kV用户专变负荷", "需110kV降压供电负荷", "本区现有110kV降压变电容量", "本区110kV容载比", "本区需110kV变电容量", "本区变电容量盈亏", "目前已立项的变电容量", "规划新增变电容量", "变电容量合计", "容载比", "备注" }; for (int i = 0; i < lei.Length; i++) { string parentID = ""; Ps_Table_100PH table1 = new Ps_Table_100PH(); table1.ID += "|" + GetProjectID; parentID = table1.ID; table1.Title = lei[i]; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = "0"; if (frm.BCheck) table1.Col2 = "no"; else table1.Col2 = "no1"; table1.Sort = i + 1; try { Common.Services.BaseService.Create("InsertPs_Table_100PH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); return; } if (lei[i].ToString() == "目前已立项的变电容量") { //根据地区计算相应结果填入 IList yllist = Common.Services.BaseService.GetList("SelectPs_Table_100PHListByConn", " ID='" + table1.ID + "' and ProjectID='" + GetProjectID + "'"); Ps_Table_100PH psr = yllist[0] as Ps_Table_100PH; string AreaName = title; for (int j = yAnge.BeginYear; j <= yAnge.EndYear; j++) { string year=j.ToString(); string con = "and a.BuildEd='" + year + "' and a.ProjectID='" + ProjectUID + "' and a.AreaName='" + AreaName + "' and substring(a.BianInfo,1,charindex('@',a.BianInfo,0)-1)='110'"; double vol = Convert.ToDouble(Common.Services.BaseService.GetObject("SelectTZGSsubLL", con)); psr.GetType().GetProperty("y" + j.ToString()).SetValue(psr, Math.Round(vol, 2), null); } try { Common.Services.BaseService.Update<Ps_Table_100PH>(psr); } catch (Exception ex) { MsgBox.Show("计算已立项的变电容量出错:" + ex.Message); return; } } } //UpdateFuHe(table_yd.Title, table_yd.ID,"yf"); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
public void EditPsTable() { TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } if (!base.EditRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } Ps_YearRange range = oper.GetYearRange("Col5='" + GetProjectID + "' and Col4='" + OperTable.ph110 + "'"); if (focusedNode.GetValue("Col1") != null && focusedNode.GetValue("Col1").ToString() == "0") { FrmChangeBian frm = new FrmChangeBian(); frm.GetProject = GetProjectID; frm.Mark = OperTable.ph110; frm.Text = "修改" + focusedNode.GetValue("Title"); Hashtable ht = new Hashtable(); for (int i = range.StartYear; i <= range.FinishYear; i++) { ht.Add("y" + i.ToString(), focusedNode.GetValue("y" + i.ToString()).ToString()); } frm.TextAttr = ht; frm.Title = focusedNode.GetValue("Title").ToString(); if (focusedNode.GetValue("Col1").ToString() == "0") { frm.SetEnable(); frm.BFuHe = true; } if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_100PH table = new Ps_Table_100PH(); table.ID = focusedNode.GetValue("ID").ToString(); table.Title = frm.Title; table.ParentID = focusedNode.GetValue("ParentID").ToString(); for (int i = range.StartYear; i <= range.FinishYear; i++) { table.GetType().GetProperty("y" + i.ToString()).SetValue(table, Convert.ToDouble(frm.TextAttr["y" + i.ToString()]), null); } double end = Convert.ToDouble(frm.TextAttr["y" + range.FinishYear.ToString()]); for (int j = range.FinishYear + 1; j <= range.EndYear; j++) { table.GetType().GetProperty("y" + j.ToString()).SetValue(table, end, null); } table.Col1 = focusedNode.GetValue("Col1").ToString(); table.ProjectID = GetProjectID; table.Sort = int.Parse(focusedNode.GetValue("Sort").ToString()); try { Common.Services.BaseService.Update("UpdatePs_Table_100PH", table); LoadData1(table.ParentID); FoucsLocation(table.ID, treeList1.Nodes); } catch (Exception ex) { MsgBox.Show("修改项目出错:" + ex.Message); } } } else if (focusedNode.GetValue("Col1") != null && focusedNode.GetValue("Col1").ToString() == "1") { string conn = "ParentID='" + focusedNode.GetValue("ID").ToString() + "'"; IList<Ps_Table_Edit> eList = Common.Services.BaseService.GetList<Ps_Table_Edit>("SelectPs_Table_EditListByConn", conn); FrmPsEdit frm = new FrmPsEdit(); frm.Mark = OperTable.ph110; frm.GetProject = GetProjectID; frm.GridData = eList; frm.Title = focusedNode.GetValue("Title").ToString(); frm.ParentID = focusedNode.GetValue("ID").ToString(); string curVolumn = focusedNode.GetValue("y" + range.EndYear).ToString(); frm.CurVolumn = curVolumn; frm.TypeTable = "100"; frm.MaxYear = GetChildMaxYear(conn); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_100PH table = new Ps_Table_100PH(); table = Common.Services.BaseService.GetOneByKey<Ps_Table_100PH>(focusedNode.GetValue("ID")); //table.ID = focusedNode.GetValue("ID").ToString(); table.Title = frm.Title; //table.ParentID = focusedNode.GetValue("ParentID").ToString(); //table.Col1 = focusedNode.GetValue("Col1").ToString(); //table.Sort = int.Parse(focusedNode.GetValue("Sort").ToString()); //table.Title = frm.StrResult[0]; //if (frm.GetStatus == "已有") //{ // for (int i = range.BeginYear; i <= range.EndYear; i++) // { // if (table.GetType().GetProperty("y" + i.ToString()).GetValue(table, null).ToString() == curVolumn) // table.GetType().GetProperty("y" + i.ToString()).SetValue(table, double.Parse(frm.StrResult[2]), null); // } //} //else if (frm.GetStatus == "扩建") //{ // for (int i = int.Parse(frm.StrResult[1]); i <= range.EndYear; i++) // { // table.GetType().GetProperty("y" + i.ToString()).SetValue(table, double.Parse(frm.StrResult[2]), null); // } //} //else if (frm.GetStatus == "拆除") //{ // for (int i = int.Parse(frm.StrResult[1]); i <= range.EndYear; i++) // { // table.GetType().GetProperty("y" + i.ToString()).SetValue(table, 0.0, null); // } // table.ParentID = "-1"; //} try { Common.Services.BaseService.Update("UpdatePs_Table_100PH", table); LoadData1(table.ParentID); FoucsLocation(table.ID, treeList1.Nodes); } catch (Exception ex) { MsgBox.Show("修改项目出错:" + ex.Message); } } } else if (focusedNode.GetValue("ParentID").ToString() == "0") { FrmAddPN frm = new FrmAddPN(); frm.ParentName = focusedNode.GetValue("Title").ToString(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_100PH table1 = new Ps_Table_100PH(); table1.ID = focusedNode.GetValue("ID").ToString(); table1.ParentID = focusedNode.GetValue("ParentID").ToString(); table1.Sort = int.Parse(focusedNode.GetValue("Sort").ToString()); table1.Title = frm.ParentName; table1.ProjectID = GetProjectID; table1.BuildYear = focusedNode.GetValue("BuildYear").ToString(); try { Common.Services.BaseService.Update("UpdatePs_Table_100PH", table1); LoadData1(table1.ID); FoucsLocation(table1.ID, treeList1.Nodes); } catch (Exception ex) { MsgBox.Show("修改分类出错:" + ex.Message); } } } else MsgBox.Show("不能修改此行"); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } //FindNodes(treeList1.FocusedNode); string parentid = treeList1.FocusedNode["ParentID"].ToString(); if (!base.EditRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (parentid == "0") { FrmAddPN frm = new FrmAddPN(); //frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString(); frm.ParentName = treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改分类名"; frm.SetLabelName = "分类名称"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); table1 = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(treeList1.FocusedNode.GetValue("ID")); table1.Title = frm.ParentName; table1.Col2 = "no"; try { Common.Services.BaseService.Update<Ps_Table_TZGS>(table1); treeList1.FocusedNode.SetValue("Title", frm.ParentName); } catch { } //catch(Exception ex) //{ // MsgBox.Show("修改出错:" + ex.Message); //} } } else { FrmAddTzgsWH2 frm = new FrmAddTzgsWH2(); Ps_Table_TZGS table = new Ps_Table_TZGS(); table = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(treeList1.FocusedNode.GetValue("ID")); frm.ParentName = table.Title; //treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改工程"; frm.Stat = treeList1.FocusedNode.ParentNode.GetValue("Col2").ToString(); frm.AreaName = table.AreaName; frm.BianInfo = table.BianInfo; frm.LineInfo = table.LineInfo; frm.LineLen = table.Length; frm.Vol = table.Volumn; frm.StartYear = table.BuildYear; frm.FinishYear = table.BuildEd; frm.LineLen = table.Length; frm.BieZhu = table.Col1; frm.Col3 = table.Col3; frm.StrType = table.Col4; frm.JGNum = table.JGNum; frm.Amount = table.Amount; frm.ProgType = table.ProgType; frm.WGNum = table.WGNum; //frm.TzgsXs = double.Parse(yAngeXs.Col1); frm.DQ = table.DQ; frm.StrType = "bian"; Ps_Table_TZGS t1 = new Ps_Table_TZGS(); string sql1 = " ParentID='" + table.ID + "' and Col4='bian'"; t1 =(Ps_Table_TZGS) Common.Services.BaseService.GetObject("SelectPs_Table_TZGSByConn", sql1); frm.Num1 = t1.Num1; frm.Num2 = t1.Num2; frm.Num5 = t1.Num5; frm.StrType = "line"; Ps_Table_TZGS t2 = new Ps_Table_TZGS(); string sql2 = " ParentID='" + table.ID + "' and Col4='line'"; t2 = (Ps_Table_TZGS)Common.Services.BaseService.GetObject("SelectPs_Table_TZGSByConn", sql2); frm.Num1 = t2.Num1; frm.Num2 = t2.Num2; frm.Num5 = t2.Num5; if (frm.ShowDialog() == DialogResult.OK) { AddChildVol(table, false); table.Title = frm.ParentName; table.BuildYear = frm.StartYear; table.BuildEd = frm.FinishYear; table.Length = frm.LineLen; table.Volumn = frm.Vol; double temp = frm.AllVol - table.AllVolumn; table.AllVolumn = frm.AllVol; table.AftVolumn += temp; table.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(table, temp + double.Parse(table.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(table,null).ToString()), null); table.Col1 = frm.BieZhu; table.Col3 = frm.Col3; table.Col4 = frm.StrType; table.BianInfo = frm.BianInfo; table.LineInfo = frm.LineInfo; table.JGNum =frm.JGNum; table.Amount=frm.Amount; table.ProgType=frm.ProgType; table.WGNum = frm.WGNum; table.DQ = frm.DQ; frm.StrType = "bian"; t1.Num1 = frm.Num1; t1.Num2 = frm.Num2; t1.Num5 = frm.Num5; t1.WGNum = frm.WGNum; frm.StrType = "line"; t2.Num1 = frm.Num1; t2.Num2 = frm.Num2; t2.Num5 = frm.Num5; try { Common.Services.BaseService.Update<Ps_Table_TZGS>(table); Common.Services.BaseService.Update<Ps_Table_TZGS>(t1); Common.Services.BaseService.Update<Ps_Table_TZGS>(t2); AddChildVol(table, true); LoadData1(); FoucsLocation(table.ID, treeList1.Nodes); } catch { } } } }
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } Ps_YearRange range = yAnge; TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { FrmAreaStyle frmas = new FrmAreaStyle(); if (frmas.ShowDialog() == DialogResult.OK) { Ps_Table_ElecPH table_yd = new Ps_Table_ElecPH(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.GetElecMaxSort() + 1; table_yd.ProjectID = GetProjectID; //for (int i = range.BeginYear; i <= range.EndYear; i++) //{ // table_yd.GetType().GetProperty("y" + i.ToString()).SetValue(table_yd, null, null); // // table_yd.GetType().GetProperty("yk" + i.ToString()).SetValue(table_yd, null, null); //} try { Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table_yd); } catch (Exception ex) { MsgBox.Show("增加城区出错:" + ex.Message); } string[] lei; if (frmas.comBoxTEXT == "送端地区") { lei = new string[6] { "地区最大负荷", "平均高峰负荷", "地区装机规模", "地区电源满发时供电能力", "机组满发时高峰电力盈亏", "机组满发时平均高峰电力盈亏 " };//, "三、220千伏及以下地方电源出力", "四、220千伏及以下外网送入电力", "五、500千伏供电负荷" }; } else if(frmas.comBoxTEXT == "抽水蓄能地区") { lei = new string[8] { "地区最大负荷", "负荷备用(5%)", "夏季低谷负荷", "地区装机规模", "地区电源满发时供电能力(含抽蓄出力)", "地区抽水蓄能机组低谷抽水负荷", "机组满发时高峰电力盈亏", "夏季低谷时(含抽蓄抽水) 电力盈亏" };//, "三、220千伏及以下地方电源出力", "四、220千伏及以下外网送入电力", "五、500千伏供电负荷" }; } else { lei = new string[7] { "地区最大负荷", "负荷备用(5%)", "地区装机规模", "地区电源满发时供电能力(枯水年)", "停最大单机时供电能力(枯水年)", "机组满发时高峰电力盈亏", "停最大单机时高峰电力盈亏" };//, "三、220千伏及以下地方电源出力", "四、220千伏及以下外网送入电力", "五、500千伏供电负荷" }; } for (int i = 0; i < lei.Length; i++) { Ps_Table_ElecPH table1 = new Ps_Table_ElecPH(); table1.ID += "|" + GetProjectID; table1.Title = lei[i]; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = Convert.ToString(i + 1); table1.Col2 = "110child"; if (i == 2) { //table1.Col1 = "no"; table1.Col2 = "110"; } table1.Sort = i + 1; try { Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } if (lei[i] == "地区装机规模") { Ps_Table_ElecPH table2 = new Ps_Table_ElecPH(); table2.ID += "|" + GetProjectID; table2.Title = "其中: 电厂"; table2.ParentID = table1.ID; table2.ProjectID = GetProjectID; table2.Col1 = Convert.ToString("child"); // table2.Col2 = "110child"; table1.Sort = i + 1; Ps_Table_ElecPH table3 = new Ps_Table_ElecPH(); table3.ID += "|" + GetProjectID; table3.Title = " 电厂"; table3.ParentID = table1.ID; table3.ProjectID = GetProjectID; table3.Col1 = Convert.ToString("child"); // table3.Col2 = "110child"; table3.Sort = i + 2; try { Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table2); Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table3); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } } } this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); //treeList1.ExpandAll(); LoadData1(); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } else { return; } } }
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 (treeList1.FocusedNode.GetValue("Col1").ToString() == "no" || focusedNode.GetValue("ParentID").ToString()=="0") { MsgBox.Show( focusedNode.GetValue("Title").ToString()+"不允许添加子分类!"); return; } FrmAddPN frm = new FrmAddPN(); frm.Text = "增加" + focusedNode.GetValue("Title") + "的子分类"; frm.SetLabelName = "子分类名称"; if(frm.ShowDialog() == DialogResult.OK) { Ps_Table_220Result table1 = new Ps_Table_220Result(); table1.ID += "|" + GetProjectID; table1.Title = frm.ParentName; table1.ParentID = focusedNode.GetValue("ID").ToString(); table1.ProjectID = GetProjectID; table1.Col1 = "child"; table1.Col2 = treeList1.FocusedNode.GetValue("Col1").ToString(); table1.Sort = OperTable.Get220ResultMaxSort()+1; try { Common.Services.BaseService.Create("InsertPs_Table_220Result", table1); dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(table1, 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.GetValue("SortId") != null && treeList1.FocusedNode.GetValue("SortId").ToString() == "1") { FrmAddXM frm = new FrmAddXM(); frm.SetFrmName = "修改" + treeList1.FocusedNode.GetValue("CompName").ToString() + "的项目名"; frm.Comp = treeList1.FocusedNode.GetValue("CompName").ToString(); frm.Build = treeList1.FocusedNode.GetValue("BuildSize").ToString(); frm.Progre = treeList1.FocusedNode.GetValue("Progress").ToString(); frm.Plan = treeList1.FocusedNode.GetValue("PlanYear").ToString(); frm.Pow = treeList1.FocusedNode.GetValue("Power").ToString(); frm.Weig = treeList1.FocusedNode.GetValue("Weight").ToString(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_Yd table_dy = new Ps_Table_Yd(); Itop.Client.Chen.Class1.TreeNodeToDataObject <Ps_Table_Yd>(table_dy, treeList1.FocusedNode); table_dy.CompName = frm.Comp; table_dy.BuildSize = frm.Build; table_dy.Progress = frm.Progre; table_dy.PlanYear = frm.Plan; table_dy.Power = frm.Pow; table_dy.Weight = frm.Weig; try { Common.Services.BaseService.Update <Ps_Table_Yd>(table_dy); treeList1.FocusedNode.SetValue("CompName", frm.Comp); LoadData(); } catch { } } } else { FrmAddPN frm = new FrmAddPN(); frm.SetFrmName = "修改" + treeList1.FocusedNode.GetValue("CompName").ToString() + "的分类名"; frm.ParentName = treeList1.FocusedNode.GetValue("CompName").ToString(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_Yd table_dy = new Ps_Table_Yd(); Itop.Client.Chen.Class1.TreeNodeToDataObject <Ps_Table_Yd>(table_dy, treeList1.FocusedNode); table_dy.CompName = frm.ParentName; try { Common.Services.BaseService.Update <Ps_Table_Yd>(table_dy); treeList1.FocusedNode.SetValue("CompName", frm.ParentName); LoadData(); } catch { } } } }
//添加父分类 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); frm.SetCheckVisible(); frm.SetCheckText("不计特殊"); frm.checkEdit1.Visible = false; if (frm.ShowDialog() == DialogResult.OK) { for (int i = 0; i < treeList1.Nodes.Count; i++) { if (treeList1.Nodes[i].GetValue("Title").ToString() == frm.ParentName && treeList1.Nodes[i].GetValue("ParentID").ToString() == "0") { MessageBox.Show(frm.ParentName + " 地区已存在!"); return; } } Ps_Table_500PH table_yd = new Ps_Table_500PH(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.Get500MaxSort() + 1; table_yd.ProjectID = GetProjectID; try { Common.Services.BaseService.Create("InsertPs_Table_500PH", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } Ps_Table_500PH table1 = new Ps_Table_500PH(); table1.ID += "|" + GetProjectID; table1.Title = "500千伏公用变电站供电负荷"; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = "0"; if (frm.BCheck) table1.Col2 = "no"; else table1.Col2 = "no1"; table1.Sort = 1; try { Common.Services.BaseService.Create("InsertPs_Table_500PH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } UpdateFuHe(table_yd.Title, table_yd.ID,"yf"); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData1(table_yd.ID); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
//添加父分类 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); frm.SetCheckVisible(); frm.SetCheckText("不计特殊"); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_500PH table_yd = new Ps_Table_500PH(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.Get500MaxSort() + 1; table_yd.ProjectID = GetProjectID; try { Common.Services.BaseService.Create("InsertPs_Table_500PH", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } string[] lei = new string[6] { "地区最大负荷", "接入地区220千伏及以下电网装机容量", "220kV联络线与区外交换电力", "电源满发供电出力", "高峰电力盈亏", "停一台最大单机后供电出力" }; for (int i = 0; i < lei.Length; i++) { Ps_Table_500PH table1 = new Ps_Table_500PH(); table1.ID += "|" + GetProjectID; table1.Title = lei[i]; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = "0"; if (frm.BCheck) table1.Col2 = "no"; else table1.Col2 = "no1"; table1.Sort = i+1; try { Common.Services.BaseService.Create("InsertPs_Table_500PH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } } UpdateFuHe(table_yd.Title, table_yd.ID,"yf"); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData1(table_yd.ID); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
//添加父分类 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } TreeListNode focusedNode = treeList1.FocusedNode; if (focusedNode == null) { return; } //if (focusedNode == null) //{ // return; //} if (focusedNode.GetValue("Title").ToString() != "地方电源建设规划") { MessageBox.Show("只能在“地方电源建设规划”分类下添加城区!"); return; } FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { Ps_PowerBuild table_yd = new Ps_PowerBuild(); table_yd.ID = table_yd.ID + "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = focusedNode.GetValue("ID").ToString(); table_yd.Sort = OperTable.GetPowerBuildMaxSort() + 1; table_yd.ProjectID = GetProjectID; table_yd.Col1 = "che"; table_yd.Col2 = "no"; try { Common.Services.BaseService.Create("InsertPs_PowerBuild", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } Ps_PowerBuild table1 = new Ps_PowerBuild(); table1.ID += "|" + GetProjectID; table1.Title = "年末装机容量"; table1.Type = "水电"; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = "sc"; table1.Col2 = "no"; table1.Sort = 1; Ps_PowerBuild table2 = new Ps_PowerBuild(); table2.ID += "|" + GetProjectID; table2.Title = "年末装机容量"; table2.Type = "火电"; table2.ParentID = table_yd.ID; table2.ProjectID = GetProjectID; table2.Col1 = "hc"; table2.Col2 = "no"; table2.Sort = 2; Ps_PowerBuild table3 = new Ps_PowerBuild(); table3.ID += "|" + GetProjectID; table3.Title = "已建项目小计"; table3.ParentID = table_yd.ID; table3.ProjectID = GetProjectID; table3.Col1 = "yhe"; table3.Col2 = "no"; table3.Sort = 3; Ps_PowerBuild table4 = new Ps_PowerBuild(); table4.ID += "|" + GetProjectID; table4.Title = "在建及新建项目小计"; table4.ParentID = table_yd.ID; table4.ProjectID = GetProjectID; table4.Col1 = "xhe"; table4.Col2 = "no"; table4.Sort = 4; try { Common.Services.BaseService.Create("InsertPs_PowerBuild", table1); Common.Services.BaseService.Create("InsertPs_PowerBuild", table2); Common.Services.BaseService.Create("InsertPs_PowerBuild", table3); Common.Services.BaseService.Create("InsertPs_PowerBuild", table4); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData1(table_yd.ID); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } //FindNodes(treeList1.FocusedNode); string nodestr = treeList1.FocusedNode.GetValue("Col1").ToString(); string parentid = treeList1.FocusedNode["ParentID"].ToString(); if (!base.EditRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (nodestr == "1" || nodestr == "2" || nodestr == "3" || nodestr == "4" || nodestr == "5" || nodestr == "6" || nodestr == "no") { MsgBox.Show("固定分类不许修改!"); return; } FrmAddPN frm = new FrmAddPN(); //frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString(); frm.ParentName = treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改分类名"; frm.SetLabelName = "分类名称"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_220Result table1 = new Ps_Table_220Result(); table1 = Common.Services.BaseService.GetOneByKey<Ps_Table_220Result>(treeList1.FocusedNode.GetValue("ID")); table1.Title = frm.ParentName; try { Common.Services.BaseService.Update<Ps_Table_220Result>(table1); treeList1.FocusedNode.SetValue("Title", frm.ParentName); } catch { } //catch(Exception ex) //{ // MsgBox.Show("修改出错:" + ex.Message); //} } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } //FindNodes(treeList1.FocusedNode); string parentid = treeList1.FocusedNode["ParentID"].ToString(); if (!base.EditRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (parentid == "0") { FrmAddPN frm = new FrmAddPN(); //frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString(); frm.ParentName = treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改分类名"; frm.SetLabelName = "分类名称"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); table1 = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(treeList1.FocusedNode.GetValue("ID")); table1.Title = frm.ParentName; table1.Col2 = "no"; try { Common.Services.BaseService.Update<Ps_Table_TZGS>(table1); treeList1.FocusedNode.SetValue("Title", frm.ParentName); } catch { } //catch(Exception ex) //{ // MsgBox.Show("修改出错:" + ex.Message); //} } } else { FrmAddTzgs frm = new FrmAddTzgs(); Ps_Table_TZGS table = new Ps_Table_TZGS(); table = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(treeList1.FocusedNode.GetValue("ID")); frm.ParentName = treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改工程"; frm.Stat = treeList1.FocusedNode.ParentNode.GetValue("Col2").ToString(); frm.BianInfo = table.BianInfo; frm.LineInfo = table.LineInfo; frm.StartYear = table.BuildYear; frm.FinishYear = table.BuildEd; frm.LineLen = table.Length; frm.BieZhu = table.Col1; frm.Col3 = table.Col3; if (frm.ShowDialog() == DialogResult.OK) { AddChildVol(table, false); table.Title = frm.ParentName; table.BuildYear = frm.StartYear; table.BuildEd = frm.FinishYear; table.Length = frm.LineLen; table.Volumn = frm.Vol; double temp = frm.AllVol - table.AllVolumn; table.AllVolumn = frm.AllVol; table.AftVolumn += temp; table.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(table, temp + double.Parse(table.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(table,null).ToString()), null); table.Col1 = frm.BieZhu; table.Col3 = frm.Col3; table.BianInfo = frm.BianInfo; table.LineInfo = frm.LineInfo; try { Common.Services.BaseService.Update<Ps_Table_TZGS>(table); AddChildVol(table, true); LoadData1(); FoucsLocation(table.ID, treeList1.Nodes); } catch { } } } }
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } Ps_YearRange range = yAnge; TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_TZGS table_yd = new Ps_Table_TZGS(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.GetTZGSMaxSort() + 1; table_yd.ProjectID = GetProjectID; table_yd.Col2 = frm.ParentName; try { Common.Services.BaseService.Create("InsertPs_Table_TZGS", table_yd); } catch (Exception ex) { MsgBox.Show("增加分类出错:" + ex.Message); } this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); //treeList1.ExpandAll(); LoadData1(); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (!base.AddRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } Ps_YearRange range = yAnge; TreeListNode focusedNode = treeList1.FocusedNode; //if (focusedNode == null) //{ // return; //} FrmAddPN frm = new FrmAddPN(); if (frm.ShowDialog() == DialogResult.OK) { for (int i = 0; i < treeList1.Nodes.Count; i++) { if (treeList1.Nodes[i].GetValue("Title").ToString() == frm.ParentName && treeList1.Nodes[i].GetValue("ParentID").ToString() == "0") { MessageBox.Show(frm.ParentName + " 地区已存在!"); return; } } Ps_Table_ElecPH table_yd = new Ps_Table_ElecPH(); table_yd.ID += "|" + GetProjectID; table_yd.Title = frm.ParentName; table_yd.ParentID = "0"; table_yd.Sort = OperTable.GetElecMaxSort() + 1; table_yd.ProjectID = GetProjectID; //for (int i = range.BeginYear; i <= range.EndYear; i++) //{ // table_yd.GetType().GetProperty("y" + i.ToString()).SetValue(table_yd, null, null); // // table_yd.GetType().GetProperty("yk" + i.ToString()).SetValue(table_yd, null, null); //} try { Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table_yd); } catch (Exception ex) { MsgBox.Show("增加城区出错:" + ex.Message); } string[] lei = new string[3] { "需电量", "35千伏及以下地方电源发电量","110千伏供电量"};//, "三、220千伏及以下地方电源出力", "四、220千伏及以下外网送入电力", "五、500千伏供电负荷" }; for (int i = 0; i < lei.Length; i++) { Ps_Table_ElecPH table1 = new Ps_Table_ElecPH(); table1.ID += "|" + GetProjectID; table1.Title = lei[i]; table1.ParentID = table_yd.ID; table1.ProjectID = GetProjectID; table1.Col1 = Convert.ToString(i+1); table1.Col2 = "110child"; if (i == 2) { table1.Col1 = "no"; table1.Col2 = "110"; } table1.Sort = i+1; try { Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table1); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } if (i == 1) { Ps_Table_ElecPH table2 = new Ps_Table_ElecPH(); table2.ID += "|" + GetProjectID; table2.Title = "其中:小水电"; table2.ParentID = table1.ID; table2.ProjectID = GetProjectID; table2.Col1 = Convert.ToString(i + 1); // table2.Col2 = "110child"; table1.Sort = i + 1; Ps_Table_ElecPH table3 = new Ps_Table_ElecPH(); table3.ID += "|" + GetProjectID; table3.Title = "小火电"; table3.ParentID = table1.ID; table3.ProjectID = GetProjectID; table3.Col1 = Convert.ToString(i + 1); // table3.Col2 = "110child"; table3.Sort = i + 2; try { Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table2); Common.Services.BaseService.Create("InsertPs_Table_ElecPH", table3); } catch (Exception ex) { MsgBox.Show("增加项目出错:" + ex.Message); } } } this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); //treeList1.ExpandAll(); LoadData1(); FoucsLocation(table_yd.ID, treeList1.Nodes); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } }