📄 cppbuilder.txt
字号:
//---------------------------------------------------------------------------
#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;
}
//---------------------------------------------------------------------------
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -