item.cs

VSharp学习软件源代码bid示例程序

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.ApplicationBlocks.Data;

namespace bid.Entity
{
	/// <summary>
	/// Item 的摘要说明。
	/// </summary>
	public class Item
	{
		#region 字段、构造函数和析构函数
		private int _Id;
		private int _UserID;
		private string _ItemDesc;
		private double _BasePrice;
		private string _ItemStatus;
		private int _BuyerID;
		private double _SalePrice;
		private DateTime _SaleDate;

		public int Id
		{
			get{	return _Id;		}
			set{	_Id = value;	}
		}
		public int UserID
		{
			get{	return _UserID;	}
			set{	_UserID = value;}
		}
		public string ItemDesc
		{
			get{return _ItemDesc;}
			set{_ItemDesc = value;}
		}
		public double BasePrice
		{
			get{return _BasePrice;}
			set{ _BasePrice = value; }
		}
		public string ItemStatus
		{
			get{ return _ItemStatus; }
			set{ _ItemStatus = value;}
		}
		public int BuyerID
		{
			get{ return _BuyerID;}
			set{ _BuyerID = value;}
		}
		public double SalePrice
		{
			get{ return _SalePrice;}
			set{ _SalePrice = value;}
		}
		public DateTime SaleDate
		{
			get{ return _SaleDate; }
			set{ _SaleDate = value;}
		}

		public Item()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		#endregion

		public Item( int ItemId )
		{
			string SqlString = " SELECT * FROM Item WHERE id={0}";
			SqlString = string.Format( SqlString, ItemId );
			DataTable tblTemp = SqlHelper.ExecuteDataset( DBUtil.ConnString, CommandType.Text, SqlString ).Tables[0];
			if( tblTemp != null)
			{
				if( tblTemp.Rows.Count == 1)
				{

					this._Id		= Convert.ToInt32(		tblTemp.Rows[0]["id"]			);
					this._UserID	= Convert.ToInt32(		tblTemp.Rows[0]["user_id"]		);
					this._ItemDesc	= Convert.ToString(		tblTemp.Rows[0]["item_desc"]	);
					this._BasePrice	= Convert.ToDouble(		tblTemp.Rows[0]["base_price"]	);
					this._ItemStatus= Convert.ToString(		tblTemp.Rows[0]["item_status"]	);
					this._BuyerID	= Convert.ToInt32(		tblTemp.Rows[0]["buyer_id"]		);
					this._SalePrice	= Convert.ToDouble(		tblTemp.Rows[0]["sale_price"]	);
					this._SaleDate	= Convert.ToDateTime(	tblTemp.Rows[0]["sale_date"]	);
				}
			}
		}
		/// <summary>
		/// 得到所有的物品的列表
		/// </summary>
		/// <returns></returns>
		public DataTable GetItemList()
		{
			return null;
		}

		/// <summary>
		/// 得到正在销售的物品项
		/// </summary>
		/// <returns></returns>
		public DataTable GetItemListOnSale()
		{
			string SqlString = " SELECT * FROM ItemlistOnSale ";
			return SqlHelper.ExecuteDataset( DBUtil.ConnString, CommandType.Text, SqlString).Tables[0];
		}

		/// <summary>
		/// 根据用户的ID得到这个用户的所有物品的列表
		/// </summary>
		/// <param name="UserID"></param>
		/// <returns></returns>
		public DataTable GetItemListByUserID( string UserID )
		{
			return null;
		}

		public string AddItem( int UserId, string ItemDesc, double BasePrice )
		{
			string SqlString = "AddItem";
			SqlCommand cmd = new SqlCommand();
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.CommandText = SqlString;
			SqlParameterCollection prms = cmd.Parameters;

			prms.Add("@user_id", SqlDbType.Int);
			prms.Add("@item_desc", SqlDbType.NVarChar,200);
			prms.Add("@base_price", SqlDbType.Real);
            
			prms["@user_id"].Value = UserId;
			prms["@item_desc"].Value = ItemDesc;
			prms["@base_price"].Value = BasePrice;
			
			try
			{
				cmd.Connection = new SqlConnection( DBUtil.ConnString );
				cmd.Connection.Open();
				int result = Convert.ToInt32( cmd.ExecuteScalar());
				cmd.Connection.Close();
				if( result > 0 )
				{
					return "1";
				}
				return "0";
			}
			catch( Exception ex )
			{
				return ex.Message;
			}
			finally
			{
				if( cmd.Connection.State !=  ConnectionState.Closed ) 
					cmd.Connection.Close();
			}
		}

		public int ItemSale( int BuyerID, double Price )
		{
			return 0;
		}
	}
}