private void btnFinish_Click(object sender, EventArgs e) { try { MapEventLayer layer = cboType.SelectedItem as MapEventLayer; EventDetails item = new EventDetails(); item.Point = _currentPoint; item.Description = txtDescription.Text; item.Date = dtpDate.DateTime; item.TypeId = layer.TypeId; item.EventType = layer.EventTypeName; string sql = $"insert into Geo_Event(LinkCode, Latitude, Longitude, EventTypeId, Description, EventDate)" + $" values('{_eventInfo.KeyCode}', {item.Point.Y}, {item.Point.X}, {item.TypeId}, '{item.Description}', '{item.Date}'); SELECT SCOPE_IDENTITY()"; item.Id = Convert.ToInt32(_hmCon.SQLExecutor.ExecuteScalar(sql, _hmCon.TRConnection)); _eventInfo.EventList.Add(item); cboEvents.Properties.Items.Add(item); cboEvents.SelectedIndex = cboEvents.Properties.Items.Count - 1; InDrawingStatus(false); _map.FinishDraw(item); } catch (Exception ex) { _pop.ShowPopup("Sql exception: " + ex.Message); } }
public void AddEventLayer(MapEventLayer layer, int layerIndex) { _layerList.Add(layer, layerIndex); cboType.Properties.Items.Clear(); cboType.Properties.Items.AddRange(_layerList.Keys); }
public PenEvent(MapEventLayer layerInfo) { _layerInfo = layerInfo; _layerInfo.MarkerType = EventMarkerType.Proportional; }
public ucDrawEvents(HMCon con, TUC_HMDevXManager.TUC_HMDevXManager hmDevMgr, WpfMapDrawBase map, MapEventLayer layer, int layerIndex) : base(con, hmDevMgr, map) { InitializeComponent(); _layerList = new Dictionary <MapEventLayer, int>() { { layer, layerIndex } }; cboType.Properties.Items.AddRange(_layerList.Keys); cboType.SelectedIndex = 0; gcAttr.DataSource = _attrTable; InDrawingStatus(false); }
public Form1() { InitializeComponent(); hmConn = new HMConnection.HMCon("web_qa_re", "CSMSQL2012", 12, "ying"); //hmConn = new HMConnection.HMCon("WEB_DEMO_MASTER_V11", "REFLEXDEMOSERV", 12, "ying"); hmDevMgr = new TUC_HMDevXManager.TUC_HMDevXManager(); List <IMapLayer> layers = new List <IMapLayer>(); MapShapeLayer shapeLayer = new MapShapeLayer() { LinkTable = "Test", LinkColumn = "Asset Code" }; shapeLayer.Attributes.Add(new AttrInfo("Category", "Category")); shapeLayer.Attributes.Add(new AttrInfo("Location", "Location")); shapeLayer.Attributes.Add(new AttrInfo("Asset Code", "Asset Code")); layers.Add(shapeLayer); MapPointLayer pointLayer = new MapPointLayer() { LinkTable = "Test", LinkColumn = "Asset Code", }; pointLayer.Attributes.Add(new AttrInfo("Desc", "Description")); pointLayer.Attributes.Add(new AttrInfo("Asset Code", "Asset Code")); //pointLayer.HilightMarkerSymbol = new PictureMarkerSymbol(); //((PictureMarkerSymbol)pointLayer.HilightMarkerSymbol).SetSourceAsync(new System.Uri("http://static.arcgis.com/images/Symbols/Basic/GoldShinyPin.png")); //pointLayer.MarkerSymbol = new PictureMarkerSymbol(); //((PictureMarkerSymbol)pointLayer.MarkerSymbol).SetSourceAsync(new System.Uri("http://static.arcgis.com/images/Symbols/Basic/GreenShinyPin.png")); layers.Add(pointLayer); MapLineLayer lineLayer = new MapLineLayer() { LinkTable = "Test", LinkColumn = "Asset Code" }; lineLayer.Attributes.Add(new AttrInfo("Category", "Category")); lineLayer.Attributes.Add(new AttrInfo("Location", "Location")); lineLayer.Attributes.Add(new AttrInfo("Asset Code", "Asset Code")); layers.Add(lineLayer); var eventList = MapEventLayer.GetEventLayers(hmConn, "Test", "Asset Code"); layers.AddRange(eventList); string sql = $"exec sp_FA_SearchBuildingAssets '{hmConn.MLUser}E', 'E'"; hmConn.SQLExecutor.ExecuteNonQuery(sql, hmConn.TRConnection); sql = $"SELECT distinct eqi_code, [Asset Code], Description, Category, Class, Location " + $"FROM working_Fixed_Assets_search WHERE(username = '******')"; var table = hmConn.SQLExecutor.ExecuteDataAdapter(sql, hmConn.TRConnection); gc.DataSource = table; gv.Columns.ToList().ForEach(x => x.Caption = x.Name + "Cap"); ucMap1.Init(hmConn, hmDevMgr, gv, layers); }