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