ordform.h

suite component ace report

//---------------------------------------------------------------------------
#ifndef ordformH
#define ordformH
//---------------------------------------------------------------------------
#include <vcl\Classes.hpp>
#include <vcl\Controls.hpp>
#include <vcl\StdCtrls.hpp>
#include <vcl\Forms.hpp>
#include <vcl\DB.hpp>
#include <vcl\DBTables.hpp>
#include <vcl\DBGrids.hpp>
#include <vcl\Grids.hpp>
#include <vcl\DBCtrls.hpp>
#include <vcl\ExtCtrls.hpp>
#include <vcl\Mask.hpp>
#include "SctRep.hpp"
#include "SctVar.hpp"
#include "SctCtrl.hpp"
#include "SctBtn.hpp"
#include <vcl\Buttons.hpp>
#include "AcePage.hpp"
#include <Db.hpp>
//---------------------------------------------------------------------------
class TFormOrders : public TForm
{
__published:	// IDE-managed Components 
	TDataSource *CustomerSource;
	TTable *CustomerTable;
	TTable *OrdersTable;
	TDataSource *OrdersSource;
	TDBGrid *DBGrid2;
	TDBNavigator *DBNavigator1;
	TDBEdit *DBEdit1;
	TDBEdit *DBEdit2;
	TDBEdit *DBEdit3;
	TDBEdit *DBEdit4;
	TDBEdit *DBEdit6;
	TDBEdit *DBEdit7;
	TDBEdit *DBEdit8;
	TDBEdit *DBEdit9;
	TDBEdit *DBEdit10;
	TLabel *Label1;
	TLabel *Label2;
	TLabel *Label3;
	TLabel *Label4;
	TLabel *Label5;
	TLabel *Label6;
	TLabel *Label7;
	TTable *ItemsTable;
	TDataSource *ItemsSource;
	TTable *PartsTable;
	TDataSource *PartsSource;
	TSctReport *SctReport1;
	TSctGrouppage *ReportPage;
	TSctBand *ReportHeaderBand;
	TSctLevel *ReportHeaderBandlevel;
	TSctBand *PageHeaderBand;
	TSctLevel *PageHeaderBandlevel;
	TSctBand *DetailBand;
	TSctLevel *DetailBandlevel;
	TSctBand *PageFooterBand;
	TSctLevel *PageFooterBandlevel;
	TSctBand *ReportFooterBand;
	TSctLevel *ReportFooterBandlevel;
	TSctDateTimeVar *svarDateTime;
	TSctPageVar *svarPage;
	TSctDataSourceGuide *DataSourceGuide;
	TSctDataSourceGuide *DataSourceGuide1;
	TSctDataSourceGuide *DataSourceGuide2;
	TSctDataSourceGuide *DataSourceGuide3;
	TSctDBVar *customertableCUSTNO;
	TSctDBVar *customertableCOMPANY;
	TSctDBVar *customertableADDR1;
	TSctDBVar *customertableADDR2;
	TSctDBVar *customertableCITY;
	TSctDBVar *customertableSTATE;
	TSctDBVar *customertableZIP;
	TSctDBVar *customertableCOUNTRY;
	TSctDBVar *customertablePHONE;
	TSctDBVar *customertableFAX;
	TSctDBVar *customertableTAXRATE;
	TSctDBVar *customertableCONTACT;
	TSctDBVar *customertableLASTINVOICEDATE;
	TSctDBVar *orderstableORDERNO;
	TSctDBVar *orderstableCUSTNO;
	TSctDBVar *orderstableSALEDATE;
	TSctDBVar *orderstableSHIPDATE;
	TSctDBVar *orderstableEMPNO;
	TSctDBVar *orderstableSHIPTOCONTACT;
	TSctDBVar *orderstableSHIPTOADDR1;
	TSctDBVar *orderstableSHIPTOADDR2;
	TSctDBVar *orderstableSHIPTOCITY;
	TSctDBVar *orderstableSHIPTOSTATE;
	TSctDBVar *orderstableSHIPTOZIP;
	TSctDBVar *orderstableSHIPTOCOUNTRY;
	TSctDBVar *orderstableSHIPTOPHONE;
	TSctDBVar *orderstableSHIPVIA;
	TSctDBVar *orderstablePO;
	TSctDBVar *orderstableTERMS;
	TSctDBVar *orderstablePAYMENTMETHOD;
	TSctDBVar *orderstableITEMSTOTAL;
	TSctDBVar *orderstableTAXRATE;
	TSctDBVar *orderstableFREIGHT;
	TSctDBVar *orderstableAMOUNTPAID;
	TSctDBVar *itemstableORDERNO;
	TSctDBVar *itemstableITEMNO;
	TSctDBVar *itemstablePARTNO;
	TSctDBVar *itemstableQTY;
	TSctDBVar *itemstableDISCOUNT;
	TSctDBVar *partstablePARTNO;
	TSctDBVar *partstableVENDORNO;
	TSctDBVar *partstableDESCRIPTION;
	TSctDBVar *partstableONHAND;
	TSctDBVar *partstableONORDER;
	TSctDBVar *partstableCOST;
	TSctDBVar *partstableLISTPRICE;
	TSctSubDataBand *SubDataDetailBand;
	TSctLevel *SubDataDetailBandlevel;
	TSctOverlayBand *OverLay;
	TSctLevel *OverLayLevel;
	TSctExprVar *ExprItemsAmount;
	TSctTotalvar *TotalofExprItemsAmount;
	TSctExprVar *ExprAddress;
	TSctShape *SctShape3;
	TSctShape *SctShape1;
	TSctvarlabel *TSctvarlabel5;
	TSctImageLabel *SctImageLabel1;
	TSctTextLabel *SctTextLabel1;
	TSctTextLabel *SctTextLabel2;
	TSctTextLabel *SctTextLabel3;
	TSctTextLabel *SctTextLabel4;
	TSctTextLabel *SctTextLabel5;
	TSctTextLabel *SctTextLabel6;
	TSctTextLabel *SctTextLabel7;
	TSctTextLabel *SctTextLabel9;
	TSctShape *SctShape4;
	TSctTextLabel *SctTextLabel15;
	TSctShape *SctShape5;
	TSctShape *SctShape6;
	TSctShape *SctShape7;
	TSctTextLabel *SctTextLabel16;
	TSctTextLabel *SctTextLabel17;
	TSctTextLabel *SctTextLabel18;
	TSctvarlabel *Sctvarlabel1;
	TSctvarlabel *Sctvarlabel3;
	TSctvarlabel *Sctvarlabel4;
	TSctvarlabel *Sctvarlabel5;
	TSctTextLabel *SctTextLabel19;
	TSctvarlabel *Sctvarlabel6;
	TSctLine *SctLine1;
	TSctBarCodeLabel *SctBarCodeLabel1;
	TSctvarlabel *TSctvarlabel8;
	TSctvarlabel *TSctvarlabel9;
	TSctvarlabel *TSctvarlabel10;
	TSctvarlabel *Sctvarlabel2;
	TSctTextLabel *SctTextLabel14;
	TSctTotalvarLabel *SctTotalvarLabel1;
	TSctVerticalDivider *SctVerticalDivider1;
	TSctTextLabel *SctTextLabel8;
	TSctShape *SctShape2;
	TSctVerticalDivider *SctVerticalDivider2;
	TSctTextLabel *SctTextLabel13;
	TSctTextLabel *SctTextLabel10;
	TSctTextLabel *SctTextLabel11;
	TSctTextLabel *SctTextLabel12;
	TSctReportButton *SctReportButton1;
	TSctDataFootBand *SubDataDetailBandFoot;
	TSctLevel *SubDataDetailBandFootlevel;
	void __fastcall FormClose(TObject *Sender, TCloseAction &Action);
	void __fastcall ExprItemsAmountGetData(TSctVar *oVar);
	void __fastcall SctTextLabel14LabelPrintWhen(TSctLabel *lb, bool &Result);
	
	void __fastcall ReportPageAfterDataSkip(TSctGrouppage *Page);
	void __fastcall ExprAddressGetData(TSctVar *oVar);
	void __fastcall SctTotalvarLabel1LabelPrintWhen(TSctLabel *lb,
	bool &Result);
private:	// User declarations
public:		// User declarations
	virtual __fastcall TFormOrders(TComponent* Owner);
};
//---------------------------------------------------------------------------
extern TFormOrders *FormOrders;
//---------------------------------------------------------------------------
#endif