Part 7: Adding Features 添加功能
Tailspin Spyworks demonstrates how extraordinarily simple it is to create powerful, scalable applications for the .NET platform. It shows off how to use the great new features in ASP.NET 4 to build an online store, including shopping, checkout, and administration.
通过Tailspin Spyworks 演示在.NET平台创建功能强大，结构良好的应用程序有多么简单。演示如何使用ASP.NET 4的新特性创建一个包含购物、结算和管理功能的在线网店。
This tutorial series details all of the steps taken to build the Tailspin Spyworks sample application. Part 7 adds additional features, such as account review, product reviews, and "popular items" and "also purchased" user controls.
本系列指南对构建案例程序的每一步做了详细的解释。第七部分添加账户查看、产品评论、畅销产品、一并购买等功能。
添加功能
Though users can browse our catalog, place items in their shopping cart, and complete the checkout process, there are a number of supporting features that we will include to improve our site.
用户已经可以浏览产品类别、将产品放入购物车、完成结算流程，我们将添加一些增强功能改进我们的站点。
- Account Review (List orders placed and view details.)账户查看（列出订单、查看订单详情）
- Add some context specific content to the front page.在首页添加和上下文相关的内容
- Add a feature to let users Review the products in the catalog.添加评论类别中产品的功能
- Create a User Control to display Popular Items and Place that control on the front page.创建用户控件，显示畅销产品，显示到首页
- Create an "Also Purchased" user control and add it to the product details page.创建“一并购买”用户控件，添加到详情页
- Add a Contact Page.添加联系页面
- Add an About Page.添加关于页面
- Global Error 处理全局异常
账户查看
In the "Account" folder create two .aspx pages one named OrderList.aspx and the other named OrderDetails.aspx
在“Account”文件夹创建两个aspx页面，名为为OrderList.aspx和OrderDetails.aspx
OrderList.aspx will leverage the GridView and EntityDataSoure controls much as we have previously.
OrderList.aspx将象之前一样利用GridView和EntityDataSource控件来实现。
<div class="ContentHead">Order History</div><br /> <asp:GridView ID="GridView_OrderList" runat="server" AllowPaging="True" ForeColor="#333333" GridLines="None" CellPadding="4" Width="100%" AutoGenerateColumns="False" DataKeyNames="OrderID" DataSourceID="EDS_Orders" AllowSorting="True" ViewStateMode="Disabled" > <AlternatingRowStyle BackColor="White" /> <Columns> <asp:BoundField DataField="OrderID" HeaderText="OrderID" ReadOnly="True" SortExpression="OrderID" /> <asp:BoundField DataField="CustomerName" HeaderText="Customer" SortExpression="CustomerName" /> <asp:BoundField DataField="OrderDate" HeaderText="Order Date" SortExpression="OrderDate" /> <asp:BoundField DataField="ShipDate" HeaderText="Ship Date" SortExpression="ShipDate" /> <asp:HyperLinkField HeaderText="Show Details" Text="Show Details" DataNavigateUrlFields="OrderID" DataNavigateUrlFormatString="~/Account/OrderDetails.aspx?OrderID={0}" /> </Columns> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /> <RowStyle BackColor="#FFFBD6" ForeColor="#333333" /> <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" /> <SortedAscendingCellStyle BackColor="#FDF5AC" /> <SortedAscendingHeaderStyle BackColor="#4D0000" /> <SortedDescendingCellStyle BackColor="#FCF6C0" /> <SortedDescendingHeaderStyle BackColor="#820000" /> <SortedAscendingCellStyle BackColor="#FDF5AC"></SortedAscendingCellStyle> <SortedAscendingHeaderStyle BackColor="#4D0000"></SortedAscendingHeaderStyle> <SortedDescendingCellStyle BackColor="#FCF6C0"></SortedDescendingCellStyle> <SortedDescendingHeaderStyle BackColor="#820000"></SortedDescendingHeaderStyle> </asp:GridView> <asp:EntityDataSource ID="EDS_Orders" runat="server" EnableFlattening="False" AutoGenerateWhereClause="True" Where="" OrderBy="it.OrderDate DESC" ConnectionString="name=CommerceEntities" DefaultContainerName="CommerceEntities" EntitySetName="Orders" > <WhereParameters> <asp:SessionParameter Name="CustomerName" SessionField="UserName" /> </WhereParameters> </asp:EntityDataSource>
The EntityDataSoure selects records from the Orders table filtered on the UserName (see the WhereParameter) which we set in a session variable when the user log's in.
EntityDataSource根据用户登录后在session变量中存储的UserName（WhereParameter参数）从Order表检索出相应的记录。
Note also these parameters in the HyperlinkField of the GridView:
也请注意GridView超链接字段的参数：
DataNavigateUrlFields="OrderID" DataNavigateUrlFormatString="~/Account/OrderDetails.aspx?OrderID={0}"
These specify the link to the Order details view for each product specifying the OrderID field as a QueryString parameter to the OrderDetails.aspx page.
添加超链接指向OrderDetails.aspx。
OrderDetails.aspx
We will use an EntityDataSource control to access the Orders and a FormView to display the Order data and another EntityDataSource with a GridView to display all the Order's line items.
使用一个EntityDataSource和FormView显示订单数据，使用另一个EntityDataSource和GridView显示详情记录。
<asp:FormView ID="FormView1" runat="server" CellPadding="4" DataKeyNames="OrderID" DataSourceID="EDS_Order" ForeColor="#333333" Width="250px"> <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" /> <ItemTemplate> OrderID : <%# Eval("OrderID") %><br /> CustomerName : <%# Eval("CustomerName") %><br /> Order Date : <%# Eval("OrderDate") %><br /> Ship Date : <%# Eval("ShipDate") %><br /> </ItemTemplate> <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" /> <RowStyle BackColor="#FFFBD6" ForeColor="#333333" /> </asp:FormView> <asp:EntityDataSource ID="EDS_Order" runat="server" EnableFlattening="False" ConnectionString="name=CommerceEntities" DefaultContainerName="CommerceEntities" EntitySetName="Orders" AutoGenerateWhereClause="True" Where="" EntityTypeFilter="" Select=""> <WhereParameters> <asp:QueryStringParameter Name="OrderID" QueryStringField="OrderID" Type="Int32" /> </WhereParameters> </asp:EntityDataSource> <asp:GridView ID="GridView_OrderDetails" runat="server" AutoGenerateColumns="False" DataKeyNames="ProductID,UnitCost,Quantity" DataSourceID="EDS_OrderDetails" CellPadding="4" GridLines="Vertical" CssClass="CartListItem" onrowdatabound="MyList_RowDataBound" ShowFooter="True" ViewStateMode="Disabled"> <AlternatingRowStyle CssClass="CartListItemAlt" /> <Columns> <asp:BoundField DataField="ProductID" HeaderText="Product ID" ReadOnly="True" SortExpression="ProductID" /> <asp:BoundField DataField="ModelNumber" HeaderText="Model Number" SortExpression="ModelNumber" /> <asp:BoundField DataField="ModelName" HeaderText="Model Name" SortExpression="ModelName" /> <asp:BoundField DataField="UnitCost" HeaderText="Unit Cost" ReadOnly="True" SortExpression="UnitCost" DataFormatString="{0:c}" /> <asp:BoundField DataField="Quantity" HeaderText="Quantity" ReadOnly="True" SortExpression="Quantity" /> <asp:TemplateField> <HeaderTemplate>Item Total</HeaderTemplate> <ItemTemplate> <%# (Convert.ToDouble(Eval("Quantity")) * Convert.ToDouble(Eval("UnitCost")))%> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle CssClass="CartListFooter"/> <HeaderStyle CssClass="CartListHead" /> </asp:GridView> <asp:EntityDataSource ID="EDS_OrderDetails" runat="server" ConnectionString="name=CommerceEntities" DefaultContainerName="CommerceEntities" EnableFlattening="False" EntitySetName="VewOrderDetails" AutoGenerateWhereClause="True" Where=""> <WhereParameters> <asp:QueryStringParameter Name="OrderID" QueryStringField="OrderID" Type="Int32" /> </WhereParameters> </asp:EntityDataSource>
In the Code Behind file (OrderDetails.aspx.cs) we have two little bits of housekeeping.
在代码文件（OrderDetails.aspx.cs）有两个小功能。
First we need to make sure that OrderDetails always gets an OrderId.
首先，确保OrderDetails总是能获取OrderId。
protected void Page_Load(object sender, EventArgs e) { if (String.IsNullOrEmpty(Request.QueryString["OrderId"])) { Response.Redirect("~/Account/OrderList.aspx"); } }
We also need to calculate and display the order total from the line items.
还需要计算并显示订单总金额。
decimal _CartTotal = 0; protected void MyList_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { TailspinSpyworks.Data_Access.VewOrderDetail myCart = new Data_Access.VewOrderDetail(); myCart = (TailspinSpyworks.Data_Access.VewOrderDetail)e.Row.DataItem; _CartTotal += Convert.ToDecimal(myCart.UnitCost * myCart.Quantity); } else if (e.Row.RowType == DataControlRowType.Footer) { e.Row.Cells[5].Text = "Total: " + _CartTotal.ToString("C"); } }
首页
Let's add some static content to the Default.aspx page.
我们在Default.aspx页面添加一些静态内容。
First I'll create a "Content" folder and within it an Images folder (and I'll include an image to be used on the home page.)
首先创建“Content” 文件夹，再在其中创建“Images”文件夹
Into the bottom placeholder of the Default.aspx page, add the following markup.
在页面占位符下方添加如下标记：
<h2> <asp:LoginView ID="LoginView_VisitorGreeting" runat="server"> <AnonymousTemplate> Welcome to the Store ! </AnonymousTemplate> <LoggedInTemplate> Hi <asp:LoginName ID="LoginName_Welcome" runat="server" />. Thanks for coming back. </LoggedInTemplate> </asp:LoginView> </h2> <p><strong>TailSpin Spyworks</strong> demonstrates how extraordinarily simple it is to create powerful, scalable applications for the .NET platform. </p> <table> <tr> <td> <h3>Some Implementation Features.</h3> <ul> <li><a href="#">CSS Based Design.</a></li> <li><a href="#">Data Access via Linq to Entities.</a></li> <li><a href="#">MasterPage driven design.</a></li> <li><a href="#">Modern ASP.NET Controls User.</a></li> <li><a href="#">Integrated Ajac Control Toolkit Editor.</a></li> </ul> </td> <td> <img src="Content/Images/SampleProductImage.gif" alt=""/> </td> </tr> </table> <table> <tr> <td colspan="2"><hr /></td> </tr> <tr> <td> <!-- Popular Items --> </td> <td> <center><h3>Ecommerce the .NET 4 Way</h3></center> <blockquote> <p> ASP.NET offers web developers the benefit of more that a decade of innovation. This demo leverages many of the latest features of ASP.NET development to illustrate really simply building rich web applications with ASP.NET can be. For more information about build web applications with ASP.NET please visit the community web site at www.asp.net </p> </blockquote> </td> </tr> </table> <h3>Spyworks Event Calendar</h3> <table> <tr class="rowH"> <th>Date</th> <th>Title</th> <th>Description</th> </tr> <tr class="rowA"> <td>June 01, 2011</td> <td>Sed vestibulum blandit</td> <td> Come and check out demos of all the newest Tailspin Spyworks products and experience them hands on. </td> </tr> <tr class="rowB"> <td>November 28, 2011</td> <td>Spyworks Product Demo</td> <td> Come and check out demos of all the newest Tailspin Spyworks products and experience them hands on. </td> </tr> <tr class="rowA"> <td>November 23, 2011</td> <td>Spyworks Product Demo</td> <td> Come and check out demos of all the newest Tailspin Spyworks products and experience them hands on. </td> </tr> <tr class="rowB"> <td>November 21, 2011</td> <td>Spyworks Product Demo</td> <td> Come and check out demos of all the newest Tailspin Spyworks products and experience them hands on. </td> </tr> </table>
产品查看
First we'll add a button with a link to a form that we can use to enter a product review.
首先在表单中添加一个链接按钮，链接到产品评论页面。
<div class="SubContentHead">Reviews</div><br /> <a id="ReviewList_AddReview" href="ReviewAdd.aspx?productID=<%# Eval("ProductID") %>"> <img id="Img2" runat="server" src="~/Styles/Images/review_this_product.gif" alt="" /> </a>
Note that we are passing the ProductID in the query string
注意在查询字符串中传递了ProductID
Next let's add page named ReviewAdd.aspx
添加名为ReviewAdd.aspx的页面
This page will use the ASP.NET AJAC Control Toolkit. If you have not already done so you can download it from here http://ajaxcontroltoolkit.codeplex.com/ and there is guidance on setting up the toolkit for use with Visual Studio here http://www.asp.net/learn/ajax-videos/video-76.aspx.
本页面将使用ASP.NET AJAX控件工具包。可从http://ajaxcontroltoolkit.codeplex.com/下载。
In design mode, drag controls and validators from the toolbox and build a form like the one below.
在设计模式，从工具栏拖拽控件和验证器，构建如下表单：
The markup will look something like this.
标记内容如下：
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"> </asp:ToolkitScriptManager> <div class="ContentHead">Add Review - <asp:label id="ModelName" runat="server" /></div> <div> <span class="NormalBold">Name</span><br /> <asp:TextBox id="Name" runat="server" Width="400px" /><br /> <asp:RequiredFieldValidator runat="server" id="RequiredFieldValidator1" ControlToValidate="Name" Display="Dynamic" CssClass="ValidationError" ErrorMessage="'Name' must not be left blank." /><br /> <span class="NormalBold">Email</span><br /> <asp:TextBox id="Email" runat="server" Width="400px" /><br /> <asp:RequiredFieldValidator runat="server" id="RequiredFieldValidator2" ControlToValidate="Email" Display="Dynamic" CssClass="ValidationError" ErrorMessage="'Email' must not be left blank." /> <br /><hr /><br /> <span class="NormalBold">Rating</span><br /><br /> <asp:RadioButtonList ID="Rating" runat="server"> <asp:ListItem value="5" selected="True" Text='<img src="Styles/Images/reviewrating5.gif" alt=""> (Five Stars) ' /> <asp:ListItem value="4" selected="True" Text='<img src="Styles/Images/reviewrating4.gif" alt=""> (Four Stars) ' /> <asp:ListItem value="3" selected="True" Text='<img src="Styles/Images/reviewrating3.gif" alt=""> (Three Stars) ' /> <asp:ListItem value="2" selected="True" Text='<img src="Styles/Images/reviewrating2.gif" alt=""> (Two Stars) ' /> <asp:ListItem value="1" selected="True" Text='<img src="Styles/Images/reviewrating1.gif" alt=""> (One Stars) ' /> </asp:RadioButtonList> <br /><hr /><br /> <span class="NormalBold">Comments</span><br /> <cc1:Editor ID="UserComment" runat="server" /> <asp:RequiredFieldValidator runat="server" id="RequiredFieldValidator3" ControlToValidate="UserComment" Display="Dynamic" CssClass="ValidationError" ErrorMessage="Please enter your comment." /><br /><br /> <asp:ImageButton ImageURL="Styles/Images/submit.gif" runat="server" id="ReviewAddBtn" onclick="ReviewAddBtn_Click" /> <br /><br /><br /> </div>
Now that we can enter reviews, lets display those reviews on the product page.
现在可进入评论，让我们在产品页面显示评论。
Add this markup to the ProductDetails.aspx page.
在ProductDetails.aspx页面添加如下标记：
<asp:ListView ID="ListView_Comments" runat="server" DataKeyNames="ReviewID,ProductID,Rating" DataSourceID="EDS_CommentsList"> <ItemTemplate> <tr> <td><%# Eval("CustomerName") %></td> <td> <img src='Styles/Images/ReviewRating_d<%# Eval("Rating") %>.gif' alt=""> <br /> </td> <td> <%# Eval("Comments") %> </td> </tr> </ItemTemplate> <AlternatingItemTemplate> <tr> <td><%# Eval("CustomerName") %></td> <td> <img src='Styles/Images/ReviewRating_da<%# Eval("Rating") %>.gif' alt=""> <br /> </td> <td><%# Eval("Comments") %></td> </tr> </AlternatingItemTemplate> <EmptyDataTemplate> <table runat="server"> <tr><td>There are no reviews yet for this product.</td></tr> </table> </EmptyDataTemplate> <LayoutTemplate> <table runat="server"> <tr runat="server"> <td runat="server"> <table ID="itemPlaceholderContainer" runat="server" border="1"> <tr runat="server"> <th runat="server">Customer</th> <th runat="server">Rating</th> <th runat="server">Comments</th> </tr> <tr ID="itemPlaceholder" runat="server"></tr> </table> </td> </tr> <tr runat="server"> <td runat="server"> <asp:DataPager ID="DataPager1" runat="server"> <Fields> <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" /> </Fields> </asp:DataPager> </td> </tr> </table> </LayoutTemplate> </asp:ListView> <asp:EntityDataSource ID="EDS_CommentsList" runat="server" EnableFlattening="False" AutoGenerateWhereClause="True" EntityTypeFilter="" Select="" Where="" ConnectionString="name=CommerceEntities" DefaultContainerName="CommerceEntities" EntitySetName="Reviews"> <WhereParameters> <asp:QueryStringParameter Name="ProductID" QueryStringField="productID" Type="Int32" /> </WhereParameters> </asp:EntityDataSource>
Running our application now and navigating to a product shows the product information including customer reviews.
运行并导航到产品页面，查看包含顾客评论的产品信息。
畅销产品（创建用户控件）
In order to increase sales on your web site we will add a couple of features to "suggestive sell" popular or related products.
为提升站点的销售量，我们将添加“建议购买”畅销货相关的产品功能。
The first of these features will be a list of the more popular product in our product catalog.
首先，在产品目录显示畅销产品。
We will create a "User Control" to display the top selling items on the home page of our application. Since this will be a control, we can use it on any page by simply dragging and dropping the control in Visual Studio's designer onto any page that we like.
我们将创建“用户控件”来显示销售量排名靠前的产品。做成控件的好处是，我们在任何需要此功能的页面通过设计模式下拖拽控件的方法就能完成。
In Visual Studio's solutions explorer, right-click on the solution name and create a new directory named "Controls". While it is not necessary to do so, we will help keep our project organized by creating all our user controls in the "Controls" directory.
在VS解决方案管理器，右击解决方案名，创建新的目录命名为“Controls”。
Right-click on the controls folder and choose "New Item" :
在“Controls”文件夹上右击选择“new Item“：
Specify a name for our control of "PopularItems". Note that the file extension for user controls is .ascx not .aspx.
指明控件的名字为”PopularItems“。注意用户控件的文件扩展名为.ascx而不是.aspx。
Our Popular Items User control will be defined as follows.
畅销产品用户控件的定义如下：
<%@ OutputCache Duration="3600" VaryByParam="None" %> <div class="MostPopularHead">Our most popular items this week</div> <div id="PanelPopularItems" runat="server"> <asp:Repeater ID="RepeaterItemsList" runat="server"> <HeaderTemplate></HeaderTemplate> <ItemTemplate> <a class='MostPopularItemText' href='ProductDetails.aspx?productID=<%# Eval("ProductId") %>'> <%# Eval("ModelName") %></a><br /> </ItemTemplate> <FooterTemplate></FooterTemplate> </asp:Repeater> </div>
Here we're using a method we have not used yet in this application. We're using the repeater control and instead of using a data source control we're binding the Repeater Control to the results of a LINQ to Entities query.
这里使用一个之前还没有使用过的方法。我们使用repeater控件并使用LINQ to Entities查询结果作为数据源，而不是使用数据源控件。
In the code behind of our control we do that as follows.
在控件代码部分，代码如下：
using TailspinSpyworks.Data_Access; protected void Page_Load(object sender, EventArgs e) { using (CommerceEntities db = new CommerceEntities()) { try { var query = (from ProductOrders in db.OrderDetails join SelectedProducts in db.Products on ProductOrders.ProductID equals SelectedProducts.ProductID group ProductOrders by new { ProductId = SelectedProducts.ProductID, ModelName = SelectedProducts.ModelName } into grp select new { ModelName = grp.Key.ModelName, ProductId = grp.Key.ProductId, Quantity = grp.Sum(o => o.Quantity) } into orderdgrp where orderdgrp.Quantity > 0 orderby orderdgrp.Quantity descending select orderdgrp).Take(5); RepeaterItemsList.DataSource = query; RepeaterItemsList.DataBind(); } catch (Exception exp) { throw new Exception("ERROR: Unable to Load Popular Items - " + exp.Message.ToString(), exp); } } }
Note also this important line at the top of our control's markup.
注意控件标记顶端重要的一行。
<%@ OutputCache Duration="3600" VaryByParam="None" %>
Since the most popular items won't be changing on a minute to minute basis we can add a aching directive to improve the performance of our application. This directive will cause the controls code to only be executed when the cached output of the control expires. Otherwise, the cached version of the control's output will be used.
由于最畅销商品在一分钟之内无需更新，我们可以使用缓存来改进程序的性能。此行代码的意思是如果缓存没有超出一分钟，无需重新执行代码而是直接使用缓存内容。
Now all we have to do is include our new control in our Default.aspc page.
现在我们只需要将创建好的控件放在Default.aspx页面就好了。
Use drag and drop to place an instance of the control in the open column of our Default form.
将控件拖放到适当位置。
Now when we run our application the home page displays the most popular items.
现在运行程序时，首页将显示畅销产品。
”一并购买“控件（带参数的用户控件）
The second User Control that we'll create will take suggestive selling to the next level by adding context specificity.
第二个用户控件将更进一步根据具体情境推荐购买产品。
The logic to calculate the top "Also Purchased" items is non-trivial.
先来搞清楚”一并购买“的计算逻辑。
Our "Also Purchased" control will select the OrderDetails records (previously purchased) for the currently selected ProductID and grab the OrderIDs for each unique order that is found.
”一并购买”控件将在OrderDetails表中搜索当前产品ID，并获取包含此产品ID的订单ID。
Then we will select al the products from all those Orders and sum the quantities purchased. We'll sort the products by that quantity sum and display the top five items.
然后检索出这些订单中购买的所有产品，并合并购买数量。排序选出购买量前五名。
Given the complexity of this logic, we will implement this algorithm as a stored procedure.
考虑到此逻辑的复杂性，我们使用存储过程来实现此算法。
The T-SQL for the stored procedure is as follows.
存储过程的T-SQL代码如下：
ALTER PROCEDURE dbo.SelectPurchasedWithProducts @ProductID int AS SELECT TOP 5 OrderDetails.ProductID, Products.ModelName, SUM(OrderDetails.Quantity) as TotalNum FROM OrderDetails INNER JOIN Products ON OrderDetails.ProductID = Products.ProductID WHERE OrderID IN ( /* This inner query should retrieve all orders that have contained the productID */ SELECT DISTINCT OrderID FROM OrderDetails WHERE ProductID = @ProductID ) AND OrderDetails.ProductID != @ProductID GROUP BY OrderDetails.ProductID, Products.ModelName ORDER BY TotalNum DESC RETURN
Note that this stored procedure (SelectPurchasedWithProducts) existed in the database when we included it in our application and when we generated the Entity Data Model we specified that, in addition to the Tables and Views that we needed, the Entity Data Model should include this stored procedure.
当我们从数据库创建实体数据模型时，应一并创建存储过程的映射。
To access the stored procedure from the Entity Data Model we need to import the function.
Double Click on the Entity Data Model in the Solutions Explorer to open it in the designer and open the Model Browser, then right-click in the designer and select "Add Function Import".
在解决方案管理器双击实体数据模型，打开设计器并打开模型浏览器，右击设计器选择“添加导入函数”
Doing so will open this dialog.
将打开如下对话框：
Fill out the fields as you see above, selecting the "SelectPurchasedWithProducts" and use the procedure name for the name of our imported function.
如上填写字段，选择“SelectPurchasedWithProducts”使用存储过程名作为导入函数的名字。
Click "Ok".
Having done this we can simply program against the stored procedure as we might any other item in the model.
此后我们科针对存储过程进行编程。
So, in our "Controls" folder create a new user control named AlsoPurchased.ascx.
在“Controls”文件夹创建一个名为AlsoPurchased.ascx的用户控件。
The markup for this control will look very familiar to the PopularItems control.
标记如下：
<div> <div class="MostPopularHead"> <asp:Label ID="LabelTitle" runat="server" Text=" Customers who bought this also bought:"></asp:Label></div> <div id="PanelAlsoBoughtItems" runat="server"> <asp:Repeater ID="RepeaterItemsList" runat="server"> <HeaderTemplate></HeaderTemplate> <ItemTemplate> <a class='MostPopularItemText' href='ProductDetails.aspx?productID=<%# Eval("ProductId") %>'><%# Eval("ModelName") %></a><br /> </ItemTemplate> <FooterTemplate></FooterTemplate> </asp:Repeater> </div> </div>
The notable difference is that are not caching the output since the item's to be rendered will differ by product.
值得注意的不同点是这里不再缓存输出数据，因为不同产品对应结果不同。
The ProductId will be a "property" to the control.
ProductId作为控件的一个“属性”。
private int _ProductId; public int ProductId { get { return _ProductId ; } set { _ProductId = Convert.ToInt32(value); } }
In the control's PreRender event handler we eed to do three things.
在控件的PreRender事件处理函数需要做三件事：
- Make sure the ProductID is set.确保设置了ProductID。
- See if there are any products that have been purchased with the current one.查看此商品是否被购买过。
- Output some items as determined in #2. 输出。
Note how easy it is to call the stored procedure through the model.
请注意通过模型调用存储过程非常简单。
//--------------------------------------------------------------------------------------+ protected void Page_PreRender(object sender, EventArgs e) { if (_ProductId < 1) { // This should never happen but we could expand the use of this control by reducing // the dependency on the query string by selecting a few RANDOME products here. Debug.Fail("ERROR : The Also Purchased Control Can not be used without setting the ProductId."); throw new Exception("ERROR : It is illegal to load the AlsoPurchased COntrol without setting a ProductId."); } int ProductCount = 0; using (CommerceEntities db = new CommerceEntities()) { try { var v = db.SelectPurchasedWithProducts(_ProductId); ProductCount = v.Count(); } catch (Exception exp) { throw new Exception("ERROR: Unable to Retrieve Also Purchased Items - " + exp.Message.ToString(), exp); } } if (ProductCount > 0) { WriteAlsoPurchased(_ProductId); } else { WritePopularItems(); } }
After determining that there ARE "also purchased" we can simply bind the repeater to the results returned by the query.
将获取到的结果绑定到Repeater。
//-------------------------------------------------------------------------------------+ private void WriteAlsoPurchased(int currentProduct) { using (CommerceEntities db = new CommerceEntities()) { try { var v = db.SelectPurchasedWithProducts(currentProduct); RepeaterItemsList.DataSource = v; RepeaterItemsList.DataBind(); } catch (Exception exp) { throw new Exception("ERROR: Unable to Write Also Purchased - " + exp.Message.ToString(), exp); } } }
If there were not any "also purchased" items we'll simply display other popular items from our catalog.
如果没有“一并购买”的数据，将显示目录中的畅销产品。
//--------------------------------------------------------------------------------------+ private void WritePopularItems() { using (CommerceEntities db = new CommerceEntities()) { try { var query = (from ProductOrders in db.OrderDetails join SelectedProducts in db.Products on ProductOrders.ProductID equals SelectedProducts.ProductID group ProductOrders by new { ProductId = SelectedProducts.ProductID, ModelName = SelectedProducts.ModelName } into grp select new { ModelName = grp.Key.ModelName, ProductId = grp.Key.ProductId, Quantity = grp.Sum(o => o.Quantity) } into orderdgrp where orderdgrp.Quantity > 0 orderby orderdgrp.Quantity descending select orderdgrp).Take(5); LabelTitle.Text = "Other items you might be interested in: "; RepeaterItemsList.DataSource = query; RepeaterItemsList.DataBind(); } catch (Exception exp) { throw new Exception("ERROR: Unable to Load Popular Items - " + exp.Message.ToString(), exp); } } }
To view the "Also Purchased" items, open the ProductDetails.aspx page and drag the AlsoPurchased control from the Solutions Explorer so that it appears in this position in the markup.
打开ProductDetails.aspx页面，拖动“一并购买”控件到合适位置。
<table border="0"> <tr> <td> <img src='Catalog/Images/<%# Eval("ProductImage") %>' border="0" alt='<%# Eval("ModelName") %>' /> </td> <td><%# Eval("Description") %><br /><br /><br /> <uc1:AlsoPurchased ID="AlsoPurchased1" runat="server" /> </td> </tr> </table>
Doing so will create a reference to the control at the top of the ProductDetails page.
将在页面的标记首部创建对控件的引用：
<%@ Register src="Controls/AlsoPurchased.ascx" tagname="AlsoPurchased" tagprefix="uc1" %>
Since the AlsoPurchased user control requires a ProductId number we will set the ProductID property of our control by using an Eval statement against the current data model item of the page.
此控件需要产品ID，我们将此属性通过Eval语句进行赋值。
When we build and run now and browse to a product we see the "Also Purchased" items.
再次运行，查看效果。
扫一扫
1921
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
