通过存储过程访问SQL数据:ApplicationBlocks

using System;
using System.Data;
using Microsoft.ApplicationBlocks.Data;
using System.Collections;

namespace Proj
{
 /// <summary>
 /// BllToDbWithProc 的摘要说明。
 /// </summary>
 public class BllToDbWithProc
 {
  public BllToDbWithProc(){}

  #region "调用存储过程"
  public bool ExecNonReturnProc(string Conn,string ProcName,System.Data.SqlClient.SqlParameter[] ParValue)
  {
   try
   {
    SqlHelper.ExecuteNonQuery(Conn,CommandType.StoredProcedure,ProcName,ParValue);
    return true;
   }
   catch(Exception e)
   {
    return false;
   }
  }

  public bool ExeOutPutProc(string Conn,string ProcName,out ArrayList OutValue,int[] OutIndex,System.Data.SqlClient.SqlParameter[] ParValue)
  {
   try
   {
    SqlHelper.ExecuteNonQuery(Conn,CommandType.StoredProcedure,ProcName,ParValue);
    ArrayList tmpList=new ArrayList();
    if (OutIndex.Length>0)
    {
     for (int i=0;i<ParValue.Length;i++)
     {
      if (ParValue[i].Direction==System.Data.ParameterDirection.InputOutput)
      {
       tmpList.Add(ParValue[i].Value);
      }
     }
     OutValue=tmpList;
    }
    else
     OutValue=null;
    return true;
   }
   catch(Exception e)
   {
    OutValue=null;
    return false;
   }
  }

  #endregion

  #region "调用视图"
  public DataSet ExeDataSetProc(string Conn,string Sql)
  {
   try
   {
    return  SqlHelper.ExecuteDataset(Conn,CommandType.Text,Sql);
   }
   catch(Exception e)
   {
    return null;
   }
  }
  public DataSet ExeDataSetProcWithPar(string Conn,string Sql,params System.Data.SqlClient.SqlParameter[] ParValue)
  {
   try
   {
    return SqlHelper.ExecuteDataset(Conn,CommandType.Text,Sql,ParValue);
   }
   catch(Exception e)
   {
    return null;  
   }
  }

  #endregion

 }
}

  public static string ConnString
  {
   get
   {
    return System.Configuration.ConfigurationSettings.AppSettings["ConnectString"].ToString();
   }
   set
   {
    System.Configuration.ConfigurationSettings.AppSettings.Set("ConnectString",value);
   }
  }