耗材管理系统（ssh）

package com.hua.struts.action; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import com.hua.domain.Consume_apply; import com.hua.domain.Consume_audit; import com.hua.domain.Consume_audit_detail; import com.hua.domain.User; import com.hua.service.inter.ConsumeServiceInter; import com.hua.struts.form.ConsumeApplyForm; public class TPAction extends DispatchAction { @Resource public ConsumeServiceInter consumeService; //用来判别到底是耗材审核 的明细页面 还是 已审核 未审核 的明细页面 String backSign=""; public void setConsumeService(ConsumeServiceInter consumeService) { this.consumeService = consumeService; } //跳转到耗材申请页面 public ActionForward gotoConsume_applyUI(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { //获取用户权限信息，便于控制可以进行哪些操作 User userInfo=(User) request.getSession().getAttribute("userInfo"); // System.out.println("**TPAction.java***"+userInfo.getRole()+" "+userInfo.getUser_name()); //||userInfo.getRole().equals("实验室主任") if(userInfo.getRole().equals("实验室管理员")){ //合法 return mapping.findForward("gotoConsume_applyUI"); }else{ //非法或没有操作权限 return mapping.findForward("gotoAuthorityUI"); } } //从耗材申请页面 跳转到 耗材报表页面 public ActionForward gotoReportGenerationUI(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { ConsumeApplyForm consumeApplyForm=(ConsumeApplyForm) form; Consume_apply consume_apply=new Consume_apply(); //获取当前时间，作为申请编号和明细id Date nowTime=new Date(); SimpleDateFormat time=new SimpleDateFormat("yyyy-MM-dd-HH-mm-ss"); String str=time.format(nowTime); //System.out.println(str); String str_nowTime=str.replaceAll("-", ""); consume_apply.setApply_id(str_nowTime); consume_apply.setCollege(consumeApplyForm.getCollege()); consume_apply.setLaboratory(consumeApplyForm.getLaboratory()); consume_apply.setConsume_id(consumeApplyForm.getConsume_id()); consume_apply.setMaterial(consumeApplyForm.getMaterial()); consume_apply.setManufacturer(consumeApplyForm.getManufacturer()); consume_apply.setStandard(consumeApplyForm.getStandard()); consume_apply.setVersion(consumeApplyForm.getVersion()); consume_apply.setMaterial_category(consumeApplyForm.getMaterial_category()); consume_apply.setPurchase_mode(consumeApplyForm.getPurchase_mode()); consume_apply.setUnit(consumeApplyForm.getUnit()); consume_apply.setNumber(consumeApplyForm.getNumber()); consume_apply.setUnit_price(consumeApplyForm.getUnit_price()); consume_apply.setTotal_price(consumeApplyForm.getTotal_price()); consume_apply.setPurpose(consumeApplyForm.getPurpose()); /******耗材申请 时间*******/ nowTime=new Date(); time=new SimpleDateFormat("yyyy-MM-dd hh:mm"); consume_apply.setApplication_time(time.format(nowTime)); consume_apply.setAgenter(consumeApplyForm.getAgenter()); consume_apply.setRemark(consumeApplyForm.getRemark()); request.getSession().setAttribute("consumeApplyInfo", consume_apply); /* System.out.println("*****TPAction.java******"+consume_apply.getApply_id()+" 2"+consume_apply.getApplication_time());*/ return mapping.findForward("gotoReportGenerationUI"); } //返回耗材申请页面（报表页面--->耗材申请页面，做修改） public ActionForward backConsume_applyUI(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { return mapping.findForward("backConsume_applyUI"); } //提交耗材报表，成功跳转到等待审核页面，失败跳转到失败页面（或弹出对话框） public ActionForward gotoAuditUI(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { ConsumeApplyForm consumeApplyForm=(ConsumeApplyForm) form; Consume_audit consume_audit=new Consume_audit(); Consume_audit_detail consume_audit_detail=new Consume_audit_detail(); //封装 /*************明细部分 的 封装*************/ consume_audit_detail.setDetail_id(Long.parseLong(0+"")); consume_audit_detail.setConsume_id(consumeApplyForm.getApply_id()); consume_audit_detail.setMaterial(consumeApplyForm.getMaterial()); consume_audit_detail.setManufacturer(consumeApplyForm.getManufacturer()); consume_audit_detail.setStandard(consumeApplyForm.getStandard()); consume_audit_detail.setVersion(consumeApplyForm.getVersion()); consume_audit_detail.setMaterial_category(consumeApplyForm.getMaterial_category()); consume_audit_detail.setPurchase_mode(consumeApplyForm.getPurchase_mode()); consume_audit_detail.setUnit(consumeApplyForm.getUnit()); consume_audit_detail.setNumber(consumeApplyForm.getNumber()); consume_audit_detail.setUnit_price(consumeApplyForm.getUnit_price()); consume_audit_detail.setTotal_price(consumeApplyForm.getTotal_price()); consume_audit_detail.setPurpose(consumeApplyForm.getPurpose()); consume_audit_detail.setRemark(consumeApplyForm.getRemark()); /*************主表部分 的 封装*************/ consume_audit.setApply_id(consumeApplyForm.getApply_id()); consume_audit.setCollege(consumeApplyForm.getCollege()); consume_audit.setLaboratory(consumeApplyForm.getLaboratory()); consume_audit.setMaterial(consumeApplyForm.getMaterial()); consume_audit.setTotal_price(consumeApplyForm.getTotal_price()); consume_audit.setApplication_time(consumeApplyForm.getApplication_time()); consume_audit.setAgenter(consumeApplyForm.getAgenter()); consume_audit.setCollege_auditor("-"); consume_audit.setCollege_time("-"); consume_audit.setCollege_auditState("未审核"); consume_audit.setUniversity_auditor("-"); consume_audit.setUniversity_time("-"); consume_audit.setUniversity_auditState("未审核"); consume_audit.setConsume_audit_detail(consume_audit_detail); consume_audit_detail.setConsume_audit(consume_audit); try{ consumeService.saveConsume_auditAndConsume_audit_detail(consume_audit,consume_audit_detail); return mapping.findForward("gotoAuditUI"); }catch(Exception e){ e.printStackTrace(); return mapping.findForward("backConsume_applyUI"); } } //从报表审核页面到开始页面backBeginUI public ActionForward backBeginUI(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { return mapping.findForward("backBeginUI"); } //从开始界面跳转到耗材审核界面（审核耗材） @SuppressWarnings("unchecked") public ActionForward gotoConsume_auditUI(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { //在跳转到耗材审核页面前先判断是第一次还是，点击超链接 审核通过 或 审核未通过而过来的 //若是后者，则应该先修改数据库中的审核字段 //此处是根据 登录人角色 来判断是 校级审核 还是 院级审核 //1.获取用户信息，看是否有操作权限 User userInfo=(User) request.getSession().getAttribute("userInfo"); //2.接受 判断的标记 results_audit，看是进行校级还是院级审核操作 String results_audit=request.getParameter("results_audit"); //System.out.println("************000000*************"); Integer pageNow=1;//第一次登陆时，显示第一页 String pageNow_str=(String) request.getParameter("pageNow"); if(pageNow_str!=null){ pageNow=Integer.parseInt(pag