OA系统

开发平台：
ASP/ASPX

finish_list.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="finish_list.aspx.cs" Inherits="web_data_repair_finish_list" %>
<!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>
    <form id="form1" runat="server">
    <center>
    <div>
        <asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0">
            <asp:View ID="View1" runat="server">
                <asp:Label ID="Label1" runat="server" Text="已簽核表單"></asp:Label><br />
                <asp:GridView ID="GridView1" runat="server" CellPadding="4" Style="position: relative" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="668px" OnRowDataBound="GridView1_RowDataBound" PageSize="8" ForeColor="#333333" GridLines="None">
                    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                    <EditRowStyle BackColor="#999999" />
                    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                    <Columns>
                        <asp:BoundField DataField="form_id" HeaderText="报修单号" SortExpression="form_id" />
                        <asp:BoundField DataField="emp_name" HeaderText="报修人" SortExpression="emp_name" />
                        <asp:BoundField DataField="check_time" HeaderText="审核时间" SortExpression="check_time" />
                        <asp:BoundField DataField="stuse" HeaderText="状态" ReadOnly="True" SortExpression="stuse" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                    SelectCommand="SELECT DISTINCT f.form_id, g.emp_name, f.check_time, CASE f.is_agree WHEN 'N' THEN '不同意' WHEN 'Y' THEN '已同意' END AS stuse FROM OA_REPAIR_FORM AS e INNER JOIN OA_EMPLOYEE AS g ON e.emp_id = g.id INNER JOIN OA_REPAIR_FLOW AS f ON e.form_id = f.form_id WHERE (f.is_check = 'Y') AND (f.operator_id = @operator_id) ORDER BY f.form_id DESC">
                    <SelectParameters>
                        <asp:SessionParameter Name="operator_id" SessionField="user_id" Type="Int32" />
                    </SelectParameters>
                </asp:SqlDataSource>
            </asp:View>
        </asp:MultiView>&nbsp;<asp:MultiView ID="MultiView2" runat="server">
            <asp:View ID="View2" runat="server">
                &nbsp;<asp:Table ID="FormTable" runat="server" GridLines="Both" Height="152px" Width="672px">
                    <asp:TableRow runat="server" BackColor="#E0E0E0" HorizontalAlign="Left">
                        <asp:TableCell runat="server" ColumnSpan="4" Font-Bold="True">单据明细</asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">维修单号</asp:TableCell>
                        <asp:TableCell runat="server">
                            <asp:Label ID="lb_no" runat="server" ForeColor="Black" Width="4cm"></asp:Label>
                        </asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">申请人</asp:TableCell>
                        <asp:TableCell runat="server">
                            <asp:Label ID="lb_person" runat="server" BorderStyle="None" Width="4cm"></asp:Label>
                        </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">门店</asp:TableCell>
                        <asp:TableCell runat="server">
                            <asp:Label ID="lb_department" runat="server" BorderStyle="None" ForeColor="Black"
                                Width="4cm"></asp:Label>
                        </asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">店内电话</asp:TableCell>
                        <asp:TableCell runat="server">
                            <asp:Label ID="lb_tel" runat="server" BorderStyle="None" ForeColor="Black" Width="4cm"></asp:Label>
                        </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">设备类型</asp:TableCell>
                        <asp:TableCell runat="server">
                            <asp:Label ID="lb_type" runat="server" BorderStyle="None" ForeColor="Black" Width="4cm"></asp:Label>
                        </asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">设备名称</asp:TableCell>
                        <asp:TableCell runat="server">
                            <asp:Label ID="lb_equipment" runat="server" BorderStyle="None" ForeColor="Black"
                                Width="4cm"></asp:Label>
                        </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">反映问题</asp:TableCell>
                        <asp:TableCell runat="server" ColumnSpan="3">
                            <asp:Label ID="comment" runat="server" Width="10cm"></asp:Label>
                        </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" Width="2cm">维修厂商</asp:TableCell>
                        <asp:TableCell runat="server" ColumnSpan="3">
                            <asp:Label ID="company" runat="server" BorderStyle="None" Width="10cm"></asp:Label>
                        </asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
                <asp:Table ID="FlowTable" runat="server" GridLines="Both" Style="width: 680px" Visible="true"
                    Width="636px">
                    <asp:TableRow runat="server" BackColor="#E0E0E0" HorizontalAlign="Left">
                        <asp:TableCell runat="server" ColumnSpan="7" Font-Bold="True">单据流程</asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server">步驟</asp:TableCell>
                        <asp:TableCell runat="server">辦理人</asp:TableCell>
                        <asp:TableCell runat="server">簽核類別</asp:TableCell>
                        <asp:TableCell runat="server">處理狀態</asp:TableCell>
                        <asp:TableCell runat="server">是否完工</asp:TableCell>
                        <asp:TableCell runat="server">處理意見</asp:TableCell>
                        <asp:TableCell runat="server">辦理日期</asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
            </asp:View>
        </asp:MultiView>
        </div>
       </center>
    </form>
</body>
</html>

						