public class Department : clsDB, INotifyPropertyChanged| Department | |
| Department | Initializes a new instance of the Department class |
| Department(Int16, Int16, Int32, Boolean, String, String, String, String, String) | Initializes a new instance of the Department class |
| City | |
| ColumnCount |
Reports column count
(Inherited from clsDB) |
| CompanyNumber | |
| DepartmentNumber | |
| ErrorMessage |
Used to retrieve internal error messages
(Inherited from clsDB) |
| Id | |
| InActive | |
| IsChanged | Has record been modified? |
| IsDupe |
Set true when a duplicate record is found on insertion
(Inherited from clsDB) |
| Item |
Generic method for getting values of property by names. Useful when iterating through columns in a record
(Inherited from clsDB) |
| Name | |
| State | |
| StreetAddress | |
| Zip |
| delete |
Delete record
(Inherited from clsDB) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object) |
| fill | |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object) |
| GetColumn |
Finds if specified Column name is in table. Datarows must have already been fetched.
(Inherited from clsDB) |
| GetHashCode | Serves as the default hash function. (Inherited from Object) |
| GetTableSchema |
Gets a table schema
(Inherited from clsDB) |
| GetType | Gets the Type of the current instance. (Inherited from Object) |
| insertRecord |
Inserts a new record using instantiated Insert statement
(Inherited from clsDB) |
| load(Int32) | |
| load(Boolean, Boolean) | |
| load(String, String, Boolean) |
Retrieve records from a table using the passes SQL string
(Inherited from clsDB) |
| loadAll |
Retrieve all records in a table
(Inherited from clsDB) |
| loadByCompany | |
| loadByDepartment | |
| loadByPrimaryKey |
Load a record by Primary Key
(Inherited from clsDB) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object) |
| OnPropertyChanged | |
| query |
Execute custom query. Used mainly for special deletion scenarios
(Inherited from clsDB) |
| queryWithCount |
Custome query for getting record counts
(Inherited from clsDB) |
| save | Save or Update a record |
| ToString | Returns a string that represents the current object. (Inherited from Object) |
| updateRecord |
Updates records using update statement passed with child class instantiation
(Inherited from clsDB) |
| updateRecordSpecial |
Updates records using passed update statement
(Inherited from clsDB) |
| connectionString | (Inherited from clsDB) |
| DataSetName | (Inherited from clsDB) |
| insertStmt | (Inherited from clsDB) |
| loadAllStmt | (Inherited from clsDB) |
| loadStmt | (Inherited from clsDB) |
| LoadStmt | (Inherited from clsDB) |
| localCN | (Inherited from clsDB) |
| localTable | (Inherited from clsDB) |
| m_City | |
| m_CompanyNumber | |
| m_DepartmentNumber | |
| m_Id | |
| m_InActive | |
| m_isChanged | |
| m_Name | |
| m_State | |
| m_StreetAddress | |
| m_Zip | |
| priKeyName | (Inherited from clsDB) |
| SQL_COL_CITY | |
| SQL_COL_COMPANY_NUMBER | |
| SQL_COL_DEPARTMENT_NUMBER | |
| SQL_COL_ID | |
| SQL_COL_IN_ACTIVE | |
| SQL_COL_NAME | |
| SQL_COL_STATE | |
| SQL_COL_STREET_ADDRESS | |
| SQL_COL_ZIP | |
| SQL_DELETE | (Inherited from clsDB) |
| SQL_INSERT | |
| SQL_LOAD | |
| SQL_LOAD_ALL | |
| SQL_LOAD_BY_COMPANY | |
| SQL_LOAD_BY_DEPARTMENT | |
| SQL_UPDATE | |
| TABLE | |
| updateStmt | (Inherited from clsDB) |