/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
PSP_VolumeBalance obj = FocusedObject;
if (obj == null)
{
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <PSP_VolumeBalance>(obj);
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return;
}
this.gridView.BeginUpdate();
//记住当前焦点行索引
int iOldHandle = this.gridView.FocusedRowHandle;
//从链表中删除
ObjectList.Remove(obj);
//刷新表格
gridControl.RefreshDataSource();
//设置新的焦点行索引
GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle);
this.gridView.EndUpdate();
if (ObjectList.Count == 0 || EnsureBaseYear() == obj.Year)
{
PSP_VolumeBalanceDataSource BaseYearrate = new PSP_VolumeBalanceDataSource();
BaseYearrate.UID = baseyeartype;
BaseYearrate.Value = 1990;
BaseYearrate.TypeID = Convert.ToInt32(obj.TypeID);
BaseYearrate.Flag = flag;
Services.BaseService.Update("UpdatePSP_VolumeBalanceDataSource2", BaseYearrate);
}
}
/// <summary>
/// 删除焦点对象
/// </summary>
///
#region 添加负荷行
private void AddFuHe(PSP_VolumeBalance obj)
{
PSP_VolumeBalance pvc = new PSP_VolumeBalance();
pvc.TypeID = type;
pvc.Flag = flag;
pvc.Year = EnsureBaseYear();
IList <PSP_VolumeBalance> list = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAndYear", pvc);
if (list != null)
{
if (list.Count == 1)
{
PSP_VolumeBalance_Calc pvc2 = new PSP_VolumeBalance_Calc();
pvc2.Type = "1";
pvc2.Flag = list[0].UID;
IList <PSP_VolumeBalance_Calc> list2 = Services.BaseService.GetList <PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc2);
PSP_VolumeBalance_Calc pvc3 = new PSP_VolumeBalance_Calc();
pvc3.Type = "1";
pvc3.Flag = obj.UID;
IList <PSP_VolumeBalance_Calc> list3 = Services.BaseService.GetList <PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc3);
if (list2 != null)
{
if (list2.Count > 0)
{
foreach (PSP_VolumeBalance_Calc pvctemp in list2)
{
if (list3 != null)
{
if (list3.Count == list2.Count)
{
break;
}
}
PSP_VolumeBalance_Calc _obj = new PSP_VolumeBalance_Calc();
_obj = pvctemp;
_obj.Flag = obj.UID;
_obj.Vol = 0;
_obj.UID = Guid.NewGuid().ToString();
Services.BaseService.Create <PSP_VolumeBalance_Calc>(_obj);
}
}
}
}
}
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + gridView1.GetDataRow(gridView1.FocusedRowHandle)["ListName"])
== DialogResult.No)
{
return;
}
PowerEachList report = Itop.Common.DataConverter.RowToObject <PowerEachList>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
try
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.Flag = report.UID;
if (typeFlag.Contains("110"))
{
ob.TypeID = "110";
}
else if (typeFlag.Contains("220"))
{
ob.TypeID = "220";
}
IList <PSP_VolumeBalance> list = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
foreach (PSP_VolumeBalance listtemp in list)
{
Services.BaseService.Update("DeletePSP_VolumeBalance2", listtemp);
}
Common.Services.BaseService.Update("DeletePowerEachList_VolumeBalance", report);
gridView1.DeleteRow(gridView1.FocusedRowHandle);
}
catch (Exception ex)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData()
{
try
{
int iOldHandle = this.gridView.FocusedRowHandle;
PSP_VolumeBalance vol = new PSP_VolumeBalance();
vol.TypeID = type;
vol.Flag = flag;
IList <PSP_VolumeBalance> list = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", vol);
this.gridControl.DataSource = list;
if (list != null)
{
if (list.Count > 0)
{
baseyear = list[0].Year;
}
}
try
{
if (Volumecalc == "")
{
Volumecalc = "0";
}
//Volumecalc = System.Configuration.ConfigurationSettings.AppSettings["Volumecalc"];
colL8.Caption = "需" + type + "kV变电容量(容载比" + Volumecalc + ")";
GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle);
if (type == "35")
{
colL5.Caption = "需" + type + "千伏变电电力(负荷同时率" + loadrate + ")";
}
}
catch { }
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
/// <summary>
/// 删除后保存合计
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool deleSaveSum(IList <PSP_VolumeBalance_Calc> ObjectList1, string flag)
{
try
{
double s = 0.0;
sum = 0;
foreach (PSP_VolumeBalance_Calc pvc in ObjectList1)
{
sum += pvc.Vol;
}
PSP_VolumeBalance pv = Services.BaseService.GetOneByKey <PSP_VolumeBalance>(flag);
if (flag == "")
{
return(false);
}
switch (type)
{
case "1":
pv.L2 = sum;
break;
case "2":
pv.L10 = sum;
break;
case "3":
pv.L11 = sum;
break;
}
Services.BaseService.Update <PSP_VolumeBalance>(pv);
}
catch (Exception exc)
{
//Debug.Fail(exc.Message);
//HandleException.TryCatch(exc);
return(false);
}
return(true);
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
PSP_VolumeBalance_Calc obj = new PSP_VolumeBalance_Calc();
obj.Flag = flag;
obj.Type = type;
obj.Col1 = dy;
obj.CreateTime = DateTime.Now;
//执行添加操作
using (FrmPSP_VolumeBalance_CalcDialog dlg = new FrmPSP_VolumeBalance_CalcDialog())
{
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
dlg.Type = type;
dlg.CtrTitle = ctrtitle;
dlg.FormTitle = FormTitle;
if (type == "1" && dy == "220")
{
dlg.editorRow2.Visible = true;
}
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
SaveSum();
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
if (obj.Type == "1")
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
//ob.TypeID = dy;
ob.UID = obj.Flag;
//string s ="";
IList <PSP_VolumeBalance> list = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByKey", ob);
if (list != null)
{
if (list.Count == 1)
{
ob.Flag = list[0].Flag;
ob.TypeID = list[0].TypeID;
//s = obj.Flag;
list.Clear();
list = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
foreach (PSP_VolumeBalance pvm in list)
{
if (pvm.UID == ob.UID)
{
continue;
}
PSP_VolumeBalance_Calc pvc = new PSP_VolumeBalance_Calc();
pvc = obj;
pvc.Flag = pvm.UID;
pvc.UID = Guid.NewGuid().ToString();
pvc.Vol = 0;
pvc.Col2 = "";
Services.BaseService.Create <PSP_VolumeBalance_Calc>(pvc);
}
}
}
RefreshData();
}
}
/// <summary>
/// ��Ӷ���
/// </summary>
public void AddObject()
{
//�����������Ƿ��Ѿ�����
if (ObjectList == null)
{
return;
}
//�½�����
PSP_VolumeBalance_Calc obj = new PSP_VolumeBalance_Calc();
obj.Flag = flag;
obj.Type = type;
obj.Col1 = dy;
obj.CreateTime = DateTime.Now;
//ִ����Ӳ���
using (FrmPSP_VolumeBalance_CalcDialog dlg = new FrmPSP_VolumeBalance_CalcDialog())
{
dlg.IsCreate = true; //�����½���־
dlg.Object = obj;
dlg.Type = type;
dlg.CtrTitle = ctrtitle;
dlg.FormTitle = FormTitle;
if (type == "1" && dy=="220")
dlg.editorRow2.Visible = true;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//���¶�����뵽������
ObjectList.Add(obj);
SaveSum();
//ˢ�±���������ж�λ���¶����ϡ�
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
if (obj.Type == "1")
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
//ob.TypeID = dy;
ob.UID = obj.Flag;
//string s ="";
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByKey", ob);
if(list!=null)
if (list.Count == 1)
{
ob.Flag = list[0].Flag;
ob.TypeID = list[0].TypeID;
//s = obj.Flag;
list.Clear();
list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
foreach (PSP_VolumeBalance pvm in list)
{
if (pvm.UID == ob.UID)
continue;
PSP_VolumeBalance_Calc pvc = new PSP_VolumeBalance_Calc();
pvc = obj;
pvc.Flag = pvm.UID;
pvc.UID = Guid.NewGuid().ToString();
pvc.Vol = 0;
pvc.Col2 = "";
Services.BaseService.Create<PSP_VolumeBalance_Calc>(pvc);
}
}
RefreshData();
}
}
private void barA5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FrmBalance_Calc FrmBalance = new FrmBalance_Calc();
FrmBalance.FormTitle = "规划新增变电容量";
FrmBalance.CtrTitle = this.ctrlPSP_VolumeBalance1.GridView.GroupPanelText;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
PSP_VolumeBalance vol = new PSP_VolumeBalance();
if (this.ctrlPSP_VolumeBalance1.GridView.GetRow(this.ctrlPSP_VolumeBalance1.GridView.FocusedRowHandle) != null)
{
vol = this.ctrlPSP_VolumeBalance1.GridView.GetRow(this.ctrlPSP_VolumeBalance1.GridView.FocusedRowHandle) as PSP_VolumeBalance;
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "3";
FrmBalance.DY = TypeID;
if (FrmBalance.FLAG != "")
{
FrmBalance.ShowDialog();
this.ctrlPSP_VolumeBalance1.RefreshData();
vol.GetType().GetProperty("L11").SetValue(vol, FrmBalance.SUM, null);
this.ctrlPSP_VolumeBalance1.reloadsum(vol);
}
}
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
PSP_VolumeBalance vol = new PSP_VolumeBalance();
vol.TypeID = TypeID;
vol.Flag = Flag;
IList<PSP_VolumeBalance> listTypes = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", vol);
FormChooseYears frm = new FormChooseYears();
foreach (PSP_VolumeBalance year in listTypes)
frm.ListYearsForChoose.Add(year.Year);
frm.NoIncreaseRate = true;
if (frm.ShowDialog() == DialogResult.OK)
{
int k = 0;
PSP_VolumeBalance vb = new PSP_VolumeBalance();
vb.TypeID = TypeID;
vb.Flag = Flag;
IList<PSP_VolumeBalance> pspvb = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", vb);
string str = "";
PSP_VolumeBalance_Calc vbc = new PSP_VolumeBalance_Calc();
try
{
vbc.Flag = pspvb[0].UID;
}
catch { }
vbc.Type = "1";
IList<PSP_VolumeBalance_Calc> vbclist = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbc);
DataTable dt = new DataTable();
//dt.Columns.Add("Sort", typeof(int));
dt.Columns.Add("序号", typeof(int));
dt.Columns.Add("项目", typeof(string));
int isort = 0;
if (TypeID == "220")
{
foreach (GridColumn i in ctrlPSP_VolumeBalance1.GridView.Columns)
{
if (i.Caption != "年度" && i.Caption != "小电厂需备用容量" && i.Caption != "外网供电" && i.FieldName != "S2" && i.FieldName != "S3")
{
if (i.FieldName == "S4")
i.Caption = "注：";
if (isort == 2)
{
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = pspvbc.Title;
dt.Rows.Add(drow);
DataRow drow1 = dt.NewRow();
drow1["项目"] = "注：";
dt.Rows.Add(drow1);
}
isort++;
k = isort + vbclist.Count;
}
else if (isort == 10)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = "注：";
dt.Rows.Add(drow);
isort++;
}
else if (isort == 12)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = "注：";
dt.Rows.Add(drow);
isort++;
}
DataRow dr = dt.NewRow();
//dr["序号"] = isort + 1;
dr["项目"] = i.Caption;
//dr["Sort"] = isort + 1;
dt.Rows.Add(dr);
isort++;
}
}
}
if (TypeID == "35")
{
foreach (GridColumn i in ctrlPSP_VolumeBalance1.GridView.Columns)
{
if (i.Caption != "年度" && i.Caption != "小电厂需备用容量" && i.Caption != "110kV及以下小电源直接供电负荷" && i.FieldName != "S3")
{
if(i.FieldName== "S2"|| i.FieldName == "S4")
i.Caption = "注：";
if (isort == 10)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = "注：";
dt.Rows.Add(drow);
isort++;
}
else if (isort == 12)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = "注：";
dt.Rows.Add(drow);
isort++;
}
DataRow dr = dt.NewRow();
//dr["序号"] = isort + 1;
dr["项目"] = i.Caption;
if (dr["项目"]!=null)
if (dr["项目"].ToString().Contains("(负荷同时率" + Ensureloadrate() + ")"))
dr["项目"]=dr["项目"].ToString().Replace("(负荷同时率" + Ensureloadrate() + ")", "");
//dr["Sort"] = isort + 1;
dt.Rows.Add(dr);
isort++;
}
}
}
if (TypeID == "110")
{
foreach (GridColumn i in ctrlPSP_VolumeBalance1.GridView.Columns)
{
if (i.Caption != "年度" && i.Caption != "小电厂需备用容量" )
{
if (i.FieldName == "S2" || i.FieldName == "S4" || i.FieldName == "S3")
i.Caption = "注：";
if (isort == 12)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = "注：";
dt.Rows.Add(drow);
isort++;
}
else if (isort == 14)
{
DataRow drow = dt.NewRow();
//drow["序号"] = isort + 1;
drow["项目"] = "注：";
dt.Rows.Add(drow);
isort++;
}
DataRow dr = dt.NewRow();
//dr["序号"] = isort + 1;
dr["项目"] = i.Caption;
//dr["Sort"] = isort + 1;
dt.Rows.Add(dr);
isort++;
}
}
}
isort = 1;
foreach (System.Data.DataRow row in dt.Rows)
{
row["序号"] = isort;
isort++;
}
foreach (ChoosedYears i in frm.ListChoosedYears)
{
dt.Columns.Add(i.Year + "年", typeof(string));
}
//if (TypeID == "220")
//{
// dt.Rows.RemoveAt(vbclist.Count + 14);
//}
foreach (ChoosedYears i in frm.ListChoosedYears)
{
foreach (PSP_VolumeBalance balan in pspvb)
{
if (balan.Year == i.Year)
{
int j = 0;
dt.Rows[0][i.Year + "年"] = balan.L1;
dt.Rows[1][i.Year + "年"] = balan.L2;
PSP_VolumeBalance_Calc vbcalc = new PSP_VolumeBalance_Calc();
vbcalc.Flag = balan.UID;
vbcalc.Type = "1";
IList<PSP_VolumeBalance_Calc> vbclist1 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
if (TypeID == "220")
{
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist1)
{
dt.Rows[j+2][i.Year + "年"] = pspvbc.Vol.ToString();
j++;
dt.Rows[j + 2][i.Year + "年"] = pspvbc.Col2.ToString();
j++;
}
dt.Rows[j + 2][i.Year + "年"] = balan.L5;
dt.Rows[j + 3][i.Year + "年"] = balan.S4;
dt.Rows[j + 4][i.Year + "年"] = balan.L6;
dt.Rows[j + 5][i.Year + "年"] = balan.L7;
dt.Rows[j + 6][i.Year + "年"] = balan.L8;
dt.Rows[j + 7][i.Year + "年"] = balan.L9;
dt.Rows[j + 8][i.Year + "年"] = balan.L10;
str = "";
vbcalc.Type = "2";
IList<PSP_VolumeBalance_Calc> vbclist2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist2)
{
if (pspvbc.LX1 == "新建")
str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2;
else
str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2;
if (pspvbc.UID != vbclist2[vbclist2.Count - 1].UID)
str += ",";
}
dt.Rows[j + 9][i.Year + "年"] = str;
dt.Rows[j + 10][i.Year + "年"] = balan.L11;
str = "";
vbcalc.Type = "3";
IList<PSP_VolumeBalance_Calc> vbclist3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist3)
{
if (pspvbc.LX1 == "新建")
str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2;
else
str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2;
if (pspvbc.UID != vbclist3[vbclist3.Count - 1].UID)
str += ",";
}
dt.Rows[j + 11][i.Year + "年"] = str;
dt.Rows[j + 12][i.Year + "年"] = balan.L12;
dt.Rows[j + 13][i.Year + "年"] = balan.L13;
dt.Rows[j + 14][i.Year + "年"] = balan.L14;
}
else if (TypeID == "110")
{
//foreach (PSP_VolumeBalance_Calc pspvbc in vbclist1)
//{
// str = "(" + pspvbc.Title + "," + pspvbc.LX1 + "," + pspvbc.LX2 + ") " + str;
//}
dt.Rows[2][i.Year + "年"] = balan.S2;
dt.Rows[j + 3][i.Year + "年"] = balan.L4;
dt.Rows[j + 4][i.Year + "年"] = balan.S3;
dt.Rows[j + 5][i.Year + "年"] = balan.L5;
dt.Rows[j + 6][i.Year + "年"] = balan.S4;
dt.Rows[j + 7][i.Year + "年"] = balan.L6;
dt.Rows[j + 8][i.Year + "年"] = balan.L7;
dt.Rows[j + 9][i.Year + "年"] = balan.L8;
dt.Rows[j + 10][i.Year + "年"] = balan.L9;
dt.Rows[j + 11][i.Year + "年"] = balan.L10;
str = "";
vbcalc.Type = "2";
IList<PSP_VolumeBalance_Calc> vbclist2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist2)
{
if (pspvbc.LX1 == "新建")
str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2;
else
str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2;
if (pspvbc.UID != vbclist2[vbclist2.Count - 1].UID)
str += ",";
}
dt.Rows[j + 12][i.Year + "年"] = str;
dt.Rows[j + 13][i.Year + "年"] = balan.L11;
str = "";
vbcalc.Type = "3";
IList<PSP_VolumeBalance_Calc> vbclist3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist3)
{
if (pspvbc.LX1 == "新建")
str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2;
else
str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2;
if (pspvbc.UID != vbclist3[vbclist3.Count - 1].UID)
str += ",";
}
dt.Rows[j + 14][i.Year + "年"] = str;
dt.Rows[j + 15][i.Year + "年"] = balan.L12;
dt.Rows[j + 16][i.Year + "年"] = balan.L13;
dt.Rows[j + 17][i.Year + "年"] = balan.L14;
}
else if (TypeID == "35")
{
dt.Rows[j+2][i.Year + "年"] = balan.S2;
dt.Rows[j + 3][i.Year + "年"] = balan.L5;
dt.Rows[j + 4][i.Year + "年"] = balan.S4;
dt.Rows[j + 5][i.Year + "年"] = balan.L6;
dt.Rows[j + 6][i.Year + "年"] = balan.L7;
dt.Rows[j + 7][i.Year + "年"] = balan.L8;
dt.Rows[j + 8][i.Year + "年"] = balan.L9;
dt.Rows[j + 9][i.Year + "年"] = balan.L10;
//dt.Rows[j + 8][i.Year + "年"] = balan.L10;
str = "";
vbcalc.Type = "2";
IList<PSP_VolumeBalance_Calc> vbclist2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist2)
{
if (pspvbc.LX1 == "新建")
str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2;
else
str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2;
if (pspvbc.UID != vbclist2[vbclist2.Count - 1].UID)
str += ",";
}
dt.Rows[j + 10][i.Year + "年"] = str;
dt.Rows[j + 11][i.Year + "年"] = balan.L11;
str = "";
vbcalc.Type = "3";
IList<PSP_VolumeBalance_Calc> vbclist3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", vbcalc);
foreach (PSP_VolumeBalance_Calc pspvbc in vbclist3)
{
if (pspvbc.LX1 == "新建")
str += pspvbc.LX1 + "" + pspvbc.Title + "" + pspvbc.LX2;
else
str += pspvbc.Title + "" + pspvbc.LX1 + "" + pspvbc.LX2;
if (pspvbc.UID != vbclist3[vbclist3.Count - 1].UID)
str += ",";
}
dt.Rows[j + 12][i.Year + "年"] = str;
dt.Rows[j + 13][i.Year + "年"] = balan.L12;
dt.Rows[j + 14][i.Year + "年"] = balan.L13;
}
}
}
}
FormPSP_VolumeBalance_Print fr = new FormPSP_VolumeBalance_Print();
fr.GridDataTable = dt;
//if (TypeID == "220")
//{
fr.Text = this.Text;
fr.gridView1.GroupPanelText = this.Text;
fr.PRintRight = PrintRight;
//}
fr.ShowDialog();
}
}
public void reloadsum(PSP_VolumeBalance objtemp)
{
double factor = 1;
if (type == "35")
{
if (loadrate != "")
{
factor = Convert.ToDouble(loadrate);
}
}
if (objtemp.S1 == "1")
{
objtemp.L5 = Math.Round(objtemp.L1 + objtemp.L3 - objtemp.L2 - objtemp.L4, 2);
if (objtemp.L5 != 0)
{
objtemp.L7 = Math.Round(objtemp.L6 / (objtemp.L5 * factor), 2);
}
else
{
objtemp.L7 = 0;
}
objtemp.L8 = Math.Round((objtemp.L5 * factor) * Convert.ToDouble(Volumecalc), 2);
objtemp.L9 = Math.Round(objtemp.L6 - objtemp.L8, 2);
objtemp.L12 = Math.Round(objtemp.L6 + objtemp.L10 + objtemp.L11, 2);
if (objtemp.L5 != 0)
{
objtemp.L13 = Math.Round(objtemp.L12 / (objtemp.L5 * factor), 2);
}
else
{
objtemp.L13 = 0;
}
Services.BaseService.Update("UpdatePSP_VolumeBalance2", objtemp);
if (EnsureBaseYear() <= objtemp.Year)
{
sum(objtemp);
}
}
else
{
PSP_VolumeBalance volumtemp = new PSP_VolumeBalance();
volumtemp.TypeID = type;
volumtemp.Flag = flag;
volumtemp.Year = objtemp.Year;
IList <PSP_VolumeBalance> list = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDLessYear", volumtemp);
if (list.Count > 0)
{
objtemp.L6 = Math.Round(list[list.Count - 1].L12, 2);
}
else
{
objtemp.L6 = 0;
}
objtemp.L5 = Math.Round(objtemp.L1 + objtemp.L3 - objtemp.L2 - objtemp.L4, 2);
if (objtemp.L5 != 0)
{
objtemp.L7 = Math.Round(objtemp.L6 / (objtemp.L5 * factor), 2);
}
else
{
objtemp.L7 = 0;
}
objtemp.L8 = Math.Round((objtemp.L5 * factor) * Convert.ToDouble(Volumecalc), 2);
objtemp.L9 = Math.Round(objtemp.L6 - objtemp.L8, 2);
objtemp.L12 = Math.Round(objtemp.L6 + objtemp.L10 + objtemp.L11, 2);
if (objtemp.L5 != 0)
{
objtemp.L13 = Math.Round(objtemp.L12 / (objtemp.L5 * factor), 2);
}
else
{
objtemp.L13 = 0;
}
Services.BaseService.Update("UpdatePSP_VolumeBalance2", objtemp);
if (EnsureBaseYear() <= objtemp.Year)
{
sum(objtemp);
}
}
RefreshData();
}
private void barA2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//DevExpress.XtraBars.BarItem bot = (DevExpress.XtraBars.BarItem)sender;
FormPSP_VolumeBalanceVolumecalc frm = new FormPSP_VolumeBalanceVolumecalc();
frm.Type = TypeID;
//if (bot.Caption == "设定容载比")
//{
frm.Text = "设定容载比";
frm.CtrTitle = "容载比";
frm.YearValue = EnsureVolumecalc();
frm.UID = Volumecalc;
//}
//else
// if (bot.Caption== "设定负荷同时率")
// {
// frm.Text = "设定负荷同时率";
// frm.CtrTitle = "负荷同时率";
// frm.YearValue =Ensureloadrate();
// frm.UID = loadrate;
// }
frm.Flag = Flag;
if (frm.ShowDialog() == DialogResult.OK)
{
this.ctrlPSP_VolumeBalance1.Volumecalc0 = EnsureVolumecalc().ToString();
this.ctrlPSP_VolumeBalance1.colL8.Caption = "需" + TypeID + "kV变电容量(容载比" + EnsureVolumecalc() + ")";
//if(TypeID=="35")
// this.ctrlPSP_VolumeBalance1.colL5.Caption = "需" + TypeID + "千伏变电电力(负荷同时率" + Ensureloadrate() + ")";
PSP_VolumeBalance vol = new PSP_VolumeBalance();
vol.Year = this.ctrlPSP_VolumeBalance1.EnsureBaseYear();
vol.Flag = Flag;
vol.TypeID = TypeID;
if (vol.Year > 1900)
{
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDLessYear", vol);
if (list != null)
{
foreach (PSP_VolumeBalance pvo in list)
{
this.ctrlPSP_VolumeBalance1.reloadsum(pvo);
}
}
if (list != null) list.Clear();
list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAndYear", vol);
if (list != null)
{
if (list.Count == 1)
this.ctrlPSP_VolumeBalance1.reloadsum(list[0]);
}
}
else
{
PSP_VolumeBalance voltemp = new PSP_VolumeBalance();
voltemp.Flag = Flag;
voltemp.TypeID = TypeID;
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", voltemp);
foreach(PSP_VolumeBalance pvo in list)
{
this.ctrlPSP_VolumeBalance1.reloadsum(pvo);
}
}
}
}
protected bool SaveRecord()
{
//����/�� ����
try
{
if (IsCreate)
{
Services.BaseService.Create<PSP_VolumeBalance>(_obj);
}
else
{
Services.BaseService.Update<PSP_VolumeBalance>(_obj);
}
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return false ;
}
if (_obj.S1 == "1")
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.Year = EnsureBaseYear();
ob.TypeID = type;
ob.Flag = flag;
IList<PSP_VolumeBalance> list0 = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAndYear", ob);
if (list0 != null)
{
if (list0.Count == 1)
{
list0[0].S1 = "0";
Services.BaseService.Update<PSP_VolumeBalance>(list0[0]);
}
}
PSP_VolumeBalanceDataSource BaseYearrate = new PSP_VolumeBalanceDataSource();
BaseYearrate.UID = baseyeartype;
BaseYearrate.Flag = flag;
BaseYearrate.Value = _obj.Year;
BaseYearrate.TypeID = Convert.ToInt32(_obj.TypeID);
Services.BaseService.Update("UpdatePSP_VolumeBalanceDataSource2", BaseYearrate);
}
else if (_obj.Year == EnsureBaseYear() /*|| (EnsureBaseYear() == baseyear)*/)
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.Flag = flag;
ob.TypeID = type;
IList<PSP_VolumeBalance> list0 = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
if (list0 != null)
if (list0.Count > 0)
ob = list0[0];
PSP_VolumeBalanceDataSource BaseYearrate = new PSP_VolumeBalanceDataSource();
BaseYearrate.Flag = flag;
BaseYearrate.UID = baseyeartype;
BaseYearrate.Value = baseyear;
BaseYearrate.TypeID = Convert.ToInt32(_obj.TypeID);
Services.BaseService.Update("UpdatePSP_VolumeBalanceDataSource2", BaseYearrate);
PSP_VolumeBalanceDataSource volumtemp = new PSP_VolumeBalanceDataSource();
volumtemp.TypeID = Convert.ToInt32(type);
volumtemp.Flag = flag;
IList<PSP_VolumeBalanceDataSource> list = Services.BaseService.GetList<PSP_VolumeBalanceDataSource>("SelectPSP_VolumeBalanceDataSourceByTypeID", volumtemp);
if (ob != null)
if (ob.UID != "")
foreach (PSP_VolumeBalanceDataSource psptemp in list)
{
if (psptemp.UID == baseyeartype)
continue;
if (hs[psptemp.Name] != null)
ob.GetType().GetProperty("L" + hs[psptemp.Name].ToString()).SetValue(ob, psptemp.Value, null);
}
try
{
ob.S1 = "1";
Services.BaseService.Update<PSP_VolumeBalance>(ob);
isresum = true;
}
catch (Exception ex)
{
System.Console.WriteLine(ex.ToString());
}
}
//�����ѳɹ�
return true;
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
PSP_VolumeBalance obj = new PSP_VolumeBalance();
obj.TypeID = type;
obj.Flag = flag;
//执行添加操作
using (FrmPSP_VolumeBalanceDialog dlg = new FrmPSP_VolumeBalanceDialog())
{
dlg.Type = type;
dlg.Flag = flag;
dlg.List = gridView.DataSource as IList <PSP_VolumeBalance>;
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (ObjectList.Count > 0)
{
baseyear = ObjectList[0].Year;
}
dlg.BaseYear = baseyear;
if (type == "220")
{
dlg.xtraTabControl1.TabPages[0].Text = "220千伏变电容量平衡表";
dlg.Text = "220千伏变电容量平衡表";
dlg.rowL1.Properties.Caption = "综合最高负荷";
dlg.rowL2.Properties.Caption = "直接供电负荷";
dlg.rowL2.Visible = false;
dlg.rowL4.Properties.Caption = "外网供电";
//dlg.rowL3.Visible = false;
// dlg.rowL4.Visible = true;
dlg.rowL6.Properties.Caption = "现有220kV降压变电容量";
dlg.categoryRow1.Visible = false;
dlg.categoryRow2.Visible = false;
dlg.categoryRow3.Properties.Caption = "需220kV降压供电负荷";
//dlg.rowL14.Visible = false;
}
else
if (type == "35")
{
dlg.xtraTabControl1.TabPages[0].Text = "35千伏变电容量平衡表";
dlg.Text = "35千伏变电容量平衡表";
dlg.rowL1.Properties.Caption = "本区负荷";
dlg.rowL2.Properties.Caption = "本地平衡负荷";
//dlg.rowL2.Visible = false;
//dlg.rowL4.Properties.Caption = "外网供电";
//dlg.rowL3.Visible = false;
dlg.rowL4.Visible = false;
dlg.rowL6.Properties.Caption = "现有35千伏变电容量";
//dlg.rowL14.Visible = false;
}
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
reloadsum(obj);
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
AddFuHe(obj);
}
public void reloadsum(PSP_VolumeBalance objtemp)
{
double factor = 1;
if (type == "35")
if (loadrate != "")
factor = Convert.ToDouble(loadrate);
if (objtemp.S1 == "1")
{
objtemp.L5 =Math.Round(objtemp.L1 + objtemp.L3 - objtemp.L2 - objtemp.L4,2);
if (objtemp.L5 != 0)
objtemp.L7 = Math.Round(objtemp.L6 /(objtemp.L5*factor),2);
else
objtemp.L7 = 0;
objtemp.L8 = Math.Round((objtemp.L5 * factor) * Convert.ToDouble(Volumecalc), 2);
objtemp.L9 = Math.Round(objtemp.L6 - objtemp.L8,2);
objtemp.L12 = Math.Round(objtemp.L6 + objtemp.L10 + objtemp.L11,2);
if (objtemp.L5 != 0)
objtemp.L13 = Math.Round(objtemp.L12 / (objtemp.L5 * factor), 2);
else
objtemp.L13 = 0;
Services.BaseService.Update("UpdatePSP_VolumeBalance2", objtemp);
if (EnsureBaseYear() <=objtemp.Year)
sum(objtemp);
}
else
{
PSP_VolumeBalance volumtemp = new PSP_VolumeBalance();
volumtemp.TypeID = type;
volumtemp.Flag = flag;
volumtemp.Year = objtemp.Year;
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDLessYear", volumtemp);
if (list.Count > 0)
{
objtemp.L6 = Math.Round(list[list.Count - 1].L12,2);
}
else
objtemp.L6 = 0;
objtemp.L5 = Math.Round(objtemp.L1 + objtemp.L3 - objtemp.L2 - objtemp.L4,2);
if (objtemp.L5 != 0)
objtemp.L7 = Math.Round(objtemp.L6 / (objtemp.L5 * factor), 2);
else
objtemp.L7 = 0;
objtemp.L8 = Math.Round((objtemp.L5 * factor) * Convert.ToDouble(Volumecalc), 2);
objtemp.L9 = Math.Round(objtemp.L6 - objtemp.L8,2);
objtemp.L12 = Math.Round(objtemp.L6 + objtemp.L10 + objtemp.L11,2);
if (objtemp.L5 != 0)
objtemp.L13 = Math.Round(objtemp.L12 / (objtemp.L5 * factor), 2);
else
objtemp.L13= 0;
Services.BaseService.Update("UpdatePSP_VolumeBalance2", objtemp);
if (EnsureBaseYear() <= objtemp.Year)
sum(objtemp);
}
RefreshData();
}
/// <summary>
/// �Ľ������
/// </summary>
public void UpdateObject()
{
//��ȡ�������
PSP_VolumeBalance obj = FocusedObject;
bool isresum=false;
if (obj == null)
{
return;
}
//���������һ������
PSP_VolumeBalance objCopy = new PSP_VolumeBalance();
DataConverter.CopyTo<PSP_VolumeBalance>(obj, objCopy);
if ((gridView.FocusedColumn.FieldName != "L2"&& gridView.FocusedColumn.FieldName != "L10" && gridView.FocusedColumn.FieldName != "L11")||(gridView.FocusedColumn.FieldName == "L2")&&type!="220")
{
//ִ���IJ���
using (FrmPSP_VolumeBalanceDialog dlg = new FrmPSP_VolumeBalanceDialog())
{
dlg.Type = type;
dlg.Flag = flag;
dlg.List = gridView.DataSource as IList<PSP_VolumeBalance>;
dlg.Object = objCopy; //����
baseyear = ObjectList[0].Year;
dlg.BaseYear = baseyear;
if (type == "220")
{
dlg.xtraTabControl1.TabPages[0].Text = "220ǧ���������ƽ���";
dlg.Text = "220ǧ���������ƽ���";
dlg.rowL1.Properties.Caption = "�ۺ���߸���";
dlg.rowL2.Properties.Caption = "ֱ�ӹ��縺��";
dlg.rowL2.Visible = false;
dlg.rowL4.Properties.Caption = "��������";
//dlg.rowL3.Visible = false;
// dlg.rowL4.Visible = true;
dlg.rowL6.Properties.Caption = "����220kV��ѹ�������";
dlg.rowL14.Visible = false;
dlg.categoryRow1.Visible = false;
dlg.categoryRow2.Visible = false;
dlg.categoryRow3.Properties.Caption = "��220kV��ѹ���縺��";
}
else
if (type == "35")
{
dlg.xtraTabControl1.TabPages[0].Text = "35ǧ���������ƽ���";
dlg.Text = "35ǧ���������ƽ���";
dlg.rowL1.Properties.Caption = "��������";
dlg.rowL2.Properties.Caption = "����ƽ�⸺��";
dlg.rowL4.Visible = false;
dlg.rowL6.Properties.Caption = "����35ǧ���������";
dlg.categoryRow1.Properties.Caption = "����ƽ�⸺��";
dlg.categoryRow2.Visible = false;
dlg.categoryRow3.Properties.Caption = "��35ǧ����ѹ���縺��";
}
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
isresum=dlg.IsReSum;
}
}
else
{
FrmBalance_Calc FrmBalance = new FrmBalance_Calc();
FrmBalance.FormTitle = gridView.FocusedColumn.Caption;
FrmBalance.CtrTitle = gridView.GroupPanelText;
PSP_VolumeBalance vol = new PSP_VolumeBalance();
if (gridView.GetRow(gridView.FocusedRowHandle) != null)
vol = gridView.GetRow(gridView.FocusedRowHandle) as PSP_VolumeBalance;
switch (gridView.FocusedColumn.FieldName)
{
case "L2":
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "1";
FrmBalance.DY = type;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
break;
case "L10":
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "2";
FrmBalance.DY = type;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
break;
case"L11":
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "3";
FrmBalance.DY = type;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
break;
default:
break;
}
if (FrmBalance.FLAG != "")
{
FrmBalance.ShowDialog();
objCopy.GetType().GetProperty(gridView.FocusedColumn.FieldName).SetValue(objCopy, FrmBalance.SUM, null);
}
}
//�ø������½������
DataConverter.CopyTo<PSP_VolumeBalance>(objCopy, obj);
if (isresum)
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.TypeID = type;
ob.Flag = flag;
IList<PSP_VolumeBalance> list0 = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
if (list0 != null)
if (list0.Count > 0)
ob = list0[0];
if(ob.UID!=obj.UID)
Services.BaseService.Update("UpdatePSP_VolumeBalance2", obj);
reloadsum(ob);
}
else
reloadsum(obj);
//ˢ�±��
gridControl.RefreshDataSource();
}
/// <summary>
/// ˢ�±���е�����
/// </summary>
/// <returns>ture:�ɹ� false:ʧ��</returns>
public bool RefreshData()
{
try
{
int iOldHandle = this.gridView.FocusedRowHandle;
PSP_VolumeBalance vol = new PSP_VolumeBalance();
vol.TypeID = type;
vol.Flag = flag;
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", vol);
this.gridControl.DataSource = list;
if (list != null)
if (list.Count > 0)
baseyear = list[0].Year;
try
{
if (Volumecalc == "")
Volumecalc = "0";
//Volumecalc = System.Configuration.ConfigurationSettings.AppSettings["Volumecalc"];
colL8.Caption="��"+type+"kV�������(���ر�"+Volumecalc+")";
GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle);
if (type == "35")
colL5.Caption = "��" + type + "ǧ��������(����ͬʱ��" + loadrate + ")";
}
catch { }
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return false;
}
return true;
}
/// <summary>
/// ��Ӷ���
/// </summary>
public void AddObject()
{
//�����������Ƿ��Ѿ�����
if (ObjectList == null)
{
return;
}
//�½�����
PSP_VolumeBalance obj = new PSP_VolumeBalance();
obj.TypeID = type;
obj.Flag = flag;
//ִ����Ӳ���
using (FrmPSP_VolumeBalanceDialog dlg = new FrmPSP_VolumeBalanceDialog())
{
dlg.Type=type;
dlg.Flag = flag;
dlg.List = gridView.DataSource as IList<PSP_VolumeBalance>;
dlg.IsCreate = true; //�����½���־
dlg.Object = obj;
if (ObjectList.Count>0)
baseyear = ObjectList[0].Year;
dlg.BaseYear = baseyear;
if (type == "220")
{
dlg.xtraTabControl1.TabPages[0].Text = "220ǧ���������ƽ���";
dlg.Text = "220ǧ���������ƽ���";
dlg.rowL1.Properties.Caption = "�ۺ���߸���";
dlg.rowL2.Properties.Caption = "ֱ�ӹ��縺��";
dlg.rowL2.Visible = false;
dlg.rowL4.Properties.Caption = "��������";
//dlg.rowL3.Visible = false;
// dlg.rowL4.Visible = true;
dlg.rowL6.Properties.Caption = "����220kV��ѹ�������";
dlg.categoryRow1.Visible = false;
dlg.categoryRow2.Visible = false;
dlg.categoryRow3.Properties.Caption = "��220kV��ѹ���縺��";
//dlg.rowL14.Visible = false;
}
else
if (type == "35")
{
dlg.xtraTabControl1.TabPages[0].Text = "35ǧ���������ƽ���";
dlg.Text = "35ǧ���������ƽ���";
dlg.rowL1.Properties.Caption = "��������";
dlg.rowL2.Properties.Caption = "����ƽ�⸺��";
//dlg.rowL2.Visible = false;
//dlg.rowL4.Properties.Caption = "��������";
//dlg.rowL3.Visible = false;
dlg.rowL4.Visible = false;
dlg.rowL6.Properties.Caption = "����35ǧ���������";
//dlg.rowL14.Visible = false;
}
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//���¶�����뵽������
ObjectList.Add(obj);
reloadsum(obj);
//ˢ�±���������ж�λ���¶����ϡ�
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
AddFuHe(obj);
}
private void sum(PSP_VolumeBalance objtemp)
{
//PSP_VolumeBalance volumtemp = new PSP_VolumeBalance();
//volumtemp.TypeID =type;
//volumtemp.Year = objtemp.Year;
//IList<PSP_VolumeBalance> listtemp = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAboveYear", volumtemp);
double l6temp = objtemp.L12;
double factor = 1;
if (type == "35")
{
if (loadrate != "")
{
factor = Convert.ToDouble(loadrate);
}
}
PSP_VolumeBalance vol = new PSP_VolumeBalance();
vol.Flag = flag;
vol.TypeID = type;
IList List = Services.BaseService.GetList("SelectPSP_VolumeBalanceByTypeID", vol);
DataTable da = DataConverter.ToDataTable(List, typeof(PSP_VolumeBalance));
DataRow[] dr = da.Select("Year>" + objtemp.Year);
foreach (DataRow drtemp in dr)
{
PSP_VolumeBalance psp = new PSP_VolumeBalance();
foreach (DataColumn dm in da.Columns)
{
psp.GetType().GetProperty(dm.ColumnName).SetValue(psp, drtemp[dm.ColumnName], null);
}
//psp = psptemp;
psp.L6 = Math.Round(l6temp, 2);
psp.L5 = Math.Round(psp.L1 + psp.L3 - psp.L2 - psp.L4, 2);
if (psp.L5 != 0)
{
psp.L7 = Math.Round(psp.L6 / (psp.L5 * factor), 2);
}
else
{
psp.L7 = 0;
}
psp.L8 = Math.Round((psp.L5 * factor) * Convert.ToDouble(Volumecalc), 2);
psp.L9 = Math.Round(psp.L6 - psp.L8, 2);
psp.L12 = Math.Round(psp.L6 + psp.L10 + psp.L11, 2);
if (psp.L5 != 0)
{
psp.L13 = Math.Round(psp.L12 / (psp.L5 * factor), 2);
}
else
{
psp.L13 = 0;
}
l6temp = Math.Round(psp.L12, 2);
Services.BaseService.Update("UpdatePSP_VolumeBalance2", psp);
//foreach (DataColumn dm in da.Columns)
//{
// drtemp[dm.ColumnName]= psp.GetType().GetProperty(dm.ColumnName).GetValue(psp, null);
//}
}
}
protected bool SaveRecord()
{
//创建/修改 对象
try
{
if (IsCreate)
{
Services.BaseService.Create <PSP_VolumeBalance>(_obj);
}
else
{
Services.BaseService.Update <PSP_VolumeBalance>(_obj);
}
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
if (_obj.S1 == "1")
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.Year = EnsureBaseYear();
ob.TypeID = type;
ob.Flag = flag;
IList <PSP_VolumeBalance> list0 = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAndYear", ob);
if (list0 != null)
{
if (list0.Count == 1)
{
list0[0].S1 = "0";
Services.BaseService.Update <PSP_VolumeBalance>(list0[0]);
}
}
PSP_VolumeBalanceDataSource BaseYearrate = new PSP_VolumeBalanceDataSource();
BaseYearrate.UID = baseyeartype;
BaseYearrate.Flag = flag;
BaseYearrate.Value = _obj.Year;
BaseYearrate.TypeID = Convert.ToInt32(_obj.TypeID);
Services.BaseService.Update("UpdatePSP_VolumeBalanceDataSource2", BaseYearrate);
}
else if (_obj.Year == EnsureBaseYear() /*|| (EnsureBaseYear() == baseyear)*/)
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.Flag = flag;
ob.TypeID = type;
IList <PSP_VolumeBalance> list0 = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
if (list0 != null)
{
if (list0.Count > 0)
{
ob = list0[0];
}
}
PSP_VolumeBalanceDataSource BaseYearrate = new PSP_VolumeBalanceDataSource();
BaseYearrate.Flag = flag;
BaseYearrate.UID = baseyeartype;
BaseYearrate.Value = baseyear;
BaseYearrate.TypeID = Convert.ToInt32(_obj.TypeID);
Services.BaseService.Update("UpdatePSP_VolumeBalanceDataSource2", BaseYearrate);
PSP_VolumeBalanceDataSource volumtemp = new PSP_VolumeBalanceDataSource();
volumtemp.TypeID = Convert.ToInt32(type);
volumtemp.Flag = flag;
IList <PSP_VolumeBalanceDataSource> list = Services.BaseService.GetList <PSP_VolumeBalanceDataSource>("SelectPSP_VolumeBalanceDataSourceByTypeID", volumtemp);
if (ob != null)
{
if (ob.UID != "")
{
foreach (PSP_VolumeBalanceDataSource psptemp in list)
{
if (psptemp.UID == baseyeartype)
{
continue;
}
if (hs[psptemp.Name] != null)
{
ob.GetType().GetProperty("L" + hs[psptemp.Name].ToString()).SetValue(ob, psptemp.Value, null);
}
}
}
}
try
{
ob.S1 = "1";
Services.BaseService.Update <PSP_VolumeBalance>(ob);
isresum = true;
}
catch (Exception ex)
{
System.Console.WriteLine(ex.ToString());
}
}
//操作已成功
return(true);
}
private void barA1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
bool issum = true;
PSP_VolumeBalance sumobj = new PSP_VolumeBalance();
Form1_Fs_VolumeBalance frm = new Form1_Fs_VolumeBalance();
frm.Text = "选择最高负荷";
frm.TYPEFLAG2 = "2";
//frm.ShowDialog();
if (frm.ShowDialog() == DialogResult.OK)
{
IList<PSP_VolumeBalance> list;
if (this.ctrlPSP_VolumeBalance1.GridControl.DataSource != null && this.ctrlPSP_VolumeBalance1.GridControl.DataSource != DBNull.Value)
{
list = this.ctrlPSP_VolumeBalance1.GridControl.DataSource as IList<PSP_VolumeBalance>;
foreach (PSP_VolumeBalance pspvol in list)
foreach (TreeListColumn tlc in frm.TLN.TreeList.Columns)
{
if (tlc.FieldName.IndexOf("年") < 0)
continue;
if (Convert.ToInt32(tlc.FieldName.Replace("年","")) == pspvol.Year)
{
try
{
pspvol.L1 = Math.Round(Convert.ToDouble(frm.TLN[tlc.FieldName]),2);
Services.BaseService.Update<PSP_VolumeBalance>(pspvol);
if (issum)
{
issum = false;
}
}
catch (Exception ex)
{
// MessageBox.Show(ex.ToString());
}
}
}
if (!issum)
{
foreach(PSP_VolumeBalance vol in list)
if (this.ctrlPSP_VolumeBalance1.EnsureBaseYear() > 1900)
{
if (vol.Year < this.ctrlPSP_VolumeBalance1.EnsureBaseYear())
{
this.ctrlPSP_VolumeBalance1.reloadsum(vol);
}
else if (vol.Year == this.ctrlPSP_VolumeBalance1.EnsureBaseYear())
{
this.ctrlPSP_VolumeBalance1.reloadsum(vol);
}
}
else
{
this.ctrlPSP_VolumeBalance1.reloadsum(vol);
}
}
}
}
}
private void AddFuHe(PSP_VolumeBalance obj)
{
PSP_VolumeBalance pvc = new PSP_VolumeBalance();
pvc.TypeID = type;
pvc.Flag = flag;
pvc.Year = EnsureBaseYear();
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAndYear", pvc);
if (list != null)
if (list.Count == 1)
{
PSP_VolumeBalance_Calc pvc2 = new PSP_VolumeBalance_Calc();
pvc2.Type ="1";
pvc2.Flag = list[0].UID;
IList<PSP_VolumeBalance_Calc> list2 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc2);
PSP_VolumeBalance_Calc pvc3 = new PSP_VolumeBalance_Calc();
pvc3.Type = "1";
pvc3.Flag = obj.UID;
IList<PSP_VolumeBalance_Calc> list3 = Services.BaseService.GetList<PSP_VolumeBalance_Calc>("SelectPSP_VolumeBalance_CalcByTypeFlag", pvc3);
if (list2 != null)
if (list2.Count > 0)
{
foreach (PSP_VolumeBalance_Calc pvctemp in list2)
{
if (list3 != null)
if (list3.Count == list2.Count)
break;
PSP_VolumeBalance_Calc _obj = new PSP_VolumeBalance_Calc();
_obj = pvctemp;
_obj.Flag = obj.UID;
_obj.Vol = 0;
_obj.UID = Guid.NewGuid().ToString();
Services.BaseService.Create<PSP_VolumeBalance_Calc>(_obj);
}
}
}
}
/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
PSP_VolumeBalance obj = FocusedObject;
bool isresum = false;
if (obj == null)
{
return;
}
//创建对象的一个副本
PSP_VolumeBalance objCopy = new PSP_VolumeBalance();
DataConverter.CopyTo <PSP_VolumeBalance>(obj, objCopy);
if ((gridView.FocusedColumn.FieldName != "L2" && gridView.FocusedColumn.FieldName != "L10" && gridView.FocusedColumn.FieldName != "L11") || (gridView.FocusedColumn.FieldName == "L2") && type != "220")
{
//执行修改操作
using (FrmPSP_VolumeBalanceDialog dlg = new FrmPSP_VolumeBalanceDialog())
{
dlg.Type = type;
dlg.Flag = flag;
dlg.List = gridView.DataSource as IList <PSP_VolumeBalance>;
dlg.Object = objCopy; //绑定副本
baseyear = ObjectList[0].Year;
dlg.BaseYear = baseyear;
if (type == "220")
{
dlg.xtraTabControl1.TabPages[0].Text = "220千伏变电容量平衡表";
dlg.Text = "220千伏变电容量平衡表";
dlg.rowL1.Properties.Caption = "综合最高负荷";
dlg.rowL2.Properties.Caption = "直接供电负荷";
dlg.rowL2.Visible = false;
dlg.rowL4.Properties.Caption = "外网供电";
//dlg.rowL3.Visible = false;
// dlg.rowL4.Visible = true;
dlg.rowL6.Properties.Caption = "现有220kV降压变电容量";
dlg.rowL14.Visible = false;
dlg.categoryRow1.Visible = false;
dlg.categoryRow2.Visible = false;
dlg.categoryRow3.Properties.Caption = "需220kV降压供电负荷";
}
else
if (type == "35")
{
dlg.xtraTabControl1.TabPages[0].Text = "35千伏变电容量平衡表";
dlg.Text = "35千伏变电容量平衡表";
dlg.rowL1.Properties.Caption = "本区负荷";
dlg.rowL2.Properties.Caption = "本地平衡负荷";
dlg.rowL4.Visible = false;
dlg.rowL6.Properties.Caption = "现有35千伏变电容量";
dlg.categoryRow1.Properties.Caption = "本地平衡负荷";
dlg.categoryRow2.Visible = false;
dlg.categoryRow3.Properties.Caption = "需35千伏降压供电负荷";
}
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
isresum = dlg.IsReSum;
}
}
else
{
FrmBalance_Calc FrmBalance = new FrmBalance_Calc();
FrmBalance.FormTitle = gridView.FocusedColumn.Caption;
FrmBalance.CtrTitle = gridView.GroupPanelText;
PSP_VolumeBalance vol = new PSP_VolumeBalance();
if (gridView.GetRow(gridView.FocusedRowHandle) != null)
{
vol = gridView.GetRow(gridView.FocusedRowHandle) as PSP_VolumeBalance;
}
switch (gridView.FocusedColumn.FieldName)
{
case "L2":
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "1";
FrmBalance.DY = type;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
break;
case "L10":
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "2";
FrmBalance.DY = type;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
break;
case "L11":
FrmBalance.FLAG = vol.UID;
FrmBalance.TYPE = "3";
FrmBalance.DY = type;
FrmBalance.ADdRight = AddRight;
FrmBalance.EDitRight = EditRight;
FrmBalance.DEleteRight = DeleteRight;
FrmBalance.PRintRight = PrintRight;
break;
default:
break;
}
if (FrmBalance.FLAG != "")
{
FrmBalance.ShowDialog();
objCopy.GetType().GetProperty(gridView.FocusedColumn.FieldName).SetValue(objCopy, FrmBalance.SUM, null);
}
}
//用副本更新焦点对象
DataConverter.CopyTo <PSP_VolumeBalance>(objCopy, obj);
if (isresum)
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.TypeID = type;
ob.Flag = flag;
IList <PSP_VolumeBalance> list0 = Services.BaseService.GetList <PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
if (list0 != null)
{
if (list0.Count > 0)
{
ob = list0[0];
}
}
if (ob.UID != obj.UID)
{
Services.BaseService.Update("UpdatePSP_VolumeBalance2", obj);
}
reloadsum(ob);
}
else
{
reloadsum(obj);
}
//刷新表格
gridControl.RefreshDataSource();
}
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (gridView1.FocusedRowHandle < 0)
{
return;
}
if (!base.DeleteRight)
{
MsgBox.Show("您没有权限进行此项操作！");
return;
}
if (MsgBox.ShowYesNo("是否删除 " + gridView1.GetDataRow(gridView1.FocusedRowHandle)["ListName"])
== DialogResult.No)
{
return;
}
PowerEachList report = Itop.Common.DataConverter.RowToObject<PowerEachList>(gridView1.GetDataRow(gridView1.FocusedRowHandle));
try
{
PSP_VolumeBalance ob = new PSP_VolumeBalance();
ob.Flag = report.UID;
if (typeFlag.Contains("110"))
ob.TypeID = "110";
else if (typeFlag.Contains("220"))
ob.TypeID = "220";
IList<PSP_VolumeBalance> list = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeID", ob);
foreach(PSP_VolumeBalance listtemp in list)
Services.BaseService.Update("DeletePSP_VolumeBalance2", listtemp);
Common.Services.BaseService.Update("DeletePowerEachList_VolumeBalance", report);
gridView1.DeleteRow(gridView1.FocusedRowHandle);
}
catch (Exception ex)
{
MsgBox.Show("删除出错：" + ex.Message);
}
}
private void sum(PSP_VolumeBalance objtemp)
{
//PSP_VolumeBalance volumtemp = new PSP_VolumeBalance();
//volumtemp.TypeID =type;
//volumtemp.Year = objtemp.Year;
//IList<PSP_VolumeBalance> listtemp = Services.BaseService.GetList<PSP_VolumeBalance>("SelectPSP_VolumeBalanceByTypeIDAboveYear", volumtemp);
double l6temp = objtemp.L12;
double factor = 1;
if (type == "35")
if (loadrate != "")
factor = Convert.ToDouble(loadrate);
PSP_VolumeBalance vol = new PSP_VolumeBalance();
vol.Flag=flag;
vol.TypeID=type;
IList List = Services.BaseService.GetList("SelectPSP_VolumeBalanceByTypeID", vol);
DataTable da = DataConverter.ToDataTable(List, typeof(PSP_VolumeBalance));
DataRow[] dr = da.Select("Year>"+objtemp.Year);
foreach (DataRow drtemp in dr)
{
PSP_VolumeBalance psp = new PSP_VolumeBalance();
foreach (DataColumn dm in da.Columns)
{
psp.GetType().GetProperty(dm.ColumnName).SetValue(psp, drtemp[dm.ColumnName], null);
}
//psp = psptemp;
psp.L6 = Math.Round(l6temp,2);
psp.L5 = Math.Round(psp.L1 + psp.L3 - psp.L2 - psp.L4,2);
if (psp.L5 != 0)
psp.L7 = Math.Round(psp.L6 / (psp.L5 * factor), 2);
else
psp.L7 = 0;
psp.L8 = Math.Round((psp.L5 * factor) * Convert.ToDouble(Volumecalc), 2);
psp.L9 = Math.Round(psp.L6 - psp.L8,2);
psp.L12 = Math.Round(psp.L6 + psp.L10 + psp.L11,2);
if (psp.L5 != 0)
psp.L13 = Math.Round(psp.L12 / (psp.L5 * factor), 2);
else
psp.L13 = 0;
l6temp = Math.Round(psp.L12,2);
Services.BaseService.Update("UpdatePSP_VolumeBalance2", psp);
//foreach (DataColumn dm in da.Columns)
//{
// drtemp[dm.ColumnName]= psp.GetType().GetProperty(dm.ColumnName).GetValue(psp, null);
//}
}
}
