GetAll Method (EntFile)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal entId As Nullable(Of Integer), _
ByVal filePath As String, _
ByVal fileDesc As String, _
ByVal fileType As String, _
ByVal lastModified As Nullable(Of Date), _
ByVal fileSize As Nullable(Of Integer), _
ByVal author As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim entId As Nullable(Of Integer)
Dim filePath As String
Dim fileDesc As String
Dim fileType As String
Dim lastModified As Nullable(Of Date)
Dim fileSize As Nullable(Of Integer)
Dim author As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = EntFile.GetAll(entId, filePath, fileDesc, fileType, lastModified, fileSize, author, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> entId,
string filePath,
string fileDesc,
string fileType,
Nullable<DateTime> lastModified,
Nullable<int> fileSize,
string author,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- entId
- Optional filter parameter. Holds the ID of the entity with which the file is associated.
- filePath
- Optional filter parameter. Holds the path and file name of the file.
- fileDesc
- Optional filter parameter. Holds the description of the file.
- fileType
- Optional filter parameter. Holds the file extension of the file.
- lastModified
- Optional filter parameter. Holds the date/time of the last time the file was modified.
- fileSize
- Optional filter parameter. Holds the size of the file in bytes.
- author
- Optional filter parameter. Holds the name of the author of the file.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who created or last updated a entity file record.
- lastEditAt
- Optional filter parameter. Holds the date and time when a entity file record was created or last updated.
Return Value
Returns a DataSet that contains all the records in the Ent_File table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
ent_id |
An integer that is the ID of the entity with which the file is associated. |
|
file_path |
A string that is the path and file name. |
|
file_desc |
A string that is the file description. |
|
file_type |
A string that is the file extension of the associated file. The file extension is pulled from the filename in the file_path column. |
|
last_modified |
A date/time that is the last time the file was modified. |
|
file_size |
An integer that is the size of the file in bytes. |
|
author |
A string that is the author. |
|
spare1 |
A string that is the contents of spare1 field. |
|
spare2 |
A string that is the contents of spare2 field. |
|
spare3 |
A string that is the contents of spare3 field. |
|
spare4 |
A string that is the contents of spare4 field. |
|
last_edit_comment |
A string that contains comments about why the record was created or updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A date/time that indicates when the record was added or last updated. |