AttachedController.java 7.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  1. package com.zhcs.dt.controller.information.attached;
  2. import java.text.DateFormat;
  3. import java.text.SimpleDateFormat;
  4. import java.util.ArrayList;
  5. import java.util.Date;
  6. import java.util.HashMap;
  7. import java.util.List;
  8. import java.util.Map;
  9. import javax.annotation.Resource;
  10. import org.springframework.beans.propertyeditors.CustomDateEditor;
  11. import org.springframework.stereotype.Controller;
  12. import org.springframework.web.bind.WebDataBinder;
  13. import org.springframework.web.bind.annotation.InitBinder;
  14. import org.springframework.web.bind.annotation.RequestMapping;
  15. import org.springframework.web.bind.annotation.ResponseBody;
  16. import org.springframework.web.servlet.ModelAndView;
  17. import com.zhcs.dt.controller.base.BaseController;
  18. import com.zhcs.dt.entity.Page;
  19. import com.zhcs.dt.service.information.attached.AttachedManager;
  20. import com.zhcs.dt.service.information.attachedmx.AttachedMxManager;
  21. import com.zhcs.dt.util.AppUtil;
  22. import com.zhcs.dt.util.Jurisdiction;
  23. import com.zhcs.dt.util.ObjectExcelView;
  24. import com.zhcs.dt.util.PageData;
  25. import com.zhcs.dt.util.Tools;
  26. /**
  27. * 说明:主附结构
  28. * 创建人:FH Q313596790
  29. * 创建时间:2016-04-17
  30. */
  31. @Controller
  32. @RequestMapping(value="/attached")
  33. public class AttachedController extends BaseController {
  34. String menuUrl = "attached/list.do"; //菜单地址(权限用)
  35. @Resource(name="attachedService")
  36. private AttachedManager attachedService;
  37. @Resource(name="attachedmxService")
  38. private AttachedMxManager attachedmxService;
  39. /**保存
  40. * @param
  41. * @throws Exception
  42. */
  43. @RequestMapping(value="/save")
  44. public ModelAndView save() throws Exception{
  45. logBefore(logger, Jurisdiction.getUsername()+"新增Attached");
  46. if(!Jurisdiction.buttonJurisdiction(menuUrl, "add")){return null;} //校验权限
  47. ModelAndView mv = this.getModelAndView();
  48. PageData pd = new PageData();
  49. pd = this.getPageData();
  50. pd.put("ATTACHED_ID", this.get32UUID()); //主键
  51. pd.put("CTIME", Tools.date2Str(new Date())); //创建时间
  52. attachedService.save(pd);
  53. pd = attachedService.findById(pd); //根据ID读取
  54. mv.setViewName("information/attached/attached_edit");
  55. mv.addObject("msg", "edit");
  56. mv.addObject("pd", pd);
  57. return mv;
  58. }
  59. /**删除
  60. * @param out
  61. * @throws NumberFormatException
  62. * @throws Exception
  63. */
  64. @RequestMapping(value="/delete")
  65. @ResponseBody
  66. public Object delete() throws NumberFormatException, Exception{
  67. logBefore(logger, Jurisdiction.getUsername()+"删除Attached");
  68. if(!Jurisdiction.buttonJurisdiction(menuUrl, "del")){return null;} //校验权限
  69. Map<String,String> map = new HashMap<String,String>();
  70. PageData pd = new PageData();
  71. pd = this.getPageData();
  72. String errInfo = "success";
  73. if(Integer.parseInt(attachedmxService.findCount(pd).get("zs").toString()) > 0){
  74. errInfo = "false";
  75. }else{
  76. attachedService.delete(pd);
  77. }
  78. map.put("result", errInfo);
  79. return AppUtil.returnObject(new PageData(), map);
  80. }
  81. /**修改
  82. * @param
  83. * @throws Exception
  84. */
  85. @RequestMapping(value="/edit")
  86. public ModelAndView edit() throws Exception{
  87. logBefore(logger, Jurisdiction.getUsername()+"修改Attached");
  88. if(!Jurisdiction.buttonJurisdiction(menuUrl, "edit")){return null;} //校验权限
  89. ModelAndView mv = this.getModelAndView();
  90. PageData pd = new PageData();
  91. pd = this.getPageData();
  92. attachedService.edit(pd);
  93. mv.addObject("msg","success");
  94. mv.setViewName("save_result");
  95. return mv;
  96. }
  97. /**列表
  98. * @param page
  99. * @throws Exception
  100. */
  101. @RequestMapping(value="/list")
  102. public ModelAndView list(Page page) throws Exception{
  103. logBefore(logger, Jurisdiction.getUsername()+"列表Attached");
  104. //if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;} //校验权限(无权查看时页面会有提示,如果不注释掉这句代码就无法进入列表页面,所以根据情况是否加入本句代码)
  105. ModelAndView mv = this.getModelAndView();
  106. PageData pd = new PageData();
  107. pd = this.getPageData();
  108. String keywords = pd.getString("keywords"); //关键词检索条件
  109. if(null != keywords && !"".equals(keywords)){
  110. pd.put("keywords", keywords.trim());
  111. }
  112. page.setPd(pd);
  113. List<PageData> varList = attachedService.list(page); //列出Attached列表
  114. mv.setViewName("information/attached/attached_list");
  115. mv.addObject("varList", varList);
  116. mv.addObject("pd", pd);
  117. mv.addObject("QX",Jurisdiction.getHC()); //按钮权限
  118. return mv;
  119. }
  120. /**去新增页面
  121. * @param
  122. * @throws Exception
  123. */
  124. @RequestMapping(value="/goAdd")
  125. public ModelAndView goAdd()throws Exception{
  126. ModelAndView mv = this.getModelAndView();
  127. PageData pd = new PageData();
  128. pd = this.getPageData();
  129. mv.setViewName("information/attached/attached_edit");
  130. mv.addObject("msg", "save");
  131. mv.addObject("pd", pd);
  132. return mv;
  133. }
  134. /**去修改页面
  135. * @param
  136. * @throws Exception
  137. */
  138. @RequestMapping(value="/goEdit")
  139. public ModelAndView goEdit()throws Exception{
  140. ModelAndView mv = this.getModelAndView();
  141. PageData pd = new PageData();
  142. pd = this.getPageData();
  143. pd = attachedService.findById(pd); //根据ID读取
  144. mv.setViewName("information/attached/attached_edit");
  145. mv.addObject("msg", "edit");
  146. mv.addObject("pd", pd);
  147. return mv;
  148. }
  149. /**批量删除
  150. * @param
  151. * @throws Exception
  152. */
  153. @RequestMapping(value="/deleteAll")
  154. @ResponseBody
  155. public Object deleteAll() throws Exception{
  156. logBefore(logger, Jurisdiction.getUsername()+"批量删除Attached");
  157. if(!Jurisdiction.buttonJurisdiction(menuUrl, "del")){return null;} //校验权限
  158. PageData pd = new PageData();
  159. Map<String,Object> map = new HashMap<String,Object>();
  160. pd = this.getPageData();
  161. List<PageData> pdList = new ArrayList<PageData>();
  162. String DATA_IDS = pd.getString("DATA_IDS");
  163. if(null != DATA_IDS && !"".equals(DATA_IDS)){
  164. String ArrayDATA_IDS[] = DATA_IDS.split(",");
  165. attachedService.deleteAll(ArrayDATA_IDS);
  166. pd.put("msg", "ok");
  167. }else{
  168. pd.put("msg", "no");
  169. }
  170. pdList.add(pd);
  171. map.put("list", pdList);
  172. return AppUtil.returnObject(pd, map);
  173. }
  174. /**导出到excel
  175. * @param
  176. * @throws Exception
  177. */
  178. @RequestMapping(value="/excel")
  179. public ModelAndView exportExcel() throws Exception{
  180. logBefore(logger, Jurisdiction.getUsername()+"导出Attached到excel");
  181. if(!Jurisdiction.buttonJurisdiction(menuUrl, "cha")){return null;}
  182. ModelAndView mv = new ModelAndView();
  183. PageData pd = new PageData();
  184. pd = this.getPageData();
  185. Map<String,Object> dataMap = new HashMap<String,Object>();
  186. List<String> titles = new ArrayList<String>();
  187. titles.add("名称"); //1
  188. titles.add("描述"); //2
  189. titles.add("价格"); //3
  190. titles.add("创建时间"); //4
  191. dataMap.put("titles", titles);
  192. List<PageData> varOList = attachedService.listAll(pd);
  193. List<PageData> varList = new ArrayList<PageData>();
  194. for(int i=0;i<varOList.size();i++){
  195. PageData vpd = new PageData();
  196. vpd.put("var1", varOList.get(i).getString("NAME")); //1
  197. vpd.put("var2", varOList.get(i).getString("FDESCRIBE")); //2
  198. vpd.put("var3", varOList.get(i).get("PRICE").toString()); //3
  199. vpd.put("var4", varOList.get(i).getString("CTIME")); //4
  200. varList.add(vpd);
  201. }
  202. dataMap.put("varList", varList);
  203. ObjectExcelView erv = new ObjectExcelView();
  204. mv = new ModelAndView(erv,dataMap);
  205. return mv;
  206. }
  207. @InitBinder
  208. public void initBinder(WebDataBinder binder){
  209. DateFormat format = new SimpleDateFormat("yyyy-MM-dd");
  210. binder.registerCustomEditor(Date.class, new CustomDateEditor(format,true));
  211. }
  212. }