unit3.pas

来自「玉龙飞雪进销存管理系统,可以帮您管理进销存的软件」· PAS 代码 · 共 201 行

unit Unit3;

interface

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

type
  TFormxiao = class(TForm)
    GroupBox1: TGroupBox;
    Panel1: TPanel;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBComboBox1: TDBComboBox;
    Label3: TLabel;
    DBComboBox2: TDBComboBox;
    Label4: TLabel;
    DBEdit2: TDBEdit;
    Panel2: TPanel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit4: TDBEdit;
    Panel3: TPanel;
    Label9: TLabel;
    DBEdit7: TDBEdit;
    Label10: TLabel;
    DBEdit8: TDBEdit;
    Label13: TLabel;
    DBGrid1: TDBGrid;
    Label11: TLabel;
    DBEdit9: TDBEdit;
    DBEdit5: TDBEdit;
    Label7: TLabel;
    DBLookupComboBox1: TDBLookupComboBox;
    Panel4: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    SpeedButton7: TSpeedButton;
    DBNavigator1: TDBNavigator;
    DBMemo1: TDBMemo;
    Label8: TLabel;
    DBComboBox3: TDBComboBox;
    Table1: TTable;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    Table2: TTable;
    Table1BDEDesigner: TAutoIncField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TDateField;
    Table1BDEDesigner5: TStringField;
    Table1BDEDesigner6: TFloatField;
    Table1BDEDesigner7: TFloatField;
    Table1BDEDesigner8: TCurrencyField;
    Table1BDEDesigner9: TStringField;
    Table1BDEDesigner10: TCurrencyField;
    Table1BDEDesigner11: TMemoField;
    Table1Field: TCurrencyField;
    procedure SpeedButton1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    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 Table1CalcFields(DataSet: TDataSet);
    procedure SpeedButton4Click(Sender: TObject);
    procedure Table1BeforeClose(DataSet: TDataSet);
    procedure SpeedButton7Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Formxiao: TFormxiao;

implementation

uses Unit4, Unit9, Unit14;

{$R *.dfm}



procedure TFormxiao.SpeedButton1Click(Sender: TObject);
begin
close;
end;

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

procedure TFormxiao.FormClose(Sender: TObject; var Action: TCloseAction);
begin
table1.Close;
table2.Close;
end;

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

procedure TFormxiao.SpeedButton5Click(Sender: TObject);
begin
if(Application.MessageBox('是否确定要删除记录','确认删除',
MB_YESNO+MB_ICONQUESTION)<>IDNO) then
if(Table1.RecordCount>0) then
Table1.Delete;
end;

procedure TFormxiao.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 TFormxiao.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 TFormxiao.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 TFormxiao.Table1AfterPost(DataSet: TDataSet);
begin
speedbutton6.Enabled:=true;
speedbutton7.Enabled:=true;
speedbutton4.Enabled:=true;
speedbutton5.Enabled:=true;
DBNavigator1.Enabled:=true;
end;

procedure TFormxiao.Table1CalcFields(DataSet: TDataSet);
var
quantity1:single;
price1:Currency;
begin
quantity1:=Table1.FieldByName('销售数量').asfloat;

price1:=Table1.FieldByName('销售单价').asCurrency;

Table1.FieldByName('应付款数').asCurrency:=quantity1*price1;

end;

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

procedure TFormxiao.Table1BeforeClose(DataSet: TDataSet);
begin
table1.Edit;
table1.Post;
end;

procedure TFormxiao.SpeedButton7Click(Sender: TObject);
begin
formxiaop:=Tformxiaop.create(self);
formxiaop.QuickRep1.Preview;
formxiaop.Close;
end;
end.