public interface ISPAccesser:ITransactionAccesser
{
/// <summary>
/// ExcuteNoneQuery執行命令式的存儲過程，可以輸出out參數。
/// </summary>
/// <paramname="spName"> 存儲過程名稱 </param>
/// <paramname="parms"> 所有的[in]和[in,out]參數 </param>
/// <paramname="outVals"> out參數的"名稱－值"字典 </param>
void ExcuteNoneQuery( string spName, IList < SPParameter > parms, out IDictionary < string , object > outVals);

/// <summary>
/// ExcuteNoneQuery執行查詢式的存儲過程，可以輸出out參數。
/// </summary>
/// <paramname="spName"> 存儲過程名稱 </param>
/// <paramname="parms"> 所有的[in]和[in,out]參數 </param>
/// <paramname="outVals"> out參數的"名稱－值"字典 </param>
DataSet ExcuteQuery( string spName, IList < SPParameter > parms, out IDictionary < string , object > outVals);
}

IList < SPParameter > paraList = new List < SPParameter > ();
SPParameter para1 = new SPParameter ( " newDbName " ,ParameterDirection.Input, " EASNew9 " );
paraList.Add(para1);
SPParameter para2 = new SPParameter ( " dbDataDirPath " ,ParameterDirection.Input, @" C:/ProgramFiles/MicrosoftSQLServer/MSSQL/Data/ " );
paraList.Add(para2);
SPParameter para3 = new SPParameter ( " soureDbName " ,ParameterDirection.Input, " AutoSchedulerSystem " );
paraList.Add(para3);
SPParameter para4 = new SPParameter ( " soureBackupFilePATH " ,ParameterDirection.Input, @" d:/sqlDatabase/AutoSchedulerSystem2 " );
paraList.Add(para4);
IDictionary < string , object > outParas = null ;

spAccesser .ExcuteNoneQuery( " CopyDB " ,paraList, out outParas);