import random
import time
import pymysql

class Make_Bill():
    def __init__(self, Num, stt, val, Mnum):
        self.Num = Num
        self.stt = stt
        self.val = val
        self.Mnum = Mnum
        self.Make(self.Num)
    def makeid(self):
        return int(random.uniform(10000001, 10999999))
    def Make(self, Num):

        sql = "SELECT card类型,Card_Number FROM card WHERE Card_Number = %s" % (self.Num)
        db = pymysql.connect(host="localhost", user="root",
                             password="lwh20021210...", db="atm", port=3306)
        cur = db.cursor()
        try:
            cur.execute(sql)  # 执行sql语句
            results = cur.fetchall()
            print(type(results))
            YH = results[0][0]
            YC = results[0][1]
            tim = time.strftime('%Y-%m-%d %H:%M:%S ', time.localtime(time.time()))
            sql2 = "INSERT INTO bill VALUES ('%s',%s, '%s','%s', %s,'%s','%s')" % (
            tim, self.makeid(), YH, self.stt, self.val, YC, self.Mnum)
            cur.execute(sql2)
            db.commit()
        except Exception as e:
            db.rollback()
        finally:

            db.close()  # 关闭连接

# MM=Make_Bill("62155504510128","转账",1000,"62155504510112")