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