📄 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","公司质检部门" );
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;
if (!(info.substring(2)=="00")) f1.elements[ObjID].options[i] = null
}
}
var b=0
var indexarr = new Array()
for (i=0;i<f1.elements[ObjID].length;i++)
{ value1 = f1.elements[ObjID].options[i].value
if (value1.substring(2)=="00"){
if (f1.elements[ObjID].length==i+1)
f1.elements[ObjID].options[i]=null
else
{ value2 = f1.elements[ObjID].options[i+1].value
if (value2.substring(2)=="00"){
indexarr[b]=i
b++
}
}
}
}
for (var c=0;c<b;c++){
f1.elements[ObjID].options[indexarr[c]-c]=null
}
}
}
function isValidDate( year, month, day )
{
year = parseInt(year,10);
month = parseInt(month,10);
day = parseInt(day,10);
if ( month==4 || month==6 || month==9 || month==11 )
{ if ( day < 1 || day > 30 )
{// alert( "日期在1 - 30之间" );
return (false);
}
}
else
{ if ( month!=2 )
{ if ( day < 1 || day > 31 )
{// alert( "日期在1 - 31之间" );
return (false);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -