public static final String SELECT_COLLECTION_CODE = "SELECT * from tb_collection_code where collectionCode=?";//查询采集码

public static final String UPDATE_COLLECTION_CODE="UPDATE tb_collection_code SET merchantId=?,state=? where id=?";//修改采集码

//商户账号对应的openID以及uniondID

public static final String GETOPENUNIOMUSERINFOBYMERCHANTACCOUNT = "select openid, unionid from tbMerchantUser where merAccountNumber = ? and state!='3'";

public static final String INSERTMERCHANTUSERSETTLEMENTLOG = "insert into `tbMerchantUserSettlementLog`(userOpenId, userUnionId, amount,orderNumber,"+

"merAccountNumber , type , createTime) values (?,?,?,?,?,?,?)";//用户 结算日志表向其中插入数据

public static final String UPDATEMERCHANTUSERAMOUNTANDBALANCEFORSETTLEMENTFAILURE="update tbMerchantUser set accountBalance=(accountBalance + ?) ,totalAmount=(totalAmount-?) "+

"where userOpenId =? and state != '3'";// 若出错，则将余额加回去。 同时总账本要减少相应金额

//=======================================物业代扣卡=====================================================================

public static final String GETPROPERTYDEDUCTIONCARDLIST="select pc.propertyCardNo,pc.cardTypeName cardTypeName1,cu.* from propertyCard pc left join cusRelation c on (c.propertyCardNo like CONCAT('%',pc.propertyCardNo,'%') ) "+

"left join customer cu on (cu

　　A：如果聚合码限制了你的收款码数量，建议你可以尝试申请其他服务商的代理，例如银行、电子支付公司或者网上平台。此外还可以选择对应的企业钱包来实现快速、安全地接受/转出/存储货币。

不能。聚合码是一种支付工具，只能用来进行多平台的付款，不能限制收款码。