📄 list.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="list.aspx.cs" Inherits="kehufuwu_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>
<link href="../StyleSheet1.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None"
BorderWidth="1px" CellPadding="3" DataKeyNames="ID" DataSourceID="SqlDataSource1"
GridLines="Horizontal" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
Style="color: white;">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C"/>
<Columns>
<asp:BoundField DataField="ID" HeaderText="退货订单编号" ReadOnly="True" SortExpression="ID" >
<ItemStyle Width="75px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="thrq" HeaderText="提货日期" SortExpression="thrq" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="thjs" HeaderText="提货件数" SortExpression="thjs" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="thr" HeaderText="提货人" SortExpression="thr" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="thfs" HeaderText="提货方式" SortExpression="thfs" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="hygs" HeaderText="货运公司" SortExpression="hygs" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="ddyfje" HeaderText="代垫运费金额" SortExpression="ddyfje" >
<ItemStyle Width="75px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="khdq" HeaderText="客户地区" SortExpression="khdq" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="qdsj" HeaderText="清点时间" SortExpression="qdsj" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="qdr" HeaderText="清点人" SortExpression="qdr" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="qdjs" HeaderText="清点件数" SortExpression="qdjs" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="bzsm" HeaderText="备注说明" SortExpression="bzsm" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="jdrq" HeaderText="交单日期" SortExpression="jdrq" >
<ItemStyle Width="50px" Wrap="False" />
</asp:BoundField>
<asp:HyperLinkField DataNavigateUrlFields="ID" DataNavigateUrlFormatString="tiandan.aspx?ID={0}"
DataTextField="ID" DataTextFormatString="进入" HeaderText="客户部填写">
<ItemStyle Width="75px" Wrap="False" />
<HeaderStyle BackColor="White" />
</asp:HyperLinkField>
</Columns>
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:tdgzConnectionString10 %>"
SelectCommand="SELECT * FROM [tuihuoguanli] WHERE (([jdrq] NOT LIKE '%' + @jdrq + '%') AND ([qdjs] = @qdjs) AND ([qdsj] NOT LIKE '%' + @qdsj + '%')) ORDER BY [ID]">
<SelectParameters>
<asp:Parameter DefaultValue="20" Name="jdrq" Type="String" />
<asp:Parameter DefaultValue="0" Name="qdjs" Type="Int32" />
<asp:Parameter DefaultValue="20" Name="qdsj" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -