//添加地区
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;
}
}
