Supply_chain_finance/web/target/classes/sql/jlw/examinationClasses.md

queryByCondition

• 根据不为空的参数进行分页查询

  select @pageTag(){ t.* @} from examination_classes t where 1=1
  @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行
  and #function("examinationClasses.query")# @if(!isEmpty(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(classId)){ and t.class_id =#classId# @} @if(!isEmpty(status)){ and t.status =#status# @} @if(!isEmpty(data)){ and t.data =#data# @}

deleteExaminationClassesByIds

• 批量删除

  delete from examination_classes where find_in_set(class_id,#ids#)

deleteExaminationClassesByExaminationId

• 批量删除

  delete from examination_classes where examination_id = #examinationId#

getExaminationClassesValues

• 根据不为空的参数进行查询

  select t.* from examination_classes t where 1=1
  @if(!isEmpty(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(classId)){ and t.class_id =#classId# @} @if(!isEmpty(status)){ and t.status =#status# @} @if(!isEmpty(data)){ and t.data =#data# @}

getValuesByQuery

• 根据不为空的参数进行查询

  select t.* from examination_classes t where 1=1
  @if(!isEmpty(examinationId)){ and t.examination_id =#examinationId# @} @if(!isEmpty(classId)){ and t.class_id =#classId# @} @if(!isEmpty(status)){ and t.status =#status# @} @if(!isEmpty(data)){ and t.data =#data# @}

getClassesName

• 根据不为空的参数进行查询

  SELECT c.name class_name, ec.class_id FROM examination_classes ec LEFT JOIN classes c ON ec.class_id = c.classes_id WHERE ec.examination_id = #examinationId#