Develop and Download Open Source Software

zencart-clone

Browse Subversion Repository

/[zencart-clone]/Unit7.pas

Diff of /Unit7.pas

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 6 by yamat0jp, Tue Dec 29 10:58:29 2015 UTC revision 10 by yamat0jp, Sat Jan 16 23:06:35 2016 UTC
# Line 7  uses Line 7  uses
7    IWVCLBaseControl, IWBaseControl, IWBaseHTMLControl, IWControl, IWCompGrids,    IWVCLBaseControl, IWBaseControl, IWBaseHTMLControl, IWControl, IWCompGrids,
8    IWDBGrids, IWCompButton, IWCompExtCtrls, IWVCLComponent,    IWDBGrids, IWCompButton, IWCompExtCtrls, IWVCLComponent,
9    IWBaseLayoutComponent, IWBaseContainerLayout, IWContainerLayout,    IWBaseLayoutComponent, IWBaseContainerLayout, IWContainerLayout,
10    IWTemplateProcessorHTML, PngImage, Data.DB, IWCompLabel, IWDBStdCtrls;    IWTemplateProcessorHTML, PngImage, Data.DB, IWCompLabel, IWDBStdCtrls,
11      FireDAC.Comp.Client;
12    
13  type  type
14    TPayForm = class(TIWAppForm)    TPayForm = class(TIWAppForm)
# Line 16  type Line 17  type
17      IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;      IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;
18      IWDBLabel1: TIWDBLabel;      IWDBLabel1: TIWDBLabel;
19      procedure IWButton2Click(Sender: TObject);      procedure IWButton2Click(Sender: TObject);
20        procedure IWButton1Click(Sender: TObject);
21    public    public
22    end;    end;
23    
# Line 23  implementation Line 25  implementation
25    
26  {$R *.dfm}  {$R *.dfm}
27    
28  uses Unit3, Unit1, ServerController, Unit4;  uses Unit3, Unit1, ServerController;
29    
30    procedure TPayForm.IWButton1Click(Sender: TObject);
31    var
32      s: TFDQuery;
33      i: integer;
34    begin
35      with DM.FDQuery1 do
36      begin
37        Open('select * from cart_data where number = :num;',
38          [DM.FDTable1.FieldByName('NUMBER').AsInteger]);
39        s := TFDQuery.Create(nil);
40        try
41          s.Connection := DM.FDConnection1;
42          s.Open('select * from order_data;');
43          while Eof = false do
44          begin
45            s.Append;
46            s.FieldByName('LASTORDER').AsDateTime := Date;
47            s.FieldByName('VOLUME').AsInteger := DM.FDQuery1.FieldByName('VOLUME')
48              .AsInteger;
49            s.FieldByName('USER').AsString :=
50              DM.FDTable1.FieldByName('NAME').AsString;
51            s.FieldByName('ADDRESS').AsString :=
52              DM.FDTable1.FieldByName('ADDRESS').AsString;
53            s.FieldByName('EMAIL').AsString :=
54              DM.FDTable1.FieldByName('EMAIL').AsString;
55            if DM.FDTable2.Locate('SERIAL', DM.FDQuery1.FieldByName('SERIAL').AsInteger, []) = true
56            then
57            begin
58              s.FieldByName('NAME').AsString :=
59                DM.FDTable2.FieldByName('NAME').AsString;
60              s.FieldByName('MAKER').AsString :=
61                DM.FDTable2.FieldByName('MAKER').AsString;
62              s.FieldByName('PRICE').AsInteger := DM.FDTable2.FieldByName('PRICE')
63                .AsInteger * s.FieldByName('VOLUME').AsInteger;
64            end;
65            Next;
66          end;
67          s.Post;
68          First;
69          s.Open('select * from recent_data;');
70          while s.Eof = false do
71            if Date + 30 < s.FieldByName('DATE').AsDateTime then
72              s.Delete
73            else
74              s.Next;
75          while Eof = false do
76          begin
77            if s.Locate('SERIAL', FieldByName('SERIAL').AsInteger, []) = false then
78              s.AppendRecord([FieldByName('NUMBER').AsInteger,
79                FieldByName('SERIAL').AsInteger, Date]);
80            Delete;
81          end;
82        finally
83          s.Free;
84        end;
85      end;
86      WebApplication.ShowMessage('お買い上げありがとうございました');
87      Release;
88      IWForm1.Thumbnail := true;
89    end;
90    
91  procedure TPayForm.IWButton2Click(Sender: TObject);  procedure TPayForm.IWButton2Click(Sender: TObject);
92  begin  begin
Legend:
Removed from v.6  
changed lines
  Added in v.10
Back to OSDN">Back to OSDN
 ViewVC Help
Powered by ViewVC 1.1.26  
About OSDN
Find Software
Develop Software
Help