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

📄 attributechakan.asp

📁 企业办公自动化管理系统 asp+sql server 2005
💻 ASP
字号:
<!--#include file="../include/sqlstr.asp"-->
<!--#include file="../include/opendb.asp"-->

<%
oabusyname=request.cookies("oabusyname")
oabusysuid=request.cookies("oabusysuid")
oabusyuserdept=request.cookies("oabusyuserdept")
oabusyuserlevel=request.cookies("oabusyuserlevel")
'if oabusysuid="" then response.redirect "default.asp"
dim rs1,sql1,rs,sql,conn,conn1
set conn=opendb()
set rs=server.createobject("adodb.recordset")
sql="select * from a_liuchengbeifeng where id="&request("id")
rs.open sql,conn,1,1
set conn=opendb()
set rs1=server.createobject("adodb.recordset")

sql1="select  top 1 * from a_liucheng where  shifoukanguo=0 and liuchengbeifengid="&rs("id")
rs1.open sql1,conn,1,1

%>
<html>

<head>
<meta http-equiv="Expires" content=0>
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
<style>
 .litle_button{
               width: 95; height: 20; font-size: 9pt;background-color: #FFFFFF; border: 1 solid #009F9F;color: #0000FF; 
              }
</style>
<link rel="stylesheet" href="../css/css.css" type="text/css">
</head>

<body bgproperties="fixed" background="image/bag.jpg">
<br>
<div align="center">
  <center>
<form method="POST" action="sign1.asp" name="the_form">





      <table border="1" cellspacing="0" style="border-collapse: collapse" bordercolor="#009F9F" width="551" id="AutoNumber1" cellpadding="4" height="251">
        <tr> 
          <th colspan="4" bgcolor="#000000" height="16"> 
            <p align="center"><font color="#FFFFFF">流 程 属 性 阅 览</font></p>
          </th>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="12" class="litle_button">流程主题:</td>
          <td width="371" height="12" class="cc"><%=rs("title")%></td>
          <td rowspan="7" height="90" width="57" valign="top"> </td>
        </tr>
      
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="13" class="litle_button">发 
            起 人:</td>
          <td width="371" height="13" class="big"><%=rs("fashongren")%></td>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="13" class="litle_button">发布时间:</td>
          <td width="371" height="13" class="big"><%=rs("inputdate")%></td>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="13" class="litle_button">截止日期:</td>
          <td width="371" height="13" class="big"><%=rs("year")&"-"&rs("mouth")&"-"&rs("day")%></td>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="13" class="litle_button">来文单位:</td>
          <td width="371" height="13" class="big"><%=rs("danwei")%></td>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="13" class="litle_button">流程密级:</td>
          <td width="371" height="13" class="cc"><%=rs("baomi")%></td>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="13" class="litle_button">流程附件:</td>
          <td height="13" colspan="3" class="big"> 
            <a href="downfile.asp?id=<%=rs("id")%>" target="_blank"><img src="../images/attach.gif" width=30 height=30 border=0 alt="文件名:<%=rs("filename")%>">附件</a> 
            </td>
        </tr>
        <tr> 
          <td width="91" align="center" bgcolor="#E0E0E0" height="7" class="litle_button">已阅人员:</td>
          <td height="7" colspan="3" class="cc"><font size="2"> 
            <%
	dim rs2,sql2
	set conn=opendb()
set rs2=server.createobject("adodb.recordset")

sql2="select  * from a_liucheng where  shifoukanguo=1 and liuchengbeifengid="&rs("id")
rs2.open sql2,conn,1,1 

for i=1 to rs2.recordcount%>
            <a href="qianming.asp?id=<%=rs2("id")%>" target="_blank"><%=rs2("name")&","%> </a>
            <%rs2.movenext
next
%>
      
            </font> </td>
        </tr>
      </table>  
      
      <p class="big">&nbsp;</p>
      <table width="600" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td>&nbsp;</td>
              </tr>
            </table>
          </td>
          <td>&nbsp;</td>
        </tr>
      </table>
      <div align="center">
        <input type="button" value="<< 返 回" name="back" onclick="history.go(-1);">
        <input type="hidden" name="C1" value="<%=Request.QueryString("id")%>">
      </div>
    </form> 
  </center>  
</div>  
</body>

</html>

⌨️ 快捷键说明

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