示例#1
0
文件: SqlBook.cs 项目: IrisLinSQ/007
 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);
 }
示例#2
0
文件: SqlBook.cs 项目: IrisLinSQ/007
 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);
 }