咏南中间件(datasnap)新接口演示

咏南中间件(datasnap)新接口演示

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
/// <author>cxg 2020-12-19</author>
/// datasnap http客户端接口调用演示
 
unit Unit2;
 
interface
 
uses
  untGlobal,
  ClientClassesUnit1, MsgPack, Winapi.Windows, Winapi.Messages, System.SysUtils,
  System.Variants, System.Classes, Vcl.Graphics, Vcl.Controls, Vcl.Forms,
  Vcl.Dialogs,  Vcl.ToolWin, Vcl.ComCtrls, Data.DB,
  Datasnap.DBClient, Vcl.Grids, Vcl.DBGrids, Data.DbxDatasnap,
  Data.DBXCommon, Data.DbxHTTPLayer, Datasnap.DSClientRest;
 
type
  TForm2 = class(TForm)
    ToolBar1: TToolBar;
    ToolButton1: TToolButton;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    ClientDataSet1: TClientDataSet;
    DataSource1: TDataSource;
    ClientDataSet2: TClientDataSet;
    DataSource2: TDataSource;
    DSRestConnection1: TDSRestConnection;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    procedure ToolButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure ToolButton2Click(Sender: TObject);
    procedure ToolButton3Click(Sender: TObject);
    procedure ToolButton4Click(Sender: TObject);
    procedure ToolButton5Click(Sender: TObject);
    procedure ToolButton6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;
 
var
  Form2: TForm2;
 
implementation
 
{$R *.dfm}
 
procedure TForm2.FormCreate(Sender: TObject);
begin
  DSRestConnection1.Host := '127.0.0.1';   //中间件ip and port
  DSRestConnection1.Port := 9000;
  DSRestConnection1.Context := 'yn/';
end;
 
procedure TForm2.ToolButton1Click(Sender: TObject);
//查询
var
  m: Tmethod1Client;
  send, recv: TMsgPack;
begin
  send := TMsgPack.Create;
  m := Tmethod1Client.Create(DSRestConnection1);
  send.Force('cmd').AsString := 'query';   //命令字
  send.Force('accountno').AsString := '1'//数据库帐套号
  send.Force('tablenum').AsInteger := 2;    //查询几个表?
  send.Force('sql1').AsString := 'select top 100 * from tunit';
  send.Force('sql2').AsString := 'select * from tgoods';
  recv := m.remoteMethod(send);
  if recv.Force('result').AsBoolean then
  begin
    ClientDataSet1.Data := DeCompressData(recv.Force('dataset1').AsVariant);  //unzip
    ClientDataSet2.Data := DeCompressData(recv.Force('dataset2').AsVariant);  //unzip
  end;
  m.Free;
end;
 
procedure TForm2.ToolButton2Click(Sender: TObject);
//保存
var
  m: Tmethod1Client;
  send, recv: TMsgPack;
begin
  if ClientDataSet1.State in dsEditModes then
    ClientDataSet1.Post;
  if ClientDataSet2.State in dsEditModes then
    ClientDataSet2.Post;
  if ClientDataSet1.ChangeCount = 0 then
    Exit;
  if ClientDataSet2.ChangeCount = 0 then
    Exit;
  send := TMsgPack.Create;
  m := Tmethod1Client.Create(DSRestConnection1);
  send.Force('cmd').AsString := 'save'; //命令字
  send.Force('accountno').AsString := '1'; //数据库帐套号
  send.Force('tablenum').AsInteger := 2;
  send.Force('tablename1').AsString := 'tunit';
  send.Force('tablename2').AsString := 'tgoods';
  send.Force('delta1').AsVariant := ClientDataSet1.Delta;
  send.Force('delta2').AsVariant := ClientDataSet2.Delta;
  recv := m.remoteMethod(send);
  if recv.Force('result').AsBoolean then
  begin
    ClientDataSet1.MergeChangeLog;
    ClientDataSet2.MergeChangeLog;
  end
  else
  begin
    ClientDataSet1.Cancel;
    ClientDataSet2.Cancel;
  end;
  m.Free;
end;
 
procedure TForm2.ToolButton3Click(Sender: TObject);
//存储过程
var
  m: Tmethod1Client;
  send, recv: TMsgPack;
begin
  send := TMsgPack.Create;
  m := Tmethod1Client.Create(DSRestConnection1);
  send.Force('cmd').AsString := 'spopen';//命令字
  send.Force('accountno').AsString := '1';//数据库帐套号
  send.Force('spname').AsString := '存储过程名';
  send.Force('params').AsString := '@参数1=1;@参数2=2';
  recv := m.remoteMethod(send);
  if recv.Force('result').AsBoolean then
  begin
    ClientDataSet1.Data := DeCompressData(recv.Force('dataset1').AsVariant);  //unzip
  end;
  m.Free;
end;
 
procedure TForm2.ToolButton4Click(Sender: TObject);
//execsql
var
  m: Tmethod1Client;
  send, recv: TMsgPack;
begin
  send := TMsgPack.Create;
  m := Tmethod1Client.Create(DSRestConnection1);
  send.Force('cmd').AsString := 'execsql';//命令字
  send.Force('accountno').AsString := '1';//数据库帐套号
  send.Force('sql').AsString := 'insert into tunit(unitid,unitname) values (''1'', ''2'')';
  recv := m.remoteMethod(send);
  if recv.Force('result').AsBoolean then
  begin
    ShowMessage('execsql ok');
  end;
  m.Free;
end;
 
procedure TForm2.ToolButton5Click(Sender: TObject);
//downfile
var
  m: Tmethod1Client;
  send, recv: TMsgPack;
begin
  send := TMsgPack.Create;
  m := Tmethod1Client.Create(DSRestConnection1);
  send.Force('cmd').AsString := 'downfile';//命令字
  send.Force('filenum').AsInteger := 2;//下载几个文件?
  send.Force('filename1').AsString := 'filename1';
  send.Force('filename2').AsString := 'filename2';
  recv := m.remoteMethod(send);
  if recv.Force('result').AsBoolean then
  begin
    recv.Force('file1').SaveBinaryToFile('filename1');
    recv.Force('file2').SaveBinaryToFile('filename2');
  end else ShowMessage('downfile fail');
  m.Free;
end;
 
procedure TForm2.ToolButton6Click(Sender: TObject);
//upfile
var
  m: Tmethod1Client;
  send, recv: TMsgPack;
begin
  send := TMsgPack.Create;
  m := Tmethod1Client.Create(DSRestConnection1);
  send.Force('cmd').AsString := 'upfile';//命令字
  send.Force('filenum').AsInteger := 2;//上传几个文件?
  send.Force('filename1').AsString := 'filename1';
  send.Force('filename2').AsString := 'filename2';
  send.Force('file1').LoadBinaryFromFile('filename1');
  send.Force('file2').LoadBinaryFromFile('filename2');
  recv := m.remoteMethod(send);
  if recv.Force('result').AsBoolean then
  begin
    ShowMessage('upfile ok');
  end else ShowMessage('upfile fail');
  m.Free;
end;
 
end.

  

posted @   delphi中间件  阅读(886)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· 单线程的Redis速度为什么快?
历史上的今天:
2018-12-21 mormot支持https
2015-12-21 DELPHI7加载UNICODE编码格式的TXT显示为乱码的解决方法
2013-12-21 冬至
点击右上角即可分享
微信分享提示