📄 z_sortitem.jsp
字号:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
String z_Loginmessage=(String)session.getValue("z_loginSign");
String adminID=(String)session.getValue("adminID");
if(z_Loginmessage!="OK")
{
response.sendRedirect("index4.jsp");
}
%>
<jsp:useBean id="z_sortItem" scope="page" class="firm.firm"/>
<%
String sort=request.getParameter("SubSort");
String subSort1=sort.substring(0,2);
String subSort2=sort.substring(2,4);
String str="";
String sql="";
String sql1="";
if(sort.compareTo("0000")==0){
sql="select * from I_s_item as x order by (select avg(score6) from I_distribute as y where y.itemID=x.itemID) desc";
sql1="select count(*) as cnt from I_s_item";
str="全部";
}
else if(subSort2.compareTo("00")==0){
sql="select * from I_s_item as x where sort1 like '"+subSort1+"__"+"' or sort2 like '"+subSort1+"__"+"' order by (select avg(score6) from I_distribute as y where y.itemID=x.itemID) desc";
sql1="select count(*) as cnt from I_s_item where sort1 like '"+subSort1+"__"+"' or sort2 like '"+subSort1+"__"+"'";
str="总类";
}
else{
sql="select * from I_s_item as x where sort1='"+sort+"' or sort2='"+sort+"' order by (select avg(score6) from I_distribute as y where y.itemID=x.itemID) desc";
sql1="select count(*) as cnt from I_s_item where sort1='"+sort+"' or sort2='"+sort+"'";
str="分类";
}
ResultSet rs=z_sortItem.executeQuery(sql);
int pageLine=20;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
ResultSet countrs=z_sortItem.executeQuery(sql1);
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
z_sortItem.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
%>
<html>
<head>
<title>项目设置</title>
<style>
<!--
:link {color:#000099}
:visited {color:#000099}
:active {color:#000099}
A:link,A:visited,A:active {text-decoration:none}
//-->
</style>
<SCRIPT language=javascript>
<!--
OptSort = new Array(
"0100","网络",
"0101","软件外包",
"0200","经营管理",
"0201","公司硬件设施",
"0202","员工交通",
"0300","员工住宿",
"0301","员工工资",
"0302","节假日补助",
"0303","公司发展战略",
"0304","软件系统",
"0400","招聘新员工",
"0401","成立新部门",
"0402","公司管理制度",
"0403","公司财务管理",
"0500","公司人事管理",
"0501","公司销售部门",
"0502","公司质检部门" );
function showMainOpt()
{
var i,start,step,len,a,args=showMainOpt.arguments;
a = args[0];
len = a.length;
start = (args.length>=2)?args[1]:0;
step = 2;
for(i=start;i<len;i+=step)
{
if(a[i].substr(a[i].length-2) == "00")
document.writeln("<option value="+a[i]+">"+a[i+1]+"</option>");
}
}
function showSubOpt()
{
var i,len,start,step,s1,s2,a,args=showSubOpt.arguments;
var mainVal,val,name;
a=args[0];
s1=args[1];
s2=args[2];
start=0;
step=2;
IsAll = (args.length>=4)?args[3]:false;
len=a.length;
mainVal=s1.options[s1.selectedIndex].value;
mainVal=mainVal.substr(0,2);
for(i=s2.length-1;i>=0;i--)
{
s2.options[i]=null;
}
if(Number(mainVal)!=0)
{
for(i=start;i<len;i+=step)
{
val = a[i];
name = a[i+1];
if(val.substr(0,2)==mainVal)
{
if(val.substr(val.length-2) == "00")s2.options[s2.length]=new Option("全部",val,false,false);
else s2.options[s2.length]=new Option(name,val,false,false);
}
}
}
}
function showSort()
{
var i,len,start,step,s1,a,args=showSort.arguments;
var name;
a=args[0];
s1=args[1];
start=0;
step=2;
len=a.length;
for(i=0;i<len;i+=step)
{
if(a[i]==s1)
{
name=a[i+1];
break;
}
else name="";
}
document.writeln(name);
}
//-->
</SCRIPT>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center">
<table border="0" cellspacing="0" cellpadding="0" width="670">
<tr>
<td bgcolor="#000099">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFFFFF">
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3"></td>
</tr>
<tr bgcolor="#FFFFFF">
<td colspan="3"> </td>
</tr>
<tr>
<td width="33%"> </td>
<td bgcolor="#FFFFFF">
<div align="center"><img src="../images/z_itemSetup.gif" width="112" height="22"></div>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -