OA系统

开发平台：
ASP/ASPX

form_add.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="form_add.aspx.cs" Inherits="web_data_repair_form_add" %>
<!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">
                <br />
                <asp:Table ID="Table1" runat="server" GridLines="Both" Height="180px" HorizontalAlign="Center" Width="500px">
                    <asp:TableRow runat="server" HorizontalAlign="Center" VerticalAlign="Middle">
                        <asp:TableCell runat="server" Width="2cm">申请单号</asp:TableCell>
                        <asp:TableCell runat="server" Width="4cm" Font-Bold="True">
                           <asp:Label ID="lb_no" runat="server" Width="3cm" ForeColor="Blue"></asp:Label></asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">代请人</asp:TableCell>
                        <asp:TableCell runat="server" Width="4cm" Font-Bold="True">
                            <asp:Label runat="server" ForeColor="Blue" ID="lb_person" BorderStyle="None" Width="3cm"></asp:Label></asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server" HorizontalAlign="Center" VerticalAlign="Middle">
                        <asp:TableCell runat="server" Width="2cm">报修门店</asp:TableCell>
                        <asp:TableCell runat="server" Width="4cm">
                            <asp:DropDownList ID="dll_department" runat="server" Width="4cm" DataSourceID="SqlDataSource3" DataTextField="name" DataValueField="id" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                            </asp:DropDownList>                            
                             <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>"
                    SelectCommand="SELECT id, name FROM OA_DEPARTMENT WHERE (CHARINDEX('店', name) &gt; 0)">
                </asp:SqlDataSource></asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">店内电话</asp:TableCell>
                        <asp:TableCell runat="server" Width="4cm" Font-Bold="True">
                            <asp:Label ID="lb_tel" runat="server" ForeColor="Blue" Width="4cm"></asp:Label>
                        </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server" HorizontalAlign="Center" VerticalAlign="Middle">
                        <asp:TableCell runat="server" Width="2cm">设备类型</asp:TableCell>
                        <asp:TableCell runat="server" Width="4cm">
                        <asp:DropDownList ID="dll_type" runat="server" Width="4cm" DataSourceID="SqlDataSource4" DataTextField="type" DataValueField="type" AutoPostBack="True">
                            </asp:DropDownList>
                        <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>" SelectCommand="SELECT [type] FROM [OA_UNIT_TYPE]"></asp:SqlDataSource></asp:TableCell>
                        <asp:TableCell runat="server" Width="2cm">设备名称</asp:TableCell>
                        <asp:TableCell runat="server" Width="4cm">
                        <asp:DropDownList ID="dll_equipment" runat="server" Width="4cm" DataSourceID="SqlDataSource5" DataTextField="eq_name" DataValueField="eq_name" AutoPostBack="True">
                            </asp:DropDownList>
                     <asp:SqlDataSource ID="SqlDataSource5" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>" SelectCommand="SELECT [eq_name] FROM [OA_UNIT_DETAIL] WHERE ([eq_type] = @eq_type)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="dll_type" Name="eq_type" PropertyName="SelectedValue"
                            Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                            </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server" HorizontalAlign="Center" VerticalAlign="Middle">
                        <asp:TableCell runat="server" Width="2cm">维修厂商</asp:TableCell>
                        <asp:TableCell runat="server" ColumnSpan="3" HorizontalAlign="Left">
                         <asp:DropDownList ID="dll_company" runat="server" Width="6cm" DataSourceID="SqlDataSource6" DataTextField="company" DataValueField="id">
                            </asp:DropDownList>
                     <asp:SqlDataSource ID="SqlDataSource6" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>" SelectCommand="SELECT [id], [company] FROM [oa_company] WHERE ([equipment] = @equipment)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="dll_type" Name="equipment" PropertyName="SelectedValue"
                            Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
                            </asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server" HorizontalAlign="Center" VerticalAlign="Middle">
                        <asp:TableCell runat="server" Width="2cm">问题描述</asp:TableCell>
                        <asp:TableCell runat="server" ColumnSpan="3" HorizontalAlign="Left">
                        <table>
                        <tr>
                        <td>
                         <asp:DropDownList ID="dll_question" runat="server" Width="6cm" DataSourceID="SqlDataSource7" DataTextField="question" DataValueField="question" OnSelectedIndexChanged="dll_question_SelectedIndexChanged1" AutoPostBack="True">
                            </asp:DropDownList></td>
                        </tr>
                        <tr>
                        <td> 
                       <asp:TextBox ID="comment" runat="server" Width="10cm" Rows="5" TextMode="MultiLine"></asp:TextBox>
                        </td>
                        </tr>
                        </table>
                     <asp:SqlDataSource ID="SqlDataSource7" runat="server" ConnectionString="<%$ ConnectionStrings:oa1ConnectionString %>" SelectCommand="SELECT [question] FROM [OA_UNIT_QUESTION] WHERE ([equipment] = @equipment)">
                    <SelectParameters>
                        <asp:ControlParameter ControlID="dll_equipment" Name="equipment" PropertyName="SelectedValue"
                            Type="String" />
                    </SelectParameters>
                </asp:SqlDataSource>
</asp:TableCell>
                    </asp:TableRow>
                    <asp:TableRow runat="server">
                        <asp:TableCell runat="server" ColumnSpan="4" HorizontalAlign="Center" VerticalAlign="Middle">
                            <asp:Button ID="bovk" runat="server" Text="确定" OnClick="Button1_Click"/></asp:TableCell>
                    </asp:TableRow>
                </asp:Table>
                &nbsp;&nbsp;&nbsp;&nbsp;
            </asp:View>
        </asp:MultiView></div>
        </center>
    </form>
</body>
</html>

						