📄 yhdacx.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="yhdacx.aspx.cs" Inherits="main" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>小天鹅零售采集系统</title>
<script type="text/javascript" src="popcalendar.js"></script>
<link href="Styles.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align: center">
<table border="0" cellpadding="0" cellspacing="0" style="width: 800px">
<tr>
<td colspan="3" style="height: 63px; background-image: url(images/TopHead.jpg);">
</td>
</tr>
<tr>
<td style="width: 94px; height: 97px; background-image: url(images/Edit_TopLeft.jpg);">
</td>
<td style="width: 618px; height: 97px; background-image: url(images/Edit_TopBG.jpg);">
</td>
<td style="width: 88px; height: 97px; background-image: url(images/Edit_Topright.jpg);">
</td>
</tr>
<tr>
<td style="width: 94px; background-image: url(images/Edit_LeftBG.jpg);">
</td>
<td style="width: 618px">
<table border="0" cellpadding="0" cellspacing="0" style="width: 618px; height: 100%">
<tr>
<td style="width: 618px; height: 123px;">
<table border="0" cellpadding="0" cellspacing="0" style="width: 100%; height: 100%">
<tr>
<td style="width: 103px">
<asp:CheckBox ID="CheckBox1" runat="server" Text="流水号" /></td>
<td style="width: 103px">
<asp:CheckBox ID="CheckBox2" runat="server" Text="姓名" /></td>
<td style="width: 103px">
<asp:CheckBox ID="CheckBox3" runat="server" Text="管理部" /></td>
<td style="width: 103px">
<asp:CheckBox ID="CheckBox4" runat="server" Text="城市" /></td>
<td style="width: 103px">
<asp:CheckBox ID="CheckBox5" runat="server" Text="网点号" /></td>
<td style="width: 103px">
<asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" /></td>
</tr>
<tr>
<td style="width: 103px">
<asp:TextBox ID="TextBox1" runat="server" Width="100%"></asp:TextBox></td>
<td style="width: 103px">
<asp:TextBox ID="TextBox2" runat="server" Width="100%"></asp:TextBox></td>
<td style="width: 103px">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1"
DataTextField="F_GLBMC" DataValueField="F_GLB" Width="100%">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:yhdaselect %>"
SelectCommand="SELECT [F_GLB], [F_GLBMC] FROM [T_GLB]"></asp:SqlDataSource>
</td>
<td style="width: 103px">
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
DataTextField="F_City" DataValueField="F_City" Width="100%">
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:yhdaselect %>"
SelectCommand="SELECT [F_City] FROM [T_City] WHERE ([F_GLB] = @F_GLB)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="F_GLB" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</td>
<td style="width: 103px">
<asp:TextBox ID="TextBox3" runat="server" Width="100%"></asp:TextBox></td>
<td style="width: 103px">
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="返回" /></td>
</tr>
<tr>
<td colspan="6">
<asp:Label ID="Label1" runat="server" Width="80%"></asp:Label></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="width: 100px">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
CellPadding="4" DataKeyNames="F_ID" DataSourceID="SqlDataSource3" ForeColor="#333333"
GridLines="None" Width="620px">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="F_ID" HeaderText="流水号" InsertVisible="False" ReadOnly="True"
SortExpression="F_ID">
<ControlStyle Width="80px" />
<HeaderStyle Width="80px" />
<ItemStyle Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="F_YHXM" HeaderText="姓名" SortExpression="F_YHXM">
<ControlStyle Width="80px" />
<HeaderStyle Width="80px" />
<ItemStyle Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="F_DZ" HeaderText="地址" SortExpression="F_DZ">
<ControlStyle Width="138px" />
<HeaderStyle Width="138px" />
<ItemStyle Width="138px" />
</asp:BoundField>
<asp:BoundField DataField="F_LXDH" HeaderText="联系电话" SortExpression="F_LXDH">
<ControlStyle Width="80px" />
<HeaderStyle Width="80px" />
<ItemStyle Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="F_GLB" HeaderText="管理部" SortExpression="F_GLB">
<ControlStyle Width="80px" />
<HeaderStyle Width="80px" />
<ItemStyle Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="F_CITY" HeaderText="城市" SortExpression="F_CITY">
<ControlStyle Width="80px" />
<HeaderStyle Width="80px" />
<ItemStyle Width="80px" />
</asp:BoundField>
<asp:BoundField DataField="F_CPXH" HeaderText="型号" SortExpression="F_CPXH">
<ControlStyle Width="80px" />
<HeaderStyle Width="80px" />
<ItemStyle Width="80px" />
</asp:BoundField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:yhdaselect %>"
SelectCommand="SELECT top 1 [F_ID], [F_YHXM], [F_DZ], [F_LXDH], [F_GLB], [F_CITY], [F_CPXH] FROM [T_YHDA] ORDER BY [F_ID] DESC ">
</asp:SqlDataSource>
</td>
</tr>
</table>
</td>
<td style="width: 88px; background-image: url(images/Edit_RightBG.jpg);">
</td>
</tr>
<tr>
<td style="width: 94px; height: 24px; background-image: url(images/Edit_BotLeft.jpg);">
</td>
<td style="width: 618px;height: 24px; background-image: url(images/Edit_BotBG.jpg);">
</td>
<td style="width: 88px;height: 24px; background-image: url(images/Edit_BotRight.jpg);">
</td>
</tr>
</table>
<tr>
<td colspan="9">
</td>
</tr>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -