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

📄 projectlz_edit.asp

📁 ASP程序实现的科技期刊系统
💻 ASP
字号:
<!--#include file="../Include/TimeOut.asp"-->
<%modulecode="0504"%>
<!--#include file="../Include/ModuleUserCheck.asp"-->
<!--#include file="../Include/online.asp"-->
<%
'无变量传来时先赋初值,即添加状态
JieGuo=""
YiJian=""
edit=""

'取得传来变量
ProjectCode=Request.Querystring("code")
strsqlzh=Request.QueryString("strsql")
page=Cstr(Request.Querystring("page"))
edit=Request.Querystring("edit")

JieGuo=request("JieGuo")
YiJian=request("YiJian")
if not ProjectCode="" then
set rst=server.createobject("ADODB.recordset")
Strsql="select 论证结果,论证意见 from XT_VD_ProjectBasic where 项目编码='"&ProjectCode&"'"
rst.open Strsql,strconn
if rst.EOF then '项目基本表没填
	Response.Write "此项目申报书没填完整,不能论证!<br>"
	Response.Write "<a href=ProjectTJ_EditList.asp?strsql="+server.URLEncode ( Request.QueryString("strsql"))+"&page="+Cstr(page)+">按此返回列表</a>"
	Response.End 
else
	if JieGuo="" then'没有提交
	JieGuo=rst("论证结果")
	YiJian=rst("论证意见")
	else
'				strsql="update XT_TD_Project set 项目进度='立项',进度状况='未立项' where 项目编码="+"'"+ProjectCode+"'"
				strsql1="update XT_TD_ProjectBasic set 论证结果='"&JieGuo&"',论证意见='"&YiJian&"',专家编码='"&session("DepartCode")&"',论证时间='"&date&"' where 项目编码="+"'"+ProjectCode+"'"
'				conn.Execute strsql,1
				conn.Execute strsql1,1
				Response.Redirect "ProjectCS_EditList.asp?strsql="+server.URLEncode ( Request.QueryString("strsql"))+"&page="+Cstr(page)
	end if	
end if
end if
%>
<html>
<head>
<title>专家论证意见</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../CssLib/Cssbutton.css">
</head>

<body text="#000000" bgcolor="#ffffff">
<%'显示专家信息
if not ProjectCode="" then
set rstExp=server.createobject("ADODB.recordset")
StrsqlExp="select 责任专家 from XT_VD_ProjectName where 项目编码='"&ProjectCode&"'"
rstExp.open StrsqlExp,strconn,2,2
%>
<table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="#333333">
  <tr bgcolor="#EAEAEA"> 
    <td width="16%">本项目被分配的专家</td>
    <td colspan="2"><%if not isnull(rstexp("责任专家")) then Response.Write rstExp("责任专家") else Response.Write "无" end if%></td>
  </tr>
  <%rstExp.close%>
  <%StrsqlExp="select * from xt_vd_ProjectExpertYJ where 项目编码='"&ProjectCode&"'"
	rstExp.Open StrsqlExp,conn,2,2
	if not rstExp.EOF then 
		for i=1 to rstExp.RecordCount
  %>
  <tr bgcolor="#EAEAEA"> 
    <td width="16%"><%=rstExp("专家姓名")%></td>
    <td width="42%"><%=rstExp("评审结果")%></td>
    <td width="42%"><%=rstExp("评审意见")%></td>
  </tr>
  <%
		rstExp.MoveNext 
		next
	else
	%>
  <tr bgcolor="#EAEAEA"> 
    <td colspan="3">目前暂无专家意见!</td>
  </tr>
	<%
	end if
	rstExp.Close
	set rstExp=nothing
  %>
</table>
<%end if'专家信息显示结束%>
<br>
<img src="../Project/images/edit_title_LZ.gif" width="200" height="27"><font color="#00CCFF" size="1">★★★★★<font color="#00CCFF" size="1">★★★★★</font><font color="#00CCFF" size="1">★★★★★</font><font color="#00CCFF" size="1">★★★★★</font>★★</font><br>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td width="22" height="20"><img src="../public/images/edit_bg_zs.gif" width="21" height="20"></td>
    <td background="../public/images/bg_left.gif" bgcolor="#0099FF"> 
      <div align="center"></div>
    </td>
    <td width="10"><img src="../public/images/edit_bg_ys.gif" width="21" height="20"></td>
  </tr>
  <tr> 
    <td background="../public/images/bg_left.gif">&nbsp;</td>
    <td bgcolor="#FFFFFF" height="200"> 
      <table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
        <tr> 
          <td height="20" width="6%" bgcolor="#FFFFFF">&nbsp;</td>
          <td height="20" width="20%" bgcolor="#FFFFFF">&nbsp;</td>
          <td height="20" width="69%" bgcolor="#FFFFFF">&nbsp;</td>
          <td height="20" width="5%" bgcolor="#FFFFFF">&nbsp;</td>
        </tr>
        <form name="conlist" method="post" action="../Project/ProjectLZ_edit.asp?Code=<%=projectCode%>&strsql=<%=server.URLEncode(strsqlzh)%>&edit=<%=request.querystring("edit")%>&page=<%=Cstr(request.querystring("page"))%>" onSubmit="return checkfun()">
          <tr> 
            <td height="20" width="6%" bgcolor="#EAEAEA">&nbsp;</td>
            <td height="20" width="20%" bgcolor="#EAEAEA"> 
              <div align="left">专家论证结果</div>
            </td>
            <td height="20" width="69%" bgcolor="#EAEAEA">
              <input type="radio" name="JieGuo" value="推荐" <%if JieGuo="推荐" then response.write "checked" end if%><%if JieGuo="" or isnull(JieGuo) then response.write "checked" end if%>>
              推荐
              <input type="radio" name="JieGuo" value="可选" <%if JieGuo="可选" then response.write "checked" end if%>>
              可选 
              <input type="radio" name="JieGuo" value="落选"<%if JieGuo="落选" then response.write "checked" end if%>>
              落选</td>
            <td height="20" width="5%" bgcolor="#EAEAEA">&nbsp;</td>
          </tr>
          <tr> 
            <td height="18" width="6%" bgcolor="white">&nbsp;</td>
            <td height="18" width="20%" bgcolor="white"> 
              <div align="left"></div>
            </td>
            <td height="18" width="69%" bgcolor="white">&nbsp;</td>
            <td height="18" width="5%" bgcolor="white">&nbsp;</td>
          </tr>
          <tr> 
            <td height="20" width="6%" bgcolor="#EAEAEA">&nbsp;</td>
            <td height="20" width="20%" bgcolor="#EAEAEA"> 
              <div align="left">专家论证意见</div>
            </td>
            <td height="20" width="69%" bgcolor="#EAEAEA"> 
              <textarea name="YiJian" rows="4" cols="65"><%=YiJian%></textarea>
            </td>
            <td height="20" width="5%" bgcolor="#EAEAEA">&nbsp;</td>
          </tr>
          <tr> 
            <td height="20" width="6%" bgcolor="#FFFFFF"><font color="#FFFFFF"></font></td>
            <td height="20" width="20%" bgcolor="#FFFFFF"><font color="#FFFFFF"></font></td>
            <td height="20" width="65%" bgcolor="#FFFFFF"><font color="#FFFFFF"></font></td>
            <td height="20" width="9%" bgcolor="#FFFFFF"><font color="#FFFFFF"></font></td>
          </tr>
          <tr> 
            <td height="20" colspan="4" bgcolor="#FFFFFF"> 
              <div align="center"> 
                <input class="button" type="submit" name="Submit" value="提交" >
                <input class="button" type="button" name="Submit3" value="取消" onClick="history.back()">
              </div>
            </td>
          </tr>
          <tr> 
            <td height="20" width="6%" bgcolor="#FFFFFF">&nbsp;</td>
            <td height="20" width="20%" bgcolor="#FFFFFF">&nbsp;</td>
            <td height="20" width="69%" bgcolor="#FFFFFF">&nbsp;</td>
            <td height="20" width="5%" bgcolor="#FFFFFF">&nbsp;</td>
          </tr>
        </form>
      </table>
    </td>
    <td bgcolor="#FFFFFF" background="../public/images/bg_left.gif">&nbsp;</td>
  </tr>
  <tr> 
    <td width="22"><img src="../public/images/edit_bg_zx.gif" width="21" height="20"></td>
    <td bgcolor="#FFFFFF" background="../public/images/bg_left.gif" height="20">&nbsp;</td>
    <td width="10"> 
      <div align="right"><img src="../public/images/edit_bg_yx.gif" width="21" height="20"></div>
    </td>
  </tr>
</table>
</body>
</html>
<script language="vbscript">
	function checkfun()   '校验表单
		checkfun=true
		if ConList.YiJian.value ="" then 
			checkfun=false
			window.alert "意见不能为空,请重新输入!"
			exit function
		end if
	end function
</script>

⌨️ 快捷键说明

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