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