/// <summary>
/// 有回傳資料的SQL執行程序
/// </summary>
/// <param name="_sp_name">欲執行的SQL SP 名稱</param>
/// <param name="_function_name">供寫Log的上層函式名稱</param>
/// <returns></returns>
public GosmioSqlDataReader ExecuteReader(CommandType commandType, string _sp_name)
{
SetCommandInit(commandType, _sp_name);
// 連線DB
if (ConnectionOpen())
{
return(null);
}
DateTime tTimeStart = DateTime.Now;
try
{
_MDataReader = new GosmioSqlDataReader(MCmd, _MFunctionName);
_MDataReader.mObjDtr = ExecuteReaderProcess();
return(_MDataReader);
}
catch (System.Exception ex)
{
if (_MIsSqlErrorLog)
{
Logger.WriteErrorLog(_MFunctionName, ex, MCmd, tTimeStart);
}
else
{
Logger.WriteErrorLog(_MFunctionName, ex, null, tTimeStart);
}
return(null);
}
}
private void Init()
{
MParam = null;
_MDataReader = null;
MCmd = null;
_MErrorNo = 0;
_MErrorMsg = "";
MCommandTimeout = 0;
}
