whycxzp
2021-06-01 14ee0d150819e624ccb79591139f9230da6355eb
更新登录类型标识
1个文件已修改
13 ■■■■ 已修改文件
nfdw_stand/src/com/fgkj/dao/impl/User_infImpl.java 13 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
nfdw_stand/src/com/fgkj/dao/impl/User_infImpl.java
@@ -564,8 +564,9 @@
    //5.1查询所有员工信息(包含1002)
    public PageInfo<User_inf> searchUserPage(PageInfo page) {
        String numberSql = "SELECT FOUND_ROWS() number";
        String sql = "select SQL_CALC_FOUND_ROWS distinct(tb_user_inf.uid),uName " +
                " from db_user.tb_user_inf " +
        String sql = "select SQL_CALC_FOUND_ROWS distinct(inf.uid),uName,login_type,face.id as faceId,face.url as faceUrl " +
                " from db_user.tb_user_inf inf" +
                " left join db_user.tb_user_face face on inf.face_id=face.id " +
                " order by uid limit ?,?";
        Connection conn = DBUtil.getConn();
        List list = DAOHelper
@@ -578,6 +579,14 @@
                                        User_inf userinf = new User_inf();
                                        userinf.setUId(rs.getInt("uId"));
                                        userinf.setUName(rs.getString("uName"));
                                        userinf.setLoginType(rs.getInt("login_type"));
                                        Face face = new Face();
                                        face.setId(rs.getInt("faceId"));
                                        face.setUrl(rs.getString("faceUrl"));
                                        userinf.setFace(face);
                                        list.add(userinf);
                                    }
                                } catch (SQLException e) {