private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
dt.Clear();
object obj = comboBox1.SelectedItem;
if (obj != null)
{
DataRowView row1 = obj as DataRowView;
string id = row1.Row["id"].ToString();
IList list = null;
if (id == "20")
{
string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "'";
list = Services.BaseService.GetList("SelectPSP_Substation_InfoListByWhere", con);
foreach (PSP_Substation_Info dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.UID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "变电站";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = true;
row["D"] = "变电站";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = false;
row["D"] = "变电站";
dt.Rows.Add(row);
}
}
}
else if (id == "30")
{
string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "'";
list = Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", con);
foreach (PSP_PowerSubstation_Info dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.UID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "电源";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = true;
row["D"] = "电源";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = false;
row["D"] = "电源";
dt.Rows.Add(row);
}
}
}
else if (id == "05")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "线路";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "线路";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "线路";
dt.Rows.Add(row);
}
}
}
else if (id == "02")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "两绕组变压器";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "两绕组变压器";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "两绕组变压器";
dt.Rows.Add(row);
}
}
}
else if (id == "03")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "三绕组变压器";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "三绕组变压器";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "三绕组变压器";
dt.Rows.Add(row);
}
}
}
else if (id == "04")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "发电机";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "发电机";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "发电机";
dt.Rows.Add(row);
}
}
}
else if (id == "12")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "负荷";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "负荷";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "负荷";
dt.Rows.Add(row);
}
}
}
}
gridControl1.DataSource = dt;
}
public void Init()
{
dt.Columns.Add("A");
dt.Columns.Add("B");
dt.Columns.Add("C", typeof(bool));
dt.Columns.Add("D");
//Stream fs = Assembly.GetExecutingAssembly().GetManifestResourceStream("Itop.TLPSP.DEVICE.devicetypes.xml");
string path = System.Windows.Forms.Application.StartupPath + "\\" + "devicetypes.xml";
//Assembly.GetExecutingAssembly().GetManifestResourceStream
XmlDocument xml = new XmlDocument();
xml.Load(path);
XmlNodeList nodes = xml.GetElementsByTagName("device");
DataTable table = new DataTable();
table.Columns.Add("id", typeof(string));
table.Columns.Add("name", typeof(string));
table.Columns.Add("class", typeof(string));
foreach (XmlNode node in nodes)
{
if (((XmlElement)node).GetAttribute("name") == "变电站" || ((XmlElement)node).GetAttribute("name") == "电源" || ((XmlElement)node).GetAttribute("name") == "线路" || ((XmlElement)node).GetAttribute("name") == "两绕组变压器" || ((XmlElement)node).GetAttribute("name") == "三绕组变压器" || ((XmlElement)node).GetAttribute("name") == "发电机" || ((XmlElement)node).GetAttribute("name") == "负荷")
{
DataRow row = table.NewRow();
row["id"] = node.Attributes["id"].Value;
row["name"] = node.Attributes["name"].Value;
row["class"] = node.Attributes["class"].Value;
table.Rows.Add(row);
}
}
comboBox1.DataSource = table;
comboBox1.DisplayMember = "name";
{
dt.Clear();
object obj = comboBox1.SelectedItem;
if (obj != null)
{
DataRowView row1 = obj as DataRowView;
string id = row1.Row["id"].ToString();
IList list = null;
if (id == "20")
{
string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "'";
list = Services.BaseService.GetList("SelectPSP_Substation_InfoListByWhere", con);
foreach (PSP_Substation_Info dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.UID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "变电站";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = true;
row["D"] = "变电站";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = false;
row["D"] = "变电站";
dt.Rows.Add(row);
}
}
}
else if (id == "30")
{
string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "'";
list = Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", con);
foreach (PSP_PowerSubstation_Info dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.UID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "电源";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = true;
row["D"] = "电源";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.UID;
row["B"] = dev.Title;
row["C"] = false;
row["D"] = "电源";
dt.Rows.Add(row);
}
}
}
else if (id == "05")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "线路";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "线路";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "线路";
dt.Rows.Add(row);
}
}
}
else if (id == "02")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "两绕组变压器";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "两绕组变压器";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "两绕组变压器";
dt.Rows.Add(row);
}
}
}
else if (id == "03")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "三绕组变压器";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "三绕组变压器";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "三绕组变压器";
dt.Rows.Add(row);
}
}
}
else if (id == "04")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "发电机";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "发电机";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "发电机";
dt.Rows.Add(row);
}
}
}
else if (id == "12")
{
string con = " where type = '" + id + "'";
string con2 = " and ProjectID = '" + this.ProjectID + "'";
con = con + con2;
list = Services.BaseService.GetList("SelectPSPDEVByCondition", con);
foreach (PSPDEV dev in list)
{
PSP_GprogElevice pspDev = new PSP_GprogElevice();
pspDev.DeviceSUID = dev.SUID;
pspDev.GprogUID = ProjectSUID;
pspDev.Type = "负荷";
IList list1 = Services.BaseService.GetList("SelectPSP_GprogEleviceByKey", pspDev);
if (list1.Count > 0)
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = true;
row["D"] = "负荷";
dt.Rows.Add(row);
}
else
{
DataRow row = dt.NewRow();
row["A"] = dev.SUID;
row["B"] = dev.Name;
row["C"] = false;
row["D"] = "负荷";
dt.Rows.Add(row);
}
}
}
}
gridControl1.DataSource = dt;
}
}
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);
}
}
}
