咏南中间件(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. |
本文来自博客园,作者:{咏南中间件},转载请注明原文链接:https://www.cnblogs.com/hnxxcxg/p/14167044.html
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 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 冬至