Beispiel #1
0
        public DataTable FindTableTop <T>(int Top, string WhereSql, DbParameter[] parameters) where T : new()
        {
            StringBuilder builder = DatabaseCommon.SelectSql <T>(Top);

            builder.Append(WhereSql);
            return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, builder.ToString(), parameters)));
        }
Beispiel #2
0
        public DataTable FindTable <T>(string WhereSql) where T : new()
        {
            StringBuilder builder = DatabaseCommon.SelectSql <T>();

            builder.Append(WhereSql);
            return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, builder.ToString())));
        }
Beispiel #3
0
        public DataTable FindTableTop <T>(int Top) where T : new()
        {
            StringBuilder builder = DatabaseCommon.SelectSql <T>(Top);

            return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, builder.ToString())));
        }
Beispiel #4
0
 public DataTable FindTableBySql(string strSql, DbParameter[] parameters)
 {
     return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, strSql.ToString(), parameters)));
 }
Beispiel #5
0
 public DataTable FindTableByProc(string procName, DbParameter[] parameters)
 {
     return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.StoredProcedure, procName, parameters)));
 }