📄 cpjgdz.jsp
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<%
/*************************************************************
*调用时需要参数isFirst=1
*************************************************************/
%>
<%
response.setHeader("Cache-Control","no-store");
response.setHeader("Pragma","no-cache");
response.setDateHeader("Expires",0);
%>
<%@page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="DbBean" class="publib.OperDbBean" scope="page"></jsp:useBean>
<%
if((session.getValueNames()).length==0)
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/sysmang/loginagain.html';");
out.println("</SCRIPT>");
return;
}
try {
java.lang.String sql="";
java.sql.ResultSet rs=null;
java.sql.ResultSet rs_cp=null;
java.sql.ResultSet rs_jgzl=null;
java.lang.String selectedJgbm="";
java.lang.String baseJgbm="";
int checknum=0;
int i=0;//计数器
java.lang.String czydm=(( java.lang.String)session.getValue("czydm")).trim();
java.lang.String isFirst=(( java.lang.String)request.getParameter("isFirst")).trim();
java.lang.String strJgbm="";
java.lang.String strCpbm="";
java.lang.String strNbjgbm="";
java.lang.String strCpDownList="";
java.lang.String strJgzlDownList="";
java.lang.String dm="";
java.lang.String mc="";
java.lang.String resulttable="";
java.lang.String delResulttable="";
java.lang.String czyJgbm="";
java.lang.String isTop="1";
sql="SELECT DBO.CZYZD.JGBM AS JGBM FROM DBO.CZYZD WHERE DBO.CZYZD.CZYBM='"+czydm+"'";
rs=DbBean.sqlQuery(sql);
i=0;
while(rs.next())
{
i++;
czyJgbm=(rs.getString("JGBM")).trim();
}
rs.close();//释放资源
rs=null;
if(i!=1)
{
java.sql.SQLException exception = new java.sql.SQLException("请与系统维护员联系，您现在不属于任何机构或属于多个机构，所以您在本系统中没有任何权限！");
throw exception;
}
if(isFirst.equals("1"))
{
baseJgbm=czyJgbm;
selectedJgbm=czyJgbm;
}
else if(isFirst.equals("0"))
{
baseJgbm=(( java.lang.String)request.getParameter("baseJgbm")).trim();
selectedJgbm=(( java.lang.String)request.getParameter("jgbmlist")).trim();
}
else if(isFirst.equals("2"))
{
selectedJgbm=(( java.lang.String)request.getParameter("jgbmlist")).trim();
if(czyJgbm.equals(selectedJgbm))
{
baseJgbm=czyJgbm;
selectedJgbm=czyJgbm;
}
else
{
i=0;
sql="SELECT DBO.JGZD.SJJGBM AS SJJGBM FROM DBO.JGZD WHERE DBO.JGZD.JGBM='"+selectedJgbm+"'";
rs=DbBean.sqlQuery(sql);
while(rs.next())
{
i++;
baseJgbm=(rs.getString("SJJGBM")).trim();
selectedJgbm=baseJgbm;
}
rs.close();//释放资源
rs=null;
if(i!=1)
{
java.sql.SQLException exception = new java.sql.SQLException("当前机构已经没有上级机构了！");
throw exception;
}
}
}
if(baseJgbm.equals(czyJgbm)) isTop="1";
else isTop="0";
i=0;//计数器复位，以备后用
//下面查询出所选机构的所有操作员信息
sql="SELECT DBO.NBZYJG.CPBM AS CPBM, DBO.NBZYJG.NBJGBM AS NBJGBM FROM DBO.NBZYJG WHERE DBO.NBZYJG.JGBM='"+selectedJgbm+"'";
rs=DbBean.sqlQuery(sql);
//查询产品字典
sql="SELECT DBO.CPZD.CPBM AS DM, DBO.CPZD.CPMC AS MC FROM DBO.CPZD";
rs_cp=DbBean.sqlQuery(sql);
//查询价格种类字典
sql="SELECT DBO.JGZLZD.NBJGBM AS DM, DBO.JGZLZD.JG AS MC FROM DBO.JGZLZD WHERE (JGBM='"+selectedJgbm+"')";
rs_jgzl=DbBean.sqlQuery(sql);
while(rs.next())
{
checknum++;
resulttable+="<TR>";
delResulttable+="<TR>";
strCpbm=((java.lang.String)(rs.getString("CPBM"))).trim();
strNbjgbm=((java.lang.String)(rs.getString("NBJGBM"))).trim();
strCpDownList="";
if(rs_cp.first())
{
do
{
dm = rs_cp.getString("DM").trim();
mc = rs_cp.getString("MC").trim();
if(dm.equals(strCpbm)) strCpDownList = strCpDownList+"<option value='"+dm+"' selected>"+mc+"</option>";
else strCpDownList = strCpDownList+"<option value='"+dm+"'>"+mc+"</option>";
} while(rs_cp.next());
}
strJgzlDownList="";
if(rs_jgzl.first())
{
do
{
dm = rs_jgzl.getString("DM").trim();
mc = rs_jgzl.getString("MC").trim();
if(dm.equals(strNbjgbm)) strJgzlDownList = strJgzlDownList+"<option value='"+dm+"' selected>"+mc+"</option>";
else strJgzlDownList = strJgzlDownList+"<option value='"+dm+"'>"+mc+"</option>";
} while(rs_jgzl.next());
}
resulttable+="<TD><INPUT type='hidden' name='OCCPBM' value='"+strCpbm+"'>";
resulttable+="<SELECT name='OCPBM'>"+strCpDownList+"</SELECT></TD>";
resulttable+="<TD><SELECT name='ONBJGBM'>"+strJgzlDownList+"</SELECT></TD>";
delResulttable+="<TD align='right'><input type='checkbox' name='DCPBM' value='"+strCpbm+"'></TD>";
delResulttable+="<TD><SELECT name='DCPBM_P'>"+strCpDownList+"</SELECT></TD>";
delResulttable+="<TD><SELECT name='DNBJGBM'>"+strJgzlDownList+"</SELECT></TD>";
resulttable+="</TR>";
delResulttable+="</TR>";
}
if(checknum==0)
{
resulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
delResulttable+="<TR><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR>";
}
rs.close();//释放资源
rs=null;
%>
<HTML>
<HEAD>
<META http-equiv="Content-Style-Type" content="text/css">
<META name="GENERATOR" content="IBM WebSphere Page Designer V3.5 for Windows">
<TITLE>
产品价格对照维护
</TITLE>
<LINK rel="stylesheet" href="/resources/Master.css" type="text/css">
<SCRIPT language="JavaScript">
var actionurl="";
var checknum=<%=checknum%>;
function FindObj(doc, lId)
{
for (var i=0; i < doc.layers.length; i++)
{
var w_str = "doc.layers[i].document." + lId;
var obj;obj=new Array;
obj[lId] = eval(w_str);
if (!obj[lId]) obj[lId] = FindObj(doc.layers[i], lId);
if (obj[lId]) return obj[lId];
}
return null;
}
function ShowObj(lId)
{
var ob;ob=new Array;
var appVer=parseInt(navigator.appVersion);
var isNC=(document.layers && (appVer >= 4));
var isIE=(document.all && (appVer >= 4));
if (isNC)
{
w_str = "document." + lId;ob[lId] = eval(w_str);
if (!ob[lId]) ob[lId] = FindObj(document, lId);
if (ob[lId]) ob[lId].visibility = "show";
}
if (isIE)
{
w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
ob[lId].visibility = "visible";
}
}
function HideObj(lId)
{
var ob;ob=new Array;
var appVer=parseInt(navigator.appVersion);
var isNC=(document.layers && (appVer >= 4));
var isIE=(document.all && (appVer >= 4));
if (isNC)
{
w_str = "document." + lId;ob[lId] = eval(w_str);
if (!ob[lId]) ob[lId] = FindObj(document, lId);
if (ob[lId]) ob[lId].visibility = "hide";
}
if (isIE)
{
w_str = "document.all.item(\"" + lId + "\").style";ob[lId] = eval(w_str);
ob[lId].visibility = "hidden";
}
}
function btnClick(i)
{
czform.quebtn.disabled=false;
czform.chabtn.disabled=false;
czform.newbtn.disabled=false;
czform.delbtn.disabled=false;
czform.subbtn.disabled=true;
switch(i)
{
case 1:
czform.ACT.value='1';
czform.quebtn.disabled=true;
HideObj("Lxz");
HideObj("Ldel");
ShowObj("Lcxgx");
break;
case 2:
czform.ACT.value='2';
czform.chabtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lxz");
HideObj("Ldel");
ShowObj("Lcxgx");
actionurl='cpjgdz_save.jsp?isFirst=0&baseJgbm=<%=baseJgbm%>';
czform.action=actionurl;
break;
case 3:
czform.ACT.value='3';
czform.newbtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lcxgx");
HideObj("Ldel");
ShowObj("Lxz");
actionurl='cpjgdz_save.jsp?isFirst=0&baseJgbm=<%=baseJgbm%>';
document.czform.NCPBM.focus();
czform.action=actionurl;
break;
case 4:
czform.ACT.value='4';
czform.delbtn.disabled=true;
czform.subbtn.disabled=false;
HideObj("Lxz");
HideObj("Lcxgx");
ShowObj("Ldel");
actionurl='cpjgdz_save.jsp?isFirst=0&baseJgbm=<%=baseJgbm%>';
czform.action=actionurl;
break;
}
}
function openpop()
{
window.open('search.jsp?yhzbm='+document.czform.yhzmclist.value,'PopupWindow','menubar=no,toolbar=no,location=no,directories=no,\
status=yes,resizable=yes,scrollbars=yes,width=40,height=40,top=11200,left=11200');
}
function checkque()
{
openpop();
}
function doChange()
{
czform.action='cpjgdz.jsp?isFirst=0&baseJgbm='+czform.jgbmlist.value;
czform.submit();
}
function doChange2()
{
czform.action='cpjgdz.jsp?isFirst=2';
czform.submit();
}
</SCRIPT>
</HEAD>
<BODY>
<FORM method="post" name="czform" >
<DIV style="width : 400px;height : 5px;top : 0px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxffdsfgx">
<H2>产品价格对照维护</H2>
<INPUT type="button" name="quebtn" value="查询" onclick="btnClick(1)" disabled>
<INPUT type="button" name="chabtn" value="修改" onclick="btnClick(2)">
<INPUT type="button" name="newbtn" value="增加" onclick="btnClick(3)">
<INPUT type="button" name="delbtn" value="删除" onclick="btnClick(4)">
<INPUT type="submit" name="subbtn" value="提交" disabled>
<INPUT type="button" name="bangzhu" value="帮助" onClick="window.open('/help/2.8/2.8.7.html','PopupWindow','menubar=yes,toolbar=yes,location=yes,directories=yes,status=yes,resizable=yes,scrollbars=yes,width='+(screen.availWidth)+',height='+(screen.availHeight)+',top=0,left=0');">
<INPUT TYPE='hidden' NAME='ACT' VALUE='1'><BR>
<BR>
</DIV>
<DIV style="width : 398px;height : 25px;top : 90px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lpublic">
所属机构：<SELECT name="jgbmlist" onchange="doChange()"><%=DbBean.selOptionE("DBO.JGZD","JGBM","JGMC",selectedJgbm,"WHERE ((JGBM='"+baseJgbm+"' OR SJJGBM='"+baseJgbm+"') AND (JGBZ LIKE '0%') AND (JGJB <= '10'))")%></SELECT>
<%
if(isTop.equals("0"))
{
out.println("<IMG src='/resources/images/function/goback.gif' width='16' height='18' border='0' onclick='doChange2()'>");
}
%>
</DIV>
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : visible;" id="Lcxgx">
<TABLE border="0" width="600">
<TR>
<TH>产品名称</TH>
<TH>内部价格</TH>
</TR>
<%=resulttable%>
</TABLE>
</DIV>
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : hidden;" id="Ldel">
<TABLE border="0" width="600">
<TR>
<TH>删除项</TH>
<TH>产品名称</TH>
<TH>内部价格</TH>
</TR>
<%=delResulttable%>
</TABLE>
</DIV>
<DIV style="top : 130px;left : 20px;
position : absolute;
z-index : 1;
visibility : hidden;" id="Lxz">
<TABLE border="0" width="550">
<TR>
<TH>产品名称</TH>
<TH>内部价格</TH>
</TR>
<TR>
<%
strCpDownList="";
if(rs_cp.first())
{
do
{
dm = rs_cp.getString("DM").trim();
mc = rs_cp.getString("MC").trim();
strCpDownList = strCpDownList+"<option value='"+dm+"'>"+mc+"</option>";
} while(rs_cp.next());
}
strJgzlDownList="";
if(rs_jgzl.first())
{
do
{
dm = rs_jgzl.getString("DM").trim();
mc = rs_jgzl.getString("MC").trim();
strJgzlDownList = strJgzlDownList+"<option value='"+dm+"'>"+mc+"</option>";
} while(rs_jgzl.next());
}
%>
<TD><SELECT name="NCPBM"><%=strCpDownList%></SELECT></TD>
<TD><SELECT name="NNBJGBM"><%=strJgzlDownList%></SELECT></TD>
</TR>
</TABLE>
</DIV>
</FORM>
</BODY>
</HTML>
<%
rs_cp.close();
rs_cp=null;
rs_jgzl.close();
rs_jgzl=null;
System.gc();
} catch( Throwable e)
{
DbBean.clear();
if(((e.getMessage())).equals("ResultSet is closed"))
{
out.println("<SCRIPT language='JavaScript'>");
out.println("self.location='/blank.html';");
out.println("</SCRIPT>");
}
else if(e.getMessage()==null)
{
out.println("服务已经重启，您闲置的时间太长或系统调用错误，请重新登入试一下！<br>如果再出现这种情况请与系统维护员联系！");
}
else out.println(e.getMessage());
System.gc();
return;
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -