sdoslp.pas

阀门厂的合同管理含销售 等

unit SDOSLP;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids, DB;

type
  TFormSDOSLP = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Button1: TButton;
    Button2: TButton;
    procedure DataSource1DataChange(Sender: TObject; Field: TField);
    procedure Button1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FormSDOSLP: TFormSDOSLP;

implementation

uses DataHJ;
{$R *.dfm}

procedure TFormSDOSLP.DataSource1DataChange(Sender: TObject; Field: TField);
begin
    if DataSource1.State=dsInsert then
       Button1.Caption:='添加';
    if DataSource1.State=dsEdit then
       Button1.Caption:='更新';
    if DataSource1.State=dsBrowse then
       Button1.Caption:='确定';
end;

procedure TFormSDOSLP.Button1Click(Sender: TObject);
begin
   if  Button1.Caption='确定' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    close;
   end;
   if  Button1.Caption='更新' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    Button1.Caption:='确定';
   end;
   if  Button1.Caption='添加' then
   begin
    DataSource1.DataSet.Edit;
    DataSource1.DataSet.Post;
    Button1.Caption:='确定';
   end;
end;

procedure TFormSDOSLP.FormShow(Sender: TObject);
begin
   try
     DataModHJ.ADOQP0.Close;
     DataModHJ.ADOQP0.SQL.Clear;
     DataModHJ.ADOQP0.SQL.Add('select * from SDOSLP');
     DataModHJ.ADOQP0.Prepared;
     DataModHJ.ADOQP0.Open;
     if DataModHJ.ADOQP0.RecordCount>0 then
        DataModHJ.ADOQP0.Edit;
   except
     exit;
   end;
end;

procedure TFormSDOSLP.Button2Click(Sender: TObject);
begin
   DataModHJ.ADOQP0.Cancel;
   Close;
end;

end.