home *** CD-ROM | disk | FTP | other *** search
/ CD Actual 9 / CDACTUAL9.iso / progs / CB / DATA.Z / DMCSDEMO.HPP < prev    next >
Encoding:
C/C++ Source or Header  |  1996-08-12  |  3.9 KB  |  125 lines
  1. //---------------------------------------------------------------------------
  2. #ifndef DmCSDemoHPP
  3. #define DmCSDemoHPP
  4. //---------------------------------------------------------------------------
  5. #include <vcl.h>
  6. #pragma hdrstop
  7. //---------------------------------------------------------------------------
  8. #ifndef WindowsHPP
  9. #include <windows.hpp>
  10. #endif
  11.  
  12. #ifndef MessagesHPP
  13. #include <messages.hpp>
  14. #endif
  15.  
  16. #ifndef SysUtilsHPP
  17. #include <sysutils.hpp>
  18. #endif
  19.  
  20. #ifndef ClassesHPP
  21. #include <classes.hpp>
  22. #endif
  23.  
  24. #ifndef GraphicsHPP
  25. #include <graphics.hpp>
  26. #endif
  27.  
  28. #ifndef ControlsHPP
  29. #include <controls.hpp>
  30. #endif
  31.  
  32. #ifndef FormsHPP
  33. #include <forms.hpp>
  34. #endif
  35.  
  36. #ifndef DialogsHPP
  37. #include <dialogs.hpp>
  38. #endif
  39.  
  40. #ifndef DBHPP
  41. #include <db.hpp>
  42. #endif
  43.  
  44. #ifndef DBTablesHPP
  45. #include <dbtables.hpp>
  46. #endif
  47. //---------------------------------------------------------------------------
  48. class TDmEmployee : public TDataModule
  49. {
  50. __published:
  51.     TDatabase *EmployeeDatabase;
  52.     TStoredProc *ShipOrderProc;
  53.     TStoredProc *DeleteEmployeeProc;
  54.     TTable *EmployeeLookup;
  55.     TSmallintField *SmallintField1;
  56.     TStringField *StringField1;
  57.     TStringField *StringField2;
  58.     TStringField *StringField3;
  59.     TDateTimeField *DateTimeField1;
  60.     TStringField *StringField4;
  61.     TStringField *StringField5;
  62.     TSmallintField *SmallintField2;
  63.     TStringField *StringField6;
  64.     TFloatField *FloatField1;
  65.     TStringField *StringField7;
  66.     TTable *SalesTable;
  67.     TStringField *SalesTablePO_NUMBER;
  68.     TIntegerField *SalesTableCUST_NO;
  69.     TSmallintField *SalesTableSALES_REP;
  70.     TStringField *SalesTableORDER_STATUS;
  71.     TDateTimeField *SalesTableORDER_DATE;
  72.     TDateTimeField *SalesTableSHIP_DATE;
  73.     TDateTimeField *SalesTableDATE_NEEDED;
  74.     TStringField *SalesTablePAID;
  75.     TIntegerField *SalesTableQTY_ORDERED;
  76.     TIntegerField *SalesTableTOTAL_VALUE;
  77.     TFloatField *SalesTableDISCOUNT;
  78.     TStringField *SalesTableITEM_TYPE;
  79.     TFloatField *SalesTableAGED;
  80.     TTable *CustomerTable;
  81.     TIntegerField *CustomerTableCUST_NO;
  82.     TStringField *CustomerTableCUSTOMER;
  83.     TStringField *CustomerTableCONTACT_FIRST;
  84.     TStringField *CustomerTableCONTACT_LAST;
  85.     TStringField *CustomerTablePHONE_NO;
  86.     TStringField *CustomerTableADDRESS_LINE1;
  87.     TStringField *CustomerTableADDRESS_LINE2;
  88.     TStringField *CustomerTableCITY;
  89.     TStringField *CustomerTableSTATE_PROVINCE;
  90.     TStringField *CustomerTableCOUNTRY;
  91.     TStringField *CustomerTablePOSTAL_CODE;
  92.     TStringField *CustomerTableON_HOLD;
  93.     TTable *EmployeeTable;
  94.     TSmallintField *EmployeeTableEMP_NO;
  95.     TStringField *EmployeeTableFIRST_NAME;
  96.     TStringField *EmployeeTableLAST_NAME;
  97.     TStringField *EmployeeTablePHONE_EXT;
  98.     TDateTimeField *EmployeeTableHIRE_DATE;
  99.     TStringField *EmployeeTableDEPT_NO;
  100.     TStringField *EmployeeTableJOB_CODE;
  101.     TSmallintField *EmployeeTableJOB_GRADE;
  102.     TStringField *EmployeeTableJOB_COUNTRY;
  103.     TFloatField *EmployeeTableSALARY;
  104.     TStringField *EmployeeTableFULL_NAME;
  105.     TTable *SalaryHistoryTable;
  106.     TStringField *SalaryHistoryTableEMPLOYEE;
  107.     TSmallintField *SalaryHistoryTableEMP_NO;
  108.     TDateTimeField *SalaryHistoryTableCHANGE_DATE;
  109.     TStringField *SalaryHistoryTableUPDATER_ID;
  110.     TFloatField *SalaryHistoryTableOLD_SALARY;
  111.     TFloatField *SalaryHistoryTablePERCENT_CHANGE;
  112.     TFloatField *SalaryHistoryTableNEW_SALARY;
  113.     TDataSource *SalesSource;
  114.     TDataSource *CustomerSource;
  115.     TDataSource *EmployeeSource;
  116.     TDataSource *SalaryHistorySource;
  117. private:        // private user declarations
  118. public:         // public user declarations
  119.     virtual __fastcall TDmEmployee(TComponent* Owner);
  120. };
  121. //---------------------------------------------------------------------------
  122. extern TDmEmployee *DmEmployee;
  123. //---------------------------------------------------------------------------
  124. #endif
  125.