Пример #1
0
 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());
 }
Пример #2
0
 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));
 }
Пример #3
0
        // 更新商品
        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));
        }
Пример #4
0
        //增加商品, 返回商品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));
        }
Пример #5
0
 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());
 }