string updateNode(string txt, string all) { NW_Node node = new NW_Node(); DataTable dt = node.NW_Node_GetList(); string _list = ""; string lat = ""; string lng = ""; string link = "http://maps.google.com/mapfiles/ms/icons/green.png"; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Description"].ToString().Length > 3) { if (dt.Rows[i]["Description"].ToString().IndexOf(',') > 0) { if (all == " ") { if (dt.Rows[i]["Total"] != DBNull.Value) { if (dt.Rows[i]["NodeGroup"].ToString() == "BT") { link = "http://maps.google.com/mapfiles/marker_greenB.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "GV") { link = "http://maps.google.com/mapfiles/marker_purpleG.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "TD") { link = "http://maps.google.com/mapfiles/marker_orangeT.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q2") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=2%7c5680FC%7c000000&.png%3f"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q9") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=9%7cE14E9D%7c000000&.png%3f"; } lat = dt.Rows[i]["Description"].ToString().Substring(0, dt.Rows[i]["Description"].ToString().IndexOf(',')); lng = dt.Rows[i]["Description"].ToString().Substring(dt.Rows[i]["Description"].ToString().IndexOf(',') + 1); _list += "var info" + i.ToString() + " = new google.maps.InfoWindow({\n" + "content: 'Node:" + dt.Rows[i]["NodeName"].ToString() + "<br> Device: " + dt.Rows[i]["Total"].ToString() + "'\n" + "});\n" + "var N" + i.ToString() + "\n" + "addMarker(N" + i.ToString() + ",{lat: " + lat + ", lng: " + lng + "},'" + dt.Rows[i]["NodeName"].ToString() + "', map,info" + i.ToString() + ",'" + link + "') \n"; } } else { if (dt.Rows[i]["NodeGroup"].ToString() == "BT") { link = "http://maps.google.com/mapfiles/marker_greenB.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "GV") { link = "http://maps.google.com/mapfiles/marker_purpleG.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "TD") { link = "http://maps.google.com/mapfiles/marker_orangeT.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q2") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=2%7c5680FC%7c000000&.png%3f"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q9") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=9%7cE14E9D%7c000000&.png%3f"; } lat = dt.Rows[i]["Description"].ToString().Substring(0, dt.Rows[i]["Description"].ToString().IndexOf(',')); lng = dt.Rows[i]["Description"].ToString().Substring(dt.Rows[i]["Description"].ToString().IndexOf(',') + 1); _list += "var info" + i.ToString() + " = new google.maps.InfoWindow({\n" + "content: 'Node:" + dt.Rows[i]["NodeName"].ToString() + "<br> Device: " + dt.Rows[i]["Total"].ToString() + "'\n" + "});\n" + "var N" + i.ToString() + "\n" + "addMarker(N" + i.ToString() + ",{lat: " + lat + ", lng: " + lng + "},'" + dt.Rows[i]["NodeName"].ToString() + "', map,info" + i.ToString() + ",'" + link + "') \n"; } } } } // addMarker({lat: 10.8133611, lng: 106.6974304},'aa', map) txt = txt.Replace("_node", _list); return(txt); }
string updateNode(string txt,string all) { NW_Node node = new NW_Node(); DataTable dt = node.NW_Node_GetList(); string _list = ""; string lat=""; string lng=""; string link = "http://maps.google.com/mapfiles/ms/icons/green.png"; for (int i = 0; i < dt.Rows.Count; i++) { if ( dt.Rows[i]["Description"].ToString().Length > 3) { if (dt.Rows[i]["Description"].ToString().IndexOf(',') > 0) { if (all == " ") { if (dt.Rows[i]["Total"] != DBNull.Value) { if (dt.Rows[i]["NodeGroup"].ToString() == "BT") { link = "http://maps.google.com/mapfiles/marker_greenB.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "GV") { link = "http://maps.google.com/mapfiles/marker_purpleG.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "TD") { link = "http://maps.google.com/mapfiles/marker_orangeT.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q2") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=2%7c5680FC%7c000000&.png%3f"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q9") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=9%7cE14E9D%7c000000&.png%3f"; } lat = dt.Rows[i]["Description"].ToString().Substring(0, dt.Rows[i]["Description"].ToString().IndexOf(',')); lng = dt.Rows[i]["Description"].ToString().Substring(dt.Rows[i]["Description"].ToString().IndexOf(',') + 1); _list += "var info" + i.ToString() + " = new google.maps.InfoWindow({\n" + "content: 'Node:" + dt.Rows[i]["NodeName"].ToString() + "<br> Device: " + dt.Rows[i]["Total"].ToString() + "'\n" + "});\n" + "var N" + i.ToString() + "\n" + "addMarker(N" + i.ToString() + ",{lat: " + lat + ", lng: " + lng + "},'" + dt.Rows[i]["NodeName"].ToString() + "', map,info" + i.ToString() + ",'" + link + "') \n"; } } else { if (dt.Rows[i]["NodeGroup"].ToString() == "BT") { link = "http://maps.google.com/mapfiles/marker_greenB.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "GV") { link = "http://maps.google.com/mapfiles/marker_purpleG.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "TD") { link = "http://maps.google.com/mapfiles/marker_orangeT.png"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q2") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=2%7c5680FC%7c000000&.png%3f"; } if (dt.Rows[i]["NodeGroup"].ToString() == "Q9") { link = "http://chart.googleapis.com/chart?chst=d_map_pin_letter&chld=9%7cE14E9D%7c000000&.png%3f"; } lat = dt.Rows[i]["Description"].ToString().Substring(0, dt.Rows[i]["Description"].ToString().IndexOf(',')); lng = dt.Rows[i]["Description"].ToString().Substring(dt.Rows[i]["Description"].ToString().IndexOf(',') + 1); _list += "var info" + i.ToString() + " = new google.maps.InfoWindow({\n" + "content: 'Node:" + dt.Rows[i]["NodeName"].ToString() + "<br> Device: " + dt.Rows[i]["Total"].ToString() + "'\n" + "});\n" + "var N" + i.ToString() + "\n" + "addMarker(N" + i.ToString() + ",{lat: " + lat + ", lng: " + lng + "},'" + dt.Rows[i]["NodeName"].ToString() + "', map,info" + i.ToString() + ",'" + link + "') \n"; } } } } // addMarker({lat: 10.8133611, lng: 106.6974304},'aa', map) txt = txt.Replace("_node", _list); return txt; }