/// <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; }