/// <summary>
/// 更新一个产品
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(TblAdProductV2 entity)
{
string sql = @" UPDATE Gungnir..[tbl_AdProduct_v2]
SET PID = @PID ,
Position = @Position ,
State = @State ,
LastUpdateDateTime = GETDATE() ,
PromotionPrice = @PromotionPrice ,
PromotionNum = @PromotionNum ,
newappsetdataId = @newappsetdataId ,
ActivityId = @ActivityId
WHERE ID = @ID";
SqlParameter[] sqlPrams = new SqlParameter[] {
new SqlParameter("@PID", entity.PId),
new SqlParameter("@Position", entity.Position),
new SqlParameter("@State", entity.State),
new SqlParameter("@PromotionPrice", entity.PromotionPrice),
new SqlParameter("@PromotionNum", entity.PromotionNum),
new SqlParameter("@newappsetdataId", entity.NewAppSetDataId),
new SqlParameter("@ID", entity.Id),
new SqlParameter("@ActivityId", entity.ActivityId)
};
using (SqlConnection SqlServerConn = new SqlConnection(connstring))
{
return(SqlHelper.ExecuteNonQuery(SqlServerConn, CommandType.Text, sql, sqlPrams));
}
}
public ActionResult Edit(TblAdProductV2 product)
{
//查询产品Id是否存在
var resultData = manager.GetProductInfoByPIdNewVersion(product.PId);
if (resultData == null)
{
ViewBag.Result = "您输入的产品Id不存在.";
return(View());
}
//1.先查询数据是否存在
//2. 如果不存在，直接跳转到HomePageConfig/Index页面
if (product != null)
{
if (services.HasSingleProduct(product.Id))
{
ViewBag.Result = services.UpdateProduct(product);
}
else
{
return(RedirectToAction("Index", "HomePageConfig"));
}
}
return(RedirectToAction("SearchProductsByMoudleId", new { id = product.NewAppSetDataId }));
}
/// <summary>
/// 更新产品信息
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int UpdateProduct(TblAdProductV2 entity)
{
//logger.Log(Level.Debug, entity.ToString());
//没有对应的产品信息
if (productDAL.SelectSingle(entity.Id) == null)
{
return(0);
}
//throw Bussiness Exception
return(productDAL.Update(entity));
}
public ActionResult Add(TblAdProductV2 product, int id)
{
var resultData = manager.GetProductInfoByPIdNewVersion(product.PId);
if (resultData == null)
{
ViewBag.Result = "您输入的产品Id不存在.";
return(View());
}
if (product != null)
{
// 设置上一个请求传递过来的appsetDataid
product.NewAppSetDataId = id;
ViewBag.Result = services.AddProduct(product);
}
return(RedirectToAction("SearchProductsByMoudleId", new { id = id }));
}
/// <summary>
/// 添加一个产品
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(TblAdProductV2 entity)
{
string sql = @"
INSERT INTO Gungnir..[tbl_AdProduct_v2]
( PID ,
Position ,
State ,
CreateDateTime ,
PromotionPrice ,
PromotionNum ,
newappsetdataId ,
ActivityId
)
VALUES ( @PID ,
@Position ,
@State ,
GETDATE() ,
@PromotionPrice ,
@PromotionNum ,
@newappsetdataId ,
@ActivityId
)";
SqlParameter[] sqlPrams = new SqlParameter[]
{
new SqlParameter("@PID", entity.PId),
new SqlParameter("@Position", entity.Position),
new SqlParameter("@State", entity.State),
new SqlParameter("@PromotionPrice", entity.PromotionPrice),
new SqlParameter("@PromotionNum", entity.PromotionNum),
new SqlParameter("@newappsetdataId", entity.NewAppSetDataId),
new SqlParameter("@ActivityId", entity.ActivityId)
};
//释放 connection资源
using (SqlConnection SqlServerConn = new SqlConnection(connstring))
{
return(SqlHelper.ExecuteNonQuery(SqlServerConn, CommandType.Text, sql, sqlPrams));
}
}
/// <summary>
/// 删除一个产品 (暂未实现，以后有需要再实现.)
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Remove(TblAdProductV2 entity)
{
throw new NotImplementedException();
}
/// <summary>
/// 新增产品
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int AddProduct(TblAdProductV2 entity)
{
return(productDAL.Add(entity));
}
