ВУЗ:
Составители:
75
Ⱥɧɚɥɨɝɢɱɧɵɦ ɨɛɪɚɡɨɦ ɦɨɠɧɨ ɩɨɥɭɱɢɬɶ ɤɨɞ ɜɜɨɞɚ ɬɟɤɫɬɚ ɜ ɤɨɥɨɧɬɢ-
ɬɭɥɵ, ɧɚɫɬɪɨɣɤɭ ɲɪɢɮɬɨɜ, ɚɛɡɚɰɟɜ ɢ ɬ. ɩ.
Ɋɟɲɟɧɢɟ ɩɨɫɬɚɜɥɟɧɧɨɣ ɡɚɞɚɱɢ ɩɪɢɜɟɞɟɧɨ ɜ ɫɥɟɞɭɸɳɟɦ ɥɢɫɬɢɧɝɟ:
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls,
Forms,
Dialogs, StdCtrls, DB, ADODB, ActiveX;
type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
ADODataSet1: TADODataSet;
Button1: TButton;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
procedure TableExport(Word,Document,Selection: Variant; DataSet:
TDataSet; Title,FlagText: String);
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
uses ComObj;
{$R *.dfm}
procedure TForm1.Button1Click(Sender: TObject);
var
Word: Variant;
Document: Variant;
Selection: Variant;
Vr: OleVariant;
begin
Screen.Cursor := crHourGlass;
//ɫɨɡɞɚɟɬɫɹ ɫɟɪɜɟɪ ɚɜɬɨɦɚɬɢɡɚɰɢɢ Word
Word := CreateOleObject('Word.Application');
try
//ɫɨɡɞɚɟɬɫɹ ɧɨɜɵɣ ɞɨɤɭɦɟɧɬ ɩɨ ɲɚɛɥɨɧɭ
Document := Word.Documents.Add(GetCurrentDir+'\Shablon.doc');
//ɜɵɛɢɪɚɟɬɫɹ ɩɟɪɜɚɹ ɧɚɞɩɢɫɶ
Vr := 'Text Box 8';
Document.Shapes.Item(Vr).Select;
//ɡɚɩɨɦɢɧɚɟɬɫɹ ɫɫɵɥɤɚ ɧɚ ɨɛɴɟɤɬ Selection
Selection := Word.Selection;
//ɩɢɲɟɬɫɹ ɬɟɤɫɬ
Selection.TypeText('ɬɟɤɫɬ ɧɚ ɬɢɬɭɥɶɧɨɣ');
//ɩɟɪɟɯɨɞ ɜ ɤɨɧɟɰ ɞɨɤɭɦɟɧɬɚ
Vr := wdStory;
Selection.EndKey(Vr);
//ɩɟɪɟɯɨɞ ɜ ɜɟɪɯɧɢɣ ɤɨɥɨɧɬɢɬɭɥ
Word.ActiveWindow.ActivePane.View.SeekView := wdSeekCurrent-
PageHeader;
Vr := 'Text Box 5';
Selection.HeaderFooter.Shapes.Item(Vr).Select;
Word.Selection.TypeText('ɬɟɤɫɬ ɜ ɤɨɥɨɧɬɢɬɭɥɟ');
Word.ActiveWindow.ActivePane.View.SeekView := wdSeekMain-
Document;
ADODataSet1.Close;
ADODataSet1.CommandText := 'SELECT [Main].[Tel],
[Main].[name], '+
'[Main].[House], [Korp].[NameKorp], [Flat].[NameFlat],
[Ul].[NameUl] '+
' FROM Main, Ul, Korp, Flat WHERE ([Main].[IdUl]=[Ul].[IdUl])
And '+
'([Main].[IdKorp]=[Korp].[IdKorp]) And '+
'([Main].[IdFlat]=[Flat].[IdFlat]) ';
ADODataSet1.Open;
//ɧɚɫɬɪɚɢɜɚɸɬɫɹ ɩɚɪɚɦɟɬɪɵ ɷɤɫɩɨɪɬɚ
//ɡɚɝɨɥɨɜɨɤ
ADODataSet1.fields[0].DisplayLabel := 'Ɍɟɥɟɮɨɧ';
//ɲɢɪɢɧɚ ɫɬɨɥɛɰɚ
ADODataSet1.fields[0].Tag := round(Word.CentimetersToPoints(2));
//ɨɬɨɛɪɚɠɚɬɶ ɩɨɥɟ
DataSet1.fields[0].Visible := True;
76
����������� ������� ����� �������� ��� ����� ������ � �������- Screen.Cursor := crHourGlass; ����, ��������� �������, ������� � �. �. //��������� ������ ������������� Word ������� ������������ ������ ��������� � ��������� ��������: Word := CreateOleObject('Word.Application'); unit Unit1; try //��������� ����� �������� �� ������� interface Document := Word.Documents.Add(GetCurrentDir+'\Shablon.doc'); //���������� ������ ������� uses Vr := 'Text Box 8'; Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Document.Shapes.Item(Vr).Select; Forms, //������������ ������ �� ������ Selection Dialogs, StdCtrls, DB, ADODB, ActiveX; Selection := Word.Selection; type //������� ����� TForm1 = class(TForm) Selection.TypeText('����� �� ���������'); ADOConnection1: TADOConnection; //������� � ����� ��������� ADODataSet1: TADODataSet; Vr := wdStory; Button1: TButton; Selection.EndKey(Vr); procedure Button1Click(Sender: TObject); //������� � ������� ���������� private Word.ActiveWindow.ActivePane.View.SeekView := wdSeekCurrent- { Private declarations } PageHeader; procedure TableExport(Word,Document,Selection: Variant; DataSet: Vr := 'Text Box 5'; TDataSet; Title,FlagText: String); Selection.HeaderFooter.Shapes.Item(Vr).Select; Word.Selection.TypeText('����� � �����������'); public Word.ActiveWindow.ActivePane.View.SeekView := wdSeekMain- { Public declarations } Document; end; ADODataSet1.Close; ADODataSet1.CommandText := 'SELECT [Main].[Tel], var [Main].[name], '+ Form1: TForm1; '[Main].[House], [Korp].[NameKorp], [Flat].[NameFlat], [Ul].[NameUl] '+ implementation ' FROM Main, Ul, Korp, Flat WHERE ([Main].[IdUl]=[Ul].[IdUl]) And '+ uses ComObj; '([Main].[IdKorp]=[Korp].[IdKorp]) And '+ '([Main].[IdFlat]=[Flat].[IdFlat]) '; {$R *.dfm} ADODataSet1.Open; //������������� ��������� �������� procedure TForm1.Button1Click(Sender: TObject); //��������� var Word: Variant; ADODataSet1.fields[0].DisplayLabel := '�������'; Document: Variant; //������ ������� Selection: Variant; ADODataSet1.fields[0].Tag := round(Word.CentimetersToPoints(2)); Vr: OleVariant; //���������� ���� begin DataSet1.fields[0].Visible := True; 75 76
Страницы
- « первая
- ‹ предыдущая
- …
- 36
- 37
- 38
- 39
- 40
- …
- следующая ›
- последняя »