数据中心编号处理

yanzhaofeige

5 days ago 1d25094b9f0e339d784e6f1b17c95c88c272dd45

数据中心编号处理

 cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcNoIndexController.java

New file
@@ -0,0 +1,104 @@
package com.odcc.cpzidc.web.controller.bis;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.odcc.cpzidc.common.annotation.Log;
import com.odcc.cpzidc.common.core.controller.BaseController;
import com.odcc.cpzidc.common.core.domain.AjaxResult;
import com.odcc.cpzidc.common.enums.BusinessType;
import com.odcc.cpzidc.bis.domain.IdcNoIndex;
import com.odcc.cpzidc.bis.service.IIdcNoIndexService;
import com.odcc.cpzidc.common.utils.poi.ExcelUtil;
import com.odcc.cpzidc.common.core.page.TableDataInfo;

/**
 * IDC编号索引Controller
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
@RestController
@RequestMapping("/bis/idcNoIndex")
public class IdcNoIndexController extends BaseController
{
    @Autowired
    private IIdcNoIndexService idcNoIndexService;

    /**
     * 查询IDC编号索引列表
     */
    @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:list')")
    @GetMapping("/list")
    public TableDataInfo list(IdcNoIndex idcNoIndex)
    {
        startPage();
        List<IdcNoIndex> list = idcNoIndexService.selectIdcNoIndexList(idcNoIndex);
        return getDataTable(list);
    }

    /**
     * 导出IDC编号索引列表
     */
    @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:export')")
    @Log(title = "IDC编号索引", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IdcNoIndex idcNoIndex)
    {
        List<IdcNoIndex> list = idcNoIndexService.selectIdcNoIndexList(idcNoIndex);
        ExcelUtil<IdcNoIndex> util = new ExcelUtil<IdcNoIndex>(IdcNoIndex.class);
        util.exportExcel(response, list, "IDC编号索引数据");
    }

    /**
     * 获取IDC编号索引详细信息
     */
    @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(idcNoIndexService.selectIdcNoIndexById(id));
    }

    /**
     * 新增IDC编号索引
     */
    @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:add')")
    @Log(title = "IDC编号索引", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IdcNoIndex idcNoIndex)
    {
        return toAjax(idcNoIndexService.insertIdcNoIndex(idcNoIndex));
    }

    /**
     * 修改IDC编号索引
     */
    @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:edit')")
    @Log(title = "IDC编号索引", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IdcNoIndex idcNoIndex)
    {
        return toAjax(idcNoIndexService.updateIdcNoIndex(idcNoIndex));
    }

    /**
     * 删除IDC编号索引
     */
    @PreAuthorize("@ss.hasPermi('bis:idcNoIndex:remove')")
    @Log(title = "IDC编号索引", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(idcNoIndexService.deleteIdcNoIndexByIds(ids));
    }
}

 cpzidc-admin/src/main/java/com/odcc/cpzidc/web/controller/bis/IdcTelCodeController.java

New file
@@ -0,0 +1,104 @@
package com.odcc.cpzidc.web.controller.bis;

import java.util.List;
import javax.servlet.http.HttpServletResponse;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.odcc.cpzidc.common.annotation.Log;
import com.odcc.cpzidc.common.core.controller.BaseController;
import com.odcc.cpzidc.common.core.domain.AjaxResult;
import com.odcc.cpzidc.common.enums.BusinessType;
import com.odcc.cpzidc.bis.domain.IdcTelCode;
import com.odcc.cpzidc.bis.service.IIdcTelCodeService;
import com.odcc.cpzidc.common.utils.poi.ExcelUtil;
import com.odcc.cpzidc.common.core.page.TableDataInfo;

/**
 * 电话区号Controller
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
@RestController
@RequestMapping("/bis/idcTelCode")
public class IdcTelCodeController extends BaseController
{
    @Autowired
    private IIdcTelCodeService idcTelCodeService;

    /**
     * 查询电话区号列表
     */
    @PreAuthorize("@ss.hasPermi('bis:idcTelCode:list')")
    @GetMapping("/list")
    public TableDataInfo list(IdcTelCode idcTelCode)
    {
        startPage();
        List<IdcTelCode> list = idcTelCodeService.selectIdcTelCodeList(idcTelCode);
        return getDataTable(list);
    }

    /**
     * 导出电话区号列表
     */
    @PreAuthorize("@ss.hasPermi('bis:idcTelCode:export')")
    @Log(title = "电话区号", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    public void export(HttpServletResponse response, IdcTelCode idcTelCode)
    {
        List<IdcTelCode> list = idcTelCodeService.selectIdcTelCodeList(idcTelCode);
        ExcelUtil<IdcTelCode> util = new ExcelUtil<IdcTelCode>(IdcTelCode.class);
        util.exportExcel(response, list, "电话区号数据");
    }

    /**
     * 获取电话区号详细信息
     */
    @PreAuthorize("@ss.hasPermi('bis:idcTelCode:query')")
    @GetMapping(value = "/{id}")
    public AjaxResult getInfo(@PathVariable("id") Long id)
    {
        return success(idcTelCodeService.selectIdcTelCodeById(id));
    }

    /**
     * 新增电话区号
     */
    @PreAuthorize("@ss.hasPermi('bis:idcTelCode:add')")
    @Log(title = "电话区号", businessType = BusinessType.INSERT)
    @PostMapping
    public AjaxResult add(@RequestBody IdcTelCode idcTelCode)
    {
        return toAjax(idcTelCodeService.insertIdcTelCode(idcTelCode));
    }

    /**
     * 修改电话区号
     */
    @PreAuthorize("@ss.hasPermi('bis:idcTelCode:edit')")
    @Log(title = "电话区号", businessType = BusinessType.UPDATE)
    @PutMapping
    public AjaxResult edit(@RequestBody IdcTelCode idcTelCode)
    {
        return toAjax(idcTelCodeService.updateIdcTelCode(idcTelCode));
    }

    /**
     * 删除电话区号
     */
    @PreAuthorize("@ss.hasPermi('bis:idcTelCode:remove')")
    @Log(title = "电话区号", businessType = BusinessType.DELETE)
    @DeleteMapping("/{ids}")
    public AjaxResult remove(@PathVariable Long[] ids)
    {
        return toAjax(idcTelCodeService.deleteIdcTelCodeByIds(ids));
    }
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcNoIndex.java

New file
@@ -0,0 +1,79 @@
package com.odcc.cpzidc.bis.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.odcc.cpzidc.common.annotation.Excel;
import com.odcc.cpzidc.common.core.domain.BaseEntity;

/**
 * IDC编号索引对象 idc_no_index
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
public class IdcNoIndex extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** ID */
    private Long id;

    /** 省份 */
    @Excel(name = "省份")
    private String telNo;

    /** 投产年份 */
    @Excel(name = "投产年份")
    private String productionYear;

    /** 序号 */
    @Excel(name = "序号")
    private String index;

    public void setId(Long id) 
    {
        this.id = id;
    }

    public Long getId() 
    {
        return id;
    }
    public void setTelNo(String telNo) 
    {
        this.telNo = telNo;
    }

    public String getTelNo() 
    {
        return telNo;
    }
    public void setProductionYear(String productionYear) 
    {
        this.productionYear = productionYear;
    }

    public String getProductionYear() 
    {
        return productionYear;
    }
    public void setIndex(String index) 
    {
        this.index = index;
    }

    public String getIndex() 
    {
        return index;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("telNo", getTelNo())
            .append("productionYear", getProductionYear())
            .append("index", getIndex())
            .toString();
    }
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/domain/IdcTelCode.java

New file
@@ -0,0 +1,109 @@
package com.odcc.cpzidc.bis.domain;

import org.apache.commons.lang3.builder.ToStringBuilder;
import org.apache.commons.lang3.builder.ToStringStyle;
import com.odcc.cpzidc.common.annotation.Excel;
import com.odcc.cpzidc.common.core.domain.BaseEntity;

/**
 * 电话区号对象 idc_tel_code
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
public class IdcTelCode extends BaseEntity
{
    private static final long serialVersionUID = 1L;

    /** 表ID */
    private Long id;

    /** 省份 */
    @Excel(name = "省份")
    private String province;

    /** 城市 */
    @Excel(name = "城市")
    private String city;

    /** 号码 */
    @Excel(name = "号码")
    private String code;

    /** 文章是否可用 */
    @Excel(name = "文章是否可用")
    private Long state;

    /** 创建者 */
    @Excel(name = "创建者")
    private Long createUser;

    public void setId(Long id) 
    {
        this.id = id;
    }

    public Long getId() 
    {
        return id;
    }
    public void setProvince(String province) 
    {
        this.province = province;
    }

    public String getProvince() 
    {
        return province;
    }
    public void setCity(String city) 
    {
        this.city = city;
    }

    public String getCity() 
    {
        return city;
    }
    public void setCode(String code) 
    {
        this.code = code;
    }

    public String getCode() 
    {
        return code;
    }
    public void setState(Long state) 
    {
        this.state = state;
    }

    public Long getState() 
    {
        return state;
    }
    public void setCreateUser(Long createUser) 
    {
        this.createUser = createUser;
    }

    public Long getCreateUser() 
    {
        return createUser;
    }

    @Override
    public String toString() {
        return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE)
            .append("id", getId())
            .append("province", getProvince())
            .append("city", getCity())
            .append("code", getCode())
            .append("state", getState())
            .append("createTime", getCreateTime())
            .append("updateTime", getUpdateTime())
            .append("createUser", getCreateUser())
            .toString();
    }
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcNoIndexMapper.java

New file
@@ -0,0 +1,61 @@
package com.odcc.cpzidc.bis.mapper;

import java.util.List;
import com.odcc.cpzidc.bis.domain.IdcNoIndex;

/**
 * IDC编号索引Mapper接口
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
public interface IdcNoIndexMapper 
{
    /**
     * 查询IDC编号索引
     * 
     * @param id IDC编号索引主键
     * @return IDC编号索引
     */
    public IdcNoIndex selectIdcNoIndexById(Long id);

    /**
     * 查询IDC编号索引列表
     * 
     * @param idcNoIndex IDC编号索引
     * @return IDC编号索引集合
     */
    public List<IdcNoIndex> selectIdcNoIndexList(IdcNoIndex idcNoIndex);

    /**
     * 新增IDC编号索引
     * 
     * @param idcNoIndex IDC编号索引
     * @return 结果
     */
    public int insertIdcNoIndex(IdcNoIndex idcNoIndex);

    /**
     * 修改IDC编号索引
     * 
     * @param idcNoIndex IDC编号索引
     * @return 结果
     */
    public int updateIdcNoIndex(IdcNoIndex idcNoIndex);

    /**
     * 删除IDC编号索引
     * 
     * @param id IDC编号索引主键
     * @return 结果
     */
    public int deleteIdcNoIndexById(Long id);

    /**
     * 批量删除IDC编号索引
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteIdcNoIndexByIds(Long[] ids);
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/mapper/IdcTelCodeMapper.java

New file
@@ -0,0 +1,61 @@
package com.odcc.cpzidc.bis.mapper;

import java.util.List;
import com.odcc.cpzidc.bis.domain.IdcTelCode;

/**
 * 电话区号Mapper接口
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
public interface IdcTelCodeMapper 
{
    /**
     * 查询电话区号
     * 
     * @param id 电话区号主键
     * @return 电话区号
     */
    public IdcTelCode selectIdcTelCodeById(Long id);

    /**
     * 查询电话区号列表
     * 
     * @param idcTelCode 电话区号
     * @return 电话区号集合
     */
    public List<IdcTelCode> selectIdcTelCodeList(IdcTelCode idcTelCode);

    /**
     * 新增电话区号
     * 
     * @param idcTelCode 电话区号
     * @return 结果
     */
    public int insertIdcTelCode(IdcTelCode idcTelCode);

    /**
     * 修改电话区号
     * 
     * @param idcTelCode 电话区号
     * @return 结果
     */
    public int updateIdcTelCode(IdcTelCode idcTelCode);

    /**
     * 删除电话区号
     * 
     * @param id 电话区号主键
     * @return 结果
     */
    public int deleteIdcTelCodeById(Long id);

    /**
     * 批量删除电话区号
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteIdcTelCodeByIds(Long[] ids);
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcNoIndexService.java

New file
@@ -0,0 +1,61 @@
package com.odcc.cpzidc.bis.service;

import java.util.List;
import com.odcc.cpzidc.bis.domain.IdcNoIndex;

/**
 * IDC编号索引Service接口
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
public interface IIdcNoIndexService 
{
    /**
     * 查询IDC编号索引
     * 
     * @param id IDC编号索引主键
     * @return IDC编号索引
     */
    public IdcNoIndex selectIdcNoIndexById(Long id);

    /**
     * 查询IDC编号索引列表
     * 
     * @param idcNoIndex IDC编号索引
     * @return IDC编号索引集合
     */
    public List<IdcNoIndex> selectIdcNoIndexList(IdcNoIndex idcNoIndex);

    /**
     * 新增IDC编号索引
     * 
     * @param idcNoIndex IDC编号索引
     * @return 结果
     */
    public int insertIdcNoIndex(IdcNoIndex idcNoIndex);

    /**
     * 修改IDC编号索引
     * 
     * @param idcNoIndex IDC编号索引
     * @return 结果
     */
    public int updateIdcNoIndex(IdcNoIndex idcNoIndex);

    /**
     * 批量删除IDC编号索引
     * 
     * @param ids 需要删除的IDC编号索引主键集合
     * @return 结果
     */
    public int deleteIdcNoIndexByIds(Long[] ids);

    /**
     * 删除IDC编号索引信息
     * 
     * @param id IDC编号索引主键
     * @return 结果
     */
    public int deleteIdcNoIndexById(Long id);
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/IIdcTelCodeService.java

New file
@@ -0,0 +1,61 @@
package com.odcc.cpzidc.bis.service;

import java.util.List;
import com.odcc.cpzidc.bis.domain.IdcTelCode;

/**
 * 电话区号Service接口
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
public interface IIdcTelCodeService 
{
    /**
     * 查询电话区号
     * 
     * @param id 电话区号主键
     * @return 电话区号
     */
    public IdcTelCode selectIdcTelCodeById(Long id);

    /**
     * 查询电话区号列表
     * 
     * @param idcTelCode 电话区号
     * @return 电话区号集合
     */
    public List<IdcTelCode> selectIdcTelCodeList(IdcTelCode idcTelCode);

    /**
     * 新增电话区号
     * 
     * @param idcTelCode 电话区号
     * @return 结果
     */
    public int insertIdcTelCode(IdcTelCode idcTelCode);

    /**
     * 修改电话区号
     * 
     * @param idcTelCode 电话区号
     * @return 结果
     */
    public int updateIdcTelCode(IdcTelCode idcTelCode);

    /**
     * 批量删除电话区号
     * 
     * @param ids 需要删除的电话区号主键集合
     * @return 结果
     */
    public int deleteIdcTelCodeByIds(Long[] ids);

    /**
     * 删除电话区号信息
     * 
     * @param id 电话区号主键
     * @return 结果
     */
    public int deleteIdcTelCodeById(Long id);
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcNoIndexServiceImpl.java

New file
@@ -0,0 +1,93 @@
package com.odcc.cpzidc.bis.service.impl;

import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.odcc.cpzidc.bis.mapper.IdcNoIndexMapper;
import com.odcc.cpzidc.bis.domain.IdcNoIndex;
import com.odcc.cpzidc.bis.service.IIdcNoIndexService;

/**
 * IDC编号索引Service业务层处理
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
@Service
public class IdcNoIndexServiceImpl implements IIdcNoIndexService 
{
    @Autowired
    private IdcNoIndexMapper idcNoIndexMapper;

    /**
     * 查询IDC编号索引
     * 
     * @param id IDC编号索引主键
     * @return IDC编号索引
     */
    @Override
    public IdcNoIndex selectIdcNoIndexById(Long id)
    {
        return idcNoIndexMapper.selectIdcNoIndexById(id);
    }

    /**
     * 查询IDC编号索引列表
     * 
     * @param idcNoIndex IDC编号索引
     * @return IDC编号索引
     */
    @Override
    public List<IdcNoIndex> selectIdcNoIndexList(IdcNoIndex idcNoIndex)
    {
        return idcNoIndexMapper.selectIdcNoIndexList(idcNoIndex);
    }

    /**
     * 新增IDC编号索引
     * 
     * @param idcNoIndex IDC编号索引
     * @return 结果
     */
    @Override
    public int insertIdcNoIndex(IdcNoIndex idcNoIndex)
    {
        return idcNoIndexMapper.insertIdcNoIndex(idcNoIndex);
    }

    /**
     * 修改IDC编号索引
     * 
     * @param idcNoIndex IDC编号索引
     * @return 结果
     */
    @Override
    public int updateIdcNoIndex(IdcNoIndex idcNoIndex)
    {
        return idcNoIndexMapper.updateIdcNoIndex(idcNoIndex);
    }

    /**
     * 批量删除IDC编号索引
     * 
     * @param ids 需要删除的IDC编号索引主键
     * @return 结果
     */
    @Override
    public int deleteIdcNoIndexByIds(Long[] ids)
    {
        return idcNoIndexMapper.deleteIdcNoIndexByIds(ids);
    }

    /**
     * 删除IDC编号索引信息
     * 
     * @param id IDC编号索引主键
     * @return 结果
     */
    @Override
    public int deleteIdcNoIndexById(Long id)
    {
        return idcNoIndexMapper.deleteIdcNoIndexById(id);
    }
}

 cpzidc-bis/src/main/java/com/odcc/cpzidc/bis/service/impl/IdcTelCodeServiceImpl.java

New file
@@ -0,0 +1,96 @@
package com.odcc.cpzidc.bis.service.impl;

import java.util.List;
import com.odcc.cpzidc.common.utils.DateUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.odcc.cpzidc.bis.mapper.IdcTelCodeMapper;
import com.odcc.cpzidc.bis.domain.IdcTelCode;
import com.odcc.cpzidc.bis.service.IIdcTelCodeService;

/**
 * 电话区号Service业务层处理
 * 
 * @author ruoyi
 * @date 2024-10-09
 */
@Service
public class IdcTelCodeServiceImpl implements IIdcTelCodeService 
{
    @Autowired
    private IdcTelCodeMapper idcTelCodeMapper;

    /**
     * 查询电话区号
     * 
     * @param id 电话区号主键
     * @return 电话区号
     */
    @Override
    public IdcTelCode selectIdcTelCodeById(Long id)
    {
        return idcTelCodeMapper.selectIdcTelCodeById(id);
    }

    /**
     * 查询电话区号列表
     * 
     * @param idcTelCode 电话区号
     * @return 电话区号
     */
    @Override
    public List<IdcTelCode> selectIdcTelCodeList(IdcTelCode idcTelCode)
    {
        return idcTelCodeMapper.selectIdcTelCodeList(idcTelCode);
    }

    /**
     * 新增电话区号
     * 
     * @param idcTelCode 电话区号
     * @return 结果
     */
    @Override
    public int insertIdcTelCode(IdcTelCode idcTelCode)
    {
        idcTelCode.setCreateTime(DateUtils.getNowDate());
        return idcTelCodeMapper.insertIdcTelCode(idcTelCode);
    }

    /**
     * 修改电话区号
     * 
     * @param idcTelCode 电话区号
     * @return 结果
     */
    @Override
    public int updateIdcTelCode(IdcTelCode idcTelCode)
    {
        idcTelCode.setUpdateTime(DateUtils.getNowDate());
        return idcTelCodeMapper.updateIdcTelCode(idcTelCode);
    }

    /**
     * 批量删除电话区号
     * 
     * @param ids 需要删除的电话区号主键
     * @return 结果
     */
    @Override
    public int deleteIdcTelCodeByIds(Long[] ids)
    {
        return idcTelCodeMapper.deleteIdcTelCodeByIds(ids);
    }

    /**
     * 删除电话区号信息
     * 
     * @param id 电话区号主键
     * @return 结果
     */
    @Override
    public int deleteIdcTelCodeById(Long id)
    {
        return idcTelCodeMapper.deleteIdcTelCodeById(id);
    }
}

 cpzidc-bis/src/main/resources/mapper/bis/IdcNoIndexMapper.xml

New file
@@ -0,0 +1,66 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.odcc.cpzidc.bis.mapper.IdcNoIndexMapper">
    
    <resultMap type="IdcNoIndex" id="IdcNoIndexResult">
        <result property="id"    column="id"    />
        <result property="telNo"    column="tel_no"    />
        <result property="productionYear"    column="production_year"    />
        <result property="index"    column="index"    />
    </resultMap>

    <sql id="selectIdcNoIndexVo">
        select id, tel_no, production_year, index from idc_no_index
    </sql>

    <select id="selectIdcNoIndexList" parameterType="IdcNoIndex" resultMap="IdcNoIndexResult">
        <include refid="selectIdcNoIndexVo"/>
        <where>  
            <if test="telNo != null  and telNo != ''"> and tel_no = #{telNo}</if>
            <if test="productionYear != null  and productionYear != ''"> and production_year = #{productionYear}</if>
            <if test="index != null  and index != ''"> and index = #{index}</if>
        </where>
    </select>
    
    <select id="selectIdcNoIndexById" parameterType="Long" resultMap="IdcNoIndexResult">
        <include refid="selectIdcNoIndexVo"/>
        where id = #{id}
    </select>

    <insert id="insertIdcNoIndex" parameterType="IdcNoIndex" useGeneratedKeys="true" keyProperty="id">
        insert into idc_no_index
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="telNo != null">tel_no,</if>
            <if test="productionYear != null">production_year,</if>
            <if test="index != null">index,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="telNo != null">#{telNo},</if>
            <if test="productionYear != null">#{productionYear},</if>
            <if test="index != null">#{index},</if>
         </trim>
    </insert>

    <update id="updateIdcNoIndex" parameterType="IdcNoIndex">
        update idc_no_index
        <trim prefix="SET" suffixOverrides=",">
            <if test="telNo != null">tel_no = #{telNo},</if>
            <if test="productionYear != null">production_year = #{productionYear},</if>
            <if test="index != null">index = #{index},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteIdcNoIndexById" parameterType="Long">
        delete from idc_no_index where id = #{id}
    </delete>

    <delete id="deleteIdcNoIndexByIds" parameterType="String">
        delete from idc_no_index where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 cpzidc-bis/src/main/resources/mapper/bis/IdcTelCodeMapper.xml

New file
@@ -0,0 +1,84 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.odcc.cpzidc.bis.mapper.IdcTelCodeMapper">
    
    <resultMap type="IdcTelCode" id="IdcTelCodeResult">
        <result property="id"    column="id"    />
        <result property="province"    column="province"    />
        <result property="city"    column="city"    />
        <result property="code"    column="code"    />
        <result property="state"    column="state"    />
        <result property="createTime"    column="create_time"    />
        <result property="updateTime"    column="update_time"    />
        <result property="createUser"    column="create_user"    />
    </resultMap>

    <sql id="selectIdcTelCodeVo">
        select id, province, city, code, state, create_time, update_time, create_user from idc_tel_code
    </sql>

    <select id="selectIdcTelCodeList" parameterType="IdcTelCode" resultMap="IdcTelCodeResult">
        <include refid="selectIdcTelCodeVo"/>
        <where>  
            <if test="province != null  and province != ''"> and province = #{province}</if>
            <if test="city != null  and city != ''"> and city = #{city}</if>
            <if test="code != null  and code != ''"> and code = #{code}</if>
            <if test="state != null "> and state = #{state}</if>
            <if test="createUser != null "> and create_user = #{createUser}</if>
        </where>
    </select>
    
    <select id="selectIdcTelCodeById" parameterType="Long" resultMap="IdcTelCodeResult">
        <include refid="selectIdcTelCodeVo"/>
        where id = #{id}
    </select>

    <insert id="insertIdcTelCode" parameterType="IdcTelCode" useGeneratedKeys="true" keyProperty="id">
        insert into idc_tel_code
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="province != null">province,</if>
            <if test="city != null">city,</if>
            <if test="code != null">code,</if>
            <if test="state != null">state,</if>
            <if test="createTime != null">create_time,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createUser != null">create_user,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="province != null">#{province},</if>
            <if test="city != null">#{city},</if>
            <if test="code != null">#{code},</if>
            <if test="state != null">#{state},</if>
            <if test="createTime != null">#{createTime},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createUser != null">#{createUser},</if>
         </trim>
    </insert>

    <update id="updateIdcTelCode" parameterType="IdcTelCode">
        update idc_tel_code
        <trim prefix="SET" suffixOverrides=",">
            <if test="province != null">province = #{province},</if>
            <if test="city != null">city = #{city},</if>
            <if test="code != null">code = #{code},</if>
            <if test="state != null">state = #{state},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createUser != null">create_user = #{createUser},</if>
        </trim>
        where id = #{id}
    </update>

    <delete id="deleteIdcTelCodeById" parameterType="Long">
        delete from idc_tel_code where id = #{id}
    </delete>

    <delete id="deleteIdcTelCodeByIds" parameterType="String">
        delete from idc_tel_code where id in 
        <foreach item="id" collection="array" open="(" separator="," close=")">
            #{id}
        </foreach>
    </delete>
</mapper>

 cpzidc-ui/src/api/bis/idcNoIndex.js

New file
@@ -0,0 +1,44 @@
import request from '@/utils/request'

// 查询IDC编号索引列表
export function listIdcNoIndex(query) {
  return request({
    url: '/bis/idcNoIndex/list',
    method: 'get',
    params: query
  })
}

// 查询IDC编号索引详细
export function getIdcNoIndex(id) {
  return request({
    url: '/bis/idcNoIndex/' + id,
    method: 'get'
  })
}

// 新增IDC编号索引
export function addIdcNoIndex(data) {
  return request({
    url: '/bis/idcNoIndex',
    method: 'post',
    data: data
  })
}

// 修改IDC编号索引
export function updateIdcNoIndex(data) {
  return request({
    url: '/bis/idcNoIndex',
    method: 'put',
    data: data
  })
}

// 删除IDC编号索引
export function delIdcNoIndex(id) {
  return request({
    url: '/bis/idcNoIndex/' + id,
    method: 'delete'
  })
}

 cpzidc-ui/src/api/bis/idcTelCode.js

New file
@@ -0,0 +1,44 @@
import request from '@/utils/request'

// 查询电话区号列表
export function listIdcTelCode(query) {
  return request({
    url: '/bis/idcTelCode/list',
    method: 'get',
    params: query
  })
}

// 查询电话区号详细
export function getIdcTelCode(id) {
  return request({
    url: '/bis/idcTelCode/' + id,
    method: 'get'
  })
}

// 新增电话区号
export function addIdcTelCode(data) {
  return request({
    url: '/bis/idcTelCode',
    method: 'post',
    data: data
  })
}

// 修改电话区号
export function updateIdcTelCode(data) {
  return request({
    url: '/bis/idcTelCode',
    method: 'put',
    data: data
  })
}

// 删除电话区号
export function delIdcTelCode(id) {
  return request({
    url: '/bis/idcTelCode/' + id,
    method: 'delete'
  })
}

 cpzidc-ui/src/views/bis/idcNoIndex/index.vue

New file
@@ -0,0 +1,273 @@
<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
      <el-form-item label="省份" prop="telNo">
        <el-input
          v-model="queryParams.telNo"
          placeholder="请输入省份"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="投产年份" prop="productionYear">
        <el-input
          v-model="queryParams.productionYear"
          placeholder="请输入投产年份"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="序号" prop="index">
        <el-input
          v-model="queryParams.index"
          placeholder="请输入序号"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          type="primary"
          plain
          icon="el-icon-plus"
          size="mini"
          @click="handleAdd"
          v-hasPermi="['bis:idcNoIndex:add']"
        >新增</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="success"
          plain
          icon="el-icon-edit"
          size="mini"
          :disabled="single"
          @click="handleUpdate"
          v-hasPermi="['bis:idcNoIndex:edit']"
        >修改</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="danger"
          plain
          icon="el-icon-delete"
          size="mini"
          :disabled="multiple"
          @click="handleDelete"
          v-hasPermi="['bis:idcNoIndex:remove']"
        >删除</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
          @click="handleExport"
          v-hasPermi="['bis:idcNoIndex:export']"
        >导出</el-button>
      </el-col>
      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>

    <el-table v-loading="loading" :data="idcNoIndexList" @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
      <el-table-column label="ID" align="center" prop="id" />
      <el-table-column label="省份" align="center" prop="telNo" />
      <el-table-column label="投产年份" align="center" prop="productionYear" />
      <el-table-column label="序号" align="center" prop="index" />
      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope">
          <el-button
            size="mini"
            type="text"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
            v-hasPermi="['bis:idcNoIndex:edit']"
          >修改</el-button>
          <el-button
            size="mini"
            type="text"
            icon="el-icon-delete"
            @click="handleDelete(scope.row)"
            v-hasPermi="['bis:idcNoIndex:remove']"
          >删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    
    <pagination
      v-show="total>0"
      :total="total"
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- 添加或修改IDC编号索引对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="省份" prop="telNo">
          <el-input v-model="form.telNo" placeholder="请输入省份" />
        </el-form-item>
        <el-form-item label="投产年份" prop="productionYear">
          <el-input v-model="form.productionYear" placeholder="请输入投产年份" />
        </el-form-item>
        <el-form-item label="序号" prop="index">
          <el-input v-model="form.index" placeholder="请输入序号" />
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">确 定</el-button>
        <el-button @click="cancel">取 消</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listIdcNoIndex, getIdcNoIndex, delIdcNoIndex, addIdcNoIndex, updateIdcNoIndex } from "@/api/bis/idcNoIndex";

export default {
  name: "IdcNoIndex",
  data() {
    return {
      // 遮罩层
      loading: true,
      // 选中数组
      ids: [],
      // 非单个禁用
      single: true,
      // 非多个禁用
      multiple: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // IDC编号索引表格数据
      idcNoIndexList: [],
      // 弹出层标题
      title: "",
      // 是否显示弹出层
      open: false,
      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        telNo: null,
        productionYear: null,
        index: null
      },
      // 表单参数
      form: {},
      // 表单校验
      rules: {
      }
    };
  },
  created() {
    this.getList();
  },
  methods: {
    /** 查询IDC编号索引列表 */
    getList() {
      this.loading = true;
      listIdcNoIndex(this.queryParams).then(response => {
        this.idcNoIndexList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    // 取消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // 表单重置
    reset() {
      this.form = {
        id: null,
        telNo: null,
        productionYear: null,
        index: null
      };
      this.resetForm("form");
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.resetForm("queryForm");
      this.handleQuery();
    },
    // 多选框选中数据
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.id)
      this.single = selection.length!==1
      this.multiple = !selection.length
    },
    /** 新增按钮操作 */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加IDC编号索引";
    },
    /** 修改按钮操作 */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getIdcNoIndex(id).then(response => {
        this.form = response.data;
        this.open = true;
        this.title = "修改IDC编号索引";
      });
    },
    /** 提交按钮 */
    submitForm() {
      this.$refs["form"].validate(valid => {
        if (valid) {
          if (this.form.id != null) {
            updateIdcNoIndex(this.form).then(response => {
              this.$modal.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addIdcNoIndex(this.form).then(response => {
              this.$modal.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** 删除按钮操作 */
    handleDelete(row) {
      const ids = row.id || this.ids;
      this.$modal.confirm('是否确认删除IDC编号索引编号为"' + ids + '"的数据项？').then(function() {
        return delIdcNoIndex(ids);
      }).then(() => {
        this.getList();
        this.$modal.msgSuccess("删除成功");
      }).catch(() => {});
    },
    /** 导出按钮操作 */
    handleExport() {
      this.download('bis/idcNoIndex/export', {
        ...this.queryParams
      }, `idcNoIndex_${new Date().getTime()}.xlsx`)
    }
  }
};
</script>

 cpzidc-ui/src/views/bis/idcTelCode/index.vue

New file
@@ -0,0 +1,298 @@
<template>
  <div class="app-container">
    <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" v-show="showSearch" label-width="68px">
      <el-form-item label="省份" prop="province">
        <el-input
          v-model="queryParams.province"
          placeholder="请输入省份"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="城市" prop="city">
        <el-input
          v-model="queryParams.city"
          placeholder="请输入城市"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="文章是否可用" prop="state">
        <el-input
          v-model="queryParams.state"
          placeholder="请输入文章是否可用"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item label="创建者" prop="createUser">
        <el-input
          v-model="queryParams.createUser"
          placeholder="请输入创建者"
          clearable
          @keyup.enter.native="handleQuery"
        />
      </el-form-item>
      <el-form-item>
        <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button>
        <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button>
      </el-form-item>
    </el-form>

    <el-row :gutter="10" class="mb8">
      <el-col :span="1.5">
        <el-button
          type="primary"
          plain
          icon="el-icon-plus"
          size="mini"
          @click="handleAdd"
          v-hasPermi="['bis:idcTelCode:add']"
        >新增</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="success"
          plain
          icon="el-icon-edit"
          size="mini"
          :disabled="single"
          @click="handleUpdate"
          v-hasPermi="['bis:idcTelCode:edit']"
        >修改</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="danger"
          plain
          icon="el-icon-delete"
          size="mini"
          :disabled="multiple"
          @click="handleDelete"
          v-hasPermi="['bis:idcTelCode:remove']"
        >删除</el-button>
      </el-col>
      <el-col :span="1.5">
        <el-button
          type="warning"
          plain
          icon="el-icon-download"
          size="mini"
          @click="handleExport"
          v-hasPermi="['bis:idcTelCode:export']"
        >导出</el-button>
      </el-col>
      <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar>
    </el-row>

    <el-table v-loading="loading" :data="idcTelCodeList" @selection-change="handleSelectionChange">
      <el-table-column type="selection" width="55" align="center" />
      <el-table-column label="表ID" align="center" prop="id" />
      <el-table-column label="省份" align="center" prop="province" />
      <el-table-column label="城市" align="center" prop="city" />
      <el-table-column label="号码" align="center" prop="code" />
      <el-table-column label="文章是否可用" align="center" prop="state" />
      <el-table-column label="创建者" align="center" prop="createUser" />
      <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
        <template slot-scope="scope">
          <el-button
            size="mini"
            type="text"
            icon="el-icon-edit"
            @click="handleUpdate(scope.row)"
            v-hasPermi="['bis:idcTelCode:edit']"
          >修改</el-button>
          <el-button
            size="mini"
            type="text"
            icon="el-icon-delete"
            @click="handleDelete(scope.row)"
            v-hasPermi="['bis:idcTelCode:remove']"
          >删除</el-button>
        </template>
      </el-table-column>
    </el-table>
    
    <pagination
      v-show="total>0"
      :total="total"
      :page.sync="queryParams.pageNum"
      :limit.sync="queryParams.pageSize"
      @pagination="getList"
    />

    <!-- 添加或修改电话区号对话框 -->
    <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body>
      <el-form ref="form" :model="form" :rules="rules" label-width="80px">
        <el-form-item label="省份" prop="province">
          <el-input v-model="form.province" placeholder="请输入省份" />
        </el-form-item>
        <el-form-item label="城市" prop="city">
          <el-input v-model="form.city" placeholder="请输入城市" />
        </el-form-item>
        <el-form-item label="号码" prop="code">
          <el-input v-model="form.code" type="textarea" placeholder="请输入内容" />
        </el-form-item>
        <el-form-item label="文章是否可用" prop="state">
          <el-input v-model="form.state" placeholder="请输入文章是否可用" />
        </el-form-item>
        <el-form-item label="创建者" prop="createUser">
          <el-input v-model="form.createUser" placeholder="请输入创建者" />
        </el-form-item>
      </el-form>
      <div slot="footer" class="dialog-footer">
        <el-button type="primary" @click="submitForm">确 定</el-button>
        <el-button @click="cancel">取 消</el-button>
      </div>
    </el-dialog>
  </div>
</template>

<script>
import { listIdcTelCode, getIdcTelCode, delIdcTelCode, addIdcTelCode, updateIdcTelCode } from "@/api/bis/idcTelCode";

export default {
  name: "IdcTelCode",
  data() {
    return {
      // 遮罩层
      loading: true,
      // 选中数组
      ids: [],
      // 非单个禁用
      single: true,
      // 非多个禁用
      multiple: true,
      // 显示搜索条件
      showSearch: true,
      // 总条数
      total: 0,
      // 电话区号表格数据
      idcTelCodeList: [],
      // 弹出层标题
      title: "",
      // 是否显示弹出层
      open: false,
      // 查询参数
      queryParams: {
        pageNum: 1,
        pageSize: 10,
        province: null,
        city: null,
        code: null,
        state: null,
        createUser: null
      },
      // 表单参数
      form: {},
      // 表单校验
      rules: {
        createUser: [
          { required: true, message: "创建者不能为空", trigger: "blur" }
        ]
      }
    };
  },
  created() {
    this.getList();
  },
  methods: {
    /** 查询电话区号列表 */
    getList() {
      this.loading = true;
      listIdcTelCode(this.queryParams).then(response => {
        this.idcTelCodeList = response.rows;
        this.total = response.total;
        this.loading = false;
      });
    },
    // 取消按钮
    cancel() {
      this.open = false;
      this.reset();
    },
    // 表单重置
    reset() {
      this.form = {
        id: null,
        province: null,
        city: null,
        code: null,
        state: null,
        createTime: null,
        updateTime: null,
        createUser: null
      };
      this.resetForm("form");
    },
    /** 搜索按钮操作 */
    handleQuery() {
      this.queryParams.pageNum = 1;
      this.getList();
    },
    /** 重置按钮操作 */
    resetQuery() {
      this.resetForm("queryForm");
      this.handleQuery();
    },
    // 多选框选中数据
    handleSelectionChange(selection) {
      this.ids = selection.map(item => item.id)
      this.single = selection.length!==1
      this.multiple = !selection.length
    },
    /** 新增按钮操作 */
    handleAdd() {
      this.reset();
      this.open = true;
      this.title = "添加电话区号";
    },
    /** 修改按钮操作 */
    handleUpdate(row) {
      this.reset();
      const id = row.id || this.ids
      getIdcTelCode(id).then(response => {
        this.form = response.data;
        this.open = true;
        this.title = "修改电话区号";
      });
    },
    /** 提交按钮 */
    submitForm() {
      this.$refs["form"].validate(valid => {
        if (valid) {
          if (this.form.id != null) {
            updateIdcTelCode(this.form).then(response => {
              this.$modal.msgSuccess("修改成功");
              this.open = false;
              this.getList();
            });
          } else {
            addIdcTelCode(this.form).then(response => {
              this.$modal.msgSuccess("新增成功");
              this.open = false;
              this.getList();
            });
          }
        }
      });
    },
    /** 删除按钮操作 */
    handleDelete(row) {
      const ids = row.id || this.ids;
      this.$modal.confirm('是否确认删除电话区号编号为"' + ids + '"的数据项？').then(function() {
        return delIdcTelCode(ids);
      }).then(() => {
        this.getList();
        this.$modal.msgSuccess("删除成功");
      }).catch(() => {});
    },
    /** 导出按钮操作 */
    handleExport() {
      this.download('bis/idcTelCode/export', {
        ...this.queryParams
      }, `idcTelCode_${new Date().getTime()}.xlsx`)
    }
  }
};
</script>