def init_arealist(self):
'''
初始化省市数据
:return:
'''
getAreaSql = f"select Position,Province_Name,Province_Code,City_Name,City_Code from arealists"
with MysqlHelper.Operator(MYSQL_HOST, MYSQL_PORT, MYSQL_USER,
MYSQL_PASSWORD, MYSQL_DB) as oper:
# 获取省市列表
cursor = oper.execute_sql(getAreaSql)
self.areaList = oper.res_to_dict(cursor)
# '省市'字去掉
self.new_areaList = list(
map(
lambda x: {
'Position':
x['Position'],
'Province_Name':
x['Province_Name'].replace('省', '').replace('市', ''),
'Province_Code':
x['Province_Code'],
'City_Name':
x['City_Name'].replace('省', '').replace('市', ''),
'City_Code':
x['City_Code']
}, self.areaList))
oper.cursor.close()
def get_company_list(self):
sql = "select company_name,qyxx_id from company_manager where status not like '新三板%' and status not like " \
"'上市%' and status not like '拟上市%'"
try:
com_list = MysqlHelper().get_all(sql)
return com_list
except Exception as err:
print("MYSQL查询数据时出错了~错误内容为{}".format(str(err)))