websql主子表查询组装对象数据

	var egisAll = [];
    var egisAllTemp = [];
    function syncRepair() {
      egisAllTemp = [];
        db.transaction(function(tx) {
            tx.executeSql('select * from egis where approvalStatus=?', [2], successone);
        }, null);
    }

    function successone(tx, results) {
        egisAll = results.rows;
        for (var i = 0; i < egisAll.length; i++) {
            var egis = egisAll[i];
            successtwo(egis, i)
        }
    }

    function successtwo(egis, j) {
        db.transaction(function(tx) {
            var refid = egis.id;
            tx.executeSql('select * from egisDetail where refId=?', [refid], function(tx, results1) {
                var shuzu = [];
                //查询回来虽然是个数组也可以直接用，但是我这里对这个数组转了一下，才能把它放进对象里正常使用
                for (var i = 0; i < results1.rows.length; i++) {
                    shuzu.push(results1.rows[i]);
                }
                egis["eaEgisexdetailList"] = shuzu;
                //最终主子表合成了一个数组
                egisAllTemp.push(egis);
            })
        })
    }