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 { }
}
}
