f_workshop_master.pas

使用Delphi开发的成本管理系统

unit f_workshop_master;

interface

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

type
  Tw_workshop_master = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    ado_workshop_master: TADOQuery;
    data_workshop_master: TDataSource;
    ToolBar1: TToolBar;
    btadd: TBitBtn;
    btok: TBitBtn;
    Btdel: TBitBtn;
    btno1: TBitBtn;
    ado_workshop_masterworkshop_id: TStringField;
    ado_workshop_masterworkshop_item_id: TStringField;
    ado_workshop_masterworkshop_item_unit: TStringField;
    ado_workshop_masterunit_amount: TFloatField;
    DBEdit1: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure btaddClick(Sender: TObject);
    procedure btokClick(Sender: TObject);
    procedure BtdelClick(Sender: TObject);
    procedure btno1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  w_workshop_master: Tw_workshop_master;

implementation

uses f_workshop_id, f_workshop_item_id, f_main;

{$R *.dfm}

procedure Tw_workshop_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_workshop_master.SpeedButton2Click(Sender: TObject);
begin
 Application.CreateForm(Tw_workshop_item_id, w_workshop_item_id);
  if w_workshop_item_id.ShowModal = mrOk then
  DBEdit5.Text:=copy(trim(w_workshop_item_id.combobox1.text),1,5);
end;

procedure Tw_workshop_master.btaddClick(Sender: TObject);
begin
try
   ado_workshop_master.Append;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;

procedure Tw_workshop_master.btokClick(Sender: TObject);
begin
try
   ado_workshop_master.post;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;
procedure Tw_workshop_master.BtdelClick(Sender: TObject);
begin
try
    if MessageDlg('您确定要删除录入的数据吗？', mtConfirmation, [mbYes, mbNo], 0) = mrYes then
       ado_workshop_master.Delete;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;

procedure Tw_workshop_master.btno1Click(Sender: TObject);
begin
try
   ado_workshop_master.Cancel;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
  close;
end;
procedure Tw_workshop_master.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
w_main.Enabled:=true;
end;

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