def save_express_for_customer_to_staff(express_param):
sql = "INSERT INTO Express (id, expressType, overdueTime, status, StoreTime, SyncFlag" \
", Version, box_id, mouth_id" \
", operator_id, storeUser_id,groupName,lastModifiedTime)" \
" VALUES (:id,:expressType,:overdueTime,:status,:storeTime,:syncFlag," \
":version,:box_id,:mouth_id" \
",:operator_id,:storeUser_id,:groupName,:lastModifiedTime)"
ClientDatabase.insert_or_update_database(sql, express_param)
def save_send_express(express_param):
sql = "INSERT INTO Express (id, customerStoreNumber, expressType, overdueTime, status, storeTime, syncFlag" \
", version, box_id, mouth_id, storeUserPhoneNumber" \
", operator_id, groupName,Weight, lastModifiedTime)" \
" VALUES (:id,:customerStoreNumber,:expressType,:overdueTime,:status,:storeTime,:syncFlag," \
":version,:box_id,:mouth_id,:storeUserPhoneNumber" \
",:operator_id,:groupName,:Weight,:lastModifiedTime)"
ClientDatabase.insert_or_update_database(sql, express_param)
def init_mouth_type(mouth_type):
sql = "SELECT * FROM MouthType WHERE id=:id"
result_set = ClientDatabase.get_result_set(sql, mouth_type)
if len(result_set) != 0:
return
sql = "INSERT INTO MouthType (id, defaultUsePrice,defaultOverduePrice, name,deleteFlag)" \
"VALUES (:id,:defaultUsePrice,:defaultOverduePrice,:name,:deleteFlag)"
ClientDatabase.insert_or_update_database(sql, mouth_type)
def save_express(express_param):
sql = "INSERT INTO Express (id, ExpressNumber, expressType, status, StoreTime, SyncFlag" \
", ValidateCode, Version, box_id, mouth_id" \
", operator_id, groupName, lastModifiedTime, payAmount, payType, order_id, takeUser_id)" \
" VALUES (:id,:expressNumber,:expressType,:status,:storeTime,:syncFlag," \
":validateCode,:version,:box_id,:mouth_id" \
",:operator_id,:groupName,:lastModifiedTime,:payAmount,:payType,:order_id,:takeUser_id)"
ClientDatabase.insert_or_update_database(sql, express_param)
print("写入本地数据库成功！")
def init_express(express):
sql = "INSERT INTO Express (id, expressNumber, expressType, overdueTime, status, storeTime, syncFlag" \
", takeUserPhoneNumber, storeUserPhoneNumber, validateCode, version, box_id, " \
"logisticsCompany_id, mouth_id, operator_id, " \
"storeUser_id,groupName,customerStoreNumber, chargeType, continuedHeavy, " \
"continuedPrice, endAddress, startAddress, firstHeavy, firstPrice, designationSize, " \
"electronicCommerce_id, takeUser_id, payAmount, payType, order_id)" \
"VALUES (:id,:expressNumber,:expressType,:overdueTime,:status,:storeTime,:syncFlag,:takeUserPhoneNumber" \
",:storeUserPhoneNumber,:validateCode,:version,:box_id,:logisticsCompany_id,:mouth_id,:operator_id,:" \
"storeUser_id,:groupName,:customerStoreNumber,:chargeType,:continuedHeavy,:continuedPrice" \
",:endAddress,:startAddress,:firstHeavy,:firstPrice,:designationSize,:electronicCommerce_id" \
",:takeUser_id,:payAmount,:payType,:order_id)"
ClientDatabase.insert_or_update_database(sql, express)
def save_customer_reject_express(customer_store_express):
sql = "INSERT INTO Express(id, customerStoreNumber, expressType," \
" status, storeTime, syncFlag, version, electronicCommerce_id, " \
"box_id, logisticsCompany_id, mouth_id, operator_id, " \
"storeUser_id, recipientName, weight, storeUserPhoneNumber, chargeType, lastModifiedTime)" \
"VALUES (:id,:customerStoreNumber,:expressType," \
"'IN_STORE',:storeTime,0,0,:electronicCommerce_id,:box_id," \
":logisticsCompany_id,:mouth_id,:operator_id," \
":storeUser_id,:recipientName,:weight,:storeUserPhoneNumber, :chargeType,:lastModifiedTime)"
return ClientDatabase.insert_or_update_database(sql,
customer_store_express)
def insert_download_info(advertisement):
sql = "INSERT INTO Download (id, url, filename, status, position, type, MD5,flagTime,version,initFlag,deleteFlag)" \
"VALUES (:id,:url,:filename,:status,:position, :type,:MD5,:flagTime,:version,:initFlag,:deleteFlag)"
ClientDatabase.insert_or_update_database(sql, advertisement)
def update_download_info_end(param):
sql = "UPDATE Download SET status=:status,EndTime=:endTime WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, param)
def init_cabinet(cabinet):
sql = "INSERT INTO Cabinet(id, deleteFlag, number)" \
"VALUES (:id,:deleteFlag,:number)"
ClientDatabase.insert_or_update_database(sql, cabinet)
def delete_holiday(param):
sql = "UPDATE Holiday SET deleteFlag= 1 WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, param)
def init_holiday(param):
sql = "INSERT INTO Holiday (id, startTime, endTime, delayDay, holidayType, deleteFlag) " \
"VALUES (:id,:startTime,:endTime,:delayDay,:holidayType,0)"
ClientDatabase.insert_or_update_database(sql, param)
def init_company(param):
sql = "INSERT INTO Company (id, companyType, name, parentCompany_id,deleteFlag)" \
"VALUES (:id,:companyType,:name,:parentCompany_id,:deleteFlag)"
ClientDatabase.insert_or_update_database(sql, param)
def update_company(param):
sql = "UPDATE Company SET companyType =:companyType, name =:name, parentCompany_id =:parentCompany_id," \
"deleteFlag =:deleteFlag WHERE id =:id"
ClientDatabase.insert_or_update_database(sql, param)
def save_record(record_param):
sql = "INSERT INTO TransactionRecord (id, paymentType, transactionType, Amount, express_id, CreateTime)" \
"VALUES (:id,:paymentType,:transactionType,:amount,:express_id,:createTime)"
ClientDatabase.insert_or_update_database(sql, record_param)
def update_recode(record):
sql = "UPDATE TransactionRecord SET Amount=:amount WHERE express_id = :express_id"
ClientDatabase.insert_or_update_database(sql, record)
def mark_sync_success(param):
sql = "UPDATE mouth SET syncFlag = 1 WHERE id = :id"
ClientDatabase.insert_or_update_database(sql, param)
def mark_box_sync_success(param):
sql = "UPDATE Box SET syncFlag = 1"
ClientDatabase.insert_or_update_database(sql, param)
def mark_alert_sync_success(ups_parm):
sql = "UPDATE Alert SET SyncFlag = 1 WHERE id = :id"
ClientDatabase.insert_or_update_database(sql, ups_parm)
def update_holiday(msg):
sql = "UPDATE Holiday SET startTime=:startTime, endTime=:endTime," \
"delayDay=:delayDay,holidayType=:holidayType WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, msg)
def insert_alert_info(ups_parm):
sql = "INSERT INTO Alert (id, alertType, alertStatus, createTime, box_id, syncFlag,operator_id,alertvalue," \
"value_id) VALUES (:id, :alertType, :alertStatus, :createTime, :box_id, :syncFlag, :operator_id," \
" :alertvalue,:value_id)"
ClientDatabase.insert_or_update_database(sql, ups_parm)
def update_box(msg):
sql = "UPDATE Box SET name=:name, orderNo=:orderNo," \
"validateType=:validateType,currencyUnit=:currencyUnit,overdueType=:overdueType," \
"freeDays=:freeDays,freeHours=:freeHours,holidayType=:holidayType WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, msg)
def init_box(msg):
sql = "INSERT INTO Box (id, deleteFlag, name, orderNo, operator_id,validateType," \
"syncFlag,currencyUnit,overdueType,freeDays,freeHours,receiptNo,holidayType) " \
"VALUES (:id,0,:name,:orderNo,:operator_id,:validateType," \
":syncFlag,:currencyUnit,:overdueType,:freeDays,:freeHours,:receiptNo,:holidayType)"
ClientDatabase.insert_or_update_database(sql, msg)
def init_mouth(mouth):
sql = "INSERT INTO Mouth(id, deleteFlag, number,usePrice ,overduePrice, status, box_id, cabinet_id, " \
"express_id, mouthType_id,numberInCabinet,syncFlag,openOrder)" \
"VALUES (:id,:deleteFlag,:number,:usePrice,:overduePrice,:status,:box_id,:cabinet_id,:express_id" \
",:mouthType_id,:numberInCabinet,:syncFlag,:openOrder)"
ClientDatabase.insert_or_update_database(sql, mouth)
def use_mouth(mouth_param__):
sql = "UPDATE mouth SET express_id=:express_id ,Status=:status WHERE id = :id"
ClientDatabase.insert_or_update_database(sql, mouth_param__)
def free_mouth(mouth):
sql = "UPDATE mouth SET express_id = NULL , status = 'ENABLE' " \
"WHERE id = :id"
ClientDatabase.insert_or_update_database(sql, mouth)
def update_free_time(param):
sql = "UPDATE Box SET freeHours=:freeHours,freeDays=:freeDays,overdueType=:overdueType WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, param)
def update_download_info_status(param):
sql = "UPDATE Download SET status=:status WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, param)
def update_mouth_status(param):
sql = "UPDATE mouth SET status=:status WHERE id=:id "
ClientDatabase.insert_or_update_database(sql, param)
def update_upgrade_info_for_deleteflag(param):
sql = "UPDATE Download SET deleteFlag=1 WHERE id=:id"
ClientDatabase.insert_or_update_database(sql, param)
def manage_set_mouth(param):
sql = "UPDATE mouth SET status=:status, syncFlag=:syncFlag WHERE id=:id "
return ClientDatabase.insert_or_update_database(sql, param)