public void Update(Model.Store.Item entity) { using (IDbConnection conn = SqlString.GetSQLiteConnection()) { conn.Execute("UPDATE store_item SET Item_Img=@Item_Img,Title=@Title,CategoryId=@CategoryId,Content=@Content,Price=@Price,Stock=@Stock,AddTime=@AddTime,State=@State,Flag=@Flag WHERE Item_Id =@Item_Id", entity); } }
public ActionResult Purchase(int itemid, int num, string address, string phone, string des) { if (string.IsNullOrEmpty(address)) { return(View("OnOrderFail")); } if (string.IsNullOrEmpty(phone)) { return(View("OnOrderFail")); } Model.Store.Item item = itemService.Find(itemid); if (item.State != 1) { return(View("OnOrderFail")); } if (item.Stock >= num) { itemService.UpdateStock(item.Item_Id, item.Stock - num); Model.Store.Order order = new Model.Store.Order(); order.Address = address; order.AddTime = DateTime.Now; order.Des = des; order.IsDeliver = false; order.IsReceipt = false; order.ItemId = item.Item_Id; order.MemberId = base.LoginMember.Member_Id; order.Num = num; order.Phone = phone; order.Price = item.Price; order.State = 1; orderService.Insert(order); return(View("OnOrderSuccess")); } return(View("OnOrderFail")); }
public bool Insert(Model.Store.Item entity) { using (IDbConnection conn = SqlString.GetSQLiteConnection()) { int i = conn.Execute("INSERT INTO store_item(Item_Img,Title,CategoryId,Content,Price,Stock,AddTime,State,Flag)" + "VALUES(@Item_Img,@Title,@CategoryId,@Content,@Price,@Stock,@AddTime,@State,@Flag)", entity); if (i > 0) { return(true); } else { return(false); } } }