dfm_price.pas

仓库管理系统 仓库管理系统

unit dfm_price;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  ComCtrls, StdCtrls, Buttons, ExtCtrls, Grids, DBGrids, Db, DBTables, Mask,
  DBCtrls, ADODB;

type
  Tdfmprice = class(TForm)
    StatusBar1: TStatusBar;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Label2: TLabel;
    Label11: TLabel;
    ComboBox1: TComboBox;
    BitBtn1: TBitBtn;
    DataSource1: TDataSource;
    Edit1: TEdit;
    ADOQuery1: TADOQuery;
    ADOQuery1clabel: TWideStringField;
    ADOQuery1spbh: TWideStringField;
    ADOQuery1lsj: TBCDField;
    ADOQuery1cname: TWideStringField;
    DataSource2: TDataSource;
    ADOTable1: TADOTable;
    Label1: TLabel;
    MaskEdit1: TMaskEdit;
    BitBtn2: TBitBtn;
    ADOQuery2: TADOQuery;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure quitbtnClick(Sender: TObject);
    procedure dstmanrecStateChange(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormKeyPress(Sender: TObject; var Key: Char);
    procedure BitBtn2Click(Sender: TObject);
    procedure MaskEdit1KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  dfmprice: Tdfmprice;

implementation

uses  dbmRainbowMis, chHeadUnit;

{$R *.DFM}

procedure Tdfmprice.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  action:=cafree;
end;

procedure Tdfmprice.quitbtnClick(Sender: TObject);
begin
  close;
end;

procedure Tdfmprice.dstmanrecStateChange(Sender: TObject);
begin
{    case tbltmanrec.State of
      dsbrowse:
        begin
          addbtn.Enabled :=true;
          delbtn.Enabled :=true;
//          BitBtn_edit.Enabled :=true;
          postbtn.Enabled :=false;
          cancelbtn.Enabled :=false;
        end;
      dsinsert:
        begin
          addbtn.Enabled :=false;
          delbtn.Enabled :=false;
//          BitBtn_edit.Enabled :=true;
          postbtn.Enabled :=true;
          cancelbtn.Enabled :=true;
        end;
      dsedit:
        begin
          addbtn.Enabled :=false;
          delbtn.Enabled :=false;
//          BitBtn_edit.Enabled :=true;
          postbtn.Enabled :=true;
          cancelbtn.Enabled :=true;
        end;
    end;}
end;

procedure Tdfmprice.BitBtn1Click(Sender: TObject);
begin
  with ADOQuery1 do
  begin
    close;
    Parameters.ParamByName ('vspbh').value:=trim(edit1.text)+'%';
    Parameters.ParamByName ('vlabel').value:=trim(combobox1.Text)+'%';
    open;
  end;
end;

procedure Tdfmprice.FormCreate(Sender: TObject);
begin
  ADOTable1.Open ;
  chHeadUnit.combolist(combobox1,ADOTable1,'clabel','cclass',1);
end;

procedure Tdfmprice.FormKeyPress(Sender: TObject; var Key: Char);
begin
  chHeadUnit.tabventer(dfmprice,key); 
end;

procedure Tdfmprice.BitBtn2Click(Sender: TObject);
begin
  if trim(MaskEdit1.Text)<>'' then
  begin
    with ADOQuery2 do
    begin
      close;
      Parameters.ParamByName ('vlsj').value:=strtofloat(trim(maskedit1.text));
      Parameters.ParamByName ('vspbh').value:=trim(edit1.text)+'%';
      Parameters.ParamByName ('vlabel').value:=trim(combobox1.Text)+'%';
      ExecSQL;
    end;
    BitBtn1Click(BitBtn1);
  end;   
end;

procedure Tdfmprice.MaskEdit1KeyPress(Sender: TObject; var Key: Char);
begin
//  if not ((key in ['0'..'9']) or (key=#8) or (key=#48)) then key:=#0;
end;

end.