vw_arrsh_hy.cpp

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

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

#include <vcl.h>
#pragma hdrstop

#include "VW_Arrsh_HY.h"
#include "VW_Arrsd_HY.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "QueryBaseForm"
#pragma link "SDGrid"
#pragma link "KSAdvReport"
#pragma resource "*.dfm"
TfrmVW_Arrsh_HY *frmVW_Arrsh_HY;
//---------------------------------------------------------------------------
__fastcall TfrmVW_Arrsh_HY::TfrmVW_Arrsh_HY(TComponent* Owner, HWND chWnd, AnsiString MidCode,AnsiString WhereStr)
        : TQueryBaseForm(Owner,chWnd,MidCode,WhereStr)
{
 //初始化
 FilterStr="";
 sSQL="";
 LateBillCode="";
 sgArrsh->RowCount=1;
 QueryGrid=sgArrsh;
}
//---------------------------------------------------------------------------
__fastcall TfrmVW_Arrsh_HY::TfrmVW_Arrsh_HY(TComponent* Owner, AnsiString wherestr)
        : TQueryBaseForm(Owner)
{
 FilterStr="";
 sSQL="";
 LateBillCode="";
 sgArrsh->RowCount=1;
 QueryGrid=sgArrsh;

 tbControl->Enabled=false;
 TBorderIcons tempBI = BorderIcons;
 tempBI >> biMinimize;
 BorderIcons = tempBI;
 FilterStr=wherestr;
 FillGridWithData();
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::tbQueryClick(TObject *Sender)
{
//  if(!ShowQueryWindow())
//    return;
  try{
    StartWaitForm("正在查询,请稍候...");
    FillGridWithData();
  }
  __finally
  {
    EndWaitForm();
  }
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::ClearControl(bool BringToNext)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::GetDataFromComObject()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::WaitUserInput()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::RefreshGridData(int mAction)
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::DisplayBill()
{
 return;
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::GetBill(AnsiString BillID)
{
 return;
}
//---------------------------------------------------------------------------
//获取查询语句
AnsiString __fastcall TfrmVW_Arrsh_HY::GetQueryStr()
{
 AnsiString Selectstr,Fromstr,Wherestr,Orderstr;
 Selectstr="select "
          +AnsiString("ArrshCode, ")          //核销单号
          +AnsiString("ArrshDate, ")          //核销日期
          +AnsiString("ArrshDocType, ")       //单据类型
          +AnsiString("ArrshDocCode, ")       //来款单据号
          +AnsiString("ArrshUser, ")          //操作员
          +AnsiString("ArrshCheck, ")         //审核
          +AnsiString("ArrshChecker, ")       //审核人
          +AnsiString("ArrshCheckDate, ")     //审核日期
          +AnsiString("ArrshDesc ");          //备注
 Fromstr=" from SdVW_Arrsh ";
 Wherestr=" where ArrshDocType = 3 ";
 if(FilterStr != "")
  Wherestr+=" and "+FilterStr;
 Orderstr=" order by ArrshCode ";
 sSQL=Selectstr+Fromstr+Wherestr+Orderstr;
 return(sSQL);
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::FillGridWithData()
{
 TComResultSet *RsQuery;
 AnsiString ItemStr,sSql;
 //获取查询语句
 sSql=GetQueryStr();
 if(sSql=="")
  return;
 sgArrsh->RowCount=1;
 LateBillCode="";
 RsQuery=new  TComResultSet(Handle,g_ClientHandle);
 RsQuery->Open(sSql,"");
 RsQuery->MoveFirst();
 while( RsQuery->Eof == 0)
 {
  ItemStr=     RsQuery->FieldByName("ArrshCode")+
          "\t"+RsQuery->FieldByName("ArrshDate")+
          "\t"+RsQuery->FieldByName("ArrshDocCode")+
          "\t"+(RsQuery->FieldByName("ArrshCheck")=="1"?"√":"")+
          "\t"+RsQuery->FieldByName("ArrshChecker")+
          "\t"+RsQuery->FieldByName("ArrshCheckDate")+
          "\t"+RsQuery->FieldByName("ArrshUser")+
          "\t"+RsQuery->FieldByName("ArrshDesc");
  sgArrsh->AddItem(ItemStr);
  RsQuery->MoveNext();
 }
 RsQuery->Close();
 delete RsQuery;
}
//---------------------------------------------------------------------------
AnsiString __fastcall TfrmVW_Arrsh_HY::DataConvert(AnsiString sFieldName,AnsiString sFieldValue)
{
 sFieldName=UpperCase(sFieldName);
 if(sFieldName == "DOCTYPE")
 {
  if(sFieldValue == "1")
   return("退款单");
  if(sFieldValue == "2")
   return("退回票据");
  if(sFieldValue == "3")
   return("红字应收单");
 }
 return("");
}
//---------------------------------------------------------------------------
AnsiString __fastcall TfrmVW_Arrsh_HY::GetDetailQueryStr()
{
 AnsiString Selectstr,Fromstr,Wherestr,Orderstr;
 if(sgArrsh->RowCount < 2 || sgArrsh->Row == 0 )    //当前行无效
  return("");
 Selectstr="select "
          +AnsiString("ArrsdLine, ")          //行号
          +AnsiString("ArrsdDocCode, ")
          +AnsiString("ArrsdDocLine, ")
          +AnsiString("ArrsdConv, ")          //换算系数
          +AnsiString("ArrsdRAmt, ")          //红冲金额
          +AnsiString("ArrsdCAmt, ")          //核销金额
          +AnsiString("ArrsdDesc ");          //备注

 Fromstr=" from SdVW_Arrsd ";
 Wherestr =" where ArrsdCode='"+sgArrsh->Cells[0][sgArrsh->Row]+"'";
 Orderstr=" order by ArrsdLine";
 return(Selectstr+Fromstr+Wherestr+Orderstr);
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::FillGridWithDetail()
{
 TComResultSet *RsQuery;
 AnsiString ItemStr,sSql;
 TfrmVW_Arrsd_HY *p;
 //获取查询语句
 sSql=GetDetailQueryStr();
 if(sSql=="")
  return;
 try
 {
  p=new TfrmVW_Arrsd_HY(this);
  p->seCode->Text=sgArrsh->Cells[0][sgArrsh->Row];
  p->seDocCode->Text=sgArrsh->Cells[2][sgArrsh->Row];
  p->sgArrsd->RowCount=1;
  RsQuery=new  TComResultSet(Handle,g_ClientHandle);
  RsQuery->Open(sSql,"");
  RsQuery->MoveFirst();
  while( RsQuery->Eof == 0)
  {
   ItemStr=    RsQuery->FieldByName("ArrsdLine")+
          "\t"+RsQuery->FieldByName("ArrsdDocCode")+
          "\t"+RsQuery->FieldByName("ArrsdDocLine")+
          "\t"+RsQuery->FieldByName("ArrsdConv")+
          "\t"+RsQuery->FieldByName("ArrsdRAmt")+
          "\t"+RsQuery->FieldByName("ArrsdCAmt")+
          "\t"+RsQuery->FieldByName("ArrsdDesc");

   p->sgArrsd->AddItem(ItemStr);
   RsQuery->MoveNext();
  }
  RsQuery->Close();
  if(p->sgArrsd->RowCount > 1)
   p->ShowModal();
 }
 __finally
 {
  delete RsQuery;
  delete p;
 }
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::muFirstClick(TObject *Sender)
{
 if(sgArrsh->RowCount > 1)
 {
  sgArrsh->Row=1;
 }

}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::tbPreviousClick(TObject *Sender)
{
 if(sgArrsh->RowCount > 1 && sgArrsh->Row > 1)
 {
  sgArrsh->Row=sgArrsh->Row-1;
 }
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::muNextClick(TObject *Sender)
{
 if(sgArrsh->RowCount > 1 && sgArrsh->Row < sgArrsh->RowCount-1)
 {
  sgArrsh->Row=sgArrsh->Row+1;
 }
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::muLastClick(TObject *Sender)
{
 if(sgArrsh->RowCount > 1)
 {
  sgArrsh->Row=sgArrsh->RowCount-1;
 }
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::tbRefreshClick(TObject *Sender)
{
 if(sSQL=="")
  return;
 FillGridWithData();
}
//---------------------------------------------------------------------------
void __fastcall TfrmVW_Arrsh_HY::sgArrshDblClick(TObject *Sender)
{
 int ARow=sgArrsh->Row;
 if(ARow>0)
 {
  FillGridWithDetail();
 }
}
//---------------------------------------------------------------------------