com.cory.dao.DatadictDao Maven / Gradle / Ivy
package com.cory.dao;
import com.cory.db.annotations.Dao;
import com.cory.db.annotations.Param;
import com.cory.db.annotations.Select;
import com.cory.db.annotations.Update;
import com.cory.model.DataDict;
import java.util.List;
/**
* generated by CodeGenerator on 2017/5/10.
*/
@Dao(model = DataDict.class)
public interface DatadictDao extends BaseDao {
@Select(whereSql = "type = #{type} and value = #{value}")
DataDict getByValue(@Param("type") String type, @Param("value") String value);
@Select(whereSql = "type = #{type} and SHOWABLE = 1", orderBy = true)
List getByType(@Param("type") String type, @Param("sort") String sort);
@Update(columnSql = "MODIFIER = #{modifier}, MODIFY_TIME = now(), SHOWABLE = #{showable}", whereSql = "id = #{id}")
int updateShowable(@Param("id") Integer id, @Param("showable") boolean showable, @Param("modifier") Integer modifier);
}