/// <summary>
/// 插入一个订单返回该订单的id
/// </summary>
/// <param name="order">对象</param>
/// <returns></returns>
public int AddOrderInfo(OrderInfo order)
{
string sql = "insert into OrderInfo(SubTime,Remark,OrderState,DelFlag,SubBy) values(@SubTime,@Remark,@OrderState,@DelFlag,@SubBy);select last_insert_rowid();";
SQLiteParameter[] param =
{
new SQLiteParameter("@SubTime", order.SubTime),
new SQLiteParameter("@Remark", order.Remark),
new SQLiteParameter("@OrderState", order.OrderState),
new SQLiteParameter("@DelFlag", order.DelFlag),
new SQLiteParameter("@SubBy", order.SubBy)
};
return(Convert.ToInt32(SqliteHelper.ExecuteScalar(sql, param)));
}
/// <summary>
/// 根据餐桌的id查询该餐桌是不是空闲的
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public object SearchDeskById(int id)
{
string sql = "select count(*) from deskinfo where delflag=0 and deskid=@DeskId and deskState=0";
return(SqliteHelper.ExecuteScalar(sql, new SQLiteParameter("@DeskId", id)));
}
/// <summary>
/// 根据餐桌的id查询正在使用的订单id
/// </summary>
/// <param name="deskId">餐桌的id</param>
/// <returns>订单的id</returns>
public object GetOrderIdByDeskId(int deskId)
{
string sql = "select OrderInfo.OrderId from R_Order_Desk inner join OrderInfo on R_Order_Desk.OrderId=OrderInfo.OrderId where OrderState=1 and DeskId=@DeskId";
return(SqliteHelper.ExecuteScalar(sql, new SQLiteParameter("@DeskId", deskId)));
}
/// <summary>
/// 查询该房间下是否有正在使用的餐桌
/// </summary>
/// <param name="roomId">房间的id</param>
/// <returns></returns>
public object GetDeskInfoStateByRoomId(int roomId)
{
string sql = "select count(*) from deskinfo where delflag=0 and deskState=1 and RoomId=@RoomId";
return(SqliteHelper.ExecuteScalar(sql, new SQLiteParameter("@RoomId", roomId)));
}