f_labor_master.pas

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

unit f_labor_master;

interface

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

type
  Tw_labor_master = class(TForm)
    ToolBar1: TToolBar;
    btadd: TBitBtn;
    btok: TBitBtn;
    Btdel: TBitBtn;
    btno1: TBitBtn;
    DBGrid1: TDBGrid;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    data_labor_master: TDataSource;
    ado_labormaster: TADOQuery;
    ado_labormasterproduct_id: TStringField;
    ado_labormasterlabor_id: TStringField;
    ado_labormasterlabor_unit: TStringField;
    ado_labormasterunit_amount: TFloatField;
    ado_labormasterunit_cost: TFloatField;
    BitBtn1: TBitBtn;
    procedure btaddClick(Sender: TObject);
    procedure btokClick(Sender: TObject);
    procedure BtdelClick(Sender: TObject);
    procedure btno1Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  w_labor_master: Tw_labor_master;

implementation

uses data_1, f_product_id, f_labor_id, f_main;

{$R *.dfm}

procedure Tw_labor_master.btaddClick(Sender: TObject);
begin
 try
   ado_labormaster.Append;
   ado_labormaster.FieldByName('unit_cost').AsString:=trim(dbedit5.Text);
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;
procedure Tw_labor_master.btokClick(Sender: TObject);
begin
try
   ado_labormaster.Post;
  except
    showmessage('产生例外错误，请联系开发人员或者程序供应商');
  end;
end;

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

procedure Tw_labor_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_labor_master.SpeedButton2Click(Sender: TObject);
begin
   Application.CreateForm(Tw_labor_id, w_labor_id);
  if w_labor_id.ShowModal = mrOk then
  DBEdit2.Text:=copy(trim(w_labor_id.combobox1.text),1,5);
end;
procedure Tw_labor_master.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
w_main.Enabled:=true;
end;

procedure Tw_labor_master.FormCreate(Sender: TObject);
begin
w_main.Enabled:=false;
end;
procedure Tw_labor_master.BitBtn1Click(Sender: TObject);
begin
dbedit5.Text:=floattostr(ado_labormaster.fieldbyname('labor_unit').Value*ado_labormaster.fieldbyname('unit_amount').Value);
end;

end.