ADO序列

ADO序列

此单元，DELPHI7不适用。

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
unit ncSerializeADO;
 
interface
 
uses SysUtils, Classes, Variants, DB, ADODB, ADOInt, ComObj, ActiveX, OleCtrls;
 
// SysUtils: Need TBytes
// Classes: Need TBytesStream
// ADODB: Need TPersistFormat
// ADOInt: Need function PersistFormatEnum
// ActiveX: Need IStream
 
function RecordsetToStream(const aRecordset: _Recordset; aFormat: TPersistFormat): TBytesStream;
function RecordsetToBytes(const aRecordset: _Recordset; aFormat: TPersistFormat = pfADTG): TBytes;
 
function StreamToRecordset(const aStream: TBytesStream; aConnection: TADOConnection = nil): _Recordset;
function BytesToRecordset(const aBytes: TBytes; aConnection: TADOConnection = nil): _Recordset;
 
function VariantToBytes(aVar: Variant): TBytes;
function BytesToVariant(aBytes: TBytes): Variant;
 
function ParametersToBytes(aParameters: TParameters): TBytes;
procedure BytesToParameters(aBytes: TBytes; aParameters: TParameters);
 
implementation
 
uses ncSources;
 
function VariantToBytes(aVar: Variant): TBytes;
var
  VariantType: TVarType;
  BufLen: Integer;
begin
  VariantType := FindVarData(aVar)^.VType;
  SetLength(Result, SizeOf(VariantType));
  move(VariantType, Result[0], SizeOf(VariantType));
  BufLen := Length(Result);
  if not(VariantType in [varEmpty, varNull]) then
  begin
    case VariantType of
      varByte, varSmallint, varShortInt, varInteger, varWord, varLongWord:
        WriteInteger(aVar, Result, BufLen);
      varSingle, varDouble:
        WriteDouble(aVar, Result, BufLen);
      varCurrency:
        WriteCurrency(aVar, Result, BufLen);
      varDate:
        WriteDate(aVar, Result, BufLen);
      varBoolean:
        WriteBool(aVar, Result, BufLen);
      varInt64, varUInt64:
        WriteInt64(aVar, Result, BufLen);
      varOleStr, varStrArg, varString, varUString:
        WriteString(aVar, Result, BufLen);
    else
      raise Exception.Create('Cannot pack specified parameter');
    end;
  end;
 
end;
 
function BytesToVariant(aBytes: TBytes): Variant;
var
  VariantType: TVarType;
  Ofs: Integer;
begin
  move(aBytes[0], VariantType, SizeOf(VariantType));
  Ofs := SizeOf(VariantType);
 
  if not(VariantType in [varEmpty, varNull]) then
  begin
    case VariantType of
      varEmpty:
        Result := Variants.Unassigned;
      varNull:
        Result := Variants.Null;
      varByte, varSmallint, varShortInt, varInteger, varWord, varLongWord:
        Result := ReadInteger(aBytes, Ofs);
      varSingle, varDouble:
        Result := ReadDouble(aBytes, Ofs);
      varCurrency:
        Result := ReadCurrency(aBytes, Ofs);
      varDate:
        Result := ReadDate(aBytes, Ofs);
      varBoolean:
        Result := ReadBool(aBytes, Ofs);
      varInt64, varUInt64:
        Result := ReadInt64(aBytes, Ofs);
      varOleStr, varStrArg, varString, varUString:
        Result := ReadString(aBytes, Ofs);
    else
      raise Exception.Create('Cannot pack specified parameter');
    end;
  end;
 
end;
 
function ParametersToBytes(aParameters: TParameters): TBytes;
var
  BufLen: Integer;
  i: Integer;
begin
  BufLen := 0;
  WriteInteger(aParameters.Count, Result, BufLen);
  for i := 0 to aParameters.Count - 1 do
    WriteBytes(VariantToBytes(aParameters.Items[i].Value), Result, BufLen);
end;
 
procedure BytesToParameters(aBytes: TBytes; aParameters: TParameters);
var
  ParameterCount: Integer;
  Ofs: Integer;
  i: Integer;
begin
  if Length(aBytes) > 0 then
  begin
    Ofs := 0;
    if not Assigned(aParameters) then
      raise Exception.Create('Parameters object not assigned');
    ParameterCount := ReadInteger(aBytes, Ofs);
    if ParameterCount <> aParameters.Count then
      raise Exception.Create('Bytes stream parameters differ from SQL Parameters');
 
    for i := 0 to ParameterCount - 1 do
      aParameters.Items[i].Value := BytesToVariant(ReadBytes(aBytes, Ofs));
  end;
end;
 
function RecordsetToStream(const aRecordset: _Recordset; aFormat: TPersistFormat): TBytesStream;
var
  ADOStream: IStream;
begin
  // Create a stream to hold the data
  Result := TBytesStream.Create;
  try
    // Since ADO can't write directly to a Delphi stream, we must wrap the Delphi stream
    ADOStream := TStreamAdapter.Create(Result, soReference) as IStream;
    try
      // Save the content of the recordset to the stream
      aRecordset.Save(ADOStream, PersistFormatEnum(aFormat));
    finally
      ADOStream := nil;
    end;
 
    // The Stream now contains the data
    // Position the stream at the start
    Result.Position := 0;
  except
    Result.Free;
    raise ;
  end;
end;
 
function RecordsetToBytes(const aRecordset: _Recordset; aFormat: TPersistFormat = pfADTG): TBytes;
var
  tmpSS: TBytesStream;
begin
  tmpSS := RecordsetToStream(aRecordset, aFormat);
  try
    Result := tmpSS.Bytes;
  finally
    tmpSS.Free;
  end;
end;
 
 
function StreamToRecordset(const aStream: TBytesStream; aConnection: TADOConnection = nil): _Recordset;
var
  ADOStream: IStream;
begin
  Result := CoRecordset.Create;
  try
    // Since ADO can't write directly to a Delphi stream, we must wrap the Delphi stream
    ADOStream := TStreamAdapter.Create(aStream, soReference) as IStream;
    try
      // Save the content of the stream to the recordset
      Result.Open(ADOStream, EmptyParam, adOpenKeyset, adLockBatchOptimistic, adCmdFile);
 
      // You need to Set_ActiveConnection in order to be able to update a recordset.
      if Assigned(aConnection) then
          Result.Set_ActiveConnection(aConnection.ConnectionObject);
    finally
      ADOStream := nil;
    end;
  except
    Result := nil;
    raise ;
  end;
end;
 
function BytesToRecordset(const aBytes: TBytes; aConnection: TADOConnection = nil): _Recordset;
var
  Stream: TBytesStream;
begin
  Stream := TBytesStream.Create(aBytes);
  try
    Stream.Position := 0;
    Result := StreamToRecordset(Stream, aConnection);
  finally
    Stream.Free;
  end;
end;
 
 
end.

　　

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
function TReadyQueryItem.Update(aUpdates: _recordset): TBytes;
var
  tmpDS: TADODataSet;
begin
  FSerialiser.Acquire;
  try
    tmpDS := TADODataSet.Create(nil);
    try
      tmpDS.Recordset := aUpdates;
      tmpDS.Recordset.Set_ActiveConnection(ADOQuery.Connection.ConnectionObject);
      tmpDS.Recordset.UpdateBatch(adAffectAll);
      // tmpDS.Recordset.Filter := adFilterAffectedRecords;
      Result := RecordsetToBytes(tmpDS.Recordset, pfADTG);
    finally
      tmpDS.Free;
    end;
  finally
    FSerialiser.Release;
  end;
end;
 
procedure TReadyQueryItem.GetTablesForSQL;
var
  i: Integer;
begin
  Tables.Clear;
  // Get for every field the table it comes from
  for i := 0 to ADOQuery.Recordset.Fields.Count - 1 do
    if VarIsStr (ADOQuery.Recordset.Fields.Item[i].Properties.Item['BASETABLENAME'].Value) then
      Tables.Add(ADOQuery.Recordset.Fields.Item[i].Properties.Item['BASETABLENAME'].Value);
end;

　　

posted @   delphi中间件  阅读(458)  评论(0)  编辑  收藏  举报
编辑推荐：
· .NET Core 中如何实现缓存的预热？
· 从 HTTP 原因短语缺失研究 HTTP/2 和 HTTP/3 的设计差异
· AI与.NET技术实操系列：向量存储与相似性搜索在 .NET 中的实现
· 基于Microsoft.Extensions.AI核心库实现RAG应用
· Linux系列：如何用heaptrack跟踪.NET程序的非托管内存泄露
阅读排行：
· TypeScript + Deepseek 打造卜卦网站：技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 三行代码完成国际化适配，妙~啊~
· .NET Core 中如何实现缓存的预热？
点击右上角即可分享
微信分享提示
SQL AI 助手