itemprice.cs

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

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

namespace bid.Entity
{
	/// <summary>
	/// ItemPrice 的摘要说明。
	/// </summary>
	public class ItemPrice
	{
		private int _Id;
		private int _ItemId;
		private int _UserId;
		private double _Price;
		private DateTime _PriceTime;

		public int Id
		{
			get
			{
				return _Id;
			}
			set
			{
				_Id = value;
			}
			
		}
		public int ItemId
		{
			get
			{
				return _ItemId;
			}
			set
			{
				_ItemId = value;
			}
		}
		private int UserID
		{
			get
			{
				return _UserId;
			}
			set
			{
				_UserId = value;
			}
		}
		private double Price
		{
			get
			{
				return _Price;
			}
			set
			{
				_Price = value;
			}
		}
		private DateTime PriceTime
		{
			get
			{
				return _PriceTime;
			}
			set
			{
				_PriceTime = value;
			}
		}


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

		/// <summary>
		/// 根据物品的ID得到这个物品的所有出价记录
		/// </summary>
		/// <param name="ItemID"></param>
		/// <returns></returns>
		public DataTable GetItemPriceByItemId( int ItemId )
		{
			string SqlString = " SELECT A.price, A.pricetime,b.name as bider_name FROM item_price AS A, [User] AS B WHERE A.ItemId = {0} AND B.id = A.userid ORDER BY A.price DESC ";
			SqlString = string.Format( SqlString, ItemId );
			return SqlHelper.ExecuteDataset( DBUtil.ConnString, CommandType.Text, SqlString).Tables[0];
		}

		/// <summary>
		/// 出价。
		/// </summary>
		/// <param name="ItemId">物品的Id</param>
		/// <param name="BiderId">出价者的Id</param>
		/// <param name="BidPrice">所出的价格</param>
		/// <returns></returns>
		public string bid( int ItemId, int BiderId, double BidPrice )
		{
			string SqlString = "Bid";
			SqlCommand cmd = new SqlCommand();
			cmd.CommandType = CommandType.StoredProcedure;
			cmd.CommandText = SqlString;
			SqlParameterCollection prms = cmd.Parameters;

			prms.Add("@item_id", SqlDbType.Int);
			prms.Add("@bider_id", SqlDbType.Int);
			prms.Add("@bid_price", SqlDbType.Real);
			prms.Add("@info", SqlDbType.NVarChar,200);
            
			prms["@item_id"].Value = ItemId;
			prms["@bider_id"].Value = BiderId;
			prms["@bid_price"].Value = BidPrice;
			prms["@info"].Direction = ParameterDirection.Output;
			
			try
			{
				cmd.Connection = new SqlConnection( DBUtil.ConnString );
				cmd.Connection.Open();
				int result = Convert.ToInt32( cmd.ExecuteScalar());
				cmd.Connection.Close();
				if( result == 1 )
				{
					return "1";
				}
				else
				{
					return prms["@info"].Value.ToString();
				}
			}
			catch( Exception ex )
			{
				return ex.Message;
			}
			finally
			{
				if( cmd.Connection.State !=  ConnectionState.Closed ) 
					cmd.Connection.Close();
			}
		}
	}
}