unit f_cost_master;

interface

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

type
  Tw_cost_master = class(TForm)
    ToolBar1: TToolBar;
    btadd: TBitBtn;
    btok: TBitBtn;
    Btdel: TBitBtn;
    btno1: TBitBtn;
    GroupBox1: TGroupBox;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    DBGrid1: TDBGrid;
    ado_cost_master: TADOQuery;
    ado_cost_masterworkshop_id: TStringField;
    ado_cost_masterresourse_id: TStringField;
    ado_cost_masterseason_num: TIntegerField;
    ado_cost_masterresourse_cost: TFloatField;
    data_cost_master: TDataSource;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    procedure btaddClick(Sender: TObject);
    procedure btokClick(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure BtdelClick(Sender: TObject);
    procedure btno1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  w_cost_master: Tw_cost_master;

implementation

uses f_workshop_id, f_resourse_id, f_main;

{$R *.dfm}

procedure Tw_cost_master.btaddClick(Sender: TObject);
begin
try
   ado_cost_master.Append;
  except
    showmessage('產生例外錯誤，請聯系開發人員或者程序供應商');
  end;
end;

procedure Tw_cost_master.btokClick(Sender: TObject);
begin
try
   ado_cost_master.Post;
  except
    showmessage('產生例外錯誤，請聯系開發人員或者程序供應商');
  end;
end;

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

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

procedure Tw_cost_master.btno1Click(Sender: TObject);
begin
try
   ado_cost_master.Cancel;
  except
    showmessage('產生例外錯誤，請聯系開發人員或者程序供應商');
  end;
  close;
end;

procedure Tw_cost_master.SpeedButton2Click(Sender: TObject);
begin
application.CreateForm(tw_resourse_id,w_resourse_id); 
  if w_resourse_id.ShowModal=mrok then
  dbedit2.Text:=copy(trim(w_resourse_id.ComboBox1 .Text),1,5);
end;

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

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

end.