result = [{'orgid': '', 'orgid_text': '全部'}]
try:
    userorgid = await get_userorgid()
    if not userorgid:
        return json.dumps(result, ensure_ascii=False)
    db = DBPools()
    async with db.sqlorContext('sage') as sor:
        rows = await sor.sqlExe(
            "select id as orgid, orgname as orgid_text from organization where status = '1' order by orgname",
            {}
        )
        return json.dumps(result + list(rows), ensure_ascii=False)
except Exception as e:
    debug(f'get_search_orgid error: {e}')
return json.dumps(result, ensure_ascii=False)