private void setup()
 {
     using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select macroPropertyHidden, macroPropertyType, macroPropertySortOrder, macroPropertyAlias, macroPropertyName from cmsMacroProperty where id = @id", new SqlParameter("@id", _id)))
     {
         if (dr.Read())
         {
             _public    = bool.Parse(dr["macroPropertyHidden"].ToString());
             _sortOrder = int.Parse(dr["macroPropertySortOrder"].ToString());
             _alias     = dr["macroPropertyAlias"].ToString();
             _name      = dr["macroPropertyName"].ToString();
             _type      = new MacroPropertyType(int.Parse(dr["macroPropertyType"].ToString()));
         }
     }
 }
		private void setup() 
		{
			using (SqlDataReader dr = Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(GlobalSettings.DbDSN, CommandType.Text, "select macroPropertyHidden, macroPropertyType, macroPropertySortOrder, macroPropertyAlias, macroPropertyName from cmsMacroProperty where id = @id", new SqlParameter("@id", _id)))
			{
				if(dr.Read())
				{
					_public = bool.Parse(dr["macroPropertyHidden"].ToString());
					_sortOrder = int.Parse(dr["macroPropertySortOrder"].ToString());
					_alias = dr["macroPropertyAlias"].ToString();
					_name = dr["macroPropertyName"].ToString();
					_type = new MacroPropertyType(int.Parse(dr["macroPropertyType"].ToString()));
				}
			}
		}