def GetAllBuyers():
"""获取所有的买家数据"""
db_cur = db_conn.cursor()
db_cur.execute(SQL_ALL_BUYERS)
all_buyers = []
for row in db_cur:
rec = Buyer()
rec.uid = str(row[0])
rec.buyer_name = row[1]
rec.phone1 = row[2]
rec.phone2 = row[3]
rec.phone3 = row[4]
rec.email = row[5]
all_buyers.append(rec)
return all_buyers
def GetAllBuyers():
"""获取所有的买家数据"""
db_cur = db_conn.cursor()
db_cur.execute(SQL_ALL_BUYERS)
all_buyers = []
for row in db_cur:
rec = Buyer()
rec.uid = str(row[0])
rec.buyer_name = row[1]
rec.phone1 = row[2]
rec.phone2 = row[3]
rec.phone3 = row[4]
rec.email = row[5]
all_buyers.append(rec)
return all_buyers
def SaveChanges(self): for row in self.change_rows.keys(): row = int(row) buyer = Buyer() buyer.uid = self.m_grid5.GetCellValue(row, 0) buyer.buyer_name = self.m_grid5.GetCellValue(row, 1) buyer.phone1 = self.m_grid5.GetCellValue(row, 2) buyer.phone2 = self.m_grid5.GetCellValue(row, 3) buyer.phone3 = self.m_grid5.GetCellValue(row, 4) buyer.email = self.m_grid5.GetCellValue(row, 5) db.UpdateBuyer(buyer) for new_row in self.new_buyers.keys(): buyer = Buyer() buyer.buyer_name = self.m_grid5.GetCellValue(new_row, 1) buyer.phone1 = self.m_grid5.GetCellValue(new_row, 2) buyer.phone2 = self.m_grid5.GetCellValue(new_row, 3) buyer.phone3 = self.m_grid5.GetCellValue(new_row, 4) buyer.email = self.m_grid5.GetCellValue(new_row, 5) db.InsertBuyer(buyer)
