qu_adjcoh.cpp

速达开源ERP系统

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

#include <vcl.h>
#pragma hdrstop

#include "Qu_AdjCoh.h"
#include "Qu_AdjCod.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "QueryBaseForm"
#pragma link "SDGrid"
#pragma resource "*.dfm"
TfrmQu_AdjCoh *frmQu_AdjCoh;
//---------------------------------------------------------------------------
__fastcall TfrmQu_AdjCoh::TfrmQu_AdjCoh(TComponent* Owner)
        : TQueryBaseForm(Owner)
{
       m_FilterStr=""; //查询条件字串
       m_SQL="";      //查询语句
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::ClearControl(bool BringToNext)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::GetDataFromComObject()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::WaitUserInput()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::RefreshGridData(int mAction)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::DisplayBill()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::GetBill(AnsiString BillID)
{
 return;
}
//---------------------------------------------------------------------------
bool __fastcall TfrmQu_AdjCoh::ShowQueryWindow()
{
  TfrmQuForm *FQuery=new TfrmQuForm(this,this->Name);
  FQuery->ShowModal();
  if(FQuery->CancelQuery)
    return false;
  m_FilterStr=FQuery->CreateSqlString;
  delete FQuery;
  return true;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::FillGridWithData()
{
  TComResultSet *RsQuery=NewResultSet();
  AnsiString  ItemStr="";
  if(m_FilterStr=="")
    m_FilterStr="";
  else
    m_FilterStr=" where "+m_FilterStr;
  m_SQL="select distinct AdjCohCode,AdjCohDate, AdjCohFmonth,postypename,AdjCohDesc,AdjCohAmt,AdjCohKeeper,AdjCohCheck,AdjCohPost,AdjCohUser,";
  m_SQL=m_SQL+" AdjCohChecker, AdjCohPoster,AdjCohSysDate  from sdVW_AdjCoh "+m_FilterStr+" order by ADJCOHCODE";
  sgAdjCoh->RowCount=1;
  try
  {
    RsQuery->Open(m_SQL,"");
    RsQuery->MoveFirst();
    while( RsQuery->Eof == 0)
    {
      ItemStr="\t"+RsQuery->FieldByName("ADJCOHCODE")+
          "\t"+RsQuery->FieldByName("ADJCOHDATE")+
          "\t"+RsQuery->FieldByName("ADJCOHFMONTH")+
          "\t"+RsQuery->FieldByName("postypename")+
          "\t"+RsQuery->FieldByName("AdjCohDesc")+
          "\t"+RsQuery->FieldByName("AdjCohAmt")+
          "\t"+RsQuery->FieldByName("AdjCohKeeper")+
          "\t"+(RsQuery->FieldByName("AdjCohCheck")=="1" ?"是":"否")+
          "\t"+(RsQuery->FieldByName("AdjCohPost")=="1" ?"是":"否")+
          "\t"+RsQuery->FieldByName("AdjCohUser")+
          "\t"+RsQuery->FieldByName("AdjCohChecker")+
          "\t"+RsQuery->FieldByName("AdjCohPoster")+
          "\t"+RsQuery->FieldByName("AdjCohSysDate");
      sgAdjCoh->AddItem(ItemStr);
      RsQuery->MoveNext();
    }
    RsQuery->Close();
  }
  __finally
  {
    delete RsQuery;
  }
}
void __fastcall TfrmQu_AdjCoh::FillGridWithDetailData()
{
 AnsiString  ItemStr="";
 TfrmQu_AdjCod *m_AdjCod= new TfrmQu_AdjCod(this,sgAdjCoh->TextMatrix[sgAdjCoh->Row][1]);
 m_AdjCod->ShowModal();
 delete m_AdjCod;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::tbQueryClick(TObject *Sender)
{
  if(!ShowQueryWindow())
    return;
  try{
    StartWaitForm("正在查询,请稍候...");
    FillGridWithData();
  }
  __finally
  {
    EndWaitForm();
  }
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::tbRefreshClick(TObject *Sender)
{
    if(m_SQL=="")
      FillGridWithData();
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::muFirstClick(TObject *Sender)
{
   if(sgAdjCoh->RowCount > 1)
    sgAdjCoh->Row=1;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::muPreviousClick(TObject *Sender)
{
   if( sgAdjCoh->Row>1)
    sgAdjCoh->Row--;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::muNextClick(TObject *Sender)
{
   if( sgAdjCoh->Row < sgAdjCoh->RowCount-1)
    sgAdjCoh->Row++;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::muLastClick(TObject *Sender)
{
   if(sgAdjCoh->RowCount > 1)
    sgAdjCoh->Row=sgAdjCoh->RowCount-1;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_AdjCoh::sgAdjCohDblClick(TObject *Sender)
{
   if(sgAdjCoh->Row>0 &&sgAdjCoh->Row<sgAdjCoh->RowCount)    //当前行无效
     {
      TfrmQu_AdjCod *m_AdjCod= new TfrmQu_AdjCod(this,sgAdjCoh->TextMatrix[sgAdjCoh->Row][1]);
      m_AdjCod->ShowModal();
      delete m_AdjCod;
     }
}
//---------------------------------------------------------------------------