⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 updateproject.asp

📁 投资管理系统, asp+ mssql server
💻 ASP
字号:
<%
response.expires=-1
dim ThisKey
ThisKey = "b"
%>
<!--#include file="../inc/permission.asp"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="Nav.asp"-->
<!--#include file="../../inc/RightsForOne.asp"-->
<%
ID=trim(request("ID"))
LoginName=Session("LoginName")
If RightsForOne(ID,LoginName)<3 Then
	Response.Write "<Script Language='JavaScript'>"
	Response.Write "alert('你没有编辑此项目的权限');"
	Response.Write "self.close();"
	Response.Write "</Script>"
	Response.End
End If
set rs=Server.CreateObject("ADODB.RecordSet")
if trim(request("submit"))="确 定" then
	Name=replace(trim(request("Name")),"'","''")
	Address=replace(trim(request("Address")),"'","''")
	Attribute=replace(trim(request("Attribute")),"'","''")
	ShenpiUnit=replace(trim(request("ShenpiUnit")),"'","''")
	Money=replace(trim(request("Money")),"'","''")
	if Money="" then
		Money=0
	end if
	Nianxian=replace(trim(request("Nianxian")),"'","''")
	KaigongTime=replace(trim(request("KaigongTime")),"'","''")
	Neirong=replace(trim(request("Neirong")),"'","''")
	InputTime=trim(request("InputTime"))
	InputLogin=trim(request("InputLogin"))

	rs.open "select * from tblBase where ID="&ID,conn,1,2
	
	rs("Name")=Name
	rs("Address")=Address
	rs("Attribute")=Attribute
	rs("ShenpiUnit")=ShenpiUnit
	rs("Money")=Money
	rs("Nianxian")=Nianxian
	rs("KaigongTime")=KaigongTime
	rs("Neirong")=Neirong
	rs("InputName")=Session("UserName")
	rs("InputLogin")=Session("LoginName")
	rs.update
	rs.close

end if
	rs.open "select * from tblBase where ID="&ID,conn,1,1
	if not rs.eof then
	Name=trim(rs("Name"))
	Address=trim(rs("Address"))
	Attribute=trim(rs("Attribute"))
	ShenpiUnit=trim(rs("ShenpiUnit"))
	Money=trim(rs("Money"))
	Nianxian=trim(rs("Nianxian"))
	KaigongTime=trim(rs("KaigongTime"))
	Neirong=trim(rs("Neirong"))
	InputTime=trim(rs("InputTime"))
	InputLogin=trim(rs("InputLogin"))
	end if
	rs.close
%>
<HTML>
<HEAD>
<TITLE>后台投资情况</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" href="../css/main.css" type="text/css">
</HEAD>
<BODY bgColor=#996600 topmargin=10>
<table width="750" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr>
    <td><img src="../image/top_2.jpg" width="750" height="80"></td>
  </tr>
</table>
<div align="center"></div>
<TABLE align=center bgColor=#ffffff border=0 cellPadding=0 width=750>
  <FORM action="" method=post name=form1>
  <INPUT name=ID type=hidden value="<%=ID%>">
  <INPUT name=typet type=hidden value="<%=typet%>">
  <INPUT name=InputTime type=hidden value="<%=InputTime%>">
  <INPUT name=InputLogin type=hidden value="<%=InputLogin%>">
  <TR>
      <TD align=middle 
    style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid; BORDER-TOP: #996600 1px solid" 
    vAlign=top width="100%" bgcolor="#FFCC33"> 
        <TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
          <TR bgcolor="#FF9900">
            <TD bgcolor="#FF9900" align=middle 
          style="BORDER-BOTTOM:1 solid #996600;BORDER-right: #996600 1px solid;" width="16%" onmouseover="javascript:this.bgColor='#FFCC33'" onmouseout="javascript:this.bgColor='#FF9900';"  style="cursor:hand"><b><font color="#FFFFFF">项目基本情况</font> </b></TD>
            <TD bgcolor="#FF9900" align=middle 
          style="BORDER-BOTTOM:1 solid #996600;" width="16%" onmouseover="javascript:this.bgColor='#FFCC33';" onmouseout="javascript:this.bgColor='#FF9900';"  onClick="OpenWindow1();" style="cursor:hand"><b><font color="#FFFFFF">申报审批备案情况</font></b></TD>
            <TD bgcolor="#FF9900" align=middle 
          style="BORDER-BOTTOM:1 solid #996600;BORDER-LEFT:1 solid #996600" width="16%" onmouseover="javascript:this.bgColor='#FFCC33'" onmouseout="javascript:this.bgColor='#FF9900';"  onClick="OpenWindow2();" style="cursor:hand"><b><font color="#FFFFFF">项目年度计划</font></b></TD>
            <TD bgcolor="#FF9900" align=middle 
          style="BORDER-BOTTOM:1 solid #996600;BORDER-LEFT:1 solid #996600" width="16%" onmouseover="javascript:this.bgColor='#FFCC33'" onmouseout="javascript:this.bgColor='#FF9900';"  onClick="OpenWindow3();" style="cursor:hand"><b><font color="#FFFFFF">项目进展情况</font></b></TD>
		  <TD bgcolor="#FF9900" align=middle 
          style="BORDER-BOTTOM:1 solid #996600;BORDER-LEFT:1 solid #996600" width="16%" onmouseover="javascript:this.bgColor='#FFCC33'" onmouseout="javascript:this.bgColor='#FF9900';"   onClick="OpenWindow4();" style="cursor:hand"><b><font color="#FFFFFF">项目资金情况</font></b></TD>
		  <TD bgcolor="#FF9900" align=middle 
          style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid;" 
          width="20%" onmouseover="javascript:this.bgColor='#FFCC33'" onmouseout="javascript:this.bgColor='#FF9900';"  onClick="OpenWindow5();" style="cursor:hand"><b><font color="#FFFFFF">项目业主、主管单位情况</font></b></TD>
          </TR>
        </TABLE>
      <TABLE border=0 cellPadding=0 cellSpacing=0 width="95%">
        <TR>
          <TD width="100%"><font color=red><%=Nav%></font>项目基本情况:</TD></TR>
        <TR>
          <TD align=middle vAlign=top width="100%">
            <TABLE border=0 cellPadding=0 cellSpacing=0 width="95%">
              <TR>
                <TD align=middle style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid; BORDER-TOP: #996600 1px solid" 
                vAlign=center>项目名称</TD>
                <TD colspan=3 
                style="BORDER-BOTTOM: #996600 1px solid; BORDER-RIGHT: #996600 1px solid; BORDER-TOP: #996600 1px solid" 
                width="85%"><INPUT type=text name=Name size=81 value="<%=Name%>"> </TD></TR>
              <!--#include file="../inc/Att2.asp"-->
              <TR>
                <TD align=middle style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" vAlign=center>建设地址</TD>
                <TD style="BORDER-BOTTOM: #996600 1px solid;" 
                width="35%"><INPUT type=text name=Address size=32 value="<%=Address%>"> </TD>
                <TD align=middle style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                vAlign=center>总投资</TD>
                <TD style="BORDER-BOTTOM: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                width="35%"><INPUT type=text name=Money size=25 value="<%=Money%>">(万元)</TD></TR>
              <TR>
                <TD align=middle style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                vAlign=center>建设年限</TD>
                <TD style="BORDER-BOTTOM: #996600 1px solid;" 
                width="35%"><INPUT type=text name=Nianxian size=32 value="<%=Nianxian%>"> </TD>
                <TD align=middle style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                vAlign=center>预计争取开工时间</TD>
                <TD style="BORDER-BOTTOM: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                width="35%"><INPUT type=text name=KaigongTime size=32 value="<%if KaigongTime="" then%><%=date1%><%else%><%=KaigongTime%><%end if%>"> </TD></TR>
              <TR>
                <TD align=middle style="BORDER-BOTTOM: #996600 1px solid; BORDER-LEFT: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                vAlign=center>建设内容及规模</TD>
                <TD colspan=3 
                style="BORDER-BOTTOM: #996600 1px solid; BORDER-RIGHT: #996600 1px solid" 
                width="85%"><TEXTAREA cols=80 name=Neirong rows=3><%=Neirong%></TEXTAREA>
            </TD></TR></TABLE></TD></TR></TABLE>
      <TABLE border=0 cellPadding=0 cellSpacing=0 width="70%">
        <TR>
          <TD align=middle width="100%">
		  <INPUT type=submit name=submit onclick="return j();" value="确 定"> 
		  <INPUT type=reset name=exit value="重 写"> 
		  <input type=button onclick="javascript:window.close();" value="关闭窗口">
          </TD></TR></TABLE></TD></TR></FORM>
    <td bgcolor="#FF9900" height="23">&nbsp;
  </TABLE>
<script language=javascript>
function OpenWindow1(url,windowname){
	ID=document.form1.ID.value;
	typet=document.form1.typet.value;
window.open('../Shenpi/Shenpi.asp?typet='+typet+'&ID='+ID,'Shenpi','left=50,top=10,height=490,width=530,toolbar=no,menubar=no,scrollbars=yes')
}

function OpenWindow2(url,windowname){
	ID=document.form1.ID.value;
	typet=document.form1.typet.value;
window.open('../Plan/Plan.asp?typet='+typet+'&ID='+ID,'Plan','left=50,top=50,height=340,width=530,toolbar=no,menubar=no,scrollbars=yes')
}

function OpenWindow3(url,windowname){
	ID=document.form1.ID.value;
	typet=document.form1.typet.value;
window.open('../Jindu/Jindu.asp?typet='+typet+'&ID='+ID,'Jindu','left=50,top=50,height=220,width=530,toolbar=no,menubar=no,scrollbars=yes')
}

function OpenWindow4(url,windowname){
	ID=document.form1.ID.value;
	typet=document.form1.typet.value;
window.open('../Money/Money.asp?typet='+typet+'&ID='+ID,'Money','left=20,top=50,height=380,width=730,toolbar=no,menubar=no,scrollbars=yes')
}

function OpenWindow5(url,windowname){
	ID=document.form1.ID.value;
	typet=document.form1.typet.value;
window.open('../Yezhu/Yezhu.asp?typet='+typet+'&ID='+ID,'Yezhu','left=50,top=50,height=320,width=530,toolbar=no,menubar=no,scrollbars=yes')
}

function j(){
	s=document.form1.Money.value
	if(s!==''){
		dot=0
		for(i=0;i<s.length;i++){
			if(s.charAt(i)>'9'){
				alert("请输入正确的数字。");
				return false;
			}
			else{
				if(s.charAt(i)<'0'){
					if(s.charAt(i)=='.'){
						dot=dot+1
							if(dot>1){
								alert("请输入正确格式的数字。");
								return false;
							}
					}
					if(s.charAt(i)!='.'){
						alert("请输入正确的数字。");
						return false;					
					}
				}
			}
		}
	}
}
</script>
<!--#include file="../inc/SearchAtt.asp"-->
</BODY>
</HTML>
<!--#include file="../inc/close.asp"-->

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -