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; } }
/// <summary> /// 返回每个电压等级的容量 /// </summary> /// <param name="list"></param> private void ReturnVoltage(IList list, string strType,string strTitle) { Ps_Table_TZGS pTT = new Ps_Table_TZGS(); if (strTitle == "新建") { HP.INewVolume = new IList[list.Count]; for (int i = 0; i < list.Count; ++i) { pTT = (Ps_Table_TZGS)list[i]; SelectVoltageVolume(pTT.ID, strType, i,HP.INewVolume); } } if (strTitle == "扩建") { HP.IExtendsVolume = new IList[list.Count]; for (int i = 0; i < list.Count; ++i) { pTT = (Ps_Table_TZGS)list[i]; SelectVoltageVolume(pTT.ID, strType, i,HP.IExtendsVolume ); } } if (strTitle == "改造") { HP.IRebuildVolume = new IList[list.Count]; for (int i = 0; i < list.Count; ++i) { pTT = (Ps_Table_TZGS)list[i]; SelectVoltageVolume(pTT.ID, strType, i,HP.IRebuildVolume); } } }
public void AddModelChild(string id,string pid) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); table1.ID += "|" + GetProjectID; table1.Title = "其中:小水电"; table1.ParentID = id; table1.ProjectID = GetProjectID; table1.Col1 = "child"; table1.Col2 = "2"; table1.Col3 = "shui"; table1.Col4 = pid; table1.Sort = 0; Ps_Table_TZGS table3 = new Ps_Table_TZGS(); table3.ID += "|" + GetProjectID; table3.Title = "其它"; table3.Col1 = "child"; table3.Col2 = "2"; table3.ParentID = id; table3.ProjectID = GetProjectID; table3.Col3 = "other"; table3.Col4 = pid; table3.Sort = 2; Ps_Table_TZGS table2 = new Ps_Table_TZGS(); table2.ID += "|" + GetProjectID; table2.Title = "小火电"; table2.Col1 = "child"; table2.Col2 = "2"; table2.ParentID = id; table2.ProjectID = GetProjectID; table2.Col3 = "huo"; table2.Col4 = pid; table2.Sort = 1; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); Common.Services.BaseService.Create("InsertPs_Table_TZGS", table3); Common.Services.BaseService.Create("InsertPs_Table_TZGS", table2); }
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 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); }
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; }
public Ps_Table_TZGS GetTZGSParent(string type) { try { IList list = Common.Services.BaseService.GetList("SelectPs_Table_TZGSByConn", "Col2='"+type+"' and ProjectID='"+GetProjectID+"' and ParentID='0'"); Ps_Table_TZGS guid = new Ps_Table_TZGS(); guid = null; if (list.Count > 0) guid = (Ps_Table_TZGS)list[0]; return guid; } catch { return null; } }
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 barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FrmAddTzgsAHTL frm = new FrmAddTzgsAHTL(); frm.Text = "增加"; // frm.Stat = focusedNode.GetValue("Col2").ToString(); // frm.SetLabelName = "子分类名称"; Ps_Table_TZGS table1 = new Ps_Table_TZGS(); table1.ID += "|" + GetProjectID; frm.TZGSID = table1.ID; if (frm.ShowDialog() == DialogResult.OK) { table1.Title = frm.ParentName; table1.ParentID = "0";// 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.LineVol+frm.BianVol; // table1.BefVolumn = frm.AllVol; //table1.AftVolumn = frm.LineVol + frm.BianVol; table1.LineInfo = frm.LineInfo; table1.BianInfo = frm.BianInfo; table1.AreaName = frm.AreaName; //用y1990存放线路长度 table1.y1990= frm.LineLen + frm.LineLen2; //table1.Length2 = frm.LineLen2; table1.Sort = OperTable.GetTZGSMaxSort() + 1; table1.Col3 = frm.Col3; table1.Col1 = frm.BieZhu; table1.DQ = frm.DQ; table1.JGNum = frm.JGNum; table1.WGNum = frm.WGNum; table1.ProgType = frm.ProgType; table1.Amount = frm.Amount; table1.Num6 = frm.Num6; try { string pid = table1.ID; string tit = table1.Title; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); frm.StrType = "bian"; table1.Title = tit + "-变电"; table1.Col4 = "bian"; table1.Volumn = frm.Vol; table1.AllVolumn = frm.Amount; // table1.BefVolumn = frm.AllVol; //table1.AftVolumn = frm.BianVol; table1.Length = 0; table1.Length2 = 0; table1.y1990 = 0; table1.ParentID = pid; table1.ID = Guid.NewGuid().ToString(); table1.BianInfo = frm.BianInfo; table1.Num1 = frm.Num1; table1.Num2 = frm.Num2; table1.Num5 = frm.Num5; table1.Amount = frm.Amount; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); frm.StrType = "line"; table1.Title = tit + "-线路"; table1.Col4 = "line"; table1.Length = frm.LineLen; table1.Volumn = 0; table1.AllVolumn = frm.Amount; // table1.BefVolumn = frm.AllVol; //table1.AftVolumn = frm.LineVol; table1.y1990 = frm.LineLen + frm.LineLen2; table1.Length = frm.LineLen; table1.Length2 = frm.LineLen2; table1.ParentID = pid; table1.ID = Guid.NewGuid().ToString(); table1.LineInfo = frm.LineInfo; table1.Num1 = frm.Num1; table1.Num2 = frm.Num2; table1.Num5 = frm.Num5; table1.Num6 = frm.Num6; table1.Length = frm.LineLen; table1.Length2 = frm.LineLen2; table1.Amount = frm.Amount; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); LoadData(); } 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 { 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 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 { } } } }
/// <summary> /// 写入低压数据 /// </summary> /// <param name="FB"></param> /// <param name="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteLowData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { Ps_Table_TZGS pTT = new Ps_Table_TZGS(); Ps_Table_TZGS pTT1 = new Ps_Table_TZGS(); Ps_Table_TZGS pTT2 = new Ps_Table_TZGS(); string VolatageClass = null; string UnitTemp=null; string strTitle = null; IList listKG = null; IList listPB = null; for (int i = 0; i < LP.ILow.Count; ++i) { pTT = (Ps_Table_TZGS)LP.ILow[i]; VolatageClass = ReturnLowVoltageClass("b", pTT.Title); listKG = ReturnLowRows("d");//开关 listPB = ReturnLowRows("c");//配变 pTT1 = (Ps_Table_TZGS)listPB[i]; pTT2 = (Ps_Table_TZGS)listKG[i]; for (int j = 0; j < LowPressure.IntCount; ++j) { if(j==0||j==1) { UnitTemp = strUnit + strUnit1; PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT.Length.ToString());// ReturnFabricationCost(LP.strType[j], VolatageClass); if(LP.list!=null) { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 5, UnitTemp); } else if (j == 2 || j == 3 || j == 4)//开关站,箱式变电站,配电室 { UnitTemp = strUnit + strUnit2; obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 5, UnitTemp); } else if (j == 5 || j == 6 || j == 7)//环网柜,柱上变,电缆分支箱 { UnitTemp = strUnit + strUnit3; obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 5, UnitTemp); } if (j == LowPressure.IntCount-2||j==LowPressure.IntCount-1)//最后一行 { for (int col = 2; col < obj.ColumnCount; ++col) { //obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), col,"kk"); obj.Cells[(IntRow + 1 + j + i * LowPressure.IntCount), col].Locked = false;//手写 } } if(j==LowPressure.IntCount-1) { //鼠标右键点击出现菜单 } strTitle = (string)PF.ReturnStr(obj, (IntRow + 1 + j + i * LowPressure.IntCount), 1); switch (strTitle) { case "开关站": PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT2.Num1.ToString());// ReturnFabricationCostTitle("常规", VolatageClass, strTitle); if (LP.list == null) { //MessageBox.Show(strTitle + "没有数据!!!"); } else { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } break; case "箱式变电站": PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT1.Num3.ToString());// ReturnFabricationCostTitle("常规", VolatageClass, strTitle); if (LP.list == null) { //MessageBox.Show(strTitle + "没有数据!!!"); } else { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } break; case "配电室": PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT1.Num1.ToString());// ReturnFabricationCostTitle("常规", VolatageClass, strTitle); if(LP.list==null) { //MessageBox.Show(strTitle + "没有数据!!!"); }else { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } break; case "环网柜": PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT2.Num2.ToString());// ReturnFabricationCostTitle("常规", VolatageClass, strTitle); if (LP.list == null) { //MessageBox.Show(strTitle + "没有数据!!!"); } else { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } break; case "柱上变": PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT1.Num5.ToString());// ReturnFabricationCostTitle("常规", VolatageClass, strTitle); if (LP.list == null) { //MessageBox.Show(strTitle + "没有数据!!!"); } else { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } break; case "电缆分支箱": PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 2, VolatageClass);// PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 3, pTT2.Num4.ToString());// ReturnFabricationCostTitle("常规", VolatageClass, strTitle); if (LP.list == null) { //MessageBox.Show(strTitle + "没有数据!!!"); } else { PF.CreateSheetView(obj, 1, 1, (IntRow + 1 + j + i * LowPressure.IntCount), 4, LP.list.Num.ToString());// obj.SetValue((IntRow + 1 + j + i * LowPressure.IntCount), 6, LP.list.L4); } break; default: break; } } } }
/// <summary> /// 写入高压数据 /// </summary> /// <param name="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteHeightData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { int RowTemp = IntRow; double Amount = 0; IList list = null; Ps_Table_TZGS pTT = new Ps_Table_TZGS(); Ps_Table_TZMX pTT1 = new Ps_Table_TZMX(); //IList list = null; //list = SelectVoltageClass(FB, "新建"); for (int i = 0; i < HP.INew.Count; i++) { pTT = (Ps_Table_TZGS)HP.INew[i]; PF.CreateSheetView(obj, HP.INewVolume[i].Count, 1, RowTemp, 2, pTT.BianInfo);//新建 list = HP.INewVolume[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; PF.CreateSheetView(obj, 1, 1, (RowTemp + j), 3, pTT1.Vol.ToString() + unit);//新建 Amount = ReturnAmount(pTT1, pTT, "sub"); obj.SetValue(RowTemp, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp,5,strUnit+unit);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } if (HP.INewVolume[i].Count == 0) { RowTemp += 1; } else { RowTemp += HP.INewVolume[i].Count; } } //list = SelectVoltageClass(FB, "扩建"); for (int i = 0; i < HP.IExtends.Count; i ++) { pTT = (Ps_Table_TZGS)HP.IExtends[i]; PF.CreateSheetView(obj, HP.IExtendsVolume[i].Count, 1, RowTemp , 2, pTT.BianInfo);//扩建 list = HP.IExtendsVolume[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; PF.CreateSheetView(obj, 1, 1, (RowTemp + j), 3, pTT1.Vol.ToString() + unit);//扩建 Amount = ReturnAmount(pTT1, pTT, "sub"); obj.SetValue(RowTemp, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + unit);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } if (HP.IExtendsVolume[i].Count==0) { RowTemp += 1; } else { RowTemp += HP.IExtendsVolume[i].Count; } } //list = SelectVoltageClass(FB, "改造"); for (int i = 0; i < HP.IRebuild.Count; i ++) { pTT = (Ps_Table_TZGS)HP.IRebuild[i]; PF.CreateSheetView(obj, HP.IRebuildVolume[i].Count, 1, RowTemp , 2, pTT.BianInfo);//改造 list = HP.IRebuildVolume[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; PF.CreateSheetView(obj, 1, 1, (RowTemp + j), 3, pTT1.Vol.ToString() + unit);//改造 Amount = ReturnAmount(pTT1, pTT, "sub"); obj.SetValue(RowTemp, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + unit);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } if (HP.IRebuildVolume[i].Count==0) { RowTemp += 1; } else { RowTemp += HP.IRebuildVolume[i].Count; } } //架空线路 for(int i=0;i<HP.INew.Count;++i) { pTT = (Ps_Table_TZGS)HP.INew[i]; ////if (HP.Length[i].Count == 0 || HP.Length[i] == null) ////{ //// intTemp = 1; ////} ////else ////{ //// intTemp = HP.Length[i].Count; ////} PF.CreateSheetView(obj, 1, 1, RowTemp +i, 2, pTT.BianInfo);//新建架空电压等级 PF.CreateSheetView(obj, 1, 1, RowTemp+i, 3, pTT.Length.ToString());//新建架空线路 list = HP.Length[i]; for (int j = 0; j < list.Count;++j ) { pTT1 = (Ps_Table_TZMX)list[j]; Amount = ReturnAmount(pTT1, pTT, "line"); obj.SetValue(RowTemp + i, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + strUnit1);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } } RowTemp += HP.INew.Count; //新建电缆线路 for(int i=0;i<HP.INew.Count;++i) { pTT = (Ps_Table_TZGS)HP.INew[i]; ////if (HP.Length[i].Count == 0 || HP.Length[i] == null) ////{ //// intTemp = 1; ////} ////else ////{ //// intTemp = HP.Length[i].Count; ////} PF.CreateSheetView(obj, 1, 1, RowTemp+i , 2, pTT.BianInfo);//新建电缆电压等级 PF.CreateSheetView(obj, 1, 1, RowTemp+i, 3, pTT.Length2.ToString());//新建电缆线路 list = HP.Length[i]; for (int j = 0; j < list.Count; ++j) { pTT1 = (Ps_Table_TZMX)list[j]; Amount = ReturnAmount(pTT1, pTT, "line"); obj.SetValue(RowTemp + i, 4, Amount);//单位工程综合造价 obj.SetValue(RowTemp, 5, strUnit + strUnit1);//单位 obj.SetValue(RowTemp, 6, pTT.Col1);//备注 } } RowTemp += HP.INew.Count; }
/// <summary> /// 左侧标题 /// </summary> private void SetLeftTitle(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { PF.CreateSheetView(obj, HP.RowsCount, 1, IntRow, 0, "高压配电网"); PF.CreateSheetView(obj, LP.RowsCount, 1, (IntRow + HP.RowsCount), 0, "中低压配电网"); PF.CreateSheetView(obj, 1, 1, (IntRow + HP.RowsCount + LP.RowsCount), 0, "其它"); /*高压部分*******************************************************************************************/ PF.CreateSheetView(obj, HP.Volume[0], 1, IntRow, 1, HP.strTitle[0]);//新建 PF.CreateSheetView(obj, HP.Volume[1], 1, IntRow += HP.Volume[0], 1, HP.strTitle[1]);//扩建 PF.CreateSheetView(obj, HP.Volume[2], 1, IntRow += HP.Volume[1], 1, HP.strTitle[2]);//改造 PF.CreateSheetView(obj, HP.INew.Count, 1, IntRow += HP.Volume[2], 1, HP.strTitle[3]);//新建架空 PF.CreateSheetView(obj, HP.INew.Count, 1, IntRow += HP.INew.Count, 1, HP.strTitle[4]);//新建电缆 /* ********************************************************************************************************************** */ /** 低压部分***********************************************************************************************************/ Ps_Table_TZGS pTT = new Ps_Table_TZGS(); for(int i=0;i<LP.ILow.Count;++i) { pTT = (Ps_Table_TZGS)LP.ILow[i]; for(int j=0;j<LowPressure.IntCount;++j) { if(j==0) { PF.CreateSheetView(obj, 1, obj.ColumnCount, (5+HP.RowsCount + j + i * LowPressure.IntCount), 1, pTT.Title);//标题 } else { PF.CreateSheetView(obj, 1, 1, (5 + HP.RowsCount + j + i * LowPressure.IntCount), 1, LP.strTitle[j - 1]);// } } } }
private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (!base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (treeList1.FocusedNode.GetValue("ParentID").ToString() != "0") { MsgBox.Show("此分类不是总分类!"); return; } if (MsgBox.ShowYesNo("总分类及其下属分类都将删除,是否删除总分类 " + treeList1.FocusedNode.GetValue("Title") + "?") == DialogResult.Yes) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); // Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode); table1.ID = treeList1.FocusedNode.GetValue("ID").ToString(); DelAll(table1.ID); try { //DeletePSP_ValuesByType里面删除数据和分类 Common.Services.BaseService.Delete<Ps_Table_TZGS>(table1);//("DeletePs_Table_TZGS", table1); treeList1.DeleteNode(treeList1.FocusedNode); //treeList1.ExpandAll(); //删除后,如果同级还有其它分类,则重新计算此类的所有年份数据 } catch (Exception ex) { //MsgBox.Show("删除出错:" + ex.Message); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } } }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FrmAddTzgsAHTL frm = new FrmAddTzgsAHTL(); Ps_Table_TZGS table = new Ps_Table_TZGS(); table = Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(FocusedObject.ID); frm.TZGSID = table.ID; frm.ParentName = table.Title; //treeList1.FocusedNode.GetValue("Title").ToString(); frm.Text = "修改工程"; //frm.Stat = treeList1.FocusedNode.ParentNode.GetValue("Col2").ToString(); frm.StrType = ""; 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.LineLen2 = table.Length2; 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.DQ = table.DQ; frm.Num6=table.Num6; 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.Amount =t1.Amount; 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; frm.Num6 = t2.Num6; frm.Amount = t2.Amount; frm.LineLen = t2.Length; frm.LineLen2 = t2.Length2; if (frm.ShowDialog() == DialogResult.OK) { //AddChildVol(table, false); frm.StrType = ""; table.Title = frm.ParentName; table.BuildYear = frm.StartYear; table.BuildEd = frm.FinishYear; table.Length=frm.LineLen ; table.Length2 = frm.LineLen2; table.Volumn = frm.Vol; table.AllVolumn = frm.Amount; // table1.BefVolumn = frm.AllVol; //table.AftVolumn = frm.LineVol + frm.BianVol; //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.AreaName = frm.AreaName; table.WGNum = frm.WGNum; //用y1990存放线路长度 table.y1990 = frm.LineLen + frm.LineLen2; table.DQ = frm.DQ; frm.StrType = "bian"; t1.Num1 = frm.Num1; t1.Num2 = frm.Num2; t1.Num5 = frm.Num5; t1.WGNum = frm.WGNum; t1.AreaName = frm.AreaName; t1.Col3 = frm.Col3; t1.DQ = frm.DQ; t1.ProgType = frm.ProgType; t1.BuildYear = frm.StartYear; t1.BuildEd = frm.FinishYear; t1.Amount=frm.Amount; t1.Volumn = frm.Vol; t1.AllVolumn = frm.Amount; // table1.BefVolumn = frm.AllVol; //t1.AftVolumn = frm.BianVol; t1.y1990 = 0; frm.StrType = "line"; t2.Num1 = frm.Num1; t2.Num2 = frm.Num2; t2.Num5 = frm.Num5; t2.Num6 = frm.Num6; t2.Length = frm.LineLen; t2.Length2 = frm.LineLen2; t2.AreaName = frm.AreaName; t2.Col3 = frm.Col3; t2.DQ = frm.DQ; t2.ProgType = frm.ProgType; t2.BuildYear = frm.StartYear; t2.BuildEd = frm.FinishYear; t2.Amount = frm.Amount; t2.AllVolumn = frm.Amount; // table1.BefVolumn = frm.AllVol; //t2.AftVolumn = frm.LineVol; t2.y1990 = frm.LineLen + frm.LineLen2; 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); LoadData(); } catch { } } }
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 void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (FocusedObject == null) return; if (!base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } if (MsgBox.ShowYesNo("是否删除选中的工程?") == DialogResult.Yes) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); table1.ID = FocusedObject.ID; Services.BaseService.Update("DeletePs_Table_TZGS", table1); } LoadData(); }
public void DelAll(string suid) { string conn = "ParentId='" + suid + "'"; IList<Ps_Table_TZGS> list = Common.Services.BaseService.GetList<Ps_Table_TZGS>("SelectPs_Table_TZGSByConn", conn); if (list.Count > 0) { foreach (Ps_Table_TZGS var in list) { string child = var.ID; DelAll(child); Ps_Table_TZGS ny = new Ps_Table_TZGS(); ny.ID = child; Common.Services.BaseService.Delete(ny); } } else return; }
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 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++) // { // } //} }
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 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); } } }
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { return; } if (!base.DeleteRight) { MsgBox.Show("您没有权限进行此项操作!"); return; } string nodestr = treeList1.FocusedNode.GetValue("Col1").ToString(); string parentid = treeList1.FocusedNode["ParentID"].ToString(); if (treeList1.FocusedNode.HasChildren) { MsgBox.Show("此工程下有子工程,请先删除子工程!"); return; } if (treeList1.FocusedNode.GetValue("ParentID").ToString() == "0") { MsgBox.Show("此工程是分类,请用“删除分类”功能!"); return; } if (MsgBox.ShowYesNo("是否删除工程 " + treeList1.FocusedNode.GetValue("Title") + "?") == DialogResult.Yes) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); // Class1.TreeNodeToDataObject<PSP_Types>(psp_Type, treeList1.FocusedNode); table1.ID = treeList1.FocusedNode.GetValue("ID").ToString(); try { //DeletePSP_ValuesByType里面删除数据和分类 TreeListNode node1 = treeList1.FocusedNode.NextNode; string teID = ""; if (node1 != null) teID = node1.GetValue("ID").ToString(); AddChildVol(Common.Services.BaseService.GetOneByKey<Ps_Table_TZGS>(table1.ID), false); Common.Services.BaseService.Delete <Ps_Table_TZGS>(table1);//("DeletePs_Table_TZGS", table1); treeList1.DeleteNode(treeList1.FocusedNode); LoadData1(); FoucsLocation(teID, treeList1.Nodes); } catch (Exception ex) { //MsgBox.Show("删除出错:" + ex.Message); this.Cursor = Cursors.WaitCursor; treeList1.BeginUpdate(); LoadData(); treeList1.EndUpdate(); this.Cursor = Cursors.Default; } } }
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; }
/// <summary> /// 返回单位工程综合造价 /// </summary> /// <param name="pTT1"></param> /// <returns></returns> private double ReturnAmount(Ps_Table_TZMX pTT1, Ps_Table_TZGS pTT,string Typeqf) { string strTemp = null; int beginYear = 0; int EndYear = 0; int.TryParse(pTT1.BuildYear, out beginYear); int.TryParse(pTT1.BuildEnd, out EndYear); strTemp = null; for (int k = beginYear; k <= EndYear; ++k) { if (k == EndYear) strTemp += "y" + k; else strTemp += "y" + k + "+"; } return SelectAmount(strTemp, pTT.ID, "sub"); }