unit Unit2;

interface

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

type
  TFormjin = class(TForm)
    GroupBox1: TGroupBox;
    Panel1: TPanel;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    Label3: TLabel;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    Label4: TLabel;
    DBEdit2: TDBEdit;
    Panel2: TPanel;
    Label5: TLabel;
    DBEdit3: TDBEdit;
    Label6: TLabel;
    DBEdit4: TDBEdit;
    Panel3: TPanel;
    Label11: TLabel;
    DBEdit9: TDBEdit;
    DBGrid1: TDBGrid;
    Label9: TLabel;
    Label8: TLabel;
    Panel4: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    SpeedButton7: TSpeedButton;
    DBNavigator1: TDBNavigator;
    DBMemo1: TDBMemo;
    Label10: TLabel;
    DBEdit8: TDBEdit;
    DBComboBox3: TDBComboBox;
    Label7: TLabel;
    DBEdit5: TDBEdit;
    Table1: TTable;
    DataSource1: TDataSource;
    Table1BDEDesigner: TAutoIncField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TDateField;
    Table1BDEDesigner5: TFloatField;
    Table1BDEDesigner6: TFloatField;
    Table1BDEDesigner7: TCurrencyField;
    Table1BDEDesigner8: TStringField;
    Table1BDEDesigner9: TCurrencyField;
    Table1BDEDesigner10: TMemoField;
    Table1CurrencyField: TCurrencyField;
    
    procedure SpeedButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure Table1AfterInsert(DataSet: TDataSet);
    procedure Table1AfterPost(DataSet: TDataSet);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Table1CalcFields(DataSet: TDataSet);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton7Click(Sender: TObject);

   
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Formjin: TFormjin;

implementation

uses Unit1, Unit4, Unit8, Unit14;

{$R *.dfm}
procedure TFormjin.SpeedButton1Click(Sender: TObject);
begin
close;
end;


procedure TFormjin.FormCreate(Sender: TObject);
begin
DBGRID1.ReadOnly:=true;
Table1.Open;
end;

procedure TFormjin.SpeedButton6Click(Sender: TObject);
begin
Table1.Insert;
end;

procedure TFormjin.SpeedButton5Click(Sender: TObject);
begin
if(Application.MessageBox('是否確定要刪除記錄','確認刪除',
MB_YESNO+MB_ICONQUESTION)<>IDNO) then
if(Table1.RecordCount>0) then
Table1.Delete;
end;

procedure TFormjin.SpeedButton3Click(Sender: TObject);
begin
if(Table1.Modified) then
table1.Post;
speedbutton6.Enabled:=true;
speedbutton7.Enabled:=true;
speedbutton4.Enabled:=true;
speedbutton5.Enabled:=true;
DBNavigator1.Enabled:=true;
end;

procedure TFormjin.SpeedButton2Click(Sender: TObject);
begin
if(table1.Modified) then
table1.Cancel;
speedbutton6.Enabled:=true;
speedbutton7.Enabled:=true;
speedbutton4.Enabled:=true;
speedbutton5.Enabled:=true;
DBNavigator1.Enabled:=true;
end;

procedure TFormjin.Table1AfterInsert(DataSet: TDataSet);
begin
dataSet.FieldByName('進貨時間').Asstring := datetostr(Now);
speedbutton6.Enabled:=false;
speedbutton7.Enabled:=false;
speedbutton4.Enabled:=false;
speedbutton5.Enabled:=false;
DBNavigator1.Enabled:=false;
end;

procedure TFormjin.Table1AfterPost(DataSet: TDataSet);
begin
speedbutton6.Enabled:=true;
speedbutton7.Enabled:=true;
speedbutton4.Enabled:=true;
speedbutton5.Enabled:=true;
DBNavigator1.Enabled:=true;
end;

procedure TFormjin.FormClose(Sender: TObject; var Action: TCloseAction);
begin
table1.Close;

end;

procedure TFormjin.Table1CalcFields(DataSet: TDataSet);

var
quantity1:single;
price1:Currency;
begin
quantity1:=Table1.FieldByName('進貨數量').asfloat;
//數量
price1:=Table1.FieldByName('貨品單價').asCurrency;
//單價
Table1.FieldByName('應付款數').asCurrency:=quantity1*price1;
//應付資金
end;

procedure TFormjin.SpeedButton4Click(Sender: TObject);
begin
formcha:=Tformcha.create(self);
formcha.Show;
formcha.PageControl1.ActivePageIndex:=0;
end;

procedure TFormjin.SpeedButton7Click(Sender: TObject);
begin
form_jinp:=Tform_jinp.create(self);
form_jinp.QuickRep1.Preview;
form_jinp.Close;
end;

end.