OA系统

开发平台：

ASP/ASPX

employee_where_d.aspx：源码内容

							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="employee_where_d.aspx.cs" Inherits="web_approvel_employee_where_1_d" %>
<!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>
</head>
<body>
<center>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
            DataSourceID="SqlDataSource1" OnRowCreated="Setcolor" Width="186px">
            <Columns>
                <asp:TemplateField HeaderText="刷卡時間" >
                    
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server"   ></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
    
    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
            SelectCommand="select a.id,card_t,card_status from oa_card_time as a left join oa_employee as b on a.emp_card_no=b.work_card_no1 where    &#13;&#10; card_date=@card_date and b.id=@e_id">
            <SelectParameters>
                <asp:QueryStringParameter Name="card_date" QueryStringField="card_date" />
                <asp:QueryStringParameter Name="e_id" QueryStringField="e_id" />
            </SelectParameters>
        </asp:SqlDataSource>
    </form>
    </center>
</body>
</html>

						