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); } } }