TynSerial序列（还原）TFDMemTable

TynSerial序列（还原）TFDMemTable

1）TFDMemTable查询数据

?

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

procedure TForm1.Qrys(accountno, sql, sql2: string; DataSet, DataSet2: TFDMemTable); // TFDMemTable主从表查询 var   url: SockString;   i: integer;   serial: TynSerial; begin   serial := TynSerial.Create;   try     url := 'querys';     serial.WriteString('accountno', accountno);     serial.WriteString('sql', sql);     serial.WriteString('sql2', sql2);     i := FHttp.Post(url, serial.Text, FDataType);     if i = 200 then     begin       serial.Text := FHttp.Content;       serial.ReadFDDataSet('dataset', DataSet);       serial.ReadFDDataSet('dataset2', DataSet2);     end     else       ShowMessage(i.ToString + ' error');   finally     serial.Free;   end; end;

　2）　TFDMemTable提交数据

?

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

function TForm1.Save(accountno, tablename: string; dataset: TFDMemTable): string; // TFDMemTable提交 var   url: SockString;   i: Integer;   serial: TynSerial; begin   serial := TynSerial.Create;   try     url := 'save2';     serial.WriteString('accountno', accountno);     serial.WriteString('tablename', tablename);     serial.WriteFDDelta('delta', dataset);     i := FHttp.Post(url, serial.Text, FDataType);     if i = 200 then     begin       serial.Text := FHttp.Content;       if serial.ReadBool('result') then         dataset.MergeChangeLog       else         ShowMessage('提交失败');     end     else       ShowMessage(i.ToString + ' error');   finally     serial.Free;   end; end;