Invoices Class

Definition

Namespace: MbcsCentral.WinGL
Assembly: MbcsCentral (in MbcsCentral.exe) Version: 2.0.1.15 (2.0.1.15)
C#
public class Invoices : clsDB, INotifyPropertyChanged
Inheritance
Object    clsDB    Invoices
Derived
Implements
INotifyPropertyChanged

Constructors

Properties

ACH 
ACH_TYPE 
AllocationFlag 
Allowance 
Amount 
AmountPaid 
AmountToPay 
AmountWithDiscount 
Batch 
CheckDate 
CheckGroup 
CheckNumber 
ColumnCount Reports column count
(Inherited from clsDB)
Company 
Date 
DateLastPaid 
Department 
DepartmentName 
Description 
Discount 
DiscountAmount 
DiscountDollar 
EFT 
ErrorMessage Used to retrieve internal error messages
(Inherited from clsDB)
FullInvoiceNumber 
InvoiceKey 
InvoiceNumber 
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)
Memo 
MemoId 
PayDueDate 
PayFlag 
Prefix 
PrePaid 
RowForegroundBrush 
Suffix 
Vendor 
VendorName 
VendorNumber 

Methods

BuildSqlStatements 
delete Delete record
(Inherited from clsDB)
EqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
fill 
FinalizeAllows 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)
GetHashCodeServes as the default hash function.
(Inherited from Object)
GetTableSchema Gets a table schema
(Inherited from clsDB)
GetTypeGets the Type of the current instance.
(Inherited from Object)
insertRecord Inserts a new record using instantiated Insert statement
(Inherited from clsDB)
load(String) 
load(Int32, String) 
load(Boolean, Boolean, String) 
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)
LoadByInvoice 
loadByPrimaryKey Load a record by Primary Key
(Inherited from clsDB)
loadByVendor 
loadForBatch 
LoadForChecks 
LoadForPayment 
LoadQuery 
MemberwiseCloneCreates 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 
SetTable 
ToStringReturns 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)

Events

Fields

BASE_TABLE 
CompanyDelimiter 
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_ACH 
m_ACH_TYPE 
m_AllocationFlag 
m_Allowance 
m_Amount 
m_AmountPaid 
m_AmountToPay 
m_Batch 
m_CheckDate 
m_CheckGroup 
m_CheckNumber 
m_Company 
m_Date 
m_DateLastPaid 
m_Department 
m_DepartmentName 
m_Description 
m_Discount 
m_DiscountAmount 
m_DiscountDollar 
m_EFT 
m_InvoiceKey 
m_InvoiceNumber 
m_isChanged 
m_Memo 
m_MemoId 
m_PayDueDate 
m_PayFlag 
m_Prefix 
m_PrePaid 
m_Suffix 
m_Vendor 
m_VendorName 
m_VendorNumber 
priKeyName
(Inherited from clsDB)
SQL_COL_ACH 
SQL_COL_ACH_TYPE 
SQL_COL_ALLOCATION_FLAG 
SQL_COL_ALLOWANCE 
SQL_COL_AMOUNT 
SQL_COL_AMOUNT_PAID 
SQL_COL_AMOUNT_TO_PAY 
SQL_COL_BATCH 
SQL_COL_CHECK_DATE 
SQL_COL_CHECK_GROUP 
SQL_COL_CHECK_NUMBER 
SQL_COL_COMPANY 
SQL_COL_DATE 
SQL_COL_DATE_LAST_PAID 
SQL_COL_DEPARTMENT 
SQL_COL_DESCRIPTION 
SQL_COL_DISCOUNT 
SQL_COL_DISCOUNT_AMOUNT 
SQL_COL_DISCOUNT_DOLLAR 
SQL_COL_EFT 
SQL_COL_INVOICE_KEY 
SQL_COL_INVOICE_NUMBER 
SQL_COL_MEMO 
SQL_COL_MEMO_ID 
SQL_COL_PAY_DUE_DATE 
SQL_COL_PAY_FLAG 
SQL_COL_PREFIX 
SQL_COL_SUFFIX 
SQL_COL_VENDOR_NUMBER 
SQL_DELETE
(Inherited from clsDB)
SQL_INSERT 
SQL_LOAD 
SQL_LOAD_ALL 
SQL_LOAD_BY_BATCH 
SQL_LOAD_BY_INVOICE 
SQL_LOAD_BY_VENDOR 
SQL_LOAD_FOR_ACH 
SQL_LOAD_FOR_CHECKS 
SQL_LOAD_FOR_PAYMENTS 
SQL_LOAD_FOR_SELECTION 
SQL_UPDATE 
TABLE 
TenantDelimiter 
updateStmt
(Inherited from clsDB)

See Also