public void LoadData() { try { string sql = " and a.ProjectID='" + GetProjectID + "'"; IList <Ps_Table_TZGS> list = Services.BaseService.GetList <Ps_Table_TZGS>("SelectPs_Table_TZGSByListWherepw", sql); for (int i = 0; i < list.Count; i++) { Ps_Table_TZGS p = list[i]; p.Sort = (i + 1); p.FromID = p.LineInfo.Split("@".ToCharArray())[0]; p.ProjectID = "蚌埠"; if (p.DQ == "市辖供电区") { p.ParentID = "蚌埠市区"; } else { p.ParentID = "蚌埠县区"; } } this.gridControl.DataSource = list; } catch (Exception e1) { MessageBox.Show(e1.Message); } }
/// <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); } } }
/// <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]);// } } } }
/// <summary> /// 写入数据 /// </summary> /// <param name="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { Ps_Table_TZGS pTT = null; string strTitle = null; string strDQ = null; Object Value = null; for (int i = 0; i < obj.RowCount - IntRow; i += AreaValue.Count) { strTitle = PF.ReturnStr(obj, IntRow + i, 0).ToString(); //县级还是市辖 strDQ = PF.ReturnStr(obj, IntRow + i, 1).ToString(); //分区 SelectValue(FB, strTitle, strDQ); for (int v = 0; v < AreaValue.Count; ++v) { pTT = (Ps_Table_TZGS)AreaValue[v]; for (int j = 2; j < obj.ColumnCount; ++j) { switch (j) { case 2: Value = pTT.BianInfo.Substring(0, pTT.BianInfo.IndexOf("@", 0, pTT.BianInfo.Length)); //电压等级 break; case 3: Value = pTT.y2010; // break; case 4: Value = pTT.y2011; // break; case 5: //*************************************** Value = pTT.y2012; // break; case 6: Value = pTT.y2013; // break; case 7: Value = pTT.y2014; // break; case 8: Value = pTT.y2015; // break; default: break; } obj.SetValue(IntRow + i + v, j, Value);// } } } }
private void ReturnVol() { Ps_Table_TZGS pTT = null; HP.Length = new IList[HP.ILineAndJK.Count]; for (int i = 0; i < HP.ILineAndJK.Count; ++i) { pTT = (Ps_Table_TZGS)HP.INew[i]; SelectLineAndJKOfVal(pTT.ID, i); } }
public double GetNum(int year) { double num = 0.0; foreach (Control ctrl in groupControl1.Controls) { if (ctrl is CheckBox) { if ((ctrl as CheckBox).Checked == true) { Ps_Table_TZGS tzgs = (ctrl as CheckBox).Tag as Ps_Table_TZGS; num += double.Parse(tzgs.GetType().GetProperty("y" + year.ToString()).GetValue(tzgs, null).ToString()); } } } return(num); }
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(); }
/// <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")); }
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (advBandedGridView1.RowCount == 0) { return; } FrmAddTzgsWH2pw frm = new FrmAddTzgsWH2pw(); Ps_Table_TZGS table = new Ps_Table_TZGS(); table = Common.Services.BaseService.GetOneByKey <Ps_Table_TZGS>(FocusedObject.ID); frm.tzgspwid = table.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.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 = "pw"; frm.Amount = table.Amount; frm.StrType = "pw-pb"; Ps_Table_TZGS t1 = new Ps_Table_TZGS(); string sql1 = " ParentID='" + table.ID + "' and Col4='pw-pb'"; t1 = (Ps_Table_TZGS)Common.Services.BaseService.GetObject("SelectPs_Table_TZGSByConn", sql1); frm.Num1 = t1.Num1; frm.Num2 = t1.Num2; frm.Num3 = t1.Num3; frm.Num4 = t1.Num4; frm.Num5 = t1.Num5; frm.Num6 = t1.Num6; frm.Amount = t1.Amount; frm.StrType = "pw-kg"; Ps_Table_TZGS t2 = new Ps_Table_TZGS(); string sql2 = " ParentID='" + table.ID + "' and Col4='pw-kg'"; t2 = (Ps_Table_TZGS)Common.Services.BaseService.GetObject("SelectPs_Table_TZGSByConn", sql2); frm.Num1 = t2.Num1; frm.Num2 = t2.Num2; frm.Num3 = t2.Num3; frm.Num4 = t2.Num4; frm.Amount = t2.Amount; frm.StrType = "pw-line"; Ps_Table_TZGS t3 = new Ps_Table_TZGS(); string sql3 = " ParentID='" + table.ID + "' and Col4='pw-line'"; t3 = (Ps_Table_TZGS)Common.Services.BaseService.GetObject("SelectPs_Table_TZGSByConn", sql3); frm.Num1 = t3.Num1; frm.Num2 = t3.Num2; frm.Num3 = t3.Num3; frm.Num4 = t3.Num4; frm.Num5 = t3.Num5; frm.Num6 = t3.Num6; frm.LineLen = t3.Length; frm.LineLen2 = t3.Length2; frm.Amount = t3.Amount; 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.Length2 = frm.LineLen2; //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 = "pw"; table.Amount = frm.Amount; table.AreaName = frm.AreaName; frm.StrType = "pw-pb"; t1.Num1 = frm.Num1; t1.Num2 = frm.Num2; t1.Num3 = frm.Num3; t1.Num4 = frm.Num4; t1.Num5 = frm.Num5; t1.Num6 = frm.Num6; t1.Amount = frm.Amount; t1.AreaName = frm.AreaName; t1.Col3 = frm.Col3; t1.DQ = frm.DQ; t1.ProgType = frm.ProgType; t1.BuildYear = frm.StartYear; t1.BuildEd = frm.FinishYear; frm.StrType = "pw-kg"; t2.Num1 = frm.Num1; t2.Num2 = frm.Num2; t2.Num3 = frm.Num3; t2.Num4 = frm.Num4; t2.Amount = frm.Amount; t2.AreaName = frm.AreaName; t2.Col3 = frm.Col3; t2.DQ = frm.DQ; t2.ProgType = frm.ProgType; t2.BuildYear = frm.StartYear; t2.BuildEd = frm.FinishYear; frm.StrType = "pw-line"; t3.Num1 = frm.Num1; t3.Num2 = frm.Num2; t3.Num3 = frm.Num3; t3.Num4 = frm.Num4; t3.Num5 = frm.Num5; t3.Num6 = frm.Num6; t3.Length = frm.LineLen; t3.Length2 = frm.LineLen2; t3.Amount = frm.Amount; t3.AreaName = frm.AreaName; t3.Col3 = frm.Col3; t3.DQ = frm.DQ; t3.ProgType = frm.ProgType; t3.BuildYear = frm.StartYear; t3.BuildEd = frm.FinishYear; 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); Common.Services.BaseService.Update <Ps_Table_TZGS>(t3); LoadData(); } catch { } } }
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { FrmAddTzgsWH2pw frm = new FrmAddTzgsWH2pw(); frm.Text = "增加"; // frm.Stat = focusedNode.GetValue("Col2").ToString(); // frm.SetLabelName = "子分类名称"; if (frm.ShowDialog() == DialogResult.OK) { Ps_Table_TZGS table1 = new Ps_Table_TZGS(); table1.ID += "|" + GetProjectID; frm.tzgspwid = table1.ID; 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.AllVolumn = frm.AllVol; //table1.AftVolumn = frm.AllVol; table1.LineInfo = frm.LineInfo; table1.BianInfo = frm.BianInfo; table1.AreaName = frm.AreaName; table1.Length = frm.LineLen; 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; table1.Col4 = "pw"; frm.StrType = "pw"; table1.Amount = frm.Amount; try { string pid = table1.ID; string tit = table1.Title; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); frm.StrType = "pw-pb"; table1.Title = tit + "-配变"; table1.Col4 = "pw-pb"; //table1.Volumn = frm.Vol; table1.ParentID = pid; table1.ID = Guid.NewGuid().ToString(); table1.Num1 = frm.Num1; table1.Num2 = frm.Num2; table1.Num3 = frm.Num3; table1.Num4 = frm.Num4; table1.Num5 = frm.Num5; table1.Num6 = frm.Num6; table1.Amount = frm.Amount; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); frm.StrType = "pw-kg"; table1.Title = tit + "-开关"; table1.Col4 = "pw-kg"; table1.ParentID = pid; table1.ID = Guid.NewGuid().ToString(); table1.Num1 = frm.Num1; table1.Num2 = frm.Num2; table1.Num3 = frm.Num3; table1.Num4 = frm.Num4; table1.Amount = frm.Amount; Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1); frm.StrType = "pw-line"; table1.Title = tit + "-线路"; table1.Col4 = "pw-line"; table1.Length = frm.LineLen; table1.ParentID = pid; table1.ID = Guid.NewGuid().ToString(); table1.LineInfo = frm.LineInfo; table1.Num1 = frm.Num1; table1.Num2 = frm.Num2; table1.Num3 = frm.Num3; table1.Num4 = frm.Num4; 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); } } }
/// <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 WriteData(Itop.Client.Base.FormBase FB, FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { Ps_Table_TZGS pTT = null; string strTitle = null; string strDQ = null; string temp = null; Object Value = null; int index = 0; for (int i = 0; i < obj.RowCount - IntRow; i += AreaValue.Count * projectVC) { strTitle = PF.ReturnStr(obj, IntRow + i, 0).ToString(); //县级还是市辖 strDQ = PF.ReturnStr(obj, IntRow + i, 1).ToString(); //分区 SelectValue(FB, strTitle, strDQ); index = 0; for (int v = 0; v < AreaValue.Count * projectVC; v += projectVC) { pTT = (Ps_Table_TZGS)AreaValue[index]; temp = pTT.BianInfo.Substring(0, pTT.BianInfo.IndexOf("@", 0, pTT.BianInfo.Length));//电压等级 PF.CreateSheetView(obj, projectVC, 1, IntRow + i + v, 2, temp); index++; for (int n = 0; n < projectVC; ++n)//项目 { PF.CreateSheetView(obj, 1, 1, IntRow + i + v + n, 3, strProject[n]); for (int j = 4; j < obj.ColumnCount; ++j) { Value = 0; switch (j) { case 4: if (pTT.BuildYear == "2010" && n == 0) { Value = pTT.Num1 + pTT.Num3 + pTT.Num5; // } if (pTT.BuildYear == "2010" && n == 1) { Value = pTT.Num2 + pTT.Num4 + pTT.Num6; // } break; case 5: //*************************************** if (pTT.BuildYear == "2011" && n == 0) { Value = pTT.Num1 + pTT.Num3 + pTT.Num5; // } if (pTT.BuildYear == "2011" && n == 1) { Value = pTT.Num2 + pTT.Num4 + pTT.Num6; // } break; case 6: if (pTT.BuildYear == "2012" && n == 0) { Value = pTT.Num1 + pTT.Num3 + pTT.Num5; // } if (pTT.BuildYear == "2012" && n == 1) { Value = pTT.Num2 + pTT.Num4 + pTT.Num6; // } break; case 7: if (pTT.BuildYear == "2013" && n == 0) { Value = pTT.Num1 + pTT.Num3 + pTT.Num5; // } if (pTT.BuildYear == "2013" && n == 1) { Value = pTT.Num2 + pTT.Num4 + pTT.Num6; // } break; case 8: if (pTT.BuildYear == "2014" && n == 0) { Value = pTT.Num1 + pTT.Num3 + pTT.Num5; // } if (pTT.BuildYear == "2014" && n == 1) { Value = pTT.Num2 + pTT.Num4 + pTT.Num6; // } break; case 9: if (pTT.BuildYear == "2015" && n == 0) { Value = pTT.Num1 + pTT.Num3 + pTT.Num5; // } if (pTT.BuildYear == "2015" && n == 1) { Value = pTT.Num2 + pTT.Num4 + pTT.Num6; // } break; case 10: obj.Cells[IntRow + i + v + n, j].Formula = "SUM(F" + (IntRow + i + v + n + 1) + ":J" + (IntRow + i + v + n + 1) + ")"; // break; default: break; } if (j != 10) { obj.SetValue(IntRow + i + v + n, j, Value);// } } } } } }
private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow) { Ps_Table_TZGS ptz = null; int index = 1; for (int i = 0; i < Llist.Count; ++i)//低压 { ptz = (Ps_Table_TZGS)Llist[i]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 obj.SetValue((i + IntRow), j, index); break; case 1: //项目 obj.SetValue((i + IntRow), j, ptz.Title); break; case 2: //项目性质 obj.SetValue((i + IntRow), j, ptz.Col3); break; case 3: //建设年限 obj.SetValue((i + IntRow), j, ptz.BuildEd); break; case 4: //建设内容 obj.SetValue((i + IntRow), j, ptz.Col1); break; case 5: //资金 obj.SetValue((i + IntRow), j, ptz.Amount); break; default: break; } } index++; } for (int i = 0; i < HList.Count; ++i)//高压 { ptz = (Ps_Table_TZGS)HList[i]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 obj.SetValue((i + IntRow + Llist.Count), j, index); break; case 1: //项目 obj.SetValue((i + IntRow + Llist.Count), j, ptz.Title); break; case 2: //项目性质 obj.SetValue((i + IntRow + Llist.Count), j, ptz.Col3); break; case 3: //建设年限 obj.SetValue((i + IntRow + Llist.Count), j, ptz.BuildEd); break; case 4: //建设内容 obj.SetValue((i + IntRow + Llist.Count), j, ptz.Col1); break; case 5: //资金 obj.SetValue((i + IntRow + Llist.Count), j, ptz.Amount); break; default: break; } } index++; } }
/// <summary> /// 写入数据 /// </summary> /// <param name="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { Ps_Table_TZGS pTT_A = null; Ps_Table_TZGS pTT_B = null; Ps_Table_TZGS pTT_C = null; Ps_Table_TZGS pTT_D = null; Object value = null; IList list_A = Value_A[0]; IList list_B = Value_B[0]; IList list_C = Value_C[0]; IList list_D = Value_D[0]; string City = "市区供电区"; string County = "县域供电区"; int index = 1; for (int i = IntRow; i < Value_A[0].Count + IntRow; ++i)//市辖 { pTT_A = (Ps_Table_TZGS)list_A[i - IntRow]; pTT_B = (Ps_Table_TZGS)list_B[i - IntRow]; pTT_C = (Ps_Table_TZGS)list_C[i - IntRow]; pTT_D = (Ps_Table_TZGS)list_D[i - IntRow]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 value = index; break; case 1: //电压等级(kV) value = pTT_C.BianInfo.Substring(0, pTT_C.BianInfo.IndexOf("@", 0, pTT_C.BianInfo.Length)); //电压等级// pTT.Title.Substring(0,pTT.Title.IndexOf("-",0,pTT.Title.Length)); break; case 2: //工程名称 value = pTT_A.Title; break; case 3: //供电区名称 value = pTT_A.AreaName + City; break; case 4: //供电区性质 value = "市辖区"; break; case 5: //工程描述 value = pTT_A.Col1; break; case 6: //高损配变 台数(台) break; case 7: //高损配变 容量(MVA) break; case 8: //无功补偿装置 组数(组) break; case 9: //无功补偿装置 容量(Mvar) break; case 10: //开关类 断路器(台) value = pTT_D.Num5; break; case 11: //开关类 负荷开关(台) 现在用柱上开关 value = pTT_D.Num3; break; case 12: //开关类 环网柜(座) value = pTT_D.Num2; break; case 13: //开关类 电缆分支箱(座) value = pTT_D.Num4; break; case 14: //架空线路 线路长度(km) value = pTT_B.Length; break; case 15: //架空线路 杆塔(基) value = pTT_B.Num2; break; case 16: //电缆线路 长度(km) value = pTT_B.Length2; break; case 17: //电缆线路 沟道(km) value = pTT_B.Num6; break; case 18: //改造时间 value = pTT_A.BuildYear; break; case 19: //投资(万元) value = pTT_A.Amount; break; default: break; } if (j != 6 && j != 7 && j != 8 && j != 9) { obj.SetValue(i, j, value); } else { obj.Cells[i, j].Locked = false;//手写 } } index++; } list_A = Value_A[1]; list_B = Value_B[1]; list_C = Value_C[1]; list_D = Value_D[1]; for (int i = IntRow + Value_A[0].Count; i < Value_A[1].Count + Value_A[0].Count + IntRow; ++i)//县级 { pTT_A = (Ps_Table_TZGS)list_A[i - (IntRow + Value_A[0].Count)]; pTT_B = (Ps_Table_TZGS)list_B[i - (IntRow + Value_A[0].Count)]; pTT_C = (Ps_Table_TZGS)list_C[i - (IntRow + Value_A[0].Count)]; pTT_D = (Ps_Table_TZGS)list_D[i - (IntRow + Value_A[0].Count)]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 value = index; break; case 1: //电压等级(kV) value = pTT_C.BianInfo.Substring(0, pTT_C.BianInfo.IndexOf("@", 0, pTT_C.BianInfo.Length)); //电压等级// pTT.Title.Substring(0,pTT.Title.IndexOf("-",0,pTT.Title.Length)); break; case 2: //工程名称 value = pTT_A.Title; break; case 3: //供电区名称 value = pTT_A.AreaName + City; break; case 4: //供电区性质 value = "市辖区"; break; case 5: //工程描述 value = pTT_A.Col1; break; case 6: //高损配变 台数(台) break; case 7: //高损配变 容量(MVA) break; case 8: //无功补偿装置 组数(组) break; case 9: //无功补偿装置 容量(Mvar) break; case 10: //开关类 断路器(台) value = pTT_D.Num5; break; case 11: //开关类 负荷开关(台) 现在用柱上开关 value = pTT_D.Num3; break; case 12: //开关类 环网柜(座) value = pTT_D.Num2; break; case 13: //开关类 电缆分支箱(座) value = pTT_D.Num4; break; case 14: //架空线路 线路长度(km) value = pTT_B.Length; break; case 15: //架空线路 杆塔(基) value = pTT_B.Num2; break; case 16: //电缆线路 长度(km) value = pTT_B.Length2; break; case 17: //电缆线路 沟道(km) value = pTT_B.Num6; break; case 18: //改造时间 value = pTT_A.BuildYear; break; case 19: //投资(万元) value = pTT_A.Amount; break; default: break; } if (j != 6 && j != 7 && j != 8 && j != 9) { obj.SetValue(i, j, value); } else { obj.Cells[i, j].Locked = false;//手写 } } index++; } }
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="obj"></param> /// <param name="IntRow"></param> /// <param name="IntCol"></param> private void WriteData(FarPoint.Win.Spread.SheetView obj, int IntRow, int IntCol) { Ps_Table_TZGS pTT_A = null; Ps_Table_TZGS pTT_B = null; Ps_Table_TZGS pTT_C = null; Ps_Table_TZGS pTT_D = null; Object value = null; IList list_A = Value_A[0]; IList list_B = Value_B[0]; IList list_C = Value_C[0]; IList list_D = Value_D[0]; string City = "市区供电区"; string County = "县域供电区"; int intdex = 1; for (int i = IntRow; i < Value_A[0].Count + IntRow; ++i)//市辖 { pTT_A = (Ps_Table_TZGS)list_A[i - IntRow]; pTT_B = (Ps_Table_TZGS)list_B[i - IntRow]; pTT_C = (Ps_Table_TZGS)list_C[i - IntRow]; pTT_D = (Ps_Table_TZGS)list_D[i - IntRow]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 value = intdex; break; case 1: //工程名称 value = pTT_A.Title; // pTT.Title.Substring(0,pTT.Title.IndexOf("-",0,pTT.Title.Length)); break; case 2: //电压等级(kV) value = pTT_C.BianInfo.Substring(0, pTT_C.BianInfo.IndexOf("@", 0, pTT_C.BianInfo.Length)); //电压等级 break; case 3: //供电区名称 value = pTT_A.AreaName + City; break; case 4: //供电区性质 value = "市辖区"; break; case 5: //工程描述 value = pTT_A.Col1; break; case 6: //长度(km)架空 value = pTT_B.Length; break; case 7: //电缆长度(km) value = pTT_B.Length2; break; case 8: //中压开关 开闭站(座) value = pTT_D.Num1; break; case 9: //中压开关 环网柜(座) value = pTT_D.Num2; break; case 10: //中压开关 柱上开关(台) value = pTT_D.Num3; break; case 11: //中压开关 电缆分支箱(台) value = pTT_D.Num4; break; case 12: //中压配电 配电室(座) value = pTT_C.Num1; break; case 13: //中压配电 箱变(座) value = pTT_C.Num3; break; case 14: //中压配电 柱上变(台) value = pTT_C.Num5; break; case 15: //中压配电 无功补偿容量(Mvar) value = pTT_C.WGNum; break; case 16: //低压网配套 架空线路(km) value = pTT_B.Length; break; case 17: //低压网配套 电缆(km) value = pTT_B.Length2; break; case 18: //投资(万元) value = pTT_A.Amount; break; case 19: //投运时间(年) value = pTT_A.BuildYear; break; case 20: //工程属性 变电站配套送出 if (pTT_A.ProgType == "变电站配套送出") { value = "是"; } else { value = null; } break; case 21: //工程属性 配电网切改 if (pTT_A.ProgType == "配电网切改") { value = "是"; } else { value = null; } break; case 22: //工程属性 架空线入地 if (pTT_A.ProgType == "架空线入地") { value = "是"; } else { value = null; } break; case 23: //工程属性 新农村电气化 if (pTT_A.ProgType == "新农村电气化") { value = "是"; } else { value = null; } break; case 24: //工程属性 无电区供电 if (pTT_A.ProgType == "无电区供电") { value = "是"; } else { value = null; } break; case 25: //工程属性 其它 if (pTT_A.ProgType == "其他类别") { value = "是"; } else { value = null; } break; default: break; } obj.SetValue(i, j, value); } intdex++; } list_A = Value_A[1]; list_B = Value_B[1]; list_C = Value_C[1]; list_D = Value_D[1]; for (int i = IntRow + Value_A[0].Count; i < Value_A[1].Count + Value_A[0].Count + IntRow; ++i)//县级 { pTT_A = (Ps_Table_TZGS)list_A[i - (IntRow + Value_A[0].Count)]; pTT_B = (Ps_Table_TZGS)list_B[i - (IntRow + Value_A[0].Count)]; pTT_C = (Ps_Table_TZGS)list_C[i - (IntRow + Value_A[0].Count)]; pTT_D = (Ps_Table_TZGS)list_D[i - (IntRow + Value_A[0].Count)]; for (int j = 0; j < obj.ColumnCount; ++j) { switch (j) { case 0: //序号 value = intdex; break; case 1: //工程名称 value = pTT_A.Title; // pTT.Title.Substring(0,pTT.Title.IndexOf("-",0,pTT.Title.Length)); break; case 2: //电压等级(kV) value = pTT_C.BianInfo.Substring(0, pTT_C.BianInfo.IndexOf("@", 0, pTT_C.BianInfo.Length)); //电压等级 break; case 3: //供电区名称 value = pTT_A.AreaName + County; break; case 4: //供电区性质 value = pTT_A.DQ.Substring(2, (pTT_A.DQ.Length - 2)); break; case 5: //工程描述 value = pTT_A.Col1; break; case 6: //长度(km)架空 value = pTT_B.Length; break; case 7: //电缆长度(km) value = pTT_B.Length2; break; case 8: //中压开关 开闭站(座) value = pTT_D.Num1; break; case 9: //中压开关 环网柜(座) value = pTT_D.Num2; break; case 10: //中压开关 柱上开关(台) value = pTT_D.Num3; break; case 11: //中压开关 电缆分支箱(台) value = pTT_D.Num4; break; case 12: //中压配电 配电室(座) value = pTT_C.Num1; break; case 13: //中压配电 箱变(座) value = pTT_C.Num3; break; case 14: //中压配电 柱上变(台) value = pTT_C.Num5; break; case 15: //中压配电 无功补偿容量(Mvar) value = pTT_C.WGNum; break; case 16: //低压网配套 架空线路(km) value = pTT_B.Length; break; case 17: //低压网配套 电缆(km) value = pTT_B.Length2; break; case 18: //投资(万元) value = pTT_A.Amount; break; case 19: //投运时间(年) value = pTT_A.BuildYear; break; case 20: //工程属性 变电站配套送出 if (pTT_A.ProgType == "变电站配套送出") { value = "是"; } else { value = null; } break; case 21: //工程属性 配电网切改 if (pTT_A.ProgType == "配电网切改") { value = "是"; } else { value = null; } break; case 22: //工程属性 架空线入地 if (pTT_A.ProgType == "架空线入地") { value = "是"; } else { value = null; } break; case 23: //工程属性 新农村电气化 if (pTT_A.ProgType == "新农村电气化") { value = "是"; } else { value = null; } break; case 24: //工程属性 无电区供电 if (pTT_A.ProgType == "无电区供电") { value = "是"; } else { value = null; } break; case 25: //工程属性 其它 if (pTT_A.ProgType == "其他类别") { value = "是"; } else { value = null; } break; default: break; } obj.SetValue(i, j, value); } intdex++; } }
/// <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; }
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 { } } }