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
