public void InitSelectBox()
{
//IList list = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", "ProjectID='"+ProjectID+"' and ParentID='0' and Col4='bian'");
//int x=10;
//for (int i = 0; i < list.Count; i++)
//{
// Ps_Table_TZGS tzgs=list[i] as Ps_Table_TZGS;
// CheckBox box = new CheckBox();
// box.Text = tzgs.FromID + "kV";
// box.Tag = tzgs;
// box.Checked = true;
// box.Size = new Size(60, 18);
// groupControl1.Controls.Add(box);
// box.Location = new Point(x + 100 * i, 35);
//}
//if (list.Count == 0)
// simpleButton4.Enabled = false;
IList list = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", "ProjectID='" + ProjectID + "' and ParentID='0' ");
DataTable dt = Itop.Common.DataConverter.ToDataTable((IList)list, typeof(Ps_Table_TZGS));
IList listrust = new List<Ps_Table_TZGS>();
int dy=500;
DataRow[] dtrow500 = dt.Select(" FromID='" + dy + "'");
dy = 220;
DataRow[] dtrow220 = dt.Select(" FromID='" + dy + "'");
dy = 110;
DataRow[] dtrow110 = dt.Select(" FromID='" + dy + "'");
if (dtrow500.Length>0)
{
Ps_Table_TZGS tzgs500 = new Ps_Table_TZGS();
tzgs500.FromID = "500";
for (int j = 1990; j < 2061; j++)
{
foreach (DataRow row in dtrow500)
{
double tempdb = double.Parse(tzgs500.GetType().GetProperty("y" + j).GetValue(tzgs500, null).ToString());
double tempdb2=double.Parse(row["y"+j].ToString());
tzgs500.GetType().GetProperty("y" + j).SetValue(tzgs500, tempdb + tempdb2, null);
}
}
listrust.Add(tzgs500);
}
if (dtrow220.Length>0)
{
Ps_Table_TZGS tzgs220 = new Ps_Table_TZGS();
tzgs220.FromID = "220";
for (int j = 1990; j < 2061; j++)
{
foreach (DataRow row in dtrow220)
{
double tempdb = double.Parse(tzgs220.GetType().GetProperty("y" + j).GetValue(tzgs220, null).ToString());
double tempdb2 = double.Parse(row["y" + j].ToString());
tzgs220.GetType().GetProperty("y" + j).SetValue(tzgs220, tempdb + tempdb2, null);
}
}
listrust.Add(tzgs220);
}
if (dtrow110.Length>0)
{
Ps_Table_TZGS tzgs110 = new Ps_Table_TZGS();
tzgs110.FromID = "110";
for (int j = 1990; j < 2061; j++)
{
foreach (DataRow row in dtrow110)
{
double tempdb = double.Parse(tzgs110.GetType().GetProperty("y" + j).GetValue(tzgs110, null).ToString());
double tempdb2 = double.Parse(row["y" + j].ToString());
tzgs110.GetType().GetProperty("y" + j).SetValue(tzgs110, tempdb + tempdb2, null);
}
}
listrust.Add(tzgs110);
}
int x = 10;
for (int i = 0; i < listrust.Count; i++)
{
Ps_Table_TZGS tzgs = listrust[i] as Ps_Table_TZGS;
CheckBox box = new CheckBox();
box.Text = tzgs.FromID + "kV";
box.Tag = tzgs;
box.Checked = true;
box.Size = new Size(60, 18);
groupControl1.Controls.Add(box);
box.Location = new Point(x + 100 * i, 35);
}
if (list.Count == 0)
simpleButton4.Enabled = false;
}
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 ( focusedNode.GetValue("ParentID").ToString()!="0")
{
//MsgBox.Show( focusedNode.GetValue("Title").ToString()+"不允许添加子分类！");
// return;
focusedNode = focusedNode.ParentNode;
}
FrmAddTzgs frm = new FrmAddTzgs();
frm.Text = "增加" + focusedNode.GetValue("Title") + "的子分类";
frm.Stat = focusedNode.GetValue("Col2").ToString();
// frm.SetLabelName = "子分类名称";
if(frm.ShowDialog() == DialogResult.OK)
{
Ps_Table_TZGS table1 = new Ps_Table_TZGS();
table1.ID += "|" + GetProjectID;
table1.Title = frm.ParentName;
table1.ParentID = focusedNode.GetValue("ID").ToString();
table1.ProjectID = GetProjectID;
table1.BuildYear = frm.StartYear;
table1.BuildEd = frm.FinishYear;
table1.FromID = "0";
table1.Length = frm.LineLen;
table1.Volumn = frm.Vol;
table1.AllVolumn = frm.AllVol;
// table1.BefVolumn = frm.AllVol;
table1.AftVolumn = frm.AllVol;
table1.LineInfo = frm.LineInfo;
table1.BianInfo = frm.BianInfo;
table1.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(table1, frm.AllVol, null);
//table1.Col2 = treeList1.FocusedNode.GetValue("Col1").ToString();
table1.Sort = OperTable.GetTZGSMaxSort()+1;
table1.Col3 = frm.Col3;
table1.Col1 = frm.BieZhu;
try
{
Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1);
dataTable.Rows.Add(Itop.Common.DataConverter.ObjectToRow(table1, dataTable.NewRow()));
AddChildVol(table1, true);
LoadData1();
FoucsLocation(table1.ID, treeList1.Nodes);
}
catch (Exception ex)
{
MsgBox.Show("增加工程出错：" + ex.Message);
}
}
}
public void AddChildVol(Ps_Table_TZGS child,bool bAdd)
{
Ps_Table_TZGS pare = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(child.ParentID);
IList<string> list=new List<string>();
list.Add("Length");list.Add("Volumn");list.Add("AllVolumn");list.Add("BefVolumn");
list.Add("AftVolumn");
for (int i = 2008; i <= yAnge.StartYear + 5; i++)
list.Add("y" + i.ToString());
double old=0.0,cld=0.0;
foreach (string str in list)
{
old=double.Parse(pare.GetType().GetProperty(str).GetValue(pare,null).ToString());
cld=double.Parse(child.GetType().GetProperty(str).GetValue(child,null).ToString());
if (bAdd)
pare.GetType().GetProperty(str).SetValue(pare, old + cld, null);
else
pare.GetType().GetProperty(str).SetValue(pare, old - cld, null);
}
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare);
}
public void RefreshData()
{
string n = "";
string conn = "ProjectID='" + GetProjectID + "' and Status!='拆除' and FinishYear>'" + Convert.ToString(yAnge.StartYear) + "' and FinishYear<'" + Convert.ToString(yAnge.StartYear + 6) + "' and (Col4='" + OperTable.ph110 + "' or Col4='" + OperTable.ph220 + "' or Col4='" + OperTable.ph500 + "') and ParentID not in (Select FromID from Ps_Table_TZGS where ProjectID = '" + GetProjectID + "')";
IList<Ps_Table_Edit> list = Common.Services.BaseService.GetList<Ps_Table_Edit>("SelectPs_Table_EditListByConn", conn);
for (int i = 0; i < list.Count; i++)
{
n = "";
if (list[i].Col4 == OperTable.ph110)
{
Ps_Table_100PH table = Common.Services.BaseService.GetOneByKey<Ps_Table_100PH>(list[i].ParentID);
if (table != null)
{
Ps_Table_TZGS pare = new Ps_Table_TZGS();
pare = GetTZGSParent("110");
Ps_Table_TZGS tzgs = new Ps_Table_TZGS();
if (pare != null)
tzgs.ParentID = pare.ID;
else
{
pare = new Ps_Table_TZGS();
pare.ID += "|" + GetProjectID;
pare.Col2 = "110";
pare.Title = "110千伏送变电工程";
pare.ParentID = "0";
pare.ProjectID = GetProjectID;
pare.Sort = 2;
Common.Services.BaseService.Create<Ps_Table_TZGS>(pare);
tzgs.ParentID = pare.ID;
}
tzgs.ID += "|" + GetProjectID;
tzgs.FromID = table.ID;
tzgs.ProjectID = GetProjectID;
tzgs.Sort = OperTable.GetTZGSMaxSort() + 1;
tzgs.Title = table.Title+"工程";
tzgs.BuildYear = list[i].StartYear;
tzgs.BuildEd = list[i].FinishYear;
tzgs.Volumn = double.Parse(list[i].Volume);
tzgs.Col3 = list[i].Status;
tzgs.AftVolumn = GetBianQ(double.Parse(list[i].Volume), list[i].Status, "110",ref n);
tzgs.BianInfo = n;
tzgs.AllVolumn = tzgs.AftVolumn;
tzgs.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(tzgs, tzgs.AllVolumn, null);
pare.AftVolumn += tzgs.AftVolumn;
pare.AllVolumn += tzgs.AllVolumn;
pare.Length += tzgs.Length;
pare.Volumn += tzgs.Volumn;
pare.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare, double.Parse(pare.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(pare, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare);
Common.Services.BaseService.Create<Ps_Table_TZGS>(tzgs);
}
}
else if (list[i].Col4 == OperTable.ph220)
{
Ps_Table_200PH table = Common.Services.BaseService.GetOneByKey<Ps_Table_200PH>(list[i].ParentID);
if (table != null)
{
Ps_Table_TZGS pare = new Ps_Table_TZGS();
pare = GetTZGSParent("220");
Ps_Table_TZGS tzgs = new Ps_Table_TZGS();
if (pare != null)
tzgs.ParentID = pare.ID;
else
{
pare = new Ps_Table_TZGS();
pare.ID += "|" + GetProjectID;
pare.Col2 = "220";
pare.Title = "220千伏送变电工程";
pare.ParentID = "0";
pare.ProjectID = GetProjectID;
pare.Sort = 1;
Common.Services.BaseService.Create<Ps_Table_TZGS>(pare);
tzgs.ParentID = pare.ID;
}
tzgs.ID += "|" + GetProjectID;
tzgs.FromID = table.ID;
tzgs.ProjectID = GetProjectID;
tzgs.Sort = OperTable.GetTZGSMaxSort() + 1;
tzgs.Title = table.Title + "工程";
tzgs.BuildYear = list[i].StartYear;
tzgs.BuildEd = list[i].FinishYear;
tzgs.Volumn = double.Parse(list[i].Volume);
tzgs.Col3 = list[i].Status;
tzgs.AftVolumn = GetBianQ(double.Parse(list[i].Volume), list[i].Status, "220",ref n);
tzgs.AllVolumn = tzgs.AftVolumn;
tzgs.BianInfo = n;
tzgs.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(tzgs, tzgs.AllVolumn, null);
pare.AftVolumn += tzgs.AftVolumn;
pare.AllVolumn += tzgs.AllVolumn;
pare.Length += tzgs.Length;
pare.Volumn += tzgs.Volumn;
pare.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare, double.Parse(pare.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(pare, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare);
Common.Services.BaseService.Create<Ps_Table_TZGS>(tzgs);
}
}
else if (list[i].Col4 == OperTable.ph500)
{
Ps_Table_500PH table = Common.Services.BaseService.GetOneByKey<Ps_Table_500PH>(list[i].ParentID);
if (table != null)
{
Ps_Table_TZGS pare = new Ps_Table_TZGS();
pare = GetTZGSParent("500");
Ps_Table_TZGS tzgs = new Ps_Table_TZGS();
if (pare != null)
tzgs.ParentID = pare.ID;
else
{
pare = new Ps_Table_TZGS();
pare.ID += "|" + GetProjectID;
pare.Col2 = "500";
pare.Title = "500千伏送变电工程";
pare.ParentID = "0";
pare.ProjectID = GetProjectID;
pare.Sort = 0;
Common.Services.BaseService.Create<Ps_Table_TZGS>(pare);
tzgs.ParentID = pare.ID;
}
tzgs.ID += "|" + GetProjectID;
tzgs.FromID = table.ID;
tzgs.ProjectID = GetProjectID;
tzgs.Sort = OperTable.GetTZGSMaxSort()+1;
tzgs.Title = table.Title + "工程";
tzgs.BuildYear = list[i].StartYear;
tzgs.BuildEd = list[i].FinishYear;
tzgs.Volumn = double.Parse(list[i].Volume);
tzgs.Col3 = list[i].Status;
tzgs.AftVolumn = GetBianQ(double.Parse(list[i].Volume), list[i].Status, "500",ref n);
tzgs.AllVolumn = tzgs.AftVolumn;
tzgs.BianInfo = n;
tzgs.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(tzgs, tzgs.AllVolumn, null);
pare.AftVolumn += tzgs.AftVolumn;
pare.AllVolumn += tzgs.AllVolumn;
pare.Length += tzgs.Length;
pare.Volumn += tzgs.Volumn;
pare.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare, double.Parse(pare.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(pare,null).ToString())+tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare);
Common.Services.BaseService.Create<Ps_Table_TZGS>(tzgs);
}
}
}
LoadData1();
//string con = "ProjectID='" + GetProjectID + "'";
//IList<Ps_Table_TZGS> list2 = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", con);
//for (int i = 0; i < list1.Count; i++)
//{
// for (int j = 0; j < list2.Count; j++)
// {
// }
//}
}
public void UpdateFuHe(string pid,string col1,Ps_Table_TZGS oldrs,Ps_Table_TZGS newrs)
{
string conn = "ProjectID='" + GetProjectID + "' and Col1='"+col1+"' and ParentID='"+pid+"'";
IList list = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", conn);
if (list.Count > 0)
{
for(int i=yAnge.BeginYear;i<=yAnge.EndYear;i++)
{
double oldyf = double.Parse(oldrs.GetType().GetProperty("yf"+i.ToString()).GetValue(oldrs,null).ToString());
double oldyk = double.Parse(oldrs.GetType().GetProperty("yk" + i.ToString()).GetValue(oldrs, null).ToString());
double newyf = double.Parse(newrs.GetType().GetProperty("yf" + i.ToString()).GetValue(newrs, null).ToString());
double newyk = double.Parse(newrs.GetType().GetProperty("yk" + i.ToString()).GetValue(newrs, null).ToString());
double myyf = double.Parse(list[0].GetType().GetProperty("yf" + i.ToString()).GetValue(list[0], null).ToString());
double myyk = double.Parse(list[0].GetType().GetProperty("yk" + i.ToString()).GetValue(list[0], null).ToString());
list[0].GetType().GetProperty("yf" + i.ToString()).SetValue(list[0], Math.Round(myyf - oldyf + newyf,1), null);
list[0].GetType().GetProperty("yk" + i.ToString()).SetValue(list[0], Math.Round(myyk - oldyk + newyk,1), null);
}
Common.Services.BaseService.Update<Ps_Table_TZGS>((Ps_Table_TZGS)list[0]);
}
}
public void AddTotalRow(ref IList list)
{
//合计
string conn = "ParentID='0' and ProjectID='" + GetProjectID + "'";
int[] year = GetYears();
Ps_Table_TZGS parent = new Ps_Table_TZGS();
parent.ID += "|" + GetProjectID;
parent.ParentID = "0"; parent.Title = "合计"; parent.Sort = 10000;// OperTable.GetMaxSort() + 1;
//
IList<Ps_Table_TZGS> teList = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", conn);
double old=0.0,te=0.0;
for (int i = 0; i < teList.Count; i++)
{
parent.AllVolumn += teList[i].AllVolumn;
parent.BefVolumn += teList[i].BefVolumn;
parent.AftVolumn += teList[i].AftVolumn;
for (int j = yAnge.StartYear + 1; j <= yAnge.StartYear + 5; j++)
{
old=double.Parse(parent.GetType().GetProperty("y"+j.ToString()).GetValue(parent,null).ToString());
te = double.Parse(teList[i].GetType().GetProperty("y"+j.ToString()).GetValue(teList[i],null).ToString());
parent.GetType().GetProperty("y" + j.ToString()).SetValue(parent, old + te, null);
}
}
list.Add(parent);
}
private bool SaveCellValue(string year, string typeID, double value)
{
Ps_Table_TZGS psp = new Ps_Table_TZGS();
Ps_Table_TZGS old = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(typeID);
psp = (Ps_Table_TZGS)old.Clone();
psp.GetType().GetProperty(year).SetValue(psp, Math.Round(value,1),null);
try
{
Common.Services.BaseService.Update<Ps_Table_TZGS>(psp);
}
catch(Exception ex)
{
MsgBox.Show("保存数据出错：" + ex.Message);
return false;
}
return true;
}
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 { }
}
}
}
public void RefreshData()
{
string n = "";
string conn = "ProjectID='" + GetProjectID + "' and ID not in (Select FromID from Ps_Table_TZGS where ProjectID = '" + GetProjectID + "')";
IList<Ps_Table_BuildPro> list = Common.Services.BaseService.GetList<Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", conn);
Ps_Table_TZGS pare110 = GetTZGSParent("110");
Ps_Table_TZGS pare220 = GetTZGSParent("220");
Ps_Table_TZGS pare500 = GetTZGSParent("500");
for (int i = 0; i < list.Count; i++)
{
n = "";
Ps_Table_BuildPro table = list[i];
// if (list[i].Col4 == OperTable.ph110)
// {
if (table != null)
{
Ps_Table_TZGS tzgs = new Ps_Table_TZGS();
tzgs.ID = table.ID;
tzgs.FromID = table.ID;
tzgs.ProjectID = GetProjectID;
tzgs.ParentID = table.ParentID;
tzgs.Sort = table.Sort;
tzgs.Title = table.Title;// +"工程";
tzgs.BuildYear = list[i].BuildYear;
tzgs.BuildEd = list[i].BuildEd;
tzgs.Volumn = list[i].Volumn;
tzgs.Col3 = list[i].Col3;
tzgs.AftVolumn = list[i].AftVolumn;
tzgs.Length = list[i].Length;
tzgs.BianInfo = list[i].BianInfo;
tzgs.AllVolumn = list[i].AllVolumn;
tzgs.Col1 = list[i].Col1;
tzgs.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(tzgs, tzgs.AllVolumn, null);
if (pare110 != null && table.ParentID==pare110.ID)
{
pare110.AftVolumn += tzgs.AftVolumn;
pare110.AllVolumn += tzgs.AllVolumn;
pare110.Length += tzgs.Length;
pare110.Volumn += tzgs.Volumn;
pare110.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare110, double.Parse(pare110.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(pare110, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare110);
}
else if (pare220 != null && table.ParentID == pare220.ID)
{
pare220.AftVolumn += tzgs.AftVolumn;
pare220.AllVolumn += tzgs.AllVolumn;
pare220.Length += tzgs.Length;
pare220.Volumn += tzgs.Volumn;
pare220.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare220, double.Parse(pare220.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(pare220, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare220);
}
else if (pare500 != null && table.ParentID == pare500.ID)
{
pare500.AftVolumn += tzgs.AftVolumn;
pare500.AllVolumn += tzgs.AllVolumn;
pare500.Length += tzgs.Length;
pare500.Volumn += tzgs.Volumn;
pare500.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare500, double.Parse(pare500.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).GetValue(pare500, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare500);
}
// Common.Services.BaseService.Update<Ps_Table_TZGS>(pare);
Common.Services.BaseService.Create<Ps_Table_TZGS>(tzgs);
}
// }
}
if (pare110 == null)
{
pare110 = GetTZGSParent("110");
if (pare110 != null)
{
pare110.AllVolumn = 0;
pare110.AftVolumn = 0;
conn = "ProjectID='" + GetProjectID + "' and ParentID = '"+pare110.ID+"'";
IList<Ps_Table_BuildPro> listt = Common.Services.BaseService.GetList<Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", conn);
foreach (Ps_Table_BuildPro t in listt)
{
pare110.AftVolumn += t.AftVolumn;
pare110.AllVolumn += t.AllVolumn;
}
pare110.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare110, pare110.AllVolumn, null);
}
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare110);
}
if (pare220 == null)
{
pare220 = GetTZGSParent("220");
if (pare110 != null)
{
pare220.AllVolumn = 0;
pare220.AftVolumn = 0;
conn = "ProjectID='" + GetProjectID + "' and ParentID = '" + pare220.ID + "'";
IList<Ps_Table_BuildPro> listt = Common.Services.BaseService.GetList<Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", conn);
foreach (Ps_Table_BuildPro t in listt)
{
pare220.AftVolumn += t.AftVolumn;
pare220.AllVolumn += t.AllVolumn;
}
pare220.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare220, pare220.AllVolumn, null);
}
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare220);
}
if (pare500 == null)
{
pare500 = GetTZGSParent("500");
if (pare500 != null)
{
pare500.AllVolumn = 0;
pare500.AftVolumn = 0;
conn = "ProjectID='" + GetProjectID + "' and ParentID = '" + pare500.ID + "'";
IList<Ps_Table_BuildPro> listt = Common.Services.BaseService.GetList<Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", conn);
foreach (Ps_Table_BuildPro t in listt)
{
pare500.AftVolumn += t.AftVolumn;
pare500.AllVolumn += t.AllVolumn;
}
pare500.GetType().GetProperty("y" + Convert.ToString(yAnge.StartYear + 1)).SetValue(pare500, pare500.AllVolumn, null);
}
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare500);
}
LoadData1();
//string con = "ProjectID='" + GetProjectID + "'";
//IList<Ps_Table_TZGS> list2 = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", con);
//for (int i = 0; i < list1.Count; i++)
//{
// for (int j = 0; j < list2.Count; j++)
// {
// }
//}
}
public void RefreshData(string type)
{
string n = "";
string conn = "COL4='"+type+"' and ProjectID='" + GetProjectID + "' and ID not in (Select ID from Ps_Table_TZGS where ProjectID = '" + GetProjectID + "')";
IList<Ps_Table_BuildPro> list = Common.Services.BaseService.GetList<Ps_Table_BuildPro>("SelectPs_Table_BuildProByConn", conn);
Ps_Table_TZGS pare110 = GetTZGSParent("110",type);
Ps_Table_TZGS pare220 = GetTZGSParent("220", type);
Ps_Table_TZGS pare500 = GetTZGSParent("500", type);
for (int i = 0; i < list.Count; i++)
{
n = "";
Ps_Table_BuildPro table = list[i];
// if (list[i].Col4 == OperTable.ph110)
// {
if (table != null)
{
Ps_Table_TZGS tzgs = new Ps_Table_TZGS();
tzgs.ID = table.ID;
tzgs.FromID = table.ID;
tzgs.ProjectID = GetProjectID;
tzgs.ParentID = table.ParentID;
tzgs.Sort = table.Sort;
tzgs.Title = table.Title;// +"工程";
tzgs.BuildYear = list[i].BuildYear;
tzgs.BuildEd = list[i].BuildEd;
tzgs.Volumn = list[i].Volumn;
tzgs.Col3 = list[i].Col3;
tzgs.AftVolumn = list[i].AftVolumn;
if (list[i].Col4=="bian")
{
if (list[i].Col5 != null && list[i].Col5!="")
{
tzgs.Num1 = Convert.ToDouble(list[i].Col5);
}
}
else if (list[i].Col4 == "line")
{
tzgs.Length = list[i].Length;
}
else if (list[i].Col4 == "sbd")
{
if (list[i].Col5 != null && list[i].Col5 != "")
{
tzgs.Num1 = Convert.ToDouble(list[i].Col5);
}
tzgs.Length = list[i].Length;
}
tzgs.BianInfo = list[i].BianInfo;
tzgs.LineInfo = list[i].LineInfo;
tzgs.AllVolumn = list[i].AllVolumn;
tzgs.Col1 = list[i].Col1;
tzgs.FromID = list[i].FromID;
tzgs.Col4 = list[i].Col4;
if (tzgs.GetType().GetProperty("y" + Convert.ToString(list[i].BuildYear)) != null)
tzgs.GetType().GetProperty("y" + Convert.ToString(list[i].BuildYear)).SetValue(tzgs, tzgs.AllVolumn, null);
if (pare110 != null && table.ParentID==pare110.ID)
{
pare110.AftVolumn += tzgs.AftVolumn;
pare110.AllVolumn += tzgs.AllVolumn;
pare110.Length += tzgs.Length;
pare110.Volumn += tzgs.Volumn;
pare110.Num1 += tzgs.Num1;
pare110.GetType().GetProperty("y" + Convert.ToString(list[i].BuildYear)).SetValue(pare110, double.Parse(pare110.GetType().GetProperty("y" + Convert.ToString(list[i].BuildEd)).GetValue(pare110, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare110);
}
else if (pare220 != null && table.ParentID == pare220.ID)
{
pare220.AftVolumn += tzgs.AftVolumn;
pare220.AllVolumn += tzgs.AllVolumn;
pare220.Length += tzgs.Length;
pare220.Volumn += tzgs.Volumn;
pare220.Num1 += tzgs.Num1;
pare220.GetType().GetProperty("y" + Convert.ToString(list[i].BuildYear)).SetValue(pare220, double.Parse(pare220.GetType().GetProperty("y" + Convert.ToString(list[i].BuildEd)).GetValue(pare220, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare220);
}
else if (pare500 != null && table.ParentID == pare500.ID)
{
pare500.AftVolumn += tzgs.AftVolumn;
pare500.AllVolumn += tzgs.AllVolumn;
pare500.Length += tzgs.Length;
pare500.Volumn += tzgs.Volumn;
pare500.Num1 += tzgs.Num1;
pare500.GetType().GetProperty("y" + Convert.ToString(list[i].BuildYear)).SetValue(pare500, double.Parse(pare500.GetType().GetProperty("y" + Convert.ToString(list[i].BuildEd)).GetValue(pare500, null).ToString()) + tzgs.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare500);
}
// Common.Services.BaseService.Update<Ps_Table_TZGS>(pare);
Common.Services.BaseService.Create<Ps_Table_TZGS>(tzgs);
}
// }
}
if (pare110 == null)
{
pare110 = GetTZGSParent("110",type);
if (pare110 != null)
{
pare110.AllVolumn = 0;
pare110.AftVolumn = 0;
pare110.Length = 0;
pare110.Volumn = 0;
pare110.Num1 = 0;
conn = "ProjectID='" + GetProjectID + "' and ParentID = '"+pare110.ID+"'";
IList<Ps_Table_TZGS> listt = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", conn);
foreach (Ps_Table_TZGS t in listt)
{
pare110.Length += t.Length;
pare110.Volumn += t.Volumn;
pare110.AftVolumn += t.AftVolumn;
pare110.AllVolumn += t.AllVolumn;
pare110.Num1 += t.Num1;
for (int i = yAnge.StartYear + 1; i <= yAnge.StartYear + 5; i++)
{
double temp = double.Parse(t.GetType().GetProperty("y" + i.ToString()).GetValue(t, null).ToString());
double old = double.Parse(pare110.GetType().GetProperty("y" + Convert.ToString(i)).GetValue(pare110, null).ToString());
pare110.GetType().GetProperty("y" + Convert.ToString(i)).SetValue(pare110, old+temp, null);
}
}
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare110);
}
}
if (pare220 == null)
{
pare220 = GetTZGSParent("220", type);
if (pare220 != null)
{
pare220.AllVolumn = 0;
pare220.AftVolumn = 0;
pare220.Length = 0;
pare220.Volumn = 0;
pare220.Num1 = 0;
conn = "ProjectID='" + GetProjectID + "' and ParentID = '" + pare220.ID + "'";
IList<Ps_Table_TZGS> listt = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", conn);
foreach (Ps_Table_TZGS t in listt)
{
pare220.Length += t.Length;
pare220.Volumn += t.Volumn;
pare220.AftVolumn += t.AftVolumn;
pare220.AllVolumn += t.AllVolumn;
pare220.Num1 += t.Num1;
for (int i = yAnge.StartYear + 1; i <= yAnge.StartYear + 5; i++)
{
double temp = double.Parse(t.GetType().GetProperty("y" + i.ToString()).GetValue(t, null).ToString());
double old = double.Parse(pare220.GetType().GetProperty("y" + Convert.ToString(i)).GetValue(pare220, null).ToString());
pare220.GetType().GetProperty("y" + Convert.ToString(i)).SetValue(pare220, old + temp, null);
}
}
// pare220.GetType().GetProperty("y" + Convert.ToString(list[i].BuildEd)).SetValue(pare220, pare220.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare220);
}
}
if (pare500 == null)
{
pare500 = GetTZGSParent("500", type);
if (pare500 != null)
{
pare500.AllVolumn = 0;
pare500.AftVolumn = 0;
pare500.Length = 0;
pare500.Volumn = 0;
pare500.Num1 = 0;
conn = "ProjectID='" + GetProjectID + "' and ParentID = '" + pare500.ID + "'";
IList<Ps_Table_TZGS> listt = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", conn);
foreach (Ps_Table_TZGS t in listt)
{
pare500.Length += t.Length;
pare500.Volumn += t.Volumn;
pare500.AftVolumn += t.AftVolumn;
pare500.AllVolumn += t.AllVolumn;
pare500.Num1 += t.Num1;
for (int i = yAnge.StartYear + 1; i <= yAnge.StartYear + 5; i++)
{
double temp = double.Parse(t.GetType().GetProperty("y" + i.ToString()).GetValue(t, null).ToString());
double old = double.Parse(pare500.GetType().GetProperty("y" + Convert.ToString(i)).GetValue(pare500, null).ToString());
pare500.GetType().GetProperty("y" + Convert.ToString(i)).SetValue(pare500, old + temp, null);
}
}
// pare500.GetType().GetProperty("y" + Convert.ToString(list[i].BuildEd)).SetValue(pare500, pare500.AllVolumn, null);
Common.Services.BaseService.Update<Ps_Table_TZGS>(pare500);
}
}
LoadData1();
//string con = "ProjectID='" + GetProjectID + "'";
//IList<Ps_Table_TZGS> list2 = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", con);
//for (int i = 0; i < list1.Count; i++)
//{
// for (int j = 0; j < list2.Count; j++)
// {
// }
//}
}
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")
{
FrmAddBuild frm = new FrmAddBuild();
//frm.TypeTitle = treeList1.FocusedNode.GetValue("Title").ToString();
frm.ParentName = treeList1.FocusedNode.GetValue("Title").ToString();
frm.Text = "修改分类名";
frm.SetLabelName = "分类名称";
frm.GetV = treeList1.FocusedNode.GetValue("FromID").ToString();
frm.Conn = tong + "ParentID='0' and ProjectID='" + GetProjectID + "' and FromID=";
frm.BEdit = true;
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.FromID = frm.GetV;
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
{
FrmAddTzgsBBPW frm = new FrmAddTzgsBBPW();
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();
try
{
frm.V = int.Parse(treeList1.FocusedNode.GetValue("FromID").ToString());
}
catch { }
frm.AreaName = treeList1.FocusedNode.GetValue("AreaName").ToString();
frm.ProjectID = ProjectUID;
if (treeList1.FocusedNode.GetValue("Col4") != null)
{
if (treeList1.FocusedNode.GetValue("Col4").ToString() == "line")
frm.Line = true;
}
frm.Text = "修改工程";
frm.StrType = table.Col4;
frm.ParentName = table.Title;
if (treeList1.FocusedNode.ParentNode!=null)
{
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;
frm.Vol = table.Volumn;
frm.TzgsXs = double.Parse(yAngeXs.Col1);
frm.DQ = table.DQ;
frm.Num1 = table.Num1;
frm.Num2 = table.Num2;
frm.uid = table.ID;
frm.operatorflag = false;
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;
for (int i = yAnge.BeginYear; i <= yAnge.EndYear; i++)
{
table.GetType().GetProperty("y" + i).SetValue(table, 0, null);
}
table.GetType().GetProperty("y" + Convert.ToString(frm.FinishYear)).SetValue(table, table.AftVolumn, null);
table.Col1 = frm.BieZhu;
table.Col3 = frm.Col3;
//table.Col4 = frm.StrType;
table.BianInfo = frm.BianInfo;
table.LineInfo = frm.LineInfo;
table.DQ = frm.DQ;
table.Num1 = frm.Num1;
table.Num2 = frm.Num2;
try
{
Common.Services.BaseService.Update<Ps_Table_TZGS>(table);
AddChildVol(table, true);
LoadData1();
FoucsLocation(table.ID, treeList1.Nodes);
}
catch { }
}
}
}
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 { }
}
}
}
