📄 employeeorders.aspx

📁 基于sqlserver2k,reporting service的扩展(auth,render,deliver==)应用（mssql,RS,AS,BI）
💻 ASPX
字号:
<%@ Page Language="c#" AutoEventWireup="false" Codebehind="EmployeeOrders.aspx.cs" Inherits="AWC.Reporter.Web.EmployeeOrders" %>
<HTML>
	<HEAD>
		<META http-equiv="Content-Type" content="text/html; charset=windows-1252">
		<meta content="Microsoft Visual Studio.NET 7.0" name="GENERATOR">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="Internet Explorer 5.0" name="vs_targetSchema">
		<STYLE type="text/css"> 
			BODY {background:#FBFBFB; font-family:Verdana; } 
			A:link {color:blue;text-decoration:none} 
			A:active {color:red;text-decoration:none} 
			A:visited {color:blue;text-decoration:none} 
		</STYLE>		
		<script language=javascript>
		<!--
		function requestReport(salesOrderNumber)
		{
			window.open("http://192.168.1.204/reportserver?/AWReporter/Sales Order Detail&SalesOrderNumber=" + salesOrderNumber + "&rc:Parameters=false&rs:Command=Render", "_blank", "location=no,toolbar=no,left=100,top=100,height=600,width=800")
		}
		//-->
		</script>
		
	</HEAD>
	<body FONT-FAMILY:Verdana>
		<form id="WebForm1" method="post" runat="server">
			<P></P>
			<H1><FONT color="#000099">Salesperson&nbsp;Orders</FONT>&nbsp;
			</H1>
			<P></P>
			<P><asp:panel id="Panel1" runat="server" Width="600px" BorderStyle="Groove">
					<TABLE cellSpacing="0" cellPadding="1" width="100%" border="0">
						<TR>
							<TD width="116" height="23">&nbsp;
								<asp:label id="lblSalesPerson" runat="server" Font-Size="8pt">Salesperson: </asp:label></TD>
							<TD height="23">
								<asp:DropDownList id="drpSalesPerson" runat="server" AutoPostBack="True" DataTextField="Employee"
									DataValueField="EmployeeID"></asp:DropDownList></TD>
						</TR>
					</TABLE>
				</asp:panel></P>
			<P></P>
			<asp:datagrid id="grdOrders" runat="server" BorderStyle="Solid" width="600px" NAME="grdOrders"
				Font-Name="Verdana" Font-Size="8pt" AllowSorting="True" font-names="Verdana" AutoGenerateColumns="False"
				BackColor="White" BorderWidth="1px" BorderColor="Tan" CellPadding="2" EnableViewState="False">
				<AlternatingItemStyle BackColor="Beige"></AlternatingItemStyle>
				<ItemStyle ForeColor="DarkSlateBlue"></ItemStyle>
				<HeaderStyle Font-Bold="True" ForeColor="White" BackColor="DarkRed"></HeaderStyle>
				<Columns>
					<asp:BoundColumn DataField="OrderDate" ReadOnly="True" HeaderText="Order Date" DataFormatString="{0:d}">
						<HeaderStyle Width="80px"></HeaderStyle>
						<ItemStyle Wrap="False"></ItemStyle>
					</asp:BoundColumn>
					<asp:BoundColumn DataField="SalesOrderNumber" ReadOnly="True" HeaderText="Order #">
						<HeaderStyle Width="90px"></HeaderStyle>
						<ItemStyle Wrap="False"></ItemStyle>
					</asp:BoundColumn>
					<asp:BoundColumn DataField="Store" ReadOnly="True" HeaderText="Store">
						<HeaderStyle Width="90px"></HeaderStyle>
						<ItemStyle Wrap="False"></ItemStyle>
					</asp:BoundColumn>
					<asp:BoundColumn DataField="SubTotal" ReadOnly="True" HeaderText="Sub Total" DataFormatString="{0:C}">
						<HeaderStyle Width="100px"></HeaderStyle>
					</asp:BoundColumn>
					<asp:TemplateColumn HeaderText="Details">
						<ItemStyle HorizontalAlign="Left"></ItemStyle>
						<ItemTemplate>
							<a href="#" onclick="javascript:requestReport('<%#DataBinder.Eval(Container.DataItem,"SalesOrderNumber") %>');">Details</a>
						</ItemTemplate>
					</asp:TemplateColumn>					
				</Columns>
				<PagerStyle Mode="NumericPages"></PagerStyle>
			</asp:datagrid></form>
	</body>
</HTML>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -