基于javaweb+mysql的ssm医院电子病历管理系统(java+ssm+jsp+easyui+mysql)

基于javaweb+mysql的ssm医院电子病历管理系统(java+ssm+jsp+easyui+mysql)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计,大作业,毕业设计,项目练习,学习演示等

功能说明

基于javaweb+mysql的SSM医院电子病历管理系统(java+ssm+jsp+easyui+mysql)

项目介绍

本项目分为管理员、医生两种角色。 管理员角色包含以下功能: 登录页面,个人信息,修改密码,医生管理(职位管理、科室管理、医生管理)、患者管理(患者管理、患者统计)、患者病历(病历类型、病历管理、已删病历)、系统管理(登录日志)等功能。

医生角色包含以下功能: 登录页面,个人信息,修改密码,患者管理、患者病历(病历管理、已删病历)等功能。

环境需要

1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否maven项目:否

技术栈

  1. 后端:Spring+SpringMVC+Mybatis 2. 前端:JSP+css+javascript+jQuery+bootstrap+easyui

使用说明

  1. 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中conf/jdbc.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,在浏览器中输入http://localhost:8080/ 登录
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String page = (String) request.getParameter("page");
		String rows = (String) request.getParameter("rows");
		String spchuName = (String) request.getParameter("spchuName");
		String spchuId = (String) request.getParameter("spchuId");
		String sptypeId = (String) request.getParameter("sptypeId");
		String spchuType = (String) request.getParameter("spchuType");
		String spchuType1 = (String) request.getParameter("spchuType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String roleId = (String) request.getParameter("roleId");
		String yhroleId = (String) request.getParameter("yhroleId");
		String yonghuId = (String) request.getParameter("yonghuId");
		String yhbumenId = (String) request.getParameter("yhbumenId");
		String shangpinId = (String) request.getParameter("shangpinId");
		String sdate = (String) request.getParameter("sdate");
		String edate = (String) request.getParameter("edate");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Spchu spchu = new Spchu();
		try {
			if (StringUtil.isNotEmpty(spchuName)) {
				spchu.setSpchuName(spchuName);
			}
			if (StringUtil.isNotEmpty(spchuId)) {
				spchu.setSpchuId(Integer.parseInt(spchuId));
			}
			if (StringUtil.isNotEmpty(sptypeId)) {
				spchu.setSptypeId(Integer.parseInt(sptypeId));
			}
			if (StringUtil.isNotEmpty(spchuType)) {
				spchu.setSpchuType(Integer.parseInt(spchuType));
			}
			if (StringUtil.isNotEmpty(spchuType1)) {
				spchu.setSpchuType1(Integer.parseInt(spchuType1));
			}
			if (StringUtil.isNotEmpty(userId)) {
				spchu.setUserId(Integer.parseInt(userId));
			}
			if (StringUtil.isNotEmpty(bumenId)) {
				spchu.setBumenId(Integer.parseInt(bumenId));
			}
			if (StringUtil.isNotEmpty(roleId)) {
				spchu.setRoleId(Integer.parseInt(roleId));
			}
			if (StringUtil.isNotEmpty(shangpinId)) {
				spchu.setShangpinId(Integer.parseInt(shangpinId));
			}
			if (StringUtil.isNotEmpty(yhroleId)) {
		try {
			sptypes = sptypeService.querySptypes(null, 0,0);
			for(int i=0;i<sptypes.size();i++){
				sptypeIds.add(sptypes.get(i).getSptypeId());
				sptypeNames.add(sptypes.get(i).getSptypeName());
			}
			for(int i=0;i<sptypeIds.size();i++){
				Integer spjinZongshu = 0;
				spjin.setSptypeId(sptypeIds.get(i));
				spjins = spjinService.querySpjins(spjin, 0, 0, sdate, edate);
				for(int j=0;j<spjins.size();j++){
					spjinZongshu = spjinZongshu + spjins.size();
				}
				zongshu = zongshu + spjinZongshu;
				spjinZongshus.add(spjinZongshu);
			}
			
			HttpSession session = request.getSession();
			session.setAttribute("sptypeNames", sptypeNames);
			session.setAttribute("spjinZongshus", spjinZongshus);
			session.setAttribute("zongshu", zongshu);
			response.sendRedirect("admin/spjintongji.jsp");	
			
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/shangchuanSpjin")
	public void shangchuanSpjin(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
			throws Exception {
		try {
			String spjinId = (String) request.getParameter("spjinId");
			String directory = "/file";
			String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
	        String fileName = uploadFile.getOriginalFilename();  
			File dir = new File(targetDirectory,fileName);        
	        if(!dir.exists()){
	            dir.mkdirs();
	        }
	        //MultipartFile自带的解析方法
	        uploadFile.transferTo(dir);

			String shangchuandizhi = "/file" + "/" + fileName;
			String shangchuanname = fileName;
			Spjin spjin = spjinService.getSpjin(Integer.parseInt(spjinId));
			spjin.setSpjinImg(shangchuandizhi);
			spjin.setSpjinImgName(shangchuanname);
			spjinService.modifySpjin(spjin);
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		}
		if (StringUtil.isNotEmpty(userDate1)) {
			user.setUserDate1(DateUtil.formatString(userDate1,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(userDate2)) {
			user.setUserDate2(DateUtil.formatString(userDate2,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(userType1)) {
			user.setUserType1(Integer.parseInt(userType1));
		}
		if (StringUtil.isNotEmpty(userType2)) {
			user.setUserType2(Integer.parseInt(userType2));
		}
		if (StringUtil.isNotEmpty(roleId)) {
			user.setRoleId(Integer.parseInt(roleId));
			Role role = new Role();
			role = roleService.getRole(Integer.parseInt(roleId));
			user.setRoleName(role.getRoleName());
		}
		if (StringUtil.isNotEmpty(bumenId)) {
			user.setBumenId(Integer.parseInt(bumenId));
			Bumen bumen = new Bumen();
			bumen = bumenService.getBumen(Integer.parseInt(bumenId));
			user.setBumenName(bumen.getBumenName());
		}
		try {
			if (StringUtil.isNotEmpty(userId)) {
				userService.modifyUser(user);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				int total = userService.queryUsers(null, userName, 0, 0, null, null).size();
				if (total==0) {
					Date date = new Date();
					user.setUserDate1(date);
					user.setUserType1(0);
					userService.save(user);
					result.put("success", "true");

//导入导出

@Controller
public class UyijianAction {
	@Autowired
	private UyijianService uyijianService;
	@Autowired
	private UserService userService;

	/***上传导入开始***/
	private InputStream excelFile;

	public InputStream getExcelFile() {
		return excelFile;
	}
	/***上传导入结束***/

	@RequestMapping("/getUyijians")
	        if(!dir.exists()){
	            dir.mkdirs();
	        }
	        //MultipartFile自带的解析方法
	        uploadFile.transferTo(dir);

			String shangchuandizhi = "/file" + "/" + fileName;
			String shangchuanname = fileName;
			Spchu spchu = spchuService.getSpchu(Integer.parseInt(spchuId));
			spchu.setSpchuImg(shangchuandizhi);
			spchu.setSpchuImgName(shangchuanname);
			spchuService.modifySpchu(spchu);
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/daoruSpchu")
	public void daoruSpchu(HttpServletRequest request, HttpServletResponse response,MultipartFile uploadFile)
			throws Exception {
		try {
			String directory = "/file";
			String targetDirectory = request.getSession().getServletContext().getRealPath(directory);
	        String fileName = uploadFile.getOriginalFilename();  
			File dir = new File(targetDirectory,fileName);        
	        if(!dir.exists()){
	            dir.mkdirs();
	        }
	        //MultipartFile自带的解析方法
	        uploadFile.transferTo(dir);
			excelFile = new FileInputStream(dir);
			Workbook wb = new HSSFWorkbook(excelFile);
			Sheet sheet = wb.getSheetAt(0);
			int rowNum = sheet.getLastRowNum() + 1;
			for (int i = 1; i < rowNum; i++) {
				Spchu spchu = new Spchu();
				Row row = sheet.getRow(i);

@Controller
public class SptypeAction {
	@Autowired
	private SptypeService sptypeService;

	@RequestMapping("/getSptypes")
	public void getSptypes(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String page = (String) request.getParameter("page");
		String rows = (String) request.getParameter("rows");
		String sptypeName = (String) request.getParameter("sptypeName");
		String sptypeId = (String) request.getParameter("sptypeId");
		String sptypeMark2 = (String) request.getParameter("sptypeMark2");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Sptype sptype = new Sptype();
		try {
			if (StringUtil.isNotEmpty(sptypeName)) {
				sptype.setSptypeName(sptypeName);
			}
			if (StringUtil.isNotEmpty(sptypeId)) {
				sptype.setSptypeId(Integer.parseInt(sptypeId));
			}
			if (StringUtil.isNotEmpty(sptypeMark2)) {
				sptype.setSptypeMark2(Integer.parseInt(sptypeMark2));
			}
			JSONArray jsonArray = JSONArray.fromObject(sptypeService.querySptypes(sptype, pageBean.getStart(), pageBean.getRows()));
			JSONObject result = new JSONObject();
			int total = sptypeService.querySptypes(sptype, 0, 0).size();
			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addSptype")
	public void addSptype(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		try {
			JSONObject result = new JSONObject();
			sptype = sptypeService.getSptype(Integer.parseInt(sptypeId));
			spjin.setSptypeName(sptype.getSptypeName());
		}
		if (StringUtil.isNotEmpty(shangpinId)) {
			spjin.setShangpinId(Integer.parseInt(shangpinId));
			Shangpin shangpin = new Shangpin();
			shangpin = shangpinService.getShangpin(Integer.parseInt(shangpinId));
			spjin.setShangpinName(shangpin.getShangpinName());
			spjin.setSptypeId(shangpin.getSptypeId());
			spjin.setSptypeName(shangpin.getSptypeName());
			spjin.setUserId(shangpin.getUserId());
			spjin.setUserName(shangpin.getUserName());
			spjin.setBumenId(shangpin.getBumenId());
			spjin.setBumenName(shangpin.getBumenName());
			spjin.setRoleId(shangpin.getRoleId());
			spjin.setRoleName(shangpin.getRoleName());
		}
		if (StringUtil.isNotEmpty(userId)) {
			spjin.setUserId(Integer.parseInt(userId));
			User user = new User();
			user = userService.getUser(Integer.parseInt(userId));
			spjin.setUserName(user.getUserName());
			spjin.setBumenId(user.getBumenId());
			spjin.setBumenName(user.getBumenName());
			spjin.setRoleId(user.getRoleId());
			spjin.setRoleName(user.getRoleName());
		}
		if (StringUtil.isNotEmpty(spgysId)) {
			spjin.setSpgysId(Integer.parseInt(spgysId));
			Spgys spgys = new Spgys();
			spgys = spgysService.getSpgys(Integer.parseInt(spgysId));
			spjin.setSpgysName(spgys.getSpgysName());
		}
		if (StringUtil.isNotEmpty(spcangkuId)) {
			spjin.setSpcangkuId(Integer.parseInt(spcangkuId));
			Spcangku spcangku = new Spcangku();
			spcangku = spcangkuService.getSpcangku(Integer.parseInt(spcangkuId));
			spjin.setSpcangkuName(spcangku.getSpcangkuName());
		}
		try {
			if (StringUtil.isNotEmpty(spjinId)) {
				spjin.setSpjinZe(spjin.getSpjinJine()*spjin.getSpjinZong());
				spjinService.modifySpjin(spjin);
				if(spjin.getSpjinType()==1){
					Shangpin shangpin = new Shangpin();
					shangpin = shangpinService.getShangpin(spjin.getShangpinId());
					shangpin.setShangpinZong(shangpin.getShangpinZong()+spjin.getSpjinZong());
					shangpin.setShangpinJin(shangpin.getShangpinJin()+spjin.getSpjinZe());
					shangpin.setShangpinLirun(shangpin.getShangpinXiao()-shangpin.getShangpinJin());
					shangpinService.modifyShangpin(shangpin);
				}
	        String fileName = uploadFile.getOriginalFilename();  
			File dir = new File(targetDirectory,fileName);        
	        if(!dir.exists()){
	            dir.mkdirs();
	        }
	        //MultipartFile自带的解析方法
	        uploadFile.transferTo(dir);

			String shangchuandizhi = "/file" + "/" + fileName;
			String shangchuanname = fileName;
			Gonggao gonggao = gonggaoService.getGonggao(Integer.parseInt(gonggaoId));
			gonggao.setGonggaoImg(shangchuandizhi);
			gonggao.setGonggaoImgName(shangchuanname);
			gonggaoService.modifyGonggao(gonggao);
			JSONObject result = new JSONObject();
			result.put("success", "true");
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/xiazaiGonggao")
	public void xiazaiGonggao(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String filename = (String) request.getParameter("filename");
        //模拟文件,myfile.txt为需要下载的文件  
        String path = request.getSession().getServletContext().getRealPath("file")+"\\"+filename;  
        //获取输入流  
        InputStream bis = new BufferedInputStream(new FileInputStream(new File(path)));
        //转码,免得文件名中文乱码  
        filename = URLEncoder.encode(filename,"UTF-8");  
        //设置文件下载头  
        response.addHeader("Content-Disposition", "attachment;filename=" + filename);    
        //1.设置文件ContentType类型,这样设置,会自动判断下载文件类型    
        response.setContentType("multipart/form-data");   
        BufferedOutputStream out = new BufferedOutputStream(response.getOutputStream());  
        int len = 0;  
        while((len = bis.read()) != -1){  
            out.write(len);  
            out.flush();  
        }  
        out.close();
	}

	@RequestMapping("/daoruGonggao")
					shangpin.setShangpinZong(shangpin.getShangpinZong()-spjin.getSpjinZong());
					shangpin.setShangpinJin(shangpin.getShangpinJin()-spjin.getSpjinZe());
					shangpin.setShangpinLirun(shangpin.getShangpinXiao()-shangpin.getShangpinJin());
					shangpinService.modifyShangpin(shangpin);
				}
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				Date date = new Date();
				spjin.setSpjinDate(date);
				spjin.setSpjinType(0);
				spjin.setSpjinZe(spjin.getSpjinJine()*spjin.getSpjinZong());
				spjinService.save(spjin);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteSpjin")
	public void deleteSpjin(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		String delIds = (String) request.getParameter("delIds");
		try {
			String str[] = delIds.split(",");
			for (int i = 0; i < str.length; i++) {
				spjinService.deleteSpjin(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/spjinComboList")
	public void spjinComboList(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String spchuId = (String) request.getParameter("spchuId");
		String sptypeId = (String) request.getParameter("sptypeId");
		String spchuType = (String) request.getParameter("spchuType");
		String spchuType1 = (String) request.getParameter("spchuType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String roleId = (String) request.getParameter("roleId");
		String yhroleId = (String) request.getParameter("yhroleId");
		String yonghuId = (String) request.getParameter("yonghuId");
		String yhbumenId = (String) request.getParameter("yhbumenId");
		String shangpinId = (String) request.getParameter("shangpinId");
		String sdate = (String) request.getParameter("sdate");
		String edate = (String) request.getParameter("edate");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Spchu spchu = new Spchu();
		try {
			if (StringUtil.isNotEmpty(spchuName)) {
				spchu.setSpchuName(spchuName);
			}
			if (StringUtil.isNotEmpty(spchuId)) {
				spchu.setSpchuId(Integer.parseInt(spchuId));
			}
			if (StringUtil.isNotEmpty(sptypeId)) {
				spchu.setSptypeId(Integer.parseInt(sptypeId));
			}
			if (StringUtil.isNotEmpty(spchuType)) {
				spchu.setSpchuType(Integer.parseInt(spchuType));
			}
			if (StringUtil.isNotEmpty(spchuType1)) {
				spchu.setSpchuType1(Integer.parseInt(spchuType1));
			}
			if (StringUtil.isNotEmpty(userId)) {
				spchu.setUserId(Integer.parseInt(userId));
			}
			if (StringUtil.isNotEmpty(bumenId)) {
				spchu.setBumenId(Integer.parseInt(bumenId));
			}
			if (StringUtil.isNotEmpty(roleId)) {
				spchu.setRoleId(Integer.parseInt(roleId));
			}
			if (StringUtil.isNotEmpty(shangpinId)) {

	/***上传导入开始***/
	private InputStream excelFile;

	public InputStream getExcelFile() {
		return excelFile;
	}
	/***上传导入结束***/

	@RequestMapping("/getUyijians")
	public void getUyijians(HttpServletRequest request,
			HttpServletResponse response) throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String page = (String) request.getParameter("page");
		String rows = (String) request.getParameter("rows");
		String uyijianName = (String) request.getParameter("uyijianName");
		String uyijianId = (String) request.getParameter("uyijianId");
		String uyijianType = (String) request.getParameter("uyijianType");
		String uyijianType1 = (String) request.getParameter("uyijianType1");
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String sdate = (String) request.getParameter("sdate");
		String edate = (String) request.getParameter("edate");
		PageBean pageBean = new PageBean(Integer.parseInt(page), Integer.parseInt(rows));
		Uyijian uyijian = new Uyijian();
		try {
			if (StringUtil.isNotEmpty(uyijianName)) {
				uyijian.setUyijianName(uyijianName);
			}
			if (StringUtil.isNotEmpty(uyijianId)) {
				uyijian.setUyijianId(Integer.parseInt(uyijianId));
			}
			if (StringUtil.isNotEmpty(uyijianType)) {
				uyijian.setUyijianType(Integer.parseInt(uyijianType));
			}
			if (StringUtil.isNotEmpty(uyijianType1)) {
				uyijian.setUyijianType1(Integer.parseInt(uyijianType1));
			}
			if (StringUtil.isNotEmpty(userId)) {
				uyijian.setUserId(Integer.parseInt(userId));
			}
			if (StringUtil.isNotEmpty(bumenId)) {
				uyijian.setBumenId(Integer.parseInt(bumenId));
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addUtaolun")
	public void addUtaolun(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String utaolunName = (String) request.getParameter("utaolunName");
		String utaolunMark = (String) request.getParameter("utaolunMark");
		String utaolunMark1 = (String) request.getParameter("utaolunMark1");
		String utaolunMark2 = (String) request.getParameter("utaolunMark2");
		String utaolunDate = (String) request.getParameter("utaolunDate");
		String utaolunDate1 = (String) request.getParameter("utaolunDate1");
		String utaolunType = (String) request.getParameter("utaolunType");
		String utaolunType1 = (String) request.getParameter("utaolunType1");
		String userId = (String) request.getParameter("userId");
		String yonghuId = (String) request.getParameter("yonghuId");
		String utaolunId = (String) request.getParameter("utaolunId");
		Utaolun utaolun = new Utaolun();

		if (StringUtil.isNotEmpty(utaolunId)) {
			utaolun = utaolunService.getUtaolun(Integer.parseInt(utaolunId));
		}
		if (StringUtil.isNotEmpty(utaolunName)) {
			utaolun.setUtaolunName(utaolunName);
		}
		if (StringUtil.isNotEmpty(utaolunMark)) {
			utaolun.setUtaolunMark(utaolunMark);
		}
		if (StringUtil.isNotEmpty(utaolunMark1)) {
			utaolun.setUtaolunMark1(utaolunMark1);
		}
		if (StringUtil.isNotEmpty(utaolunMark2)) {
			utaolun.setUtaolunMark2(utaolunMark2);
		}
		if (StringUtil.isNotEmpty(utaolunDate)) {
			utaolun.setUtaolunDate(DateUtil.formatString(utaolunDate,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(utaolunDate1)) {
}

//导入导出

@Controller
public class GonggaoAction {
	@Autowired
	private GonggaoService gonggaoService;
	@Autowired
	private GgtypeService ggtypeService;

	/***上传导入开始***/
		String userId = (String) request.getParameter("userId");
		String bumenId = (String) request.getParameter("bumenId");
		String shangpinId = (String) request.getParameter("shangpinId");
		Spjin spjin = new Spjin();
		if (StringUtil.isNotEmpty(spjinId)) {
			spjin.setSpjinId(Integer.parseInt(spjinId));
		}
		if (StringUtil.isNotEmpty(sptypeId)) {
			spjin.setSptypeId(Integer.parseInt(sptypeId));
		}
		if (StringUtil.isNotEmpty(spjinType)) {
			spjin.setSpjinType(Integer.parseInt(spjinType));
		}
		if (StringUtil.isNotEmpty(spjinType1)) {
			spjin.setSpjinType1(Integer.parseInt(spjinType1));
		}
		if (StringUtil.isNotEmpty(userId)) {
			spjin.setUserId(Integer.parseInt(userId));
		}
		if (StringUtil.isNotEmpty(bumenId)) {
			spjin.setBumenId(Integer.parseInt(bumenId));
		}
		if (StringUtil.isNotEmpty(shangpinId)) {
			spjin.setShangpinId(Integer.parseInt(shangpinId));
		}
		try {
			JSONArray jsonArray = new JSONArray();
			JSONObject jsonObject = new JSONObject();
			jsonObject.put("id", "");
			jsonObject.put("spjinName", "请选择...");
			jsonArray.add(jsonObject);
			jsonArray.addAll(JSONArray.fromObject(spjinService.querySpjins(spjin, 0, 0, null, null)));
			ResponseUtil.write(response, jsonArray);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/spjinTongji")
	public void spjinTongji(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		String sdate=request.getParameter("sdate");
		String edate=request.getParameter("edate");
		List<Integer> sptypeIds = new ArrayList<Integer>();
		List<String> sptypeNames = new ArrayList<String>();
		List<Integer> spjinZongshus = new ArrayList<Integer>();
			uzhannei.setUserName(user.getUserName());
			uzhannei.setBumenId(user.getBumenId());
			uzhannei.setBumenName(user.getBumenName());
		}
		if (StringUtil.isNotEmpty(shouuserId)) {
			uzhannei.setShouuserId(Integer.parseInt(shouuserId));
			User user = new User();
			user = userService.getUser(Integer.parseInt(shouuserId));
			uzhannei.setShouuserName(user.getUserName());
		}
		try {
			if (StringUtil.isNotEmpty(uzhanneiId)) {
				uzhanneiService.modifyUzhannei(uzhannei);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			} else {
				Date date = new Date();
				uzhannei.setUzhanneiDate(date);
				uzhanneiService.save(uzhannei);
				result.put("success", "true");
				ResponseUtil.write(response, result);
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/deleteUzhannei")
	public void deleteUzhannei(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		JSONObject result = new JSONObject();
		String delIds = (String) request.getParameter("delIds");
		try {
			String str[] = delIds.split(",");
			for (int i = 0; i < str.length; i++) {
				uzhanneiService.deleteUzhannei(Integer.parseInt(str[i]));
			}
			result.put("success", "true");
			result.put("delNums", str.length);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/uzhanneiComboList")
	public void uzhanneiComboList(HttpServletRequest request, HttpServletResponse response)
			}
			if (StringUtil.isNotEmpty(yhbumenId)) {
				yhbumen.setYhbumenId(Integer.parseInt(yhbumenId));
			}
			if (StringUtil.isNotEmpty(yhbumenMark2)) {
				yhbumen.setYhbumenMark2(Integer.parseInt(yhbumenMark2));
			}
			JSONArray jsonArray = JSONArray.fromObject(yhbumenService.queryYhbumens(yhbumen, pageBean.getStart(), pageBean.getRows()));
			JSONObject result = new JSONObject();
			int total = yhbumenService.queryYhbumens(yhbumen, 0, 0).size();
			result.put("rows", jsonArray);
			result.put("total", total);
			ResponseUtil.write(response, result);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	@RequestMapping("/addYhbumen")
	public void addYhbumen(HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		try {
			JSONObject result = new JSONObject();
			
			String yhbumenName = (String) request.getParameter("yhbumenName");
			String yhbumenMark = (String) request.getParameter("yhbumenMark");
			String yhbumenMark1 = (String) request.getParameter("yhbumenMark1");
			String yhbumenMark2 = (String) request.getParameter("yhbumenMark2");
			String yhbumenId = (String) request.getParameter("yhbumenId");
			Yhbumen yhbumen = new Yhbumen();
			
			if (StringUtil.isNotEmpty(yhbumenId)) {
				yhbumen = yhbumenService.getYhbumen(Integer.parseInt(yhbumenId));
			}
			if (StringUtil.isNotEmpty(yhbumenName)) {
				yhbumen.setYhbumenName(yhbumenName);
			}
			if (StringUtil.isNotEmpty(yhbumenMark)) {
				yhbumen.setYhbumenMark(yhbumenMark);
			}
			if (StringUtil.isNotEmpty(yhbumenMark1)) {
				yhbumen.setYhbumenMark1(yhbumenMark1);
			}
			if (StringUtil.isNotEmpty(yhbumenMark2)) {
				yhbumen.setYhbumenMark2(Integer.parseInt(yhbumenMark2));
			}

			if (StringUtil.isNotEmpty(yhbumenId)) {
				yhbumenService.modifyYhbumen(yhbumen);
			} else {
		String uzhanneiMark1 = (String) request.getParameter("uzhanneiMark1");
		String uzhanneiMark2 = (String) request.getParameter("uzhanneiMark2");
		String uzhanneiDate = (String) request.getParameter("uzhanneiDate");
		String uzhanneiType = (String) request.getParameter("uzhanneiType");
		String uzhanneiType1 = (String) request.getParameter("uzhanneiType1");
		String uxtypeId = (String) request.getParameter("uxtypeId");
		String userId = (String) request.getParameter("userId");
		String shouuserId = request.getParameter("shouuserId");
		String uzhanneiDate1 = request.getParameter("uzhanneiDate1");
		String uzhanneiId = (String) request.getParameter("uzhanneiId");
		Uzhannei uzhannei = new Uzhannei();

		if (StringUtil.isNotEmpty(uzhanneiId)) {
			uzhannei = uzhanneiService.getUzhannei(Integer.parseInt(uzhanneiId));
		}
		if (StringUtil.isNotEmpty(uzhanneiName)) {
			uzhannei.setUzhanneiName(uzhanneiName);
		}
		if (StringUtil.isNotEmpty(uzhanneiMark)) {
			uzhannei.setUzhanneiMark(uzhanneiMark);
		}
		if (StringUtil.isNotEmpty(uzhanneiMark1)) {
			uzhannei.setUzhanneiMark1(uzhanneiMark1);
		}
		if (StringUtil.isNotEmpty(uzhanneiMark2)) {
			uzhannei.setUzhanneiMark2(uzhanneiMark2);
			Date date = new Date();
			uzhannei.setUzhanneiDate1(date);
			uzhannei.setUzhanneiType(1);
		}
		if (StringUtil.isNotEmpty(uzhanneiDate)) {
			uzhannei.setUzhanneiDate(DateUtil.formatString(uzhanneiDate,
					"yyyy-MM-dd hh:mm:ss"));
		}
		if (StringUtil.isNotEmpty(uzhanneiDate1)) {
			uzhannei.setUzhanneiDate1(DateUtil.formatString(uzhanneiDate1,
					"yyyy-MM-dd HH:mm:ss"));
		}
		if (StringUtil.isNotEmpty(uzhanneiType)) {
			uzhannei.setUzhanneiType(Integer.parseInt(uzhanneiType));
		}
		if (StringUtil.isNotEmpty(uzhanneiType1)) {
			uzhannei.setUzhanneiType1(Integer.parseInt(uzhanneiType1));
		}
		if (StringUtil.isNotEmpty(uxtypeId)) {
			uzhannei.setUxtypeId(Integer.parseInt(uxtypeId));
			Uxtype uxtype = new Uxtype();
			uxtype = uxtypeService.getUxtype(Integer.parseInt(uxtypeId));
			uzhannei.setUxtypeName(uxtype.getUxtypeName());
		}
		if (StringUtil.isNotEmpty(userId)) {

请添加图片描述

请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述
请添加图片描述

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值