GetAll Method (CustContact)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal custId As String, _
ByVal contactId As Nullable(Of Integer), _
ByVal contactName As String, _
ByVal department As String, _
ByVal phone As String, _
ByVal fax As String, _
ByVal email As String, _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim custId As String
Dim contactId As Nullable(Of Integer)
Dim contactName As String
Dim department As String
Dim phone As String
Dim fax As String
Dim email As String
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = CustContact.GetAll(custId, contactId, contactName, department, phone, fax, email, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string custId,
Nullable<int> contactId,
string contactName,
string department,
string phone,
string fax,
string email,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- custId
- Optional filter parameter. Holds a customer or vendor ID.
- contactId
- Optional filter parameter. Holds a contact ID.
- contactName
- Optional filter parameter. Holds the name of a contact.
- department
- Optional filter parameter. Holds a department name.
- phone
- Optional filter parameter. Holds a contact phone number.
- fax
- Optional filter parameter. Holds a contact fax number.
- Optional filter parameter. Holds a contact email.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- lastEditBy
- Optional filter parameter. Holds the user who created or last updated the record.
- lastEditAt
- Optional filter parameter. Holds the date and time that the record was added or last updated.
Return Value
Returns a DataSet that contains a DataRow for each contact record that matches the specified filter criteria. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Names |
Description |
|---|---|
|
cust_id |
A string that is the customer or vendor ID. |
|
contact_id |
An integer that is the contact ID. |
|
contact_name |
A string that is the contact's name. |
|
dept |
A string that is the contact's department. |
|
phone |
A string that is the contact's phone number. |
|
fax |
A string that is the contact's fax number. |
|
|
A string that is the contact's email address. |
|
customer |
A Boolean flag that indicates whether the contact is associated with a customer (true) or a vendor (false) record in the Cust table. |
|
spare1 |
A string that is the content of the user-defined spare1 field. |
|
spare2 |
A string that is the content of the user-defined spare2 field. |
|
spare3 |
A string that is the content of the user-defined spare3 field. |
|
spare4 |
A string that is the content of the user-defined spare4 field. |
|
last_edit_comment |
A string that contains comments about why the record was added 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 datetime that indicates when the record was added or last updated. It is used by other methods that modify or delete this type of record for optimistic concurrency control. |
|
mod_id |
The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes. |