private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FrmPSP_Project_ListPrint_TouZiGuSuan tzprint = new FrmPSP_Project_ListPrint_TouZiGuSuan();
PSP_Project_List pp = new PSP_Project_List();
pp.Flag2 = typeFlag;
IList list = Services.BaseService.GetList("SelectPSP_Project_ListByFlag2", pp);
try
{
foreach (PSP_Project_List pl in list)
{
if (pl.L5 != "" && pl.L5 != null)
{
if (int.Parse(pl.L5) > 1)
{
pl.L6 = pl.L6 + " X " + pl.L5;
}
}
}
}
catch { }
DataTable dt = Itop.Common.DataConverter.ToDataTable(list, typeof(PSP_Project_List));
tzprint.Text = this.ctrlPowerEachList1.FocusedObject.ListName;
//tzprint.gridControl1.Text= "4455";
tzprint.bandedGridView1.GroupPanelText = this.ctrlPowerEachList1.FocusedObject.ListName;
tzprint.GridDataTable = dt;
tzprint.Show();
}
/// <summary>
/// 修改焦点对象
/// </summary>
public void UpdateObject()
{
//获取焦点对象
PSP_Project_List obj = FocusedObject;
if (obj == null)
{
return;
}
//创建对象的一个副本
PSP_Project_List objCopy = new PSP_Project_List();
DataConverter.CopyTo <PSP_Project_List>(obj, objCopy);
//执行修改操作
using (FrmPSP_Project_ListDialog dlg = new FrmPSP_Project_ListDialog())
{
dlg.Object = objCopy; //绑定副本
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//用副本更新焦点对象
DataConverter.CopyTo <PSP_Project_List>(objCopy, obj);
//刷新表格
gridControl.RefreshDataSource();
}
/// <summary>
/// 添加对象
/// </summary>
public void AddObject()
{
//检查对象链表是否已经加载
if (ObjectList == null)
{
return;
}
//新建对象
PSP_Project_List obj = new PSP_Project_List();
//执行添加操作
using (FrmPSP_Project_ListDialog dlg = new FrmPSP_Project_ListDialog())
{
dlg.IsCreate = true; //设置新建标志
dlg.Object = obj;
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
}
//将新对象加入到链表中
ObjectList.Add(obj);
//刷新表格，并将焦点行定位到新对象上。
gridControl.RefreshDataSource();
GridHelper.FocuseRow(this.gridView, obj);
}
/// <summary>
/// 刷新表格中的数据
/// </summary>
/// <returns>ture:成功 false:失败</returns>
public bool RefreshData()
{
PSP_Project_List pp = new PSP_Project_List();
pp.Flag2 = flag;
try
{
IList <PSP_Project_List> list = Services.BaseService.GetList <PSP_Project_List>("SelectPSP_Project_ListByFlag2", pp);
this.gridControl.DataSource = list;
}
catch (Exception exc)
{
Debug.Fail(exc.Message);
HandleException.TryCatch(exc);
return(false);
}
return(true);
}
/// <summary>
/// 删除焦点对象
/// </summary>
public void DeleteObject()
{
//获取焦点对象
PSP_Project_List obj = FocusedObject;
if (obj == null)
{
return;
}
//请求确认
if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
{
return;
}
//执行删除操作
try
{
Services.BaseService.Delete <PSP_Project_List>(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();
}
public void InitSodata()
{
if (ctrlPowerEachList1.FocusedObject == null)
{
return;
}
string sid = typeFlag = ctrlPowerEachList1.FocusedObject.UID;
ctrlPSP_Project_List1.Flag = typeFlag;
Hashtable hs = new Hashtable();
Hashtable hs1 = new Hashtable();
IList <LineInfo> listLineInfo = Services.BaseService.GetList <LineInfo>("SelectLineInfoByPowerID", sid);
foreach (LineInfo l1 in listLineInfo)
{
hs.Add(Guid.NewGuid().ToString(), l1.UID);
}
IList <substation> listsubstation = Services.BaseService.GetList <substation>("SelectsubstationByPowerID2", sid);
foreach (substation s1 in listsubstation)
{
hs.Add(Guid.NewGuid().ToString(), s1.UID);
}
PSP_Project_List psp_Type = new PSP_Project_List();
psp_Type.Flag2 = sid;
IList <PSP_Project_List> listProTypes = Common.Services.BaseService.GetList <PSP_Project_List>("SelectPSP_Project_ListByFlag2", psp_Type);
foreach (PSP_Project_List ps in listProTypes)
{
hs1.Add(Guid.NewGuid().ToString(), ps.Code);
}
foreach (PSP_Project_List p1 in listProTypes)
{
if (p1.Code != "" && !hs.ContainsValue(p1.Code) && p1.ParentID != "0")
{
//删除
Services.BaseService.Delete <PSP_Project_List>(p1);
}
}
foreach (LineInfo l2 in listLineInfo)
{
if (!hs1.ContainsValue(l2.UID) && l2.Voltage != "")
{
//添加
try
{
PSP_Project_List ps2 = new PSP_Project_List();
ps2.ParentID = l2.Voltage.ToUpper().Replace("KV", "");
ps2.L3 = l2.LineName;
ps2.Code = l2.UID;
ps2.Flag = 1;
ps2.Flag2 = sid;
ps2.L4 = l2.Voltage;
ps2.L8 = double.Parse(l2.Length).ToString();;
ps2.L9 = l2.LineType;
if (l2.ObligateField1 == "运行")
{
ps2.L2 = "扩建";
}
else if (l2.ObligateField1 == "规划")
{
ps2.L2 = "新建";
}
ps2.L15 = l2.ObligateField3;
ps2.ID = Guid.NewGuid().ToString();
Services.BaseService.Create <PSP_Project_List>(ps2);
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
if (hs1.ContainsValue(l2.UID) && l2.Voltage != "")
{
//更新
try
{
PSP_Project_List p2 = new PSP_Project_List();
p2.Code = l2.UID;
p2.Flag2 = sid;
PSP_Project_List ps2 = (PSP_Project_List)Services.BaseService.GetObject("SelectPSP_Project_ListByObject", p2);
ps2.ParentID = l2.Voltage.ToUpper().Replace("KV", "");
ps2.Flag = 1;
if (l2.ObligateField1 == "运行")
{
l2.ObligateField1 = "扩建";
}
else if (l2.ObligateField1 == "规划")
{
l2.ObligateField1 = "新建";
}
if (double.Parse(l2.Length).ToString() == "" || double.Parse(l2.Length).ToString() == null)
{
l2.Length = "0";
}
if (ps2.L3 != l2.LineName || ps2.L4 != l2.Voltage || ps2.L8 != double.Parse(l2.Length).ToString() || ps2.L9 != l2.LineType || l2.ObligateField1 != ps2.L2 || ps2.L15 != l2.ObligateField3)
{
ps2.L3 = l2.LineName;
ps2.L4 = l2.Voltage;
ps2.L8 = double.Parse(l2.Length).ToString();
ps2.L9 = l2.LineType;
if (l2.ObligateField1 == "运行")
{
ps2.L2 = "扩建";
}
else if (l2.ObligateField1 == "规划")
{
ps2.L2 = "新建";
}
ps2.L15 = l2.ObligateField3;
Services.BaseService.Update("UpdatePSP_Project_ListByCode", ps2);
}
}
catch (Exception ex)
{
System.Console.WriteLine(ex.Message);
}
}
}
Project_Sum psp = new Project_Sum();
psp.S5 = "2";
IList <Project_Sum> sum = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS5", psp);
Hashtable ha = new Hashtable();
ArrayList al = new ArrayList();
foreach (substation s2 in listsubstation)
{
if (!hs1.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
ha.Clear();
al.Clear();
int kk = 0;
//添加
try
{
Substation_Info sub = new Substation_Info();
sub.Code = s2.UID;
//Substation_Info station = (Substation_Info)Common.Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub);
PSP_Project_List ps3 = new PSP_Project_List();
ps3.ParentID = s2.ObligateField1;
ps3.L3 = s2.EleName;
ps3.Code = s2.UID;
ps3.Flag = 2;
ps3.Flag2 = sid;
ps3.L4 = s2.ObligateField1.ToString();
if (s2.ObligateField3 == "运行")
{
ps3.L2 = "扩建";
}
else if (s2.ObligateField3 == "规划")
{
ps3.L2 = "新建";
}
ps3.L15 = s2.ObligateField5;
//if (station != null)
//{
// ps3.L5 = station.L3.ToString();
//}
foreach (Project_Sum ps1 in sum)
{
if (s2.ObligateField1.ToString() == ps1.S1.ToString())
{
try
{
double mva = double.Parse(s2.Number.ToString());
double t5 = Convert.ToDouble(ps1.T5); //单台容量
int ta = Convert.ToInt32(ps1.T1); //主变台数
if (mva == (t5 * ta))
{
ha.Add(t5, ta);
al.Add(t5);
}
}
catch { }
}
}
if (al.Count > 0)
{
double va = Convert.ToDouble(al[0].ToString());
for (int ii = 0; ii < al.Count; ii++)
{
if (va < Convert.ToDouble(al[ii].ToString()))
{
va = Convert.ToDouble(al[ii].ToString());
}
}
ps3.L5 = ha[va].ToString();
ps3.L6 = va.ToString();
}
else
{
ps3.L5 = "";
ps3.L6 = "";
}
ps3.IsConn = double.Parse(s2.Number.ToString()).ToString();//总容量
ps3.ID = Guid.NewGuid().ToString();
Services.BaseService.Create <PSP_Project_List>(ps3);
}
catch { }
}
if (hs1.ContainsValue(s2.UID) && s2.ObligateField1 != "")
{
ha.Clear();
al.Clear();
int kk = 0;
//更新
try
{
Substation_Info sub = new Substation_Info();
sub.Code = s2.UID;
//Substation_Info station = (Substation_Info)Common.Services.BaseService.GetObject("SelectSubstation_InfoByCode", sub);
PSP_Project_List p3 = new PSP_Project_List();
p3.Code = s2.UID;
p3.Flag2 = sid;
PSP_Project_List ps3 = (PSP_Project_List)Services.BaseService.GetObject("SelectPSP_Project_ListByObject", p3);
ps3.ParentID = s2.ObligateField1;
ps3.Flag = 2;
if (s2.ObligateField3 == "运行")
{
s2.ObligateField3 = "扩建";
}
else if (s2.ObligateField3 == "规划")
{
s2.ObligateField3 = "新建";
}
string l5 = "";
string l6 = "";
foreach (Project_Sum ps1 in sum)
{
if (s2.ObligateField1.ToString() == ps1.S1.ToString())
{
try
{
double mva = 0;
if (s2.Number.ToString() != "" && s2.Number.ToString() != null)
{
mva = double.Parse(s2.Number.ToString());
}
double t5 = Convert.ToDouble(ps1.T5); //单台容量
int ta = Convert.ToInt32(ps1.T1); //主变台数
if (mva == (t5 * ta))
{
ha.Add(t5, ta);
al.Add(t5);
}
}
catch { }
}
}
if (al.Count > 0)
{
double va = Convert.ToDouble(al[0].ToString());
for (int ii = 0; ii < al.Count; ii++)
{
if (va < Convert.ToDouble(al[ii].ToString()))
{
va = Convert.ToDouble(al[ii].ToString());
}
}
l5 = ha[va].ToString();
l6 = va.ToString();
}
else
{
l5 = "";
l6 = "";
}
if (ps3.L3 != s2.EleName || ps3.L4 != s2.ObligateField1.ToString() || s2.ObligateField3 != ps3.L2 || ps3.L15 != s2.ObligateField5 || ps3.L5 != l5 || ps3.L6 != l6)
{
ps3.L3 = s2.EleName;
ps3.L4 = s2.ObligateField1.ToString();
if (s2.ObligateField3 == "运行")
{
ps3.L2 = "扩建";
}
else if (s2.ObligateField3 == "规划")
{
ps3.L2 = "新建";
}
ps3.L15 = s2.ObligateField5;
//if (station != null)
//{
// ps3.L5 = station.L3.ToString();
//}
ps3.IsConn = double.Parse(s2.Number.ToString()).ToString();//总容量
Services.BaseService.Update("UpdatePSP_Project_ListByCode", ps3);
}
}
catch { }
}
}
}
private void CreateInit()
{
double sumvalue = 0;
OBJ.L11 = "0";
if (OBJ.L4 == "220")
{
Project_Sum pjt = new Project_Sum();
if (OBJ.Flag == 2)
{
pjt.S1 = "220";
pjt.S5 = "2";
IList <Project_Sum> lt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum ps in lt)
{
if (ps.T5 != null && ps.T5 != "")
{
if (!this.repositoryItemComboBox3.Items.Contains(ps.T5))
{
this.repositoryItemComboBox3.Items.Add(ps.T5);
}
}
}
if (this.repositoryItemComboBox3.Items.Count > 0)
{
OBJ.L6 = this.repositoryItemComboBox3.Items[0].ToString();
}
}
pjt.S1 = "220";
pjt.S5 = "1";
IList <Project_Sum> ltt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum pss in ltt)
{
if (pss.L1 != null && pss.L1 != "")
{
if (!this.repositoryItemComboBox10.Items.Contains(pss.L1))
{
this.repositoryItemComboBox10.Items.Add(pss.L1);
}
}
}
if (OBJ.Flag == 1)
{
if (this.repositoryItemComboBox10.Items.Count > 0)
{
OBJ.L9 = this.repositoryItemComboBox10.Items[0].ToString();
}
}
}
if (OBJ.L4 == "110")
{
Project_Sum pjt = new Project_Sum();
if (OBJ.Flag == 2)
{
pjt.S1 = "110";
pjt.S5 = "2";
IList <Project_Sum> lt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum ps in lt)
{
if (ps.T5 != null && ps.T5 != "")
{
if (!this.repositoryItemComboBox3.Items.Contains(ps.T5))
{
this.repositoryItemComboBox3.Items.Add(ps.T5);
}
}
}
if (this.repositoryItemComboBox3.Items.Count > 0)
{
OBJ.L6 = this.repositoryItemComboBox3.Items[0].ToString();
}
}
pjt.S1 = "110";
pjt.S5 = "1";
IList <Project_Sum> ltt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum pss in ltt)
{
if (pss.L1 != null && pss.L1 != "")
{
if (!this.repositoryItemComboBox10.Items.Contains(pss.L1))
{
this.repositoryItemComboBox10.Items.Add(pss.L1);
}
}
}
if (OBJ.Flag == 1)
{
if (this.repositoryItemComboBox10.Items.Count > 0)
{
OBJ.L9 = this.repositoryItemComboBox10.Items[0].ToString();
}
}
}
if (OBJ.L4 == "35")
{
Project_Sum pjt = new Project_Sum();
if (OBJ.Flag == 2)
{
pjt.S1 = "35";
pjt.S5 = "2";
IList <Project_Sum> lt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum ps in lt)
{
if (ps.T5 != null && ps.T5 != "")
{
if (!this.repositoryItemComboBox3.Items.Contains(ps.T5))
{
this.repositoryItemComboBox3.Items.Add(ps.T5);
}
}
}
if (this.repositoryItemComboBox3.Items.Count > 0)
{
OBJ.L6 = this.repositoryItemComboBox3.Items[0].ToString();
}
}
pjt.S1 = "35";
pjt.S5 = "1";
IList <Project_Sum> ltt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum pss in ltt)
{
if (pss.L1 != null && pss.L1 != "")
{
if (!this.repositoryItemComboBox10.Items.Contains(pss.L1))
{
this.repositoryItemComboBox10.Items.Add(pss.L1);
}
}
}
if (OBJ.Flag == 1)
{
if (this.repositoryItemComboBox10.Items.Count > 0)
{
OBJ.L9 = this.repositoryItemComboBox10.Items[0].ToString();
}
}
}
if (OBJ.L4 == "66")
{
Project_Sum pjt = new Project_Sum();
if (OBJ.Flag == 2)
{
pjt.S1 = "66";
pjt.S5 = "2";
IList <Project_Sum> lt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum ps in lt)
{
if (ps.T5 != null && ps.T5 != "")
{
if (!this.repositoryItemComboBox3.Items.Contains(ps.T5))
{
this.repositoryItemComboBox3.Items.Add(ps.T5);
}
}
}
if (this.repositoryItemComboBox3.Items.Count > 0)
{
OBJ.L6 = this.repositoryItemComboBox3.Items[0].ToString();
}
}
pjt.S1 = "66";
pjt.S5 = "1";
IList <Project_Sum> ltt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum pss in ltt)
{
if (pss.L1 != null && pss.L1 != "")
{
if (!this.repositoryItemComboBox10.Items.Contains(pss.L1))
{
this.repositoryItemComboBox10.Items.Add(pss.L1);
}
}
}
if (OBJ.Flag == 1)
{
if (this.repositoryItemComboBox10.Items.Count > 0)
{
OBJ.L9 = this.repositoryItemComboBox10.Items[0].ToString();
}
}
}
if (OBJ.L4 == "500")
{
Project_Sum pjt = new Project_Sum();
if (OBJ.Flag == 2)
{
pjt.S1 = "500";
pjt.S5 = "2";
IList <Project_Sum> lt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum ps in lt)
{
if (ps.T5 != null && ps.T5 != "")
{
if (!this.repositoryItemComboBox3.Items.Contains(ps.T5))
{
this.repositoryItemComboBox3.Items.Add(ps.T5);
}
}
}
if (this.repositoryItemComboBox3.Items.Count > 0)
{
OBJ.L6 = this.repositoryItemComboBox3.Items[0].ToString();
}
}
pjt.S1 = "500";
pjt.S5 = "1";
IList <Project_Sum> ltt = Common.Services.BaseService.GetList <Project_Sum>("SelectProject_SumByS1andS5", pjt);
foreach (Project_Sum pss in ltt)
{
if (pss.L1 != null && pss.L1 != "")
{
if (!this.repositoryItemComboBox10.Items.Contains(pss.L1))
{
this.repositoryItemComboBox10.Items.Add(pss.L1);
}
}
}
if (OBJ.Flag == 1)
{
if (this.repositoryItemComboBox10.Items.Count > 0)
{
OBJ.L9 = this.repositoryItemComboBox10.Items[0].ToString();
}
}
}
if (OBJ.Flag == 2)
{
this.单台容量.Enabled = true;
this.主变台数.Enabled = true;
}
PSP_Project_List sf = (PSP_Project_List)Services.BaseService.GetObject("SelectPSP_Project_ListByMaxCreateTime", null);
IList sf1 = Services.BaseService.GetList("selectPag2", null);
foreach (PSP_Project_List kk in sf1)
{
if (kk.L1 != "" && kk.L1 != null)
{
this.repositoryItemComboBox5.Items.Add(kk.L1);
}
}
if (sf != null)
{
if (sf.L1 != "" && sf.L1 != null)
{
OBJ.L1 = sf.L1;
}
else if (this.repositoryItemComboBox5.Items.Count > 0)
{
OBJ.L1 = this.repositoryItemComboBox5.Items[0].ToString();
}
else if (this.repositoryItemComboBox5.Items.Count > 0)
{
OBJ.L1 = this.repositoryItemComboBox5.Items[0].ToString();
}
}
}
private void FormAddInfo_LangFang_Load(object sender, EventArgs e)
{
if (isupdate == true)
{
PSP_Project_List ppt = new PSP_Project_List();
ppt.ID = poweruid;
ppt.Flag2 = flag;
//obj = (PSP_Project_List)Common.Services.BaseService.GetObject("SelectPSP_Project_ListByKey", ppt);
obj = Common.Services.BaseService.GetOneByKey <PSP_Project_List>(ppt);
OBJ = obj;
powerid = obj.Code;
if (OBJ.Flag == 2)
{
OBJ.L19 = "变电站";
}
else
{
OBJ.L19 = "线路";
}
isupdate = true;
UpDateInit();
IList <PSP_Project_List> list = new List <PSP_Project_List>();
list.Add(OBJ);
this.vGridControl1.DataSource = list;
}
if (isupdate == false)
{
OBJ.ID = Guid.NewGuid().ToString();
OBJ.CreateTime = DateTime.Now;
OBJ.UpdateTime = DateTime.Now;
OBJ.ParentID = parentID;
OBJ.Flag2 = flag;
OBJ.Flag = 2;
OBJ.L4 = "220";
OBJ.L5 = "1";
OBJ.L7 = "户内站";
OBJ.L11 = "0";
OBJ.L12 = 0;
OBJ.L10 = 0;
OBJ.L19 = "变电站";
CreateInit();
IList <PSP_Project_List> list = new List <PSP_Project_List>();
list.Add(OBJ);
this.vGridControl1.DataSource = list;
}
this.电压等级.Properties.RowEdit.Click += new EventHandler(RowEdit_Click);
this.类型.Properties.RowEdit.EditValueChanged += new EventHandler(RowEdit_EditValueChanged);
LineInfo li22 = Common.Services.BaseService.GetOneByKey <LineInfo>(powerid);
if (li22 != null || OBJ.Flag == 1)
{
isline = true;
}
substation sb = Common.Services.BaseService.GetOneByKey <substation>(powerid);
if (sb != null || OBJ.Flag == 2)
{
isPower = true;
}
}
