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