88
#include <ADODB.hpp>
#include <DB.hpp>
#include <DBGrids.hpp>
#include <Grids.hpp>
#include <DBCtrls.hpp>
#include <Menus.hpp>
//-------------------------------------------------------
--------------------
class TFormVnalichii : public TForm
{
__published: // IDE-managed
Components
TDBGrid *DBGridComputerTehnika;
TADODataSet
*ADODataSetComputerTehnika;
TDataSource *DataSourceComputerTehnika;
TAutoIncField
*ADODataSetComputerTehnikaCod;
TWideStringField
*ADODataSetComputerTehnikaName;
TBCDField
*ADODataSetComputerTehnikaCena;
TBooleanField
*ADODataSetComputerTehnikaProdan;
TDateTimeField
*ADODataSetComputerTehnikaDataPostup;
TMemoField
*ADODataSetComputerTehnikaOpisanie;
TBlobField
*ADODataSetComputerTehnikaPicture;
TIntegerField
*ADODataSetComputerTehnikaCodVidTehni
ki;
TDataSource *DataSourceVidTehniki;
TADODataSet *ADODataSetVidTehniki;
TStringField
*ADODataSetComputerTehnikaNameVidTeh
niki;
TDBImage *DBImageFoto;
TDBMemo *DBMemoOpisanie;
TButton *ButtonExit;
TButton *ButtonPrint;
TPopupMenu *PopupMenu1;
TMenuItem *N1;
TMenuItem *N2;
void __fastcall ButtonExitClick(TObject
*Sender);
void __fastcall
DBGridComputerTehnikaCellClick(TColumn
*Column);
void __fastcall FormShow(TObject *Sender);
void __fastcall ButtonPrintClick(TObject
*Sender);
void __fastcall N1Click(TObject *Sender);
void __fastcall N2Click(TObject *Sender);
private: // User declarations
public: // User declarations
__fastcall TFormVnalichii(TComponent*
Owner);
};
//-------------------------------------------------------
--------------------
extern PACKAGE TFormVnalichii
*FormVnalichii;
//-------------------------------------------------------
--------------------
#endif
//-------------------------------------------------------
--------------------
#include <vcl.h>
#pragma hdrstop
#include "ComputerTehnika.h"
#include "DM.h"
//-------------------------------------------------------
--------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TFormComputerTehnika
*FormComputerTehnika;
//-------------------------------------------------------
--------------------
__fastcall
TFormComputerTehnika::TFormComputerTe
hnika(TComponent* Owner)
: TForm(Owner)
{
}
//-------------------------------------------------------
--------------------
void __fastcall
TFormComputerTehnika::ButtonFotoClick(T
Object *Sender)
{ char *s;
OpenDialogFoto->InitialDir=
ExtractFileDir(Application->ExeName);
if(OpenDialogFoto->Execute()==true) //вызов
диалога выбора файла
{DBImageFoto->Visible=true;
s= OpenDialogFoto->FileName.c_str();
//получить наименование выбранного
файла с полным путем
DBImageFoto->Picture->LoadFromFile(s);
}
else
{if(ADODataSetComputerTehnikaPicture-
>Value=="")
DBImageFoto->Visible=false;
}
}
//-------------------------------------------------------
--------------------
void __fastcall
TFormComputerTehnika::FormShow(TObject
*Sender)
{
ADODataSetComputerTehnika->Close();
ADODataSetComputerTehnika->Open();
ADODataSetVidTehniki->Close();
ADODataSetVidTehniki->Open();
}
//-------------------------------------------------------
--------------------
//Выполняется при нажатии кнопки
Добавить
void __fastcall
TFormComputerTehnika::ButtonAddClick(TO
bject *Sender)
{
if(ADODataSetComputerTehnika-
>State==dsBrowse)
{ADODataSetComputerTehnika->Insert();
Panel1->Visible=false;
Panel2->Visible=true;
GroupBox1->Visible=true;
DateTimePickerDataPostup->Date= Date();
DBEditName->SetFocus();
}
}
//-------------------------------------------------------
--------------------
//Выполняется при нажатии кнопки
Удалить
void __fastcall
TFormComputerTehnika::ButtonDeleteClick(
TObject *Sender)
{
if(ADODataSetComputerTehnika-
>RecordCount==0) //есть ли данные в БД
{ButtonChange->Enabled=false;//сделать
кнопку Изменить недоступной