def change_line(self, table_name, IEMI, bool): try: sql = f"INSERT INTO trillion.{table_name} (IEMI, changetime, bool) VALUES ({IEMI}, CURRENT_TIMESTAMP, {bool})" results = CommonDao.change_option(self, sql) return results except: pass
def submit_transfer(self, values): try: sql = "UPDATE trillion.%s SET productlines='%s' WHERE IEMI='%s';" % values iphone_info = CommonDao.change_option(self, sql) return iphone_info except: pass
def delete_data(self, values): try: sql = "DELETE FROM trillion.%s WHERE IEMI='%s';" % values results = CommonDao.change_option(self, sql) return results except: pass
def change_data(self, values): try: sql = "UPDATE trillion.%s SET istorage='%s', color='%s', intime=CURRENT_TIMESTAMP, company='%s', productlines='%s', bstorage='%s', remarks='%s' WHERE IEMI='%s';" % values results = CommonDao.change_option(self, sql) return results except: pass
def insert_data(self, values): try: sql = "INSERT INTO trillion.%s (IEMI, istorage, color, intime, company, productlines, bstorage, remarks) VALUES ('%s','%s','%s',CURRENT_TIMESTAMP,'%s','%s','%s','%s');" % values results = CommonDao.change_option(self, sql) return results except: pass
def change_status_single(self, table_name, IEMI): try: sql = f"UPDATE trillion.{table_name} SET forinventory='1' WHERE IEMI='{IEMI}';" results = CommonDao.change_option(self, sql) return results except: pass
def change_status(self, table_name): try: sql = f"UPDATE trillion.{table_name} SET forinventory='0';" results = CommonDao.change_option(self, sql) return results except: pass
def submit_class(self, values): try: sql = "UPDATE trillion.%s SET " \ "grade='%s', remarks='%s' WHERE IEMI='%s';" % values # print(sql) iphone_info = CommonDao.change_option(self, sql) return iphone_info except: pass
def insert_sell_info(self, values): try: sql = "UPDATE trillion.%s SET " \ "outtime=CURRENT_TIMESTAMP, selller='%s', bstorage='%s', tocompany='%s', tracknumber='%s', salenumber='%s', remarks='%s' WHERE IEMI='%s';" % values # print(sql) results = CommonDao.change_option(self, sql) print(results) return results except: pass