Example #1
0
         internal static void BuildTQLines(ref LineOverlay layer, string tqcode, string tqname) {
             IList<PS_xl> xllist=Client.ClientHelper.PlatformSqlMap.GetList<PS_xl>(string.Format("where left(Linecode,{0})='{1}' and LineVol = '0.4'",tqcode.Length,tqcode));
             
             string linecode = "";

             foreach (PS_xl line in xllist) {
                 linecode = line.LineCode;
                 IList<PS_gt> list = Client.ClientHelper.PlatformSqlMap.GetList<PS_gt>(string.Format("where Linecode='{0}' order by gtcode", linecode));


                 GMapMarkerVector marker = null;
                 GMapMarkerVector preMarker = null;
                 List<PointLatLng> points = new List<PointLatLng>();
                 PointRoute route = new PointRoute(points, linecode);
                 route.Stroke.Width = 1;
                 int count = 0;
                 IList<TX_Point> listp = Client.ClientHelper.PlatformSqlMap.GetList<TX_Point>("where layerid='" + tqcode + "'");
                 Dictionary<string, TX_Point> dicp = new Dictionary<string, TX_Point>();
                 foreach (TX_Point p in listp) {
                     dicp.Add(p.ID, p);
                 }
                 foreach (PS_gt gt in list) {
                     PointF pf = new PointF((float)gt.gtLon, (float)gt.gtLat);
                     if (count == 0) {
                         int.TryParse(gt.gth, out count);
                         count /= 10;
                     }
                     if (box.Contains(pf)) {
                         PointLatLng point = new PointLatLng(Convert.ToDouble(gt.gtLat), Convert.ToDouble(gt.gtLon));
                         route.Points.Add(point);
                         if (gt.gtType.Contains("方杆"))
                             marker = new GMapMarkerRect(point);
                         else
                             marker = new GMapMarkerVector(point);
                         if (preMarker != null) {
                             marker.ParentMarker = preMarker;
                             preMarker.NextMarker = marker;
                         }
                         marker.MarkerType = MarkerEnum.gt;
                         preMarker = marker;
                         marker.ToolTipText = gt.gth + "\n" + line.LineName;
                         marker.Text = string.IsNullOrEmpty(gt.c1) ? count + "" : gt.c1;
                         marker.Tag = gt;
                         marker.Id = gt.gtID;
                         layer.Markers.Insert(0,marker);
                         route.Markers.Add(marker);
                         marker.Route = route;
                     }
                     count++;
                 }
                 //线路名文字
                 if (route.Points.Count > 0) {
                     if (dicp.ContainsKey(line.LineCode)) {
                         TX_Point pt = dicp[line.LineCode];
                         GMapMarkerText text = new GMapMarkerText(new PointLatLng(double.Parse(pt.y), double.Parse(pt.x)));
                         text.Text = pt.Text;
                         text.IsVisible = false;
                         text.MarkerType = MarkerEnum.xlmc;
                         layer.Markers.Add(text);
                         text.Tag = pt;
                     } else {
                         GMapMarkerText text = new GMapMarkerText(route.Points[route.Points.Count-1]);
                         text.Tag = line.LineCode;
                         text.Text = line.LineName;
                         text.IsVisible = false;
                         text.MarkerType = MarkerEnum.xlmc;
                         layer.Markers.Add(text);
                     }
                 }
                 if (route.Points.Count > 0) {
                     
                     layer.Routes.Add(route);
                 }
             }
         }
Example #2
0
        private void buildTitleInfo(string gdscode) {
            GMap.NET.RectLatLng? r1= MapControl.GetRectOfAllMarkers(null);
            GMap.NET.RectLatLng? r2=MapControl.GetRectOfAllRoutes(null);
            GMap.NET.RectLatLng rect = RectLatLng.Empty;
            if (r1.HasValue) {
                rect = r1.Value;
                if (r2.HasValue) rect = union(rect, r2.Value);
            } else if (r2.HasValue) {
                rect = r2.Value;
            }
            if (!rect.IsEmpty) {
                
                rect.Inflate(.002d, .001d);
                string name = MainHelper.UserCompany;
                if (gdscode != null) {
                    mOrg org = Client.ClientHelper.PlatformSqlMap.GetOne<mOrg>("where orgcode='" + gdscode + "'");

                    if (org != null) {
                        name = org.OrgName;
                    }
                }
                GMapMarkerText text = new GMapMarkerText(new PointLatLng(rect.Top - .0025, rect.Left + rect.WidthLng / 2));
                text.Font = new Font(FontFamily.GenericSansSerif, 12, FontStyle.Bold);
                text.Text = name + "高压配电线路网络图 - " + DateTime.Now.Year + "年";
                MapControl.FindOverlay("bdz").Markers.Add(text);
                //MapControl.MapBounds = rect;
                MapControl.SetZoomToFitRect(rect);
            }
            
        }
Example #3
0
         internal static void Build35kVLines(ref LineOverlay layer, string lineCode) {
             sd_xl xl0 = Client.ClientHelper.PlatformSqlMap.GetOne<sd_xl>("where linecode='" + lineCode + "'");
             if (xl0 == null) return;
             IList<sd_xl> xllist0 = Client.ClientHelper.PlatformSqlMap.GetList<sd_xl>(string.Format(" where linecode like '{0}%' and linevol='10'", xl0.OrgCode));
             DataTable dt0 = Ebada.Core.ConvertHelper.ToDataTable(xllist0 as IList, typeof(sd_xl));
             DataTable dt = dt0.Clone();

             getchildxl(dt0, dt, xl0.LineID);
             //IList<sd_xl> xllist = Client.ClientHelper.PlatformSqlMap.GetList<sd_xl>(string.Format("where left(Linecode,{0})='{1}' and LineVol = '10'", lineCode.Length, lineCode));
             IList<sd_xl> xllist = Ebada.Core.ConvertHelper.ToIList<sd_xl>(dt);
             xllist.Insert(0, xl0);
             string linecode = "";
             string kgfilter = " where gtid in (select gtid from ps_gt  where Linecode='{0}')";
             string byqfilter = " tqid  in (select a.tqid from ps_tq a, ps_gt b  where a.gtid=b.gtid and b.Linecode='{0}') ";
             string byqfilter2 = "select a.*,b.gtid from ps_tqbyq a ,ps_tq b,ps_gt c  where a.tqid=b.tqid and  b.gtid=c.gtid and c.Linecode='{0}' ";
             Dictionary<string, PointLatLng> gtdic = new Dictionary<string, PointLatLng>();
             IList<sd_gt> list;
             IList<PS_kg> kglist;
             IList byqlist;
             IList<TX_Point> listp = Client.ClientHelper.PlatformSqlMap.GetList<TX_Point>("where layerid='" + lineCode + "'");
             Dictionary<string, TX_Point> dicp = new Dictionary<string, TX_Point>();
             foreach (TX_Point p in listp) {
                 dicp.Add(p.ID, p);
             }
             foreach (sd_xl line in xllist) {
                 linecode = line.LineCode;
                 list = Client.ClientHelper.PlatformSqlMap.GetList<sd_gt>(string.Format("where Linecode='{0}' order by gtcode", linecode));
                 kglist = Client.ClientHelper.PlatformSqlMap.GetList<PS_kg>(string.Format(kgfilter, linecode));
                 byqlist = Client.ClientHelper.PlatformSqlMap.GetList("Select", string.Format(byqfilter2, linecode));
                 DataTable byqtable = DataConvert.HashTablesToDataTable(byqlist);
                 GMapMarkerVector marker = null;
                 GMapMarkerVector preMarker = null;
                 List<PointLatLng> points = new List<PointLatLng>();
                 PointRoute route = new PointRoute(points, linecode);
                 //route.Stroke.Color = Color.Black;
                 if (linecode.Length == 6)
                     route.Stroke.Width = 3;
                 else
                     route.Stroke.Width = 3;
                 route.Stroke.Color = Color.OrangeRed;
                 route.Tag = line;
                 int count = 0;
                 gtdic.Clear();
                 foreach (sd_gt gt in list) {
                     PointF pf = new PointF((float)gt.gtLon, (float)gt.gtLat);
                     if (count == 0) {
                         int.TryParse(gt.gth, out count);
                         count /= 10;
                     }

                     if (box.Contains(pf)) {

                         PointLatLng point = new PointLatLng(Convert.ToDouble(gt.gtLat), Convert.ToDouble(gt.gtLon));
                         gtdic.Add(gt.gtID, point);//放入字典供杆塔设备定位
                         route.Points.Add(point);
                         if (gt.gtType.Contains("方杆"))
                             marker = new GMapMarkerRect(point);
                         else
                             marker = new GMapMarkerVector(point);
                         if (preMarker != null) {
                             marker.ParentMarker = preMarker;
                             preMarker.NextMarker = marker;
                         }
                         marker.MarkerType = MarkerEnum.gt;
                         preMarker = marker;
                         marker.ToolTipText = gt.gth + "\n" + line.LineName;
                         marker.Tag = gt;
                         if (count % 2 == 1)
                             marker.Text = string.IsNullOrEmpty(gt.c1) ? count + "" : gt.c1;
                         marker.Id = gt.gtID;
                         layer.Markers.Add(marker);
                         route.Markers.Add(marker);
                         marker.Route = route;
                     }
                     count++;
                 }
                 //线路名文字
                 if (route.Points.Count > 0) {
                     if (dicp.ContainsKey(line.LineCode)) {
                         TX_Point pt = dicp[line.LineCode];
                         GMapMarkerText text = new GMapMarkerText(new PointLatLng(double.Parse(pt.y), double.Parse(pt.x)));
                         text.Text = pt.Text;
                         text.IsVisible = false;
                         text.MarkerType = MarkerEnum.xlmc;
                         layer.Markers.Add(text);
                         text.Tag = pt;
                     } else {
                         GMapMarkerText text = new GMapMarkerText(route.Points[route.Points.Count - 1]);
                         text.Tag = line.LineCode;
                         text.Text = line.LineName;
                         text.IsVisible = false;
                         text.MarkerType = MarkerEnum.xlmc;
                         layer.Markers.Add(text);
                     }
                 }
                 //变压器
                 if (byqtable != null && byqtable.Rows.Count > 0) {

                     //int i = 0;
                     List<string> byqgt = new List<string>();
                     foreach (DataRow row in byqtable.Rows) {

                         if (!gtdic.ContainsKey(row["gtid"].ToString())) continue;
                         if (byqgt.Contains(row["gtid"].ToString())) { }
                         else
                             byqgt.Add(row["gtid"].ToString());
                         PointLatLng point = gtdic[row["gtid"].ToString()];
                         //point.Lng += i++ * 0.0002d; 
                         marker = new GMapMarkerBYQ(point);
                         marker.MarkerType = MarkerEnum.byq;
                         marker.ShowText = true;
                         marker.Text = string.Format("{0}", row["byqCapcity"]);
                         marker.ToolTipText = string.Format("安装地点:{0}\r\n型号:{1}\r\n容量:{2}", row["byqName"], row["byqModle"], row["byqCapcity"]);
                         marker.Tag = row["byqID"];
                         //marker.IsHitTestVisible = false;
                         layer.Markers.Add(marker);
                         if (dicp.ContainsKey(row["byqID"].ToString())) {
                             TX_Point pt = dicp[row["byqID"].ToString()];
                             marker.Position = new PointLatLng(double.Parse(pt.y), double.Parse(pt.x));
                             marker.Tag = pt;
                         }
                     }
                 }
                 if (kglist != null && kglist.Count > 0) {
                     foreach (PS_kg row in kglist) {
                         if (!gtdic.ContainsKey(row.gtID)) continue;

                         PointLatLng point = gtdic[row.gtID];
                         marker = new GMapMarkerKG(point);
                         marker.IsVisible = false;
                         marker.MarkerType = MarkerEnum.kg;
                         //marker.Text = string.Format("{0}", row.kgModle);
                         marker.ToolTipText = string.Format("安装地点:{0}\r\n型号:{1}\r\n容量:{2}", row.kgInstallAdress, row.kgModle, row.kgCapcity);
                         marker.Tag = row;
                         //marker.IsHitTestVisible = false;
                         layer.Markers.Add(marker);
                     }
                 }
                 if (route.Points.Count > 0) {

                     layer.Routes.Add(route);
                 }
             }
         }