| | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.tcm.training.admin.agent.entity.AgentRegion; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Insert; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | | @Mapper |
| | | public interface AgentRegionMapper extends BaseMapper<AgentRegion> { |
| | | |
| | | /** 批量保存代理区域。 */ |
| | | @Insert("<script>INSERT INTO tcm_agent_region (agent_id, region_code, region_name, region_level, created_at) VALUES " |
| | | + "<foreach collection='regions' item='item' separator=','>" |
| | | + "(#{item.agentId}, #{item.regionCode}, #{item.regionName}, #{item.regionLevel}, #{item.createdAt})" |
| | | + "</foreach></script>") |
| | | int insertBatch(@Param("regions") List<AgentRegion> regions); |
| | | } |