package com.shlanbao.tzsc.pms.md.eqp.controller;
|
|
import java.io.File;
|
import java.io.FileInputStream;
|
import java.io.InputStream;
|
import java.io.OutputStream;
|
import java.net.URLEncoder;
|
import java.util.List;
|
|
import javax.servlet.ServletOutputStream;
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
|
import org.apache.log4j.Logger;
|
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
import org.springframework.web.bind.annotation.RequestParam;
|
import org.springframework.web.bind.annotation.ResponseBody;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import com.shlanbao.tzsc.base.controller.BaseController;
|
import com.shlanbao.tzsc.base.mapping.MdEquipment;
|
import com.shlanbao.tzsc.base.model.Combobox;
|
import com.shlanbao.tzsc.base.model.DataGrid;
|
import com.shlanbao.tzsc.base.model.Json;
|
import com.shlanbao.tzsc.base.model.PageParams;
|
import com.shlanbao.tzsc.pms.cos.spare.controller.InputFilesController;
|
import com.shlanbao.tzsc.pms.equ.overhaul.beans.EqmMaintainBean;
|
import com.shlanbao.tzsc.pms.md.eqp.beans.EquipmentsBean;
|
import com.shlanbao.tzsc.pms.md.eqp.service.EquipmentsServiceI;
|
import com.shlanbao.tzsc.utils.tools.DateUtil;
|
|
/**
|
* 设备主数据管理控制器
|
*
|
* @author liuligong
|
* @Time 2014/11/5 10:45
|
*/
|
@Controller
|
@RequestMapping("/pms/equc")
|
public class EquipmentsController extends BaseController {
|
protected Logger log = Logger.getLogger(this.getClass());
|
|
@Autowired
|
private EquipmentsServiceI equipmentsService;
|
|
@RequestMapping("/goToEqucMain")
|
public String goToEqucMain(HttpServletRequest request) {
|
return "/pms/equ/main/equAdd";
|
}
|
|
// 设备主数据新增
|
@ResponseBody
|
@RequestMapping("/addEqu")
|
public Json addEqu(MdEquipment equBean) {
|
Json json = new Json();
|
try {
|
equipmentsService.addEqu(equBean);
|
json.setMsg("操作成功!");
|
json.setSuccess(true);
|
} catch (Exception e) {
|
e.printStackTrace();
|
json.setMsg("操作失败!");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
@ResponseBody
|
@RequestMapping("/queryEqu")
|
public DataGrid queryEqu(EquipmentsBean equBean, PageParams pageParams) {
|
try {
|
DataGrid gd = equipmentsService.queryEqu(equBean, pageParams);
|
return gd;
|
} catch (Exception e) {
|
log.error("查询设备主数据异常。", e);
|
}
|
return null;
|
}
|
|
@RequestMapping("/goToEquEdit")
|
public String goToEquEdit(HttpServletRequest request, String id) {
|
try {
|
request.setAttribute("equBean", equipmentsService.getEquById(id));
|
} catch (Exception e) {
|
log.error("编辑设备主数据异常:", e);
|
}
|
return "/pms/equ/main/equEdit";
|
}
|
|
/**
|
* 查看设备主数据详情信息
|
* @author sunzhen
|
* @date 2019/07/11
|
* @param request
|
* @param id
|
* @return
|
*/
|
@RequestMapping("/goToEquDetails")
|
public String goToEquDetails(HttpServletRequest request, String id) {
|
try {
|
request.setAttribute("equBean", equipmentsService.getEquById(id));
|
} catch (Exception e) {
|
log.error("查看设备主数据详情异常:", e);
|
}
|
return "/pms/equ/main/equDetails";
|
}
|
|
@ResponseBody
|
@RequestMapping("/deleteEqu")
|
public Json deleteEqu(String id) {
|
Json json = new Json();
|
try {
|
equipmentsService.deleteEqu(id);
|
json.setMsg("删除设备主数据成功!");
|
json.setSuccess(true);
|
} catch (Exception e) {
|
log.error(message, e);
|
json.setMsg("删除设备主数据失败!");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
/**
|
* 批量删除
|
* @param ids
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping("/batchDeleteEqu")
|
public Json batchDeleteEqu(String ids) {
|
Json json = new Json();
|
try {
|
equipmentsService.batchDeleteEqu(ids);
|
json.setMsg("删除设备主数据成功!");
|
json.setSuccess(true);
|
} catch (Exception e) {
|
log.error(message, e);
|
json.setMsg("删除设备主数据失败!");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
@ResponseBody
|
@RequestMapping("/getAllEqpType")
|
public List<Combobox> getAllEqpType(String id) {
|
try {
|
return equipmentsService.getAllEqpType(id);
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return null;
|
}
|
|
@ResponseBody
|
@RequestMapping("/queryAllEquipments")
|
public List<EquipmentsBean> queryAllEquipments() {
|
try {
|
return equipmentsService.queryAllEquipments();
|
} catch (Exception e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
return null;
|
}
|
|
/**
|
* excel導出 2015.9.9--张璐
|
*
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping("/excelDeriveJuanBaoCP")
|
public void excelDeriveJuanBaoCP(EquipmentsBean shopShiftBean,HttpServletResponse response) throws Exception {
|
|
HSSFWorkbook wb = equipmentsService.ExportExcelJBPP2(shopShiftBean);
|
String addtime = DateUtil.getNowDateTime("yyyyMMddHHmmSSS");
|
response.reset();
|
response.setContentType("application/vnd.ms-excel");
|
response.setHeader("Content-Disposition", "attachment; filename="
|
+ addtime + ".xls");
|
ServletOutputStream os = response.getOutputStream();
|
wb.write(os);
|
os.flush();
|
os.close();
|
|
}
|
|
@ResponseBody
|
@RequestMapping("/inputExeclAndReadWrite")
|
public Json inputExeclAndReadWrite(
|
@RequestParam(value = "importFile", required = false) MultipartFile file,
|
HttpServletRequest request) {
|
Json json = new Json();
|
try {
|
String path = request.getSession().getServletContext()
|
.getRealPath("upload");
|
String fileName = file.getOriginalFilename();
|
File targetFile = new File(path, fileName);
|
if (!targetFile.exists()) {
|
targetFile.mkdirs();
|
}
|
file.transferTo(targetFile);
|
String url = path + "/" + fileName;
|
String bm = fileName.substring((fileName.lastIndexOf(".") + 1),
|
fileName.length());
|
List<MdEquipment> list = null;
|
InputFilesController fl = new InputFilesController();
|
if ("xls".equals(bm)) {
|
list = fl.readXls2003_4(url);
|
} else if ("xlsx".equals(bm)) {
|
list = fl.readXlsx2007_4(url);
|
}
|
if (list != null && list.size() > 0) {
|
equipmentsService.inputExeclAndReadWrite(list);
|
json.setMsg("导入成功！");
|
json.setSuccess(true);
|
}
|
} catch (Exception e) {
|
json.setMsg("导入失败！");
|
json.setSuccess(false);
|
e.printStackTrace();
|
}
|
return json;
|
}
|
}
|
