📄 modifyname.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page import="com.censoft.gongshang.util.*"%>
<%@ page import="com.censoft.gongshang.control.event.*"%>
<%@ page import="com.censoft.gongshang.component.enterprise.model.*"%>
<%@ page import="com.censoft.gongshang.component.sysadmin.model.*"%>
<%
try{
String SN=request.getParameter("SN");//事务号
String enterpriseName=request.getParameter("enterpriseName");//用户填写的企业名称
String pageAction =(String)request.getParameter("pageAction");//记录要执行的操作，如为cek则进行查重并显示查询结果
String enterpriseNameNew =(String)request.getParameter("enterpriseNameNew");//已经查重通过的名称
enterpriseNameNew = PubFunc.toSql(enterpriseNameNew);
ArrayList infoAL = new ArrayList();
if("cek".equals(pageAction)){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
conn = Common.getConnection();
stmt = conn.createStatement();
String nowDate = PubFunc.getNowDate();
String sql="select field104 from gsgsjin_basis02 where field001='"+SN+"'";
rs = stmt.executeQuery(sql);
String djjg="";
if(rs.next()){
djjg=rs.getString("field104");
}else{
Debug.println("[modifyName.jsp]--->>>书库库中查不到该企业的登记机关");
}
enterpriseName=PubFunc.toSql(enterpriseName);
//对用户给出的名称进行查重
sql="select * from( ( select ROWNUM as rsNumRow,t.* from (select gsgsjin_basis02.ROWID as rid,field002,field003,field009,field014,field022,field099,field123,field020,field004,field104,o.content bidname,r.content djjgname from gsgsjin_basis02 ,universal_operation o,gsshare_coding_registerorg r where ( field009 like '%"+enterpriseName+"%' or field014 like'%"+enterpriseName+"%') and gsgsjin_basis02.field002=o.code and gsgsjin_basis02.field104=r.coding and gsgsjin_basis02.field104='"+djjg+"' and ( gsgsjin_basis02.field123 > '"+nowDate+"' or gsgsjin_basis02.field123 is null ) order by field123) t ) )";
rs = stmt.executeQuery(sql);
while(rs.next()){
HashMap infoMap = new HashMap();
String field002 = rs.getString("field002");//业务类型
String field003 = rs.getString("field003");//内部序号
String field009 = rs.getString("field009");//企业名称
String field014 = rs.getString("field014");//企业字号
String field022 = rs.getString("field022");//行业代码
String field099 = rs.getString("field099");//核准日期
String field123 = rs.getString("field123");//有效期截至期限
String field020 = rs.getString("field020");//企业类型
String field004 = rs.getString("field004");//注册号
String field104 = rs.getString("field104");//登记机关
String BIDNAME = rs.getString("BIDNAME");//业务类型名称
String DJJGNAME = rs.getString("DJJGNAME");//登记机关名称
infoMap.put("field002",field002);
infoMap.put("field003",field003);
infoMap.put("field009",field009);
infoMap.put("field014",field014);
infoMap.put("field022",field022);
infoMap.put("field099",field099);
infoMap.put("field123",field123);
infoMap.put("field020",field020);
infoMap.put("field004",field004);
infoMap.put("field104",field104);
infoMap.put("BIDNAME",BIDNAME);
infoMap.put("DJJGNAME",DJJGNAME);
infoAL.add(infoMap);
}
if(infoAL.size()==0){
enterpriseNameNew = enterpriseName;
}
//out.print(""+infoAL.size());
}catch(Exception ex){
Debug.println("[selectDJJG.jsp]--->>>Exception:"+ex.getMessage());
}finally{
try{
Common.clearUp(rs,stmt,conn);
Debug.print("[selectDJJG.jsp]--->>>conn已关闭：" + conn);
} catch(Exception e){
Debug.print("[selectDJJG.jsp]--->>>关闭数据库连接出错");
}
} //end finally
}//end if
%>
<html>
<HEAD>
<meta content="no-cache" http-equiv="Pragma"/>
<link href="<%=request.getContextPath()%>/include/style/<%=(String)(session.getAttribute("frameworkStylePath"))%>/style.css" rel="stylesheet" type="text/css">
<SCRIPT LANGUAGE="JavaScript">
var parentObj = window.dialogArguments;//父窗口传过来的对象
//对用户输入的名称进行查重
function cek(enterpriseName){
window.returnValue="<%=request.getContextPath()%>/include/tools/modify/modifyName.jsp?pageAction=cek&enterpriseNameNew="+document.all.enterpriseNameNew.value+"&SN="+document.all.SN.value+"&enterpriseName="+document.all.enterpriseName.value;
window.close();
//window.location.href="<%=request.getContextPath()%>/include/tools/modify/modifyName.jsp?pageAction=cek&SN="+document.all.SN.value+"&enterpriseName="+enterpriseName;
}
//使用查重通过的企业名称
function dosel(enterpriseNameNew){
if(enterpriseNameNew!=null && enterpriseNameNew!=""){
parentObj.value=enterpriseNameNew;
}
window.close();
}
</script>
<base target="_self">
<link rel="stylesheet" href="calendar/scroll.css">
<link rel="stylesheet" href="calendar/ioa-1.css">
<title>更改企业名称</title>
<body class="businessBody01" scroll=auto>
<center>
<form name="search" method="post">
<input type="hidden" name="SN" value="<%=SN%>">
<br>
<table border="1" width="100%" class="businessTable00" >
<tr>
<td class="businessTd00" width="20%">请输入企业名称</td>
<td class="businessTd00Left" width="80%">
<input type="text" name="enterpriseName" value="<%=PubFunc.toShowForm(enterpriseName)%>" style="width:90%">
<input type="button" name="examine" value="查重" class="button" onclick="cek('document.all.enterpriseName.value');">
</td>
</tr>
<tr>
<td class="businessTd01">通过查重的企业名称</td>
<td class="businessTd01Left">
<input type="text" name="enterpriseNameNew" value="<%=PubFunc.toShowForm(enterpriseNameNew)%>" style="width:90%">
<input type="button" name="select" value="使用" class="button" onclick="dosel(document.all.enterpriseNameNew.value);">
</td>
</tr>
</table>
<br>
<table border="1" width="100%" class="businessTable00" >
<tr>
<td class="businessTd00" width="35%">业务类型</td>
<td class="businessTd00" width="65%">企业名称</td>
</tr>
<%if(infoAL.size()>0){
String td = "businessTd00Left";
for(int i=0;i<infoAL.size();i++){
HashMap tempHM = (HashMap)infoAL.get(i);
td=td.equals("businessTd00Left")?"businessTd01Left":"businessTd00Left";%>
<tr>
<td class="<%=td%>"><%=PubFunc.toShowForm((String)tempHM.get("BIDNAME"))%></td>
<td class="<%=td%>"><%=PubFunc.toShowForm((String)tempHM.get("field009"))%></td>
</tr>
<%}
}%>
</table>
<br>
<input type="button" name="close" value="关 闭" class="button" onclick="window.close();">
</form>
</center>
</body>
</html>
<%
}catch(Exception ex ){
//ex.printStackTrace();
Debug.println("[modifyName.jsp]--->>>Exception:"+ex.getMessage());
Debug.println("[modifyName.jsp]--->>>Exception:"+ex.getStackTrace());
}//end try%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -