deliverymethod.cs

PetShop实现的是一个网上购物的系统功能

#region 新增DeliveryMethod类参考答案及评分细则
/*****************************************************************************************************************
	主题：新增DeliveryMethod类评分细则.
	作者：
	时间：
	分值：20分
	细则：
         1、GetAll().......................6分 
         2、GetDeliverMoney(int id)........6分
         3、GetDeliveryMethodName(int id)....6分  
	 4、OrderProcess.aspx重写xml字符串.2分 
 *****************************************************************************************************************/
#endregion

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace PetShop.Components
{
	/// <summary>
	/// DeliverSpeed简要说明
	/// </summary>
	public class DeliveryMethod
	{
		public DeliveryMethod(){}

		public SqlDataReader GetAll()      
		{
			// create data object and params
			SqlDataReader dataReader = null;      
			Database data = new Database();   
			try 
			{
				// run the stored procedure
				data.RunProc("upDeliveryMethodGetAll", out dataReader);
				return dataReader;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				return null;
			}
		}
		public double GetAdditionalCharge(int id)
		{
			// create data object and params
			Database data = new Database();   
			try 
			{
				// run the stored procedure
				//
				SqlParameter[] prams = { 
										   data.MakeInParam("@deliverymethodid",SqlDbType.Int , 10, id),
										   data.MakeOutParam("@addtionalcharge", SqlDbType.Decimal , 10) 
									   };
				data.RunProc("upDeliverymethodGetAdditionalCharge",prams);
				if(	prams[1].Value==DBNull.Value)
					throw new DeliveryMethodIDOverException("配送方式id不正确或超出范围!");
				return Convert.ToDouble(prams[1].Value);
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				return -1;
			}
		}
			
		public string GetDeliveryMethodName(int id)
		{
			// create data object and params
			//
			Database data = new Database();   
			try 
			{
				// run the stored procedure
				//
				SqlParameter[] prams = { 
										   data.MakeInParam("@deliverymethodid",SqlDbType.Int , 10, id),
										   data.MakeOutParam("@delivername", SqlDbType.VarChar , 50) 
									   };
				data.RunProc("upDeliveryMethodGetName",prams);
				if(	prams[1].Value==DBNull.Value)
					throw new DeliveryMethodIDOverException("配送方式id不正确或超出范围!");
				return (string)prams[1].Value;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				return null;
			}
		}
		public bool GetDeliveryMethodShowDeliveryAddress(int id)
		{
			//create data object and params
			Database data=new Database();
			try
			{
				//run the stored procedure
				SqlParameter[] prams={
										 data.MakeInParam("@deliverymethodid",SqlDbType.Int,10,id),
										 data.MakeOutParam("@showdeliveryaddress",SqlDbType.Bit,1)
									 };
				data.RunProc("upDeliverSpeedGetShowDeliveryAddress",prams);
				if(prams[1].Value==DBNull.Value)
				{
					throw new DeliveryMethodIDOverException("配送方式ID不正确或超出范围!");
				}
				return Convert.ToBoolean(prams[1].Value);
			}
			catch(Exception ex)
			{
				Error.Log(ex.ToString());
				throw new Exception("Can't get this id's show shipping address flag!");
			}
		}

	}
	public class DeliveryMethodIDOverException:ApplicationException
	{
		public DeliveryMethodIDOverException():base(){}
		public DeliveryMethodIDOverException(string message):base(message){}
	}
}