增加企业微信的实体

Administrator

2025-11-26 f84ad7db2a9eb863404be1da330178df6c2b7fb9

增加企业微信的实体

 src/main/java/com/gs/xky/entity/QwStaff.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
package com.gs.xky.entity;

import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import lombok.Data;

/**
 * 
 * @TableName QW_STAFF
 */
@TableName(value ="QW_STAFF")
@Data
public class QwStaff implements Serializable {
    /**
     * 
     */
    @TableId
    private Long id;

    /**
     * 
     */
    private String name;

    /**
     * 
     */
    private String account;

    /**
     * 
     */
    private String position;

    /**
     * 
     */
    private String dept;

    /**
     * 
     */
    private String sex;

    /**
     * 
     */
    private String phone;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}

 src/main/java/com/gs/xky/mapper/QwStaffMapper.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,18 @@
package com.gs.xky.mapper;

import com.gs.xky.entity.QwStaff;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€QW_STAFF】的数据库操作Mapper
* @createDate 2025-11-26 10:51:47
* @Entity com.gs.xky.entity.QwStaff
*/
public interface QwStaffMapper extends BaseMapper<QwStaff> {

}





 src/main/java/com/gs/xky/service/Impl/QwStaffServiceImpl.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,22 @@
package com.gs.xky.service.Impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import generator.domain.QwStaff;
import com.gs.xky.service.QwStaffService;
import com.gs.xky.mapper.QwStaffMapper;
import org.springframework.stereotype.Service;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€QW_STAFF】的数据库操作Service实现
* @createDate 2025-11-26 10:51:47
*/
@Service
public class QwStaffServiceImpl extends ServiceImpl<QwStaffMapper, QwStaff>
    implements QwStaffService{

}





 src/main/java/com/gs/xky/service/QwStaffService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,13 @@
package com.gs.xky.service;

import generator.domain.QwStaff;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author Administrator
* @description é’ˆå¯¹è¡¨ã€QW_STAFF】的数据库操作Service
* @createDate 2025-11-26 10:51:47
*/
public interface QwStaffService extends IService<QwStaff> {

}

 src/main/resources/mapper/QwStaffMapper.xml

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,21 @@
<?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.gs.xky.mapper.QwStaffMapper">

    <resultMap id="BaseResultMap" type="com.gs.xky.entity.QwStaff">
            <id property="id" column="ID" />
            <result property="name" column="NAME" />
            <result property="account" column="ACCOUNT" />
            <result property="position" column="POSITION" />
            <result property="dept" column="DEPT" />
            <result property="sex" column="SEX" />
            <result property="phone" column="PHONE" />
    </resultMap>

    <sql id="Base_Column_List">
        ID,NAME,ACCOUNT,POSITION,DEPT,SEX,
        PHONE
    </sql>
</mapper>

 src/test/java/com/gs/xky/XkyApplicationTests.java

@@ -28,21 +28,21 @@
    void testExportAndSendProductionData() throws Exception {
        System.out.println("=== å¼€å§‹æµ‹è¯•å¯¼å‡ºç”Ÿäº§æ•°æ®å¹¶å‘送钉钉 ===");

        try {
            boolean result = vwCjScSjTsBbService.exportAndSendToDingtalk();

            if (result) {
                System.out.println("✓ ç”Ÿäº§æ•°æ®å¯¼å‡ºå¹¶å‘送成功");
                System.out.println("  - æ•°æ®å·²ä»Ž VW_CJ_SC_SJ_TS_BB è¡¨æŸ¥è¯¢");
                System.out.println("  - Excel æ–‡ä»¶å·²ç”Ÿæˆå¹¶ä¿å­˜åˆ° D:\\BIFile\\");
                System.out.println("  - é’‰é’‰æ–‡ä»¶æ¶ˆæ¯å·²å‘送");
            } else {
                System.out.println("✗ ç”Ÿäº§æ•°æ®å¯¼å‡ºæˆ–发送失败");
            }
        } catch (Exception e) {
            System.out.println("✗ å¯¼å‡ºå¹¶å‘送时发生异常: " + e.getMessage());
            e.printStackTrace();
        }
//        try {
//            boolean result = vwCjScSjTsBbService.exportAndSendToDingtalk();
//
//            if (result) {
//                System.out.println("✓ ç”Ÿäº§æ•°æ®å¯¼å‡ºå¹¶å‘送成功");
//                System.out.println("  - æ•°æ®å·²ä»Ž VW_CJ_SC_SJ_TS_BB è¡¨æŸ¥è¯¢");
//                System.out.println("  - Excel æ–‡ä»¶å·²ç”Ÿæˆå¹¶ä¿å­˜åˆ° D:\\BIFile\\");
//                System.out.println("  - é’‰é’‰æ–‡ä»¶æ¶ˆæ¯å·²å‘送");
//            } else {
//                System.out.println("✗ ç”Ÿäº§æ•°æ®å¯¼å‡ºæˆ–发送失败");
//            }
//        } catch (Exception e) {
//            System.out.println("✗ å¯¼å‡ºå¹¶å‘送时发生异常: " + e.getMessage());
//            e.printStackTrace();
//        }

        System.out.println("=== æµ‹è¯•ç»“束 ===");
    }