?? 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 + -