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