test1_form.pas

Delphi三层原代码掩饰及补丁

unit test1_form;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, hmClientDataSet, DB, DBClient, MConnect, SConnect, StdCtrls,
  Grids, DBGrids, ComCtrls;

type
  TForm1 = class(TForm)
    sckConn: TSocketConnection;
    cdsDemo1: THMClientDataSet;
    dsDemo1: TDataSource;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    btnClose: TButton;
    Button3: TButton;
    Button1: TButton;
    Label1: TLabel;
    Edit1: TEdit;
    Button2: TButton;
    Button4: TButton;
    cdsDemo2: THMClientDataSet;
    dsDemo2: TDataSource;
    btnConnect: TButton;
    Button5: TButton;
    Button6: TButton;
    Button7: TButton;
    cdsDemo3: THMClientDataSet;
    dsDemo3: TDataSource;
    Cmd: THMClientCommand;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    DBGrid3: TDBGrid;
    procedure Button3Click(Sender: TObject);
    procedure btnCloseClick(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure btnConnectClick(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses swModuleIndex;

{$R *.dfm}

procedure TForm1.btnCloseClick(Sender: TObject);
begin
  Close;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  cdsDemo1.OpenStoreProc(100001);
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  cdsDemo1.BeginOle;
  cdsDemo1.Ole.StoreProcIndex := 100001;
  cdsDemo1.Ole.Action := acOpenStoreProc;
  cdsDemo1.OpenData(dmDefault);
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  cdsDemo2.BeginOle;
  cdsDemo2.Ole['@mm_State'] := edit1.Text;
  cdsDemo2.OpenStoreProc(100002);
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
  cdsDemo2.BeginOle;
  cdsDemo2.Ole.Action := acOpenStoreProc;
  cdsDemo2.Ole.StoreProcIndex := 100002;
  cdsDemo2.Ole['@mm_State'] := edit1.Text;
  cdsDemo2.OpenData(dmDefault);
end;

procedure TForm1.btnConnectClick(Sender: TObject);
begin
  sckConn.Connected := True;
  if sckConn.Connected then
    ShowMessage('Connect Server Success')
  else
    ShowMessage('Connect Server Faild');
end;

procedure TForm1.Button7Click(Sender: TObject);
begin
  cdsDemo3.OpenStoreProc(100005);
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
  if cdsDemo3.Modified then cdsDemo3.Post;
  if cdsDemo3.ChangeCount > 0 then
    begin
      Cmd.BeginOle;
      Cmd.Ole['Delta'] := cdsDemo3.Delta;
      Cmd.Ole['KeyField'] := 'title_id';
      Cmd.Ole['TableName'] := 'titles';
      if Cmd.ApplyUpdates then
        begin
          cdsDemo3.MergeChangeLog;
          ShowMessage('Update Success');
        end;
    end;
end;

procedure TForm1.Button6Click(Sender: TObject);
begin
  Cmd.BeginOle;
  Cmd.Ole.Action:=1;
  Cmd.Execute(dmFirstDemo);
  ShowMessage(Cmd.LastMsg);
end;

end.