public void UpdateSetting(Domain.OemSetting setting)
{
string sql = @"UPDATE [dbo].[T_OEMSetting] SET SiteKeyWord=@SiteKeyWord ,SiteDescription=@SiteDescription,BGColor=@BGColor,copyrightInfo=@copyrightInfo WHERE ID = @Id;";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("@SiteKeyWord", setting.SiteKeyWord);
dbOperator.AddParameter("@SiteDescription", setting.SiteDescription);
//dbOperator.AddParameter("@LogoPath", setting.LogoPath);
dbOperator.AddParameter("@BGColor", setting.BGColor);
dbOperator.AddParameter("@copyrightInfo", setting.CopyrightInfo);
dbOperator.AddParameter("@Id", setting.Id);
dbOperator.ExecuteNonQuery(sql);
}
}
public void InsertSetting(Domain.OemSetting setting, Guid oemid)
{
string sql = @"INSERT INTO [dbo].[T_OEMSetting] ([Id],[SiteKeyWord],[SiteDescription] ,[BGColor],[copyrightInfo]) VALUES (@Id ,@SiteKeyWord ,@SiteDescription ,@BGColor ,@copyrightInfo);UPDATE [dbo].[T_OEMInfo] SET [Setting] = @settingId WHERE [Id] = @oemId ;";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("@Id", setting.Id);
dbOperator.AddParameter("@settingId", setting.Id);
dbOperator.AddParameter("@oemId", oemid);
dbOperator.AddParameter("@SiteKeyWord", setting.SiteKeyWord);
dbOperator.AddParameter("@SiteDescription", setting.SiteDescription);
//dbOperator.AddParameter("@LogoPath", setting.LogoPath);
dbOperator.AddParameter("@BGColor", setting.BGColor);
dbOperator.AddParameter("@copyrightInfo", setting.CopyrightInfo);
dbOperator.ExecuteNonQuery(sql);
}
}
public Domain.OemSetting QuerySetting(Guid id)
{
string sql = @"SELECT [Id],[SiteKeyWord],[SiteDescription] ,[BGColor],[copyrightInfo] FROM T_OEMSetting WHERE Id=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("@Id", id);
using (var reader = dbOperator.ExecuteReader(sql))
{
Domain.OemSetting setting = null;
if (reader.Read())
{
setting = new Domain.OemSetting();
setting.Id = reader.GetGuid(0);
setting.SiteKeyWord = reader.GetString(1);
setting.SiteDescription = reader.GetString(2);
//setting.LogoPath = reader.GetString(3);
setting.BGColor = reader.GetString(3);
setting.CopyrightInfo = reader.GetString(4);
}
return(setting);
}
}
}