|
|
回复 6# purple
var rtn = "";
var date = getItemValueAsString("date");
var sql = "select t.DOMAINID, t.`NAME` as item_NAME from obpm.t_user t where t.DEFAULTDEPARTMENT = (select t.ID from obpm.t_department t where t.`NAME` = '秘书处') ORDER BY t.ID";
var innerSql = "";
var doc = queryBySQL(sql);
if(doc != null && doc.size() > 0)
{
var innerDoc;
for (var iter = doc.iterator(); iter.hasNext();)
{
var subdoc = iter.next();
var theName = subdoc.getItemValueAsString("NAME");
innerSql = "SELECT t.DOMAINID, t.FORMID, t.ITEM_REGISTER, t.ITEM_TIME, t.ITEM_GACONTENT FROM szstioa.tlk_garegister t where t.ITEM_REGISTER = '" + theName + "' and t.ITEM_DATE = '" + date + "' and t.ITEM_STATUS = '已发布'";
innerDoc = queryBySQL(innerSql);
if(innerDoc != null && innerDoc.size() > 0)
{
var theNames = "";
var theTime = "";
var theContent = "";
for (var innerIter = innerDoc.iterator(); innerIter.hasNext();)
{
var innerSubDoc = innerIter.next();
theNames = innerSubDoc.getItemValueAsString("REGISTER");
theTime = innerSubDoc.getItemValueAsString("TIME");
theContent = innerSubDoc.getItemValueAsString("GACONTENT");
if(theTime.length() == 4)
{
theTime = "0" + theTime;
}
if(theContent.length() >= 34)
{
theContent = theContent.substring(0,32) + "...";
}
rtn += "[" + theTime + "] " + "[" + theNames + "] : " + theContent + "\n";
}
}
}
rtn = rtn.substring(0, rtn.length - 2);
}
rtn; |
|