Diff of /Unit4.pas

OSDN > Find Software > zencart-clone

 Browse Subversion Repository



/[zencart-clone]/Unit4.pas




Diff of /Unit4.pas



 Parent Directory

|  Revision Log



|  Patch














revision 2 by yamat0jp,
Sat Dec 19 14:35:42 2015 UTC




revision 17 by yamat0jp,
Wed Aug 24 12:31:07 2016 UTC






#

Line 3 
 unit Unit4;


Line 3 
 unit Unit4;












3
 interface
 interface

















4
 
 

















5
 uses
 uses















6


   Classes, SysUtils, IWAppForm, IWApplication, IWColor, IWTypes;


   Classes, SysUtils, IWAppForm, IWApplication, IWColor, IWTypes, IWVCLComponent,













7


 


   IWBaseLayoutComponent, IWBaseContainerLayout, IWContainerLayout,













8


 


   IWTemplateProcessorHTML, Vcl.Controls, IWVCLBaseControl, IWBaseControl,













9


 


   IWBaseHTMLControl, IWControl, IWCompGrids, IWCompButton, Variants,













10


 


   IWCompLabel,













11


 


   IWDBStdCtrls, IWCompExtCtrls, Data.DB, Jpeg;















12
 
 

















13
 type
 type















14


   TPayForm = class(TIWAppForm)


   TCartForm = class(TIWAppForm)













15


 


     IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;













16


 


     IWGrid1: TIWGrid;













17


 


     IWButton1: TIWButton;













18


 


     IWButton2: TIWButton;













19


 


     IWLabel1: TIWLabel;













20


 


     procedure IWAppFormRender(Sender: TObject);













21


 


     procedure IWGrid1CellClick(ASender: TObject; const ARow, AColumn: Integer);













22


 


     procedure IWAppFormCreate(Sender: TObject);













23


 


     procedure IWButton2Click(Sender: TObject);













24


 


     procedure IWButton1Click(Sender: TObject);















25
   public
   public

















26
   end;
   end;

















27
 
 











#

Line 14 
 implementation


Line 29 
 implementation












29
 
 

















30
 {$R *.dfm}
 {$R *.dfm}

















31
 
 












32
 
 uses Unit3, Unit7, Unit6, ServerController;







33
 
 







34
 
 procedure TCartForm.IWAppFormCreate(Sender: TObject);







35
 
 begin







36
 
   with DM.FDQuery1 do







37
 
   begin







38
 
     SQL.Clear;







39
 
     SQL.Add('select thumbnail,name,volume,price,number,serial from cart_data,item_data');







40
 
     SQL.Add(' where cart_data.serial = item_data.serial');







41
 
     SQL.Add(' and number = :num');







42
 
     ParamByName('num').AsInteger := UserSession.user_number;







43
 
   end;







44
 
 end;







45
 
 







46
 
 procedure TCartForm.IWAppFormRender(Sender: TObject);







47
 
 var







48
 
   i, j, k: Integer;







49
 
   s: TStream;







50
 
   pic: TIWImage;







51
 
   jpg: TJpegImage;







52
 
 begin







53
 
   for i := 0 to IWGrid1.RowCount - 1 do







54
 
     IWGrid1.Cell[i, 0].Control.Free;







55
 
   IWGrid1.RowCount := 0;







56
 
   with DM.FDQuery1 do







57
 
   begin







58
 
     Open;







59
 
     IWGrid1.RowCount := RecordCount;







60
 
     if IWGrid1.RowCount = 0 then







61
 
       IWGrid1.Caption := 'カートの中身がありません';







62
 
     First;







63
 
     i := 0;







64
 
     k := 0;







65
 
     jpg := TJpegImage.Create;







66
 
     try







67
 
       while Eof = false do







68
 
       begin







69
 
         if Fields.Fields[0].IsNull = false then







70
 
         begin







71
 
           s := CreateBlobStream(Fields.Fields[0], bmRead);







72
 
           try







73
 
             jpg.LoadFromStream(s);







74
 
           finally







75
 
             s.Free;







76
 
           end;







77
 
           pic := TIWImage.Create(IWGrid1);







78
 
           pic.Picture.Assign(jpg);







79
 
           IWGrid1.Cell[i, 0].Control := pic;







80
 
         end;







81
 
         IWGrid1.Cell[i, 1].Text := Fields.Fields[1].AsString;







82
 
         IWGrid1.Cell[i, 2].Text := Fields.Fields[2].AsString;







83
 
         j := Fields.Fields[2].AsInteger * Fields.Fields[3].AsInteger;







84
 
         inc(k, j);







85
 
         IWGrid1.Cell[i, 3].Text := IntToStr(j);







86
 
         IWGrid1.Cell[i, 4].Text := '削除';







87
 
         IWGrid1.Cell[i, 4].Clickable := true;







88
 
         Next;







89
 
         inc(i);







90
 
       end;







91
 
     finally







92
 
       jpg.Free;







93
 
     end;







94
 
   end;







95
 
   IWLabel1.Text := Format('(合計)　%d + (消費税) %d = %d円',







96
 
     [k, Trunc(k * 0.08), Trunc(k * 1.08)]);







97
 
 end;







98
 
 







99
 
 procedure TCartForm.IWButton1Click(Sender: TObject);







100
 
 var







101
 
   s: TUserForm;







102
 
 begin







103
 
   if (UserSession.user_number <> 0) and (IWGrid1.RowCount > 0) then







104
 
     if DM.FDTable1.FieldByName('EMAIL').AsString = '' then







105
 
     begin







106
 
       s := TUserForm.Create(WebApplication);







107
 
       s.pay := IWGrid1.RowCount>0;







108
 
       s.Show;







109
 
     end







110
 
     else







111
 
       TPayForm.Create(WebApplication).Show;







112
 
   Release;







113
 
 end;







114
 
 







115
 
 procedure TCartForm.IWButton2Click(Sender: TObject);







116
 
 begin







117
 
   Release;







118
 
 end;







119
 
 







120
 
 procedure TCartForm.IWGrid1CellClick(ASender: TObject;







121
 
   const ARow, AColumn: Integer);







122
 
 var







123
 
   i, j: Integer;







124
 
 begin







125
 
   with DM.FDQuery1 do







126
 
   begin







127
 
     RecNo := ARow + 1;







128
 
     i := FieldByName('NUMBER').AsInteger;







129
 
     j := FieldByName('SERIAL').AsInteger;







130
 
     Open('select * from cart_data;');







131
 
     if Locate('NUMBER;SERIAL', VarArrayOf([i, j]), []) = true then







132
 
       Delete;







133
 
   end;







134
 
   IWAppFormCreate(ASender);







135
 
 end;












136
 
 

















137
 end.
 end.





























Legend:



Removed from v.2
 


changed lines


 
Added in v.17













Back to OSDN">Back to OSDN
ViewVC Help


Powered by ViewVC 1.1.26
 /[zencart-clone]/Unit4.pas
-revision 2 by yamat0jp,
Sat Dec 19 14:35:42 2015 UTC
+revision 17 by yamat0jp,
Wed Aug 24 12:31:07 2016 UTC
 Line 3 
 unit Unit4;
  interface
  uses
-   Classes, SysUtils, IWAppForm, IWApplication, IWColor, IWTypes;
+   Classes, SysUtils, IWAppForm, IWApplication, IWColor, IWTypes, IWVCLComponent,
+   IWBaseLayoutComponent, IWBaseContainerLayout, IWContainerLayout,
+   IWTemplateProcessorHTML, Vcl.Controls, IWVCLBaseControl, IWBaseControl,
+   IWBaseHTMLControl, IWControl, IWCompGrids, IWCompButton, Variants,
+   IWCompLabel,
+   IWDBStdCtrls, IWCompExtCtrls, Data.DB, Jpeg;
  type
-   TPayForm = class(TIWAppForm)
+   TCartForm = class(TIWAppForm)
+     IWTemplateProcessorHTML1: TIWTemplateProcessorHTML;
+     IWGrid1: TIWGrid;
+     IWButton1: TIWButton;
+     IWButton2: TIWButton;
+     IWLabel1: TIWLabel;
+     procedure IWAppFormRender(Sender: TObject);
+     procedure IWGrid1CellClick(ASender: TObject; const ARow, AColumn: Integer);
+     procedure IWAppFormCreate(Sender: TObject);
+     procedure IWButton2Click(Sender: TObject);
+     procedure IWButton1Click(Sender: TObject);
    public
    end;
-Line 14 
 implementation
+Line 29 
 implementation
  {$R *.dfm}
+ uses Unit3, Unit7, Unit6, ServerController;
+ procedure TCartForm.IWAppFormCreate(Sender: TObject);
+ begin
+   with DM.FDQuery1 do
+   begin
+     SQL.Clear;
+     SQL.Add('select thumbnail,name,volume,price,number,serial from cart_data,item_data');
+     SQL.Add(' where cart_data.serial = item_data.serial');
+     SQL.Add(' and number = :num');
+     ParamByName('num').AsInteger := UserSession.user_number;
+   end;
+ end;
+ procedure TCartForm.IWAppFormRender(Sender: TObject);
+ var
+   i, j, k: Integer;
+   s: TStream;
+   pic: TIWImage;
+   jpg: TJpegImage;
+ begin
+   for i := 0 to IWGrid1.RowCount - 1 do
+     IWGrid1.Cell[i, 0].Control.Free;
+   IWGrid1.RowCount := 0;
+   with DM.FDQuery1 do
+   begin
+     Open;
+     IWGrid1.RowCount := RecordCount;
+     if IWGrid1.RowCount = 0 then
+       IWGrid1.Caption := 'カートの中身がありません';
+     First;
+     i := 0;
+     k := 0;
+     jpg := TJpegImage.Create;
+     try
+       while Eof = false do
+       begin
+         if Fields.Fields[0].IsNull = false then
+         begin
+           s := CreateBlobStream(Fields.Fields[0], bmRead);
+           try
+             jpg.LoadFromStream(s);
+           finally
+             s.Free;
+           end;
+           pic := TIWImage.Create(IWGrid1);
+           pic.Picture.Assign(jpg);
+           IWGrid1.Cell[i, 0].Control := pic;
+         end;
+         IWGrid1.Cell[i, 1].Text := Fields.Fields[1].AsString;
+         IWGrid1.Cell[i, 2].Text := Fields.Fields[2].AsString;
+         j := Fields.Fields[2].AsInteger * Fields.Fields[3].AsInteger;
+         inc(k, j);
+         IWGrid1.Cell[i, 3].Text := IntToStr(j);
+         IWGrid1.Cell[i, 4].Text := '削除';
+         IWGrid1.Cell[i, 4].Clickable := true;
+         Next;
+         inc(i);
+       end;
+     finally
+       jpg.Free;
+     end;
+   end;
+   IWLabel1.Text := Format('(合計)　%d + (消費税) %d = %d円',
+     [k, Trunc(k * 0.08), Trunc(k * 1.08)]);
+ end;
+ procedure TCartForm.IWButton1Click(Sender: TObject);
+ var
+   s: TUserForm;
+ begin
+   if (UserSession.user_number <> 0) and (IWGrid1.RowCount > 0) then
+     if DM.FDTable1.FieldByName('EMAIL').AsString = '' then
+     begin
+       s := TUserForm.Create(WebApplication);
+       s.pay := IWGrid1.RowCount>0;
+       s.Show;
+     end
+     else
+       TPayForm.Create(WebApplication).Show;
+   Release;
+ end;
+ procedure TCartForm.IWButton2Click(Sender: TObject);
+ begin
+   Release;
+ end;
+ procedure TCartForm.IWGrid1CellClick(ASender: TObject;
+   const ARow, AColumn: Integer);
+ var
+   i, j: Integer;
+ begin
+   with DM.FDQuery1 do
+   begin
+     RecNo := ARow + 1;
+     i := FieldByName('NUMBER').AsInteger;
+     j := FieldByName('SERIAL').AsInteger;
+     Open('select * from cart_data;');
+     if Locate('NUMBER;SERIAL', VarArrayOf([i, j]), []) = true then
+       Delete;
+   end;
+   IWAppFormCreate(ASender);
+ end;
  end.
 Legend:



Removed from v.2
 


changed lines


 
Added in v.17
 Legend:



Removed from v.2
 


changed lines


 
Added in v.17
-Removed from v.2
+Added in v.17
-Back to OSDN">Back to OSDN
+ViewVC Help
 Powered by ViewVC 1.1.26

Develop and Download Open Source Software

zencart-clone

Browse Subversion Repository