//---------------------------------------------------------------------------
#include <vcl.h>
#pragma hdrstop

#include "Unit2.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma link "dcInfoDBRel"
#pragma link "dcInfoRel"
#pragma link "dcInfoDB"
#pragma resource "*.dfm"
TDataModule2 *DataModule2;
//---------------------------------------------------------------------------
__fastcall TDataModule2::TDataModule2(TComponent* Owner)
    : TDataModule(Owner)
{
}
//---------------------------------------------------------------------------
void __fastcall TDataModule2::OrdByCustNewRecord(TDataSet *DataSet)
{
    NextOrd->Open();
    try
     {
      NextOrd->Edit();
      OrdByCustOrderNo->Value = NextOrdNewKey->Value;
      NextOrdNewKey->Value++;
      NextOrd->Post();
     } 
    __finally
     {
      NextOrd->Close();
     }
  OrdByCustEmpNo->Value = 1;    
}
//---------------------------------------------------------------------------

void __fastcall TDataModule2::CustBeforePost(TDataSet *DataSet)
{
  if (Cust->State == dsInsert) 
    {
      NextCust->Open();
      try
      {
        NextCust->Edit();
        CustCustNo->Value = NextCustNewCust->Value;
        NextCustNewCust->Value++;;
        NextCust->Post();
      }  
      __finally
      {
        NextCust->Close();
      }
    }
}
//---------------------------------------------------------------------------


void __fastcall TDataModule2::ItemsByOrdBeforePost(TDataSet *DataSet)
{
 int FItemNo;

  if (ItemsByOrdItemNo->IsNull) 
  {
    LastItemQuery->Close();
    LastItemQuery->Open();
//    { SQL servers return Null for some aggregates if no items are present 
      #if __BCPLUSPLUS__>0x0530
      if (LastItemQuery->Fields->Fields[0]->IsNull) FItemNo = 1;
      else FItemNo = LastItemQuery->Fields->Fields[0]->AsInteger + 1;
      #else
      if (LastItemQuery->Fields[0]->IsNull) FItemNo = 1;
      else FItemNo = LastItemQuery->Fields[0]->AsInteger + 1;
      #endif

    ItemsByOrdItemNo->Value = FItemNo;
  }
}
//---------------------------------------------------------------------------

void __fastcall TDataModule2::DataModule2Create(TObject *Sender)
{
  LastItemQuery->SQL->Text = "select max(ItemNo)  from Items where OrderNo = :OrderNo";
  LastItemQuery->DataSource =OrdersSource;    
  
}
//---------------------------------------------------------------------------