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 Calc(string addConn) { int x5 = 1, x1 = 1, x1z = 1, x2 = 1, x2z = 1, x35 = 1, x35z = 1, x10 = 1, x10z = 1, x6 = 1, x6z = 1, t5 = 0, t2 = 0, t2z = 0, t1 = 0, t1z = 0, t35 = 0, t35z = 0, t10 = 0, t10z = 0, t6 = 0, t6z = 0; double h5 = 0, h1 = 0, h1z = 0, h2 = 0, h2z = 0, h35 = 0, h35z = 0, h10 = 0, h10z = 0, h6 = 0, h6z = 0, z5 = 0, z1 = 0, z1z = 0, z2 = 0, z2z = 0, z35 = 0, z35z = 0, z10 = 0, z10z = 0, z6 = 0, z6z = 0; ; int index5 = -1, index2 = -1, index2z = -1, index1 = -1, index1z = -1, index35 = -1, index35z = -1, index10 = -1, index10z = -1, index6 = -1, index6z = -1; Hashtable table = new Hashtable(); Hashtable table_500 = new Hashtable(); Hashtable table_220 = new Hashtable(); Hashtable table_220z = new Hashtable(); Hashtable table_35 = new Hashtable(); Hashtable table_35z = new Hashtable(); Hashtable table_10 = new Hashtable(); Hashtable table_10z = new Hashtable(); Hashtable table_6 = new Hashtable(); Hashtable table_6z = new Hashtable(); IList<string> groupList_500 = new List<string>(); IList<string> groupList_220 = new List<string>(); IList<string> groupList_220z = new List<string>(); IList<string> groupList_35 = new List<string>(); IList<string> groupList_35z = new List<string>(); IList<string> groupList_10 = new List<string>(); IList<string> groupList_10z = new List<string>(); IList<string> groupList_6 = new List<string>(); IList<string> groupList_6z = new List<string>(); bool five = true, one = true, onez = true, two = true, twoz = true, three = true, threez = true, ten = true, tenz = true, six = true, sixz = true; string area = "1@3$5q99z99"; string area_500 = "1@3$5q99z99"; string area_220 = "1@3$5q99z99"; string area_220z = "1@3$5q99z99"; string area_35 = "1@3$5q99z99"; string area_35z = "1@3$5q99z99"; string area_10 = "1@3$5q99z99"; string area_10z = "1@3$5q99z99"; string area_6 = "1@3$5q99z99"; string area_6z = "1@3$5q99z99"; int j = 0; int now = 0; string con = "AreaID='" + projectid + "'";// +" and Flag='" + Ghflag + "'"; // con += addConn; con += " order by convert(int,S1) desc,S4,AreaName,CreateDate,convert(int,S5)"; string[] que = new string[60] { "һ", "��", "��", "��", "��", "��", "��", "��", "��", "ʮ", "ʮһ","ʮ��","ʮ��","ʮ��","ʮ��","ʮ��","ʮ��","ʮ��","ʮ��","��ʮ","��ʮһ","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��", "��ʮ��","��ʮ��","��ʮ","��ʮһ","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ","��ʮһ","��ʮ��","��ʮ��","��ʮ��", "��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ","��ʮһ","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ��","��ʮ"}; titlestr = que; //IList list = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoByCon", con); IList list = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", con); if (!string.IsNullOrEmpty(addConn)) { List<PSP_PowerSubstation_Info> listremove = new List<PSP_PowerSubstation_Info>(); for (int i = 0; i < list.Count;i++ ) { if (((PSP_PowerSubstation_Info)list[i]).S3.Length != 4) { listremove.Add((PSP_PowerSubstation_Info)list[i]); } else { if (Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S3)>Convert.ToDouble(addConn)) { listremove.Add((PSP_PowerSubstation_Info)list[i]); } } } for (int i = 0; i < listremove.Count;i++ ) { list.Remove(listremove[i]); } for (int i = 0; i < list.Count;i++ ) { double rl=0; int bts=0; string where = "where projectid='" + Itop.Client.MIS.ProgUID + "'and type='04'and SvgUID='" + ((PSP_PowerSubstation_Info)list[i]).UID + "'"; IList<PSPDEV> list1 = Services.BaseService.GetList<PSPDEV>("SelectPSPDEVByCondition", where); foreach (PSPDEV pd in list1) { if (!string.IsNullOrEmpty(pd.OperationYear) && Convert.ToInt32(pd.OperationYear) <= Convert.ToDouble(addConn)) { if (!string.IsNullOrEmpty(pd.OperationYear) && !string.IsNullOrEmpty(pd.Date2) && pd.Date2.Length == 4 && !string.IsNullOrEmpty(((PSP_PowerSubstation_Info)list[i]).S29) && !string.IsNullOrEmpty(((PSP_PowerSubstation_Info)list[i]).S30)) { if (Convert.ToInt32(pd.OperationYear) >= Convert.ToInt32(((PSP_PowerSubstation_Info)list[i]).S29) && Convert.ToInt32(pd.Date2) <= Convert.ToInt32(((PSP_PowerSubstation_Info)list[i]).S30)) { rl += pd.P0; bts++; } } else { rl += (double)pd.P0; bts++; } } } ((PSP_PowerSubstation_Info)list[i]).S2 = rl.ToString(); } } string conn = "L1=110"; // IList groupList = Common.Services.BaseService.GetList("SelectAreaNameGroupByConn", conn); IList<string> groupList = new List<string>(); Hashtable table2 = new Hashtable(); IList<string> groupList2 = new List<string>(); string area2 = "1@3$5q99z99"; for (int i = 0; i < list.Count; i++) { if (((PSP_PowerSubstation_Info)list[i]).S1 == "500" ) { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_500) { if (!table_500.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_500.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_500.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_500 = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (five) { index5 = i; five = false; } ((PSP_PowerSubstation_Info)list[i]).S3 = x5.ToString(); h5 += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z5 += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t5 += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} // catch { } x5++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "220" && ((PSP_PowerSubstation_Info)list[i]).S8 == "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_220z) { if (!table_220z.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_220z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_220z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); // table[((PSP_PowerSubstation_Info)list[i]).AreaName] = i; } area_220z = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (twoz) { index2z = i; twoz = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x2z.ToString(); h2z +=Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2) ; //try //{ // z2z += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t2z += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x2z++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "220"&& ((PSP_PowerSubstation_Info)list[i]).S8 != "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_220) { if (!table_220.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_220.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_220.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); // table[((PSP_PowerSubstation_Info)list[i]).AreaName] = i; } area_220 = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (two) { index2 = i; two = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x2.ToString(); h2 += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z2 += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t2 += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x2++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "110" && ((PSP_PowerSubstation_Info)list[i]).S8 == "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area2) { if (!table2.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table2.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList2.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); // table[((PSP_PowerSubstation_Info)list[i]).AreaName] = i; } area2 = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (onez) { index1z = i; onez = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x1z.ToString(); h1z +=Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2) ; //try //{ // z1z += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t1z += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x1z++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "110" && ((PSP_PowerSubstation_Info)list[i]).S8 != "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area) { if (!table.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); // table[((PSP_PowerSubstation_Info)list[i]).AreaName] = i; } area = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (one) { index1 = i; one = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x1.ToString(); h1 += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z1 += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t1 += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x1++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "35" && ((PSP_PowerSubstation_Info)list[i]).S8 == "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_35z) { if (!table_35z.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_35z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_35z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_35z = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (threez) { index35z = i; threez = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x35z.ToString(); h35z += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z35z += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t35z += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x35z++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "35" && ((PSP_PowerSubstation_Info)list[i]).S8 != "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_35) { if (!table_35.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_35.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_35.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_35 = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (three) { index35 = i; three = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x35.ToString(); h35 +=Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2) ; //try //{ // z35 += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t35 += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x35++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "10" && ((PSP_PowerSubstation_Info)list[i]).S8 == "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_10z) { if (!table_10z.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_10z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_10z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_10z = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (tenz) { index10z = i; tenz = false; } ((PSP_PowerSubstation_Info)list[i]).S20= x10z.ToString(); h10z += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z10z += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t10z += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x10z++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "10" && ((PSP_PowerSubstation_Info)list[i]).S8 != "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_10) { if (!table_10.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_10.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_10.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_10 = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (ten) { index10 = i; ten = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x10.ToString(); h10 += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z10 += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t10 += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x10++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 == "6" && ((PSP_PowerSubstation_Info)list[i]).S8 == "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_6z) { if (!table_6z.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_6z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_6z.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_6z = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (sixz) { index6z = i; sixz = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x6z.ToString(); h6z += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z6z += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t6z += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x6z++; } else if (((PSP_PowerSubstation_Info)list[i]).S1 =="6" && ((PSP_PowerSubstation_Info)list[i]).S8 != "ר��") { if (((PSP_PowerSubstation_Info)list[i]).AreaName != area_6) { if (!table_6.Contains(((PSP_PowerSubstation_Info)list[i]).AreaName)) { table_6.Add(((PSP_PowerSubstation_Info)list[i]).AreaName, i); groupList_6.Add(((PSP_PowerSubstation_Info)list[i]).AreaName); } area_6 = ((PSP_PowerSubstation_Info)list[i]).AreaName; } if (six) { index6 = i; six = false; } ((PSP_PowerSubstation_Info)list[i]).S20 = x6.ToString(); h6 += Convert.ToDouble(((PSP_PowerSubstation_Info)list[i]).S2); //try //{ // z6 += double.Parse(((PSP_PowerSubstation_Info)list[i]).L5); //} //catch { } //try //{ // t6 += (int)((PSP_PowerSubstation_Info)list[i]).L3; //} //catch { } x6++; } } if (x5 > 1) { PSP_PowerSubstation_Info info = new PSP_PowerSubstation_Info(); info.S20 = que[j]; j++; info.Title = "500ǧ��"; info.S2 = h5.ToString(); //info.L5 = z5.ToString(); //info.L3 = t5; info.S11 = "500"; info.S8 = "no"; list.Insert(index5, info);//.Add(info); now++; for (int k = 0; k < groupList_500.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList[k]; infok.AreaName = groupList_500[k]; conn = "S1='500' and AreaID='" + projectid + "' and AreaName='" + groupList_500[k] + "'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; //infok.L5 = ((PSP_PowerSubstation_Info)temList[0]).L5; infok.S1 = "500"; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_500[groupList_500[k]].ToString()) + now, infok); now++; } } if (x2 > 1) { PSP_PowerSubstation_Info info2 = new PSP_PowerSubstation_Info(); info2.S20 = que[j]; j++; info2.Title = "220ǧ������"; info2.S2 = h2.ToString(); info2.S1 = "220"; info2.S8 = "no"; list.Insert(index2 + now, info2); now++; for (int k = 0; k < groupList_220.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList[k]; infok.AreaName = groupList_220[k]; conn = "S1='220' and AreaID='" + projectid + "' and AreaName='" + groupList_220[k] + "'and S8!='ר��'" ; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "220"; infok.S4 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_220[groupList_220[k]].ToString()) + now, infok); now++; } } if (x2z > 1) { PSP_PowerSubstation_Info info2z = new PSP_PowerSubstation_Info(); info2z.S20 = que[j]; j++; info2z.Title = "220ǧ��ר��"; info2z.S2 = h2z.ToString(); info2z.S1 = "220"; info2z.S8 = "no"; list.Insert(index2z + now, info2z); now++; for (int k = 0; k < groupList_220z.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList2[k]; infok.AreaName = groupList_220z[k]; conn = "S1='220' and AreaID='" + projectid + "' and AreaName='" + groupList_220z[k] + "' and S8='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "220"; infok.S4 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_220z[groupList_220z[k]].ToString()) + now, infok); now++; } } if (x1 > 1) { PSP_PowerSubstation_Info info1 = new PSP_PowerSubstation_Info(); info1.S20 = que[j]; j++; info1.Title = "110ǧ������"; info1.S2 = h1.ToString(); info1.S1 = "110"; info1.S8 = "no"; list.Insert(index1 + now, info1); now++; for (int k = 0; k < groupList.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList[k]; infok.AreaName = groupList[k]; conn = "S1='110' and AreaID='" + projectid + "' and AreaName='" + groupList[k] + "' and S8!='ר��'" ; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "110"; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table[groupList[k]].ToString()) + now, infok); now++; } } if (x1z > 1) { PSP_PowerSubstation_Info info1z = new PSP_PowerSubstation_Info(); info1z.S20= que[j]; j++; info1z.Title = "110ǧ��ר��"; info1z.S2 = h1z.ToString(); info1z.S1 = "110"; info1z.S8 = "no"; list.Insert(index1z + now, info1z); now++; for (int k = 0; k < groupList2.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20= Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList2[k]; infok.AreaName = groupList2[k]; conn = "S1='110 'and AreaID='" + projectid + "' and AreaName='" + groupList2[k] + "' and S8='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "110"; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table2[groupList2[k]].ToString()) + now, infok); now++; } } if (x35 > 1) { PSP_PowerSubstation_Info info35 = new PSP_PowerSubstation_Info(); info35.S20 = que[j]; j++; info35.Title = "35ǧ������"; info35.S2 = h35.ToString(); info35.S1 = "35"; info35.S4 = "no"; list.Insert(index35 + now, info35); now++; for (int k = 0; k < groupList_35.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList[k]; infok.AreaName = groupList_35[k]; conn = "S1='35' and AreaID='" + projectid + "' and AreaName='" + groupList_35[k] + "' and S8!='ר��' "; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "35"; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_35[groupList_35[k]].ToString()) + now, infok); now++; } } if (x35z > 1) { PSP_PowerSubstation_Info info35z = new PSP_PowerSubstation_Info(); info35z.S20 = que[j]; j++; info35z.Title = "35ǧ��ר��"; info35z.S2 = h35z.ToString(); info35z.S2 = "35"; info35z.S4 = "no"; list.Insert(index35z + now, info35z); now++; for (int k = 0; k < groupList_35z.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList2[k]; infok.AreaName = groupList_35z[k]; conn = "S1='35' and AreaID='" + projectid + "' and AreaName='" + groupList_35z[k] + "' and S8='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "35"; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_35z[groupList_35z[k]].ToString()) + now, infok); now++; } } if (x10 > 1) { PSP_PowerSubstation_Info info10 = new PSP_PowerSubstation_Info(); info10.S20 = que[j]; j++; info10.Title = "10ǧ������"; info10.S2 = h10.ToString(); info10.S1 = "10"; info10.S8 = "no"; list.Insert(index10 + now, info10); now++; for (int k = 0; k < groupList_10.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList[k]; infok.AreaName = groupList_10[k]; conn = "S1='10' and AreaID='" + projectid + "' and AreaName='" + groupList_10[k] + "' and S8!='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 ="10" ; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_10[groupList_10[k]].ToString()) + now, infok); now++; } } if (x10z > 1) { PSP_PowerSubstation_Info info10z = new PSP_PowerSubstation_Info(); info10z.S20 = que[j]; j++; info10z.Title = "10ǧ��ר��"; info10z.S2 = h10z.ToString(); info10z.S1 = "10"; info10z.S8 = "no"; list.Insert(index10z + now, info10z); now++; for (int k = 0; k < groupList_10z.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList2[k]; infok.AreaName = groupList_10z[k]; conn = "S1='10' and AreaID='" + projectid + "' and AreaName='" + groupList_10z[k] + "' and S8='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "10"; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_10z[groupList_10z[k]].ToString()) + now, infok); now++; } } if (x6 > 1) { PSP_PowerSubstation_Info info6 = new PSP_PowerSubstation_Info(); info6.S20 = que[j]; j++; info6.Title = "6ǧ������"; info6.S2 = h6.ToString(); info6.S1 ="6" ; info6.S8 = "no"; list.Insert(index6 + now, info6); now++; for (int k = 0; k < groupList_6.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList[k]; infok.AreaName = groupList_6[k]; conn = "S1='6' and AreaID='" + projectid + "' and AreaName='" + groupList_6[k] + "' and S8!='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 = "6"; infok.S4 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_6[groupList_6[k]].ToString()) + now, infok); now++; } } if (x6z > 1) { PSP_PowerSubstation_Info info6z = new PSP_PowerSubstation_Info(); info6z.S20= que[j]; j++; info6z.Title = "6ǧ��ר��"; info6z.S2 = h6z.ToString(); info6z.S1 = "6"; info6z.S8= "no"; list.Insert(index6z + now, info6z); now++; for (int k = 0; k < groupList_6z.Count; k++) { PSP_PowerSubstation_Info infok = new PSP_PowerSubstation_Info(); infok.S20 = Convert.ToChar(k + 65).ToString().ToLower(); //infok.Title = groupList2[k]; infok.AreaName = groupList_6z[k]; conn = "S1='6' and AreaID='" + projectid + "' and AreaName='" + groupList_6z[k] + "' and S8='ר��'"; IList temList = Common.Services.BaseService.GetList("SelectSumPSP_PowerSubstation_InfoByConn", conn); infok.S2 = ((PSP_PowerSubstation_Info)temList[0]).S2; infok.S1 ="6" ; infok.S8 = "no"; conn += " and Flag='" + Ghflag + "' order by Title "; temList = Common.Services.BaseService.GetList("SelectPSP_PowerSubstation_InfoListByWhere", conn); list.Insert(int.Parse(table_6z[groupList_6z[k]].ToString()) + now, infok); now++; } } try { //for (int i = 0; i < list.Count; i++) //{ // if (((PSP_PowerSubstation_Info)list[i]).L9 != null && (double)((PSP_PowerSubstation_Info)list[i]).L2 != null) // { // double templ9 = (double)((PSP_PowerSubstation_Info)list[i]).L9; // double templ2 = (double)((PSP_PowerSubstation_Info)list[i]).L2; // ((PSP_PowerSubstation_Info)list[i]).L10 = (templ2 == 0 ? 0 : templ9 / templ2) * 100; // PSP_PowerSubstation_Info tempsub = Common.Services.BaseService.GetOneByKey<PSP_PowerSubstation_Info>(((PSP_PowerSubstation_Info)list[i]).UID); // tempsub.L10 = ((PSP_PowerSubstation_Info)list[i]).L10; // Common.Services.BaseService.Update<PSP_PowerSubstation_Info>(tempsub); // } //} } catch (Exception ew) { MessageBox.Show("���㸺���ʳ���" + ew.Message); } this.gridControl1.DataSource = list; fu_list = list; list_copy(list, fu_list_no); att_list(fu_list_no); }
private void comboBoxEdit1_SelectedIndexChanged(object sender, EventArgs e) { //�������˹�ϵ vistlineflag.Clear(); vistbusflag .Clear(); vistsubstationflag .Clear(); vistpowerflag.Clear(); visttrans2flag.Clear(); visttrans3flag.Clear(); vistfdjflag.Clear(); vistfhflag.Clear(); vistmlflag.Clear(); vistml2flag.Clear(); vistcldkflag.Clear(); vistcldrflag.Clear(); vistbldkflag.Clear(); vistbldrflag.Clear(); vistdlqflag.Clear(); string con = " AreaID = '" + Itop.Client.MIS.ProgUID + "' AND Title='"+comboBoxEdit1.Text+"'"; PSP_Substation_Info list =(PSP_Substation_Info) UCDeviceBase.DataService.GetObject("SelectPSP_Substation_InfoListByWhere", con); vistsubstationflag.Add(list.Title, list); con = "WHERE SvgUID='" + list.UID + "'AND projectid='" + Itop.Client.MIS.ProgUID + "'AND Type='01'"; IList buslist = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); if (buslist!=null) { for (int i = 0; i < buslist.Count;i++ ) { TopolyCheck(type, (PSPDEV)buslist[i]); } foreach (KeyValuePair<string, PSPDEV> keyvalue in vistbusflag) { if (string.IsNullOrEmpty(keyvalue.Value.SvgUID)) { MessageBox.Show(keyvalue.Value.Name + "û�й������վ��", "��ʾ", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } else { if (list == null) return; list.UID = keyvalue.Value.SvgUID; } list.UID=keyvalue.Value.SvgUID; list = (PSP_Substation_Info)UCDeviceBase.DataService.GetObject("SelectPSP_Substation_InfoByKey", list); if (list!=null) { if (!vistsubstationflag.ContainsKey(list.Title)) vistsubstationflag.Add(list.Title, list); } PSP_PowerSubstation_Info pp = new PSP_PowerSubstation_Info(); pp.UID = keyvalue.Value.SvgUID; pp = (PSP_PowerSubstation_Info)UCDeviceBase.DataService.GetObject("SelectPSP_PowerSubstation_InfoByKey", pp); if (pp!=null) { if (!vistpowerflag.ContainsKey(pp.Title)) vistpowerflag.Add(pp.Title, pp); } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='11'"; IList pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistbldkflag.ContainsKey(psp.Name)) { continue; } else { vistbldkflag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='09'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistbldrflag.ContainsKey(psp.Name)) { continue; } else { vistbldrflag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='12'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistfhflag.ContainsKey(psp.Name)) { continue; } else { vistfhflag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='04'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistfdjflag.ContainsKey(psp.Name)) { continue; } else { vistfdjflag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='13'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistmlflag.ContainsKey(psp.Name)) { continue; } else { vistmlflag.Add(psp.Name, psp); } } con = " WHERE JName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='13'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistmlflag.ContainsKey(psp.Name)) { continue; } else { vistmlflag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='06'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistdlqflag.ContainsKey(psp.Name)) { continue; } else { vistdlqflag.Add(psp.Name, psp); } } con = " WHERE HuganLine1='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='14'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistml2flag.ContainsKey(psp.Name)) { continue; } else { vistml2flag.Add(psp.Name, psp); } } con = " WHERE HuganLine2='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='14'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistml2flag.ContainsKey(psp.Name)) { continue; } else { vistml2flag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='02'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (visttrans2flag.ContainsKey(psp.Name)) { continue; } else { visttrans2flag.Add(psp.Name, psp); } } con = " WHERE JName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='02'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (visttrans2flag.ContainsKey(psp.Name)) { continue; } else { visttrans2flag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='03'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (visttrans3flag.ContainsKey(psp.Name)) { continue; } else { visttrans3flag.Add(psp.Name, psp); } } con = " WHERE JName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='03'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (visttrans3flag.ContainsKey(psp.Name)) { continue; } else { visttrans3flag.Add(psp.Name, psp); } } con = " WHERE KName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='03'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (visttrans3flag.ContainsKey(psp.Name)) { continue; } else { visttrans3flag.Add(psp.Name, psp); } } } foreach (KeyValuePair<string, PSPDEV> keyvalue in vistlineflag) { con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='08'"; IList pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistcldrflag.ContainsKey(psp.Name)) { continue; } else { vistcldrflag.Add(psp.Name, psp); } } con = " WHERE IName='" + keyvalue.Value.Name + "' AND ProjectID = '" + Itop.Client.MIS.ProgUID + "'" + "AND Type='10'"; pspline1 = UCDeviceBase.DataService.GetList("SelectPSPDEVByCondition", con); foreach (PSPDEV psp in pspline1) { if (vistcldkflag.ContainsKey(psp.Name)) { continue; } else { vistcldkflag.Add(psp.Name, psp); } } } } else { MessageBox.Show("�˱��վû�����˹�ϵ�����ѯ���ݺ��ٽ��м���!"); } }
public bool RefreshDataOut(string addConn) { try { string filepath = ""; string con = "AreaID='" + projectid + "'"; con += addConn; IList<PSP_PowerSubstation_Info> list = Services.BaseService.GetList<PSP_PowerSubstation_Info>("SelectSubstation_InfoByCon", con); if (xmlflag == "guihua") filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationGuiHua.xml"); else { filepath = Path.GetTempPath() + "\\" + Path.GetFileName("SubstationLayOut11.xml"); } if (File.Exists(filepath)) { this.gridView1.RestoreLayoutFromXml(filepath); } PSP_PowerSubstation_Info info = new PSP_PowerSubstation_Info(); info.Title = "�ϼ�"; //info.L9 = 0.0; //info.L3 = 0; //for (int i = 0; i < list.Count; i++) //{ // info.L5 = Convert.ToString(double.Parse(info.L5 == "" ? "0" : info.L5) + double.Parse((list[i] as Substation_Info).L5 == "" ? "0" : (list[i] as Substation_Info).L5)); // info.L6 = Convert.ToString(double.Parse(info.L6 == "" ? "0" : info.L6) + double.Parse((list[i] as Substation_Info).L6 == "" ? "0" : (list[i] as Substation_Info).L6)); // info.L3 += ((list[i] as Substation_Info).L3 == null ? 0 : (list[i] as Substation_Info).L3); // info.L2 += (list[i] as Substation_Info).L2; // info.L9 += (list[i] as Substation_Info).L9; // info.L14 = Convert.ToString(double.Parse(info.L14 == "" ? "0" : info.L14) + double.Parse((list[i] as Substation_Info).L14 == "" ? "0" : (list[i] as Substation_Info).L14)); // info.L13 = Convert.ToString(double.Parse(info.L13 == "" ? "0" : info.L13) + double.Parse((list[i] as Substation_Info).L13 == "" ? "0" : (list[i] as Substation_Info).L13)); // info.S9 = Convert.ToString(double.Parse(info.S9 == "" ? "0" : info.S9) + double.Parse((list[i] as Substation_Info).S9 == "" ? "0" : (list[i] as Substation_Info).S9)); // info.S10 = Convert.ToString(double.Parse(info.S10 == "" ? "0" : info.S10) + double.Parse((list[i] as Substation_Info).S10 == "" ? "0" : (list[i] as Substation_Info).S10)); //} //info.L10 = (info.L2 == 0 ? 0 : info.L9 / info.L2)*100; //info.S6 = Convert.ToString(double.Parse(info.L13) == 0.0 ? 0 : double.Parse(info.L14 == "" ? "0" : info.L14)*100 / double.Parse(info.L13)); list.Add(info); this.gridControl1.DataSource = list; } catch (Exception exc) { Debug.Fail(exc.Message); HandleException.TryCatch(exc); return false; } return true; }
private void ShowResult(int order, string projectsuid, string FileName, int pspouttype, frnReport wFrom) { try { //删除原来的text文本 //XmlNodeList list = tlVectorControl1.SVGDocument.SelectNodes("svg/*[@flag='" + "1" + "']"); //foreach (XmlNode node in list) //{ // SvgElement element = node as SvgElement; // tlVectorControl1.SVGDocument.CurrentElement = element; // tlVectorControl1.Delete(); //} wFrom.ShowText += "\r\n开始显示计算结果\t" + System.DateTime.Now.ToString(); double yinzi = 0, capability = 0, volt = 0, standvolt = 0, current = 0; PSPDEV benchmark = new PSPDEV(); benchmark.Type = "power"; benchmark.SvgUID = projectsuid; IList list3 = Services.BaseService.GetList("SelectPSPDEVBySvgUIDAndType", benchmark); //if (list3 == null) //{ // MessageBox.Show("请设置基准后再进行计算!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); // return; //} foreach (PSPDEV dev in list3) { yinzi = Convert.ToDouble(dev.PowerFactor); capability = Convert.ToDouble(dev.StandardCurrent); volt = Convert.ToDouble(dev.StandardVolt); TLPSPVmin = dev.iV; TLPSPVmax = dev.jV; if (dev.PowerFactor == 0) { yinzi = 1; } if (dev.StandardCurrent == 0) { capability = 1; } if (dev.StandardVolt == 0) { volt = 1; } standvolt = volt; current = capability / (Math.Sqrt(3) * volt); }; Layer lar = null; if (Layer.CkLayerExist(FileName, tlVectorControl1.SVGDocument)) { ArrayList layercol = tlVectorControl1.SVGDocument.getLayerList(); for (int i = 0; i < layercol.Count; i++) { if (FileName == (layercol[i] as Layer).GetAttribute("label")) { lar = (Layer)layercol[i]; break; } } } else { lar = Layer.CreateNew(FileName, tlVectorControl1.SVGDocument); lar.SetAttribute("layerType", progtype); lar.SetAttribute("ParentID", tlVectorControl1.SVGDocument.CurrentLayer.GetAttribute("ParentID")); this.frmlar.checkedListBox1.SelectedIndex = -1; this.frmlar.checkedListBox1.Items.Add(lar, true); } int size = tlVectorControl1.ScaleRatio > 1 ? 12 : (int)(12 / tlVectorControl1.ScaleRatio); XmlNodeList useList = tlVectorControl1.SVGDocument.SelectNodes("svg/use"); foreach (XmlNode node in useList) { XmlElement element = node as XmlElement; string strCon = null; IList listMX = null; if (pspouttype == 0) { strCon = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectsuid + "' AND SvgUID = '" + (element).GetAttribute("Deviceid") + "' AND Type = '01'"; listMX = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon); } //XmlNode text = tlVectorControl1.SVGDocument.SelectSingleNode("svg/*[@ParentID='" + element.GetAttribute("id") + "']"); if (pspouttype == 1) { bool pspflag = false; PSP_Substation_Info ps = new PSP_Substation_Info(); ps.UID = (element).GetAttribute("Deviceid"); ps = (PSP_Substation_Info)Services.BaseService.GetObject("SelectPSP_Substation_InfoByKey", ps); if (ps != null) { if (ps.Flag == "2") { strCon = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectsuid + "' AND SvgUID = '" + (element).GetAttribute("Deviceid") + "' AND Type = '01'"; listMX = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon); } pspflag = true; } if (!pspflag) { PSP_PowerSubstation_Info ppi = new PSP_PowerSubstation_Info(); ppi.UID = (element).GetAttribute("Deviceid"); ppi = (PSP_PowerSubstation_Info)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoByKey", ppi); if (ppi != null) { if (ppi.Flag == "2") { strCon = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectsuid + "' AND SvgUID = '" + (element).GetAttribute("Deviceid") + "' AND Type = '01'"; listMX = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon); } } } } if (listMX != null) { for (int i = 0; i < listMX.Count; i++) { PSPDEV elementDEV = (PSPDEV)(listMX[i]); PSP_ElcDevice elcDEV = new PSP_ElcDevice(); elcDEV.ProjectSUID = projectsuid; elcDEV.DeviceSUID = ((PSPDEV)listMX[i]).SUID; elcDEV = (PSP_ElcDevice)Services.BaseService.GetObject("SelectPSP_ElcDeviceByKey", elcDEV); if (elcDEV != null) { XmlElement elementn1 = tlVectorControl1.SVGDocument.SelectSingleNode("svg/text[@ layer='" + lar.ID + "'and @ParentID1='" + ((PSPDEV)listMX[i]).SUID + "']") as XmlElement; XmlElement elementn2 = tlVectorControl1.SVGDocument.SelectSingleNode("svg/text[@ layer='" + lar.ID + "'and @ParentID2='" + ((PSPDEV)listMX[i]).SUID + "']") as XmlElement; if (elementn1 == null) { //RectangleF bound = ((IGraph)element).GetBounds(); //XmlElement n1 = tlVectorControl1.SVGDocument.CreateElement("text") as Text; //XmlElement n2 = tlVectorControl1.SVGDocument.CreateElement("text") as Text; //n1.SetAttribute("x", Convert.ToString(bound.X)); //n1.SetAttribute("y", Convert.ToString(bound.Y - i * 20)); //n1.SetAttribute("font-size", size.ToString());//"12"); //n1.InnerText = Convert.ToDouble(GetColValue(elcDEV, order).COL2).ToString("N2"); ////Layer la = tlVectorControl1.SVGDocument.GetLayerByID(element.GetAttribute("layer")); //n1.SetAttribute("layer", lar.ID); ////MessageBox.Show(Convert.ToString(n1.InnerText)); //n1.SetAttribute("flag", "1"); //n1.SetAttribute("ParentID1", ((PSPDEV)listMX[i]).SUID); //if (Convert.ToDouble(GetColValue(elcDEV, order).COL2) > TLPSPVmax * elementDEV.RateVolt / elementDEV.ReferenceVolt || Convert.ToDouble(GetColValue(elcDEV, order).COL2) < TLPSPVmin * elementDEV.RateVolt / elementDEV.ReferenceVolt)//电压越限,需修改 // n1.SetAttribute("stroke", "#FF0000"); //if (elementDEV.NodeType == "0") //{ // n2.SetAttribute("x", Convert.ToString(bound.X)); // n2.SetAttribute("y", Convert.ToString(bound.Y + bound.Height + 20)); // if (Convert.ToDouble(elcDEV.COL5) >= 0) // { // n2.InnerText = Convert.ToDouble(GetColValue(elcDEV, order).COL4).ToString("N2") + " + " + "j" + Convert.ToDouble(GetColValue(elcDEV, order).COL5).ToString("N2"); // } // else // { // n2.InnerText = Convert.ToDouble(GetColValue(elcDEV, order).COL4).ToString("N2") + " - " + "j" + (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL5))).ToString("N2"); // } // n2.SetAttribute("layer", lar.ID); // n2.SetAttribute("flag", "1"); // n2.SetAttribute("ParentID", ((PSPDEV)listMX[i]).SUID); // n2.SetAttribute("font-size", size.ToString());//"12"); // // n2.SetAttribute("limitsize", "true"); // double tempi = Convert.ToDouble(GetColValue(elcDEV, order).COL4); // double tempj = Convert.ToDouble(GetColValue(elcDEV, order).COL5); // double temptotal = Math.Sqrt(tempi * tempi + tempj * tempj); // if (temptotal > Convert.ToDouble(elementDEV.Burthen)) // { // n2.SetAttribute("stroke", "#FF0000"); // } // tlVectorControl1.SVGDocument.RootElement.AppendChild(n2); //} //tlVectorControl1.SVGDocument.RootElement.AppendChild(n1); //tlVectorControl1.Operation = ToolOperation.Select; } else { //elementn1.InnerText = Convert.ToDouble(GetColValue(elcDEV, order).COL2).ToString("N2"); //if (Convert.ToDouble(GetColValue(elcDEV, order).COL2) > TLPSPVmax * elementDEV.RateVolt / elementDEV.ReferenceVolt || Convert.ToDouble(GetColValue(elcDEV, order).COL2) < TLPSPVmin * elementDEV.RateVolt / elementDEV.ReferenceVolt)//电压越限,需修改 // elementn1.SetAttribute("stroke", "#FF0000"); //if (elementDEV.NodeType == "0") //{ // if (Convert.ToDouble(elcDEV.COL5) >= 0) // { // elementn2.InnerText = Convert.ToDouble(GetColValue(elcDEV, order).COL4).ToString("N2") + " + " + "j" + Convert.ToDouble(GetColValue(elcDEV, order).COL5).ToString("N2"); // } // else // { // elementn2.InnerText = Convert.ToDouble(GetColValue(elcDEV, order).COL4).ToString("N2") + " - " + "j" + (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL5))).ToString("N2"); // } //} } } tlVectorControl1.Refresh(); } } } List<PSPDEV> listline = new List<PSPDEV>(); if (pspouttype==1) { SelShowlineform selbusfrm = new SelShowlineform(); selbusfrm.ProjectSUID = projectsuid; selbusfrm.ProjectID = Itop.Client.MIS.ProgUID; selbusfrm.ShowDialog(); if (selbusfrm.DialogResult == DialogResult.OK) { foreach (DataRow row in selbusfrm.DT.Rows) { try { if ((bool)row["C"]) { PSPDEV psp = new PSPDEV(); psp.SUID = row["A"].ToString(); psp = (PSPDEV)UCDeviceBase.DataService.GetObject("SelectPSPDEVByKey", psp); if (psp != null) { listline.Add(psp); } } } catch (System.Exception ex) { } } if (listline.Count == 0) { MessageBox.Show("没有选择显示的线路!"); return; } } } wFrom.ShowText += "\r\n正在显示线路信息\t" + System.DateTime.Now.ToString(); XmlNodeList polyLineList = tlVectorControl1.SVGDocument.SelectNodes("svg/polyline"); foreach (XmlNode node in polyLineList) { XmlElement element = node as XmlElement; PSP_ElcDevice elcDEV = new PSP_ElcDevice(); elcDEV.ProjectSUID = projectsuid; elcDEV.DeviceSUID = element.GetAttribute("Deviceid"); elcDEV = (PSP_ElcDevice)Services.BaseService.GetObject("SelectPSP_ElcDeviceByKey", elcDEV); PSPDEV elementDEV = new PSPDEV(); if (elcDEV != null) { elementDEV.SUID = elcDEV.DeviceSUID; elementDEV = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByKey", elementDEV); if (pspouttype == 1) //如果只显示规划线路的数据 { bool flag = false; foreach (PSPDEV showdev in listline) { if (elementDEV.SUID==showdev.SUID) { flag = true; break; } } if (!flag) { //删除不是选中的线路的数据 XmlElement elementdl = tlVectorControl1.SVGDocument.SelectSingleNode("svg/text[@ layer='" + lar.ID + "'and @ParentID='" + elementDEV.SUID + "']") as XmlElement; if (elementdl != null) { tlVectorControl1.SVGDocument.RootElement.RemoveChild(elementdl); } tlVectorControl1.Refresh(); continue; } //if (Convert.ToInt32(elementDEV.OperationYear) <= DateTime.Now.Year) //{ // continue; //} } } else { continue; } if (elementDEV != null && elementDEV.KSwitchStatus == "0") { XmlElement elementdl = tlVectorControl1.SVGDocument.SelectSingleNode("svg/text[@ layer='" + lar.ID + "'and @ParentID='" + elementDEV.SUID + "']") as XmlElement; if (elementdl == null) { List<PointF> pcol = CheckLenth((Polyline)element); PointF[] t = ((Polyline)element).Points; PointF[] t2 = ((Polyline)element).Points; t = t2; int lastnum = t2.Length - 1; PointF midt = new PointF((float)((pcol[0].X + pcol[1].X) / 2), (float)((pcol[0].Y + pcol[1].Y) / 2)); float angel = 0f; angel = (float)(180 * Math.Atan2((pcol[0].Y - pcol[1].Y), (pcol[1].X - pcol[0].X)) / Math.PI); string l3 = Convert.ToString(midt.X); string l4 = Convert.ToString(midt.Y); string tran = ((Polyline)element).Transform.ToString(); PointF center = new PointF((float)(pcol[0].X + (pcol[1].X - pcol[0].X) / 2), (float)(pcol[0].Y + (pcol[1].Y - pcol[0].Y) / 2)); XmlElement n1 = tlVectorControl1.SVGDocument.CreateElement("text") as Text; // XmlElement n2 = tlVectorControl1.SVGDocument.CreateElement("polyline") as Polyline; //XmlElement n3 = tlVectorControl1.SVGDocument.CreateElement("text") as Text; PointF pStart = new PointF(center.X + (float)(15 * Math.Sin((angel) * Math.PI / 180)), center.Y - (float)(15 * Math.Cos((angel) * Math.PI / 180))); PointF pStart2 = new PointF(center.X - (float)(23 * Math.Sin((angel) * Math.PI / 180)), center.Y + (float)(23 * Math.Cos((angel) * Math.PI / 180))); XmlNode firstNodeElement = tlVectorControl1.SVGDocument.SelectSingleNode("svg/*[@id='" + element.GetAttribute("FirstNode") + "']"); XmlNode lastNodeElement = tlVectorControl1.SVGDocument.SelectSingleNode("svg/*[@id='" + element.GetAttribute("LastNode") + "']"); //if (firstNodeElement != null) { if ((angel > 10 && angel < 90) || (angel < 0 && Math.Abs(angel) < 90) || (angel > 180 && angel < 350)) { //if (t2[0].X > ((IGraph)firstNodeElement).CenterPoint.X) //{ pStart = new PointF(center.X - (float)(23 * Math.Sin((angel) * Math.PI / 180)), center.Y + (float)(23 * Math.Cos((angel) * Math.PI / 180))); pStart2 = new PointF(center.X + (float)(23 * Math.Sin((angel) * Math.PI / 180)), center.Y - (float)(23 * Math.Cos((angel) * Math.PI / 180))); //} } else if ((angel >= 0 && angel <= 10) || (angel >= 350 && angel <= 360) || (angel < 0 && Math.Abs(angel) <= 90)) { //if (t2[0].Y > ((IGraph)firstNodeElement).CenterPoint.Y) //{ pStart = new PointF(center.X - (float)(23 * Math.Sin((angel) * Math.PI / 180)), center.Y + (float)(23 * Math.Cos((angel) * Math.PI / 180))); pStart2 = new PointF(center.X + (float)(23 * Math.Sin((angel) * Math.PI / 180)), center.Y - (float)(23 * Math.Cos((angel) * Math.PI / 180))); //} } else if ((angel < 0 && Math.Abs(angel) > 90) || (angel >= 90 && angel <= 180)) { //if (t2[0].Y > ((IGraph)firstNodeElement).CenterPoint.Y) //{ pStart = new PointF(center.X - (float)(7 * Math.Sin((angel) * Math.PI / 180)), center.Y + (float)(7 * Math.Cos((angel) * Math.PI / 180))); pStart2 = new PointF(center.X + (float)(7 * Math.Sin((angel) * Math.PI / 180)), center.Y - (float)(7 * Math.Cos((angel) * Math.PI / 180))); //} } if (Convert.ToDouble(GetColValue(elcDEV, order).COL5) >= 0) { n1.InnerText = (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL4))).ToString("N2") + " + j" + (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL5))).ToString("N2"); } else { n1.InnerText = (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL4))).ToString("N2") + " - j" + (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL5))).ToString("N2"); } Graphics dd = this.CreateGraphics(); Font ff = new Font("宋体", 12); SizeF sf = dd.MeasureString(n1.InnerText, ff); double ztlength = Math.Sqrt(sf.Width * sf.Width + sf.Height * sf.Height); PointF newp1 = new PointF(t[0].X + (t[1].X - t[0].X) / 2 - (float)(15 * Math.Sin(angel)), t[0].Y + (t[1].Y - t[0].Y) / 2 - (float)(15 * Math.Cos(angel))); //n1.SetAttribute("x", Convert.ToString(center.X - (float)(Math.Sin((angel) * Math.PI / 180) * ztlength))); //n1.SetAttribute("y", Convert.ToString(center.Y - (float)(Math.Cos((angel) * Math.PI / 180) * ztlength))); n1.SetAttribute("x", Convert.ToString(center.X)); n1.SetAttribute("y", Convert.ToString(center.Y)); //Layer la = tlVectorControl1.SVGDocument.GetLayerByID(element.GetAttribute("layer")); n1.SetAttribute("layer", lar.ID); n1.SetAttribute("ParentID", elementDEV.SUID); n1.SetAttribute("flag", "1"); n1.SetAttribute("Showline", "1"); //为显示哪条线路做标志 n1.SetAttribute("font-size", "96");// size.ToString());//"12"); // n1.SetAttribute("limitsize", "true"); if (Convert.ToDouble(GetColValue(elcDEV, order).COL14) > (elementDEV.LineChange))//电流越限,需修改。 n1.SetAttribute("stroke", "#FF0000"); //PointF p1 = new PointF(midt.X - (float)(10 * Math.Cos((angel + 25) * Math.PI / 180)), midt.Y - (float)(10 * Math.Sin((angel + 25) * Math.PI / 180))); //PointF p2 = new PointF(midt.X - (float)(10 * Math.Cos((angel + 335) * Math.PI / 180)), midt.Y - (float)(10 * Math.Sin((angel + 335) * Math.PI / 180))); //if (Convert.ToDouble(elcDEV.COL4) < 0) //{ // p1 = new PointF(midt.X - (float)(10 * Math.Cos((angel + 155) * Math.PI / 180)), midt.Y - (float)(10 * Math.Sin((angel + 155) * Math.PI / 180))); // p2 = new PointF(midt.X - (float)(10 * Math.Cos((angel + 205) * Math.PI / 180)), midt.Y - (float)(10 * Math.Sin((angel + 205) * Math.PI / 180))); //} //string l1 = Convert.ToString(p1.X); //string l2 = Convert.ToString(p1.Y); //string l5 = Convert.ToString(p2.X); //string l6 = Convert.ToString(p2.Y); //n2.SetAttribute("points", l1 + " " + l2 + "," + l3 + " " + l4 + "," + l5 + " " + l6); //n2.SetAttribute("fill-opacity", "1"); //n2.SetAttribute("layer", SvgDocument.currentLayer); //n2.SetAttribute("flag", "1"); //n2.SetAttribute("font-size", "6"); //tlVectorControl1.SVGDocument.RootElement.AppendChild(n2); //tlVectorControl1.SVGDocument.CurrentElement = n2 as SvgElement; tlVectorControl1.SVGDocument.RootElement.AppendChild(n1); tlVectorControl1.Operation = ToolOperation.Select; tlVectorControl1.SVGDocument.CurrentElement = n1 as SvgElement; RectangleF ttt = ((Polyline)element).GetBounds(); tlVectorControl1.RotateSelection(angel, pStart); if (Math.Abs(angel) > 90) tlVectorControl1.RotateSelection(180, pStart); } } else { elementdl.SetAttribute("Showline", "1"); //为显示哪条线路做标志 if (Convert.ToDouble(GetColValue(elcDEV, order).COL5) >= 0) { elementdl.InnerText = (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL4))).ToString("N2") + " + j" + (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL5))).ToString("N2"); } else { elementdl.InnerText = (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL4))).ToString("N2") + " - j" + (Math.Abs(Convert.ToDouble(GetColValue(elcDEV, order).COL5))).ToString("N2"); } if (Convert.ToDouble(GetColValue(elcDEV, order).COL14) > (elementDEV.LineChange))//电流越限,需修改。 elementdl.SetAttribute("stroke", "#FF0000"); } tlVectorControl1.Refresh(); } //删除不投入运行的输出结果 else if (elementDEV != null && elementDEV.KSwitchStatus == "1") { XmlElement elementdl = tlVectorControl1.SVGDocument.SelectSingleNode("svg/text[@ layer='" + lar.ID + "'and @ParentID='" + elementDEV.SUID + "']") as XmlElement; if (elementdl != null) { tlVectorControl1.SVGDocument.RootElement.RemoveChild(elementdl); } tlVectorControl1.Refresh(); } } //this.frmlar.checkedListBox1.Items.Add(lar, true); //this.frmlar.checkedListBox1.SelectedIndex = -1; MessageBox.Show("显示完成!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (System.Exception ex) { MessageBox.Show("参数错误,请调整参数后重新计算!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } }
private void checkwjghelement() { //判断图元有没有 wjghelement.Clear(); XmlNodeList useList = tlVectorControl1.SVGDocument.SelectNodes("svg/use"); XmlNodeList linelist = tlVectorControl1.SVGDocument.SelectNodes("svg/polyline [@IsLead='1']"); string con = "GprogUID='" + ff.Key + "'"; IList list = Services.BaseService.GetList("SelectPSP_GprogEleviceByCondition", con); try { foreach (PSP_GprogElevice pg in list) { bool flag = false; if (pg.Type == "变电站" || pg.Type == "电源") { foreach (XmlNode element in useList) { if (!string.IsNullOrEmpty((element as XmlElement).GetAttribute("Deviceid"))) { if ((element as XmlElement).GetAttribute("Deviceid") == pg.DeviceSUID) { flag = true; if (pg.L2 == "0") { pg.L2 = "1"; Services.BaseService.Update<PSP_GprogElevice>(pg); } break; } } } } else { foreach (XmlNode element in linelist) { if (!string.IsNullOrEmpty((element as XmlElement).GetAttribute("Deviceid"))) { if ((element as XmlElement).GetAttribute("Deviceid") == pg.DeviceSUID) { //显示隐藏的图元 (element as XmlElement).SetAttribute("visibility", "show"); flag = true; if (pg.L2 == "0") { pg.L2 = "1"; Services.BaseService.Update<PSP_GprogElevice>(pg); } break; } } } } if (!flag) { if (pg.L2 == "1") { pg.L2 = "0"; Services.BaseService.Update<PSP_GprogElevice>(pg); } } if (pg.Type == "变电站") { PSP_Substation_Info sb = new PSP_Substation_Info(); sb.UID = pg.DeviceSUID; sb = (PSP_Substation_Info)Services.BaseService.GetObject("SelectPSP_Substation_InfoByKey", sb); eleclass el = new eleclass(sb.Title, sb.UID, "20", flag); wjghelement.Add(el); } if (pg.Type == "电源") { PSP_PowerSubstation_Info sb = new PSP_PowerSubstation_Info(); sb.UID = pg.DeviceSUID; sb = (PSP_PowerSubstation_Info)Services.BaseService.GetObject("SelectPSP_PowerSubstation_InfoByKey", sb); eleclass el = new eleclass(sb.Title, sb.UID, "30", flag); wjghelement.Add(el); } if (pg.Type == "线路") { PSPDEV sb = new PSPDEV(); sb.SUID = pg.DeviceSUID; sb = (PSPDEV)Services.BaseService.GetObject("SelectPSPDEVByKey", sb); eleclass el = new eleclass(sb.Name, sb.SUID, "05", flag); wjghelement.Add(el); } } } catch (System.Exception ex) { } }
//�������ڵ�ʱ��ָ�pspdev����·������״̬ ��Ϊ���кʹ�ѡ��״̬ public void initdat(string GprogUID) { //�ڴ˴�����ѡ���Ԫ���豸�����Խ��и��� 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 = '" + GprogUID + "' 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 = '" + GprogUID + "' 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 = '" + GprogUID + "' 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 override void UpdateIn(DataTable table) { for (int i = 0; i < table.Rows.Count; i++) { if (table.Rows[i][0].ToString().IndexOf("�ϼ�") > 0 || table.Rows[i][1].ToString().IndexOf("�ϼ�") > 0) continue; PSP_PowerSubstation_Info area = new PSP_PowerSubstation_Info(); area.UID += "|" + ProjectID; area.AreaID = ProjectID; area.CreateDate = DateTime.Now; foreach (DataColumn col in table.Columns) { try { if (table.Rows[i][col] != null) { string inserted = table.Rows[i][col].ToString(); if (inserted == "�滮" || inserted == "��״") area.GetType().GetProperty("Flag").SetValue(area, inserted == "�滮" ? "2" : "1", null); else { Type type = area.GetType().GetProperty(col.ColumnName).PropertyType;//.GetValue(area, null).GetType(); if (type == typeof(int)) area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(inserted == "" ? "0" : inserted), null); else if (type == typeof(string)) area.GetType().GetProperty(col.ColumnName).SetValue(area, inserted, null); else if (type == typeof(decimal)) area.GetType().GetProperty(col.ColumnName).SetValue(area, decimal.Parse(inserted == "" ? "0" : inserted), null); else if (type == typeof(double)) area.GetType().GetProperty(col.ColumnName).SetValue(area, double.Parse(inserted == "" ? "0.0" : inserted), null); else if (type == typeof(DateTime)) { } } } } catch { MessageBox.Show(string.Format("��{0}��{1}�в���������", i.ToString(), col.Caption)); } } DataService.Create<PSP_PowerSubstation_Info>(area); } }