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