单位出资人查询修改

Administrator

2021-08-28 9f29a071a7f94ff8caa3dfc8967f1ef5fd7bc099

单位出资人查询修改

 src/main/java/org/springblade/modules/shareholder/controller/ShareholderController.java

@@ -134,12 +134,12 @@

    /**
     * 出资人信息
     * @param creditcode
     * @param shareholderVO
     * @return
     */
    @PostMapping("/selectShareholderInfo")
    public R<IPage<ShareholderVO>> selectShareholderInfo(String creditcode, Query query) {
        IPage<ShareholderVO> pages=shareholderService.selectShareholderInfo(Condition.getPage(query), creditcode);
    public R<IPage<ShareholderVO>> selectShareholderInfo(ShareholderVO shareholderVO, Query query) {
        IPage<ShareholderVO> pages=shareholderService.selectShareholderInfo(Condition.getPage(query), shareholderVO);
        return R.data(pages);
    }


 src/main/java/org/springblade/modules/shareholder/mapper/ShareholderMapper.java

@@ -18,6 +18,7 @@

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.shareholder.entity.Shareholder;
import org.springblade.modules.shareholder.vo.ShareholderVO;

@@ -39,5 +40,5 @@
     * @return
     */
    List<ShareholderVO> selectShareholderPage(IPage page, ShareholderVO shareholder);
    List<ShareholderVO> selectShareholderInfo(IPage page,String creditcode);
    List<ShareholderVO> selectShareholderInfo(IPage page,@Param("shareholder") ShareholderVO shareholderVO);
}

 src/main/java/org/springblade/modules/shareholder/mapper/ShareholderMapper.xml

@@ -22,7 +22,13 @@


    <select id="selectShareholderInfo" resultMap="shareholderResultMap">
        select * from sys_shareholder where creditCode=#{creditcode}
        select * from sys_shareholder where creditCode = #{shareholder.creditcode}
        <if test="shareholder.cardid!=null and shareholder.cardid!=''">
            and cardid like concat('%', #{shareholder.cardid},'%')
        </if>
        <if test="shareholder.shareholder!=null and shareholder.shareholder!=''">
            and shareholder like concat('%',#{shareholder.shareholder},'%')
        </if>
    </select>

</mapper>

 src/main/java/org/springblade/modules/shareholder/service/IShareholderService.java

@@ -24,6 +24,6 @@
     * @return
     */
    IPage<ShareholderVO> selectShareholderPage(IPage<ShareholderVO> page, ShareholderVO shareholder);
    IPage<ShareholderVO> selectShareholderInfo(IPage<ShareholderVO> page, String creditcode);
    IPage<ShareholderVO> selectShareholderInfo(IPage<ShareholderVO> page,ShareholderVO shareholderVO);
    void importshare(List<shareExcel> data, Boolean isCovered);
}

 src/main/java/org/springblade/modules/shareholder/service/impl/ShareholderServiceImpl.java

@@ -45,8 +45,8 @@
    }

    @Override
    public IPage<ShareholderVO> selectShareholderInfo(IPage<ShareholderVO> page, String creditcode) {
        return page.setRecords(baseMapper.selectShareholderInfo(page,creditcode));
    public IPage<ShareholderVO> selectShareholderInfo(IPage<ShareholderVO> page, ShareholderVO shareholderVO) {
        return page.setRecords(baseMapper.selectShareholderInfo(page,shareholderVO));
    }

    @Override