unit1.h

从ms-sql move data to oracle DB 的客户端

//---------------------------------------------------------------------------

#ifndef Unit1H
#define Unit1H
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include <ADODB.hpp>
#include <DB.hpp>
#include <DBGrids.hpp>
#include <Grids.hpp>
//---------------------------------------------------------------------------
class TForm1 : public TForm
{
__published:	// IDE-managed Components
        TADOConnection *ADOConnection1;
        TADOTable *tbc;
        TButton *bt_client;
        TMemo *Memo1;
        TADOQuery *qry;
        TButton *bt_agent;
        TButton *bt_csales;
        TButton *bt_asales;
        TButton *tb_slist;
        TButton *tb_instore;
        TButton *bt_instore_list;
        TButton *tb_shopstock;
        TButton *tb_agentstock;
        TButton *tb_spc_sales;
        TButton *tb_spc_sales_list;
        TButton *bt_switch;
        TButton *bt_comm;
        TButton *bt_pt_part;
        void __fastcall bt_clientClick(TObject *Sender);
        void __fastcall bt_agentClick(TObject *Sender);
        void __fastcall bt_csalesClick(TObject *Sender);
        void __fastcall bt_asalesClick(TObject *Sender);
        void __fastcall tb_slistClick(TObject *Sender);
        void __fastcall tb_instoreClick(TObject *Sender);
        void __fastcall bt_instore_listClick(TObject *Sender);
        void __fastcall tb_shopstockClick(TObject *Sender);
        void __fastcall tb_agentstockClick(TObject *Sender);
        void __fastcall tb_spc_salesClick(TObject *Sender);
        void __fastcall tb_spc_sales_listClick(TObject *Sender);
        void __fastcall bt_switchClick(TObject *Sender);
        void __fastcall bt_commClick(TObject *Sender);
        void __fastcall bt_pt_partClick(TObject *Sender);
private:	// User declarations
        AnsiString      tempstr;
        AnsiString      sqlstr;
        AnsiString      temp_merch;
        int             temp_code;
public:		// User declarations
        __fastcall TForm1(TComponent* Owner);

        AnsiString __fastcall get_opid(AnsiString operator_id);
        AnsiString __fastcall get_area_code(AnsiString area_code);
        AnsiString __fastcall get_shop_id(AnsiString shop_id);
        AnsiString __fastcall get_sales_mgrid(AnsiString opid);
        AnsiString __fastcall get_store_id(AnsiString store_id);
        AnsiString __fastcall get_merch_code(AnsiString merch_code);
};
//---------------------------------------------------------------------------
extern PACKAGE TForm1 *Form1;
//---------------------------------------------------------------------------
#endif