unit f_product_master;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, StdCtrls, Mask, DBCtrls, Buttons, ToolWin,
  ComCtrls, ExtCtrls, DB, ADODB;

type
  Tw_product_master = class(TForm)
    ToolBar1: TToolBar;
    btadd: TBitBtn;
    btok: TBitBtn;
    Btdel: TBitBtn;
    btno1: TBitBtn;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    ado_product_master: TADOQuery;
    data_product_master: TDataSource;
    ado_product_masterproduct_id: TStringField;
    ado_product_masterproduct_item_id: TStringField;
    ado_product_masterproduct_item_unit: TStringField;
    ado_product_masterunit_amount: TFloatField;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    procedure btaddClick(Sender: TObject);
    procedure btokClick(Sender: TObject);
    procedure btno1Click(Sender: TObject);
    procedure BtdelClick(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  w_product_master: Tw_product_master;

implementation

uses f_product_id, f_product_item_id, f_main;

{$R *.dfm}

procedure Tw_product_master.btaddClick(Sender: TObject);
begin
try
   ado_product_master.Append;
  except
    showmessage('產(chǎn)生例外錯誤，請聯(lián)系開發(fā)人員或者程序供應商');
  end;
end;
procedure Tw_product_master.btokClick(Sender: TObject);
begin
try
   ado_product_master.Post;
  except
    showmessage('產(chǎn)生例外錯誤，請聯(lián)系開發(fā)人員或者程序供應商');
  end;
end;

procedure Tw_product_master.btno1Click(Sender: TObject);
begin
try
   ado_product_master.Cancel;
  except
    showmessage('產(chǎn)生例外錯誤，請聯(lián)系開發(fā)人員或者程序供應商');
  end;
  close;
end;

procedure Tw_product_master.BtdelClick(Sender: TObject);
begin
try
    if MessageDlg('您確定要刪除錄入的數(shù)據(jù)嗎？', mtConfirmation, [mbYes, mbNo], 0) = mrYes then
       ado_product_master.Delete;
  except
    showmessage('產(chǎn)生例外錯誤，請聯(lián)系開發(fā)人員或者程序供應商');
  end;
end;

procedure Tw_product_master.SpeedButton1Click(Sender: TObject);
begin
Application.CreateForm(Tw_product_id, w_product_id);
  if w_product_id.ShowModal = mrOk then
  DBEdit1.Text:=copy(trim(w_product_id.combobox1.text),1,5);
end;

procedure Tw_product_master.SpeedButton2Click(Sender: TObject);
begin
Application.CreateForm(Tw_product_item_id, w_product_item_id);
  if w_product_item_id.ShowModal = mrOk then
  DBEdit2.Text:=copy(trim(w_product_item_id.combobox1.text),1,5);
end;

procedure Tw_product_master.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
w_main.Enabled:=true;
end;

procedure Tw_product_master.FormCreate(Sender: TObject);
begin
w_main.Enabled:=false;
end;

end.