public OptionValue this[string Key] { get { string SystemPreFix = "SystemOptions_"; DataTable dt = null; bool InApplication = true; try { dt = (DataTable)System.Web.HttpContext.Current.Application[SystemPreFix]; } catch { } if (dt == null) { InApplication = false; dt = new SLS.Dal.Tables.T_Options().Open(_connStr,"[Key], [Value]", "", ""); } if (dt == null) { throw new Exception("T_Options 表读取发生错误,请检查数据连接或者数据库是否完整"); } DataRow[] dr = dt.Select("Key='" + Key + "'"); if ((dr == null) || (dr.Length < 1)) { throw new Exception("T_Options 表读取发生错误,请检查数据连接或者是否该表拥有 Key 值为 " + Key + " 记录"); } if (!InApplication) { try { System.Web.HttpContext.Current.Application.Lock(); System.Web.HttpContext.Current.Application.Add(SystemPreFix, dt); } catch { } finally { try { System.Web.HttpContext.Current.Application.UnLock(); } catch { } } } return new OptionValue(dr[0]["Value"]); } set { SLS.Dal.Procedures.P_SetOptions(_connStr,Key, value.Value.ToString()); string SystemPreFix = "SystemOptions_"; try { System.Web.HttpContext.Current.Application.Lock(); System.Web.HttpContext.Current.Application.Remove(SystemPreFix); } catch { } finally { try { System.Web.HttpContext.Current.Application.UnLock(); } catch { } } } }
public OptionValue this[string Key] { get { string SystemPreFix = "SystemOptions_"; DataTable dt = null; bool InApplication = true; try { dt = (DataTable)System.Web.HttpContext.Current.Application[SystemPreFix]; } catch { } if (dt == null) { InApplication = false; dt = new SLS.Dal.Tables.T_Options().Open(_connStr, "[Key], [Value]", "", ""); } if (dt == null) { throw new Exception("T_Options 表读取发生错误,请检查数据连接或者数据库是否完整"); } DataRow[] dr = dt.Select("Key='" + Key + "'"); if ((dr == null) || (dr.Length < 1)) { throw new Exception("T_Options 表读取发生错误,请检查数据连接或者是否该表拥有 Key 值为 " + Key + " 记录"); } if (!InApplication) { try { System.Web.HttpContext.Current.Application.Lock(); System.Web.HttpContext.Current.Application.Add(SystemPreFix, dt); } catch { } finally { try { System.Web.HttpContext.Current.Application.UnLock(); } catch { } } } return(new OptionValue(dr[0]["Value"])); } set { SLS.Dal.Procedures.P_SetOptions(_connStr, Key, value.Value.ToString()); string SystemPreFix = "SystemOptions_"; try { System.Web.HttpContext.Current.Application.Lock(); System.Web.HttpContext.Current.Application.Remove(SystemPreFix); } catch { } finally { try { System.Web.HttpContext.Current.Application.UnLock(); } catch { } } } }