searchFestivalProduct
===
select 
    @pageTag(){
    id, fescod, cpid, productid, productname, url, icon, smstype, smsord, smscan, stime, etime
  @}
  from tb_ordercenter_product
 where fescod=#fescod#

findById
===
select id, fescod, cpid, productid, productname, url, icon, smstype, smsord, smscan, stime, etime
  from tb_ordercenter_product
 where id=#id#

findByFescod
===
select id, fescod, cpid, productid, productname, url, icon, smstype, smsord, smscan, stime, etime
  from tb_ordercenter_product
 where fescod=#fescod#
 
saveFestivalProduct
===
insert into tb_ordercenter_product(id, fescod, cpid, productid, productname, url, icon, smstype, smsord, smscan, stime, etime)
select max(id) + 1, #fescod#, #cpid#, #productid#, #productname#, #url#, #icon#, #smstype#, #smsord#, #smscan#, #stime#, #etime#
  from tb_ordercenter_product

deleteFestivalProductById
===
delete from tb_ordercenter_product where id=#id#

deleteFestivalProductByFescod
===
delete from tb_ordercenter_product where fescod=#fescod#

findAllDirectedProduct
===
select productnewid, productid, usertype, subscrbtype, productname, producttype, effecttype, directedtype, price, invalidtype, spproductid, spcode, rates
from tb_directed_product 

findAllCpinfo
===
select * from tb_directed_cpinfo where cpname is not null

updateFestivalProduct
===
update tb_ordercenter_product 
   set cpid=#cpid#,
       productid=#productid#,
       productname=#productname#,
       url=#url#,
       icon=#icon#,
       smstype=#smstype#,
       smsord=#smsord#,
       smscan=#smscan#,
       stime=#stime#,
       etime=#etime#
 where id=#id#