addname.cs

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

using System;
using System.Data;
using System.Data.SqlClient;
using Sale.DataLevel;

namespace Sale.BussinessRule
{
	/// <summary>
	/// AddName 的摘要说明。
	/// </summary>
	public class AddName
	{
		private SqlConnection sqlConnection1;
		public AddName()
		{
			this.sqlConnection1=new SqlConnection(Sale.DataLevel.Login.Connection);
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		public string AddProductName(string proID)
		{//输入商品编号，返回相应的商品名称
			SqlCommand addProductName=new SqlCommand();
			addProductName.Connection=this.sqlConnection1;
			addProductName.CommandType=CommandType.StoredProcedure;
			addProductName.CommandText="dbo.StoredProcedureProductName";//调用存储过程
			SqlParameter parinput=addProductName.Parameters.Add("@ProductID",SqlDbType.Char,5);
			parinput.Direction=ParameterDirection.Input;
			parinput.Value=proID;//给参数赋值
			SqlParameter paroutput=addProductName.Parameters.Add("@ProductName",
				SqlDbType.Char,20);
			paroutput.Direction=ParameterDirection.Output;
			try
			{
				this.sqlConnection1.Open();	
				addProductName.ExecuteNonQuery();
				this.sqlConnection1.Close();
				return Convert.ToString(paroutput.Value);//返回商品名称
			}
			catch(System.Exception e)
			{
				Console.WriteLine(e.ToString());	
				this.sqlConnection1.Close();				
			}
			return null;
		}
		public string AddProviderName(string providerID)
		{//输入供应商编号，返回相应的供应商名称
			SqlCommand addProviderName=new SqlCommand();
			addProviderName.Connection=this.sqlConnection1;
			addProviderName.CommandType=CommandType.StoredProcedure;
			addProviderName.CommandText="dbo.StoredProcedureProviderName";
			SqlParameter parinput=addProviderName.Parameters.Add("@ProviderID",SqlDbType.Char,5);
			parinput.Direction=ParameterDirection.Input;
			parinput.Value=providerID;
			SqlParameter paroutput=addProviderName.Parameters.Add("@ProviderName",
				SqlDbType.Char,20);
			paroutput.Direction=ParameterDirection.Output;
			try
			{
				this.sqlConnection1.Open();	
				addProviderName.ExecuteNonQuery();
				this.sqlConnection1.Close();
				return Convert.ToString(paroutput.Value);
			}
			catch(System.Exception e)
			{
				Console.WriteLine(e.ToString());	
				this.sqlConnection1.Close();				
			}
			return null;
		}
		public string AddClientName(string clientID)
		{
			SqlCommand addClientName=new SqlCommand();
			addClientName.Connection=this.sqlConnection1;
			addClientName.CommandType=CommandType.StoredProcedure;
			addClientName.CommandText="dbo.StoredProcedureClientName";
			SqlParameter parinput=addClientName.Parameters.Add("@ClientID",SqlDbType.Char,5);
			parinput.Direction=ParameterDirection.Input;
			parinput.Value=clientID;
			SqlParameter paroutput=addClientName.Parameters.Add("@ClientName",
				SqlDbType.Char,20);
			paroutput.Direction=ParameterDirection.Output;
			try
			{
				this.sqlConnection1.Open();	
				addClientName.ExecuteNonQuery();
				this.sqlConnection1.Close();
				return Convert.ToString(paroutput.Value);
			}
			catch(System.Exception e)
			{
				Console.WriteLine(e.ToString());	
				this.sqlConnection1.Close();				
			}
			return null;
		}
	}
}