spring+springmvc+mybatis搭建的一个佛山市房地产和建筑行业诚信管理系统附带mysql数据库

package com.ssm.web.warehouse; import java.io.IOException; import java.io.PrintWriter; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import javax.servlet.http.HttpSession; import net.sf.json.JSONArray; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.propertyeditors.CustomDateEditor; import org.springframework.stereotype.Controller; import org.springframework.web.bind.WebDataBinder; import org.springframework.web.bind.annotation.InitBinder; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import com.ssm.po.Page; import com.ssm.po.base.AttributeD; import com.ssm.po.base.Drugs; import com.ssm.po.base.Maximum; import com.ssm.po.base.Supplier; import com.ssm.po.base.Worker; import com.ssm.po.chargefor.OutpatientchargeD; import com.ssm.po.user.User; import com.ssm.po.warehouse.Apply; import com.ssm.po.warehouse.Applyd; import com.ssm.po.warehouse.Purchase; import com.ssm.po.warehouse.Storage; import com.ssm.service.base.AttributeDService; import com.ssm.service.base.DrugsService; import com.ssm.service.base.SupplierService; import com.ssm.service.base.WorkerService; import com.ssm.service.warehouse.ApplydService; import com.ssm.service.warehouse.PurchaseService; import com.ssm.service.warehouse.StorageService; import com.ssm.service.warehouse.WarehouseService; import com.ssm.util.BaseController; import com.sun.accessibility.internal.resources.accessibility; @Controller @RequestMapping("/warehouseController") public class WarehouseController extends BaseController{ private List<Applyd> listsApplyds; @Autowired private DrugsService drugsService; @Autowired private AttributeDService attributeDService; @Autowired private WarehouseService warehouseService; @Autowired private ApplydService applydService; @Autowired private WorkerService workerService; @Autowired private SupplierService supplierService; @Autowired private PurchaseService purchaseService; @Autowired private StorageService storageService; //打开新增请购单页面 @RequestMapping("/applyin") public String applyin(){ //获取当前时间 Date datetime = new Date(); //设置时间格式 String date = new SimpleDateFormat("yyyy-MM-dd").format(datetime); String dateText = new SimpleDateFormat("yyMMddhhmmss").format(datetime); String cNumber = dateText; request.setAttribute("cNumber", cNumber); request.setAttribute("date", date); return "/stock/apply_into"; } //采购查询 public void selectshop(){ Page page = super.setPage(); page.setTotal(warehouseService.total()); super.setPageTotal(page); super.request.getSession().setAttribute("page", page); int start = (page.getCurrentPage() - 1) * page.getPageSize(); List<Purchase> purchases = purchaseService.queryS(start, page.getPageSize()); request.setAttribute("purchases", purchases); } //打开采购入库 @RequestMapping("/openShop") public String openShop(){ this.selectshop(); Date datetime = new Date(); //设置时间格式 String dateText = new SimpleDateFormat("yyMMddhhmmss").format(datetime); String orderNum = "S" + dateText; request.setAttribute("orderNum", orderNum); return "/stock/shopping_plan"; } //打开入库审核 @RequestMapping("/openRuku") public String openRuku(){ Page page = super.setPage(); page.setTotal(storageService.totalStorage()); super.setPageTotal(page); super.request.getSession().setAttribute("page", page); int start = (page.getCurrentPage() - 1) * page.getPageSize(); List<Storage> storages = storageService.query(start, page.getPageSize()); request.setAttribute("storages", storages); return "/stock/inspection"; } //分页查询请购单 public void allotpage() { Page page = super.setPage(); page.setTotal(warehouseService.total()); super.setPageTotal(page); super.request.getSession().setAttribute("page", page); int start = (page.getCurrentPage() - 1) * page.getPageSize(); List<Apply> query = this.warehouseService.query(start, page.getPageSize()); request.setAttribute("query", query); } //打开查询请购单页面 @RequestMapping("/checkapply") public String checkapply(){ this.allotpage(); List<Worker> shoplist = workerService.queryshop(); List<Supplier> supplierlist = supplierService.query(); request.setAttribute("shoplist", shoplist); request.setAttribute("supplierlist", supplierlist); return "/stock/check_apply"; } //打开查询药品页面 @RequestMapping("/opendrug") public String opendrug(@RequestParam(value="drugsName",required=false) String drugsName){ Page page = super.setPage(); page.setTotal(drugsService.total(drugsName)); super.setPageTotal(page); super.request.getSession().setAttribute("page", page); int start = (page.getCurrentPage() - 1) * page.getPageSize(); List<Drugs> drugslist = this.drugsService.query(drugsName, start, page.getPageSize()); request.setAttribute("drugslist", drugslist); return "/drugsSet/drugs_list"; } //id查询 @RequestMapping("/findById") public String findById(int id){ Drugs drugs = new Drugs(); drugs.setId(id); Drugs druglist = this.drugsService.findById(drugs); if(druglist != null){ List<AttributeD> types = this.attributeDService.querytype(); List<AttributeD> units = this.attributeDService.queryunit(); request.setAttribute("druglist", druglist); request.setAttribute("types", types); request.setAttribute("units", units); return "/drugsSet/drug_update"; }else { return "/failed"; } } //格式化日期 @InitBinder public void initBinder(WebDataBinder binder) { SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); dateFormat.setLenient(false); binder.registerCustomEditor(Date.class, new CustomDateEditor(dateFormat, true)); } //修改药品信息 @RequestMapping("/updatedrug") public String updatedrug(Drugs record,String drugsName){ int id = this.drugsService.updateByPrimaryKeySelective(record); this.opendrug(null); if(id > 0){ return "/drugsSet/drugs_list"; }else { return "/failed"; } } //执行模糊条件查询 @RequestMapping("/findByWay") public String findByWay(Drugs record){ String drugsName = record.getDrugsName(); this.opendrug(drugsName); if(drugsName != null){ return "/drugsSet/drugs_list"; }else { return "/failed"; } } //分页 @RequestMapping("/page") public String page(){ return "/page/page"; } //新增请购单 @RequestMapping("/insert") public void insert(Apply record,String digital) throws IOException { if(digital != null){ String[] itemlists = digital.split(","); int items = itemlists.length/6; //新增收费单信息 record.setExamine(false); warehouseService.insertSelective(record); int applyid = record.getId(); Applyd applydetail; for(int i = 0;i < items;i++){ applydetail = new Applyd(); applydetail.setDrugsId(Integer.parseInt(itemlists[i * 6 + 0])); applydetail.setAmount(itemlists[i * 6 + 5]); applydetail.setApplyId(applyid); applydService.insertSelective(applydetail); } } } //查询请购单明细 @RequestMapping("/queryById") public void queryById(int id) throws IOException{ List<Applyd> list = this.applydService.query(id); JSONArray json = JSONArray.fromObject(list); PrintWriter out = response.getWriter(); out.print(json); out.flush(); } //新增采购单 @RequestMapping("/savepurchase") public String savepurchase(Purchase record,int applyId) throws IOExce