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 1 by yamat0jp, Sun Nov 22 11:18:44 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;    IWTemplateProcessorHTML, PngImage, Data.DB, IWCompLabel, IWDBStdCtrls,
11      FireDAC.Comp.Client;
12    
13  type  type
14    TCartForm = class(TIWAppForm)    TPayForm = class(TIWAppForm)
     IWDBGrid1: TIWDBGrid;  
15      IWButton1: TIWButton;      IWButton1: TIWButton;
16      IWButton2: TIWButton;      IWButton2: TIWButton;
17      IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;      IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;
18      procedure IWAppFormCreate(Sender: TObject);      IWDBLabel1: TIWDBLabel;
19      procedure IWAppFormDestroy(Sender: TObject);      procedure IWButton2Click(Sender: TObject);
20      procedure IWButton1Click(Sender: TObject);      procedure IWButton1Click(Sender: TObject);
21    public    public
22    end;    end;
# Line 25  implementation Line 25  implementation
25    
26  {$R *.dfm}  {$R *.dfm}
27    
28  uses Unit4, Unit1, Unit8, ServerController;  uses Unit3, Unit1, ServerController;
29    
30  procedure TCartForm.IWAppFormCreate(Sender: TObject);  procedure TPayForm.IWButton1Click(Sender: TObject);
31  var  var
32      s: TFDQuery;
33    i: integer;    i: integer;
   s, t: TIWDBGridColumn;  
   j: integer;  
34  begin  begin
35    with DM.FDQuery1 do    with DM.FDQuery1 do
36    begin    begin
37      SQL.Clear;      Open('select * from cart_data where number = :num;',
38      SQL.Add('select name,maker,image,volume,price');        [DM.FDTable1.FieldByName('NUMBER').AsInteger]);
39      SQL.Add(' from item_data join cart_data');      s := TFDQuery.Create(nil);
40      SQL.Add(' on (item_data.serial = cart_data.serial) where number = :num;');      try
41      Params.ParamByName('num').AsInteger := UserSession.user_number;        s.Connection := DM.FDConnection1;
42      Open;        s.Open('select * from order_data;');
43    end;        while Eof = false do
   for i := 0 to DM.FDQuery1.Fields.Count - 1 do  
   begin  
     s := IWDBGrid1.Columns.Add as TIWDBGridColumn;  
     if i = 2 then  
     begin  
       s.Title.Text := 'IMAGE';  
       for j := 1 to s.Collection.Count - 1 do  
44        begin        begin
45          t := s.Collection.Items[j] as TIWDBGridColumn;          s.Append;
46          t.Control := TIWImageFile.Create(IWDBGrid1);          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;        end;
67      end        s.Post;
68      else        First;
69        s.DataField := DM.FDQuery1.Fields[i].FieldName;        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;    end;
86      WebApplication.ShowMessage('お買い上げありがとうございました');
87      Release;
88      IWForm1.Thumbnail := true;
89  end;  end;
90    
91  procedure TCartForm.IWAppFormDestroy(Sender: TObject);  procedure TPayForm.IWButton2Click(Sender: TObject);
 var  
   i: integer;  
   s: TIWDBGridColumn;  
 begin  
   DM.FDQuery1.Close;  
   s := IWDBGrid1.Columns.Items[2] as TIWDBGridColumn;  
   for i := 0 to s.Collection.Count - 1 do  
     s.Control.Free;  
 end;  
   
 procedure TCartForm.IWButton1Click(Sender: TObject);  
92  begin  begin
93    Release;    Release;
   if Sender = IWButton1 then  
     TPayForm.Create(WebApplication).Show  
   else  
     TTopForm.Create(WebApplication).Show;  
94  end;  end;
95    
96  end.  end.
Legend:
Removed from v.1  
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