public string GetSchemeBonusScalec(int lotteryId)
{
DataTable table = new Tables.T_Sites().Open("Opt_InitiateSchemeBonusScale,Opt_InitiateSchemeLimitLowerScaleMoney,Opt_InitiateSchemeLimitLowerScale,Opt_InitiateSchemeLimitUpperScaleMoney,Opt_InitiateSchemeLimitUpperScale", "", "");
string str = (_Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeBonusScale"].ToString(), 0.0) * 100.0).ToString();
string str2 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitLowerScaleMoney"].ToString(), 100.0).ToString();
string str3 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitLowerScale"].ToString(), 0.2).ToString();
string str4 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitUpperScaleMoney"].ToString(), 10000.0).ToString();
string str5 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitUpperScale"].ToString(), 0.05).ToString();
string str6 = DataCache.Lotteries[lotteryId];
int num6 = 0;
return (str + "|" + str2 + "|" + str3 + "|" + str4 + "|" + str5 + "|" + lotteryId.ToString() + "|" + str6 + "|" + num6.ToString());
}
public string this[string Manner, string NotificationType]
{
get
{
if ((this.Site == null) || (this.Site.ID < 1L))
{
throw new Exception("没有初始化 SiteNotificationTemplates 类的 Site 变量");
}
if (((Manner != "SMS") && (Manner != "Email")) && (Manner != "StationSMS"))
{
throw new Exception("SiteNotificationTemplates 类的通知方式 Manner 变量的值超出的范围，它的范围是：1 (SMS)手机短信 2 Email 3 (StationSMS)站内信");
}
string str = "SiteOptions_";
DataTable table = null;
bool flag = true;
try
{
table = (DataTable)HttpContext.Current.Application[str + this.Site.ID.ToString()];
}
catch
{
}
if ((table == null) || (table.Rows.Count < 1))
{
flag = false;
table = new Tables.T_Sites().Open("", "[ID] = " + this.Site.ID.ToString(), "");
}
if (table == null)
{
throw new Exception("SiteNotificationTemplates 类读取数据错误，请检查数据库连接设置");
}
if (table.Rows.Count < 1)
{
throw new Exception("SiteNotificationTemplates 类的 Site 变量值不在有效范围之内");
}
if (!flag)
{
try
{
HttpContext.Current.Application.Lock();
HttpContext.Current.Application.Add(str + this.Site.ID.ToString(), table);
}
catch
{
}
finally
{
try
{
HttpContext.Current.Application.UnLock();
}
catch
{
}
}
}
return table.Rows[0]["Template" + Manner + "_" + NotificationType].ToString().Replace("[SiteName]", this.Site.Name).Replace("[SiteUrl]", this.Site.Url);
}
set
{
if ((this.Site == null) || (this.Site.ID < 1L))
{
throw new Exception("没有初始化 SiteNotificationTemplates 类的 Site 变量");
}
if ((!(Manner == "SMS") && !(Manner == "Email")) && !(Manner == "StationSMS"))
{
throw new Exception("SiteNotificationTemplates 类的通知方式 Manner 变量的值超出的范围，它的范围是：1 (SMS)手机短信 2 Email 3 (StationSMS)站内信");
}
if (MSSQL.ExecuteNonQuery("update T_Sites set [Template" + Manner + "_" + NotificationType + "] = @Value where [ID]=@ID", new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.VarChar, 0, ParameterDirection.Input, value), new MSSQL.Parameter("ID", SqlDbType.BigInt, 0, ParameterDirection.Input, this.Site.ID) }) < 0)
{
throw new Exception("SiteNotificationTemplates 类读取数据错误，请检查数据库连接设置。如果数据库连接设置没有问题，可能是 NotificationType 变量的值不在有效范围之内");
}
string str2 = "SiteOptions_";
try
{
HttpContext.Current.Application.Lock();
HttpContext.Current.Application.Remove(str2 + this.Site.ID.ToString());
}
catch
{
}
finally
{
try
{
HttpContext.Current.Application.UnLock();
}
catch
{
}
}
}
}
public string GetSchemeBonusScalec()
{
DataTable table = new Tables.T_Sites().Open("Opt_InitiateSchemeBonusScale,Opt_InitiateSchemeLimitLowerScaleMoney,Opt_InitiateSchemeLimitLowerScale,Opt_InitiateSchemeLimitUpperScaleMoney,Opt_InitiateSchemeLimitUpperScale", "", "");
string str = (_Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeBonusScale"].ToString(), 0.0) * 100.0).ToString();
string str2 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitLowerScaleMoney"].ToString(), 100.0).ToString();
string str3 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitLowerScale"].ToString(), 0.2).ToString();
string str4 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitUpperScaleMoney"].ToString(), 10000.0).ToString();
string str5 = _Convert.StrToDouble(table.Rows[0]["Opt_InitiateSchemeLimitUpperScale"].ToString(), 0.05).ToString();
return (str + "|" + str2 + "|" + str3 + "|" + str4 + "|" + str5 + "|时时乐");
}
public OptionValue this[string Key]
{
get
{
string str = "SiteOptions_";
DataTable table = null;
bool flag = true;
try
{
table = (DataTable)HttpContext.Current.Application[str + this.Site.ID.ToString()];
}
catch
{
}
if ((table == null) || (table.Rows.Count < 1))
{
flag = false;
table = new Tables.T_Sites().Open("", "[ID] = " + this.Site.ID.ToString(), "");
}
if (table == null)
{
throw new Exception("T_Sites 表读取发生错误，请检查数据连接或者数据库是否完整");
}
if (table.Rows.Count < 1)
{
throw new Exception("没有读到站点 ID 为 " + this.Site.ID.ToString() + " 的站点信息");
}
if (!flag)
{
try
{
HttpContext.Current.Application.Lock();
HttpContext.Current.Application.Add(str + this.Site.ID.ToString(), table);
}
catch
{
}
finally
{
try
{
HttpContext.Current.Application.UnLock();
}
catch
{
}
}
}
return new OptionValue(table.Rows[0][Key]);
}
set
{
if ((this.Site == null) || (this.Site.ID < 1L))
{
throw new Exception("没有初始化 SiteOptions 类的 Site 变量");
}
DataTable table = new Tables.T_Sites().Open(Key, "[ID] = " + this.Site.ID.ToString(), "");
if (table == null)
{
throw new Exception("T_Sites 表读取发生错误，请检查数据连接或者是否该表拥有 " + Key + " 字段");
}
if (table.Rows.Count < 1)
{
throw new Exception("没有读到站点 ID 为 " + this.Site.ID.ToString() + " 的站点信息");
}
switch (table.Columns[0].DataType.Name)
{
case "Byte[]":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.VarChar, 0, ParameterDirection.Input, value.Value.ToString()) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "String":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.VarChar, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "Int16":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.SmallInt, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "Int32":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.Int, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "Int64":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.BigInt, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "Decimal":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.Money, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "Boolean":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.Bit, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
case "Double":
if (MSSQL.ExecuteNonQuery("update T_Sites set " + Key + " = @Value where [ID] = " + this.Site.ID.ToString(), new MSSQL.Parameter[] { new MSSQL.Parameter("Value", SqlDbType.Float, 0, ParameterDirection.Input, value.Value) }) < 0)
{
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
break;
default:
throw new Exception("设置站点属性 " + Key + " 发生异常");
}
string str2 = "SiteOptions_";
try
{
HttpContext.Current.Application.Lock();
HttpContext.Current.Application.Remove(str2 + this.Site.ID.ToString());
}
catch
{
}
finally
{
try
{
HttpContext.Current.Application.UnLock();
}
catch
{
}
}
}
}
