qu_fawork.cpp

速达开源ERP系统

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

#include <vcl.h>
#pragma hdrstop

#include "Qu_FaWork.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "QueryBaseForm"
#pragma link "SDGrid"
#pragma link "fpanel"
#pragma link "SDComboBox"
#pragma resource "*.dfm"
TfrmQu_FaWork *frmQu_FaWork;
//---------------------------------------------------------------------------
__fastcall TfrmQu_FaWork::TfrmQu_FaWork(TComponent* Owner)
        : TQueryBaseForm(Owner)
{
    m_FilterStr=""; //查询条件字串
    m_SQL="";      //查询语句
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::ClearControl(bool BringToNext)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::GetDataFromComObject()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::WaitUserInput()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::RefreshGridData(int mAction)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::DisplayBill()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::GetBill(AnsiString BillID)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmQu_FaWork::FillGridWithData()
{
    TComResultSet *RsQuery=NewResultSet();
    AnsiString  ItemStr="",m_fadnawork,m_fadntwork,m_empty="";
    if(m_FilterStr=="")
      m_FilterStr="";
    else
      m_FilterStr=" where  "+m_FilterStr;
    m_SQL=" select * from sdVW_FaWork "+m_FilterStr+" order by FAWORKFMONTH desc";
    sgFaWork->RowCount=1;
    try
    {
     RsQuery->Open(m_SQL,"FAWORKFMONTH+FADNCODE");
     RsQuery->MoveFirst();
     while( RsQuery->Eof == 0)
     {
      m_fadnawork=RsQuery->FieldByName("FADNAWORK");
      m_fadntwork=RsQuery->FieldByName("FADNTWORK");
      ItemStr="\t"+RsQuery->FieldByName("FAWORKFMONTH")+
           "\t"+RsQuery->FieldByName("FADNCODE")+
           "\t"+RsQuery->FieldByName("FADNNAME")+
           "\t"+RsQuery->FieldByName("FAWORKLOAD")+
           "\t"+(RsQuery->FieldByName("FAWORKFMONTH")==g_sdEMonth ? m_fadnawork:m_empty)+
           "\t"+(RsQuery->FieldByName("FAWORKFMONTH")==g_sdEMonth ? m_fadntwork:m_empty)+
           "\t"+(RsQuery->FieldByName("FAWORKFMONTH")==g_sdEMonth ? AnsiString(m_fadntwork.ToInt()-m_fadnawork.ToInt()):m_empty);
      sgFaWork->AddItem(ItemStr);
      RsQuery->MoveNext();
     }
     RsQuery->Close();
   }
   __finally
   {
    delete RsQuery;
   } 
}
//---------------------------------------------------------------------------
bool __fastcall TfrmQu_FaWork::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_FaWork::tbQueryClick(TObject *Sender)
{
  if(!ShowQueryWindow())
    return;
  try{
    StartWaitForm("正在查询,请稍候...");

    FillGridWithData();
  }
  __finally
  {
    EndWaitForm();
  }
        
        
}
//---------------------------------------------------------------------------

void __fastcall TfrmQu_FaWork::tbRefreshClick(TObject *Sender)
{
    if(m_SQL=="")
      FillGridWithData();
    
}
//---------------------------------------------------------------------------

void __fastcall TfrmQu_FaWork::muFirstClick(TObject *Sender)
{
   if(sgFaWork->RowCount > 1)
    sgFaWork->Row=1;
        
}
//---------------------------------------------------------------------------

void __fastcall TfrmQu_FaWork::muPreviousClick(TObject *Sender)
{
   if( sgFaWork->Row>1)
    sgFaWork->Row--;
        
}
//---------------------------------------------------------------------------

void __fastcall TfrmQu_FaWork::muNextClick(TObject *Sender)
{
   if( sgFaWork->Row < sgFaWork->RowCount-1)
    sgFaWork->Row++;
        
}
//---------------------------------------------------------------------------

void __fastcall TfrmQu_FaWork::muLastClick(TObject *Sender)
{
   if(sgFaWork->RowCount > 1)
    sgFaWork->Row=sgFaWork->RowCount-1;
        
}
//---------------------------------------------------------------------------