dyDeliver/conf/sqlroot/com/dderp/business/dao/PlatformDao.dql

-- [queryPlatformInfoList]
select *
from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- if voidFlag >= 0
    voidFlag = #{voidFlag}
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addPlatformInfo]
insert into $table$ (id, platformName, platformType, requireListSerial,
voidFlag, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{platformname}, #{platformtype}, #{requirelistserial},
#{voidflag}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePlatformInfo]
update $table$ set platformName = #{platformname},platformType = #{platformtype},requireListSerial = #{requirelistserial},
updateBy = #{updateby},
updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

-- [voidPlatformInfo]
update $table$ set voidFlag = #{voidflag},updateBy = #{updateby},
updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};


-- [queryPlatformRequireList]
select *
from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- if voidFlag >= 0
    voidFlag = #{voidFlag}
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addPlatformRequire]
insert into $table$ (id, requireName, requireCode, valueType,
voidFlag, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{requirename}, #{requirecode}, #{valuetype},
#{voidflag}, #{createby}, #{createtime},
#{createtimelong}, #{updateby}, #{updatetime},
#{updatetimelong} );

-- [updatePlatformRequire]
update $table$ set requireName = #{requirename},valueType = #{valuetype},updateBy = #{updateby},
updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};

-- [voidPlatformRequire]
update $table$ set voidFlag = #{voidflag},updateBy = #{updateby},
updateTime = #{updatetime},updateTimeLong = #{updatetimelong} where id = #{id};