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