public DataTable FindTableBySql(string strSql, DbParameter[] parameters) { return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters))); }
public DataTable FindTableTop <T>(int Top) where T : new() { StringBuilder builder = DatabaseCommon.SelectSql <T>(Top); return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, builder.ToString()))); }
public DataTable FindTableByProc(string procName, DbParameter[] parameters) { return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.StoredProcedure, procName, parameters))); }
public List <T> FindListBySql <T>(string strSql, DbParameter[] parameters) { return(DatabaseReader.ReaderToList <T>(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters))); }
public List <T> FindList <T>() where T : new() { StringBuilder builder = DatabaseCommon.SelectSql <T>(); return(DatabaseReader.ReaderToList <T>(DbHelper.ExecuteReader(CommandType.Text, builder.ToString()))); }
public Hashtable FindHashtableBySql(string strSql) { return(DatabaseReader.ReaderToHashtable(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString()))); }
public T FindEntityBySql <T>(string strSql, DbParameter[] parameters) { return(DatabaseReader.ReaderToModel <T>(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters))); }