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

-- [queryPlatformInfoList]
select *
from $table$
-- trim prefix=WHERE prefixOverrides=AND|OR
  -- isNotEmpty voidFlag
      -- if voidFlag >= 0
        voidFlag = #{voidFlag}
      -- end
  -- end
  -- isNotEmpty platformType
      -- if platformType >= 0
        and platformType = #{platformType}
      -- end
  -- end
  -- isNotEmpty keyWord
    and (platformName LIKE #{Like:keyWord})
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addPlatformInfo]
insert into $table$ (id, platformCode, platformName, platformType, requireListSerial,
voidFlag, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong ) values ( #{id}, #{platformcode}, #{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
  -- isNotEmpty idPlatform
      -- if idPlatform >= 0
        idPlatform = #{idPlatform}
      -- end
  -- end
  -- isNotEmpty voidFlag
      -- if voidFlag >= 0
        and voidFlag = #{voidFlag}
      -- end
  -- end
  -- isNotEmpty keyWord
    and (requireName LIKE #{Like:keyWord})
  -- end
-- end
-- isEmpty orderBy
order by createTime desc
-- else
order by #{orderBy}
-- end
;

-- [addPlatformRequire]
insert into $table$
(id, idPlatform, requireName, requireCode, valueType,
voidFlag, createBy, createTime,
createTimeLong, updateBy, updateTime,
updateTimeLong )
values
( #{id}, #{idplatform}, #{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};