//        var from="""//                    FROM//                        biz_value_added_tax_info a//                    WHERE//                        sys_status = 1//                  """//        var paras = mutableListOf
     
      ()////        //核心企业//        if(StringUtils.notBlank(coreEnterpriseId)  ){//            from += " AND a.core_enterprise_id = ? "//            var  coreEnterpriseId="${coreEnterpriseId?.trim()}"//            paras.add(coreEnterpriseId)//        }//        //年份//        if(StringUtils.notBlank(billingYear) ){//            from += " AND a.billing_year = ? "//            var years="${billingYear?.trim()}"//            paras.add(years)//        }//        //月份//        if(StringUtils.notBlank(billingMonth) ){//            from += " AND a.billing_month = ? "//            var mouths = "${billingMonth?.trim()}"//            paras.add(mouths.trim())//        }        //获取付款单信息列表//        var IncomeInfoList  = dbp.find(select+from,*paras.toTypedArray
      
       ())
      
     

// 主画面的 select 语句    var select= """                    SELECT                        id,                        CONVERT(billing_year, char) AS billing_year,                        billing_month,                        core_enterprise_id,                        assets_trusteeship_income,                        account_receivable,                        billing_amount,                        tax_amount,                        total_amount,                        service_fee_income,                        asset_custody_income,                        service_charge_income,                        input_tax,                        transfer_input_tax,                        real_payment                    """    /**     * 主画面查询from SQL构造     * @param ctl     * @throws ActiveRecordException     */    fun fromSql( coreEnterpriseId:String ?, billingYear:String?, billingMonth:String? ): String? {        var from="""                    FROM                        biz_value_added_tax_info a                    WHERE                        sys_status = 1                  """        var where = ""        //核心企业        if(StringUtils.notBlank(coreEnterpriseId)  ){            where += " AND a.core_enterprise_id = '" + coreEnterpriseId?.trim() + "' "        }        //年份        if(StringUtils.notBlank(billingYear) ){            from += " AND a.billing_year = ' "+billingYear?.trim()+"' "        }        //月份        if(StringUtils.notBlank(billingMonth) ){            from += " AND a.billing_month = ' "+billingMonth?.trim()+"' "        }        return  from+where    }

/**     * 财务部ABS费用表：管理一览画面     * @param  billingYear     *               年份     * @param billingMonth     *               月份     * @param  coreEnterpriseId     *               核心企业     */    fun pages(iwebReq: IwebReq, pageInfo: PageInfo, coreEnterpriseId:String ?, billingYear:String?, billingMonth:String? ): Page
     
      ? {        var dbp = DbPro.use(iwebReq.dsName)        var pageIndex = pageInfo?.pageIndex ?: 1        var pageSize = pageInfo?.pageSize ?: IwebConstant.DEFAULT_PAGE_SIZE//        var from="""//                    FROM//                        biz_value_added_tax_info a//                    WHERE//                        sys_status = 1//                  """//        var paras = mutableListOf
      
       ()////        //核心企业//        if(StringUtils.notBlank(coreEnterpriseId)  ){//            from += " AND a.core_enterprise_id = ? "//            var  coreEnterpriseId="${coreEnterpriseId?.trim()}"//            paras.add(coreEnterpriseId)//        }//        //年份//        if(StringUtils.notBlank(billingYear) ){//            from += " AND a.billing_year = ? "//            var years="${billingYear?.trim()}"//            paras.add(years)//        }//        //月份//        if(StringUtils.notBlank(billingMonth) ){//            from += " AND a.billing_month = ? "//            var mouths = "${billingMonth?.trim()}"//            paras.add(mouths.trim())//        }//        return dbp.paginate(pageIndex,pageSize,select,from,*paras.toTypedArray
       
        ())        var fromql=fromSql( coreEnterpriseId, billingYear, billingMonth)        return dbp.paginate(pageIndex,pageSize,select,fromql)    }