public static void Delete(int roomId, bool isUsingNew)
{
if (isUsingNew)
{
var db = RoomStandardNewItem.GetDatabase();
db.ExecuteNonQuery("DELETE FROM RoomStandardNewItems WHERE RoomId = " + roomId);
}
else
{
var db = RoomStandardOldItem.GetDatabase();
db.ExecuteNonQuery("DELETE FROM RoomStandardOldItems WHERE RoomId = " + roomId);
}
}
public static List <RoomStandardNewItem> Get(int roomId)
{
string sql = @"
SELECT * FROM RoomStandardNewItems
WHERE
RoomId = '" + roomId + @"'
ORDER BY
JyouConditionLower,
JyouConditionUpper";
var db = RoomStandardNewItem.GetDatabase();
return(db.ExecuteQuery <RoomStandardNewItem>(sql));
}
