@Select("SELECT * FROM bb_app.sms_schedule WHERE status<>-1 ORDER BY status, create_time DESC")
@Results(value = { @Result(property = "sid"),
@Result(property = "name"),
@Result(property = "channel"),
@Result(property = "status"),
@Result(property = "sendTime",column = "SEND_TIME"),
@Result(property = "createTime",column = "CREATE_TIME"),
@Result(property = "updateTime", column = "UPDATE_TIME") })
public List<ScheduleVO> getScheduleVOs();
@Select("SELECT count(1) as cc FROM bb_app.sms_schedule WHERE status<>-1")
@Results({
@Result(property="totalCount",column = "cc")})
public PageVO queryCount();