基于javaweb+mysql的springboot医院管理系统(java+springboot+ssm+mysql+maven+thymeleaf+html)
运行环境
Java≥8、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot医院管理系统(java+springboot+ssm+mysql+maven+thymeleaf+html)
一、项目简述
功能:该项目是用springboot+layui+shiro写的医院管理系 统,该系统的业务比较复杂,数据库一共有36张表。
项目分为门诊管理、住院管理、系统管理、统计管理、数 据中心、排班管理、仓库管理、药房管理
本系统重点是门诊和住院管理 填写患者的详细信息,如姓名,年龄、手机号、性别、身 份证号、选择科室挂号类型医生、会出来相对的挂号费, 点击提交的时候会判断你输入的各项信息是否正确,如果 该手机号或者该身份证号正在就诊,则会提示该手机号或 者该身份证号正在就诊。挂号页面会根据单选按钮来查询 全部的挂号,当天的挂号和预细勺挂号,并且可以针对当 天的挂号去给用户进行一系列操作,如转入住院,如果该 病人有正在进行的项目则不能转入住院,需要把相关费用 交完后才能转入住院
门诊管理的功能: 用户挂号、处方划价、项目划价、项目缴费、项目检查、 药品缴费、门诊患者库
住院管理的功能: 入院登记、缴费管理、药品记账、项目记账、出院结算
系统管理功能: 菜单管理、角色管理、用户管理、图标管理、数据源监控 管理,其中数据源的登陆账号和密码是:admin/admin
统计管理: 门诊月度统计、住院月度统计、门诊年度统计、住院年度 统计、医生统计、门诊当天统计 数据中心
科室中心管理、医生列表管理、药品产地管理、项目大类 管理、挂号类型管理、仓库管理、经办人管理、供货商管 理、药品分类管理、药品字典管理
排班: 医生排班U里 仓库管理: 入库单管理、库存查询、出库单管理、操作记录管理等
药房管理: 药房详情管理、门诊取药管理、住院取药管理
二、项目运行
环境配置: Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts 都支持)
项目技术: JSP +Springboot+ SpringMVC + MyBatis + html+ css + JavaScript + JQuery + Ajax + Layui+ maven等等
return "view/login";
}
//登陆 shiro登陆
@RequestMapping("login")
public String login(Model model, HttpServletRequest request,String loginname,String pwd) {
//第一步:建立subject
Subject subject = SecurityUtils.getSubject();
//第二步:封装token 凭证
UsernamePasswordToken token = new UsernamePasswordToken(loginname, pwd);
//第三步:登陆
try {
//只要能通过认证就能通过了
subject.login(token);
User users=menuService.loginname(loginname);
//把user放进session
request.getSession().setAttribute("user", users);
model.addAttribute("loginname",users.getRealname());
model.addAttribute("id",users.getUserid());
//把yonghu放进session
request.getSession().setAttribute("yonghu", users.getRealname());
return "view/index";//跳转首页
} catch (UnknownAccountException e) {
//用户为空或不存在
model.addAttribute("msg", "不存在这样的用户!");
return "view/login";
} catch (IncorrectCredentialsException e) {
model.addAttribute("msg", "密码输入不对!");
return "view/login";
}
}
/*
* 加载首页左边导航栏
* */
@RequestMapping("toTreeLoad")
@ResponseBody
public List<TreeNode> toTreeLoad(HttpServletRequest request) {
//获取用户登陆id根据不同的用户有不停菜单
User user = (User) request.getSession().getAttribute("user");
///获取用户登陆id根据不同的用户有不停菜单
List<Menu> list = menuService.queryMenuByUid(user.getUserid());
//创建list集合
//把list放入nodes
List<TreeNode> nodes = new ArrayList<>();
for (Menu menus : list) {
Integer id = menus.getId();
drugstoresData.put("code", 0);
drugstoresData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
drugstoresData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
drugstoresData.put("data", pageInfo.getList());
return drugstoresData;
}
//查询报缺表数据查询对应的 仓库数据
@RequestMapping("selbaoquedrugname")
@ResponseBody
public Object selbaoquedrugname(Drugstore drugstore, Integer page, Integer limit) {
PageHelper.startPage(page, limit);
List<Drugstore> drugstores =outinstoreService.selbaoquedrugname(drugstore);//根据名字查询仓库药品
PageInfo pageInfo = new PageInfo(drugstores);
Map<String, Object> drugstoresData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式
drugstoresData.put("code", 0);
drugstoresData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
drugstoresData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
drugstoresData.put("data", pageInfo.getList());
return drugstoresData;
}
//减库存数量
@RequestMapping("updatedrugnumber")
@ResponseBody
public Integer updatedrugnumber(Ypharmacy ypharmacy,Drugstore drugstore, Record record) {
int uppharmacynumber=0;
int seldrugnamenum = outinstoreService.seldrugnamenum(drugstore);
//先修改仓库数据number
int updatedrugnumber = outinstoreService.updatedrugnumber(drugstore);
if(seldrugnamenum==1){//数量减空 删除此行药
//再删除
int deldrugnamenum = outinstoreService.deldrugnamenum(drugstore);
}
if(updatedrugnumber==1){//如果仓库数量修改成功
System.out.print("添加记录表");
int addjilu = rs.addjilu(record);//添加一条记录
//修改报缺表数量
int upbaoquenumber = outinstoreService.upbaoquenumber(drugstore);
//查询报缺表数量是否有补给完毕的数据 即number 小于等于0 的数据
int selbaoquenamenum = outinstoreService.selbaoquenamenum(drugstore);
if(selbaoquenamenum>=1){//查询到有为number0的报缺数据
//模糊查询
@RequestMapping("mohu")
@ResponseBody
public Object mohu(String durgname,ReportVo reportVo, Integer page, Integer limit){
reportVo.setReportName(durgname);
PageHelper.startPage(page, limit);
List<ReportVo> mohu = cCashierService.mohu(reportVo);
PageInfo pageInfo = new PageInfo(mohu);
Map<String, Object> tableData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式,如果后台没有加上这句话的话需要在前台页面手动设置
tableData.put("code", 0);
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
tableData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
tableData.put("data", pageInfo.getList());
return tableData;
}
//添加用户病因
@RequestMapping("addbing")
@ResponseBody
public Object addbing(Integer reid, String bing, CReport cReport){
cReport.setZhuan(bing);
cReport.setReportId(reid);
Integer addbing = cCashierService.addbing(cReport);
return addbing;
}
//查询用户有没有填写病因
@RequestMapping("selbing")
@ResponseBody
public Object selbing(Integer reid){
String selbing = cCashierService.selbing(reid);
return selbing;
}
//查看用户的检查结果
@RequestMapping("lookbing")
@ResponseBody
public Object lookbing(Integer reid){
String lookbing = cCashierService.lookbing(reid);
return lookbing;
}
//查看该用户是否还有未交钱的项目
@RequestMapping("seljiao")
@ResponseBody()
public Object seljiao(Integer reid){
int seljiao = cCashierService.seljiao(reid);
@Controller
@RequestMapping("caocc")
public class CCashierController {
@Autowired
private CCashierService cCashierService;
//进入处方页面
@RequestMapping("cc")
public Object look(Model model){
//查询所有药房
List<CWarehuose> selware = cCashierService.selware();
model.addAttribute("selware",selware);
return "cao/cashier";
}
//查询所有患者信息
@RequestMapping("selpreson")
@ResponseBody
public Object selperson(Integer page, Integer limit){
PageHelper.startPage(page, limit);
List<ReportVo> sel = cCashierService.sel();
PageInfo pageInfo = new PageInfo(sel);
Map<String, Object> tableData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式,如果后台没有加上这句话的话需要在前台页面手动设置
tableData.put("code", 0);
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
tableData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
tableData.put("data", pageInfo.getList());
if(selyi==selgong){
return 1;
}else {
return 0;
}
}
}
@Controller
@RequestMapping("seldrugstore")
public class StoreController {
@Autowired
private StoreService storeService;
@Autowired
private PutinService putinService;
@Autowired
private RecordService rs;
//查询药品仓库
@RequestMapping("selectdrugstore")
@ResponseBody
public Object seldrugstore(Drugstore drugstore, Integer page, Integer limit) {
PageHelper.startPage(page, limit);
List<Drugstore> drugstores = storeService.selStore(drugstore);
PageInfo pageInfo = new PageInfo(drugstores);
int add = storeService.updrugstore(drugstore);
if (add == 1) {
return "修改成功";
} else {
return "修改失败";
}
}
//供货商
@RequestMapping("bpisselupplier")
public Object bpisselupplier(Upplier upplier, Model model) {
List<Upplier> selupplier = storeService.selupplier(upplier);
return "drugstore/c_beputinstorage";
}
//查询药品清单
@RequestMapping("selectdgty")
@ResponseBody
public Object selectdgty(Drugdictionary drugdictionary, Integer page, Integer limit) {
PageHelper.startPage(page, limit);
List<Drugdictionary> drugdictiona = putinService.seldcy(drugdictionary);
PageInfo pageInfo = new PageInfo(drugdictiona);
Map<String, Object> drugstoresData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式
drugstoresData.put("code", 0);
drugstoresData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
drugstoresData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
drugstoresData.put("data", pageInfo.getList());
return drugstoresData;
}
//添加一条药品入库
@RequestMapping("adddrugs")
@ResponseBody
public Integer adddrugs(Drugstore drugstore,Record record) {
System.out.print("查询方法");
Integer updrugnumber=0;
Integer adddrugstore=0;
int seldrugname = putinService.seldrugname(drugstore);
System.out.println(seldrugname+"yyyyyyyyyyyyyyyyyyyyyyyy");
if(seldrugname==1){
System.out.print("进入修改方法");
updrugnumber = putinService.updrugnumber(drugstore);
System.out.print("添加记录表0");
int addjilu = rs.addjilu(record);//添加一条记录
}
@Autowired
private CTakeService cTakeService;
@RequestMapping("seltake")
private Object seltake(){
return "cao/Cquyao";
}
//查询所有患者信息
@RequestMapping("tselpreson")
@ResponseBody
public Object tselperson(Integer page, Integer limit){
PageHelper.startPage(page, limit);
List<ReportVo> sel = cTakeService.sel();
PageInfo pageInfo = new PageInfo(sel);
Map<String, Object> tableData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式,如果后台没有加上这句话的话需要在前台页面手动设置
tableData.put("code", 0);
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
tableData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
tableData.put("data", pageInfo.getList());
return tableData;
}
//修改用户状态
@RequestMapping("chuku")
@ResponseBody
public Object chuku(ReportVo reportVo){
Integer chuku = cTakeService.chuku(reportVo);
return chuku;
}
//进入查看患者页面
@RequestMapping("haun")
public Object haun(){
return "cao/chuanzhe";
}
//查看患者信息
@RequestMapping("selhuan")
@ResponseBody
public Object selhuan(ReportVo reportVo,Integer page, Integer limit){
PageHelper.startPage(page, limit);
List<ReportVo> selhuan = cTakeService.selhuan(reportVo);
PageInfo pageInfo = new PageInfo(selhuan);
Map<String, Object> tableData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式,如果后台没有加上这句话的话需要在前台页面手动设置
tableData.put("code", 0);
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
int i1 = prjectTypeService.count3(inoutpatienttype);
if(i1==0){
int i = prjectTypeService.addInoutpatienttype(inoutpatienttype);
if(i==1){
return "添加成功";
}else{
return "添加失败";
}
}else {
return inoutpatienttype.getProjectName()+"已存在";
}
}
/*
* 修改住院收费项
* */
@RequestMapping("editInoutpatienttype")
@ResponseBody
public Object editInoutpatienttype(Inoutpatienttype inoutpatienttype,Integer projectId,Integer unitId){
inoutpatienttype.setBigprojectId(projectId);
inoutpatienttype.setUnit(unitId);
int i = prjectTypeService.editInoutpatienttype(inoutpatienttype);
if(i==1){
return "修改成功";
}else{
return "修改失败";
}
}
/*
* 删除住院收费项
* */
@RequestMapping("deleteInoutpatienttype")
@ResponseBody
public Object deleteInoutpatienttype(Integer inoutpatientId){
int i = prjectTypeService.deleteInoutpatienttype(inoutpatientId);
if(i==1){
return "删除成功";
}else{
return "删除失败";
}
}
/*------------------------------------------------------------*/
/*
* 查询床位
* */
lrecord.setState(0);
int rel = 0;
//查询是否添加过但未取出该药品
List<Lrecord> lrecords = ldrugService.selDrugs(lrecord);
for (int i = 0; i < lrecords.size(); i++) {
if (lrecords.get(i).getDurgname().equals(lrecord.getDurgname())) {
rel = 1;
break;
}
}
if (rel == 1) {
//修改患者药品数量
int j = ldrugService.updDrug(lrecord);
if (j == 1) {
//减少药品数量
int o = ldrugService.updNum(lrecord);
if (o == 1) {
return "添加成功";
} else {
return "添加失败";
}
} else {
return "添加失败";
}
} else {
//计算总价
Double qian = lrecord.getRepiceprice();
Integer shu = lrecord.getDurgnum();
Double sum = qian * shu;
lrecord.setRepicetotal(sum);
lrecord.setState(0);
//添加药品
int i = ldrugService.addDrug(lrecord);
if (i == 1) {
//减少药品数量
int j = ldrugService.updNum(lrecord);
if (j == 1) {
return "添加成功";
} else {
return "添加失败";
}
//把user放进session
request.getSession().setAttribute("user", users);
model.addAttribute("loginname",users.getRealname());
model.addAttribute("id",users.getUserid());
//把yonghu放进session
request.getSession().setAttribute("yonghu", users.getRealname());
return "view/index";//跳转首页
} catch (UnknownAccountException e) {
//用户为空或不存在
model.addAttribute("msg", "不存在这样的用户!");
return "view/login";
} catch (IncorrectCredentialsException e) {
model.addAttribute("msg", "密码输入不对!");
return "view/login";
}
}
/*
* 加载首页左边导航栏
* */
@RequestMapping("toTreeLoad")
@ResponseBody
public List<TreeNode> toTreeLoad(HttpServletRequest request) {
//获取用户登陆id根据不同的用户有不停菜单
User user = (User) request.getSession().getAttribute("user");
///获取用户登陆id根据不同的用户有不停菜单
List<Menu> list = menuService.queryMenuByUid(user.getUserid());
//创建list集合
//把list放入nodes
List<TreeNode> nodes = new ArrayList<>();
for (Menu menus : list) {
Integer id = menus.getId();
Integer pid = menus.getPid();
String title = menus.getTitle();
String icon = menus.getIcon();
String href = menus.getHref();
Boolean spread = menus.getSpread() == true;
String target = menus.getTarget();
nodes.add(new TreeNode(id, pid, title, icon, href, spread, target));
}
//组装菜单
List<TreeNode> treeNodes = new ArrayList<>();
//n1.getPid() == 1 为父级菜单
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
tableData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
tableData.put("data", pageInfo.getList());
return tableData;
}
//查询药品所有信息
@RequestMapping("seldrug")
@ResponseBody
public Object seldrug(String durgname,Integer page, Integer limit,CPharmacy cPharmacy){
cPharmacy.setPharmacyName(durgname);
PageHelper.startPage(page, limit);
List<CPharmacy> selpharm = cCashierService.selpharm(cPharmacy);
PageInfo pageInfo = new PageInfo(selpharm);
Map<String, Object> tableData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式,如果后台没有加上这句话的话需要在前台页面手动设置
tableData.put("code", 0);
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
tableData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
tableData.put("data", pageInfo.getList());
return tableData;
}
//查询处方中是否有这个药
@RequestMapping("selchu")
@ResponseBody
public Object seslchu(CCashier cCashier,Integer reid, String mename){
cCashier.setReportId(reid);//把用户id存入数据库
cCashier.setDurgname(mename);//把药品名称存入实体类
Integer selcadr = cCashierService.selcadr(cCashier);
return selcadr;
}
//添加处方药品
@RequestMapping("addchu")
@ResponseBody
public Object addchu(CCashier cCashier,CPharmacy cPharmacy){
//向处方添加药品
Integer addchu = cCashierService.addchu(cCashier);
String pharmacyName=cCashier.getDurgname();
cPharmacy.setPharmacyName(pharmacyName);
//减少药房中的数量
Integer deldrunum = cCashierService.deldrunum(cPharmacy);
return addchu;
}
//查询该用户的处方
public Object deleteDoctor(Integer doctorId){
int i1 = doctorService.checkCount(doctorId);
if(i1>0){
return "该医生还有病人";
}else{
int i = doctorService.deleteDoctor(doctorId);
if(i==1){
return "删除成功";
}else{
return "删除失败";
}
}
}
/*
* 查询科室
* */
@RequestMapping("findAllDepartments")
@ResponseBody
public Object findAllDepartments(){
List<Departments> allDepartments = doctorService.findAllDepartments();
return allDepartments;
}
/*
* 查询类型
* */
@RequestMapping("findAllRegisteredtype")
@ResponseBody
public Object findAllRegisteredtype(){
List<Registeredtype> allRegisteredtype = doctorService.findAllRegisteredtype();
return allRegisteredtype;
}
}
}
}
@Controller
@RequestMapping("finance")
public class FinanceController {
@Autowired
private FinanceService financeService;
/*门诊月收入对比*/
@ResponseBody
@RequestMapping("reportYearFinance")
public Object reportYearFinance(String year){
List<Double> doubles = financeService.reportYearFinance(year);
for (int i = 0; i < doubles.size(); i++) {
if(null==doubles.get(i)) {
doubles.set(i, 0.0);
}
}
return doubles;
}
/*住院月收入对比*/
@ResponseBody
@RequestMapping("zhuYuanYearFinance")
public Object zhuYuanYearFinance(String year){
List<Double> zhuYuan = financeService.zhuYuanYearFinance(year);
for (int i = 0; i < zhuYuan.size(); i++) {
if(null==zhuYuan.get(i)) {
@Controller
@RequestMapping("drugdictionary")
public class SdrugdictionaryController {
@Autowired
private SdrugdictionaryService sdrugdictionaryService;
/*
* 查询药品
* */
@RequestMapping("findAllSdrugdictionary")
@ResponseBody
public Object SdrugdictionaryList(Sdrugdictionary sdrugdictionary, Integer page, Integer limit){
PageHelper.startPage(page, limit);
List<SdrugdictionaryMapper> listAll = sdrugdictionaryService.findAllSdrugdictionary(sdrugdictionary);
PageInfo pageInfo = new PageInfo(listAll);
Map<String, Object> tableData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式
tableData.put("code", 0);
tableData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
tableData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
tableData.put("data", pageInfo.getList());
return tableData;
}
/*
* 添加药品
* */
@RequestMapping("addSdrugdictionary")
@ResponseBody
public Object addSdrugdictionary(Sdrugdictionary sdrugdictionary){
int count = sdrugdictionaryService.count(sdrugdictionary);
if(count==0){
int i = sdrugdictionaryService.addSdrugdictionary(sdrugdictionary);
if(i==1){
return "添加成功";
}else{
return "添加失败";
}
}else {
return sdrugdictionary.getDrugName()+"已存在";
}
}
/*
System.out.print("查询方法");
Integer updrugnumber=0;
Integer adddrugstore=0;
int seldrugname = putinService.seldrugname(drugstore);
System.out.println(seldrugname+"yyyyyyyyyyyyyyyyyyyyyyyy");
if(seldrugname==1){
System.out.print("进入修改方法");
updrugnumber = putinService.updrugnumber(drugstore);
System.out.print("添加记录表0");
int addjilu = rs.addjilu(record);//添加一条记录
}
if (seldrugname!=1){
System.out.print("进入添加方法");
adddrugstore = putinService.adddrugstore(drugstore);
System.out.print("添加记录表1");
int addjilu = rs.addjilu(record);//添加一条记录
}
return adddrugstore+updrugnumber;
}
//查询选中的药品的库存数量
@RequestMapping("selnumber")
@ResponseBody
public int selnumber(Drugstore drugstore) {
System.out.print("查询数量方法");
int selnumber = putinService.selnumber(drugstore);
System.out.println(selnumber);
return selnumber;
}
//查询仓库里药品数量不足的药品
@RequestMapping("selectlackdrug")
@ResponseBody
public Object selectlackdrug(Drugstore drugstore, Integer page, Integer limit) {
PageHelper.startPage(page, limit);
List<Drugstore> drugstores = storeService.selectlackdrug(drugstore);//查询药品数量不足的药
PageInfo pageInfo = new PageInfo(drugstores);
Map<String, Object> drugstoresData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式
drugstoresData.put("code", 0);
drugstoresData.put("msg", "");
UsernamePasswordToken token = new UsernamePasswordToken(loginname, pwd);
try {
//只要能通过认证就能通过了
subject.login(token);
//加盐
String salt = UserCredentialsMatcher.generateSalt(6);
//MD5加密迭代两次
user.setPwd(UserCredentialsMatcher.encryptPassword("md5", pwd1, salt, 2));
user.setSalt(salt);
userService.editPwd(user);
return "1";//修改成功
} catch (IncorrectCredentialsException e) {
return "0";//密码错误
}
}
}
@Controller
public class SysController {
@Autowired
private UserService userService;
/*
* 跳转管理菜单
* */
@RequestMapping("toMenuManager")
public String toMenuManager() {
return "view/menu/menuManager";
}
/*
//将分页后的数据返回(每页要显示的数据)
drugstoresData.put("data", pageInfo.getList());
return drugstoresData;
}
@RequestMapping("delhuishou")
@ResponseBody
public Integer delhuishou(Huishou huishou, Record record){
//删除回收表此药(处理)
System.out.println("进入处理");
int delhuishou = pharmacyService.delhuishou(huishou);
if(delhuishou==1){
System.out.print("添加记录表");
int addjilu = rs.addjilu(record);//添加一条记录
}
return delhuishou;
}
}
@Controller
@RequestMapping("finance")
public class FinanceController {
@Autowired
private FinanceService financeService;
/*门诊月收入对比*/
@ResponseBody
@RequestMapping("reportYearFinance")
public Object reportYearFinance(String year){
List<Double> doubles = financeService.reportYearFinance(year);
for (int i = 0; i < doubles.size(); i++) {
if(null==doubles.get(i)) {
doubles.set(i, 0.0);
Map<String, Object> drugstoresData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式
drugstoresData.put("code", 0);
drugstoresData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
drugstoresData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
drugstoresData.put("data", pageInfo.getList());
return drugstoresData;
}
//添加一条药品采购单
@RequestMapping("addcaigou")
@ResponseBody
public Integer addcaigou(Caigou caigou) {
int selcaigouname = storeService.selcaigouname(caigou);//查询采购单是是否已经存在此条数据
if(selcaigouname==0){
int seldrugname =storeService.addcaigou(caigou);//添加
return seldrugname;
}else {
int upcaigounumber = storeService.upcaigounumber(caigou);//修改
return upcaigounumber;
}
}
//删除一条药品采购单
@RequestMapping("delcaigou")
@ResponseBody
public Integer delcaigou(Integer caigouid) {
int seldrugname =storeService.delcaigou(caigouid);//删除此条采购数据
return seldrugname;
}
//查询过期的药都有哪些
@RequestMapping("seldrugDateguoqi")
@ResponseBody
public Object seldrugDateguoqi(Drugstore drugstore, Integer page, Integer limit) {
PageHelper.startPage(page, limit);
List<Drugstore> drugstores = storeService.seldrugDate(drugstore);
PageInfo pageInfo = new PageInfo(drugstores);
Map<String, Object> drugstoresData = new HashMap<String, Object>();
//这是layui要求返回的json数据格式
drugstoresData.put("code", 0);
drugstoresData.put("msg", "");
//将全部数据的条数作为count传给前台(一共多少条)
drugstoresData.put("count", pageInfo.getTotal());
//将分页后的数据返回(每页要显示的数据)
drugstoresData.put("data", pageInfo.getList());
return drugstoresData;