package com.shlanbao.tzsc.pms.sys.datadict.controller;
|
|
import java.io.File;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpSession;
|
|
import org.apache.log4j.Logger;
|
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.mapping.EqmLubricant;
|
import com.shlanbao.tzsc.base.mapping.SysEqpCategory;
|
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.init.BaseParams;
|
import com.shlanbao.tzsc.pms.cos.spare.controller.InputFilesController;
|
import com.shlanbao.tzsc.pms.equ.lubricate.beans.EqmLubricantBean;
|
import com.shlanbao.tzsc.pms.equ.lubricate.service.EqmLubricantServiceI;
|
import com.shlanbao.tzsc.pms.md.fixCode.beans.FixCodeBean;
|
import com.shlanbao.tzsc.pms.sys.datadict.beans.SysEqpTypeBean;
|
import com.shlanbao.tzsc.pms.sys.datadict.service.SysEqpCategoryServiceI;
|
import com.shlanbao.tzsc.pms.sys.datadict.service.SysEqpTypeServiceI;
|
import com.shlanbao.tzsc.utils.tools.SystemConstant;
|
|
/**
|
* 数据字典维护
|
*/
|
@Controller
|
@RequestMapping("/pms/sys/eqptype")
|
public class SysEqpTypeController {
|
protected Logger log = Logger.getLogger(this.getClass());
|
@Autowired
|
private SysEqpTypeServiceI mdEqpTypeService;
|
@Autowired
|
private SysEqpCategoryServiceI mdEqpCategoryService;
|
@Autowired
|
public EqmLubricantServiceI eqmLubricantServiceI;
|
|
|
/**
|
* [功能说明]:数据字典，润滑，点检，轮保添加页基础数据加载
|
* @author wanchanghuang
|
* @createTime 2016年6月8日10:33:46
|
* @param upcode- md_fix_code表CODE
|
* */
|
@ResponseBody
|
@RequestMapping("/queryMdFixCodeByCode")
|
public Map<String, String> queryMdFixCodeByCode(HttpServletRequest request,String code){
|
List<FixCodeBean> listcb=BaseParams.getListMdFixCode();
|
Map<String, String> map=null;
|
if(listcb!=null && listcb.size()>0){
|
map=new HashMap<String, String>();
|
for(FixCodeBean f:listcb){
|
if(code.equals(f.getUpcode())){
|
map.put(f.getCode(), f.getName());
|
}
|
}
|
}
|
return map;
|
}
|
|
/**
|
* 将FixCodeBean主数据字典下的数据转化成下拉
|
* @param request
|
* @param code
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping("/queryMdFixCodeBeanByCode")
|
public List<FixCodeBean> queryMdFixCodeBeanByCode(HttpServletRequest request,String code){
|
List<FixCodeBean> listcb=BaseParams.getListMdFixCode();
|
List<FixCodeBean> beans=new ArrayList<>();
|
if(listcb!=null && listcb.size()>0){
|
FixCodeBean bean=new FixCodeBean();
|
bean.setName("请选择");
|
bean.setCode("");
|
beans.add(bean);
|
for(FixCodeBean f:listcb){
|
if(code.equals(f.getUpcode())){
|
beans.add(f);
|
}
|
}
|
}
|
return beans;
|
}
|
|
/**
|
* 将FixCodeBean主数据字典转化成下拉
|
* @param request
|
* @param code
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping("/queryMdFixCodeUpCodeBean")
|
public List<FixCodeBean> queryMdFixCodeUpCodeBean(){
|
List<FixCodeBean> listcb=BaseParams.getListMdFixCode();
|
List<FixCodeBean> beans=new ArrayList<>();
|
if(listcb!=null && listcb.size()>0){
|
FixCodeBean bean=new FixCodeBean();
|
/*bean.setName("全部");
|
bean.setCode("");*/
|
beans.add(bean);
|
for(FixCodeBean f:listcb){
|
if(f.getUpcode()!=null && f.getUpcode().equals("0")){
|
beans.add(f);
|
}
|
}
|
}
|
return beans;
|
}
|
|
|
@RequestMapping("/goToMdTypeJsp")
|
public String goToMdType(HttpServletRequest request, String id) {
|
if (null != id) {
|
try {
|
request.setAttribute("mdEqpTypeBean",
|
mdEqpTypeService.getTypeById(id));
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
}
|
return "/pms/sys/datadict/addMdType";
|
}
|
|
@RequestMapping("/AddMdTypeJsp")
|
public String goToMdType(String cateid, HttpServletRequest request)
|
throws Exception {
|
SysEqpCategory category = mdEqpCategoryService
|
.getMdCategoryById(cateid);
|
SysEqpTypeBean eqpTypeBean = new SysEqpTypeBean();
|
eqpTypeBean.setCategoryId(category.getId());
|
eqpTypeBean.setCategoryName(category.getName());
|
request.setAttribute("mdEqpTypeBean", eqpTypeBean);
|
return "/pms/sys/datadict/addMdType";
|
}
|
|
// 设备类型新增
|
@ResponseBody
|
@RequestMapping("/addMdType")
|
public Json addMdType(SysEqpTypeBean mdEqpTypeBean) {
|
Json json = new Json();
|
try {
|
mdEqpTypeService.addMdType(mdEqpTypeBean);
|
json.setMsg("操作成功!");
|
json.setSuccess(true);
|
} catch (Exception e) {
|
e.printStackTrace();
|
json.setMsg("操作失败!");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
@ResponseBody
|
@RequestMapping("/queryMdType")
|
public DataGrid queryMdType(SysEqpTypeBean mdTypeBean, PageParams pageParams) {
|
try {
|
DataGrid gd = mdEqpTypeService.queryMdType(mdTypeBean, pageParams);
|
return gd;
|
} catch (Exception e) {
|
log.error("查询异常。", e);
|
}
|
return null;
|
}
|
|
@ResponseBody
|
@RequestMapping("/queryMdEqpType")
|
public List<SysEqpTypeBean> queryMdEqpType() {
|
try {
|
return mdEqpTypeService.queryMdType();
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return null;
|
}
|
|
@ResponseBody
|
@RequestMapping("/deleteMdType")
|
public Json deleteMdType(String id) {
|
Json json = new Json();
|
try {
|
mdEqpTypeService.deleteMdType(id);
|
json.setMsg("操作成功!");
|
json.setSuccess(true);
|
} catch (Exception e) {
|
log.error("删除数据异常。", e);
|
json.setMsg("操作失败!");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
// 获取卷烟机、包装机和成型机的机型
|
@ResponseBody
|
@RequestMapping("/queryMdEqpTypeByCategory")
|
public List<SysEqpTypeBean> queryMdEqpTypeByCategory() {
|
try {
|
String[] categorys = new String[3];
|
categorys[0] = SystemConstant.CATEGORY_JY_ID;
|
categorys[1] = SystemConstant.CATEGORY_BZ_ID;
|
categorys[2] = SystemConstant.CATEGORY_CX_ID;
|
return mdEqpTypeService.queryMdEqpTypeByCategory(categorys);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return null;
|
}
|
|
@RequestMapping("/gotoHotspotJsp")
|
public String gotoHotspot(SysEqpTypeBean bean, HttpServletRequest request) {
|
try {
|
// 需要查询 不然有乱码
|
SysEqpTypeBean queryBean = mdEqpTypeService.getTypeById(bean
|
.getTwoRowId());
|
queryBean.setUploadUrl(bean.getUploadUrl());// 图片地址
|
queryBean.setTwoRowId(bean.getTwoRowId());// 子节点 主键ID
|
queryBean.setContextPath(bean.getContextPath());// 项目路径
|
queryBean.setContextDes(queryBean.getSetImagePoint());// 内容
|
request.setAttribute("mdEqpTypeBean", queryBean);
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return "/pms/sys/datadict/imagesHotspot/hotspot";
|
}
|
|
/**
|
* 图片设置
|
*
|
* @param id
|
* 主键ID
|
* @param result
|
* 设置的内容
|
* @param session
|
* @param request
|
* @return
|
*/
|
@ResponseBody
|
@RequestMapping("/setUpImage")
|
public Json setUpImage(String id, String result, String filePath,
|
HttpSession session, HttpServletRequest request) {
|
Json json = new Json();
|
try {
|
// setImagePoint
|
mdEqpTypeService.addSetUpImages(id, result, filePath);
|
json.setMsg("设置成功！");
|
json.setSuccess(true);
|
} catch (Exception e) {
|
log.error("设置异常", e);
|
json.setMsg("设置失败！");
|
json.setSuccess(false);
|
}
|
return json;
|
}
|
|
/**
|
* 【功能说明】：数据字典批量导入功能- 添加解析excel
|
*
|
* @time 2015年8月2日14:50:16
|
* @param id
|
* @param request
|
* @return path -页面路径
|
*
|
* */
|
@RequestMapping("/inputExeclAndReadWrite")
|
@ResponseBody
|
public Json inputExeclAndReadWrite(
|
@RequestParam(value = "importFile", required = false) MultipartFile file,
|
HttpServletRequest request, String type, SysEqpTypeBean etb) {
|
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=null;
|
try {
|
bm = fileName.substring((fileName.lastIndexOf(".") + 1),
|
fileName.length());
|
} catch (Exception e) {
|
json.setMsg("文件后缀错误！导入失败");
|
json.setSuccess(false);
|
return json;
|
}
|
List<SysEqpTypeBean> list = null;
|
InputFilesController fl = new InputFilesController();
|
if ("xls".equals(bm)) {
|
list = fl.readXls2003_2(url, type);
|
} else if ("xlsx".equals(bm)) {
|
list = fl.readXlsx2007_2(url, type);
|
}
|
if (list != null && list.size() > 0) {
|
mdEqpTypeService.inputExeclAndReadWrite(list, etb);
|
json.setMsg("导入成功！");
|
json.setSuccess(true);
|
}
|
} catch (Exception e) {
|
json.setMsg("导入失败！");
|
json.setSuccess(false);
|
e.printStackTrace();
|
}
|
return json;
|
}
|
|
|
|
/**##############################设备润滑#############################################################*/
|
|
|
/**设备润滑查询 */
|
@ResponseBody
|
@RequestMapping("/queryEqmLubricationById")
|
public DataGrid queryEqmLubricationById(SysEqpCategory mdTypeBean, PageParams pageParams) {
|
try {
|
DataGrid gd = eqmLubricantServiceI.queryEqmLubricationById(mdTypeBean, pageParams);
|
return gd;
|
} catch (Exception e) {
|
log.error("查询异常!!!", e);
|
}
|
return null;
|
}
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
}
|
