public void Update(Model.Store.Order entity) { using (IDbConnection conn = SqlString.GetMySqlConnection()) { conn.Execute("UPDATE store_order SET ItemId=@ItemId,Price=@Price,Num=@Num,Des=@Des,Address=@Address,Phone=@Phone,State=@State,AddTime=@AddTime,IsDeliver=@IsDeliver,TrackingNumber=@TrackingNumber,DeliverTime=@DeliverTime,IsReceipt=@IsReceipt WHERE Order_Id =@Order_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.Order entity) { using (IDbConnection conn = SqlString.GetMySqlConnection()) { int i = conn.Execute("INSERT INTO store_order(ItemId,MemberId,Price,Num,Des,Address,Phone,State,AddTime,IsDeliver,TrackingNumber,DeliverTime,IsReceipt)" + "VALUES(@ItemId,@MemberId,@Price,@Num,@Des,@Address,@Phone,@State,@AddTime,@IsDeliver,@TrackingNumber,@DeliverTime,@IsReceipt)", entity); if (i > 0) { return(true); } else { return(false); } } }