📄 affairacceptimpl.java
字号:
if(ExtString.isEmpty(sResult)) {
sResult = getStateLogDsec(sCityCode,sStateCode);
}
/* TODO 将状态设置转成配置。
BufferCache bc = new BufferCache("ACCEPT_REPORT_STATE", sIndexCode);
if ( bc.exists() ) {
Map sm = (Map)bc.get();
if ( sm != null ) sResult = (String)sm.get(sStateCode);
}
else {
// 程控状态
Map funState = new HashMap();
funState.put("1", "待处理");
funState.put("2", "处理中");
funState.put("3", "处理结束");
funState.put("4", "处理失败");
// 受理状态
Map orderState = new HashMap();
orderState.put("1", "待处理");
orderState.put("2", "转派");
orderState.put("3", "暂存");
orderState.put("4", "回退");
orderState.put("8", "作废");
orderState.put("9", "完成");
String funStateCode = "{005002001},{006001001},{006001002},{006001003}";
if ( funStateCode.indexOf("{" + sIndexCode + "}") != -1 ) {
bc.put(funState);
}
else {
bc.put(orderState);
}
}
*/
return ExtString.isEmpty(sResult)?"其它":sResult;
}
private String getStateLogDsec(String sCityCode,String sParavalue) {
String sState = "";
try {
DacClient db = new DacClient();
StringBuffer sql = new StringBuffer();
List oParam = new ArrayList();
sql.append("select t3.paradesc from ts_configsub t3 where t3.paraname = 'FunFailureStateLogDsec' ");
sql.append("and t3.citycode = ?");
oParam.add(sCityCode);
sql.append("and t3.paravalue = ?");
oParam.add(sParavalue);
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
DataTable dt = db.executeQuery(sql.toString(), ap);
if(dt != null && dt.getRows().getCount() > 0) {
sState = dt.getRow(0).getString("paradesc");
}
}catch (Exception e){
FileLogger.getLogger().warn(e.getMessage(), e);
}
return ExtString.isEmpty(sState)?"其它":sState;
}
public String getSum(ServletRequest request, ServletResponse response, Map _map) {
String sum = String.valueOf(getLogCount(_map));
return sum;
}
/**
* Modify By janage 获取日志记录数。
*
* @param _map
* @return
*/
protected int getLogCount(Map _map) {
DacClient db = new DacClient();
try {
StringBuffer sql = new StringBuffer();
List oParam = new ArrayList();
buildSelectSQL(_map, sql, oParam);
StringBuffer _sb = new StringBuffer();
_sb.append("select count(1) cnt from (");
_sb.append(sql);
_sb.append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
String tmp = db.getStringFromSqlQuery(_sb.toString(), ap);
return Integer.parseInt(tmp);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return -1;
}
protected int getRptListCount(Map _map) {
DacClient db = new DacClient();
try {
List oParam = new ArrayList();
StringBuffer _sb = new StringBuffer();
_sb.append("SELECT count(1) FROM(");
StringBuffer sql = new StringBuffer();
buildSQL(_map, sql, oParam);
_sb.append(sql);
_sb.append(")");
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
String str = db.getStringFromSqlQuery(_sb.toString(), ap);
return Integer.parseInt(str);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return -1;
}
public String genHtml(Map _map) {
DataTable dt = getRptList(_map);
StringBuffer _sb = new StringBuffer();
String sLevel = (String) _map.get("LEVEL");
String sIndexCode = (String) _map.get("INDEXCODE");
String sCityCode = (String)_map.get("CITYCODE");
int iLevel = 1;
if(! ExtString.isEmpty(sLevel)) iLevel = Integer.parseInt(sLevel);
if(iLevel<5) sLevel = String.valueOf(iLevel);
if ( dt != null && dt.getRows().getCount() > 0 ) {
_sb.append("<table>");
try {
com.doone.data.DataColumnCollection dcs = dt.getColumns();
String column_3Name = dcs.getDataColumn(3).getColumnName();
int colcount = dcs.getCount();
_sb.append("<tr>");
if ( !column_3Name.equals("ACCEPTSTATE") ) {
// 普通内容。
if ( dcs.getDataColumn(0).getColumnName().equalsIgnoreCase("CITYCODE") ) {
_sb.append("<td width=\"10%\" class=\"body_td\" align=\"center\" nowrap><b>地区</b></td>");
}
else {
_sb.append("<td width=\"10%\" class=\"body_td\" align=\"center\" nowrap><b>区域</b></td>");
}
_sb.append("<td width=\"60%\" class=\"body_td\" align=\"center\" nowrap><b>名称</b></td>");
_sb.append("<td width=\"10%\" class=\"body_td\" align=\"center\" nowrap><b>受理量</b></td>");
_sb.append("<td width=\"10%\" class=\"body_td\" align=\"center\" nowrap><b>占比率</b></td>");
}
else {
// 最未级内容。
if ( dcs.getDataColumn(0).getColumnName().equalsIgnoreCase("CITYCODE") ) {
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>地区</b></td>");
}
else {
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>区域</b></td>");
}
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>名称</b></td>");
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>状态</b></td>");
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>受理量</b></td>");
_sb.append("<td class=\"body_td\" align=\"center\" nowrap><b>占比率</b></td>");
}
_sb.append("</tr>");
for(int iresult=0;iresult<dt.getRows().getCount(); iresult++){
_sb.append("<tr height=\"20\" >");
DataRow drresult = dt.getRow(iresult);
if ( !column_3Name.equals("ACCEPTSTATE") ) {
// 普通内容，地区或区域。
String sPurCode = drresult.getString(2);
String sTitle = drresult.getString(3);
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append("<input type=\"hidden\" name=\"");
_sb.append(dcs.getDataColumn(0).getColumnName());
_sb.append("\" value=\"").append(drresult.getString(0)).append("\"/>");
_sb.append(drresult.getString(1));
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append("<input type=\"hidden\" name=\"");
_sb.append(dcs.getDataColumn(2).getColumnName());
_sb.append("\" value=\"").append(sPurCode).append("\"/>");
if(sPurCode != null && (sPurCode.equals("005002001") || sPurCode.equals("005002002"))) {
_sb.append(ExtString.isEmpty(sTitle)?" ":sTitle);
}
else {
_sb.append("<a href='javascript:' onclick=\"fnChildClick('"+sPurCode+"','"+sLevel+"','"+sTitle+"','"+drresult.getString(0)+"')\">");
_sb.append(ExtString.isEmpty(sTitle)?" ":sTitle);
_sb.append("</a>");
}
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"right\" nowrap>");
_sb.append(drresult.getString(4));
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"right\" nowrap>");
String bl = drresult.getString(5);
if ( bl.startsWith(".")) bl = "0" + bl;
_sb.append(bl);
_sb.append("</td>");
}
else {
// 最未级内容。
String sTitle = drresult.getString(2);
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append("<input type=\"hidden\" name=\"");
_sb.append(dcs.getDataColumn(0).getColumnName());
_sb.append("\" value=\"").append(drresult.getString(0)).append("\"/>");
_sb.append(drresult.getString(1));
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
//_sb.append("<input type=\"hidden\" name=\"");
//_sb.append(dcs.getDataColumn(2).getColumnName());
//_sb.append("\" value=\"").append(drresult.getString(2)).append("\"/>");
_sb.append(ExtString.isEmpty(sTitle)?" ":sTitle);
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"left\" nowrap>");
_sb.append(getStateName(sCityCode,sIndexCode, drresult.getString(3)));
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"right\" nowrap>");
_sb.append(drresult.getString(4));
_sb.append("</td>");
_sb.append("<td class=\"body_td\" align=\"right\" nowrap>");
String bl = drresult.getString(5);
if ( bl.startsWith(".")) bl = "0" + bl;
_sb.append(bl);
_sb.append("</td>");
}
_sb.append("</tr>");
}
} catch (Exception e) {
FileLogger.getLogger().info(e.getMessage(),e);
}
_sb.append("</table>");
}else{
_sb.append("<table>");
_sb.append("<tr>");
_sb.append("<TD>");
_sb.append("没有任何记录信息");
_sb.append("</TD>");
_sb.append("</tr>");
_sb.append("</table>");
}
return _sb.toString();
}
public DataTable getAllRptList(Map _map) {
DacClient db = new DacClient();
try {
List oParam = new ArrayList();
StringBuffer sql = new StringBuffer();
buildSQL(_map, sql, oParam);
Object ap[] = new Object[oParam.size()];
for (int i = 0; i < ap.length; i++) {
ap[i] = oParam.get(i);
}
return db.executeQuery(sql.toString(), ap);
} catch (Exception e) {
FileLogger.getLogger().warn(e.getMessage(), e);
}
return null;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -