public bool SaveTplCfg(TplCfgInfo info)
{
int maxBannerSequence = this.GetMaxBannerSequence();
StringBuilder builder = new StringBuilder("insert into Hishop_Banner (ShortDesc,ImageUrl,DisplaySequence,LocationType,Url,Type,IsDisable)");
builder.Append("values (@ShortDesc,@ImageUrl,@DisplaySequence,@LocationType,@Url,@Type,@IsDisable)");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.AddInParameter(sqlStringCommand, "ShortDesc", DbType.String, info.ShortDesc);
this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, info.ImageUrl);
this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.String, maxBannerSequence);
this.database.AddInParameter(sqlStringCommand, "LocationType", DbType.Int32, (int) info.LocationType);
this.database.AddInParameter(sqlStringCommand, "Url", DbType.String, info.Url);
this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, info.Type);
this.database.AddInParameter(sqlStringCommand, "IsDisable", DbType.Boolean, info.IsDisable);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public bool UpdateTplCfg(TplCfgInfo info)
{
StringBuilder builder = new StringBuilder();
builder.Append("update Hishop_Banner set ");
builder.Append("ShortDesc=@ShortDesc,");
builder.Append("ImageUrl=@ImageUrl,");
builder.Append("DisplaySequence=@DisplaySequence,");
builder.Append("LocationType=@LocationType,");
builder.Append("Url=@Url,");
builder.Append("Type=@Type,");
builder.Append("IsDisable=@IsDisable");
builder.Append(" where BannerId=@BannerId ");
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(builder.ToString());
this.database.AddInParameter(sqlStringCommand, "BannerId", DbType.Int32, info.Id);
this.database.AddInParameter(sqlStringCommand, "ShortDesc", DbType.String, info.ShortDesc);
this.database.AddInParameter(sqlStringCommand, "ImageUrl", DbType.String, info.ImageUrl);
this.database.AddInParameter(sqlStringCommand, "DisplaySequence", DbType.String, info.DisplaySequence);
this.database.AddInParameter(sqlStringCommand, "LocationType", DbType.Int32, (int) info.LocationType);
this.database.AddInParameter(sqlStringCommand, "Url", DbType.String, info.Url);
this.database.AddInParameter(sqlStringCommand, "Type", DbType.Int32, info.Type);
this.database.AddInParameter(sqlStringCommand, "IsDisable", DbType.Boolean, info.IsDisable);
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}
public static bool UpdateTplCfg(TplCfgInfo info)
{
return new BannerDao().UpdateTplCfg(info);
}
public static bool SaveTplCfg(TplCfgInfo info)
{
return new BannerDao().SaveTplCfg(info);
}
