ご注文内容発送フォームがしっくりいくようになりました。
@@ -482,6 +482,7 @@ | ||
482 | 482 | begin |
483 | 483 | UserSession.FThumbnail := Value; |
484 | 484 | IWGrid1.Visible := Value; |
485 | + IWFrame8.IWEdit1.Text := '1'; | |
485 | 486 | IWFrame8.Visible := not Value; |
486 | 487 | end; |
487 | 488 |
@@ -0,0 +1,85 @@ | ||
1 | +unit Unit13; | |
2 | + | |
3 | +interface | |
4 | + | |
5 | +uses | |
6 | + Classes, SysUtils, IWAppForm, IWApplication, IWColor, IWTypes, Vcl.Controls, | |
7 | + IWVCLBaseControl, IWBaseControl, IWBaseHTMLControl, IWControl, IWCompButton, | |
8 | + IWCompExtCtrls; | |
9 | + | |
10 | +type | |
11 | + TIWForm13 = class(TIWAppForm) | |
12 | + IWButton1: TIWButton; | |
13 | + IWRadioGroup1: TIWRadioGroup; | |
14 | + procedure IWButton1Click(Sender: TObject); | |
15 | + procedure IWRadioGroup1Click(Sender: TObject); | |
16 | + procedure IWAppFormCreate(Sender: TObject); | |
17 | + public | |
18 | + end; | |
19 | + | |
20 | +implementation | |
21 | + | |
22 | +{$R *.dfm} | |
23 | + | |
24 | +uses Unit3; | |
25 | + | |
26 | +procedure TIWForm13.IWAppFormCreate(Sender: TObject); | |
27 | +begin | |
28 | + IWRadioGroup1Click(Sender); | |
29 | +end; | |
30 | + | |
31 | +procedure TIWForm13.IWButton1Click(Sender: TObject); | |
32 | +var | |
33 | + s: TList; | |
34 | + p: PInteger; | |
35 | + i, j: Integer; | |
36 | +begin | |
37 | + s := TList.Create; | |
38 | + try | |
39 | + DM.FDTable2.First; | |
40 | + while (DM.FDTable2.Eof = false) and (i < 100) do | |
41 | + begin | |
42 | + if DM.FDTable2.FieldByName('SERIAL').AsInteger <> i then | |
43 | + begin | |
44 | + New(p); | |
45 | + s.Add(p); | |
46 | + p^ := i; | |
47 | + end; | |
48 | + inc(i); | |
49 | + DM.FDTable2.Next; | |
50 | + end; | |
51 | + DM.FDTable2.Last; | |
52 | + DM.FDQuery1.SQL.Clear; | |
53 | + DM.FDQuery1.SQL.Add('select serial from cart_data where serial = :num'); | |
54 | + while (DM.FDTable2.Bof = false) and (s.Count > 0) do | |
55 | + begin | |
56 | + p := s[0]; | |
57 | + j := DM.FDTable2.FieldByName('SERIAL').AsInteger; | |
58 | + with DM.FDQuery1 do | |
59 | + begin | |
60 | + ParamByName('num').AsInteger := j; | |
61 | + Open; | |
62 | + First; | |
63 | + while Eof = false do | |
64 | + begin | |
65 | + Fields[0].AsInteger := p^; | |
66 | + Next; | |
67 | + end; | |
68 | + Close; | |
69 | + end; | |
70 | + DM.FDTable2.FieldByName('SERIAL').AsInteger := p^; | |
71 | + DM.FDTable1.Prior; | |
72 | + System.Dispose(p); | |
73 | + s.Delete(0); | |
74 | + end; | |
75 | + finally | |
76 | + s.Free; | |
77 | + end; | |
78 | +end; | |
79 | + | |
80 | +procedure TIWForm13.IWRadioGroup1Click(Sender: TObject); | |
81 | +begin | |
82 | + IWButton1.Enabled := IWRadioGroup1.ItemIndex = 1; | |
83 | +end; | |
84 | + | |
85 | +end. |
@@ -48,7 +48,6 @@ | ||
48 | 48 | FDTable5: TFDTable; |
49 | 49 | item_info: TDataSource; |
50 | 50 | FDTable5VOLUME: TIntegerField; |
51 | - FDTable5SERIAL: TIntegerField; | |
52 | 51 | FDTable5NAME: TWideStringField; |
53 | 52 | FDTable5MAKER: TWideStringField; |
54 | 53 | FDTable5PRICE: TIntegerField; |
@@ -91,6 +90,7 @@ | ||
91 | 90 | FDTableViewMASTER: TIntegerField; |
92 | 91 | FDTableViewSERIAL: TIntegerField; |
93 | 92 | view: TDataSource; |
93 | + FDTable5SERIAL: TIntegerField; | |
94 | 94 | private |
95 | 95 | { Private 宣言 } |
96 | 96 | public |
@@ -8,7 +8,7 @@ | ||
8 | 8 | IWTemplateProcessorHTML, Vcl.Controls, IWVCLBaseControl, IWBaseControl, |
9 | 9 | IWBaseHTMLControl, IWControl, IWCompGrids, IWCompButton, Variants, |
10 | 10 | IWCompLabel, |
11 | - IWDBStdCtrls, PngImage, IWCompExtCtrls, Data.DB; | |
11 | + IWDBStdCtrls, IWCompExtCtrls, Data.DB, Jpeg; | |
12 | 12 | |
13 | 13 | type |
14 | 14 | TCartForm = class(TIWAppForm) |
@@ -48,7 +48,7 @@ | ||
48 | 48 | i, j, k: Integer; |
49 | 49 | s: TStream; |
50 | 50 | pic: TIWImage; |
51 | - png: TPngImage; | |
51 | + jpg: TJpegImage; | |
52 | 52 | begin |
53 | 53 | for i := 0 to IWGrid1.RowCount - 1 do |
54 | 54 | IWGrid1.Cell[i, 0].Control.Free; |
@@ -62,7 +62,7 @@ | ||
62 | 62 | First; |
63 | 63 | i := 0; |
64 | 64 | k := 0; |
65 | - png := TPngImage.Create; | |
65 | + jpg := TJpegImage.Create; | |
66 | 66 | try |
67 | 67 | while Eof = false do |
68 | 68 | begin |
@@ -70,12 +70,12 @@ | ||
70 | 70 | begin |
71 | 71 | s := CreateBlobStream(Fields.Fields[0], bmRead); |
72 | 72 | try |
73 | - png.LoadFromStream(s); | |
73 | + jpg.LoadFromStream(s); | |
74 | 74 | finally |
75 | 75 | s.Free; |
76 | 76 | end; |
77 | 77 | pic := TIWImage.Create(IWGrid1); |
78 | - pic.Picture.Assign(png); | |
78 | + pic.Picture.Assign(jpg); | |
79 | 79 | IWGrid1.Cell[i, 0].Control := pic; |
80 | 80 | end; |
81 | 81 | IWGrid1.Cell[i, 1].Text := Fields.Fields[1].AsString; |
@@ -89,7 +89,7 @@ | ||
89 | 89 | inc(i); |
90 | 90 | end; |
91 | 91 | finally |
92 | - png.Free; | |
92 | + jpg.Free; | |
93 | 93 | end; |
94 | 94 | end; |
95 | 95 | IWLabel1.Text := Format('(合計) %d + (消費税) %d = %d円', |
@@ -11,7 +11,7 @@ | ||
11 | 11 | FireDAC.Stan.Intf, FireDAC.Stan.Option, FireDAC.Stan.Param, |
12 | 12 | FireDAC.Stan.Error, FireDAC.DatS, FireDAC.Phys.Intf, FireDAC.DApt.Intf, |
13 | 13 | FireDAC.Stan.Async, FireDAC.DApt, Data.DB, FireDAC.Comp.DataSet, |
14 | - FireDAC.Comp.Client; | |
14 | + FireDAC.Comp.Client, UITypes; | |
15 | 15 | |
16 | 16 | type |
17 | 17 | TAdminPage = class(TIWAppForm) |
@@ -38,6 +38,12 @@ | ||
38 | 38 | procedure IWDBNavigator1Last(Sender: TObject); |
39 | 39 | procedure IWDBNavigator1Next(Sender: TObject); |
40 | 40 | procedure IWDBNavigator1Prior(Sender: TObject); |
41 | + procedure IWDBGrid2RenderCell(ACell: TIWGridCell; | |
42 | + const ARow, AColumn: Integer); | |
43 | + procedure IWDBGrid2Render(Sender: TObject); | |
44 | + procedure IWCheckBox1Change(Sender: TObject); | |
45 | + private | |
46 | + dummy: TComponent; | |
41 | 47 | public |
42 | 48 | end; |
43 | 49 |
@@ -49,14 +55,18 @@ | ||
49 | 55 | |
50 | 56 | procedure TAdminPage.FDQuery1AfterScroll(DataSet: TDataSet); |
51 | 57 | begin |
52 | - IWDBGrid1.RowCurrentColor := 200; | |
58 | + if DM.FDTable5.MasterSource = DM.order then | |
59 | + IWDBGrid1.RowCurrentColor := TColorRec.Red | |
60 | + else | |
61 | + IWDBGrid1.RowCurrentColor := TColorRec.White; | |
53 | 62 | end; |
54 | 63 | |
55 | 64 | procedure TAdminPage.IWAppFormCreate(Sender: TObject); |
56 | 65 | begin |
66 | + if DM.FDTable5.MasterSource = nil then | |
67 | + DM.FDTable5.MasterSource := DM.order; | |
68 | + DM.FDTable6.First; | |
57 | 69 | FDQuery1.Open; |
58 | - IWDBLabel1.DataField := 'ID'; | |
59 | - IWDBLabel2.DataField := 'ADDRESS'; | |
60 | 70 | end; |
61 | 71 | |
62 | 72 | procedure TAdminPage.IWButton1Click(Sender: TObject); |
@@ -108,9 +118,46 @@ | ||
108 | 118 | FDQuery1AfterScroll(nil); |
109 | 119 | end; |
110 | 120 | |
121 | +procedure TAdminPage.IWCheckBox1Change(Sender: TObject); | |
122 | +begin | |
123 | + with Sender as TIWCheckBox do | |
124 | + begin | |
125 | + Checked := true; | |
126 | + if DM.FDTable5.Locate('KEYFIELD', Tag) = true then | |
127 | + begin | |
128 | + DM.FDTable5.Edit; | |
129 | + DM.FDTable5.FieldByName('CHECKVALUE').AsBoolean := true; | |
130 | + DM.FDTable5.Post; | |
131 | + end; | |
132 | + end; | |
133 | +end; | |
134 | + | |
135 | +procedure TAdminPage.IWDBGrid2Render(Sender: TObject); | |
136 | +begin | |
137 | + dummy.Free; | |
138 | + dummy := TComponent.Create(IWDBGrid2); | |
139 | + DM.FDTable5.First; | |
140 | +end; | |
141 | + | |
142 | +procedure TAdminPage.IWDBGrid2RenderCell(ACell: TIWGridCell; | |
143 | + const ARow, AColumn: Integer); | |
144 | +var | |
145 | + s: TIWCheckBox; | |
146 | +begin | |
147 | + if (ARow > 0) and (AColumn = 4) then | |
148 | + begin | |
149 | + s := TIWCheckBox.Create(dummy); | |
150 | + s.Tag := DM.FDTable5.FieldByName('KEYFIELD').AsInteger; | |
151 | + s.Checked := DM.FDTable5.FieldByName('CHECKVALUE').AsBoolean; | |
152 | + s.OnChange := IWCheckBox1Change; | |
153 | + s.Caption := s.Tag.ToString; | |
154 | + ACell.Control := s; | |
155 | + end; | |
156 | +end; | |
157 | + | |
111 | 158 | procedure TAdminPage.IWDBNavigator1First(Sender: TObject); |
112 | 159 | begin |
113 | - Dm.FDTable6.First; | |
160 | + DM.FDTable6.First; | |
114 | 161 | end; |
115 | 162 | |
116 | 163 | procedure TAdminPage.IWDBNavigator1Last(Sender: TObject); |
@@ -36,7 +36,7 @@ | ||
36 | 36 | |
37 | 37 | procedure TPayForm.IWButton1Click(Sender: TObject); |
38 | 38 | var |
39 | - i, j, k, m: integer; | |
39 | + i, j, k, m, n: integer; | |
40 | 40 | s: string; |
41 | 41 | v: Variant; |
42 | 42 | temp: TFDQuery; |
@@ -90,6 +90,10 @@ | ||
90 | 90 | DM.FDTable6.Last; |
91 | 91 | m := DM.FDTable6.FieldByName('ORDER').AsInteger + 1; |
92 | 92 | j := 0; |
93 | + DM.FDTable5.MasterSource := nil; | |
94 | + DM.FDTable5.Last; | |
95 | + k := DM.FDTable5.FieldByName('KEYFIELD').AsInteger; | |
96 | + DM.FDTable5.MasterSource := DM.order; | |
93 | 97 | DM.FDQuery1.Open('select * from cart_data'); |
94 | 98 | DM.FDQuery1.First; |
95 | 99 | temp := TFDQuery.Create(Self); |
@@ -99,15 +103,12 @@ | ||
99 | 103 | while DM.FDQuery1.Eof = false do |
100 | 104 | begin |
101 | 105 | if DM.FDTable2.Locate('SERIAL', DM.FDQuery1.FieldByName('SERIAL') |
102 | - .AsInteger, []) = true then | |
106 | + .AsInteger) = true then | |
103 | 107 | begin |
104 | - DM.FDTable5.Last; | |
105 | - k := DM.FDTable5.FieldByName('KEYFIELD').AsInteger + 1; | |
108 | + inc(k); | |
106 | 109 | DM.FDTable5.Append; |
107 | 110 | DM.FDTable5.FieldByName('VOLUME').AsInteger := |
108 | 111 | DM.FDQuery1.FieldByName('VOLUME').AsInteger; |
109 | - DM.FDTable5.FieldByName('SERIAL').AsString := | |
110 | - DM.FDTable2.FieldByName('SERIAL').AsString; | |
111 | 112 | DM.FDTable5.FieldByName('NAME').AsString := |
112 | 113 | DM.FDTable2.FieldByName('NAME').AsString; |
113 | 114 | DM.FDTable5.FieldByName('MAKER').AsString := |
@@ -116,9 +117,11 @@ | ||
116 | 117 | DM.FDTable2.FieldByName('PRICE').AsInteger; |
117 | 118 | DM.FDTable5.FieldByName('KEYFIELD').AsInteger := k; |
118 | 119 | DM.FDTable5.FieldByName('ORDER').AsInteger := m; |
120 | + DM.FDTable5.FieldByName('CHECKVALUE').AsBoolean := false; | |
121 | + n := DM.FDTable2.FieldByName('SERIAL').AsInteger; | |
122 | + DM.FDTable5.FieldByName('SERIAL').AsInteger := n; | |
119 | 123 | DM.FDTable5.Post; |
120 | - temp.AppendRecord([i, DM.FDTable2.FieldByName('SERIAL') | |
121 | - .AsInteger, Date]); | |
124 | + temp.AppendRecord([i, n, Date]); | |
122 | 125 | j := j + DM.FDTable2.FieldByName('PRICE').AsInteger * |
123 | 126 | DM.FDQuery1.FieldByName('VOLUME').AsInteger; |
124 | 127 | end; |
@@ -19,7 +19,8 @@ | ||
19 | 19 | Unit8 in 'Unit8.pas' {IWFrame8: TFrame}, |
20 | 20 | Unit9 in 'Unit9.pas' {MyPage: TIWAppForm}, |
21 | 21 | Unit10 in 'Unit10.pas' {IWForm10: TIWAppForm}, |
22 | - Unit11 in 'Unit11.pas' {AdminFile: TIWAppForm}; | |
22 | + Unit11 in 'Unit11.pas' {AdminFile: TIWAppForm}, | |
23 | + Unit13 in 'Unit13.pas' {IWForm13: TIWAppForm}; | |
23 | 24 | |
24 | 25 | {$R *.res} |
25 | 26 |
@@ -142,6 +142,11 @@ | ||
142 | 142 | <FormType>dfm</FormType> |
143 | 143 | <DesignClass>TIWAppForm</DesignClass> |
144 | 144 | </DCCReference> |
145 | + <DCCReference Include="Unit13.pas"> | |
146 | + <Form>IWForm13</Form> | |
147 | + <FormType>dfm</FormType> | |
148 | + <DesignClass>TIWAppForm</DesignClass> | |
149 | + </DCCReference> | |
145 | 150 | <None Include="Win32\Release\templates\cart.htm"/> |
146 | 151 | <None Include="Win32\Release\templates\iteminfo.htm"/> |
147 | 152 | <None Include="Win32\Release\templates\mypage.htm"/> |