atpquery.h

来自「一个以前收集的基于C/S架构的ERP客户端源代码」· C头文件 代码 · 共 100 行

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

#ifndef ATPQueryH
#define ATPQueryH
//---------------------------------------------------------------------------
#include <Classes.hpp>
#include <Controls.hpp>
#include <StdCtrls.hpp>
#include <Forms.hpp>
#include "KSAdvReport.h"
#include "QueryBaseForm.h"
#include <ComCtrls.hpp>
#include <Dialogs.hpp>
#include <ImgList.hpp>
#include <Menus.hpp>
#include <ToolWin.hpp>
#include "SDGrid.h"
#include <Grids.hpp>
#include "fpanel.h"
#include "SDEdit.h"
//---------------------------------------------------------------------------
class TfrmATPQuery : public TQueryBaseForm
{
__published:	// IDE-managed Components
    TPageControl *pctMain;
    TTabSheet *atpClothInv;
    TSDGrid *sgATPCloth;
    TTabSheet *pctPurchase;
    TSDGrid *sgATPPurchase;
    TTabSheet *pctSale;
    TSDGrid *sgATPSale;
    TTabSheet *pctAnswerDate;
    TFloatPanel *fpAnswerDate;
    TGroupBox *GroupBox1;
    TLabel *Label2;
    TLabel *Label3;
    TLabel *Label4;
    TSDEdit *seMaxSohQty;
    TSDEdit *seMinSohQty;
    TSDEdit *seAvgSohQty;
    TLabel *Label8;
    TLabel *Label9;
    TLabel *Label10;
    TGroupBox *GroupBox2;
    TLabel *Label12;
    TLabel *Label13;
    TSDEdit *seDGMinSohQty;
    TSDEdit *seDGAvgSohQty;
    TTabSheet *pctAnswerQty;
    TSDGrid *sgATPAnswerQty;
    TLabel *Label7;
    TSDEdit *seDGMaxSohQty;
    TLabel *Label14;
    TLabel *Label15;
    TLabel *Label16;
    TLabel *Label1;
    TSDEdit *seAnswerDate;
    TLabel *Label6;
    TSDEdit *seRecDateAvgSohQty;
    TLabel *Label5;
    TSDEdit *seDateAvgSohQty;
    TLabel *Label11;
    TLabel *Label17;
private:	// User declarations
      void __fastcall ClearControl(bool BringToNext);
      void __fastcall GetDataFromComObject();
      void __fastcall WaitUserInput();
      void __fastcall RefreshGridData(int mAction);
      void __fastcall DisplayBill();
      void __fastcall GetBill(AnsiString BillID);

      void __fastcall FillGridWithData();
      void __fastcall FillPurchaseGridWithData();
      void __fastcall FillSaleGridWithData();
      void __fastcall FillAnswerDateGridWithData();
      void __fastcall FillAnswerQtyGridWithData();
        AnsiString sSQL;      //查询语句
        AnsiString __fastcall GetQueryStr();
        AnsiString __fastcall GetPurchaseQueryStr();
        AnsiString __fastcall GetSaleQueryStr();

        AnsiString __fastcall GetAnswerDateQueryStr();
        AnsiString __fastcall GetMaxSohQtyQueryStr();
        AnsiString __fastcall GetMinSohQtyQueryStr();
        AnsiString __fastcall GetAvgSohQtyQueryStr();
        AnsiString __fastcall GetDateAvgSohQtyQueryStr();
        AnsiString __fastcall GetRecDateAvgSohQtyQueryStr();

        AnsiString __fastcall GetDGMaxSohQtyQueryStr();
        AnsiString __fastcall GetDGMinSohQtyQueryStr();
        
        AnsiString iMidCode;
public:		// User declarations
    __fastcall TfrmATPQuery(TComponent* Owner, HWND chWnd, AnsiString MidCode,AnsiString WhereStr);
};
//---------------------------------------------------------------------------
extern PACKAGE TfrmATPQuery *frmATPQuery;
//---------------------------------------------------------------------------
#endif