u_supply.~pas

河南师范大学餐饮进销存软件,只要控制库存的数据。

unit u_Supply;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Menus, ToolWin, ComCtrls, Grids, DBGrids, DB, ADODB, StdCtrls,
  Buttons,u_CustomerEdit,u_SupplyAdd, u_SupplyEdit, ExtCtrls;

type
  TfrmSupplyInfo = class(TForm)
    qry: TADOQuery;
    DataSource1: TDataSource;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    btnAdd: TBitBtn;
    btnClose: TBitBtn;
    btnEdit: TBitBtn;
    btnDelete: TBitBtn;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure btnCloseClick(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure btnAddClick(Sender: TObject);
    procedure btnEditClick(Sender: TObject);
    procedure btnDeleteClick(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    bmkFlag : TBookmark;
    { Public declarations }
  end;

var
  frmSupplyInfo: TfrmSupplyInfo;

implementation

uses u_DataCtrl, u_CustomerAdd;

{$R *.dfm}

procedure TfrmSupplyInfo.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  Action := CaFree ;
end;

procedure TfrmSupplyInfo.btnCloseClick(Sender: TObject);
begin
  Close;
end;

procedure TfrmSupplyInfo.FormShow(Sender: TObject);
begin
  Qry.Active:=true;
  if qry.IsEmpty then
  begin
    btnEdit.Enabled := False;
    btnDelete.Enabled := False;
  end;
end;



procedure TfrmSupplyInfo.btnAddClick(Sender: TObject);
begin
    frmSupplyAdd.ShowModal;
end;

procedure TfrmSupplyInfo.btnEditClick(Sender: TObject);
begin
  frmSupplyEdit.ShowModal;
end;

procedure TfrmSupplyInfo.btnDeleteClick(Sender: TObject);
var
  TempSql : String;
begin
  TempSql:= 'delete from tb_Supply where SupNo='+qry.FieldValues['SupNo'];
  frmDataCtrl.Run_SQL(TempSql);
  qry.Close;
  qry.Open;
  if qry.IsEmpty then
  begin
    btnEdit.Enabled := False;
    btnDelete.Enabled := False;
  end;
end;

procedure TfrmSupplyInfo.DBGrid1DblClick(Sender: TObject);
begin
  if qry.IsEmpty then
  begin
    Application.MessageBox('记录为空','警告',mb_ok);
    Exit;
  end
  else
    btnEdit.Click;
end;

end.