韬光养晦

public class BookData : DataSet
            {
            public BookData()
            {
            //
            // Create the tables in the dataset
            //
            BuildDataTables();
            }
            private void BuildDataTables()
            {
            //
            // Create the Books table
            //
            DataTable table   = new DataTable(BOOKS_TABLE);
            DataColumnCollection columns = table.Columns;
            columns.Add(PKID_FIELD, typeof(System.Int32));
            columns.Add(TYPE_ID_FIELD, typeof(System.Int32));
            columns.Add(PUBLISHER_ID_FIELD, typeof(System.Int32));
            columns.Add(PUBLICATION_YEAR_FIELD, typeof(System.Int16));
            columns.Add(ISBN_FIELD, typeof(System.String));
            columns.Add(IMAGE_FILE_SPEC_FIELD, typeof(System.String));
            columns.Add(TITLE_FIELD, typeof(System.String));
            columns.Add(DESCRIPTION_FIELD, typeof(System.String));
            columns.Add(UNIT_PRICE_FIELD, typeof(System.Decimal));
            columns.Add(UNIT_COST_FIELD, typeof(System.Decimal));
            columns.Add(ITEM_TYPE_FIELD, typeof(System.String));
            columns.Add(PUBLISHER_NAME_FIELD, typeof(System.String));
            this.Tables.Add(table);
            }
            ………
            }
            

private SqlDataAdapter dsCommand;
            public BookData GetBookById(int bookId)
            {
            return FillBookData("GetBookById", "@BookId", bookId.ToString());
            }
            private BookData FillBookData(String commandText, String paramName, String paramValue)
            {
            if (dsCommand == null )
            {
            throw new System.ObjectDisposedException( GetType().FullName );
            }
            BookData   data    = new BookData();
            SqlCommand command = dsCommand.SelectCommand;
            command.CommandText = commandText;
            command.CommandType = CommandType.StoredProcedure; // use stored proc for perf
            SqlParameter param = new SqlParameter(paramName, SqlDbType.NVarChar, 255);
            param.Value = paramValue;
            command.Parameters.Add(param);
            dsCommand.Fill(data);
            return data;
            }
            

public CustomerData GetCustomerByEmail(String emailAddress, String password)
            {
            //
            // Check preconditions
            //
            ApplicationAssert.CheckCondition(emailAddress != String.Empty, "Email address is required",
            ApplicationAssert.LineNumber);
            ApplicationAssert.CheckCondition(password != String.Empty, "Password is required",
            ApplicationAssert.LineNumber);
            //
            // Get the customer dataSet
            //
            CustomerData dataSet;
            using (DataAccess.Customers customersDataAccess = new DataAccess.Customers())
            {
            dataSet = customersDataAccess.LoadCustomerByEmail(emailAddress);
            }
            //
            // Verify the customer's password
            //
            DataRowCollection rows = dataSet.Tables[CustomerData.CUSTOMERS_TABLE].Rows;
            if ( ( rows.Count == 1 ) && rows[0][CustomerData.PASSWORD_FIELD].Equals(password) )
            {
            return dataSet;
            }
            else
            {
            return null;
            }
            }
            

dataSet = customersDataAccess.LoadCustomerByEmail(emailAddress);
            

public void RunProc(string procName, out SqlDataReader dataReader)
            {
            SqlCommand cmd = CreateCommand(procName, null);
            dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
            }
            

public ProductResults[] GetList(string catid, int currentPage, int pageSize, ref int numResults)
            {
            numResults = 0;
            int index=0;
            SqlDataReader reader = GetList(catid);
            ProductResults[] results = new ProductResults[pageSize];
            // now loop through the list and pull out items of the specified page
            int start = (int)((currentPage - 1) * pageSize);
            if (start <= 0) start = 1;
            // skip
            for (int i = 0; i < start - 1; i++) {
            if (reader.Read()) numResults++;
            }
            if (start > 1) reader.Read();
            // read the data we are interested in
            while (reader.Read()) {
            if (index < pageSize) {
            results[index] = new ProductResults();
            results[index].productid = reader.GetString(0);
            results[index].name =  reader.GetString(1);
            index++;
            }
            numResults++;
            }
            reader.Close();
            // see if need to redim array
            if (index == pageSize)
            return results;
            else {
            // not a full page, redim array
            ProductResults[] results2 = new ProductResults[index];
            Array.Copy(results, results2, index);
            return results2;
            }
            }
            

public class ProductResults
            {
            private string m_productid;
            private string m_name;
            // product props
            public string productid {
            get { return m_productid; }
            set { m_productid = value; }
            }
            public string name {
            get { return m_name; }
            set { m_name = value; }
            }
            }
            

public CategoryData GetCategories(int categoryId)
            {
            if ( dsCommand == null )
            {
            throw new System.ObjectDisposedException( GetType().FullName );
            }
            return FillCategoryData("GetCategories", "@CategoryId", categoryId);
            }
            

public void AddOrder()
            {
            ApplicationAssert.CheckCondition(cartOrderData != null, "Order requires data",
            ApplicationAssert.LineNumber);
            ApplicationLog.WriteTrace("Duwamish7.Web.Cart.AddOrder:\r\nCustomerId: " +
            cartOrderData.Tables[OrderData.CUSTOMER_TABLE].Rows[0][OrderData.PKID_FIELD].ToString());
            cartOrderData = (new OrderSystem()).AddOrder(cartOrderData);
            }
            

public OrderData AddOrder(OrderData order)
            {
            ApplicationAssert.CheckCondition(order != null, "Order is required",
            ApplicationAssert.LineNumber);
            (new BusinessRules.Order()).InsertOrder(order);
            return order;
            }
            

public bool InsertOrder(OrderData order)
            {
            //此处省略复杂的处理逻辑
            if ( isValid )
            {
            using (DataAccess.Orders ordersDataAccess = new DataAccess.Orders())
            {
            return (ordersDataAccess.InsertOrderDetail(order)) > 0;
            }
            }
            else
            return false;
            }