演出协议查询系统 - 查询演出协议信息

String performanceProtocolName = ''; if (checkMap.containsKey('performanceProtocolName')) { performanceProtocolName = checkMap.get('performanceProtocolName').toString(); }

    //支付企业编码
    String payCompanyCode = '';
    if (checkMap.containsKey('payCompanyCode')) {
        payCompanyCode = checkMap.get('payCompanyCode').toString();
    }

    //支付企业名称
    String payCompanyName = '';
    if (checkMap.containsKey('payCompanyName')) {
        payCompanyName = checkMap.get('payCompanyName').toString();
    }

    //税务登记号
    String taxRegistrationNumber = '';
    if (checkMap.containsKey('taxRegistrationNumber')) {
        taxRegistrationNumber = checkMap.get('taxRegistrationNumber').toString();
    }

    //银行账号
    String bankAccount = '';
    if (checkMap.containsKey('bankAccount')) {
        bankAccount = checkMap.get('bankAccount').toString();
    }

    //开户行
    String openingBank = '';
    if (checkMap.containsKey('openingBank')) {
        openingBank = checkMap.get('openingBank').toString();
    }

    //统一信用代码
    String unifiedCreditCode = '';
    if (checkMap.containsKey('unifiedCreditCode')) {
        unifiedCreditCode = checkMap.get('unifiedCreditCode').toString();
    }

    //是否发票
    String isInvoice = '';
    if (checkMap.containsKey('isInvoice')) {
        isInvoice = checkMap.get('isInvoice').toString();
    }

    //发票抬头
    String invoiceTitle = '';
    if (checkMap.containsKey('invoiceTitle')) {
        invoiceTitle = checkMap.get('invoiceTitle').toString();
    }

    //发票税号
    String invoiceNumber = '';
    if (checkMap.containsKey('invoiceNumber')) {
        invoiceNumber = checkMap.get('invoiceNumber').toString();
    }

    //发票地址
    String invoiceAddress = '';
    if (checkMap.containsKey('invoiceAddress')) {
        invoiceAddress = checkMap.get('invoiceAddress').toString();
    }

    //发票电话
    String invoicePhone = '';
    if (checkMap.containsKey('invoicePhone')) {
        invoicePhone = checkMap.get('invoicePhone').toString();
    }

    //发票开户行
    String invoiceBankAccount = '';
    if (checkMap.containsKey('invoiceBankAccount')) {
        invoiceBankAccount = checkMap.get('invoiceBankAccount').toString();
    }

    //发票开户行编码
    String invoiceBankNumber = '';
    if (checkMap.containsKey('invoiceBankNumber')) {
        invoiceBankNumber = checkMap.get('invoiceBankNumber').toString();
    }

    //备注
    String remarks = '';
    if (checkMap.containsKey('remarks')) {
        remarks = checkMap.get('remarks').toString();
    }

    //查询条件
    String condition = ' where 1=1 '; 

    if (!''.equals(performanceProtocolName)) {
        condition += ' and performanceProtocolName like '%' + performanceProtocolName + '%'';
    }

    if (!''.equals(payCompanyName)) {
        condition += ' and payCompanyName like '%' + payCompanyName + '%'';
    }

    if (!''.equals(payCompanyCode)) {
        condition += ' and payCompanyCode like '%' + payCompanyCode + '%'';
    }

    if (!''.equals(taxRegistrationNumber)) {
        condition += ' and taxRegistrationNumber like '%' + taxRegistrationNumber + '%'';
    }

    if (!''.equals(bankAccount)) {
        condition += ' and bankAccount like '%' + bankAccount + '%'';
    }

    if (!''.equals(openingBank)) {
        condition += ' and openingBank like '%' + openingBank + '%'';
    }

    if (!''.equals(unifiedCreditCode)) {
        condition += ' and unifiedCreditCode like '%' + unifiedCreditCode + '%'';
    }

    if (!''.equals(isInvoice)) {
        condition += ' and isInvoice like '%' + isInvoice + '%'';
    }

    if (!''.equals(invoiceTitle)) {
        condition += ' and invoiceTitle like '%' + invoiceTitle + '%'';
    }

    if (!''.equals(invoiceNumber)) {
        condition += ' and invoiceNumber like '%' + invoiceNumber + '%'';
    }

    if (!''.equals(invoiceAddress)) {
        condition += ' and invoiceAddress like '%' + invoiceAddress + '%'';
    }

    if (!''.equals(invoicePhone)) {
        condition += ' and invoicePhone like '%' + invoicePhone + '%'';
    }

    if (!''.equals(invoiceBankAccount)) {
        condition += ' and invoiceBankAccount like '%' + invoiceBankAccount + '%'';
    }

    if (!''.equals(invoiceBankNumber)) {
        condition += ' and invoiceBankNumber like '%' + invoiceBankNumber + '%'';
    }

    if (!''.equals(remarks)) {
        condition += ' and remarks like '%' + remarks + '%'';
    }

    //结果
    List resultList = new ArrayList();

    //获取总条数
    String countSql = 'select count(*) as total from performanceProtocol ' + condition;
    int total = jdbcTemplate.queryForObject(countSql, int.class);

    //拼接分页sql
    String querySql = 'select * from performanceProtocol ' + condition + ' order by id desc limit ' + start + ',' + length;

    List<Map<String, Object>> list = jdbcTemplate.queryForList(querySql);

    if (list != null && list.size() > 0) {

        for (int i = 0; i < list.size(); i++) {

            Map<String, Object> map = list.get(i);

            String id = '';
            if (map.containsKey('id')) {
                id = map.get('id').toString();
            }

            String performanceProtocolName1 = '';
            if (map.containsKey('performanceProtocolName')) {
                performanceProtocolName1 = map.get('performanceProtocolName').toString();
            }

            String payCompanyName1 = '';
            if (map.containsKey('payCompanyName')) {
                payCompanyName1 = map.get('payCompanyName').toString();
            }

            String payCompanyCode1 = '';
            if (map.containsKey('payCompanyCode')) {
                payCompanyCode1 = map.get('payCompanyCode').toString();
            }

            String taxRegistrationNumber1 = '';
            if (map.containsKey('taxRegistrationNumber')) {
                taxRegistrationNumber1 = map.get('taxRegistrationNumber').toString();
            }

            String bankAccount1 = '';
            if (map.containsKey('bankAccount')) {
                bankAccount1 = map.get('bankAccount').toString();
            }

            String openingBank1 = '';
            if (map.containsKey('openingBank')) {
                openingBank1 = map.get('openingBank').toString();
            }

            String unifiedCreditCode1 = '';
            if (map.containsKey('unifiedCreditCode')) {
                unifiedCreditCode1 = map.get('unifiedCreditCode').toString();
            }

            String isInvoice1 = '';
            if (map.containsKey('isInvoice')) {
                isInvoice1 = map.get('isInvoice').toString();
            }