/// <summary>
/// 修改LP
/// </summary>
/// <param name="landingPage">
/// PromoteLandingPage对象实例.
/// </param>
public void Modify(Promote_LandingPage landingPage)
{
this.landingPageDA.Update(landingPage);
}
/// <summary>
/// 添加Promote_LandingPage.
/// </summary>
/// <param name="landingPage">
/// Promote_LandingPage对象实例.
/// </param>
/// <returns>
/// Promote_LandingPage编号.
/// </returns>
public int Insert(Promote_LandingPage landingPage)
{
if (landingPage == null)
{
throw new ArgumentNullException("landingPage");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.VarChar,
landingPage.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
landingPage.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"StartTime",
SqlDbType.DateTime,
landingPage.StartTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EndTime",
SqlDbType.DateTime,
landingPage.EndTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Link",
SqlDbType.VarChar,
landingPage.Link,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Content",
SqlDbType.Text,
landingPage.Content,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
landingPage.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"MasterPicture",
SqlDbType.VarChar,
landingPage.MasterPicture,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture01",
SqlDbType.VarChar,
landingPage.Picture01,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture02",
SqlDbType.VarChar,
landingPage.Picture02,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture03",
SqlDbType.VarChar,
landingPage.Picture03,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture04",
SqlDbType.VarChar,
landingPage.Picture04,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture05",
SqlDbType.VarChar,
landingPage.Picture05,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_LandingPage_Insert", parameters, null);
return (int)parameters.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 添加LP.
/// </summary>
/// <param name="landingPage">
/// PromoteLandingPage对象实例.
/// </param>
/// <returns>
/// PromoteLandingPage编号.
/// </returns>
public int Add(Promote_LandingPage landingPage)
{
return this.landingPageDA.Insert(landingPage);
}
/// <summary>
/// 更新Promote_LandingPage.
/// </summary>
/// <param name="landingPage">
/// Promote_LandingPage对象实例.
/// </param>
public void Update(Promote_LandingPage landingPage)
{
if (landingPage == null)
{
throw new ArgumentNullException("landingPage");
}
var parameters = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"ID",
SqlDbType.Int,
landingPage.ID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"PID",
SqlDbType.Int,
landingPage.PID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Name",
SqlDbType.VarChar,
landingPage.Name,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
landingPage.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"StartTime",
SqlDbType.DateTime,
landingPage.StartTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"EndTime",
SqlDbType.DateTime,
landingPage.EndTime,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Link",
SqlDbType.VarChar,
landingPage.Link,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Content",
SqlDbType.Text,
landingPage.Content,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"MasterPicture",
SqlDbType.VarChar,
landingPage.MasterPicture,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture01",
SqlDbType.VarChar,
landingPage.Picture01,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture02",
SqlDbType.VarChar,
landingPage.Picture02,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture03",
SqlDbType.VarChar,
landingPage.Picture03,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture04",
SqlDbType.VarChar,
landingPage.Picture04,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Picture05",
SqlDbType.VarChar,
landingPage.Picture05,
ParameterDirection.Input)
};
this.SqlServer.ExecuteNonQuery(CommandType.StoredProcedure, "sp_Promote_LandingPage_Update", parameters, null);
}
