📄 copy of s_changeitem.jsp
字号:
<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
String getLoginmessage=(String)session.getValue("loginSign");
String unit_ID=(String)session.getValue("unitID");
if(getLoginmessage!="OK")
{
response.sendRedirect("index2.jsp");
}
%>
<jsp:useBean id="s_changeitem" scope="page" class="firm.firm"/>
<%
String ssql="select * from I_itemSetup";
ResultSet srs=s_changeitem.executeQuery(ssql);
java.util.Date today=new java.util.Date();
java.util.Date s_beginDate=new java.util.Date();
java.util.Date s_finishDate=new java.util.Date();
if(srs.next())
{
s_beginDate=srs.getDate("s_beginDate");
s_finishDate=srs.getDate("s_finishDate");
}
if(today.before(s_beginDate) || today.after(s_finishDate))
{
response.sendRedirect("timeOut.jsp");
}
%>
<%
String itemID=request.getParameter("itemID");
String sql="select * from I_s_item where itemID='"+itemID+"'";
ResultSet rs=s_changeitem.executeQuery(sql);
//定义数据类型并初始化
String item_name1=""; //项目名称
String sort1=""; //类 别
String sort2="";
String begin_date1=""; //起止年限
String finish_date1=""; //起止年限
String applicant1=""; //申 请 者
String grade1=""; //职 称
String education1=""; //学 历
String unit_name1=""; //所在单位
String fill_date1=""; //填报日期
String purport1=""; //本课题的研究意义
String status1=""; //国内外研究现状述评
String future1=""; //预期应用前景
String point1=""; //主要思想、观点
String analysis1=""; //主要内容、重点和难点分析
String way1=""; //研究方法
String moment1=""; //阶段及最终预期研究成果
String result1=""; //预期研究成果
String reference1=""; //本课题前期研究成果，主要的外文参考文献和参考资料
String market1=""; //应用推广或市场分析
String commend_mind1=""; //推荐单位意见
String expert_mind1=""; //专家评审委员会意见
String leading_mind1=""; //审批意见
String pass1=""; //是否通过审批
String sum="";
if(rs.next())
{
item_name1=rs.getString("item_name");
sort1=rs.getString("sort1");
sort2=rs.getString("sort2");
begin_date1=rs.getString("begin_date");
finish_date1=rs.getString("finish_date");
applicant1=rs.getString("applicant");
grade1=rs.getString("grade");
education1=rs.getString("education");
unit_name1=rs.getString("unit_name");
fill_date1=rs.getString("fill_date");
purport1=rs.getString("purport");
status1=rs.getString("status");
future1=rs.getString("future");
point1=rs.getString("point");
analysis1=rs.getString("analysis");
way1=rs.getString("way");
moment1=rs.getString("moment");
result1=rs.getString("result");
reference1=rs.getString("reference");
market1=rs.getString("market");
commend_mind1=rs.getString("commend_mind");
expert_mind1=rs.getString("expert_mind");
leading_mind1=rs.getString("leading_mind");
pass1=rs.getString("pass");
rs.close();
s_changeitem.closeStmt();
s_changeitem.closeConn();
}
String begin_year=begin_date1.substring(0,4);
String begin_month=begin_date1.substring(5,7);
String finish_year=finish_date1.substring(0,4);
String finish_month=finish_date1.substring(5,7);
String fill_year=fill_date1.substring(0,4);
String fill_month=fill_date1.substring(5,7);
String fill_day=fill_date1.substring(8,10);
//经费预算
String[] outItem=new String[15];
String[] money=new String[15];
String msql1="select * from I_s_money where itemID='"+itemID+"'";
ResultSet mrs1=s_changeitem.executeQuery(msql1);
int i=0;
while(mrs1.next())
{
outItem[i]=mrs1.getString("outItem");
money[i]=mrs1.getString("sMoney");
i++;
}
for(i=0;i<14;i++)
{
if(outItem[i]==null)
{
outItem[i]="";
money[i]="";
}
}
String sql3="select sum(sMoney) as ssum from I_s_money where itemID='"+itemID+"'";
ResultSet rs3=s_changeitem.executeQuery(sql3);
if(rs3.next()){ sum=rs3.getString("ssum");}
%>
<html>
<head>
<title>项目申报</title>
<SCRIPT language=javascript>
<!--
OptSort = new Array(
"0100","哲学",
"0101","哲学",
"0200","经济学",
"0201","理论经济学",
"0202","应用经济学",
"0300","法学",
"0301","法学",
"0302","政治学",
"0303","社会学",
"0304","民族学",
"0400","教育学",
"0401","教育学",
"0402","心理学",
"0403","体育学",
"0500","文学",
"0501","中国语言文学",
"0502","外国语言文学",
"0503","新闻传播学",
"0504","艺术学",
"0600","历史学",
"0601","历史学",
"0700","理学",
"0701","数学",
"0702","物理学",
"0703","化学",
"0704","天文学",
"0705","地理学",
"0706","大气科学",
"0707","海洋科学",
"0708","地球物理学",
"0709","地质学",
"0710","生物学",
"0711","系统科学",
"0712","科学技术史",
"0800","工学",
"0801","力学",
"0802","机械工程",
"0803","光学工程",
"0804","仪器科学与技术",
"0805","材料科学与工程",
"0806","冶金工程",
"0807","动力工程及工程热物理",
"0808","电气工程",
"0809","电子科学与技术",
"0810","信息与通信工程",
"0811","控制科学与工程",
"0812","计算机科学与技术",
"0813","建筑学",
"0814","土木工程",
"0815","水利工程",
"0816","测绘科学与技术",
"0817","化学工程与技术",
"0818","地质资源与地质工程",
"0819","矿业工程",
"0820","石油与天然气工程",
"0900","农学",
"0901","作物学",
"0902","园艺学",
"0903","农业资源利用",
"0904","植物保护",
"0905","畜牧学",
"0906","兽医学",
"0907","林学",
"0908","水产",
"1000","医学",
"1001","基础医学",
"1002","临床医学",
"1003","口腔医学",
"1004","公共卫生与预防医学",
"1005","中医学",
"1006","中西医结合",
"1007","药学",
"1008","中药学",
"1100","军事学",
"1101","军事",
"1200","管理学",
"1201","管理科学与工程",
"1202","工商管理");
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 && (IsAll || !IsAll && (val.substr(val.length-2) != "00")))
{
s2.options[s2.length]=new Option(name,val,false,false);
}
}
}
}
function GetObjID(ObjName)
{
var args=GetObjID.arguments;
var f1=(args.length>1)?args[1]:document.theform;
for ( var ObjID=0; ObjID < f1.elements.length; ObjID++ )
if (f1.elements[ObjID].name == ObjName )
{ return(ObjID);
break;
}
return(-1);
}
function GetLocation(ObjID, Value)
{
var args=GetLocation.arguments;
var f1=(args.length>2)?args[2]:document.theform;
total=f1.elements[ObjID].length;
for (pp=0; pp<total; pp++)
if (f1.elements[ObjID].options[pp].text == "---"+Value+"---")
{ return (pp);
break;
}
return (-1);
}
function AddItem(ObjName, DesName, CatName)
{
var args=AddItem.arguments;
var f1=(args.length>3)?args[3]:document.theform;
//GET OBJECT ID AND DESTINATION OBJECT
ObjID = GetObjID(ObjName,f1);
DesObjID = GetObjID(DesName,f1);
CatObjID = GetObjID(CatName,f1);
if ( ObjID != -1 && DesObjID != -1 && CatObjID != -1 )
{ hasNum = overalert(DesObjID,f1);
if (hasNum == 2)
{
window.alert("最多选两项。");
}
else
{ //GET SELECTED ITEM NUMBER
SelNum = 0;
for (var j=0; j<f1.elements[ObjID].length; j++)
{ if ( f1.elements[ObjID].options[j].selected)
SelNum ++;
}
if ((SelNum + hasNum) > 2)
{
window.alert("最多选两项。");
}
else
{ jj = f1.elements[CatObjID].selectedIndex;
CatValue = f1.elements[CatObjID].options[jj].text;
CatCode = f1.elements[CatObjID].options[jj].value;
i = f1.elements[ObjID].options.length;
j = f1.elements[DesObjID].options.length;
for (h=0; h<i; h++)
{ if (f1.elements[ObjID].options[h].selected )
{ Code = f1.elements[ObjID].options[h].value;
Text = f1.elements[ObjID].options[h].text;
j = f1.elements[DesObjID].options.length;
HasSelected = false;
for (k=0; k<j; k++ )
if (f1.elements[DesObjID].options[k].value == Code)
{ HasSelected = true;
break;
}
if (HasSelected == false)
{ Location = GetLocation(DesObjID, CatValue,f1);
if (Location == -1 )
{ //f1.elements[DesObjID].options[j] = new Option("---"+CatValue+"---",CatCode);
//f1.elements[DesObjID].options[j+1] = new Option(Text, Code);
f1.elements[DesObjID].options[j] = new Option(Text, Code);
}
else
{ InsertItem(DesObjID, Location+1,f1);
f1.elements[DesObjID].options[Location+1] = new Option(Text, Code);
}
}
else
{
window.alert("此项已选择。");
}
}
}
}//else
}//else
//CLEAR SELECTION
for (i=0; i<f1.elements[ObjID].length; i++)
f1.elements[ObjID].options[i].selected = false;
for (i=0; i<f1.elements[DesObjID].length; i++)
f1.elements[DesObjID].options[i].selected = true;
}//if
}//end of function
function overalert(ID)
{
var args=overalert.arguments;
var f1=(args.length>1)?args[1]:document.theform;
var over = 0;
thelength = f1.elements[ID].length;
for (m=0; m<thelength; m++)
{ thevalue = f1.elements[DesObjID].options[m].value
thevalue = thevalue.substring(2)
if (thevalue!="00")
over=over+1;
}
return(over);
}
//end
//MODIFIED BY DAVID AND CLOUD
function DeleteItem(ObjName)
{
var args=DeleteItem.arguments;
var f1=(args.length>1)?args[1]:document.theform;
ObjID = GetObjID(ObjName,f1);
if ( ObjID != -1 )
{ var check_index = new Array();
for (i=f1.elements[ObjID].length-1; i>=0; i--)
{ if (f1.elements[ObjID].options[i].selected)
{ check_index[i] = true;
f1.elements[ObjID].options[i].selected = false;
}
else
check_index[i] = false;
}
for (i=f1.elements[ObjID].length-1; i>=0; i--)
{ if (check_index[i])
{ info = f1.elements[ObjID].options[i].value;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -