fkcpd.pas

进销存开发系统

unit Fkcpd;

interface

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

type
  TF_kcpd = class(TF_base)
    ToolBar1: TToolBar;
    SpeedButton1: TSpeedButton;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    SpeedButton2: TSpeedButton;
    ToolButton1: TToolButton;
    ToolButton2: TToolButton;
    ToolButton3: TToolButton;
    SpeedButton3: TSpeedButton;
    Panel1: TPanel;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label3: TLabel;
    Edit3: TEdit;
    Label5: TLabel;
    Edit5: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Label4: TLabel;
    Edit4: TEdit;
    Label6: TLabel;
    Edit6: TEdit;
    ToolButton4: TToolButton;
    ToolButton5: TToolButton;
    ToolButton6: TToolButton;
    ToolButton7: TToolButton;
    SpeedButton4: TSpeedButton;
    procedure FormShow(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_kcpd: TF_kcpd;

implementation
  uses Fdm,Fpypk;
{$R *.dfm}

procedure TF_kcpd.FormShow(Sender: TObject);
begin
  inherited;
  with Adoquery1 do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select tradecode,fullnamed,qty,checked,type,standard,unit,produce,averageprice from tb_stock order by tradecode');
    Open;
  end;
end;

procedure TF_kcpd.SpeedButton5Click(Sender: TObject);
begin
  inherited;
  Application.CreateForm(TF_pypk, F_pypk);
  F_pypk.ShowModal;
  F_pypk.Free;
end;

procedure TF_kcpd.SpeedButton1Click(Sender: TObject);
var
  str:string;
begin
  inherited;
  str:=inputbox('输入商品盘点数量','商品数量 ','');
  if Trim(str)<>'' then
    with Adoquery1 do
    begin
      Edit;
      Fields[3].Value:=strtofloat(str);
      updaterecord;
      post;
    end;
end;

procedure TF_kcpd.SpeedButton3Click(Sender: TObject);
begin
  inherited;
  Panel1.Visible:=not(Panel1.Visible);
  if Panel1.Visible=False then
  begin
    with Adoquery1 do
    begin
      Close;
      SQL.Clear;
      SQL.Add('select tradecode,fullnamed,qty,checked,type,standard,unit,produce,averageprice');
      SQL.Add(' from tb_stock where tradecode like :a and fullnamed like :b and ');
      SQL.Add('type like :c and standard like :d and unit like :e and produce like :f order by tradecode');
      parameters.ParamByName('a').Value:='%'+Trim(Edit1.Text)+'%';
      parameters.ParamByName('b').Value:='%'+Trim(Edit2.Text)+'%';
      parameters.ParamByName('c').Value:='%'+Trim(Edit3.Text)+'%';
      parameters.ParamByName('d').Value:='%'+Trim(Edit4.Text)+'%';
      parameters.ParamByName('e').Value:='%'+Trim(Edit5.Text)+'%';
      parameters.ParamByName('f').Value:='%'+Trim(Edit6.Text)+'%';
      Open; 
    end;
  end;
end;

procedure TF_kcpd.SpeedButton4Click(Sender: TObject);
begin
  inherited;
  Close;
end;

procedure TF_kcpd.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin
  inherited;
  if Application.MessageBox('是否退出？','提示',mb_yesno)=Id_no then
    Canclose:=False;
end;

end.