nreds.cpp

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

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

#include <vcl.h>
#pragma hdrstop

#include "NrEds.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "RecBaseForm"
#pragma link "fpanel"
#pragma link "SDEdit"
#pragma link "SDGrid"
#pragma link "SDComboBox"
#pragma link "DateEdit"
#pragma resource "*.dfm"
TfrmNrEds *frmNrEds;
//---------------------------------------------------------------------------
__fastcall TfrmNrEds::TfrmNrEds(TComponent* Owner, HWND chWnd, AnsiString MidCode,AnsiString WhereStr)
        : TRecBaseForm(Owner,chWnd,MidCode,WhereStr)
{
}
//---------------------------------------------------------------------------
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::ClearControl(bool BringToNext)
{
    if(!BringToNext)
    {
      seNrEdsCode->Text="";  //票据号码
      seNrEdsFmonth->Text=g_sdFMonth;  //月份
      deNrEdsDate->Text   =g_sdCurDate;  //日期
      seNrEdsSupply->Text   ="";
      seNrEdsAmt->Text   ="0.00";
      seNrEdsInr->Text   ="0.00";  //利息
      seNrEdsExp->Text   ="0.00";  //费用
      scNrEdsExpense->ItemIndex =-1;  //费用类型
      scNrEdsReason->ItemIndex =-1;
      lblNrEdsUser->Caption =g_sdUserCode;  //操作员
      memNrEdsDesc->Text   ="";
    }
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::InitEditControl()
{
       ClientGroup->AddComponent(2,false,false,true, FloatPanel1,FloatPanel1->Name);
       ClientGroup->AddComponent(2,true,true,false, sgNrEds,sgNrEds->Name);
       ClientGroup->AddComponent(2,false,true,true, seNrEdsCode,seNrEdsCode->Name);
       ClientGroup->AddComponent(2,true,true,true, seNrEdsFmonth,seNrEdsFmonth->Name);
       FillComboBox(Handle,scNrEdsExpense,"select ExpenseCode+'-'+ExpenseName Memo,ExpenseCode from sdExpense order by ExpenseCode" ,"Memo","ExpenseCode");
       FillComboBox(Handle,scNrEdsReason,"select EdsrCode+'-'+EdsrDesc Memo,EdsrCode from sdEdsr order by EdsrCode" ,"Memo","EdsrCode");
       FillEdit(Handle,seNrEdsSupply,"select SupplyCode+'-'+SupplyName Memo,SupplyCode from sdSupply order by SupplyCode" ,"Memo","SupplyCode");
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::GetDataFromComObject()
{
      seNrEdsCode->Text   =GetFieldValue("NrEdsCode");
      sgNrEds->LocateGrid(1,GetFieldValue("NrEdsCode"));
      seNrEdsFmonth->Text =GetFieldValue("NrEdsFmonth");
      deNrEdsDate->Text   =GetFieldValue("NrEdsDate");
      seNrEdsSupply->LocateKey(GetFieldValue("NrEdsSupply"));
      seNrEdsAmt->Text   =GetFieldValue("NrEdsAmt");
      seNrEdsInr->Text   =GetFieldValue("NrEdsInr");
      seNrEdsExp->Text   =GetFieldValue("NrEdsExp");
      scNrEdsExpense->LocateKey(GetFieldValue("NrEdsExpense"));
      scNrEdsExpense->Text  = scNrEdsExpense->ItemData[0];
      scNrEdsReason->LocateKey(GetFieldValue("NrEdsReason"));
      scNrEdsReason->Text  = scNrEdsReason->ItemData[0];
      lblNrEdsUser->Caption  = GetFieldValue("NrEdsUser");
      memNrEdsDesc->Text   =GetFieldValue("NrEdsDesc");
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::SendDataToComObject()
{
      SetFieldValue("NrEdsCode",seNrEdsCode->Text);
      SetFieldValue("NrEdsFmonth",seNrEdsFmonth->Text);
      SetFieldValue("NrEdsDate",deNrEdsDate->Text);
      SetFieldValue("NrEdsSupply",seNrEdsSupply->ItemData[1]);
      SetFieldValue("NrEdsAmt",seNrEdsAmt->Text);
      SetFieldValue("NrEdsInr",seNrEdsInr->Text);
      SetFieldValue("NrEdsExp",seNrEdsExp->Text);
      SetFieldValue("NrEdsExpense",scNrEdsExpense->ItemData[1]);
      SetFieldValue("NrEdsReason",scNrEdsReason->ItemData[1]);
      SetFieldValue("NrEdsUser",lblNrEdsUser->Caption);
      SetFieldValue("NrEdsDesc",memNrEdsDesc->Text);
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::WaitUserInput()
{
      if(seNrEdsCode->Enabled)
       seNrEdsCode->SetFocus();
}
//---------------------------------------------------------------------------
AnsiString __fastcall TfrmNrEds::GetDataToGrid()
{
      scNrEdsReason->LocateKey(GetFieldValue("NrEdsReason"));
      AnsiString  s;
      s = "\t" + GetFieldValue("NrEdsCode")    +
          "\t" + GetFieldValue("NrEdsSupply")  +
          "\t" + scNrEdsReason->ItemData[0]    ;
      return s;
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::RefreshGridData(int mAction)
{
      AnsiString ItemStr;
      ItemStr = GetDataToGrid();
      if (mAction ==  0)   //Add
      {
          sgNrEds->AddItem(ItemStr);
      }
      else if(mAction ==  1)   //Modify
      {
          int i   =   sgNrEds->Row;
          sgNrEds->ChangeItem(ItemStr,i);
      }
      else if(mAction ==  2)      //Delete
      {
          sgNrEds->RemoveItem(sgNrEds->Row);
      }
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::FillGridWithData()
{
      AnsiString ItemStr;
      comServer->MoveFirst();
      sgNrEds->RowCount    =   1;
      while (comServer->Eof   ==  0)
      {
         ItemStr =  GetDataToGrid();
         sgNrEds->AddItem(ItemStr);
         comServer->MoveNext();
      }
      comServer->MoveFirst();
}
//---------------------------------------------------------------------------

void __fastcall TfrmNrEds::FormShow(TObject *Sender)
{
      FillGridWithData();
      comServer->MoveFirst();
      GetDataFromComObject();
}
//---------------------------------------------------------------------------

void __fastcall TfrmNrEds::sgNrEdsClick(TObject *Sender)
{
      if (sgNrEds->Row > 0)
          comServer->LocateByKey(WideString(sgNrEds->TextMatrix[sgNrEds->Row][1]));
      if (comServer->RecordCount>0)
          GetDataFromComObject();
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::seNrEdsCodeExit(TObject *Sender)
{
    if(CurrentState==caNormal)
    {
      comServer->LocateByKey(WideString(seNrEdsCode->Text));
      GetDataFromComObject();
    }
}
//---------------------------------------------------------------------------

void __fastcall TfrmNrEds::seNrEdsCodeButtonClick(TObject *Sender)
{
    if(CurrentState!=caNormal)
    {
      AnsiString SqlStr;
      SqlStr="005[票据编号][登记日期][票据金额][客户名称][币种代码]select ArnrCode,ArnrDate,ArnrAmt,ClientName,ArnrCurrency from sdArnr,sdClient ";
      SqlStr+=" where ArnrClient=ClientCode and ArnrState=1 and ArnrCheck=1 ";
      SqlStr+=" order by ArnrCode ";
      TfrmWnQuery *p;
      try
      {
        StartWaitForm("正在查询,请稍候...");
        p=new TfrmWnQuery(this,"票据查询",SqlStr);
      }
      __finally
      {
        EndWaitForm();
      }
      if(p->ShowModal()==mrOk)
      {
        seNrEdsCode->Text=p->ColData[1];
        seNrEdsAmt->Text=p->ColData[3];
      }
      delete p;
    }

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

void __fastcall TfrmNrEds::seNrEdsSupplyButtonClick(TObject *Sender)
{
    AnsiString SqlStr;
    SqlStr="002[供应商代码][供应商名称]select Supplycode,SupplyName from sdSupply ";
    SqlStr+=" order by SupplyCode ";
    TfrmWnQuery *p;
    try
    {
      StartWaitForm("正在查询,请稍候...");
      p=new TfrmWnQuery(this,"供应商查询",SqlStr);
    }
    __finally
    {
      EndWaitForm();
    }
    if(p->ShowModal()==mrOk)
    {
      seNrEdsSupply->LocateKey(p->ColData[1]);
    }
    delete p;
}
//---------------------------------------------------------------------------
void __fastcall TfrmNrEds::RefreshUpdateData(int MsgSrc,int MsgType)
{
/*
  switch(MsgSrc)
  {
   case euSdExpense:
    if(ShowUpdateMessage(MsgSrc,MsgType))
    {
       FillComboBox(Handle,scNrEdsExpense,"select ExpenseCode+'-'+ExpenseName Memo,ExpenseCode from sdExpense order by ExpenseCode" ,"Memo","ExpenseCode");
    }
    break;
   case euSdEdsr:
    if(ShowUpdateMessage(MsgSrc,MsgType))
    {
       FillComboBox(Handle,scNrEdsReason,"select EdsrCode+'-'+EdsrDesc Memo,EdsrCode from sdEdsr order by EdsrCode" ,"Memo","EdsrCode");
    }
    break;
   case euSdSupply:
    if(ShowUpdateMessage(MsgSrc,MsgType))
    {
       FillEdit(Handle,seNrEdsSupply,"select SupplyCode+'-'+SupplyName Memo,SupplyCode from sdSupply order by SupplyCode" ,"Memo","SupplyCode");
    }
    break;
   default:
    break;
  }
*/
}
//---------------------------------------------------------------------------