public void GetSettingsItem_ShouldReturnSettingItem(string settingName, [Frozen] Item contextItem, [Substitute] SiteContext context, Db db, string definitionItemName)
{
var provider = new SiteSettingsProvider(context);
var settingItemId = ID.NewID;
var definitionId = ID.NewID;
db.Add(new DbItem(definitionItemName, definitionId)
{
new DbItem(SiteSettingsProvider.SettingsRootName)
{
new DbItem(DatasourceProvider.DatasourceSettingsName, ID.NewID, Templates.SiteSettings.ID)
{
new DbItem(settingName, settingItemId)
}
}
});
var definitionItem = db.GetItem(definitionId);
var setting = db.GetItem(settingItemId);
context.GetSiteDefinition(Arg.Any <Item>()).Returns(new SiteDefinition {
Item = definitionItem
});
var settingItem = provider.GetSetting(contextItem, DatasourceProvider.DatasourceSettingsName, settingName);
settingItem.ID.ShouldBeEquivalentTo(setting.ID);
}
public void GetSettingsItem_SiteDefinitionDoesNotExists_ShouldReturnNull(string settingName, [Frozen] Item contextItem, [Substitute] SiteContext context, Db db, string definitionItemName)
{
var provider = new SiteSettingsProvider(context);
context.GetSiteDefinition(Arg.Any <Item>()).Returns((SiteDefinition)null);
var settingItem = provider.GetSetting(contextItem, DatasourceProvider.DatasourceSettingsName, settingName);
settingItem.Should().BeNull();
}
public override SiteSettings GetDistributorSettings(string siteUrl)
{
SiteSettings settings = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_Settings WHERE LOWER(@SiteUrl) = LOWER(SiteUrl)");
this.database.AddInParameter(sqlStringCommand, "SiteUrl", DbType.String, siteUrl);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
settings = SiteSettingsProvider.PopulateDistributorSettings(reader);
}
reader.Close();
}
return(settings);
}
public override SiteSettings GetDistributorSettings(int userId)
{
SiteSettings settings = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_Settings WHERE @UserId = UserId");
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
if (reader.Read())
{
settings = SiteSettingsProvider.PopulateDistributorSettings(reader);
}
reader.Close();
}
return(settings);
}
public override SiteSettings GetDistributorSettings(int userId)
{
SiteSettings result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_Settings WHERE @UserId = UserId");
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, userId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = SiteSettingsProvider.PopulateDistributorSettings(dataReader);
}
dataReader.Close();
}
return(result);
}
public override SiteSettings GetDistributorSettings(string siteUrl)
{
SiteSettings result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_Settings WHERE LOWER(@SiteUrl) = LOWER(SiteUrl)");
this.database.AddInParameter(sqlStringCommand, "SiteUrl", System.Data.DbType.String, siteUrl);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
if (dataReader.Read())
{
result = SiteSettingsProvider.PopulateDistributorSettings(dataReader);
}
dataReader.Close();
}
return(result);
}
/// <summary>
/// 获取分销站点设置
/// </summary>
/// <param name="siteUrl"></param>
/// <returns></returns>
public override SiteSettings GetDistributorSettings(int userId)
{
SiteSettings settings = null;
DbCommand sqlStringCommand = database.GetSqlStringCommand("select * from distro_Settings where @UserId=UserId");
database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, userId);
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
if (null != reader && reader.Read())
{
settings = SiteSettingsProvider.PopulateDistributorSettings(reader);
}
}
return(settings);
}
/// <summary>
/// 获取分销站点设置
/// </summary>
/// <param name="siteUrl"></param>
/// <returns></returns>
public override SiteSettings GetDistributorSettings(string siteUrl)
{
SiteSettings siteConfig = null;
DbCommand sqlStringCommand = database.GetSqlStringCommand(@"select * from distro_Settings where lower(SiteUrl)=@SiteUrl or lower(SiteUrl2)=@SiteUrl");
database.AddInParameter(sqlStringCommand, "SiteUrl", DbType.String, siteUrl.ToLower());
using (IDataReader reader = database.ExecuteReader(sqlStringCommand))
{
if (null != reader && reader.Read())
{
siteConfig = SiteSettingsProvider.PopulateDistributorSettings(reader);
}
}
return(siteConfig);
}
