📄 querydaoimpl.java
字号:
if("02".equals(strTemp)){
querySuperResultModel.setCorporationState("登记");
} else
if("03".equals(strTemp)){
querySuperResultModel.setCorporationState("变更");
} else
if("04".equals(strTemp)){
querySuperResultModel.setCorporationState("备案");
} else
if("05".equals(strTemp)){
querySuperResultModel.setCorporationState("改制");
} else
if("06".equals(strTemp)){
querySuperResultModel.setCorporationState("迁入迁出");
} else
if("07".equals(strTemp)){
querySuperResultModel.setCorporationState("年检");
} else
if("08".equals(strTemp)){
querySuperResultModel.setCorporationState("注销");
} else
if("09".equals(strTemp)){
querySuperResultModel.setCorporationState("吊销");
}
} else{
querySuperResultModel.setCorporationState("");
}
*/
//////////////////////////////////////////////////////////////////////////////////////
if(strTemp != null && "01".equals(strTemp.substring(0,2))){
querySuperResultModel.setCorporationState("名称");
} else
if(strTemp != null && "07".equals(strTemp.substring(0,2))){
querySuperResultModel.setCorporationState("年检");
} else if(strTemp != null && strTemp2 != null && "02".equals(strTemp.substring(0,2))){
if("1".equals(strTemp2)){
querySuperResultModel.setCorporationState("登记");
} else
if("2".equals(strTemp2)){
querySuperResultModel.setCorporationState("注销");
} else
if("3".equals(strTemp2)){
querySuperResultModel.setCorporationState("吊销");
} else
if("4".equals(strTemp2)){
querySuperResultModel.setCorporationState("迁入");
} else
if("5".equals(strTemp2)){
querySuperResultModel.setCorporationState("迁出");
}
} else{
querySuperResultModel.setCorporationState("");
}
querySuperResultModel.setPrincipal(PubFunc.decodeGB(rs.getString("field019")));
querySuperResultModel.setPhonenumber(PubFunc.decodeGB(rs.getString("field038")));
querySuperResultModel.setPostalcode(PubFunc.decodeGB(rs.getString("field037")));
querySuperResultModel.setAbode(PubFunc.decodeGB(rs.getString("field033")));
querySuperResultModel.setWorkArea(PubFunc.decodeGB(rs.getString("field067")));
querySuperResultModel.setPracticeDate(PubFunc.decodeGB(rs.getString("field096")));
querySuperResultModel.setPunishID("");
querySuperResultModel.setLogoutRevokeDate(PubFunc.decodeGB(rs.getString("field110")));
queryResultList.add(querySuperResultModel);
Debug.println("[QueryDAOImpl]getUnPassYearCheckup--->>>i:" + i);
}
Debug.println("[QueryDAOImpl]getUnPassYearCheckup--->>>end!");
} catch(SQLException sqle){
Debug.println("[QueryDAOImpl]getUnPassYearCheckup--->>>Exception:" +
sqle.getMessage());
}
finally{
try{
this.closePreparedStatement();
} catch(Exception e){
}
try{
this.closeResultSet();
} catch(Exception e){
}
try{
this.closeStatement();
} catch(Exception e){
}
try{
this.closeConnection();
} catch(Exception e){
}
}
Debug.println("[QueryDAOImpl]getUnPassYearCheckup--->>>queryResultList.size():" + queryResultList.size());
return queryResultList;
}
/**
* 获得查询结果计算总数
* 应用: 未年检企业(未通过) 查询basisc02
*/
public String getUnPassYearCheckupCount(String tempSql) throws
AppException{
boolean flag = false;
String sql = null;
ArrayList queryResultList = new ArrayList();
QuerySuperResultModel querySuperResultModel = null;
int pageCount = 0;
String strTemp;
String superQueryCount = "0";
try{
conn = Common.getConnection();
stmt = conn.createStatement();
//是否正常数据
if(tempSql == null){
Debug.println(
"[QueryDAOImpl]getUnPassYearCheckupCount----->tempSql is null!");
return superQueryCount;
}
/*
field001 sn
field002 bid
field003 内部序号
field004 注册号
field009 企业名称
field020 企业类型
field033 住址
field019 负责人
field038 联系电话
field105 管辖单位
field104 登记机关
field099 核准日期
field037 邮政编码
field067 经营范围
field096 成立日期
处罚文号
field110 吊销,注销时间
GSGSJIN_BASIS02 WHERE 1=1
)
a,
(SELECT * FROM IN_YEARVALI
WHERE field104='370000' AND field105='370000' AND field002 LIKE '07%'
AND field007='2002' AND field020 >= '1000' AND field020 <= '4420' AND field155='9002'
) b
WHERE a.field003=b.field003(+) AND b.field007 IS NULL
) where rownumcode>=1 and rownumcode<=10
*/
sql = "SELECT count(*) as sumnum FROM (SELECT ROWNUM AS rownumcode,a.* FROM (SELECT * FROM "
+ TableNameUtil.GSGSJIN_BASIS02
+ " where 1=1 ";
sql += tempSql;
Debug.println("[QueryDAOImpl]getUnPassYearCheckupCount--->>>sql:" + sql);
rs = stmt.executeQuery(sql);
if(rs.next()){
superQueryCount = rs.getString(1);
}
} catch(SQLException sqle){
Debug.println("[QueryDAOImpl]getUnPassYearCheckupCount--->>>Exception:" +
sqle.getMessage());
}
finally{
try{
this.closePreparedStatement();
} catch(Exception e){
}
try{
this.closeResultSet();
} catch(Exception e){
}
try{
this.closeStatement();
} catch(Exception e){
}
try{
this.closeConnection();
} catch(Exception e){
}
}
Debug.println("[QueryDAOImpl]getUnPassYearCheckupCount--->>>queryResultList.size():" + queryResultList.size());
return superQueryCount;
}
/**
* 获得查询结果记录集合总数
* 应用: 超级查询 查询basisc02
*/
public String getSuperQueryCount(String tempSql) throws
AppException{
boolean flag = false;
String sql = null;
String superQueryCount = "0";
QuerySuperResultModel querySuperResultModel = null;
try{
conn = Common.getConnection();
stmt = conn.createStatement();
//是否正常数据
if(tempSql == null){
Debug.println(
"[QueryDAOImpl]getSuperQueryCount----->tempSql is null!");
return superQueryCount;
}
sql = "select count(*) from (SELECT resultTable.field004,resultTable.field160,resultTable.field023,resultTable.field110,resultTable.field096,resultTable.field067,resultTable.field033,resultTable.field037,resultTable.field038,resultTable.field019,resultTable.field002,resultTable.field020,resultTable.field009,resultTable.field003,resultTable.field001,resultTable.field104,resultTable.field105,resultTable.field155,resultTable.field161,resultTable.content,resultTable.ztfl,resultTable.changeflag FROM (select field004,field006,field023,field110,field096,field067,field033,field037,field038,field019,field002,field020,field009,field003,field001,field104,field105,field155,field099,field160,field016,FIELD050,To_Number(decode((field049),null,0,field049)) as field049,field161,FIELD134,FIELD014,FIELD097,FIELD011,FIELD022,FIELD021,FIELD073,b.content,DECODE((SELECT COUNT(*) FROM in_change WHERE field003=a.field003),0,'0') AS changeflag,d.nr as ztfl from "
+ TableNameUtil.GSGSJIN_BASIS02
+ " a,"
+ TableNameUtil.GSGSJOUT_CODING_ECONOMY
+ " b,a_bm_ztfl d where a.field020 = b.coding(+) and a.field023=d.bm(+)) resultTable" //yuxiaogang20040401修改：去掉了限制条件a.field023 is not null and
+ " where 1=1 ";
sql += tempSql;
sql += ") ";
Debug.println("[QueryDAOImpl]getSuperQueryCount--->>>sql:" + sql);
rs = stmt.executeQuery(sql);
if(rs.next()){
superQueryCount = rs.getString(1);
}
} catch(SQLException sqle){
Debug.println("[QueryDAOImpl]getSuperQueryCount--->>>Exception:" +
sqle.getMessage());
}
finally{
try{
this.closePreparedStatement();
} catch(Exception e){
}
try{
this.closeResultSet();
} catch(Exception e){
}
try{
this.closeStatement();
} catch(Exception e){
}
try{
this.closeConnection();
} catch(Exception e){
}
}
Debug.println("[QueryDAOImpl]getSuperQueryCount--->>>superQueryCount:" + superQueryCount);
return superQueryCount;
}
/**
* 获得表达式查询结果记录集合总数
* 应用:
*/
public String getSuperBiaodashiQueryCount(String tempSql,String basisorsub) throws
AppException{
boolean flag = false;
String sql = null;
String superQueryCount = "0";
QuerySuperResultModel querySuperResultModel = null;
try{
conn = Common.getConnection();
stmt = conn.createStatement();
//是否正常数据
if(tempSql == null){
Debug.println(
"[QueryDAOImpl]getSuperBiaodashiQueryCount----->tempSql is null!");
return superQueryCount;
}
if("basis".equals(basisorsub)){
sql = "select count(*) from (SELECT resultTable.field004,resultTable.field160,resultTable.field023,resultTable.field110,resultTable.field096,resultTable.field067,resultTable.field033,resultTable.field037,resultTable.field038,resultTable.field019,resultTable.field002,resultTable.field020,resultTable.field009,resultTable.field003,resultTable.field001,resultTable.field104,resultTable.field105,resultTable.field155,resultTable.field161,resultTable.content,resultTable.ztfl,resultTable.changeflag FROM (select field004,field006,field023,field110,field096,field067,field033,field037,field038,field019,field002,field020,field009,field003,field001,field104,field105,field155,field099,field160,field016,FIELD050,To_Number(decode((field049),null,0,field049)) as field049,To_Number(decode((field192),null,0,field192)) as field192,field161,FIELD134,FIELD014,FIELD097,FIELD011,FIELD022,FIELD021,FIELD073,b.content,DECODE((SELECT COUNT(*) FROM in_change WHERE field003=a.field003),0,'0') AS changeflag,d.nr as ztfl from "
+ TableNameUtil.GSGSJIN_BASIS02
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -