/// <summary> /// 获取商品信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Edit(MGoodInfo model) { var str = @" UPDATE GoodInfo SET Title=@Title, NowPrice=@NowPrice, OldPrice=@OldPrice, Type=@Type, SourceMall=@SourceMall, GoodId=@GoodId, ImgUrl=@ImgUrl, BuyUrl=@BuyUrl, IsHot=@IsHot WHERE Id=@Id "; SqlParameter[] parames ={ new SqlParameter("@Id",model.Id){ DbType=DbType.Int32}, new SqlParameter("@Title",model.Title){ DbType=DbType.String}, new SqlParameter("@NowPrice",model.NowPrice){ DbType=DbType.Decimal}, new SqlParameter("@OldPrice",model.OldPrice){ DbType=DbType.Decimal}, new SqlParameter("@Type",model.Type){ DbType=DbType.Int32}, new SqlParameter("@SourceMall",model.SourceMall){ DbType=DbType.Int32}, new SqlParameter("@GoodId",model.GoodId){ DbType=DbType.String}, new SqlParameter("@ImgUrl",model.ImgUrl){ DbType=DbType.String}, new SqlParameter("@BuyUrl",model.BuyUrl){ DbType=DbType.String}, new SqlParameter("@IsHot",model.IsHot){ DbType=DbType.Boolean} }; return _DB.ExecuteNonQuery(str, parames)>0; }
public ActionResult AddGood(MGoodInfo model) { if (model == null) return Json(new { code = "101", msg = "参数不能为空!!" }, JsonRequestBehavior.AllowGet); var bll = new BGoodInfo(); int addId = 0; model.AddDateTime = DateTime.Now; var isSc = bll.Add(model, out addId); if (!isSc) return Json(new { code = "101", msg = "添加失败!!" }, JsonRequestBehavior.AllowGet); return Json(new { code = "100", msg = "Bingo!!" }, JsonRequestBehavior.AllowGet); }
public ActionResult EditGood(MGoodInfo model) { var id = Request.GetF("Id").GetInt(0, false); if (id <= 0) return Json(new { code = "101", msg = "需要编辑的商品ID不正确!!" }, JsonRequestBehavior.AllowGet); if (model == null) return Json(new { code = "101", msg = "参数不能为空!!" }, JsonRequestBehavior.AllowGet); var bll = new BGoodInfo(); var isSc = bll.Edit(model); if (!isSc) return Json(new { code = "101", msg = "编辑失败!!" }); return Json(new { code = "100", msg = "Bingo!!" }, JsonRequestBehavior.AllowGet); }
/// <summary> /// 获取商品信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Add(MGoodInfo model, out int id) { id = 0; if (model == null) return false; var str = @" INSERT INTO GoodInfo(Title,NowPrice,OldPrice,Type,SourceMall,AddDateTime,GoodId,ImgUrl,BuyUrl,IsHot) VALUES (@Title,@NowPrice,@OldPrice,@Type,@SourceMall,@AddDateTime,@GoodId,@ImgUrl,@BuyUrl,@IsHot) SELECT SCOPE_IDENTITY(); "; SqlParameter[] parames ={ new SqlParameter("@Title",model.Title){ DbType=DbType.String}, new SqlParameter("@NowPrice",model.NowPrice){ DbType=DbType.Decimal}, new SqlParameter("@OldPrice",model.OldPrice){ DbType=DbType.Decimal}, new SqlParameter("@Type",model.Type){ DbType=DbType.Int32}, new SqlParameter("@SourceMall",model.SourceMall){ DbType=DbType.Int32}, new SqlParameter("@AddDateTime",model.AddDateTime){ DbType=DbType.DateTime}, new SqlParameter("@GoodId",model.GoodId){ DbType=DbType.String}, new SqlParameter("@ImgUrl",model.ImgUrl){ DbType=DbType.String}, new SqlParameter("@BuyUrl",model.BuyUrl){ DbType=DbType.String}, new SqlParameter("@IsHot",model.IsHot){ DbType=DbType.Boolean} }; id = _DB.ExecuteScalar(str, parames).GetInt(0, false); return id > 0; }
/// <summary> /// 添加商品 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Add(MGoodInfo model, out int id) { return _dal.Add(model,out id); }
/// <summary> /// 编辑商品 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Edit(MGoodInfo model) { return _dal.Edit(model); }