modifyprostock.cs

《C#数据库项目案例导航》一书的配套光盘

using System;
using System.Data;
using System.Data.SqlClient;
using Sale.DataLevel;
//引用程序集
namespace Sale.BussinessRule
{
	/// <summary>
	/// ModifyProStock 的摘要说明。
	/// </summary>
	public class ModifyProStock
	{
		private SqlConnection sqlConnection1;
		public ModifyProStock()
		{
			this.sqlConnection1=new SqlConnection(Sale.DataLevel.Login.Connection);
			//创建数据库Sell的连接
		}

		public void AddProStock(string proID,int proNumber)
		{
			
			SqlCommand ProBuy=new SqlCommand();
			ProBuy.Connection=this.sqlConnection1;
			ProBuy.CommandType=CommandType.StoredProcedure;
			ProBuy.CommandText="dbo.StoredProcedureProBuy";
			//调用存储过程StoredProcedureProBuy
			SqlParameter parinput=ProBuy.Parameters.Add("@ProID",SqlDbType.Char);
			//添加变量
			parinput.Direction=ParameterDirection.Input;//设计变量的属性为输入
			parinput.Value=proID;//为变量赋值
			parinput=ProBuy.Parameters.Add("@BuyNumber",
				SqlDbType.Int);			;
			parinput.Value=proNumber;//添加第二个变量并赋值
			try
			{
				this.sqlConnection1.Open();	
				ProBuy.ExecuteNonQuery();//执行存储过程
				this.sqlConnection1.Close();				
			}
			catch(System.Exception E)
			{
				Console.WriteLine(E.ToString());				
				this.sqlConnection1.Close();
			}
			
		}

		public void MinusProStock(string proID,int proNumber)
		{			
			SqlCommand ProBuy=new SqlCommand();
			ProBuy.Connection=this.sqlConnection1;
			ProBuy.CommandType=CommandType.StoredProcedure;
			ProBuy.CommandText="dbo.StoredProcedureProSell";
			SqlParameter parinput=ProBuy.Parameters.Add("@ProID",SqlDbType.Char);
			parinput.Direction=ParameterDirection.Input;
			parinput.Value=proID;
			parinput=ProBuy.Parameters.Add("@SellNumber",
				SqlDbType.Int);			;
			parinput.Value=proNumber;
			try
			{
				this.sqlConnection1.Open();	
				ProBuy.ExecuteNonQuery();
				this.sqlConnection1.Close();				
			}
			catch(System.Exception E)
			{
				Console.WriteLine(E.ToString());
				
			}			
		}
		
	}
}