var value = "";
var user ="";
var rtn2 ="";
var user = getItemValue("lxry");
if (user != null){
var sql = "select loginno from t_user where name='"+user+"'";
var rtn ="";
rtn = queryByDSName("sbgl",sql);
if (rtn != null) {
for(var iterator = rtn.iterator();iterator.hasNext();){
var map1 = iterator.next();
var rtn2= map1.get("loginno");
}
}
}
var userid = getUserIdByLoginno(rtn2);
var uservo=getUserById(userid);
if (uservo != null){
value = uservo.getDefaultDepartment();
var name="";
var depvo= getDepartmentById(value);
name= depvo.getName();
}
name; |