public String saveShootSetting(Map map) {
try {
Map createTableMap = new HashMap();
String flag = "";
createTableMap.put("tableName", map.get("shootTableName"));
createTableMap.put("leftFieldName", map.get("leftFieldName"));
createTableMap.put("rightFieldName", map.get("rightFieldName"));
createTableMap.put("flag", flag);
dao.queryForList("MapService.createRelationTable", createTableMap);
flag = (String) createTableMap.get("flag");
if (!flag.equals("1"))
return flag;
Map levelCodeMap = new HashMap();
String levelCode = "";
levelCodeMap.put("levelCode", levelCode);
dao.queryForList("MapService.getLevelCode", levelCodeMap);
levelCode = (String) levelCodeMap.get("levelCode");
List itemCodeList = dao.queryForList("MapService.getItemCode");
String itemCode = (String) itemCodeList.get(0);
Map tableMap = new HashMap();
tableMap.put("itemCode", itemCode);
tableMap.put("itemName", map.get("shootName"));
tableMap.put("levelCode", levelCode);
tableMap.put("tableName", map.get("shootTableName"));
dao.insert("MapService.saveShootTable", tableMap);
List itemCodeList1 = dao.queryForList("MapService.getItemCode");
String itemCode1 = (String) itemCodeList1.get(0);
Map leftFieldMap = new HashMap();
leftFieldMap.put("fieldName", map.get("leftFieldName"));
leftFieldMap.put("refTable", map.get("leftParentCode"));
leftFieldMap.put("itemCode", itemCode1);
leftFieldMap.put("itemName", map.get("leftDesName"));
leftFieldMap.put("parentCode", itemCode);
leftFieldMap.put("levelCode", levelCode + "001");
dao.insert("MapService.saveShootField", leftFieldMap);
List itemCodeList2 = dao.queryForList("MapService.getItemCode");
String itemCode2 = (String) itemCodeList2.get(0);
Map rightFieldMap = new HashMap();
rightFieldMap.put("fieldName", map.get("rightFieldName"));
rightFieldMap.put("refTable", map.get("rightParentCode"));
rightFieldMap.put("itemCode", itemCode2);
rightFieldMap.put("itemName", map.get("rightDesName"));
rightFieldMap.put("parentCode", itemCode);
rightFieldMap.put("levelCode", levelCode + "002");
dao.insert("MapService.saveShootField", rightFieldMap);
Map relationMap = new HashMap();
relationMap.put("itemCode", itemCode);
relationMap.put("mainField", itemCode1);
relationMap.put("selectField", itemCode2);
relationMap.put("productCode", map.get("productCode"));
dao.insert("MapService.saveShootRelation", relationMap);
return "1";
} catch (SQLException e) {
log.error(e);
throw new RuntimeException(e);
}
}
---------------------------------------------------------------------------------------------------
parameterMap id="deleteShootMap" class="java.util.HashMap">
/parameterMap>
procedure id="deleteShootSetting" parameterMap="deleteShootMap">
{call sp_pd_base_deleteshoot(?)}
/procedure>
parameterMap id="levelCodeMap" class="java.util.HashMap">
/parameterMap>
procedure id="getLevelCode" parameterMap="levelCodeMap">
{call sp_get_max(?)}
/procedure>
parameterMap id="createTableMap" class="java.util.HashMap">
/parameterMap>
procedure id="createRelationTable" parameterMap="createTableMap">
{call sp_pd_base_shootsetting(?,?,?,?)}
/procedure>