package com.yc.action.new38action;
|
|
import java.io.IOException;
|
import java.io.PrintWriter;
|
import java.util.List;
|
|
import javax.servlet.http.HttpServletRequest;
|
import javax.servlet.http.HttpServletResponse;
|
import javax.servlet.http.HttpSession;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Controller;
|
import org.springframework.web.bind.annotation.RequestMapping;
|
|
import java.util.Map;
|
|
import com.google.gson.Gson;
|
import com.yc.entity.Json38;
|
import com.yc.multiData.SpObserver;
|
import com.yc.service.new38type.Type38Ifc;
|
import com.yc.utils.SessionKey;
|
|
@Controller
|
@SuppressWarnings("all")
|
public class Type38action extends com.yc.action.BaseAction {
|
@Autowired
|
Type38Ifc type38service;
|
String formid = "";
|
|
@RequestMapping("/gridsave.do")
|
public void gridsave(HttpServletRequest request,
|
HttpServletResponse response) throws IOException {
|
HttpSession session = request.getSession();
|
|
|
|
String dat1 = request.getParameter("content").replace("\\", "");
|
// System.out.println(dat1);
|
String saisid = request.getParameter("saisid");
|
String formid = request.getParameter("formid");
|
//
|
Gson gson = new Gson();
|
Json38 gt = gson.fromJson(dat1,
|
new com.google.gson.reflect.TypeToken<Json38>() {
|
}.getType());
|
String usercode = (session.getAttribute(SessionKey.HRCODE) == null ? ""
|
: (String) session.getAttribute(SessionKey.HRCODE));
|
try {
|
SpObserver.setDBtoInstance("_"
|
+ request.getSession()
|
.getAttribute(SessionKey.DATA_BASE_ID));
|
type38service.updatePanelDatas(gt, saisid, formid, usercode);
|
this.printJson(response, "{\"code\":\"" + formid
|
+ "\",\"info\":\"" + saisid + "\"}");
|
} catch (Exception e) {
|
// TODO: handle exception
|
this.printJson(response, "{\"code\":\"" + e.getMessage()
|
+ "\",\"info\":\"" + saisid + "\"}");
|
} finally {
|
SpObserver.setDBtoInstance();
|
}
|
|
}
|
|
/*
|
* 数据设置的数据处理
|
*/
|
@RequestMapping("/gridsave1.do")
|
public void gridsave1(HttpServletRequest request,
|
HttpServletResponse response) throws IOException {
|
|
String dat1 = request.getParameter("content").replace("\\", "");
|
// System.out.println(dat1);
|
String saisid = request.getParameter("saisid");
|
String formid = request.getParameter("formid");
|
Gson gson = new Gson();
|
Json38 gt = gson.fromJson(dat1,
|
new com.google.gson.reflect.TypeToken<Json38>() {
|
}.getType());
|
|
try {
|
SpObserver.setDBtoInstance("_"
|
+ request.getSession()
|
.getAttribute(SessionKey.DATA_BASE_ID));
|
type38service.PanelDatas(gt, saisid, formid);
|
this.printJson(response, "{\"code\":\"" + formid
|
+ "\",\"info\":\"" + saisid + "\"}");
|
} catch (Exception e) {
|
// TODO: handle exception
|
this.printJson(response, "{\"code\":\"" + e.getMessage()
|
+ "\",\"info\":\"" + saisid + "\"}");
|
}
|
finally {
|
SpObserver.setDBtoInstance();
|
}
|
|
}
|
|
/*
|
*
|
* 判断是否是私有的
|
*/
|
@RequestMapping("/contrast.do")
|
public void contrast(HttpServletRequest request,
|
HttpServletResponse response, String saisid, String formid)
|
throws IOException {
|
List<Map<String, Object>> list=null;
|
String sql = "select usercode from _sysStatis where statisid="
|
+ "'" + saisid + "'" + " and formid=" + formid + "";
|
try {
|
SpObserver.setDBtoInstance("_"
|
+ request.getSession()
|
.getAttribute(SessionKey.DATA_BASE_ID));
|
|
list = type38service.selectzdy(sql);
|
} finally {
|
SpObserver.setDBtoInstance();
|
}
|
Map<String, Object> map = null;
|
String usercodes = "";
|
for (int i = 0; i < list.size(); i++) {
|
map = list.get(i);
|
usercodes = (String) map.get("usercode") == null ? ""
|
: (String) map.get("usercode");
|
|
}
|
if (usercodes.equals("") || usercodes == null) {
|
this.printJson(response,
|
"{\"code\":\"success\",\"info\":\"success\"}");
|
} else {
|
this.printJson(response,
|
"{\"code\":\"error\",\"info\":\"success\"}");
|
}
|
|
|
}
|
|
/*
|
*
|
* 判断是否存在相同的名字
|
*/
|
@RequestMapping("/statiscontrast.do")
|
public void statiscontrast(HttpServletRequest request,
|
HttpServletResponse response, String saisid, String formid)
|
throws IOException {
|
List<Map<String, Object>> list=null;
|
String sql = "select usercode from _sysStatis where statisid="
|
+ "'" + saisid + "'" + " and formid=" + formid + "";
|
try {
|
SpObserver.setDBtoInstance("_"
|
+ request.getSession()
|
.getAttribute(SessionKey.DATA_BASE_ID));
|
|
list = type38service.selectzdy(sql);
|
} finally {
|
SpObserver.setDBtoInstance();
|
}
|
if (list.size() != 0) {
|
this.printJson(response,
|
"{\"code\":\"error\",\"info\":\"error\"}");
|
} else {
|
this.printJson(response,
|
"{\"code\":\"success\",\"info\":\"success\"}");
|
}
|
|
|
}
|
|
/*
|
*
|
* 执行删除操作
|
*/
|
@RequestMapping("/datadelete.do")
|
public void datadelete(HttpServletRequest request,
|
HttpServletResponse response, String saisid, String formid)
|
throws IOException {
|
|
|
String sql = "delete from _sysStatisDetail where formid=" + formid
|
+ " and StatisID=" + "'" + saisid + "'" + " ";
|
sql = sql + " " + "delete from _sysStatis where formid=" + formid
|
+ " and StatisID=" + "'" + saisid + "'" + " ";
|
try {
|
SpObserver.setDBtoInstance("_"
|
+ request.getSession()
|
.getAttribute(SessionKey.DATA_BASE_ID));
|
type38service.delPanelData(sql);
|
this.printJson(response,
|
"{\"code\":\"success\",\"info\":\"success\"}");
|
} catch (Exception e) {
|
// TODO: handle exception
|
e.printStackTrace();
|
|
this.printJson(response, "{\"code\":\"error\",\"info\":\""
|
+ e.getMessage().toString() + "\"}");
|
} finally {
|
SpObserver.setDBtoInstance();
|
}
|
|
}
|
public List<Map<String, Object>> get38TypeInfo(HttpServletRequest request,
|
HttpServletResponse response, int formId){
|
|
HttpSession session = request.getSession();
|
List<Map<String, Object>> list=null;
|
try {
|
SpObserver.setDBtoInstance("_"
|
+ request.getSession()
|
.getAttribute(SessionKey.DATA_BASE_ID));
|
String usercode = (session.getAttribute(SessionKey.HRCODE) == null ? ""
|
: (String) session.getAttribute(SessionKey.HRCODE));
|
String isSuperUser = (String) session.getAttribute(SessionKey.SUPPER_USER);
|
String statisIds=null;
|
Map<String,Object> perssionMap =((Map<String,Map<String,Object>>)session.getAttribute(SessionKey.PERSSION)).get(formId+"");
|
if(perssionMap!=null&&!"1".equals(isSuperUser)){
|
//不是管理员才需要增加权限设置
|
statisIds= (String) perssionMap.get("statisIds");//38类型汇总项权限
|
}
|
list = type38service.selecttype(formId,
|
usercode,statisIds);
|
return list;
|
} finally {
|
SpObserver.setDBtoInstance();
|
}
|
}
|
@RequestMapping("/getType38.do")
|
public void getType38(HttpServletRequest request,
|
HttpServletResponse response, int formId) throws Exception {
|
Gson gson = new Gson();
|
String data = gson.toJson(get38TypeInfo(request,response,formId));
|
StringBuilder sb = new StringBuilder();
|
sb.append(data);
|
this.printJson(response, sb.toString());
|
|
}
|
|
private String getEndTd(String tdSel, int colNo, int tiI,
|
StringBuffer sbFieldset, StringBuffer sBuffer) {
|
if (tiI < 5 && tiI > 0) {
|
tdSel += "<td colspan=\"" + (colNo - tiI) + "\"> </td>";
|
}
|
if (sbFieldset.length() > 0) {
|
if (tdSel.trim().length() > 0) {
|
sbFieldset.append("<table><tr>").append(tdSel)
|
.append("</tr></table>");
|
}
|
sbFieldset.append("</fieldset></td>");
|
tdSel = "";
|
}
|
if (tdSel.toCharArray().length > 0) {// 未分组显示的情况
|
sbFieldset.append(tdSel);
|
}
|
try {
|
tdSel = getTr38(sBuffer, sbFieldset.toString());
|
} catch (Exception e) {
|
e.printStackTrace();
|
}
|
return tdSel;
|
}
|
|
private String getTr38(StringBuffer sBuffer, String tdSel) throws Exception {
|
sBuffer.append("\r\n<tr>");
|
sBuffer.append(tdSel);
|
sBuffer.append("\r\n</tr>");
|
return "";
|
}
|
|
@RequestMapping("/aaa.do")
|
public void aaa(HttpServletRequest request, HttpServletResponse response,
|
String id) throws IOException {
|
formid = id;
|
}
|
|
public void printText(HttpServletResponse response, String str)
|
throws IOException {
|
response.setCharacterEncoding("utf-8");
|
PrintWriter out = response.getWriter();
|
out.write(str);
|
out.flush();
|
out.close();
|
}
|
}
|