Проектирование программы формирования заказов по грузоперевозкам

Дипломная работа - Компьютеры, программирование

Другие дипломы по предмету Компьютеры, программирование

e. InsertBefore (Form1.DBGrid1. DataSource. DataSet. Fields[j].AsString);.DBGrid1. DataSource. DataSet. Next;;. Visible:=true;;TForm1.N16Click (Sender: TObject);(0,open, помощь.chm, nil, nil, SW_SHOWNORMAL);;TForm1.N1Click (Sender: TObject);. Show;;TForm1.N3Click (Sender: TObject);. Active:=false;. CommandText:= select * from Postavshiki;. Active:=true;;TForm1.N5Click (Sender: TObject);. Active:=false;. CommandText:=select * from Gruzi;. Active:=true;;TForm1.N6Click (Sender: TObject);.show;;TForm1.N7Click (Sender: TObject);. Active:=false;. CommandText:=select * From klienti;. Active:=true;;TForm1.N8Click (Sender: TObject);. Active:=false;. CommandText:=select * from transport;. Active:=true;;TForm1.N9Click (Sender: TObject);. Active:=false;. CommandText:=select * from zakazi;. Active:=true;;.

Форма 2Unit2;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, StdCtrls, jpeg, ExtCtrls, pngimage, Unit1;= class(TForm): TEdit;: TButton;: TButton;: TLabel;Button1Click (Sender: TObject);Button2Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm2;

//uses Unit1;

{$R *.dfm}TForm2. Button1Click (Sender: TObject);a:string;:=edit1. Text;.ADODataSet1. Active:=false;.ADODataSet1. CommandText:=select * From klienti where Код_клиента like +quotedstr ( % +a+ % )+;.ADODataSet1. Active:=true;;TForm2. Button2Click (Sender: TObject);.close;;.

Форма 3Unit3;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, StdCtrls, Unit1;= class(TForm): TEdit;: TButton;: TButton;: TLabel;Button1Click (Sender: TObject);Button2Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm3;

{$R *.dfm}TForm3. Button1Click (Sender: TObject);a:string;:=edit1. Text;.ADODataSet1. Active:=false;.ADODataSet1. CommandText:=select * From postavshiki where Код_поставщика like +quotedstr ( % +a+ % )+;.ADODataSet1. Active:=true;;TForm3. Button2Click (Sender: TObject);. Close;;.

Форма 4Unit4;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, Unit1, StdCtrls;= class(TForm): TEdit;: TLabel;: TButton;: TButton;Button1Click (Sender: TObject);Button2Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm4;

{$R *.dfm}TForm4. Button1Click (Sender: TObject);a:string;:=edit1. Text;.ADODataSet1. Active:=false;.ADODataSet1. CommandText:=select * From zakazi where №_Заказа like +quotedstr ( % +a+ % )+;.ADODataSet1. Active:=true;;TForm4. Button2Click (Sender: TObject);. Close;;.

Форма 5Unit5;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, Unit1, StdCtrls;= class(TForm): TButton;: TButton;: TEdit;: TLabel;Button2Click (Sender: TObject);Button1Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm5;Unit4;

{$R *.dfm}TForm5. Button1Click (Sender: TObject);.close;;TForm5. Button2Click (Sender: TObject);a:string;:=edit1. Text;.ADODataSet1. Active:=false;.ADODataSet1. CommandText:=select * From transport where Вид_транспорта like +quotedstr ( % +a+ % )+;.ADODataSet1. Active:=true;;.

Форма 6Unit6;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, StdCtrls, Unit1;= class(TForm): TButton;: TButton;: TEdit;: TLabel;Button1Click (Sender: TObject);Button2Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm6;

{$R *.dfm}TForm6. Button1Click (Sender: TObject);. Close;;TForm6. Button2Click (Sender: TObject);a:string;:=edit1. Text;.ADODataSet1. Active:=false;.ADODataSet1. CommandText:=select * From Gruzi where Тип_груза like +quotedstr ( % +a+ % )+;.ADODataSet1. Active:=true;;.

Форма 7Unit7;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, StdCtrls;= class(TForm): TEdit;: TButton;: TOpenDialog;: TButton;Button1Click (Sender: TObject);Button2Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm7;Unit1, Unit2;

{$R *.dfm}TForm7. Button1Click (Sender: TObject);

// если соединение установлено

if Form1.ADODataSet1. Active=true then begin

// выводим сообщение

showmessage (Отключите БД!!!)

// если не установленоbegin

// очищаем строку подключения

Form1.ADODataSet1. ConnectionString:= ;

// если файл БД существуетOpenDialog1. Execute then begin

// добавляем путь к файлу в эдит1. Text:=OpenDialog1. FileName;

// задаем провайдер и путь к файлу БД

Form1.ADODataSet1. ConnectionString:=Provider=Microsoft. Jet.OLEDB.4.0; Data Source=+(Edit1. Text);. Close;;;TForm7. Button2Click (Sender: TObject);

// отключаем файл.ADODataSet1. Active:=false;. Clear;;;.

Форма 9Unit9;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, StdCtrls, Mask, Unit1, DBCtrls;= class(TForm): TDBEdit;: TDBEdit;: TDBEdit;: TDBEdit;: TDBEdit;: TDBEdit;: TLabel;: TLabel;: TLabel;: TLabel;: TLabel;: TLabel;: TButton;: TButton;Button1Click (Sender: TObject);Button2Click (Sender: TObject);FormClose (Sender: TObject; var Action: TCloseAction);

{Private declarations}

{Public declarations};: TForm9;

{$R *.dfm}TForm9. Button1Click (Sender: TObject);. AdoDataSet1. Insert;. DataField:=Код_клиента;. DataField:=Фамилия;. DataField:=Имя;. DataField:=Отчество;. DataField:=Тип_лица;. DataField:=Адрес_клиента;;TForm9. Button2Click (Sender: TObject);.ADODataSet1. Post;. Close;;TForm9. FormClose (Sender: TObject; var Action: TCloseAction);. DataField:=;. DataField:=;. DataField:=;. DataField:=;. DataField:=;. DataField:=;;.

Форма 10Unit10;, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,, StdCtrls;= class(TForm): TButton;: TButton;: TLabel;Button1Click (Sender: TObject);Button2Click (Sender: TObject);

{Private declarations}

{Public declarations};: TForm10;Unit1;

{$R *.dfm}TForm10. Button1Click (Sender: TObject);.close;;TForm10. Button2Click (Sender: TObject);. Close;;.