qu_apsl.cpp

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

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

#include <vcl.h>
#pragma hdrstop

#include "Qu_Apsl.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "QueryBaseForm"
#pragma link "fpanel"
#pragma link "SDComboBox"
#pragma link "SDGrid"
#pragma link "KSAdvReport"
#pragma resource "*.dfm"
TfrmQu_Apsl *frmQu_Apsl;
//---------------------------------------------------------------------------
__fastcall TfrmQu_Apsl::TfrmQu_Apsl(TComponent* Owner, HWND chWnd, AnsiString MidCode,AnsiString WhereStr)
        : TQueryBaseForm(Owner,chWnd,MidCode,WhereStr)
{
    m_SQL="";      //查询语句
    QueryGrid=sgApsl;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::ClearControl(bool BringToNext)
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::GetDataFromComObject()
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::WaitUserInput()
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::RefreshGridData(int mAction)
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::DisplayBill()
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::GetBill(AnsiString BillID)
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::FillGridWithData()
{
   TComResultSet *RsQuery=new  TComResultSet(Handle,g_ClientHandle);
   AnsiString  ItemStr="",m_FiStr="";
   if(FilterStr=="")
       m_FiStr="";
   else
       m_FiStr=" where "+FilterStr;
   m_SQL=" select * from sdVW_Apsl "+m_FiStr+" order by ApslFmonth";
   sgApsl->RowCount=1;
   try
   {
     RsQuery->Open(m_SQL,"");
     RsQuery->MoveFirst();
     while( RsQuery->Eof == 0)
     {
     ItemStr= "\t" +RsQuery->FieldByName("ApslFmonth")    +
              "\t" +RsQuery->FieldByName("ApslSupplyName")+
              "\t" +RsQuery->FieldByName("ApslCurrency")  +
              "\t" +RsQuery->FieldByName("ApslEnrate")    +
              "\t" +RsQuery->FieldByName("ApslDocTypeName")+
              "\t" +RsQuery->FieldByName("ApslDocCode")    +
              "\t" +RsQuery->FieldByName("ApslDate")   +
              "\t" +RsQuery->FieldByName("ApslAmt")    +
              "\t" +RsQuery->FieldByName("ApslDirName")   ;
      sgApsl->AddItem(ItemStr);
      RsQuery->MoveNext();
    }
    RsQuery->Close();
  }
  __finally
  {
    delete RsQuery;
  }
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::tbQueryClick(TObject *Sender)
{
  //if(!ShowQueryWindow())
 //  return;
  try{
    StartWaitForm("正在查询,请稍候...");
    FillGridWithData();
     }
   __finally
   {
    EndWaitForm();
   }
}
//---------------------------------------------------------------------------

void __fastcall TfrmQu_Apsl::muFirstClick(TObject *Sender)
{
   if(sgApsl->RowCount > 1)
    sgApsl->Row=1;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::muPreviousClick(TObject *Sender)
{
   if( sgApsl->Row>1)
    sgApsl->Row--;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::muNextClick(TObject *Sender)
{
   if( sgApsl->Row < sgApsl->RowCount-1)
    sgApsl->Row++;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::muLastClick(TObject *Sender)
{
  if(sgApsl->RowCount > 1)
    sgApsl->Row=sgApsl->RowCount-1;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apsl::tbRefreshClick(TObject *Sender)
{
  if(m_SQL.IsEmpty())
     return;
  else
     FillGridWithData();

}
//---------------------------------------------------------------------------