orderform.cs

来自「《精通ASP.NET2.0网络应用系统开发》书中的源码」· CS 代码 · 共 173 行

using System;
using System.Data;
using System.Collections;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using SQLHelper;

namespace BookShop
{
    public class OrderItemInformation
    {
        public int BookID;
        public int Number;
        public decimal Price;
        public DateTime ItemDate;
		public string Name;     ///书籍名称
		public string Desn;     ///书籍种类名称
    }

    public class OrderFormInformation
    {
        public int TotalNumber;
        public decimal TotalMoney;
        public ArrayList OrderItemList = new ArrayList();
    }

    /// <summary>
    /// Summary description for OrderForm
    /// </summary>
    public class OrderForm
    {
        public SqlDataReader GetOrderFormByUser(int nUserID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///定义保存从数据库获取的结果的DataReader
            SqlDataReader dr = null;

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@UserID",SqlDbType.Int,4,nUserID)
            };

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_GetOrderFormByUser", paramList, out dr);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }

            ///返回从数据库获取的结果
            return (dr);
        }        

        public int AddOrderForm(int nUserID,int nTotalNumber, decimal dTotalMoney)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@UserID",SqlDbType.Int,4,nUserID),
                sqlHelper.CreateInParam("@TotalNumber",SqlDbType.Int,4,nTotalNumber),
                sqlHelper.CreateInParam("@TotalMoney",SqlDbType.Money,8,dTotalMoney)
            };

            try
            {
                ///执行存储过程
                return (sqlHelper.RunProc("Pr_AddOrderForm", paramList));
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }
        }
    }

    public class OrderItem
    {
        public SqlDataReader GetOrderItemByForm(int nOrderFormID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///定义保存从数据库获取的结果的DataReader
            SqlDataReader dr = null;

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@OrderFormID",SqlDbType.Int,4,nOrderFormID)
            };

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_GetOrderItemByForm", paramList, out dr);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }

            ///返回从数据库获取的结果
            return (dr);
        }

        public int AddOrderItem(int nBookID, int nNumber, int nOrderFormID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@BookID",SqlDbType.Int,4,nBookID),
                sqlHelper.CreateInParam("@Number",SqlDbType.Int,4,nNumber),
                sqlHelper.CreateInParam("@OrderFormID",SqlDbType.Int,4,nOrderFormID)
            };

            try
            {
                ///执行存储过程
                return (sqlHelper.RunProc("Pr_AddOrderItem", paramList));
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }
        }

        public void DeleteOrderItem(int nOrderItemID)
        {
            ///定义类SQLHelper
            SQLHelper.SQLHelper sqlHelper = new SQLHelper.SQLHelper();

            ///创建访问数据库的参数			
            SqlParameter[] paramList = {
                sqlHelper.CreateInParam("@OrderItemID",SqlDbType.Int,4,nOrderItemID)
            };

            try
            {
                ///执行存储过程
                sqlHelper.RunProc("Pr_DeleteOrderItem", paramList);
            }
            catch (Exception ex)
            {
                ///抛出执行数据库异常
                SystemError.CreateErrorLog(ex.Message);
                throw new Exception(ex.Message, ex);
            }
        }
    }
}