orderform.cs

ASP.NET网络编程从入门到精通书的源代码资料

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;

public class OrderItemInfo
{
	public int      ProductID;             ///商品ID
	public int      Number;
	public decimal  Price;
	public DateTime Date;
	public string   Name;                  ///商品名称
	public decimal  ItemTotalMoney;
}

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

    /// <summary>
    /// Summary description for OrderForm
    /// </summary>
public class OrderForm
{
	public readonly static string Cart = "SHOPPINGCART";

	public SqlDataReader GetOrderFormByUser(int nUserID)
	{
		///定义类SQLHelper
		SQLHelper sqlHelper = new 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)
		{
			///抛出执行数据库异常
			SQLHelper.CreateErrorMsg(ex.Message);
			throw new Exception(ex.Message,ex);
		}

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

	public int AddOrderForm(int nUserID,int nTotalNumber,decimal dTotalMoney)
	{
		///定义类SQLHelper
		SQLHelper sqlHelper = new 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)
		{
			///抛出执行数据库异常
			SQLHelper.CreateErrorMsg(ex.Message);
			throw new Exception(ex.Message,ex);
		}
	}

	public int CommitOrderForm(int nOrderFormID)
	{
		///定义类SQLHelper
		SQLHelper sqlHelper = new SQLHelper();

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

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

public class OrderItem
{
	public SqlDataReader GetOrderItemByForm(int nOrderFormID)
	{
		///定义类SQLHelper
		SQLHelper sqlHelper = new 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)
		{
			///抛出执行数据库异常
			SQLHelper.CreateErrorMsg(ex.Message);
			throw new Exception(ex.Message,ex);
		}

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

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

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

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

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

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

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