public void Update(Domain.DistributionOEM oem)
{
string sql = @"UPDATE [dbo].[T_OEMInfo] SET [Company] = @Company ,[CompanyName] = @CompanyName ,[SiteName] = @SiteName ,[DomainName] = @DomainName ,[ManageEmail] = @ManageEmail ,[ICPRecord] = @ICPRecord ,[EmbedCode] = @EmbedCode ,[LoginUrl] = @LoginUrl ,[Enabled] = @Enabled ,[AllowSelfRegex] = @AllowSelfRegex ,[UseB3BConfig] = @UseB3BConfig ,[Contract] = @Contract ,[Setting] = @Setting ,[RegisterTime] = @RegisterTime ,[EffectTime] = @EffectTime ,[AuthCashDeposit] = @AuthCashDeposit ,[OperatorAccount] = @OperatorAccount,LogoPath=@LogoPath WHERE [Id] = @Id ";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("@Company", oem.CompanyId);
dbOperator.AddParameter("@CompanyName", oem.Company.AbbreviateName);
dbOperator.AddParameter("@SiteName", oem.SiteName);
dbOperator.AddParameter("@DomainName", oem.DomainName);
dbOperator.AddParameter("@ManageEmail", oem.ManageEmail);
dbOperator.AddParameter("@ICPRecord", oem.ICPRecord);
if (string.IsNullOrWhiteSpace(oem.EmbedCode))
{
dbOperator.AddParameter("@EmbedCode", DBNull.Value);
}
else
{
dbOperator.AddParameter("@EmbedCode", oem.EmbedCode);
}
dbOperator.AddParameter("@LoginUrl", oem.LoginUrl);
dbOperator.AddParameter("@Enabled", oem.Enabled);
dbOperator.AddParameter("@AllowSelfRegex", oem.AllowSelfRegex);
dbOperator.AddParameter("@UseB3BConfig", oem.UseB3BConfig);
dbOperator.AddParameter("@Contract", oem.Contract.Id);
dbOperator.AddParameter("@Setting", oem.Setting.Id);
dbOperator.AddParameter("@RegisterTime", oem.RegisterTime);
dbOperator.AddParameter("@EffectTime", oem.EffectTime);
dbOperator.AddParameter("@AuthCashDeposit", oem.AuthCashDeposit);
dbOperator.AddParameter("@OperatorAccount", oem.OperatorAccount);
dbOperator.AddParameter("@LogoPath", oem.LogoPath);
dbOperator.AddParameter("@Id", oem.Id);
dbOperator.ExecuteNonQuery(sql);
}
}
public void Insert(Domain.DistributionOEM oem, string abbreviateName)
{
string sql = @"INSERT INTO [dbo].[T_OEMInfo] ([Id],[Company],[CompanyName],[SiteName],[DomainName],[ManageEmail],[ICPRecord],[EmbedCode]
,[Enabled],[AllowSelfRegex],[UseB3BConfig],[RegisterTime] ,[EffectTime],[AuthCashDeposit],[OperatorAccount],[LoginUrl])
VALUES (@Id,@Company,@CompanyName,@SiteName,@DomainName,@ManageEmail,@ICPRecord,@EmbedCode,@Enabled,@AllowSelfRegex,@UseB3BConfig,@RegisterTime
,@EffectTime,@AuthCashDeposit,@OperatorAccount,@LoginUrl)";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", oem.Id);
dbOperator.AddParameter("Company", oem.CompanyId);
dbOperator.AddParameter("CompanyName", abbreviateName);
dbOperator.AddParameter("SiteName", oem.SiteName);
dbOperator.AddParameter("DomainName", oem.DomainName);
if (string.IsNullOrWhiteSpace(oem.ManageEmail))
{
dbOperator.AddParameter("ManageEmail", string.Empty);
}
else
{
dbOperator.AddParameter("ManageEmail", oem.ManageEmail);
}
if (string.IsNullOrWhiteSpace(oem.ICPRecord))
{
dbOperator.AddParameter("ICPRecord", string.Empty);
}
else
{
dbOperator.AddParameter("ICPRecord", oem.ICPRecord);
}
if (string.IsNullOrWhiteSpace(oem.EmbedCode))
{
dbOperator.AddParameter("EmbedCode", DBNull.Value);
}
else
{
dbOperator.AddParameter("EmbedCode", oem.EmbedCode);
}
dbOperator.AddParameter("Enabled", oem.Enabled);
dbOperator.AddParameter("AllowSelfRegex", oem.AllowSelfRegex);
dbOperator.AddParameter("UseB3BConfig", oem.UseB3BConfig);
dbOperator.AddParameter("RegisterTime", oem.RegisterTime);
dbOperator.AddParameter("EffectTime", oem.EffectTime);
dbOperator.AddParameter("AuthCashDeposit", oem.AuthCashDeposit);
dbOperator.AddParameter("OperatorAccount", oem.OperatorAccount);
dbOperator.AddParameter("LoginUrl", oem.LoginUrl);
dbOperator.ExecuteNonQuery(sql);
}
}
public void UpdateOemInfo(Domain.DistributionOEM oem)
{
string sql = @"UPDATE [dbo].[T_OEMInfo] SET [SiteName] = @SiteName,[DomainName] = @DomainName,[UseB3BConfig] = @UseB3BConfig ,[EffectTime] = @EffectTime,[AuthCashDeposit] = @AuthCashDeposit,LoginUrl=@LoginUrl
WHERE Id = @Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", oem.Id);
dbOperator.AddParameter("SiteName", oem.SiteName);
dbOperator.AddParameter("DomainName", oem.DomainName);
dbOperator.AddParameter("UseB3BConfig", oem.UseB3BConfig);
dbOperator.AddParameter("EffectTime", oem.EffectTime);
dbOperator.AddParameter("AuthCashDeposit", oem.AuthCashDeposit);
dbOperator.AddParameter("LoginUrl", oem.LoginUrl);
dbOperator.ExecuteNonQuery(sql);
}
}
