public ActionResult Edit(int?item_id)
{
if (item_id.HasValue)
{
TMall.Models.ItemModel item = TMall.Respository.Item.GetItem(item_id.Value);
return(View(item));
}
return(View());
}
public ActionResult Detail(int?item_id)
{
if (!item_id.HasValue)
{
return(new HttpStatusCodeResult(404)); //参数不合法,跳转到404页面
}
TMall.Models.ItemModel item = TMall.Respository.Item.GetItem(item_id.Value);
if (item == null)
{
return(new HttpStatusCodeResult(404));
}
return(View(item));
}
// 更新商品
public static bool UpdateItem(TMall.Models.ItemModel item)
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@A", item.ItemCategoryId),
new SqlParameter("@B", item.ItemName),
new SqlParameter("@C", item.ItemPicture),
new SqlParameter("@D", item.ItemText),
new SqlParameter("@E", item.ItemPrice),
new SqlParameter("@F", item.ItemSales),
new SqlParameter("@G", item.ItemNumber),
new SqlParameter("@H", item.ItemKeyword),
new SqlParameter("@I", item.LastUpdateTime),
new SqlParameter("@J", item.ItemId),
};
string sql = "update item set item_category_id=@A,item_name=@B,item_picture=@C,item_text=@D,item_price=@E,item_sales=@F,item_number=@G,item_keyword=@H,item_last_update_time=@I where item_id = @J";
return(1 == (int)SqlHelper.ExecuteNoQuery(sql, sqlParameters));
}
//增加商品, 返回商品id
public static int AddItem(TMall.Models.ItemModel item)
{
SqlParameter[] sqlParameters = new SqlParameter[] {
new SqlParameter("@A", item.ItemCategoryId),
new SqlParameter("@B", item.ItemName),
new SqlParameter("@C", item.ItemPicture),
new SqlParameter("@D", item.ItemText),
new SqlParameter("@E", item.ItemPrice),
new SqlParameter("@F", item.ItemSales),
new SqlParameter("@G", item.ItemNumber),
new SqlParameter("@H", item.ItemKeyword),
new SqlParameter("@I", item.LastUpdateTime),
};
string sql = "insert into item (item_category_id,item_name,item_picture,item_text,item_price,item_sales,item_number,item_keyword,item_last_update_time) values(@A,@B,@C,@D,@E,@F,@G,@H,@I)\r\n select SCOPE_IDENTITY()\r\n go";
var x = SqlHelper.ExecuteScalar(sql, sqlParameters);
// 如果返回的object是decimal的实例, 要转化为int返回
return(Convert.ToInt32(x));
}
public ActionResult Edit(TMall.Models.ItemModel itemModel)
{
if (ModelState.IsValid) //查看表单是不是有效
{
itemModel.LastUpdateTime = DateTime.Now;
if (itemModel.ItemId < 0) //新增
{
int id = TMall.Respository.Item.AddItem(itemModel);
if (id > 0)
{
return(Redirect($"/Item/Detail?item_id={id}")); //成功后转移到详情页
}
}
else // update
{
if (TMall.Respository.Item.UpdateItem(itemModel))
{
return(Redirect($"/Item/Detail?item_id={itemModel.ItemId}"));//成功后转移到详情页
}
}
}
return(View());
}
