网站存储单个数据类型的位置

<configuration>

  <appSettings>
    <add key=\"ClientValidationEnabled\" value=\"true\" />
    <add key=\"UnobtrusiveJavaScriptEnabled\" value=\"true\" />
    <add key=\"MyCustomSetting\" value=\"abcd1234\" />
  </appSettings>

using System.Configuration;

string value = ConfigurationManager.AppSettings[\"MyCustomSetting\"];

public static class SysProperties
{
    public static string SMTPServer
    {
        get
        {
            return GetProperty(\"SMTPServer\").ToString();
        }
    }

    public static decimal TicketFee
    {
        get
        {
            return Convert.ToDecimal(GetProperty(\"TicketFee\"));
        }
    }

    private static object GetProperty(string PropertyName)
    {
        object PropertyValue = null;
        if (HttpContext.Current != null)
            PropertyValue = HttpContext.Current.Cache[PropertyName];

        if (PropertyValue == null)
        {
            SqlCommand cmSQL = new SqlCommand(\"SELECT Value FROM tblProperty WHERE Name = @PropertyName\");
            cmSQL.Parameters.AddWithValue(\"@PropertyName\", PropertyName);

            DataTable dt = Functions.RunSqlCommand(cmSQL);

            PropertyValue = dt.Rows[0][0];

            if (HttpContext.Current != null)
                HttpContext.Current.Cache.Insert(PropertyName, PropertyValue, null, DateTime.UtcNow.AddMinutes(5), System.Web.Caching.Cache.NoSlidingExpiration);

            return PropertyValue;
        }
        else
        {
            return PropertyValue;
        }
    }
}

// Static constructor ensures that SqlDependency.Start is called before
// we try to use any SqlCacheDependencies   
static Functions()
{
    SqlDependency.Start(ConnectionString);
}

public static string GetUserFullName(string UserName)
{
    return GetSqlCachedValue(\"SELECT FirstName + \' \' + LastName FROM dbo.tblUser WHERE UserName = @Id\", UserName, \"UserFullName\").ToString();
}

public static string GetEventNameFromId(int Id)
{
    return GetSqlCachedValue(\"SELECT EventName FROM dbo.tblEvents WHERE EventID = @Id\", Id, \"EventName\").ToString();
}

private static object GetSqlCachedValue(string Query, object Id, string CacheName)
{
    // Get the cache
    System.Web.Caching.Cache currentCache = HttpContext.Current.Cache;

    object Value = null;

    // We use a standard naming convention for storing items in the application\'s cache
    string cacheKey = string.Format(\"{0}_{1}\", CacheName, Id.ToString());

    // Attempt to retrieve the value
    if (currentCache != null && currentCache[cacheKey] != null)
        Value = currentCache[cacheKey];

    // If the value was not stored in cache, then query the database to get the value
    if (Value == null)
    {
        // Run the query provided to retrieve the value. We always expect the query to have the @Id parameter specified, that we can use
        // to plug-in the Id parameter given to this function.
        SqlCommand Command = new SqlCommand(Query);
        Command.Parameters.AddWithValue(\"@Id\", Id);

        // Generate a cache dependency for this query
        System.Web.Caching.SqlCacheDependency dependency = new System.Web.Caching.SqlCacheDependency(Command);

        // Run the query
        DataTable dt = RunSqlCommand(Command);

        if (dt.Rows.Count == 1)
        {
            // Grab the value returned
            Value = dt.Rows[0][0];

            // Save the value in the cache, so next time we don\'t have to query SQL Server
            if (currentCache != null)
            {
                currentCache.Insert(cacheKey, Value, dependency);
            }
        }
    }

    // return the final value
    return Value;
}