| 36 |
|
|
| 37 |
procedure TPayForm.IWButton1Click(Sender: TObject); |
procedure TPayForm.IWButton1Click(Sender: TObject); |
| 38 |
var |
var |
| 39 |
i, j, k, m: integer; |
i, j, k, m, n: integer; |
| 40 |
s: string; |
s: string; |
| 41 |
v: Variant; |
v: Variant; |
| 42 |
temp: TFDQuery; |
temp: TFDQuery; |
| 90 |
DM.FDTable6.Last; |
DM.FDTable6.Last; |
| 91 |
m := DM.FDTable6.FieldByName('ORDER').AsInteger + 1; |
m := DM.FDTable6.FieldByName('ORDER').AsInteger + 1; |
| 92 |
j := 0; |
j := 0; |
| 93 |
|
DM.FDTable5.MasterSource := nil; |
| 94 |
|
DM.FDTable5.Last; |
| 95 |
|
k := DM.FDTable5.FieldByName('KEYFIELD').AsInteger; |
| 96 |
|
DM.FDTable5.MasterSource := DM.order; |
| 97 |
DM.FDQuery1.Open('select * from cart_data'); |
DM.FDQuery1.Open('select * from cart_data'); |
| 98 |
DM.FDQuery1.First; |
DM.FDQuery1.First; |
| 99 |
temp := TFDQuery.Create(Self); |
temp := TFDQuery.Create(Self); |
| 103 |
while DM.FDQuery1.Eof = false do |
while DM.FDQuery1.Eof = false do |
| 104 |
begin |
begin |
| 105 |
if DM.FDTable2.Locate('SERIAL', DM.FDQuery1.FieldByName('SERIAL') |
if DM.FDTable2.Locate('SERIAL', DM.FDQuery1.FieldByName('SERIAL') |
| 106 |
.AsInteger, []) = true then |
.AsInteger) = true then |
| 107 |
begin |
begin |
| 108 |
DM.FDTable5.Last; |
inc(k); |
|
k := DM.FDTable5.FieldByName('KEYFIELD').AsInteger + 1; |
|
| 109 |
DM.FDTable5.Append; |
DM.FDTable5.Append; |
| 110 |
DM.FDTable5.FieldByName('VOLUME').AsInteger := |
DM.FDTable5.FieldByName('VOLUME').AsInteger := |
| 111 |
DM.FDQuery1.FieldByName('VOLUME').AsInteger; |
DM.FDQuery1.FieldByName('VOLUME').AsInteger; |
|
DM.FDTable5.FieldByName('SERIAL').AsString := |
|
|
DM.FDTable2.FieldByName('SERIAL').AsString; |
|
| 112 |
DM.FDTable5.FieldByName('NAME').AsString := |
DM.FDTable5.FieldByName('NAME').AsString := |
| 113 |
DM.FDTable2.FieldByName('NAME').AsString; |
DM.FDTable2.FieldByName('NAME').AsString; |
| 114 |
DM.FDTable5.FieldByName('MAKER').AsString := |
DM.FDTable5.FieldByName('MAKER').AsString := |
| 117 |
DM.FDTable2.FieldByName('PRICE').AsInteger; |
DM.FDTable2.FieldByName('PRICE').AsInteger; |
| 118 |
DM.FDTable5.FieldByName('KEYFIELD').AsInteger := k; |
DM.FDTable5.FieldByName('KEYFIELD').AsInteger := k; |
| 119 |
DM.FDTable5.FieldByName('ORDER').AsInteger := m; |
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; |
| 123 |
DM.FDTable5.Post; |
DM.FDTable5.Post; |
| 124 |
temp.AppendRecord([i, DM.FDTable2.FieldByName('SERIAL') |
temp.AppendRecord([i, n, Date]); |
|
.AsInteger, Date]); |
|
| 125 |
j := j + DM.FDTable2.FieldByName('PRICE').AsInteger * |
j := j + DM.FDTable2.FieldByName('PRICE').AsInteger * |
| 126 |
DM.FDQuery1.FieldByName('VOLUME').AsInteger; |
DM.FDQuery1.FieldByName('VOLUME').AsInteger; |
| 127 |
end; |
end; |