public static List <UserDbLayerInfo> GetLayersMetadates(UserDbLayerType userDbLayerType = UserDbLayerType.None) { var infos = new List <UserDbLayerInfo>(); var query = string.Format("SELECT * FROM gisUserLayer WHERE intDeleted=0"); if (userDbLayerType != UserDbLayerType.None) { query += string.Format(" AND intType={0}", (int)userDbLayerType); } using (var conn = new SqlConnection(ConnectionString)) { conn.Open(); var dt = SqlExecHelper.SqlExecTable(new SqlConnection(ConnectionString), query); foreach (DataRow row in dt.Rows) { var style = new VectorStyle(); if (row["xmlStyle"] != DBNull.Value && !string.IsNullOrEmpty(row["xmlStyle"] as string)) { XmlDocument doc = new XmlDocument(); doc.LoadXml((string)row["xmlStyle"]); style = StyleSerializer.DeserializeFromDocument(doc) as VectorStyle; } ITheme theme = null; if (row["xmlTheme"] != DBNull.Value && !string.IsNullOrEmpty(row["xmlTheme"] as string)) { XmlDocument doc = new XmlDocument(); doc.LoadXml((string)row["xmlTheme"]); theme = ThemeSerializer.DeserializeFromDocument(doc); } infos.Add(new UserDbLayerInfo { m_Id = (Guid)row["guidLayer"], m_Name = (String)row["strName"], m_UserId = (long)row["idfUser"], m_CreationDate = (DateTime)row["CreationDate"], m_LastModifiedDate = (DateTime)row["LastModifiedDate"], m_Description = row["strDescription"] as string, m_LayerType = (UserDbLayerType)row["intType"], m_PivotalLayer = (PivotLayerType)row["intPivotalLayer"], m_Style = style, m_Theme = theme }); } return(infos); } }
public static IDictionary <Guid, String> GetLayersNames(UserDbLayerType userDbLayerType = UserDbLayerType.None) { var names = new Dictionary <Guid, string>(); var query = "SELECT guidLayer, strName FROM gisUserLayer WHERE intDeleted=0"; if (userDbLayerType != UserDbLayerType.None) { query += string.Format(" AND intType={0}", (int)userDbLayerType); } var dt = SqlExecHelper.SqlExecTable(new SqlConnection(ConnectionString), query); foreach (DataRow row in dt.Rows) { names.Add((Guid)row[0], (String)row[1]); } return(names); }