orderinfo.cs

人力资源管理系统

using System;
using System.Data ;
using COAdmin.COMMON;
using COAdmin.DAL ;

namespace COAdmin.BLL
{
	/// <summary>
	/// Order 的摘要说明。
	/// </summary>
	public class OrderInfo
	{
		public OrderInfo()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		private int _orderID ;
		private int _custID ;
		private string _rsvName ;
		private string _rsvAddress ;
		private string _status ;
		private string _payType ; 
		private string _rsvType ;
		private double _totalPrice;
		private double _freight ;
		private double _prodPrice ;
		private double _getMoney ;
		private string _isInvoice;
		private string _invoiceTitle ;
		private int _useCoupon ;
		private string _discount ;
		private string _feedBack ;
		private DateTime _crdt ;
		private string _crusr ;
		private DateTime _mddt ;
		private string _mdusr ;
		private DateTime _senddt ;
		private string _rsvTel ;

		#region 公共属性
		public int OrderID
		{
			get{ return _orderID ; }
			set{ _orderID = value ;}
		}

		public int CustID
		{
			get{ return _custID ; }
			set{ _custID = value ;}
		}

		public string RsvName
		{
			get{ return _rsvName ; }
			set{ _rsvName = value ;}
		}

		public string RsvAddress
		{
			get{ return _rsvAddress ; }
			set{ _rsvAddress = value ;}
		}

		public string Status
		{
			get{ return _status ; }
			set{ _status = value ;}
		}

		public string PayType
		{
			get{ return _payType ; }
			set{ _payType = value ;}
		}

		public string RsvType
		{
			get{ return _rsvType ; }
			set{ _rsvType = value ;}
		}

		public double TotalPrice
		{
			get{ return _totalPrice ; }
			set{ _totalPrice = value ;}
		}

		public double Freight
		{
			get{ return _freight ; }
			set{ _freight = value ;}
		}

		public double ProdPrice
		{
			get{ return _prodPrice ; }
			set{ _prodPrice = value ;}
		}

		public double GetMoney
		{
			get{ return _getMoney ; }
			set{ _getMoney = value ;}
		}

		public string IsInvoice
		{
			get{ return _isInvoice ; }
			set{ _isInvoice = value ;}
		}

		public string InvoiceTitle
		{
			get{ return _invoiceTitle ; }
			set{ _invoiceTitle = value ;}
		}

		public int UseCoupon
		{
			get{ return _useCoupon ; }
			set{ _useCoupon = value ;}
		}

		public string Discount
		{
			get{ return _discount ; }
			set{ _discount = value ;}
		}

		public string FeedBack
		{
			get{ return _feedBack ; }
			set{ _feedBack = value ;}
		}

		public DateTime CRDT
		{
			get{ return _crdt ; }
			set{ _crdt = value ;}
		}

		public string CRUSR
		{
			get{ return _crusr ; }
			set{ _crusr = value ;}
		}

		public DateTime MDDT
		{
			get{ return _mddt ; }
			set{ _mddt = value ;}
		}

		public string mdusr
		{
			get{ return _mdusr ; }
			set{ _mdusr = value ;}
		}

		public DateTime SENDDT
		{
			get{ return _senddt ; }
			set{ _senddt = value ;}
		}

		public string RsvTel
		{
			get{ return _rsvTel ; }
			set{ _rsvTel = value ;}
		}
		#endregion

		#region 公共方法
		/// <summary>
		/// 按订单ID查询订单信息
		/// </summary>
		/// <param name="orderID">订单ID</param>
		/// <returns></returns>
		public int GetOrder(int orderID)
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Order_Get" ;
			//存储过程参数
			object[] para = new object[] {orderID} ;

			DataTable dt = DataAccess.ExecuteDataTable(spName,para) ;
			if(dt.Rows.Count > 0)
			{
				DataRow dr = dt.Rows[0] ;
				AssignAttribute(dr) ;
				ret = 0 ;
			}
			return ret ;
		}

		/// <summary>
		/// 通过客户ID查询订单信息
		/// </summary>
		/// <param name="customerID"></param>
		/// <returns></returns>
		public DataTable GetOrderByCustID(int customerID)
		{
			//存储过程名
			string spName = "CO_Order_GetByCustID" ;
			//存储过程参数
			object[] para = new object[] {customerID} ;
			//查询
			return DataAccess.ExecuteDataTable(spName,para) ;
			
		}

		/// <summary>
		/// 指定订单属性
		/// </summary>
		/// <param name="dr"></param>
		private void AssignAttribute(DataRow dr)
		{
			this._crdt = CommHandler.StringToDateTime(dr["Crdt"].ToString()) ;
			this._crusr = dr["Crusr"].ToString() ;
			this._custID = CommHandler.StringToInt(dr["CustID"].ToString()) ;
			this._discount = dr["Discount"].ToString() ;
			this._feedBack = dr["FeedBack"].ToString() ;
			this._freight = CommHandler.StringToDouble(dr["Freight"].ToString()) ;
			this._getMoney = CommHandler.StringToDouble(dr["GetMoney"].ToString()) ;
			this._invoiceTitle = dr["InvoiceTitle"].ToString() ;
			this._isInvoice = dr["IsInvoice"].ToString() ;
			this._mddt = CommHandler.StringToDateTime(dr["Mddt"].ToString()) ;
			this._mdusr = dr["Mdusr"].ToString() ;
			this._orderID = CommHandler.StringToInt(dr["OrderID"].ToString()) ;
			this._payType = dr["PayType"].ToString() ;
			this._prodPrice = CommHandler.StringToDouble(dr["ProdPrice"].ToString()) ;
			this._rsvAddress = dr["RsvAddress"].ToString() ;
			this._rsvName = dr["RsvName"].ToString() ;
			this._rsvType = dr["RsvType"].ToString() ;
			this._status = dr["Status"].ToString() ;
			this._totalPrice = CommHandler.StringToDouble(dr["totalPrice"].ToString()) ;
			this._useCoupon = CommHandler.StringToInt(dr["UseCoupon"].ToString()) ;
		}

		/// <summary>
		/// 删除订单
		/// </summary>
		/// <param name="orderID"></param>
		/// <param name="usr"></param>
		/// <returns></returns>
		public static int DeleteOrder(int orderID,string usr)
		{
			//存储过程名
			string spName = "CO_Order_Delete" ;

			//存储过程参数
			object[] para = new object[] {orderID,usr} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;

		}

		/// <summary>
		/// 添加订单
		/// </summary>
		/// <returns></returns>
		public int AddOrder()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Order_Add" ;
			//存储过程参数
			object[] para = new object[] {"",_custID,_rsvName,_rsvAddress,_rsvTel,_status ,_payType ,_rsvType,_totalPrice 
											 ,_freight,_prodPrice,_getMoney,_isInvoice ,_invoiceTitle,_useCoupon,_discount 
											 , _crusr
										 } ;

			//调用数据访问方法执行存储过程			
			ret = DataAccess.ExecuteNonQuery(spName,true,para) ;

			return ret ;
		}

		/// <summary>
		/// 修改订单
		/// </summary>
		/// <returns></returns>
		public int ModifyOrder()
		{
			int ret = -1 ;

			//存储过程名
			string spName = "CO_Order_Modify" ;
			//存储过程参数
			object[] para = new object[] {_orderID ,_custID,_rsvName,_rsvAddress,_rsvTel,_payType ,_rsvType,_totalPrice 
											 ,_freight,_prodPrice,_getMoney,_isInvoice ,_invoiceTitle,_useCoupon,_discount 
											 , _mdusr	} ;

			//调用数据访问方法执行存储过程			
			ret = DataAccess.ExecuteNonQuery(spName,false,para) ;

			return ret ;
		}	
		
		/// <summary>
		/// 使用礼券
		/// </summary>
		/// <param name="couponID">礼券编号</param>
		/// <returns></returns>
		public static int CouponUse(string couponID)
		{
			//存储过程名
			string spName = "CO_COUPON_USE" ;

			//存储过程参数
			object[] para = new object[] {couponID} ;

			return DataAccess.ExecuteNonQuery(spName,false,para) ;
		}
		#endregion
	}
}