Esempio n. 1
0
 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);
 }
Esempio n. 2
0
 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);
 }