如何实现审核功能

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

开发工具与关键技术：VS C#

作者：

撰写时间：2019.7.26

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

如何实现审核的功能呢？首先是实现弹出审核模态框和重置表单，再通过ID获取要审核的数据和使用post获取到通过ID查询的数据，用loadDatatoForm回填表单数据和returnData接收查询返回的数据。

根据ID进行查询数据，

根据ID完成查询和回填数据后，就可以到页面点击审核按钮就可以弹出一个模态框和模态框的数据回填。

然后是保存审核的方法获取页面数据，再判断数据完整性验证如果数据为空会提示“请填写完整数据信息”，如果不为空就可以提交表单；再到验证码的点击切换；

验证码的点击切换方法调用封装好的方法生成5位数随机字符串，将生成的字符串保存到session中，将生成的字符串转换成图片生成的图片返回到浏览器这样就完成了。

再到控制器写他的保存的方法，如下面代码：判断验证码是否填写正确和判断数据，然后Linq修改在pwMember.States.Trim() == "通过"时dbBrow.States = "VIP会员"，在数据判断等完成后修改成功。

public ActionResult saveUpdateMember(PW_Member pwMember,int MemberID, string POASum)

        {

            ReturnJsonVo returnJson = new ReturnJsonVo();

            string strValidCode = Request["ValideCodeTwo"];

            string SessionValidCode = "";

            try

            {

                SessionValidCode = Session["ValideCodeTwo"].ToString();

            }

            catch (Exception e)

            {

                Console.Write(e);

            }

            if (SessionValidCode.Equals(strValidCode.Trim(), StringComparison.CurrentCultureIgnoreCase))

            {

                //判断数据

                if (!string.IsNullOrEmpty(pwMember.AuditRemark))

                {

                    //Linq 修改

                    var ID = pwMember.MemberID;

                    PW_Member dbBrow = myModles.PW_Member.Where(S => S.MemberID == ID).Single();

                    if (pwMember.States.Trim() == "通过")

                    {

                        dbBrow.States = "VIP会员";

                    }

                    else

                    {

                        dbBrow.States = "审核失败";

                    }

                    dbBrow.AuditRemark = pwMember.AuditRemark;

                    PW_Member dbPaynOnA = myModles.PW_Member.Where(S => S.MemberID == MemberID).Single();

                    dbPaynOnA.StartTime = DateTime.Now;

                    dbPaynOnA.AuditTime = DateTime.Now;

                    myModles.Entry(dbPaynOnA).State = EntityState.Modified;

                    int intR = myModles.SaveChanges();

                    if (intR > 0)

                    {

                        returnJson.State = true;

                        returnJson.Text = "修改成功";

                    }

                    else

                    {

                        returnJson.Text = "修改失败";

                    }

                }

                else

                {

                    returnJson.Text = "数据不完整";

                }

            }

            else

            {

                returnJson.Text = "请输入正确的验证码！";

            }

            return Json(returnJson, JsonRequestBehavior.AllowGet);

        }

1 前端部分

效果如下图所示：

1.1 html部分

              <el-form-item>
               <el-button type="success" icon="el-icon-search" @click="auditServer()" :disabled="this.sels.length === 0">批量审核</el-button>
                 <el-button @click="toggleSelection()">取消选择</el-button>
              </el-form-item>
            </br>
            <el-table border :fit="true" ref="multipleTable" height="520" :data="listData" :highlight-current-row="true" size="small" @selection-change="selsChange" @row-click="handleChange">
                <el-table-column type="selection" width="55"></el-table-column>
                <el-table-column prop="applcd" label="微服务编码" show-overflow-tooltip width="130px" sortable fixed="left"></el-table-column>
                <el-table-column prop="servcd" label="服务编码" show-overflow-tooltip width="130px" sortable fixed="left"></el-table-column>
            </el-table>

代码说明：

1）为table添加属性

@selection-change="selsChange" @row-click="handleChange"

2）添加一列 指定type为selection，表示该表格可选择

<el-table-column type="selection" width="55"></el-table-column>

3）当没有选择服务时，按钮不可选；

:disabled="this.sels.length === 0"

1.2 js部分

export default {
  data () {
    return {

      sels:[],


  methods: {


    selsChange(sels) {
        this.sels = sels
    },

    handleChange(row, event, column) {
        this.$refs.multipleTable.toggleRowSelection(row)
    },
    auditServer () {
      var servids = this.sels.map(item => item.servid).join(",")
      var params = {
        serverIds:servids
      }
          debugger
         auditServer(params).then(
          function (res) {
          debugger
            if(res.code === 200){
            this.$message({
                     message: res.data,
                     type: 'success'
                   })
            this.dialogFormVisible = false
            }else{
            this.$message({
                  message: '错误信息：'+res.message,
                  type: 'error'
                });
            }
               this.loadData()
          }.bind(this)
       )
    },

    toggleSelection(){
    this.$refs.multipleTable.clearSelection();
    }
  }
}

2 后端部分

2.1 mapper.xml

批量修改的Mybatis实现方式，注意sql语句的书写

<!--审核服务信息-->
    <update id="auditServers" parameterType="java.util.List">
        update sdcp_serv
        SET  ISAUDITED ='1'
        where servid in
        <foreach collection="list" index="index" item="item"
                 separator="," open="(" close=")">
            #{item,jdbcType=VARCHAR}
        </foreach>
    </update>

2.2 mapper.java(对应的接口)

int  auditServers(List<String> servids);

2.3 controller

/**   
        * @Description: 批量审核服务信息 
        * @param @param map
        * @param @return
        * @param @throws Exception   参数  
        * @return Object   返回类型    
        */ 
        @RequestMapping(value = "/auditServers", method = RequestMethod.POST)
        public Object auditServers(@RequestBody  Map<String, Object> map) throws Exception {
            if (map.get("serverIds")!=null){
                String serverIds = (String) map.get("serverIds");
                List<String> ids = Arrays.asList(serverIds.split(","));
                apiServerMapper.auditServers(ids);
            }
            return ResponseData.success("服务信息修改成功");
        }

转载请注明出处：https://blog.csdn.net/wangjie919/article/details/81103828

1.只有管理员有注册审批这个权限,因此第一步是要显示待审核状态的员工

1.EmployeeDAO类

  /**
	   * 方法四:查询所有员工信息，返回到集合中
	   * @return
	   */
	  public List<Employee> selectAllEmployee(){
			 conn=ConnectionFactory.getConnection();
			 List<Employee> employeeslist=new ArrayList<Employee>();
			 Employee employee=null;	
			 try {
				PreparedStatement st=null;
				//只查询已注册且未审批 且 角色是员工的
				String sql="select * from employee where role='2' and status='0'";
		 		st = conn.prepareStatement(sql);
				ResultSet rs =st.executeQuery(sql);
				while(rs.next()){
					employee=new Employee();
					employee.setEmployeeid(rs.getInt("employeeid"));
					employee.setEmployeename(rs.getString("employeename"));
					employee.setUsername(rs.getString("username"));
					employee.setPhone(rs.getString("phone"));
					employee.setEmail(rs.getString("email"));
					employee.setStatus(rs.getString("status"));
					employee.setDepartmentid(rs.getInt("departmentid"));
					employee.setPassword(rs.getString("password"));
					employee.setRole(rs.getString("role"));
					employeeslist.add(employee);
				}
			 } catch (SQLException e) {
				    e.printStackTrace();
			}finally{
				//最后总要关闭连接
				ConnectionFactory.closeConnection();
			}
			 return employeeslist;
		 }

2.修改

新增一个

ViewAllEmployeesServlet类

package com.meeting.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.meeting.dao.EmployeeDAO;
import com.meeting.vo.Employee;

public class ViewAllEmployeesServlet extends HttpServlet {


	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String code=request.getParameter("code");
		
		//新建一个DAO去调用刚才写的selectAllEmployee()方法
		EmployeeDAO dao=new EmployeeDAO();
		List<Employee> employeesList=dao.selectAllEmployee();
		//把查询得到的集合存起来叫employeesList,并且请求转发到approveaccount.jsp
		request.setAttribute("employeesList", employeesList);
		
		if(code!=null&code.equals("approve")){
			request.getRequestDispatcher("approveaccount.jsp").forward(request, response);
		}
		
	}

}

新增一个approveaccount.jsp

<%@ page language="java" import="java.util.*,com.meeting.vo.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<html>
    <head>
        <title>CoolMeeting会议管理系统</title>
        <link rel="stylesheet" href="styles/common03.css"/>            
    </head>
    <body>
            <div class="page-content">
                <div class="content-nav">
                    人员管理 > 注册审批
                </div>
                <table class="listtable">
                    <caption>所有待审批注册信息：</caption>
                    <!-- 取出刚刚存起来的待审批的员工列表 -->
                    <%List<Employee> employeesList=(List<Employee>)request.getAttribute("employeesList"); %>
                    <tr class="listheader">
                        <th>姓名</th>
                        <th>账号名</th>
                        <th>联系电话</th>
                        <th>电子邮件</th>
                        <th>操作</th>
                    </tr>
                  <!--   循环迭代这个列表 -->
                    <%for(Employee e:employeesList){ %>
                    <tr>
                        <td><%=e.getEmployeename()%></td>
                        <td><%=e.getUsername()%></td>
                        <td><%=e.getPhone()%></td>
                        <td><%=e.getEmail()%></td>
                        <td>
                            <input type="button" class="clickbutton" value="通过"/>
                            <input type="button" class="clickbutton" value="不通过"/>
                        </td>
                    </tr>
                    <%}%>
                </table>
            </div>
    
        <div class="page-footer">
            <hr/>
            更多问题，欢迎联系<a href="mailto:webmaster@eeg.com">管理员</a>
            <img src="images/footer.png" alt="CoolMeeting"/>
        </div>
    </body>
</html>

web.xml

	<servlet>
		<servlet-name>ViewAllEmployeesServlet</servlet-name>
		<servlet-class>com.meeting.servlet.ViewAllEmployeesServlet</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>ViewAllEmployeesServlet</servlet-name>
		<url-pattern>/ViewAllEmployeesServlet</url-pattern>
	</servlet-mapping>

测试:

登录一个管理员的账号

可以看到,待审批的员工会显示出来

2.实现审批的操作:实现通过/不通过这个按钮

1.修改数据逻辑EmployeeDAO

新增一个更新用户状态的方法updateStatus()

  /**
	   * 方法五:
	   * 向表employee中插入记录，其中status和role使用默认值
	   * @param employeeid 传入的员工id
	   * @param status	传入的员工状态
	   */
	  public void updateStatus(int employeeid,String status){
		  conn=ConnectionFactory.getConnection();
		  String sql="update employee set status='"+status+"'where employeeid="+employeeid;
		  try {		
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.executeUpdate();	
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			ConnectionFactory.closeConnection();
		}	  
	  }

2.写一个新的审批的servlet

ApproveServlet.java

package com.meeting.servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.meeting.dao.EmployeeDAO;

public class ApproveServlet extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request,response);
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		//得到需要审批的员工id
		int employeeid=Integer.parseInt(request.getParameter("employeeid"));
		//用oper来知道审批的操作是通过还是不通过
		String oper =request.getParameter("oper");
		EmployeeDAO dao=new EmployeeDAO();
		
		if(oper!=null&&oper.equals("yes")){
			//通过
			dao.updateStatus(employeeid,"1");
		}
		
		if(oper!=null&&oper.equals("no")){
			//不通过
			dao.updateStatus(employeeid,"2");
		}
		//请求转发跳转到
		request.getRequestDispatcher("ViewAllEmployeesServlet?code=approve").forward(request, response);
		
	}

}

3.修改approveaccount.jsp

修改通过与不通过的按钮

测试一下:

按通过

再改回0

按不通过按钮

成功!