/// <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>
/// 删除餐桌
/// </summary>
/// <param name="id">餐桌id</param>
/// <returns></returns>
public int DeleteDeskById(int id)
{
string sql = "update DeskInfo set DelFlag=1 where DeskId=@DeskId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@DeskId", id)));
}
/// <summary>
/// 根据房间的id删除删除
/// </summary>
/// <param name="roomId">房间的id</param>
/// <returns></returns>
public int DeleteDeskInfoByRoomId(int roomId)
{
string sql = "update DeskInfo set DelFlag=1 where RoomId=@RoomId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@RoomId", roomId)));
}
/// <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)));
}
/// <summary>
/// 根据会员ID删除该会员
/// </summary>
/// <param name="memmberId">会员id</param>
/// <returns>受影响行数</returns>
public int DeleteMemmberByMemmberId(int memmberId)
{
string sql = "update MemmberInfo set DelFlag=1 where MemmberId=@MemmberId";
return(SqliteHelper.ExecuteNonquery(sql, new SQLiteParameter("@MemmberId", memmberId)));
}
