Develop and Download Open Source Software

Browse Subversion Repository

Annotation of /Unit9.pas

Parent Directory Parent Directory | Revision Log Revision Log


Revision 12 - (hide annotations) (download) (as text)
Sun Jul 24 06:09:44 2016 UTC (7 years, 7 months ago) by yamat0jp
File MIME type: text/x-pascal
File size: 3793 byte(s)
エラーは出てしまいますがORDER_DATAを第3正規化できたのでチェック前にコミット
1 yamat0jp 7 unit Unit9;
2    
3     interface
4    
5     uses
6     Classes, SysUtils, IWAppForm, IWApplication, IWColor, IWTypes, IWCompButton,
7     Vcl.Controls, IWVCLBaseControl, IWBaseControl, IWBaseHTMLControl, IWControl,
8     IWHTMLControls, IWVCLComponent, IWBaseLayoutComponent, IWBaseContainerLayout,
9 yamat0jp 8 IWContainerLayout, IWTemplateProcessorHTML, IWCompEdit;
10 yamat0jp 7
11     type
12     TMyPage = class(TIWAppForm)
13     IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;
14     IWLink2: TIWLink;
15     IWButton1: TIWButton;
16     IWButton2: TIWButton;
17 yamat0jp 8 IWEdit1: TIWEdit;
18     IWEdit2: TIWEdit;
19     IWButton3: TIWButton;
20     IWEdit3: TIWEdit;
21     IWEdit4: TIWEdit;
22     IWButton4: TIWButton;
23     IWEdit5: TIWEdit;
24 yamat0jp 7 procedure IWButton2Click(Sender: TObject);
25     procedure IWButton1Click(Sender: TObject);
26     procedure IWLink2Click(Sender: TObject);
27 yamat0jp 8 procedure IWButton3Click(Sender: TObject);
28     procedure IWButton4Click(Sender: TObject);
29     procedure IWAppFormCreate(Sender: TObject);
30 yamat0jp 7 public
31     Form: TIWAppForm;
32 yamat0jp 12 private
33     procedure DeleteUser(EventParams: TStringList);
34 yamat0jp 7 end;
35    
36     implementation
37    
38     {$R *.dfm}
39    
40     uses Unit3, ServerController, Unit1;
41    
42 yamat0jp 12 procedure TMyPage.DeleteUser(EventParams: TStringList);
43     begin
44     if EventParams.Values['RetValue'] = 'true' then
45     begin
46     IWButton1Click(nil);
47     if DM.FDTable1.Locate('NUMBER', UserSession.user_number, []) = true then
48     DM.FDTable1.Delete;
49     with DM.FDQuery1 do
50     begin
51     Open('select serial from cart_data where number = :num;',
52     [UserSession.user_number]);
53     First;
54     while Eof = false do
55     Delete;
56     end;
57     (Form as TIWForm1).Page := true;
58     UserSession.user_number := 0;
59     WebApplication.Response.Cookies.AddCookie('user_cookie', '0', '/',
60     Date - 1);
61     Release;
62     WebApplication.ShowMessage('������������');
63     end;
64     end;
65    
66 yamat0jp 8 procedure TMyPage.IWAppFormCreate(Sender: TObject);
67     begin
68 yamat0jp 12 WebApplication.RegisterCallBack('callback', DeleteUser);
69 yamat0jp 8 with DM.FDTable1 do
70     begin
71     IWEdit1.Text := FieldByName('EMAIL').AsString;
72     IWEdit2.Text := FieldByName('ADDRESS').AsString;
73 yamat0jp 12 IWEdit4.Text := FieldByName('PASSWORD').AsString;
74 yamat0jp 8 end;
75     end;
76    
77 yamat0jp 7 procedure TMyPage.IWButton1Click(Sender: TObject);
78     begin
79     with DM.FDQuery1 do
80     begin
81 yamat0jp 12 Open('select * from recent_data where number = :num;',
82 yamat0jp 7 [UserSession.user_number]);
83 yamat0jp 12 First;
84 yamat0jp 7 while Eof = false do
85     Delete;
86     end;
87     end;
88    
89 yamat0jp 12 procedure TMyPage.IWButton2Click(Sender: TObject);
90     begin
91     WebApplication.ShowConfirm('OK��������������������������', 'callback', '�m�F',
92     'OK', '������');
93     end;
94    
95 yamat0jp 8 procedure TMyPage.IWButton3Click(Sender: TObject);
96     begin
97     with DM.FDTable1 do
98     if IWEdit1.Text <> FieldByName('EMAIL').AsString then
99     begin
100     if IWEdit1.Text = IWEdit3.Text then
101     begin
102     Edit;
103     FieldByName('EMAIL').AsString := IWEdit1.Text;
104     FieldByName('ADDRESS').AsString := IWEdit2.Text;
105     Post;
106     end
107     else
108     begin
109     WebApplication.ShowMessage('���������v��������');
110     IWEdit1.Text := FieldByName('EMAIL').AsString;
111     IWEdit3.Text := '';
112     end;
113     end
114     else
115     begin
116     Edit;
117     FieldByName('ADDRESS').AsString := IWEdit2.Text;
118     Post;
119     end;
120     end;
121    
122     procedure TMyPage.IWButton4Click(Sender: TObject);
123     begin
124     if IWEdit4.Text <> IWEdit5.Text then
125     begin
126     WebApplication.ShowMessage('���������v��������');
127     Exit;
128     end
129     else if Length(IWEdit4.Text) < 5 then
130     WebApplication.ShowMessage('�p�X���[�h���T�����������K�v����')
131     else
132     with DM.FDTable1 do
133     begin
134     Edit;
135     FieldByName('PASSWORD').AsString := IWEdit4.Text;
136     Post;
137     end;
138     end;
139    
140 yamat0jp 7 procedure TMyPage.IWLink2Click(Sender: TObject);
141     begin
142     Release;
143     end;
144    
145     end.

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