selectstore.cs

来自「PetShop实现的是一个网上购物的系统功能」· CS 代码 · 共 61 行

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace PetShop.Components
{
	/// <summary>
	/// Selectstore 的摘要说明。
	/// </summary>
	public class Selectstore
	{
		public Selectstore()
		{  }
			
		
		public SqlDataReader GetAll()      
		{
			// create data object and params
			SqlDataReader dataReader = null;      
			Database data = new Database();   
			try 
			{
				// run the stored procedure
				data.RunProc("upGetstoreAll", out dataReader);
				return dataReader;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				return null;
			}
		}
		public string GetShopName(int id)
		{
			// create data object and params
			//
			Database data = new Database();   
			try 
			{
				// run the stored procedure
				//
				SqlParameter[] prams = { 
										   data.MakeInParam("@id",SqlDbType.Int , 10, id),
										   data.MakeOutParam("@name", SqlDbType.VarChar , 50) 
									   };
				data.RunProc("upGetshopname",prams);
				if(	prams[1].Value==DBNull.Value)
					throw new Exception("配送方式id不正确或超出范围!");
				return (string)prams[1].Value;
			}
			catch (Exception ex) 
			{
				Error.Log(ex.ToString());
				return null;
			}
		}
	}
}