PetShop4分析随手贴-优快云博客

本文链接：https://blog.youkuaiyun.com/zhangzhentao/article/details/1626716

PetShop4 简析

跟踪顺序为

1．Web/Controls/ItemsControl.ascx.cs

2．/BLL/Item.cs (此处用工厂实现下面的Item)

3．/IDAL/IItem.cs

/DALFactory/DataAccess.cs（工厂）

/Web/web.config（path）

/SQLServerDAL/Item.cs（IItem的实现类）

具体代码实现如下（UI->BLL->DAL）

Web/Controls/ItemsControl.ascx.cs

using System;

using System.Web;

using System.Web.UI.WebControls;

using PetShop.BLL;

using PetShop.CacheDependencyFactory;

namespace PetShop.Web {

public partial class ItemsControl : System.Web.UI.UserControl {

///<summary>

/// Rebind control

///</summary>

protected void PageChanged(object sender, DataGridPageChangedEventArgs e) {

//reset index

itemsGrid.CurrentPageIndex = e.NewPageIndex;

//get category id

string productKey = Request.QueryString["productId"];

//bind data

Item item = new Item();

itemsGrid.DataSource = item.GetItemsByProduct(productKey);

itemsGrid.DataBind();

}

/BLL/Item.cs

using System.Collections.Generic;

using PetShop.Model;

using PetShop.IDAL;

namespace PetShop.BLL {

///<summary>

/// A business component to manage product items

///</summary>

public class Item {

// Get an instance of the Item DAL using the DALFactory

// Making this static will cache the DAL instance after the initial load

private static readonly IItem dal = PetShop.DALFactory.DataAccess.CreateItem();

///<summary>

/// A method to list items by productId

/// Every item is associated with a parent product

///</summary>

///<param name="productId">The productId to search by</param>

///<returns>A Generic List of ItemInfo</returns>

public IList<ItemInfo> GetItemsByProduct(string productId) {

// Validate input

if(string.IsNullOrEmpty(productId))

return new List<ItemInfo>();

// Use the dal to search by productId

return dal.GetItemsByProduct(productId);

}

///<summary>

/// Search for an item given it's unique identifier

///</summary>

///<param name="itemId">Unique identifier for an item</param>

///<returns>An Item business entity</returns>

public ItemInfo GetItem(string itemId) {

// Validate input

if (string.IsNullOrEmpty(itemId))

return null;

// Use the dal to search by ItemId

return dal.GetItem(itemId);

}

/IDAL/IItem.cs

using System;

using System.Collections.Generic;

//References to PetShop specific libraries

//PetShop busines entity library

using PetShop.Model;

namespace PetShop.IDAL {

///<summary>

/// Interface to the Item DAL

///</summary>

public interface IItem{

///<summary>

/// Search items by productId

///</summary>

///<param name="productId">ProductId to search for</param>

///<returns>Interface to Model Collection Generic of the results</returns>

IList<ItemInfo> GetItemsByProduct(string productId);

///<summary>

/// Get information on a specific item

///</summary>

///<param name="itemId">Unique identifier for an item</param>

///<returns>Business Entity representing an item</returns>

ItemInfo GetItem(string itemId);

}

/DALFactory/DataAccess.cs

using System.Reflection;

using System.Configuration;

namespace PetShop.DALFactory {

///<summary>

/// This class is implemented following the Abstract Factory pattern to create the DAL implementation

/// specified from the configuration file

///</summary>

public sealed class DataAccess {

// Look up the DAL implementation we should be using

private static readonly string path = ConfigurationManager.AppSettings["WebDAL"];

private static readonly string orderPath = ConfigurationManager.AppSettings["OrdersDAL"];

private DataAccess() { }

public static PetShop.IDAL.ICategory CreateCategory() {

string className = path + ".Category";

return (PetShop.IDAL.ICategory)Assembly.Load(path).CreateInstance(className);

}

public static PetShop.IDAL.IInventory CreateInventory() {

string className = path + ".Inventory";

return (PetShop.IDAL.IInventory)Assembly.Load(path).CreateInstance(className);

}

public static PetShop.IDAL.IItem CreateItem() {

string className = path + ".Item";

return (PetShop.IDAL.IItem)Assembly.Load(path).CreateInstance(className);

}

public static PetShop.IDAL.IOrder CreateOrder() {

string className = orderPath + ".Order";

return (PetShop.IDAL.IOrder)Assembly.Load(orderPath).CreateInstance(className);

}

public static PetShop.IDAL.IProduct CreateProduct() {

string className = path + ".Product";

return (PetShop.IDAL.IProduct)Assembly.Load(path).CreateInstance(className);

}

/Web/web.config

<? xml version = "1.0"?>

< configuration xmlns = "http://schemas.microsoft.com/.NetConfiguration/v2.0">

< connectionStrings configProtectionProvider = "RsaProtectedConfigurationProvider">

< EncryptedData Type = "http://www.w3.org/2001/04/xmlenc#Element"xmlns="http://www.w3.org/2001/04/xmlenc#">

< EncryptionMethod Algorithm = "http://www.w3.org/2001/04/xmlenc#tripledes-cbc"/>

< KeyInfo xmlns = "http://www.w3.org/2000/09/xmldsig#">

< EncryptedKey xmlns = "http://www.w3.org/2001/04/xmlenc#">

< EncryptionMethod Algorithm = "http://www.w3.org/2001/04/xmlenc#rsa-1_5"/>

< KeyInfo xmlns = "http://www.w3.org/2000/09/xmldsig#">

< KeyName > Rsa Key</KeyName>

</ KeyInfo >

< CipherData >

< CipherValue > NrTRoEqZ1heJDQKp5vLf/vfn+JwusYDwL7c9QFU3FJTeRikKLKaT5Rsa27NzCuU3N9ClxOXBc8hz8h9xO/2LRczJGqAopjhNF77YCV3n28oAXZEC44ePtUQpDhgq9u5EkLkRrBR8zuXidyhU5g0ORGYXtse05jRsZLiNWRpoAyg=</CipherValue>

</ CipherData >

</ EncryptedKey >

</ KeyInfo >

< CipherData >

< CipherValue > RcGv/XHN0pAu9yJ9qQ47L1o/o0M2Fe1S54oDDerxNN/zvG0DDz3jl9rq0vQ4Hlrksr5uOCtDnPuD7MA69Kowd0X7mP6OSNQ4Oc2ZKU9wbbusi9xXcIYvGcc1TPxIUwVT7h+1EzpGfvCDSfWVm0aJWo5Wvf4jJGla9jh1m38nq17NJW1KRlCbaIMDl+0V5keOLrFiAVJR4m4pmQTM90e1NqvJDmIOyWt8vAZHre5+HXk89SIPwFyDhQylLmhRxxqOtvhPLRMYIWGk0F2VjGaslxI1dINxp+zCRZZAQJ1+cKFnQVDnd96xuTk24bpjKMlyR86N1gD1pVfsrgPfbTQInzh1WBEePkHNDGhtte/DerNJlssTbXXiH2IlHvp9CIkgWDXRg9QSdwTLBTwqt/islRPgQgPethFT2pezOW4Bqa5L6TyZ6KW9EJ6wwW5Q1/D/9gTbYQx6cN60cv/RaUSsNzexIIX4jIM5ObSWjdb+06kcm0ZOzgGNtmzY0EL7i902pYSJj7/rOdinVnxisop1YcThacDM4JTMyM/SCEE6dor9/OBP3WL6sdArrzGL3XSgPLgsJpzq4m4efyRLAwkodlQYThlR7pk3HHMF0UbAQ467WCX99D/hT4AYXKlxdqXR/O2vGqPHKk2aNSPPq0UgS2Ahl3AfTeBvH2u+R0CNB9mRpJv2wyvd6HVRlr7aE98ZjAhixYdeIcrlXDgDBPr2ovH0vmNQBA+Z0bvDeI0EP+nh7gtlQGNnY/GKk3bIxeO5ZfK+OPcgPFz3no1Qy6l2LW+RzOx8yXdBFVezxJdm/N9R9rOTb6RBLbg4EmMUkqTk6ylkGXwc7T6psEAb9OU52mbaQC+RK7J6KSpziIkWDb3AuhIEOMfi/sXiemJSqQ9YKK1/p+aI89/tnvi8pXA6qUHzWZXky54o2/UvtxK1GOeN2118ARIr4xgts9J+ul+A0VA9ctXHgCQBmyHm0jKF0lBLAHZN2P29b4NuRAxu1loNjJlyBL+StcBK5rlQAYjh8KZ6Ov9wJ8iVsqZUjBmV7ks6j7G6YFDlkP8Yul/1nonLLlVwFVX3fkBVzS0eLY/uFQh+ByMejS15d9K5bhbYK/xdOr0j7ccvUHIRZClXFxC37+CJDDQsnolNCUZ+4Ev2RlG0yyN68AGXhQgZgIsmLDw20dogqgJZtaqz3k7XxoEE3U6vXzA/N7NnrYdXsIc4iHzDBD4T0oDc3x1dUrPE4bxmZYwaFUG8X82ya1yMmCQKlirA74ZpEDXlGFCOoqgl2MQuFvYonNYvY5lVKkzCa7TQSccbBGTafGJISEIeKDsStBnbT6z7GDcmfpeNnCjdTPYVegtvalpWWTas88Fy5NYt+XV2hRxXNZJIOrnH62DBQrwdMScMApna8LiEU3ctUg9sSIdPmH8hL5XbIwk9gFsPXAtJHBE12pcfuHG99woAEZPg4zZ2wDZLwlenoxIPBz1oU7b8GqDIEX1fsaZwQBReNVJgKbyu3DM9NJiJmdiqZK9BCyzgqYWfDgEYqnpH1DDU4OowIhoPDvNxt1QLqSmbg2dnDrozO0U10d4YDPXGNdZ0IylFjvgqdOhDHf38rsKe1yPbgzfHcQylrlPNiO9ioSiQx6AdfPlhtYAGihFgX9FqwC7DhKPoUdyQhXhYb6T4opj+nuaAiO5SZ1FfcK6vhfoRlrwcoI5l4nmpcpbq3Ta80ZrnPiFI0ZrS/wrhfSPCPE8Z81hpcfrxp377GLNv+IZs9ItzhSrNXnggBmWvMHjtLK6z/VHgJylTfDji89XrJ/19lGDo1DMrIV7VJ8plzVq/sHTSpQJnTHlUa6234ffFOsWxN4jd4CbTXKIJqmWWsrm4r9ZoFIoFPaAiGcvSML8vVFOUPemvGJd9XgVghv5YOvty2efLqT7g/OsEfniVFZqSQ8nQPa+0Ek9YV9otks9+winTyZv8MZI6WOzIM+TtsPicFSzjKKa4FMVzsSSBC6SBP1HcUc0NYMnPIYXEoTyZQzi7lHCUEgvAQfIZtPXus7wkAmyS5WrnBQ5tKefXDoSTeaKJL/OFPRZskOTQ5pOTqxnhSWGF/lips6Do6zuW3Y+craa/xjfD/0+SxWeLJ7zt1E0=</CipherValue>

</ CipherData >

</ EncryptedData >

</ connectionStrings >

< appSettings >

< add key = "WebDAL"value="PetShop.SQLServerDAL"/>

< add key = "OrdersDAL"value="PetShop.SQLServerDAL"/>

< add key = "ProfileDAL"value="PetShop.SQLProfileDAL"/>

< add key = "EnableCaching"value="true"/>

< add key = "CategoryCacheDuration"value="12"/>

< add key = "ProductCacheDuration"value="12"/>

< add key = "ItemCacheDuration"value="12"/>

< add key = "CacheDependencyAssembly"value="PetShop.TableCacheDependency"/>

< add key = "CacheDatabaseName"value="MSPetShop4"/>

< add key = "CategoryTableDependency"value="Category"/>

< add key = "ProductTableDependency"value="Product,Category"/>

< add key = "ItemTableDependency"value="Product,Category,Item"/>

< add key = "OrderStrategyAssembly"value="PetShop.BLL"/>

< add key = "OrderStrategyClass"value="PetShop.BLL.OrderSynchronous"/>

< add key = "OrderMessaging"value="PetShop.MSMQMessaging"/>

< add key = "OrderQueuePath"value="FormatName:DIRECT=OS:MachineName/Private$/PSOrders"/>

< add key = "Event Log Source"value=".NET Pet Shop 4.0"/>

</ appSettings >

< system.web >

< pages theme = "PetShop"styleSheetTheme="PetShop"/>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

-->

< compilation debug = "false">

< assemblies >

< add assembly = "System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

< add assembly = "System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

< add assembly = "Accessibility, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

< add assembly = "System.Messaging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies></compilation>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

< authentication mode = "Forms">

< forms name = "PetShopAuth"loginUrl="SignIn.aspx"protection="None"timeout="60"/>

</ authentication >

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

-->

< customErrors defaultRedirect = "Error.aspx"mode="RemoteOnly"/>

< sessionState mode = "Off"/>

< anonymousIdentification enabled = "true"/>

< profile automaticSaveEnabled = "false"defaultProvider="ShoppingCartProvider">

< providers >

< add name = "ShoppingCartProvider"connectionStringName="SQLProfileConnString"type="PetShop.Profile.PetShopProfileProvider"applicationName=".NET Pet Shop 4.0"/>

< add name = "WishListProvider"connectionStringName="SQLProfileConnString"type="PetShop.Profile.PetShopProfileProvider"applicationName=".NET Pet Shop 4.0"/>

< add name = "AccountInfoProvider"connectionStringName="SQLProfileConnString"type="PetShop.Profile.PetShopProfileProvider"applicationName=".NET Pet Shop 4.0"/>

</ providers >

< properties >

< add name = "ShoppingCart"type="PetShop.BLL.Cart"allowAnonymous="true"provider="ShoppingCartProvider"/>

< add name = "WishList"type="PetShop.BLL.Cart"allowAnonymous="true"provider="WishListProvider"/>

< add name = "AccountInfo"type="PetShop.Model.AddressInfo"allowAnonymous="false"provider="AccountInfoProvider"/>

</ properties >

</ profile >

< membership defaultProvider = "SQLMembershipProvider">

< providers >

< add name = "SQLMembershipProvider"type="System.Web.Security.SqlMembershipProvider"connectionStringName="SQLMembershipConnString"applicationName=".NET Pet Shop 4.0"enablePasswordRetrieval="false"enablePasswordReset="true"requiresQuestionAndAnswer="false"requiresUniqueEmail="false"passwordFormat="Hashed"/>

</ providers >

</ membership >

<!--

<add name="OracleMembershipProvider"

type="PetShop.Membership.OracleMembershipProvider"

connectionStringName="OraMembershipConnString"

enablePasswordRetrieval="false"

enablePasswordReset="false"

requiresUniqueEmail="false"

requiresQuestionAndAnswer="false"

minRequiredPasswordLength="7"

minRequiredNonalphanumericCharacters="1"

applicationName=".NET Pet Shop 4.0"

hashAlgorithmType="SHA1"

passwordFormat="Hashed"/>

</providers>

</membership>

-->

< caching >

< sqlCacheDependency enabled = "true"pollTime="10000">

< databases >

< add name = "MSPetShop4"connectionStringName="SQLConnString1"pollTime="10000"/>

</ databases >

</ sqlCacheDependency >

</ caching >

</ system.web >

< location path = "UserProfile.aspx">

< system.web >

< authorization >

< deny users = "?"/>

</ authorization >

</ system.web >

</ location >

< location path = "CheckOut.aspx">

< system.web >

< authorization >

< deny users = "?"/>

</ authorization >

</ system.web >

</ location >

</ configuration >

/SQLServerDAL/Item.cs （ IItem 的实现类）

using System;

using System.Data;

using System.Data.SqlClient;

using PetShop.Model;

using PetShop.IDAL;

using System.Collections.Generic;

using PetShop.DBUtility;

namespace PetShop.SQLServerDAL {

public class Item : IItem {

// Static constants

private const string SQL_SELECT_ITEMS_BY_PRODUCT = "SELECT Item.ItemId, Item.Name, Inventory.Qty, Item.ListPrice, Product.Name, Item.Image, Product.CategoryId, Product.ProductId FROM Item INNER JOIN Product ON Item.ProductId = Product.ProductId INNER JOIN Inventory ON Item.ItemId = Inventory.ItemId WHERE Item.ProductId = @ProductId";

private const string SQL_SELECT_ITEM = "SELECT Item.ItemId, Item.Name, Item.ListPrice, Product.Name, Item.Image, Product.CategoryId, Product.ProductId FROM Item INNER JOIN Product ON Item.ProductId = Product.ProductId WHERE Item.ItemId = @ItemId";

private const string PARM_PRODUCT_ID = "@ProductId";

private const string PARM_ITEM_ID = "@ItemId";

///<summary>

/// Function to get a list of items within a product group

///</summary>

///<param name="productId">Product Id</param>

///<returns>A Generic List of ItemInfo</returns>

public IList<ItemInfo> GetItemsByProduct(string productId) {

IList<ItemInfo> itemsByProduct = new List<ItemInfo>();

SqlParameter parm = new SqlParameter(PARM_PRODUCT_ID, SqlDbType.VarChar, 10);

parm.Value = productId;

//Execute the query against the database

using(SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ITEMS_BY_PRODUCT, parm)) {

// Scroll through the results

while (rdr.Read()) {

ItemInfo item = new ItemInfo(rdr.GetString(0), rdr.GetString(1), rdr.GetInt32(2), rdr.GetDecimal(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7));

//Add each item to the arraylist

itemsByProduct.Add(item);

}

return itemsByProduct;

}

///<summary>

/// Get an individual item based on a unique key

///</summary>

///<param name="itemId">unique key</param>

///<returns>Details about the Item</returns>

public ItemInfo GetItem(string itemId) {

//Set up a return value

ItemInfo item = null;

//Create a parameter

SqlParameter parm = new SqlParameter(PARM_ITEM_ID, SqlDbType.VarChar, 10);

//Bind the parameter

parm.Value = itemId;

//Execute the query

using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_ITEM, parm)) {

if (rdr.Read())

item = new ItemInfo(rdr.GetString(0), rdr.GetString(1), 0, rdr.GetDecimal(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6));

else

item = new ItemInfo();

}

return item;

}

///<summary>

/// Get the SqlCommand used to retrieve a list of items by product

///</summary>

///<param name="id">Product id</param>

///<returns>Sql Command object used to retrieve the data</returns>

public static SqlCommand GetCommand(string id) {

//Create a parameter