package cn.ksource.web.facade.impl;
|
|
import java.util.HashMap;
|
import java.util.LinkedList;
|
import java.util.List;
|
import java.util.Map;
|
|
import javax.servlet.http.HttpServletRequest;
|
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import cn.ksource.beans.GG_XTGN;
|
import cn.ksource.core.dao.BaseDao;
|
import cn.ksource.core.dao.SqlParameter;
|
import cn.ksource.core.page.PageInfo;
|
import cn.ksource.core.util.JsonUtil;
|
import cn.ksource.core.util.StringUtil;
|
import cn.ksource.web.facade.XtgnFacade;
|
@Service("xtgnFacade")
|
public class XtgnFacadeImpl implements XtgnFacade {
|
|
@Autowired
|
public BaseDao baseDao;
|
|
@Override
|
public Map deleteXtgn(String id) {
|
String sql = "SELECT COUNT(ID) FROM GG_XTGN WHERE SJBH = :sjbh ";
|
Map param = new HashMap();
|
param.put("sjbh", id);
|
int count = baseDao.queryForInteger(sql, param);
|
|
String firstCate = new String();
|
String secondCate = new String();
|
GG_XTGN xtgn = new GG_XTGN(id).getInstanceById();
|
String sjbh = xtgn.getSjbh();
|
if(StringUtil.notEmpty(sjbh)) {
|
GG_XTGN pxtgn = new GG_XTGN(sjbh).getInstanceById();
|
int level = pxtgn.getType();
|
if(level==2) {
|
firstCate = pxtgn.getSjbh();
|
secondCate = pxtgn.getId();
|
} else {
|
firstCate = pxtgn.getId();
|
}
|
}
|
Map result = new HashMap();
|
if(count > 0){
|
result.put("msg", "存在子功能，不能删除");
|
}else{
|
xtgn.deleteById();
|
result.put("msg", "1");
|
}
|
result.put("firstCate", firstCate);
|
result.put("secondCate", secondCate);
|
return result;
|
}
|
|
@Override
|
public int queryXtgnCount(String pId) {
|
StringBuilder builder = new StringBuilder("SELECT COUNT(ID) FROM GG_XTGN WHERE 1 = 1 ");
|
Map paramMap = new HashMap();
|
if(StringUtil.notEmpty(pId)) {
|
builder.append(" AND SJBH = :pId ");
|
paramMap.put("pId", pId);
|
} else {
|
builder.append(" AND TYPE = 1 ");
|
}
|
|
int count = baseDao.queryForInteger(builder.toString(),paramMap);
|
|
return count;
|
}
|
|
@Override
|
public PageInfo queryXtgnData(PageInfo pageInfo,String pId) {
|
StringBuilder builder = new StringBuilder("SELECT * FROM GG_XTGN WHERE 1 = 1 ");
|
Map paramMap = new HashMap();
|
if(StringUtil.notEmpty(pId)) {
|
builder.append(" AND SJBH = :pId ");
|
paramMap.put("pId", pId);
|
} else {
|
builder.append(" AND TYPE = 1 ");
|
}
|
|
builder.append(" ORDER BY TYPE,SXH ");
|
|
PageInfo info = baseDao.queryforSplitPageInfo(pageInfo, builder.toString(), paramMap);
|
|
return info;
|
}
|
|
@Override
|
public List<Map> queryXtgnTree(HttpServletRequest request) {
|
Map paramMap = new HashMap();
|
String selectSubSql = "SELECT * FROM GG_XTGN ORDER BY TYPE,SXH ";
|
List<Map> cates = baseDao.queryForList(selectSubSql,paramMap);
|
Map result = new HashMap();
|
|
List<Map> resultList = new LinkedList<Map>();
|
|
Map<String, Map> yjgnCache = new HashMap<String, Map>();
|
Map<String, Map> ejgnCache = new HashMap<String, Map>();
|
Map<String, Map> sjgnCache = new HashMap<String, Map>();
|
|
for (Map map : cates) {
|
String level = map.get("TYPE").toString();
|
String id = map.get("ID").toString();
|
|
//一级树
|
if (level.equalsIgnoreCase("1")) {
|
yjgnCache.put(id, map);
|
List<Map> ejgnList = new LinkedList<Map>();
|
map.put("ejTree", ejgnList);
|
resultList.add(map);
|
continue;
|
}
|
//二级树
|
if (level.equalsIgnoreCase("2")) {
|
String pId = map.get("SJBH").toString();
|
if(yjgnCache.containsKey(pId)) {
|
Map yjgnMap = yjgnCache.get(pId);
|
List<Map> list = (List<Map>)yjgnMap.get("ejTree");
|
map.put("sjTree", new LinkedList<Map>());
|
list.add(map);
|
|
ejgnCache.put(id, map);
|
}
|
continue;
|
}
|
//三级树
|
if (level.equalsIgnoreCase("3")) {
|
if(null!=map.get("SJBH")){
|
String pId = map.get("SJBH").toString();
|
if(ejgnCache.containsKey(pId)) {
|
Map ejgnMap = ejgnCache.get(map.get("SJBH").toString());
|
List<Map> list = (List<Map>)ejgnMap.get("sjTree");
|
map.put("fjTree", new LinkedList<Map>());
|
list.add(map);
|
sjgnCache.put(id, map);
|
}
|
}
|
}
|
}
|
System.out.println(JsonUtil.list2Json(resultList));
|
return resultList;
|
}
|
|
@Override
|
public boolean isGn_markExists(String gn_mark, String sjbh) {
|
String selectsql = "select COUNT(ID) from GG_XTGN where GN_MARK=:gn_mark AND SJBH = :sjbh ";
|
int count = baseDao.queryForInteger(selectsql,
|
new SqlParameter().addValue("gn_mark", gn_mark).addValue("sjbh", sjbh));
|
if(count > 0){
|
return false;
|
}else{
|
return true;
|
}
|
}
|
|
|
|
}
|
