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)