qu_apcavh.cpp

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

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

#include <vcl.h>
#pragma hdrstop

#include "Qu_Apcavh.h"
#include "Qu_Apcavd.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "QueryBaseForm"
#pragma link "SDGrid"
#pragma link "KSAdvReport"
#pragma resource "*.dfm"
TfrmQu_Apcavh *frmQu_Apcavh;
//---------------------------------------------------------------------------
__fastcall TfrmQu_Apcavh::TfrmQu_Apcavh(TComponent* Owner, HWND chWnd, AnsiString MidCode,AnsiString WhereStr)
        : TQueryBaseForm(Owner,chWnd,MidCode,WhereStr)
{
    m_SQL="";      //查询语句
    QueryGrid=sgApcavh;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::ClearControl(bool BringToNext)
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::GetDataFromComObject()
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::WaitUserInput()
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::RefreshGridData(int mAction)
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::DisplayBill()
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::GetBill(AnsiString BillID)
{
   return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::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_Apcavh "+m_FiStr+" order by ApcavhCode";
   sgApcavh->RowCount=1;
   try
   {
     RsQuery->Open(m_SQL,"");
     RsQuery->MoveFirst();
     while( RsQuery->Eof == 0)
     {
     ItemStr= "\t" +RsQuery->FieldByName("ApcavhCode")    +
              "\t" +RsQuery->FieldByName("ApcavhDate")    +
              "\t" +RsQuery->FieldByName("ApcavhDocTypeName")    +
              "\t" +RsQuery->FieldByName("ApcavhDocCode")    +
              "\t" +RsQuery->FieldByName("ApcavhPAmt")    +
              "\t" +RsQuery->FieldByName("ApcavhCAmt")    +
              "\t" +RsQuery->FieldByName("ApcavhUser")    +
              "\t" +(RsQuery->FieldByName("ApcavhCheck")==1?"审核":"未审核")+
              "\t" +RsQuery->FieldByName("ApcavhChecker")    +
              "\t" +RsQuery->FieldByName("ApcavhCheckDate")    +
              "\t" +RsQuery->FieldByName("ApcavhSysDate") +
              "\t" +RsQuery->FieldByName("ApcavhDesc")    ;
      sgApcavh->AddItem(ItemStr);
      RsQuery->MoveNext();
    }
    RsQuery->Close();
   }
   __finally
   {
     delete RsQuery;
   }
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::tbQueryClick(TObject *Sender)
{
//  if(!ShowQueryWindow())
//   return;
  try{
    StartWaitForm("正在查询,请稍候...");
    FillGridWithData();
     }
   __finally
   {
    EndWaitForm();
   }
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::tbRefreshClick(TObject *Sender)
{
   if(m_SQL!="")
     FillGridWithData();
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::muFirstClick(TObject *Sender)
{
   if(sgApcavh->RowCount > 1)
    sgApcavh->Row=1;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::muPreviousClick(TObject *Sender)
{
   if( sgApcavh->Row>1)
    sgApcavh->Row--;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::muNextClick(TObject *Sender)
{
   if( sgApcavh->Row < sgApcavh->RowCount-1)
    sgApcavh->Row++;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::muLastClick(TObject *Sender)
{
   if(sgApcavh->RowCount > 1)
    sgApcavh->Row=sgApcavh->RowCount-1;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_Apcavh::sgApcavhDblClick(TObject *Sender)
{
   if(sgApcavh->Row>0 &&sgApcavh->Row<sgApcavh->RowCount)    //当前行无效
     {
      TfrmQu_Apcavd *m_Apcavd= new TfrmQu_Apcavd(this,sgApcavh->TextMatrix[sgApcavh->Row][1],sgApcavh->TextMatrix[sgApcavh->Row][3]);
      m_Apcavd->ShowModal();
      delete m_Apcavd;
     }
}
//---------------------------------------------------------------------------