HeatingPaymentsInvoker/conf/sqlroot/com/yinjie/heating/business/dao/HeatingDocDao.dql

-- [queryGasApp]
select * from $table$;

-- [insertGasApp]
insert into $table$
(id, appId, appName, appPublicKey,
appPrivateKey, supplyPublicKey, status,
verifyKind, whiteIps,
createBy, createTime, updateBy,
updateTime)
values ( #{id}, #{appid}, #{appname}, #{apppublickey},
#{appprivatekey}, #{supplypublickey}, #{status},
#{verifykind}, #{whiteips},
#{createby}, #{createtime}, #{updateby},
#{updatetime} );

-- [updateGasApp]
update $table$ set
appName = #{appname},
appPublicKey = #{apppublickey},
appPrivateKey = #{appprivatekey},
supplyPublicKey = #{supplypublickey},
verifyKind = #{verifykind},
whiteIps = #{whiteips},
updateBy = #{updateby},
updateTime = #{updatetime}
where appId = #{appid};

-- [voidGasApp]
update $table$ set
status = #{status},
updateBy = #{updateby},
updateTime = #{updatetime}
where appId = #{appid};