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