/**
* 获取自列表的列与掩码的Map
*
* @param conn
* @param PO
* @param dictMetadata
* @param DOMeta
* @throws Exception
*/
protected static java.util.Map getSelfEnumColViewMap(
JConnection conn, JParamObject PO, DictMetadata dictMetadata) throws Exception {
if (dictMetadata == null) {
return null;
}
TableMetadata tableMetadata = dictMetadata.getTableMetadata();
if (tableMetadata == null) {
return null;
}
java.util.List colList = tableMetadata.getColList();
if (colList == null) return null;
// 获取各列的掩码
java.util.Map map = new java.util.HashMap();
String objid = tableMetadata.getString("OBJ_ID", "");
Statement st = null;
ResultSet rs = null;
String sql = " select * from SYS_SELFENUM" + " where OBJ_ID='" + objid + "' order by COL_DISP";
try {
st = conn.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
String colid = rs.getString("COL_ID");
String colval = rs.getString("COL_VAL");
String colnote = rs.getString("F_NOTE");
if (colval == null || colval.length() == 0) {
colval = " ";
}
if (colnote == null || colnote.length() == 0) {
colnote = colval;
}
String view = (String) map.get(colid);
if (view == null) {
map.put(colid, colval + ":" + colnote);
} else {
if (view.endsWith(";")) {
view = view.substring(0, view.length() - 1);
}
map.put(colid, view + ";" + colval + ":" + colnote);
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
conn.BackStatement(st, rs);
}
return map;
}
