【SSM-报销单】6.报销单-提交报销单

最新推荐文章于 2025-01-03 21:37:47 发布

原创最新推荐文章于 2025-01-03 21:37:47 发布 · 594 阅读

2 ·

CC 4.0 BY-SA版权

项目专栏收录该内容

11 篇文章

订阅专栏

本文介绍了一个基于Java的企业报销系统中员工提交报销单的自动化流程，包括使用MyBatis进行数据库操作，通过DAO层的selectByDepartmentAndPost方法查询部门及岗位信息，以及在Controller层处理报销单提交请求，更新状态并记录处理记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在这里插入图片描述

1.Employee 添加

//提交报销单
    List<Employee> selectByDepartmentAndPost(@Param("dsn") String dsn, @Param("post") String post);

2.Employee xml

  <select id="selectByDepartmentAndPost" resultMap="employee">
        select e.*,d.sn dsn,d.name dname from employee e left join department d on d.sn=e.department_sn
        where e.sn is not NULL
        <if test="dsn!=null">
            and e.department_sn=#{dsn}
        </if>
        <if test="post!=null">
            and e.post=#{post}
        </if>
    </select>

3.C biz

 public void submit(int id) {
        ClaimVoucher claimVoucher = claimVoucherDao.select(id);
        Employee employee = employeeDao.select(claimVoucher.getCreateSn());

        claimVoucher.setStatus(Contant.CLAIMVOUCHER_SUBMIT);
        claimVoucher.setNextDealSn(employeeDao.selectByDepartmentAndPost(employee.getDepartmentSn(),Contant.POST_FM).get(0).getSn());
        claimVoucherDao.update(claimVoucher);

        DealRecord dealRecord = new DealRecord();
        dealRecord.setDealWay(Contant.DEAL_SUBMIT);
        dealRecord.setDealSn(employee.getSn());
        dealRecord.setClaimVoucherId(id);
        dealRecord.setDealResult(Contant.CLAIMVOUCHER_SUBMIT);
        dealRecord.setDealTime(new Date());
        dealRecord.setComment("无");
        dealRecordDao.insert(dealRecord);
    }

4.Controller

 @RequestMapping("/submit")
    public String submit(int id){
        claimVoucherBiz.submit(id);
        return "redirect:deal";
    }

5.修改 deal.jsp上的

<a href="/claim_voucher/submit?id=${cv.id}">提交</a>