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(); }