Develop and Download Open Source Software

Browse Subversion Repository

Contents of /Unit3.pas

Parent Directory Parent Directory | Revision Log Revision Log


Revision 19 - (show annotations) (download) (as text)
Sat Aug 27 13:22:00 2016 UTC (7 years, 6 months ago) by yamat0jp
File MIME type: text/x-pascal
File size: 3945 byte(s)
暫く制作から離れたいのでコミット
データベースに追加したフィールドがありますメンテナンスフォームも一応表示できます
1 unit Unit3;
2
3 interface
4
5 uses
6 System.SysUtils, System.Classes, FireDAC.Stan.Intf, FireDAC.Stan.Option,
7 FireDAC.Stan.Param, FireDAC.Stan.Error, FireDAC.DatS, FireDAC.Phys.Intf,
8 FireDAC.DApt.Intf, FireDAC.Stan.Async, FireDAC.DApt, FireDAC.UI.Intf,
9 FireDAC.Stan.Def, FireDAC.Stan.Pool, FireDAC.Phys, FireDAC.Phys.IB,
10 FireDAC.Phys.IBDef, Data.DB, FireDAC.Comp.Client, FireDAC.Comp.DataSet,
11 FireDAC.Comp.BatchMove.DataSet, FireDAC.Comp.BatchMove;
12
13 type
14 TDataModule3 = class(TDataModule)
15 FDQuery1: TFDQuery;
16 FDTable1: TFDTable;
17 FDTable2: TFDTable;
18 item: TDataSource;
19 user: TDataSource;
20 FDConnection1: TFDConnection;
21 FDTable1NAME: TWideStringField;
22 FDTable1EMAIL: TWideStringField;
23 FDTable1BIRTH: TDateField;
24 FDTable1ADDRESS: TWideStringField;
25 FDTable1PASSWORD: TWideStringField;
26 FDTable1NUMBER: TIntegerField;
27 FDTable3: TFDTable;
28 form: TDataSource;
29 FDTable3NAME: TWideStringField;
30 FDTable3BGCOLOR: TIntegerField;
31 FDTable2NAME: TWideStringField;
32 FDTable2MAKER: TWideStringField;
33 FDTable2STOCK: TIntegerField;
34 FDTable2WEIGHT: TIntegerField;
35 FDTable2DATE: TDateField;
36 FDTable2COMMENT: TWideMemoField;
37 FDTable2CATEGORY: TWideStringField;
38 FDTable2IMAGE: TBlobField;
39 FDTable2PRICE: TIntegerField;
40 FDTable2THUMBNAIL: TBlobField;
41 FDTable2SERIAL: TIntegerField;
42 FDTable2MASTER: TIntegerField;
43 FDTable3MAILPASS: TWideStringField;
44 FDTable3MAILUSER: TWideStringField;
45 FDTable3MAILHOST: TWideStringField;
46 FDTable1DATE: TDateField;
47 FDTable1ADDRESS2: TWideStringField;
48 FDTable5: TFDTable;
49 item_info: TDataSource;
50 FDTable5VOLUME: TIntegerField;
51 FDTable5NAME: TWideStringField;
52 FDTable5MAKER: TWideStringField;
53 FDTable5PRICE: TIntegerField;
54 FDTable5KEYFIELD: TIntegerField;
55 FDTable6: TFDTable;
56 order: TDataSource;
57 FDTable6NUMBER: TIntegerField;
58 FDTable6ORDER: TIntegerField;
59 FDTable6DATE: TDateField;
60 FDTable6PRICE: TIntegerField;
61 FDTable6LASTORDER: TDateField;
62 FDTable5ORDER: TIntegerField;
63 FDTable5CHECKVALUE: TBooleanField;
64 FDTable4: TFDTable;
65 FDTable4NUMBER: TIntegerField;
66 FDTable4ID: TWideStringField;
67 FDTable4ADDRESS: TWideStringField;
68 FDTable4EMAIL: TWideStringField;
69 FDTransaction1: TFDTransaction;
70 FDTable7: TFDTable;
71 DataSource1: TDataSource;
72 FDTable7NAME: TWideStringField;
73 FDTable7NUMBER: TIntegerField;
74 FDTable7EMAIL: TWideStringField;
75 FDTable7BANK: TWideStringField;
76 FDTable7TEL: TWideStringField;
77 FDTable7ADDRESS: TWideStringField;
78 FDTable7PASSWORD: TWideStringField;
79 FDTableView: TFDTable;
80 FDTableViewNAME: TWideStringField;
81 FDTableViewMAKER: TWideStringField;
82 FDTableViewSTOCK: TIntegerField;
83 FDTableViewWEIGHT: TIntegerField;
84 FDTableViewDATE: TDateField;
85 FDTableViewCATEGORY: TWideStringField;
86 FDTableViewTHUMBNAIL: TBlobField;
87 FDTableViewIMAGE: TBlobField;
88 FDTableViewPRICE: TIntegerField;
89 FDTableViewCOMMENT: TWideMemoField;
90 FDTableViewMASTER: TIntegerField;
91 FDTableViewSERIAL: TIntegerField;
92 view: TDataSource;
93 FDTable5SERIAL: TIntegerField;
94 FDTableViewACTIVATE: TBooleanField;
95 FDTableViewAGREE: TBooleanField;
96 FDTable2AGREE: TBooleanField;
97 FDTable3ENABLE: TBooleanField;
98 procedure FDTableViewAfterInsert(DataSet: TDataSet);
99 private
100 { Private ���� }
101 public
102 { Public ���� }
103 end;
104
105 function DM: TDataModule3;
106
107 implementation
108
109 {%CLASSGROUP 'Vcl.Controls.TControl'}
110
111 uses ServerController;
112
113 {$R *.dfm}
114
115 function DM: TDataModule3;
116 begin
117 result:=UserSession.DM;
118 end;
119
120 procedure TDataModule3.FDTableViewAfterInsert(DataSet: TDataSet);
121 begin
122 FDTableView.FieldByName('AGREE').AsBoolean := true;
123 FDTableView.FieldByName('ACTIVATE').AsBoolean := true;
124 end;
125
126 end.

Back to OSDN">Back to OSDN
ViewVC Help
Powered by ViewVC 1.1.26