GreenDao 自定义SQL查询-拼接多个查询条件-Android

/右滑菜单筛选
    public List<ExcelBean> filter(String sap
            , Boolean jidianWorkShop//机电车间
            , Boolean dianqiWorkShop//电气车间
            , Boolean cba
            , Boolean cb6A
            , Boolean cb_urban_rail_traction
            , Boolean cb_standard_traction
            , Boolean cb_internet_product
            , Boolean cb_power_module
            , Boolean cb_test_team_1
            , Boolean cb_test_team_2
            , Boolean cb_a
            , Boolean cb_b
            , Boolean cb_c
            , Boolean cb_d
            , String et_tool_name
            , Boolean cb_ok
            , Boolean cb_no
            , Boolean cb_ok_dianjian
            , Boolean cb_no_dianjian
            , Boolean cb_ok_verification
            , Boolean cb_no_verification
            , Boolean cb_ok_check
            , Boolean cb_no_check
            , Boolean cb_disable_archiving
            , Boolean cb_enable
            , Boolean cb_scrapped
            , Boolean cb_repair) {
        try {

            List<ExcelBean> beanList = new ArrayList<ExcelBean>();
            //请求参数
            ArrayList<String> strParamLt = new ArrayList<String>();

            String queryString =
                    "SELECT DISTINCT *  FROM " + ExcelBeanDao.TABLENAME + " where 1==1 ";

            if (!TextUtils.isEmpty(sap)) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.SAP.columnName + " =  ?";
                strParamLt.add(sap);
            }

            if (jidianWorkShop) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Workshop.columnName + " =  ?";
//                strParamLt.add("机电车间");
                strParamLt.add(App.getInstance().getString(R.string.str_jidian_workshop));
            }

            if (dianqiWorkShop) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Workshop.columnName + " =  ?";
//                strParamLt.add("电气车间");
                strParamLt.add(App.getInstance().getString(R.string.str_dianqi_workshop));
            }

            if (cba) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
//                strParamLt.add("CBA产品班组");
                strParamLt.add(App.getInstance().getString(R.string.str_cba));
            }

            if (cb6A) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
//                strParamLt.add("6A班组");
                strParamLt.add(App.getInstance().getString(R.string.str_6A));
            }

            if (cb_urban_rail_traction) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
//                strParamLt.add("城轨牵引班组");
                strParamLt.add(App.getInstance().getString(R.string.str_urban_rail_traction));
            }

            if (cb_standard_traction) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
//                strParamLt.add("标动牵引班组");
                strParamLt.add(App.getInstance().getString(R.string.str_standard_traction));
            }

            if (cb_internet_product) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
//                strParamLt.add("网络产品班组");
                strParamLt.add(App.getInstance().getString(R.string.str_internet_product));
            }

            if (cb_power_module) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_power_module));
            }

            if (cb_test_team_1) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_test_team_1));
            }

            if (cb_test_team_2) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.Team.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_test_team_2));
            }

            if (cb_a) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingGrade.columnName + " =  ?";
                strParamLt.add("A");
            }

            if (cb_b) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingGrade.columnName + " =  ?";
                strParamLt.add("B");
            }

            if (cb_c) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingGrade.columnName + " =  ?";
                strParamLt.add("C");
            }

            if (cb_d) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingGrade.columnName + " =  ?";
                strParamLt.add("D");
            }

            if (!TextUtils.isEmpty(et_tool_name)) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingName.columnName + " =  ?";
                strParamLt.add(et_tool_name);
            }

            if (cb_ok) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_qualified));
            }

            if (cb_no) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.ToolingStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_unqualified));
            }

            if (cb_ok_dianjian) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.DianCheckStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_ok_dianjian));
            }

            if (cb_no_dianjian) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.DianCheckStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_no_dianjian));
            }

            if (cb_ok_verification) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.VerificationStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_ok_verification));
            }

            if (cb_no_verification) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.VerificationStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_no_verification));
            }

            if (cb_ok_check) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.CheckStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_ok_check));
            }

            if (cb_no_check) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.CheckStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_no_check));
            }

            if (cb_disable_archiving) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.DisposalStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_disable_archiving));
            }

            if (cb_enable) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.DisposalStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_enable));
            }

            if (cb_scrapped) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.DisposalStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_scrapped));
            }

            if (cb_repair) {
                queryString = queryString + " and " + ExcelBeanDao.Properties.DisposalStatus.columnName + " =  ?";
                strParamLt.add(App.getInstance().getString(R.string.str_repair));
            }

            Object[] objs = strParamLt.toArray();
            String[] strs = new String[objs.length];
            for (int i = 0; i < objs.length; i++) {
                strs[i] = objs[i].toString();
            }
            Cursor cursor = mDaoSession.getExcelBeanDao().getDatabase().rawQuery(queryString, strs);
            int sapIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.SAP.columnName);
            int noIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.No.columnName);
            int sequenceNumberIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.SequenceNumber.columnName);
            int toolGroupIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.ToolingGroup.columnName);
            int toolingCodeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.ToolingCode.columnName);
            int toolingNameIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.ToolingName.columnName);
            int drawingNumberIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.DrawingNumber.columnName);
            int toolingGradeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.ToolingGrade.columnName);
            int toolingStatusIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.ToolingStatus.columnName);
            int verificationTimeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.VerificationTime.columnName);
            int verificationStatusIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.VerificationStatus.columnName);
            int verificationFileIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.VerificationFile.columnName);
            int checkTimeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.CheckTime.columnName);
            int checkStatusIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.CheckStatus.columnName);
            int checkFileIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.CheckFile.columnName);
            int disposalTimeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.DisposalTime.columnName);
            int disposalStatusIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.DisposalStatus.columnName);
            int disposalFileIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.DisposalFile.columnName);
            int inspectionTimeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.InspectionTime.columnName);
            int dianCheckStatusIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.DianCheckStatus.columnName);
            int dianCheckFileIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.DianCheckFile.columnName);
            int informationCardIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.InformationCard.columnName);
            int informationCardFileIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.InformationCardFile.columnName);
            int workshopIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.Workshop.columnName);
            int teamIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.Team.columnName);
            int fileCreatTimeIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.FileCreatTime.columnName);
            int isOpenIndex = cursor.getColumnIndex(ExcelBeanDao.Properties.IsOpen.columnName);

            while (cursor.moveToNext()) {
                ExcelBean bean = new ExcelBean();
                bean.setSAP(cursor.getString(sapIndex));
                bean.setNo(cursor.getString(noIndex));
                bean.setSequenceNumber(cursor.getString(sequenceNumberIndex));
                bean.setToolingGroup(cursor.getString(toolGroupIndex));
                bean.setToolingCode(cursor.getString(toolingCodeIndex));
                bean.setToolingName(cursor.getString(toolingNameIndex));
                bean.setDrawingNumber(cursor.getString(drawingNumberIndex));
                bean.setToolingGrade(cursor.getString(toolingGradeIndex));
                bean.setToolingStatus(cursor.getString(toolingStatusIndex));
                bean.setVerificationTime(cursor.getString(verificationTimeIndex));
                bean.setVerificationStatus(cursor.getString(verificationStatusIndex));
                bean.setVerificationFile(cursor.getString(verificationFileIndex));
                bean.setCheckTime(cursor.getString(checkTimeIndex));
                bean.setCheckStatus(cursor.getString(checkStatusIndex));
                bean.setCheckFile(cursor.getString(checkFileIndex));
                bean.setDisposalTime(cursor.getString(disposalTimeIndex));
                bean.setDisposalStatus(cursor.getString(disposalStatusIndex));
                bean.setDisposalFile(cursor.getString(disposalFileIndex));
                bean.setInspectionTime(cursor.getString(inspectionTimeIndex));
                bean.setDianCheckStatus(cursor.getString(dianCheckStatusIndex));
                bean.setDianCheckFile(cursor.getString(dianCheckFileIndex));
                bean.setInformationCard(cursor.getString(informationCardIndex));
                bean.setInformationCardFile(cursor.getString(informationCardFileIndex));
                bean.setWorkshop(cursor.getString(workshopIndex));
                bean.setTeam(cursor.getString(teamIndex));
                bean.setFileCreatTime(cursor.getString(fileCreatTimeIndex));
                bean.setIsOpen(cursor.getString(isOpenIndex));

                Log.e("moveToNext",new Gson().toJson(bean));
                beanList.add(bean);

            }

            return beanList;
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }