metadatadbprovider.cs

EpiInfo 开源的导航系统远程序,不知道在哪里下的了,分享一下,有兴趣的

        /// <param name="gmlSchema">GML schema document</param>
        /// <param name="layerName">Name of the layer</param>
        /// <returns>The layer's ID</returns>
        public int CreateLayer(string gml, string gmlSchema, string layerName)
        {
            Query insertQuery = db.CreateQuery("INSERT INTO metaLayers ([Gml], [GmlSchema], [Name]) VALUES (@Gml, @GmlSchema, @Name)");
            insertQuery.Parameters.Add(new QueryParameter("@Gml", DbType.String, gml));
            insertQuery.Parameters.Add(new QueryParameter("@GmlSchema", DbType.String, gmlSchema));
            insertQuery.Parameters.Add(new QueryParameter("@Name", DbType.String, layerName));
            db.ExecuteNonQuery(insertQuery);
            return GetMaxLayerId();
        }

        /// <summary>
        /// Creates a map layer in the database
        /// </summary>
        /// <param name="fileName">Shapefile name</param>
        /// <returns>The layer's ID</returns>
        public int CreateLayer(string fileName)
        {
            Query insertQuery = db.CreateQuery("INSERT INTO metaLayers ([FileName], [Name]) VALUES (@FileName, @Name)");
            insertQuery.Parameters.Add(new QueryParameter("@FileName", DbType.String, fileName));
            insertQuery.Parameters.Add(new QueryParameter("@Name", DbType.String, Path.GetFileNameWithoutExtension(fileName)));
            db.ExecuteNonQuery(insertQuery);
            return GetMaxLayerId();
        }

        /// <summary>
        /// Gets all layers of a map
        /// </summary>
        /// <param name="mapId">Map Id</param>
        /// <returns>Map Layers Datatable</returns>
        public MapMetadata.metaMapLayersDataTable GetMapLayers(int mapId)
        {
            try
            {
                MapMetadata map = new MapMetadata();
                Query query = db.CreateQuery("SELECT [MapLayerId], [MapId], [LayerId], [LayerRenderTypeId], [RenderField], [MarkerColor], [RampBeginColor], [RampEndColor], [ClassBreaks], [DataTableName], [DataTableKey], [FeatureKey], [LineColor], [FillColor], [PolygonOutlineColor] FROM metaMapLayers WHERE [MapId] = @MapId ORDER BY [MapLayerId] ASC");
                query.Parameters.Add(new QueryParameter("@MapId", System.Data.DbType.Int32, mapId));
                map.metaMapLayers.Merge(db.Select(query));
                foreach (MapMetadata.metaMapLayersRow mapLayer in map.metaMapLayers)
                {
                    map.metaLayers.ImportRow(GetLayer(mapLayer.LayerId));
                }
                return map.metaMapLayers;
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve map layers", ex);
            }
        }

        /// <summary>
        /// Gets all points of a map
        /// </summary>
        /// <param name="mapId">Map Id</param>
        /// <returns>Map Points Datatable</returns>
        public MapMetadata.metaMapPointsDataTable GetMapPoints(int mapId)
        {
            try
            {
                MapMetadata map = new MapMetadata();
                Query query = db.CreateQuery("SELECT [MapPointId], [MapId], [DataSourceTableName], [DataSourceXCoordinateColumnName], [DataSourceYCoordinateColumnName], [DataSourceLabelColumnName], [Size], [Color] FROM metaMapPoints WHERE [MapId] = @MapId");
                query.Parameters.Add(new QueryParameter("@MapId", DbType.Int32, mapId));
                map.metaMapPoints.Merge(db.Select(query));
                return map.metaMapPoints;
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve map points", ex);
            }
        }

        /// <summary>
        /// Gets a GML map layer based on ID
        /// </summary>
        /// <param name="layerId">MapLayerId</param>
        /// <returns>GML</returns>
        public MapMetadata.metaLayersRow GetLayer(int layerId)
        {
            try
            {
                MapMetadata.metaLayersDataTable table = new MapMetadata.metaLayersDataTable();
                Query query = db.CreateQuery("SELECT [LayerId], [Gml], [GmlSchema], [Name], [FileName] FROM metaLayers WHERE [LayerId] = @LayerId");
                query.Parameters.Add(new QueryParameter("@LayerId", System.Data.DbType.String, layerId));
                table.Merge(db.Select(query));
                if (table.Rows.Count > 0)
                {
                    return table[0];
                }
                else
                {
                    throw new GeneralException("Layer not found");
                }
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve layer", ex);
            }
        }

        /// <summary>
        /// Adds a layer to a map using default parameters
        /// </summary>
        /// <param name="mapId">Map Id</param>
        /// <param name="layerId">Layer Id</param>
        public void AddLayerToMap(int mapId, int layerId)
        {
            try
            {
                Query query = db.CreateQuery("INSERT INTO metaMapLayers ([MapId], [LayerId], [LayerRenderTypeId]) VALUES (@MapId, @LayerId, @LayerRenderTypeId)");
                query.Parameters.Add(new QueryParameter("@MapId", DbType.Int32, mapId));
                query.Parameters.Add(new QueryParameter("@LayerId", DbType.Int32, layerId));
                query.Parameters.Add(new QueryParameter("@LayerRenderTypeId", DbType.Int32, 1));
                db.ExecuteNonQuery(query);
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not add layer", ex);
            }
        }

        /// <summary>
        /// Gets all field types for grid columns
        /// </summary>
        /// <returns>Datatable containing field type info</returns>
        public DataTable GetGridFieldTypes()
        {
            try
            {
                Query query = db.CreateQuery("SELECT F.[FieldTypeId], D.[DataTypeId], F.[Name], D.[HasPattern], D.[HasSize], F.[HasRepeatLast], F.[HasRequired], F.[HasReadOnly], F.[HasRetainImageSize], D.[HasRange], F.[HasFont], F.[IsGridColumn], F.[IsDropDown] " +
                    "FROM metaFieldTypes F LEFT OUTER JOIN metaDatatypes D ON F.[DataTypeId] = D.[DataTypeId] " +
                    "WHERE F.[IsGridColumn] = @IsGridColumn");
                query.Parameters.Add(new QueryParameter("@IsGridColumn", System.Data.DbType.Boolean, true));
                return db.Select(query);
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve field types", ex);
            }
        }



        /// <summary>
        /// Gets all groups for a page
        /// </summary>
        /// <param name="pageId">Id of the page</param>
        /// <returns>Datatable containing group info</returns>
        public DataTable GetGroupsForPage(int pageId)
        {
            try
            {
                #region Input Validation
                if (pageId < 1)
                {
                    throw new ArgumentOutOfRangeException("PageId");
                }
                #endregion

                Query query = db.CreateQuery("SELECT [GroupId], [Name], [Title], [TopPositionPercentage], [LeftPositionPercentage], [HeightPercentage], [WidthPercentage], [BackgroundColor] " +
                    "FROM metaGroups " +
                    "WHERE PageId = @PageId");
                query.Parameters.Add(new QueryParameter("@PageId", DbType.Int32, pageId));
                return db.Select(query);
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve group", ex);
            }
        }

        public NamedObjectCollection<FieldGroup> GetFieldGroups(Page page)
        {
            try
            {
                NamedObjectCollection<FieldGroup> groups = new NamedObjectCollection<FieldGroup>();



                DataTable table = GetGroupsForPage(page.Id);
                foreach (DataRow row in table.Rows)
                {
                    groups.Add(new FieldGroup(row, page));
                }
                return (groups);
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve field groups", ex);
            }
        }
        public DataTable GetPatterns()
        {
            try
            {
                Query query = db.CreateQuery("SELECT [PatternId], [DataTypeId], [Expression], [Mask], [FormattedExpression] " +
                    "FROM metaPatterns ");
                return db.Select(query);
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve patterns", ex);
            }

        }
        public DataTable GetTextFieldsForPage(int viewId, int pageId)
        {
            try
            {
                #region Input Validation
                if (viewId < 1)
                {
                    throw new ArgumentOutOfRangeException("ViewId");
                }
                if (pageId < 1)
                {
                    throw new ArgumentOutOfRangeException("PageId");
                }
                #endregion

                Query query = db.CreateQuery("SELECT [Name], [FieldId] " +
                    "FROM metaFields " +
                    "WHERE [PageId] = @pageID AND [FieldTypeId] IN (1,3,4) " +
                    " AND [ViewId] = @viewID " +
                    "ORDER BY [Name]");
                query.Parameters.Add(new QueryParameter("@pageID", DbType.Int32, pageId));
                query.Parameters.Add(new QueryParameter("@viewID", DbType.Int32, viewId));
                return db.Select(query);
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve text fields for a page.", ex);
            }

        }

        /// <summary>
        /// Get the tab order for fields on a page
        /// </summary>
        /// <param name="pageId">The page Id</param>
        /// <returns>A data table containing tab order info</returns>
        public DataSets.TabOrders.TabOrderDataTable GetTabOrderForFields(int pageId)
        {
            try
            {
                #region Input Validation
                if (pageId < 1)
                {
                    throw new ArgumentOutOfRangeException("PageId");
                }
                #endregion

                Query query = db.CreateQuery("SELECT [FieldId],[Name],[PromptText], [TabIndex],[HasTabStop] " +
                    "FROM metaFields " +
                    "WHERE [PageId] = @pageID AND [FieldTypeId] NOT IN (2,15,21) " +
                    "ORDER BY [TabIndex]");
                query.Parameters.Add(new QueryParameter("@pageID", DbType.Int32, pageId));
                DataTable table = db.Select(query);
                DataSets.TabOrders tabOrders = new TabOrders();
                tabOrders.TabOrder.Merge(table);
                return tabOrders.TabOrder;
            }
            catch (Exception ex)
            {
                throw new GeneralException("Could not retrieve text fields for a page.", ex);
            }

        }

        ///// <summary>
        ///// Gets the tab index for a field name in metaFields
        ///// </summary>
        ///// <param name="viewId">The Id of the view</param>
        ///// <param name="fieldName">The field name in MetaFields</param>
        ///// <returns></returns>
        //public int GetColumnTabIndex(int viewId, string fieldName)
        //{
        //    try
        //    {
        //        #region Input Validation
        //        if (viewId < 0)
        //        {
        //            throw new ArgumentOutOfRangeException("View ID");
        //        }
        //        if (string.IsNullOrEmpty(fieldName))
        //        {
        //            throw new ArgumentNullException("Field Name");
        //        }
        //        #endregion  //Input Validation

        //        DbQuery query = db.CreateQuery("SELECT [TabIndex] FROM metaFields WHERE [ViewId] = @viewId And [Name] = @FieldName");
        //        query.Parameters.Add(new DbParameter("@viewId", DbType.Int32, viewId));
        //        query.Parameters.Add(new DbParameter("@fieldName", DbType.String, fieldName));
        //        return (int)db.ExecuteScalar(query);

        //    }
        //    catch (Exception ex)
        //    {
        //        throw new GeneralException("Could not retrieve tab index for a column", ex);
        //    }           
        //}


        ///// <summary>
        ///// 
        ///// </summary>
        ///// <param name="viewID"></param>
        ///// <param name="fieldName"></param>
        ///// <returns><