order_add.aspx

OA系统,数据库为SQLSever 。net c#

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="Order_Add.aspx.cs" Inherits="OrderInfo_Order_Add" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width: 650px; height: 500px">
        <tr>
            <td colspan="3" rowspan="1" style="height: 50px; background-color: #ffffcc">
                <span style="font-size: 24pt; font-family: 楷体_GB2312">
                    <asp:Label ID="lblDept" runat="server"></asp:Label>订单添加</span></td>
        </tr>
        <tr>
            <td colspan="3" rowspan="1" style="height: 200px">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=ADIR;Initial Catalog=OfficeOnline;User ID=sa;Password=93626wenbo"
                    ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Client_CompanyName], [Client_ID] FROM [z_Client]">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="Data Source=ADIR;Initial Catalog=OfficeOnline;User ID=sa;Password=93626wenbo"
                    ProviderName="System.Data.SqlClient" SelectCommand="SELECT [Product_ID], [Product_Name] FROM [z_Product]">
                </asp:SqlDataSource>
                <table style="border-right: black 1px solid; border-top: black 1px solid; border-left: black 1px solid;
                    width: 550px; border-bottom: black 1px solid">
                    <tr>
                        <td style="border-right: black 1px solid; width: 150px; border-bottom: black 1px solid;
                            text-align: right">
                            客户公司名：</td>
                        <td colspan="2" style="width: 400px; border-bottom: black 1px solid; text-align: left">
                            <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
                                DataTextField="Client_CompanyName" DataValueField="Client_ID">
                            </asp:DropDownList>
                        </td>
                    </tr>
                    <tr>
                        <td style="border-right: black 1px solid; width: 150px; border-bottom: black 1px solid;
                            text-align: right">
                            产品名：</td>
                        <td colspan="2" style="width: 400px; border-bottom: black 1px solid; text-align: left">
                            <asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
                                DataTextField="Product_Name" DataValueField="Product_ID">
                            </asp:DropDownList></td>
                    </tr>
                    <tr>
                        <td style="border-right: black 1px solid; width: 150px; border-bottom: black 1px solid;
                            text-align: right">
                            件数：</td>
                        <td colspan="2" style="width: 400px; border-bottom: black 1px solid; text-align: left">
                            <asp:TextBox ID="tbNum" runat="server" Width="20px"></asp:TextBox></td>
                    </tr>
                </table>
                <asp:Label ID="lblMsg" runat="server" ForeColor="Red"></asp:Label></td>
        </tr>
        <tr>
            <td colspan="3" rowspan="3" style="height: 50px">
                <asp:Button ID="btnSubmit" runat="server" OnClick="btnSubmit_Click" Text="提交" />
                <asp:Button ID="btnCancel" runat="server" Text="取消" OnClick="btnCancel_Click" /></td>
        </tr>
        <tr>
        </tr>
        <tr>
        </tr>
    </table>
</asp:Content>