public static void refund(Book book)
{
string SQLStr = "delete from Book_record where MName='"
+ book.getMoiveName() + "' and SName=" + book.getScreenName() + " and time='"
+ book.getTime() + "' and seat='" + book.getSeat() + "'";
DbHelperSQL.ExecuteSql(SQLStr);
}
public static void buyTicket(Book book)
{
string SQLStr = "Insert into Book_record Values('"
+ book.getMoiveName() + "','" + book.getTime() + "'," + book.getScreenName() + ",'"
+ book.getSeat() + "','" + book.getConsumerType() + "'," + book.getDiscount() + ","
+ book.getAfterDiscount() + ",'" + book.getSaleTime() + "')";
DbHelperSQL.ExecuteSql(SQLStr);
}