public object ExecuteScalar(string spName, params IDbDataParameter[] parameterValues) { try { this.InitSqliteDB(); return(SqlHelperDB.ExecuteScalar(this.sqliteConn, CommandType.StoredProcedure, spName, parameterValues)); } catch (Exception e) { //this.m_haserror = true; throw new System.Exception(e.Message, e.InnerException); } }
public object ExecuteScalar(CommandType commandType, string commandText, params IDbDataParameter[] commandParameters) { try { this.InitSqliteDB(); return(SqlHelperDB.ExecuteScalar(this.sqliteConn, commandType, commandText, commandParameters)); } catch (Exception e) { //this.m_haserror = true; throw new System.Exception(e.Message, e.InnerException); } }
public DataSet ExecuteDataset(string commandText, string sTableName) { try { this.InitSqliteDB(); return(SqlHelperDB.ExecuteDataset(this.sqliteConn, CommandType.Text, commandText, sTableName, (IDbDataParameter[])null)); } catch (Exception e) { // this.m_haserror = true; throw new System.Exception(e.Message, e.InnerException); } }
public DataSet ExecuteDataset(CommandType commandType, string commandText) { try { this.InitSqliteDB(); return(SqlHelperDB.ExecuteDataset(this.sqliteConn, commandType, commandText)); } catch (Exception e) { // this.m_haserror = true; throw new System.Exception(e.Message, e.InnerException); } }
public int ExecuteNonQuery(CommandType commandType, string commandText, params IDbDataParameter[] commandParameters) { try { this.InitSqliteDB(); if (this.isTrans) { return(SqlHelperDB.ExecuteNonQuery(this.sqliteTransaction, commandType, commandText, commandParameters)); } else { return(SqlHelperDB.ExecuteNonQuery(this.sqliteConn, commandType, commandText, commandParameters)); } } catch (Exception e) { //this.m_haserror = true; throw new System.Exception(e.Message, e.InnerException); //Log.instance().AsynWriteLog("ExecuteNonQuery Error:" + e.Message, Log.LOGLEVEL.Error); } }