OA系统

开发平台：
ASP/ASPX

pos_add_show.aspx：源码内容
							﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="pos_add_show.aspx.cs" Inherits="web_pos_pos_add_show" %>
<!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>pos連接地址管理</title>
</head>
<body>
    <form id="form1" runat="server">
    
    <div>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:oaConnection %>"
            SelectCommand="SELECT [id], [name], [url], [internal_url] FROM [OA_POS_URL]" DeleteCommand="DELETE FROM [OA_POS_URL] WHERE [id] = @original_id AND [name] = @original_name AND [url] = @original_url AND [internal_url] = @original_internal_url" InsertCommand="INSERT INTO [OA_POS_URL] ([name], [url], [internal_url]) VALUES (@name, @url, @internal_url)" UpdateCommand="UPDATE [OA_POS_URL] SET [name] = @name, [url] = @url, [internal_url] = @internal_url WHERE [id] = @original_id AND [name] = @original_name AND [url] = @original_url AND [internal_url] = @original_internal_url" ConflictDetection="CompareAllValues" OldValuesParameterFormatString="original_{0}">
            <DeleteParameters>
                <asp:Parameter Name="original_id" Type="Int32" />
                <asp:Parameter Name="original_name" Type="String" />
                <asp:Parameter Name="original_url" Type="String" />
                <asp:Parameter Name="original_internal_url" Type="String" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="url" Type="String" />
                <asp:Parameter Name="internal_url" Type="String" />
                <asp:Parameter Name="original_id" Type="Int32" />
                <asp:Parameter Name="original_name" Type="String" />
                <asp:Parameter Name="original_url" Type="String" />
                <asp:Parameter Name="original_internal_url" Type="String" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="name" Type="String" />
                <asp:Parameter Name="url" Type="String" />
                <asp:Parameter Name="internal_url" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
        &nbsp; &nbsp;
        <center>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
            AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="None"
            BorderWidth="1px" CellPadding="3" DataKeyNames="id" DataSourceID="SqlDataSource1"
            GridLines="Vertical" CaptionAlign="Right" Width="591px">
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
                    SortExpression="id" Visible="False" />
                <asp:BoundField DataField="name" HeaderText="名称" SortExpression="name" />
                <asp:BoundField DataField="url" HeaderText="内部网址" SortExpression="url" />
                <asp:BoundField DataField="internal_url" HeaderText="外部网址" SortExpression="internal_url" />
            </Columns>
            <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
            <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="Gainsboro" />
        </asp:GridView>
            &nbsp;</center>
        <center>
        </center>
     
        <table align="center" border="0" height="20" style="width: 587px">
            <tr>
                <td style="width: 258px; height: 1px">
                    <span class="STYLE1" style="font-size: 30px; text-transform: uppercase; color: #000099;
                        font-family: 隶书">新增門店地址</span></td>
            </tr>
            <tr>
                <td style="width: 258px; height: auto">
                    &nbsp;門店名稱： &nbsp;
                    <asp:TextBox ID="name" runat="server" Width="239px"></asp:TextBox></td>
            </tr>
            <tr>
                <td style="width: 258px; height: 45px;">
                    &nbsp;外部地址： &nbsp;
                    <asp:TextBox ID="url" runat="server" Width="238px"></asp:TextBox></td>
            </tr>
            <tr>
                <td style="width: 258px; height: 28px">
                    &nbsp;內部地址： &nbsp;
                    <asp:TextBox ID="internal_url" runat="server" Width="237px"></asp:TextBox></td>
            </tr>
            <tr>
                <td style="width: 258px">
                    <asp:Button ID="btn_ok" runat="server" OnClick="btn_ok_Click" Text="新增" />
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

						