private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (devicenum > gridView1.RowCount || devicenum == 0)
{
Ps_Table_TZMX px = new Ps_Table_TZMX();
FormTZGSXXdialog fd = new FormTZGSXXdialog();
fd.type = type;
fd.volt = volt;
fd.buildyear = Convert.ToInt32(buildyear);
fd.buildend = Convert.ToInt32(buildend);
fd.tzmx = px;
fd.ShowDialog();
if (fd.DialogResult == DialogResult.OK)
{
Ps_Table_TZMX pt = fd.tzmx;
pt.ProjectID = pid;
pt.Typeqf = type;
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
Services.BaseService.Create <Ps_Table_TZMX>(pt);
}
initdata();
}
else
{
MessageBox.Show("变电站的数目已经达到!");
return;
}
}
private void simpleButton5_Click(object sender, EventArgs e)
{
FormTzgsWH2pwXX fxx = new FormTzgsWH2pwXX();
fxx.type = "pw-kg";
fxx.pid = tzgspwid;
fxx.buildyear = StartYear;
fxx.buildend = FinishYear;
if (fxx.ShowDialog() == DialogResult.OK)
{
IList list1 = fxx.ObjectList;
foreach (Ps_Table_TZMX pt in list1)
{
Ps_Table_TZMX pm = Services.BaseService.GetOneByKey <Ps_Table_TZMX>(pt);
if (pm != null)
{
Services.BaseService.Update <Ps_Table_TZMX>(pt);
}
else
{
Services.BaseService.Create <Ps_Table_TZMX>(pt);
}
}
}
}
/// <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"));
}
/// <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 initdata()
{
gridView1.Columns.Clear();
string con = "ProjectID='" + pid + "'and Typeqf='" + type + "'";
IList listTypes = Common.Services.BaseService.GetList("SelectPs_Table_TZMXByValue", con);
DevExpress.XtraGrid.Columns.GridColumn column = new DevExpress.XtraGrid.Columns.GridColumn();
column = new DevExpress.XtraGrid.Columns.GridColumn();
column.FieldName = "Title";
column.Caption = "名称";
column.VisibleIndex = 0;
column.Width = 180;
column.OptionsColumn.AllowEdit = false;
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
column
});
if (type == "pw-line")
{
if (listTypes.Count == 0)
{
Ps_Table_TZMX pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "架空线路";
pt.Typeqf = "pw-line";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "电缆线路";
pt.Typeqf = "pw-line";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
}
//column = new DevExpress.XtraGrid.Columns.GridColumn();
//column.FieldName = "Vol";
//column.Caption = "静态投资"+buildend.ToString()+"年";
//column.VisibleIndex = 1;
//column.Width = 180;
//column.OptionsColumn.AllowEdit = false;
// this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
//column});
}
else if (type == "pw-pb")
{
if (listTypes.Count == 0)
{
Ps_Table_TZMX pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "配电室";
pt.Typeqf = "pw-pb";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "箱式变电站";
pt.Typeqf = "pw-pb";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "柱上配电变压器";
pt.Typeqf = "pw-pb";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
}
}
else if (type == "pw-kg")
{
if (listTypes.Count == 0)
{
Ps_Table_TZMX pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "开闭所";
pt.Typeqf = "pw-kg";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "环网柜";
pt.Typeqf = "pw-kg";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "柱上开关";
pt.Typeqf = "pw-kg";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
pt = new Ps_Table_TZMX();
pt.ProjectID = pid;
pt.Title = "电缆分支箱";
pt.Typeqf = "pw-kg";
pt.BuildYear = buildyear;
pt.BuildEnd = buildend;
listTypes.Add(pt);
Services.BaseService.Create <Ps_Table_TZMX>(pt);
}
}
int firyear = Convert.ToInt32(buildyear);
int endyear = Convert.ToInt32(buildend);
for (int i = firyear; i <= endyear; i++)
{
AddColumn(i);
}
column = new DevExpress.XtraGrid.Columns.GridColumn();
column.FieldName = "LendRate";
column.Caption = "建设期贷款利息";
column.VisibleIndex = 2 + endyear - firyear + 1;
column.Width = 180;
//column.OptionsColumn.AllowEdit = false;
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
column
});
column = new DevExpress.XtraGrid.Columns.GridColumn();
column.FieldName = "PrepChange";
column.Caption = "预备费用";
column.VisibleIndex = 3 + endyear - firyear + 1;
column.Width = 180;
//column.OptionsColumn.AllowEdit = false;
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
column
});
column = new DevExpress.XtraGrid.Columns.GridColumn();
column.FieldName = "DynInvest";
column.Caption = "动态投资";
column.VisibleIndex = 4 + endyear - firyear + 1;
column.Width = 180;
//column.OptionsColumn.AllowEdit = false;
this.gridView1.Columns.AddRange(new DevExpress.XtraGrid.Columns.GridColumn[] {
column
});
this.gridControl1.DataSource = listTypes;
}
