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