PetShop4分析随手贴

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 > <!– Pet Shop DAL configuration settings. Possible values: PetShop.SQLServerDAL for SqlServer, PetShop.OracleServerDALfor Oracle. –> < add key = “WebDAL“value=“PetShop.SQLServerDAL“/> < add key = “OrdersDAL“value=“PetShop.SQLServerDAL“/> < add key = “ProfileDAL“value=“PetShop.SQLProfileDAL“/> <!– Enable data caching –> < add key = “EnableCaching“value=“true“/> <!– Cache duration (in hours-whole number only) –> < add key = “CategoryCacheDuration“value=“12“/> < add key = “ProductCacheDuration“value=“12“/> < add key = “ItemCacheDuration“value=“12“/> <!– Cache dependency options. Possible values: PetShop.TableCacheDependency for SQL Server and keep empty for ORACLE –> < add key = “CacheDependencyAssembly“value=“PetShop.TableCacheDependency“/> <!– CacheDatabaseName should match the name under caching section, when using TableCacheDependency –> < add key = “CacheDatabaseName“value=“MSPetShop4“/> <!– *TableDependency lists table dependency for each instance separated by comma –> < add key = “CategoryTableDependency“value=“Category“/> < add key = “ProductTableDependency“value=“Product,Category“/> < add key = “ItemTableDependency“value=“Product,Category,Item“/> <!– Order processing options (Asynch/Synch) –> < add key = “OrderStrategyAssembly“value=“PetShop.BLL“/> < add key = “OrderStrategyClass“value=“PetShop.BLL.OrderSynchronous“/> <!– Asynchronous Order options –> < add key = “OrderMessaging“value=“PetShop.MSMQMessaging“/> < add key = “OrderQueuePath“value=“FormatName:DIRECT=OS:MachineName/Private$/PSOrders“/> <!– Application Error Log –> < 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 Provider for SqlServer –> < 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 > <!– Membership Provider for Oracle –> <!– <membership defaultProvider=”OracleMembershipProvider”> <providers> <clear/> <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 SqlParameter parm = new SqlParameter(PARM_PRODUCT_ID, SqlDbType.VarChar, 10); parm.Value = id; // Create and return SqlCommand object SqlCommand command = new SqlCommand(SQL_SELECT_ITEMS_BY_PRODUCT); command.Parameters.Add(parm); return command; } } }