OA系统

开发平台：
C#

rc_notemanage.aspx：源码内容
							<%@ Page Language="C#" AutoEventWireup="true" CodeFile="rc_notemanage.aspx.cs" Inherits="rc_rc_notemanage" validateRequest="false"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>记录管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
<link href="../css/link.css" rel="stylesheet" type="text/css"/>
<style type="text/css">
<!--
.style3 {font-size: 12px}
.style4 {font-size: 13px}
.style6 {color: #000000}
.style7 {color: #FF0000}
body {
	margin-top: 0px;
}
-->
</style>
<script language="javascript" type="text/javascript">
// <!CDATA[
function submit1_onclick() {
    var x = document.getElementById("form2");
    var cmd = document.getElementById("cmd").value;
    x.action="rc_selectlike.aspx?cmd="+cmd;
    document.myform.submit();
}
// ]]>
</script>
</head>
<body>
    <%
                COM.OA.Entity.users loginuser =Session["loginuser"] as COM.OA.Entity.users;
                if (loginuser == null)
                {
                    Response.Write("<script language='javascript'>parent.document.location.href='../login.aspx'</script>");  
                }
         %>
<div align="center">
<form  id="form2" name="myform">
  <table width="758" border="0" cellpadding="1" cellspacing="0">
    <tr>
      <td><div align="right">
          <form name="form1" method="post" action="" >
            <input name="cmd" type="text" id="cmd" />
            <input name="submit" type="submit" id="submit1" style="FONT-SIZE: 12px; HEIGHT: 27px" value= " 查 询 " onclick="return submit1_onclick()"/>
          </form>
      </div></td>
    </tr>
  </table>
  </form>
  
  <form runat="server">
  <table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td style="height: 19px; width: 4px;"><img src="../images/sj/leftlin1.gif" width="6" height="21" /></td>
      <td width="936" bgcolor="#5AAE18" style="height: 19px"><div align="center">
          <div align="center" class="style1"><span class="style1"><strong>日 程 列 表</strong></span></div>
          </div></td>
      <td width="6" style="height: 19px"><img alt="" src="../images/sj/rightlin1.gif" width="6" height="21" /></td>
    </tr>
    
  </table>
  
  <table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#5AAE18">
    <tr bgcolor="#FFFFFF">
    <td colspan="8">
        <asp:GridView ID="GridView1" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" AllowPaging="True" OnRowDataBound="GridView1_RowDataBound">
            <Columns>
                <asp:HyperLinkField DataTextField="to_title" HeaderText="主题" DataNavigateUrlFields="to_id" DataNavigateUrlFormatString="rc_notecontent.aspx?tid={0}" />
                <asp:BoundField DataField="to_orderdate" HeaderText="日程日期" SortExpression="to_orderdate" />
                <asp:HyperLinkField HeaderText="修改" Text="修改" DataNavigateUrlFields="to_id" DataNavigateUrlFormatString="rc_noteupdate.aspx?id={0}" />
                <asp:HyperLinkField HeaderText="删除" Text="删除" DataNavigateUrlFields="to_id" DataNavigateUrlFormatString="rc_notedelete.aspx?id={0}" />
                <asp:HyperLinkField HeaderText="类型" Text="工作日程" />
                <asp:BoundField DataField="to_sendtime" HeaderText="时间" SortExpression="to_sendtime" />
                <asp:TemplateField HeaderText="批阅">
                      <ItemTemplate><img alt="" src="../images/sj/pen.gif" width="24" height="21">
                          <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("to_id", "rc_read.aspx?id={0}") %>'
                              Text="撰写批阅"></asp:HyperLink>
                      </ItemTemplate>
                  </asp:TemplateField>
            </Columns>
        </asp:GridView>
    </td>
    </tr>
  </table>
  <span class="style3">
      <br />
      (总共<%=this.GridView1.Rows.Count %>条记录)</span>
  <br/>  
  <table width="13%"  border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td style="width: 87px"><img alt="" src="../images/sj/up.gif" width="17" height="12" /><a href="javascript:history.go(-1)">返 回</a></td>
    </tr>
  </table>
</form>
  <p>
      <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sj_OA_DBConnectionString %>"
          SelectCommand="SELECT * FROM [timeorder] WHERE ([to_state] = @to_state)">
          <SelectParameters>
              <asp:Parameter DefaultValue="0" Name="to_state" Type="Int32" />
          </SelectParameters>
      </asp:SqlDataSource>
      &nbsp;
      &nbsp;&nbsp;</p>
</div>
</body>
</html>

						