/**
* 获得公司的分部
*
* @param con
* @param company_code
* @return
* @throws SQLException
*/
private static java.util.List<JUnit> getChildBranch(Connection con, String company_code)
throws SQLException {
java.util.List<JUnit> lsBranch = new java.util.ArrayList<JUnit>();
java.sql.PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
sql =
"select unit_id from t_unit "
+ " where (parent_code =? or parent_code =?) and is_branch = 1 "
+ " order by unit_index ";
pstmt = con.prepareStatement(sql);
pstmt.setString(1, company_code);
pstmt.setString(2, company_code + ".LX");
rs = pstmt.executeQuery();
while (rs.next()) {
JUnit uObj = JUnit.getUnit(rs.getString("unit_id"));
lsBranch.add(uObj);
}
/*
if(lsBranch.size() == 0)
{
lsBranch.add(JUnit.getUnitByCode(company_code));
}*/
rs.close();
pstmt.close();
return lsBranch;
}
public JCompany getCompanyById(String com_id) {
if (com_id == null || com_id.length() == 0) return null;
if (JUnit.getUnit(com_id) == null) {
Exception e = new Exception("部门没找到 com_id=" + com_id);
JLog.getLogger().error("", e);
return null;
}
String code = JUnit.getUnit(com_id).getUnit_code();
if (mapCompany.get(code) == null) {
try {
loadCompany(code);
} catch (Exception e) {
JLog.getLogger().error("", e);
}
}
return mapCompany.get(code);
}