public int MakeOrder(int tableid)
{
string sql = "insert into orderinfo(odate,ispay,tableid) values(datetime('now', 'localtime'),0,@tableid);update tableinfo set tisfree=0 where tid=@tableid;select oid from orderinfo order by oid desc limit 0,1";
SQLiteParameter sp = new SQLiteParameter("@tableid", tableid);
return(Convert.ToInt32(SqliteHelper.ExcuteScalar(sql, sp)));
}
public int OrderDish(int orderid, int dishid)
{
//查询当前是否已经点了这道菜，若是则加1，若不死
string sql = "select count(*) from orderdetailinfo where orderid=@oid and dishid=@did";
SQLiteParameter[] sp = new SQLiteParameter[]
{
new SQLiteParameter("@oid", orderid),
new SQLiteParameter("@did", dishid),
};
int count = Convert.ToInt32(SqliteHelper.ExcuteScalar(sql, sp));
if (count > 0)
{
//已经点过这道菜
sql = "update orderdetailinfo set count=count+1 where orderid=@oid and dishid=@did";
}
else
{
//还没点过
sql = "insert into orderdetailinfo(orderid,dishid,count) values(@oid,@did,1)";
}
return(SqliteHelper.ExcuteNoQuery(sql, sp));
#endregion
}
public int GetOrderById(int tableid)
{
string sql = "select oid from orderinfo where tableid=@tableid and ispay=0";
SQLiteParameter sp = new SQLiteParameter("@tableid", tableid);
return(Convert.ToInt32(SqliteHelper.ExcuteScalar(sql, sp)));
}
public decimal GetTotalMoneyByOrderId(int orderid)
{
string sql =
"select sum(oti.count*di.dprice) from orderdetailinfo as oti inner join dishinfo as di on oti.dishid=di.did where oti.orderid=@orderid";
SQLiteParameter sp = new SQLiteParameter("@orderid", orderid);
var money = SqliteHelper.ExcuteScalar(sql, sp);
if (money == DBNull.Value)
{
return(0);
}
return(Convert.ToDecimal(money));
}