private void simpleButtonOK_Click(object sender, EventArgs e)
{
//if (f.ShowDialog() == DialogResult.OK)
//{
string sel = GetSelectNode();
LayerGrade lg = new LayerGrade();
lg.SvgDataUid = strSvgDataUid;
lg.Type = type;
IList list1 = Services.BaseService.GetList("SelectLayerGradeList5", lg);
if (list1.Count > 0)
{
foreach (LayerGrade ld in list1)
{
ld.Type = "";
Services.BaseService.Update <LayerGrade>(ld);
}
}
string[] id = sel.Split(",".ToCharArray());
//消除原来的
if (id.Length > 1)
{
for (int i = 1; i < id.Length; i++)
{
LayerGrade _l = Services.BaseService.GetOneByKey <LayerGrade>(id[i]);
_l.Type = type;
Services.BaseService.Update <LayerGrade>(_l);
}
}
//}
this.Close();
}
public void InitDate()
{
IList numlist = Services.BaseService.GetList <LineType>();
TreeNode tn = new TreeNode();
tn.Text = "原有变电站";
tn.Tag = "old";
for (int j = 0; j < numlist.Count; j++)
{
TreeNode n1 = new TreeNode();
n1.Text = ((LineType)numlist[j]).TypeName;
n1.Tag = ((LineType)numlist[j]).TypeName.Replace("kV", "");;
tn.Nodes.Add(n1);
}
treeView1.Nodes[0].Nodes.Add(tn);
LayerGrade lay = new LayerGrade();
IList <LayerGrade> list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeList", lay);
for (int i = 0; i < list.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = list[i].Name;
node.Tag = list[i].SUID;
for (int j = 0; j < numlist.Count; j++)
{
TreeNode n1 = new TreeNode();
n1.Text = ((LineType)numlist[j]).TypeName;
n1.Tag = ((LineType)numlist[j]).TypeName.Replace("kV", "");;
node.Nodes.Add(n1);
}
treeView1.Nodes[0].Nodes.Add(node);
}
treeView1.Nodes[0].Expand();
}
public void initDate()
{
LayerGrade lay = new LayerGrade();
lay.Name = str_year + "%";
IList <LayerGrade> list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeByYear", lay);
for (int i = 0; i < list.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = list[i].Name;
node.Tag = list[i].SUID;
treeView1.Nodes[0].Nodes.Add(node);
}
treeView1.ExpandAll();
foreach (TreeNode node in treeView1.Nodes[0].Nodes)
{
if (node.Text.Length > 4)
{
if (node.Text.Substring(0, 4) == str_year)
{
treeView1.SelectedNode = node;
}
}
}
}
public void InitData(string svgDataUid)
{
IList ilist = new ArrayList();
DataTable dataTable = new DataTable();
LayerGrade obj = new LayerGrade();
obj.SvgDataUid = svgDataUid;
ilist = Services.BaseService.GetList("SelectLayerGradeListBySvgDataUid", obj);
//ilist = Services.BaseService.GetList<PspType>();
dataTable = DataConverter.ToDataTable(ilist, typeof(LayerGrade));
pi.Properties.DataSource = dataTable;
dataTable.Rows.Add(DataConverter.ObjectToRow("", dataTable.NewRow()));
}
private void frmSelectYear_Load(object sender, EventArgs e)
{
LayerGrade lay = new LayerGrade();
IList <LayerGrade> list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeList", lay);
for (int i = 0; i < list.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = list[i].Name;
node.Tag = list[i].SUID;
treeView1.Nodes[0].Nodes.Add(node);
}
treeView1.ExpandAll();
}
public void InitDate()
{
LayerGrade lay = new LayerGrade();
IList <LayerGrade> list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeList", lay);
for (int i = 0; i < list.Count; i++)
{
TreeNode node = new TreeNode();
node.Text = list[i].Name;
node.Tag = list[i].SUID;
treeView1.Nodes[0].Nodes.Add(node);
}
treeView1.ExpandAll();
}
private void LayerGradeAdd(object sender, EventArgs e)
{
string uid = "";
if (treeList1.FocusedNode != null)
{
uid = treeList1.FocusedNode[treeListColumn2].ToString();
}
frmLayerGradeInPut dlg = new frmLayerGradeInPut(strSvgDataUid);
LayerGrade objnew = new LayerGrade();
objnew.SUID = Guid.NewGuid().ToString();
objnew.SvgDataUid = strSvgDataUid;
//objnew.ParentID = uid;
if (dlg.ShowDialog() == DialogResult.OK)
{
objnew.Name = dlg.TextInPut;
objnew.ParentID = dlg.ParentID;
}
else
{
return;
}
if (objnew.Name == "")
{
MessageBox.Show("分级名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
foreach (LayerGrade lay in ilist)
{
if (objnew.Name == lay.Name)
{
MessageBox.Show("分级已经存在。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
dataTable.Rows.Add(DataConverter.ObjectToRow(objnew, dataTable.NewRow()));
Services.BaseService.Create <LayerGrade>(objnew);
Psp_ProgLayerList obj2 = new Psp_ProgLayerList();
obj2.UID = Guid.NewGuid().ToString();
obj2.ProgUID = MIS.ProgUID;
obj2.LayerGradeID = objnew.SUID;
obj2.col1 = objnew.Name;
Services.BaseService.Create <Psp_ProgLayerList>(obj2);
InitData(strSvgDataUid);
}
private void frmProgLayerManager_Load(object sender, EventArgs e)
{
suid = ConfigurationSettings.AppSettings.Get("SvgID");
LayerGrade g = new LayerGrade();
g.ParentID = "SUID";
g.SvgDataUid = suid;
list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeListBySvgDataUid2", g);
for (int i = 0; i < list.Count; i++)
{
TreeNode node = new TreeNode();
node.Tag = list[i].SUID;
node.Text = list[i].Name;
LayerGrade _g = new LayerGrade();
_g.ParentID = list[i].SUID;
_g.SvgDataUid = suid;
IList <LayerGrade> _list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeListBySvgDataUid2", _g);
for (int j = 0; j < _list.Count; j++)
{
TreeNode _node = new TreeNode();
_node.Tag = _list[j].SUID;
_node.Text = _list[j].Name;
node.Nodes.Add(_node);
}
treeView1.Nodes.Add(node);
}
Psp_ProgLayerList p2 = new Psp_ProgLayerList();
p2.ProgUID = progid;
IList <Psp_ProgLayerList> plist = Services.BaseService.GetList <Psp_ProgLayerList>("SelectPsp_ProgLayerListListByProgUID", p2);
treeView1.AfterCheck -= new System.Windows.Forms.TreeViewEventHandler(this.tree_AfterCheck);
foreach (TreeNode tnode in treeView1.Nodes)
{
if (GetNodeCheck(tnode, plist))
{
tnode.Checked = true;
foreach (TreeNode tnode2 in tnode.Nodes)
{
if (GetNodeCheck(tnode2, plist))
{
tnode2.Checked = true;
}
}
}
}
treeView1.AfterCheck += new System.Windows.Forms.TreeViewEventHandler(this.tree_AfterCheck);
}
public void InitData(string svgDataUid)
{
strSvgDataUid = svgDataUid;
LayerGrade lg = new LayerGrade();
lg.SvgDataUid = svgDataUid;
lg.ParentID = "SUID";
ilist = Services.BaseService.GetList("SelectLayerGradeListBySvgDataUid2", lg);
//ilist = Services.BaseService.GetList<PspType>();
dataTable = DataConverter.ToDataTable(ilist, typeof(LayerGrade));
treeList1.DataSource = dataTable;
Application.DoEvents();
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
if (DesignMode)
{
return;
}
LayerGrade lay = new LayerGrade();
IList <LayerGrade> list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeList", lay);
for (int i = 0; i < list.Count; i++)
{
ComboBoxItem <LayerGrade> item = new ComboBoxItem <LayerGrade>(list[i], list[i].Name);
comboBox1.Items.Add(item);
}
}
public void InitData2(string svgDataUid)
{
treeList1.OptionsSelection.MultiSelect = false;
//this.treeList1.GetStateImage -= new DevExpress.XtraTreeList.GetStateImageEventHandler(this.treeList1_GetStateImage);
//this.treeList1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.treeList1_KeyDown);
//this.treeList1.MouseDown -= new System.Windows.Forms.MouseEventHandler(this.treeList1_MouseDown);
strSvgDataUid = svgDataUid;
LayerGrade lg = new LayerGrade();
lg.SvgDataUid = svgDataUid;
ilist = Services.BaseService.GetList("SelectLayerGradeListBySvgDataUid", lg);
dataTable = DataConverter.ToDataTable(ilist, typeof(LayerGrade));
treeList1.DataSource = dataTable;
Application.DoEvents();
treeList1.CollapseAll();
}
public void InitData(string svgDataUid)
{
strSvgDataUid = svgDataUid;
LayerGrade lg = new LayerGrade();
lg.SvgDataUid = svgDataUid;
ilist = Services.BaseService.GetList("SelectLayerGradeListBySvgDataUid", lg);
//ilist = Services.BaseService.GetList<PspType>();
for (int i = 0; i < ilist.Count; i++)
{
int key = 0;
for (int j = 0; j < savelist.Count; j++)
{
if (savelist[j].ToString() == ((LayerGrade)ilist[i]).SUID)
{
key = 1;
}
}
if (key == 1)
{
olist.Add(ilist[i]);
}
key = 0;
}
dataTable = DataConverter.ToDataTable(olist, typeof(LayerGrade));
//IList list = this.SymbolDoc.getLayerList();
//foreach (Layer lay in list)
//{
// if (lay.GetAttribute("layerType") == "电网规划层")
// {
// LayerGrade obj = new LayerGrade();
// obj.SUID = lay.ID;
// obj.Name = lay.Label;
// obj.ParentID = lay.GetAttribute("ParentID");
// dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow()));
// }
//}
treeList1.DataSource = dataTable;
Application.DoEvents();
treeList1.CollapseAll();
}
private void LayerGradeChange(object sender, EventArgs e)
{
if (treeList1.FocusedNode == null)
{
return;
}
string uid = treeList1.FocusedNode[treeListColumn2].ToString();
LayerGrade obj = Services.BaseService.GetOneByKey <LayerGrade>(uid);
frmLayerGradeInPut dlg = new frmLayerGradeInPut(strSvgDataUid);
dlg.TextInPut = treeList1.FocusedNode[treeListColumn1].ToString();
//LayerGrade objParent = Services.BaseService.GetOneByKey<LayerGrade>((string)treeList1.FocusedNode[treeListColumn4]);
dlg.ParentID = treeList1.FocusedNode[treeListColumn4].ToString();
if (obj != null)
{
dlg.textBoxEnabled = true;
}
else
{
dlg.textBoxEnabled = false;
}
if (dlg.ShowDialog() == DialogResult.OK)
{
if (dlg.TextInPut == "")
{
MessageBox.Show("分级名称不能为空！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
SVG_LAYER lar = new SVG_LAYER();
lar.svgID = strSvgDataUid;
lar.SUID = uid;
lar = (SVG_LAYER)Services.BaseService.GetObject("SelectSVG_LAYERByKey", lar);
if (lar != null)
{
lar.YearID = dlg.ParentID;
Services.BaseService.Update <SVG_LAYER>(lar);
}
if (obj != null)
{
obj.Name = dlg.TextInPut;
obj.ParentID = dlg.ParentID;
foreach (LayerGrade lay in ilist)
{
if (obj.Name == lay.Name && obj.Name != treeList1.FocusedNode[treeListColumn1].ToString())
{
MessageBox.Show("分级已经存在！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
if (obj.ParentID == obj.SUID)
{
MessageBox.Show("不能将分级设置成自己的子级！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
treeList1.FocusedNode.SetValue("Name", obj.Name);
treeList1.FocusedNode.SetValue("ParentID", obj.ParentID);
Services.BaseService.Update("UpdateLayerGrade", obj);
}
else
{
Layer lay = SymbolDoc.GetLayerByID(uid);
treeList1.FocusedNode.SetValue("Name", dlg.TextInPut);
treeList1.FocusedNode.SetValue("ParentID", dlg.ParentID);
//lay.Label = dlg.TextInPut;
lay.SetAttribute("ParentID", dlg.ParentID);
}
}
else
{
return;
}
InitData(strSvgDataUid);
}
private void simpleButton1_Click_1(object sender, EventArgs e)
{
string text1 = textEdit1.Text;
string text2 = textEdit2.Text;
if (textEdit1.Text == "")
{
MessageBox.Show("请指定要复制的年份。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textEdit1.Focus();
return;
}
if (textEdit2.Text == "")
{
MessageBox.Show("请指定要复制到的目标年份。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
textEdit2.Focus();
return;
}
LayerGrade gra = new LayerGrade();
gra.Name = text2 + "%";
IList <LayerGrade> list = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeByYear", gra);
if (list.Count == 0)
{
MessageBox.Show("没有找到指定的年份信息，请先建立对应年份的图层分级。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int itemcount = checkedListBox1.Items.Count;
if (checkedListBox1.Items != null)
{
f.SetText("复制中，请等待......");
f.Show();
for (int num = 0; num < itemcount; num++)
{
string itemname = checkedListBox1.Items[num].ToString();
string item4 = itemname.Substring(0, 4);
if ((item4 == text1) && (text2 != "") && checkedListBox1.GetItemChecked(num) == true)
{
Layer layer = this.checkedListBox1.Items[num] as Layer;
f.SetText("共选择" + checkedListBox1.CheckedItems.Count + "层，正在复制" + layer.Label + "层。");
string str = layer.GetAttribute("layerType");
Layer layer2 = CopyLayer2(layer, text2);
if (layer2 != null)
{
if (layer.Visible)
{
layer.Visible = false;
layer.Visible = true;
}
layer2.SetAttribute("layerType", str);
this.checkedListBox1.Items.Add(layer2);
layer2.Visible = false;
string xml = "";
XmlNodeList oldList = symbolDoc.SelectNodes("//*[@layer=\"" + layer2.ID + "\"]");
for (int i = 0; i < oldList.Count; i++)
{
xml = xml + ((SvgElement)oldList[i]).OuterXml;
}
SVG_LAYER obj = new SVG_LAYER();
obj.SUID = layer2.ID;
obj.svgID = symbolDoc.SvgdataUid;
obj.NAME = layer2.Label;
obj.MDATE = System.DateTime.Now;
obj.OrderID = num + 10;
obj.YearID = ((LayerGrade)list[0]).SUID;
obj.layerType = "电网规划层";
obj.visibility = "visible";
obj.IsSelect = "true";
obj.XML = xml;
Services.BaseService.Create <SVG_LAYER>(obj);
}
}
}
f.Hide();
}
}
private void button5_Click_1(object sender, EventArgs e)
{
DataTable dt = new DataTable();
frmGHDeviceList frmDevList = new frmGHDeviceList();
frmDevList.ProjectID = Itop.Client.MIS.ProgUID;
frmDevList.ProjectSUID = ctrlPSP_GProg1.FocusedObject.UID;
frmDevList.Init();
if (frmDevList.ShowDialog() == DialogResult.OK)
{
foreach (DataRow row in frmDevList.DT.Rows)
{
try {
if ((bool)row["C"])
{
PSP_GprogElevice elcDevice = new PSP_GprogElevice();
elcDevice.DeviceSUID = row["A"].ToString();
elcDevice.GprogUID = ctrlPSP_GProg1.FocusedObject.UID;
elcDevice = (PSP_GprogElevice)Services.BaseService.GetObject("SelectPSP_GprogEleviceByKey", elcDevice);
if (elcDevice != null)
{
elcDevice.Type = row["D"].ToString();
elcDevice.L2 = "0";
Services.BaseService.Update <PSP_GprogElevice>(elcDevice);
}
else
{
elcDevice = new PSP_GprogElevice();
elcDevice.DeviceSUID = row["A"].ToString();
elcDevice.GprogUID = ctrlPSP_GProg1.FocusedObject.UID;
elcDevice.Type = row["D"].ToString();
elcDevice.L2 = "0";
Services.BaseService.Create <PSP_GprogElevice>(elcDevice);
}
}
else
{
PSP_GprogElevice elcDevice = new PSP_GprogElevice();
elcDevice.DeviceSUID = row["A"].ToString();
elcDevice.GprogUID = ctrlPSP_GProg1.FocusedObject.UID;
Services.BaseService.Delete <PSP_GprogElevice>(elcDevice);
}
} catch (System.Exception ex) {
}
}
}
else
{
return;
}
//在此处将其选择的元件设备的属性进行更改
LayerGrade l1 = new LayerGrade();
l1.Type = "1";
l1.SvgDataUid = svguid;
IList ttlist = Services.BaseService.GetList("SelectLayerGradeList5", l1);
int yy1 = System.DateTime.Now.Year, yy2 = System.DateTime.Now.Year, yy3 = System.DateTime.Now.Year;
if (ttlist.Count > 0)
{
LayerGrade n1 = (LayerGrade)ttlist[0];
yy1 = Convert.ToInt32(n1.Name.Substring(0, 4));
}
l1.Type = "2";
l1.SvgDataUid = svguid;
ttlist = Services.BaseService.GetList("SelectLayerGradeList5", l1);
if (ttlist.Count > 0)
{
LayerGrade n1 = (LayerGrade)ttlist[0];
yy2 = Convert.ToInt32(n1.Name.Substring(0, 4));
}
l1.Type = "3";
l1.SvgDataUid = svguid;
ttlist = Services.BaseService.GetList("SelectLayerGradeList5", l1);
if (ttlist.Count > 0)
{
LayerGrade n1 = (LayerGrade)ttlist[0];
yy3 = Convert.ToInt32(n1.Name.Substring(0, 4));
}
string con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '变电站'";
IList list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con);
foreach (PSP_GprogElevice pg in list)
{
PSP_Substation_Info ps = new PSP_Substation_Info();
ps.UID = pg.DeviceSUID;
ps = (PSP_Substation_Info)Services.BaseService.GetObject("SelectPSP_Substation_InfoByKey", ps);
if (ps != null)
{
int s2 = 0;
if (!string.IsNullOrEmpty(ps.S2))
{
s2 = Convert.ToInt32(ps.S2);
}
if (s2 <= System.DateTime.Now.Year)
{
pg.L1 = "现行";
}
else if (s2 > System.DateTime.Now.Year && Convert.ToInt32(ps.S2) <= yy1)
{
pg.L1 = "近期";
}
else if (s2 > yy1 && Convert.ToInt32(ps.S2) <= yy2)
{
pg.L1 = "中期";
}
else if (s2 > yy2 && Convert.ToInt32(ps.S2) <= yy3)
{
pg.L1 = "远期";
}
Services.BaseService.Update <PSP_GprogElevice>(pg);
}
else
{
Services.BaseService.Delete <PSP_GprogElevice>(pg);
}
}
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '电源'";
list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con);
foreach (PSP_GprogElevice pg in list)
{
PSP_PowerSubstation_Info ps = new PSP_PowerSubstation_Info();
ps.UID = pg.DeviceSUID;
ps = (PSP_PowerSubstation_Info)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoByKey", ps);
if (ps != null)
{
int s2 = 0;
if (!string.IsNullOrEmpty(ps.S3))
{
s2 = Convert.ToInt32(ps.S3);
}
if (s2 <= System.DateTime.Now.Year)
{
pg.L1 = "现行";
}
else if (s2 > System.DateTime.Now.Year && Convert.ToInt32(ps.S3) <= yy1)
{
pg.L1 = "近期";
}
else if (s2 > yy1 && Convert.ToInt32(ps.S3) <= yy2)
{
pg.L1 = "中期";
}
else if (s2 > yy2 && Convert.ToInt32(ps.S3) <= yy3)
{
pg.L1 = "远期";
}
Services.BaseService.Update <PSP_GprogElevice>(pg);
}
else
{
Services.BaseService.Delete <PSP_GprogElevice>(pg);
}
}
//变电站里判断两绕和三绕是哪个时期的
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '变电站'";
list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con);
foreach (PSP_GprogElevice pg in list)
{
con = "c.UID='" + pg.DeviceSUID + "'and a.Type='02'and a.ProjectID='" + Itop.Client.MIS.ProgUID + "'";
IList uidlist = Services.BaseService.GetList("SelectPSPDEV_byqSUID", con);
foreach (string uid in uidlist)
{
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '两绕组变压器'AND DeviceSUID='" + uid + "'";
PSP_GprogElevice pglr = (PSP_GprogElevice)Services.BaseService.GetObject("SelectPSP_GprogEleviceByCondition", con);
if (pglr != null)
{
pglr.L1 = pg.L1;
Services.BaseService.Update <PSP_GprogElevice>(pglr);
}
}
con = "c.UID='" + pg.DeviceSUID + "'and a.Type='03'and a.ProjectID='" + Itop.Client.MIS.ProgUID + "'";
uidlist = Services.BaseService.GetList("SelectPSPDEV_byqSUID", con);
foreach (string uid in uidlist)
{
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '三绕组变压器'AND DeviceSUID='" + uid + "'";
PSP_GprogElevice pglr = (PSP_GprogElevice)Services.BaseService.GetObject("SelectPSP_GprogEleviceByCondition", con);
if (pglr != null)
{
pglr.L1 = pg.L1;
Services.BaseService.Update <PSP_GprogElevice>(pglr);
}
}
}
//发电厂里两绕和三绕组是哪个时期的
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '电源'";
list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con);
foreach (PSP_GprogElevice pg in list)
{
con = "c.UID='" + pg.DeviceSUID + "'and a.Type='02'and a.ProjectID='" + Itop.Client.MIS.ProgUID + "'";
IList uidlist = Services.BaseService.GetList("SelectPSPDEV_byqSUID", con);
foreach (string uid in uidlist)
{
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '两绕组变压器'AND DeviceSUID='" + uid + "'";
PSP_GprogElevice pglr = (PSP_GprogElevice)Services.BaseService.GetObject("SelectPSP_GprogEleviceByCondition", con);
if (pglr != null)
{
pglr.L1 = pg.L1;
Services.BaseService.Update <PSP_GprogElevice>(pglr);
}
}
con = "c.UID='" + pg.DeviceSUID + "'and a.Type='03'and a.ProjectID='" + Itop.Client.MIS.ProgUID + "'";
uidlist = Services.BaseService.GetList("SelectPSPDEV_byqSUID", con);
foreach (string uid in uidlist)
{
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '三绕组变压器'AND DeviceSUID='" + uid + "'";
PSP_GprogElevice pglr = (PSP_GprogElevice)Services.BaseService.GetObject("SelectPSP_GprogEleviceByCondition", con);
if (pglr != null)
{
pglr.L1 = pg.L1;
Services.BaseService.Update <PSP_GprogElevice>(pglr);
}
}
}
//判断设备参数中有没有在规划设备中的两绕，三绕组变压器，发电机和负荷 如果没有则删掉
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND (Type= '两绕组变压器'or Type= '三绕组变压器'or Type= '负荷'or Type= '发电机')";
list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con);
foreach (PSP_GprogElevice pg in list)
{
PSPDEV ps = new PSPDEV();
ps.SUID = pg.DeviceSUID;
ps = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByKey", ps);
if (ps == null)
{
Services.BaseService.Delete <PSP_GprogElevice>(pg);
}
}
//线路信息
con = "GprogUID = '" + ctrlPSP_GProg1.FocusedObject.UID + "' AND Type= '线路'";
list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con);
foreach (PSP_GprogElevice pg in list)
{
PSPDEV ps = new PSPDEV();
ps.SUID = pg.DeviceSUID;
ps = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByKey", ps);
if (ps != null)
{
int s2 = 0;
if (!string.IsNullOrEmpty(ps.OperationYear))
{
s2 = Convert.ToInt32(ps.OperationYear);
}
if (s2 <= System.DateTime.Now.Year)
{
pg.L1 = "运行";
ps.LineStatus = "运行";
}
else
{
pg.L1 = "待选";
ps.LineStatus = "待选";
}
Services.BaseService.Update <PSP_GprogElevice>(pg);
Services.BaseService.Update <PSPDEV>(ps);
}
else
{
Services.BaseService.Delete <PSP_GprogElevice>(pg);
}
}
}
public void InitData()
{
IList svglist = Services.BaseService.GetList("SelectLayerFileList", svg);
LayerGrade lg = new LayerGrade();
IList ilist = Services.BaseService.GetList("SelectLayerGradeList", lg);
DataTable dataTable = DataConverter.ToDataTable(ilist, typeof(LayerGrade));
SVG_LAYER sl = new SVG_LAYER();
IList list = Services.BaseService.GetList("SelectSVG_LAYERList", sl);
treeList1.DataSource = dataTable;
string ide = treeList1.Nodes[0].GetValue(0).ToString();//获取某一节点的值
foreach (SVG_LAYER lay in list)
{
if (lay.layerType == "电网规划层")
{
LayerGrade obj = new LayerGrade();
obj.SUID = lay.SUID;
obj.Name = lay.NAME;
obj.ParentID = lay.YearID;
string tempobj = "";
string tempyear = "";
if (obj.Name.ToString().Length >= 3)
{
tempobj = obj.Name.ToString().Substring(obj.Name.ToString().Length - 3, 3);
}
if (obj.Name.ToString().Length >= 4)
{
tempyear = obj.Name.ToString().Substring(0, 4);
}
if (tempobj == "变电站")
{
for (int j = 0; j < treeList1.Nodes.Count; j++)
{
if (treeList1.Nodes[j].GetValue(0).ToString().Length > 3)
{
if (treeList1.Nodes[j].GetValue(0).ToString().Substring(0, 4) == tempyear)
{
substation _substat = new substation();
_substat.LayerID = obj.SUID;
_substat.ObligateField1 = "220";
IList subList = Services.BaseService.GetList("SelectsubstationByLayerIDandObligateField1", _substat);
int templ = treeList1.Nodes[j].Nodes.Count;
treeList1.AppendNode(obj.Name, treeList1.Nodes[j]);
treeList1.Nodes[j].Nodes[templ].SetValue(0, obj.Name);
if (subList.Count != 0)
{
int jj = 0;
foreach (substation temps in subList)
{
treeList1.AppendNode(temps, treeList1.Nodes[j].Nodes[templ]);
treeList1.Nodes[j].Nodes[templ].Nodes[jj].SetValue(0, temps.EleName);
jj++;
}
}
_substat.ObligateField1 = "110";
subList = Services.BaseService.GetList("SelectsubstationByLayerIDandObligateField1", _substat);
templ = treeList1.Nodes[j].Nodes.Count;
treeList1.AppendNode(obj.Name, treeList1.Nodes[j]);
treeList1.Nodes[j].Nodes[templ].SetValue(0, obj.Name);
if (subList.Count != 0)
{
int jj = 0;
foreach (substation temps in subList)
{
treeList1.AppendNode(temps, treeList1.Nodes[j].Nodes[templ]);
treeList1.Nodes[j].Nodes[templ].Nodes[jj].SetValue(0, temps.EleName);
jj++;
}
}
_substat.ObligateField1 = "66";
subList = Services.BaseService.GetList("SelectsubstationByLayerIDandObligateField1", _substat);
templ = treeList1.Nodes[j].Nodes.Count;
treeList1.AppendNode(obj.Name, treeList1.Nodes[j]);
treeList1.Nodes[j].Nodes[templ].SetValue(0, obj.Name);
if (subList.Count != 0)
{
int jj = 0;
foreach (substation temps in subList)
{
treeList1.AppendNode(temps, treeList1.Nodes[j].Nodes[templ]);
treeList1.Nodes[j].Nodes[templ].Nodes[jj].SetValue(0, temps.EleName);
jj++;
}
}
_substat.ObligateField1 = "500";
subList = Services.BaseService.GetList("SelectsubstationByLayerIDandObligateField1", _substat);
templ = treeList1.Nodes[j].Nodes.Count;
treeList1.AppendNode(obj.Name, treeList1.Nodes[j]);
treeList1.Nodes[j].Nodes[templ].SetValue(0, obj.Name);
if (subList.Count != 0)
{
int jj = 0;
foreach (substation temps in subList)
{
treeList1.AppendNode(temps, treeList1.Nodes[j].Nodes[templ]);
treeList1.Nodes[j].Nodes[templ].Nodes[jj].SetValue(0, temps.EleName);
jj++;
}
}
}
}
}
}
}
}
Application.DoEvents();
}
public void InitData(string svgDataUid)
{
#region MyRegion
// /* 原有区分关联图层功能代码 _lgm
ilist2.Clear();
strSvgDataUid = svgDataUid;
LayerGrade lg = new LayerGrade();
lg.SvgDataUid = svgDataUid;
ilist = Services.BaseService.GetList("SelectLayerGradeListBySvgDataUid", lg);
//----------------按项目关联年份分级-------------------
Psp_ProgLayerList p = new Psp_ProgLayerList();
p.ProgUID = MIS.ProgUID;
IList <Psp_ProgLayerList> _plist = Services.BaseService.GetList <Psp_ProgLayerList>("SelectPsp_ProgLayerListListByProgUID", p);
for (int i = 0; i < ilist.Count; i++)
{
for (int j = 0; j < _plist.Count; j++)
{
if (((LayerGrade)ilist[i]).SUID == _plist[j].LayerGradeID)
{
ilist2.Add(ilist[i]);
continue;
}
}
}
//ilist2.Clear();
//strSvgDataUid = svgDataUid;
//LayerGrade lg = new LayerGrade();
//lg.SvgDataUid = svgDataUid;
//ilist = Services.BaseService.GetList("SelectLayerGradeListBySvgDataUid", lg);
////----------------按项目关联年份分级-------------------
//Psp_ProgLayerList p = new Psp_ProgLayerList();
//p.ProgUID = MIS.ProgUID;
//IList<Psp_ProgLayerList> _plist = Services.BaseService.GetList<Psp_ProgLayerList>("SelectPsp_ProgLayerListListByProgUID", p);
//for (int i = 0; i < ilist.Count; i++) {
// ilist2.Add(ilist[i]);
//}
#endregion
//-----------------------------------------------------
//ilist = Services.BaseService.GetList<PspType>();
dataTable = DataConverter.ToDataTable(ilist2, typeof(LayerGrade));
IList list = this.SymbolDoc.getLayerList();
foreach (Layer lay in list)
{
if (lay.GetAttribute("layerType") == "电网规划层")
{
LayerGrade obj = new LayerGrade();
obj.SUID = lay.ID;
obj.Name = lay.Label;
obj.ParentID = lay.GetAttribute("ParentID");
dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow()));
}
}
treeList1.DataSource = dataTable;
Application.DoEvents();
treeList1.FocusedNode = null;
treeList1.CollapseAll();
}
