async函数返回值使用then解析后undefined

Question

service的代码如下：

exports.findSignupInfo = async function(queryObj) {
    try {
        // 模糊查询条件开始
        let reg = new RegExp(queryObj.coreName);
        let query = {
            name: reg
        };
        // 模糊查询条件结束
        let connection = await DB.connect('coreEnterprises'); // 连接数据库
        let result = await DB.find(connection, query);
        result.toArray(function(err, result) { // 模糊查询
            response.data.datalist = [];
            for (let i = 0; i < result.length; i++) {
                let item = {};
                item.name = result[i].name;
                item.hmA = result[i].hmA;
                response.data.datalist.push(item);
            }
            response.data.pagecond = {
                page: 1,
                count: 1,
                pageSize: 5,
                totalPages: 1
            };
            return response;
        });
    } catch (err) {
        console.log(err);
    }
};

在controller的代码里调用service中的findSignupInfo方法，代码如下：

router.get('/v1/ccb/signup/order/find', function(req, res) {
    service.findSignupInfo(req.query).then(response => {
        res.send(response);
    });
});

可是这里的response总是undefined
请问这里应该怎么改？

Answer 1

findSignupInfo 没有返回值 自然就是undefined

参考代码:

exports.findSignupInfo = async function(queryObj) {
    try {
        // 模糊查询条件开始
        let reg = new RegExp(queryObj.coreName);
        let query = {
            name: reg
        };
        // 模糊查询条件结束
        let connection = await DB.connect('coreEnterprises'); // 连接数据库
        let result = await DB.find(connection, query);
        
        //注意这里
        return new Promise((resolve,reject)=>{
            result.toArray(function(err, result) { // 模糊查询
                response.data.datalist = [];
                for (let i = 0; i < result.length; i++) {
                    let item = {};
                    item.name = result[i].name;
                    item.hmA = result[i].hmA;
                    response.data.datalist.push(item);
                }
                response.data.pagecond = {
                    page: 1,
                    count: 1,
                    pageSize: 5,
                    totalPages: 1
                };
                resolve(response);
            });
        
        });
    } catch (err) {
        console.log(err);
    }
};