def uploadpdf(): name = request.form.get("name") productId = request.form.get("productId") file = request.files["file"] filename = "" if request.method == 'POST': if file and allowed_file(file.filename): filename = name filename += "_" filename += productId filename += ".pdf" file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename)) pdf_path = "wink.net.cn:8000/pdf/" + filename result = enter_pdf(name, productId, pdf_path) response = entities.ResponseClass(True, "", "null") response.msg = result[1] response.isSuccess = result[0] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def vendoredit(): name = request.json.get("name") company = request.json.get("company") address = request.json.get("address") phone = request.json.get("phone") fax = request.json.get("fax") star = request.json.get("star") pic = request.json.get("pic") basicinfo = entities.Basicinfo(company, address, phone, fax, star, pic) result = vendor_edit(name, basicinfo) response = entities.ResponseClass(True, "", "null") response.msg = result[1] response.isSuccess = result[0] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def homestore(): query = home_store() response = entities.ResponseClass(True, "", "null") response.isSuccess = query[0] response.msg = query[1] response.data = query[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def vendortotalinfo(): name_get = request.args.get('name') result = vendor_total_info(name_get) response = entities.ResponseClass(True, "", "null") response.isSuccess = result[0] response.msg = result[1] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def per_commodity(): id_get = request.args.get('id') result = commodity_detail(id_get) response = entities.ResponseClass(True, "", "null") response.isSuccess = result[0] response.msg = result[1] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def register_process(user, identity): # user password 加密 user.password = sha256_crypt.hash(user.password) try: # 打开数据库连接 db = pymysql.connect("localhost", "root", "wujiahao.", "flaskTest") # 使用cursor()方法获取操作游标 cursor = db.cursor() key = ["id"] condition = {"username": user.username} query = sql.select(identity,key,condition,0) if cursor.execute(query): return "该用户名已经存在", False key = ["id"] condition = {"number": user.number} query = sql.select(identity, key, condition, 0) if cursor.execute(query): return "该手机号已经存在", False # 生成SQL语句 query = sql.insert(identity, utility.class_2_dict(user)) try: # 使用execute方法执行SQL语句 cursor.execute(query) # 提交操作到db db.commit() except: # 操作失败回滚 db.rollback() db.close() return "注册失败", False # 关闭数据库连接 db.close() return "注册成功", True except: return "Unable to connect to DB", False
def getspecpdf(): company_name_get = request.args.get('companyName') productId_get = request.args.get('productId') result = get_spec(company_name_get, productId_get) response = entities.ResponseClass(True, "", "null") response.isSuccess = result[0] response.msg = result[1] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def deleteproduct(): name = request.json.get("name") productId = request.json.get("productId") result = delete_product(name, productId) response = entities.ResponseClass(True, "", "null") response.msg = result[1] response.isSuccess = result[0] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def perprovide(): name_get = request.args.get('name') productId_get = request.args.get('productId') company_name = db_link.vendor_name2company_name(name_get) result = per_commoditys(company_name, productId_get) response = entities.ResponseClass(True, "", "null") response.isSuccess = result[0] response.msg = result[1] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def login(): number = request.json.get("number") password = request.json.get("password") identity = request.json.get("identity") result = login_process(number, password, identity) response = entities.ResponseClass(True, "", "null") response.msg = result[0] response.isSuccess = result[1] response.data = result[2] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def enterspec(): name = request.json.get("name") url = request.json.get("url") productId = request.json.get("productId") detail = request.json.get("detail") result = enter_spec(name, productId, detail, url) response = entities.ResponseClass(True, "", "null") response.msg = result[1] response.isSuccess = result[0] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result
def register(): username = request.json.get("username") password = request.json.get("password") number = request.json.get("number") identity = request.json.get("identity") user = entities.User(username, number, password) result = register_process(user, identity) response = entities.ResponseClass(True, "", "null") response.msg = result[0] response.isSuccess = result[1] resp_dict = utility.class_2_dict(response) result = json.dumps(resp_dict, sort_keys=True, indent=4, separators=(',', ':'), ensure_ascii=False).encode('utf8') return result