ullxx.pas

小型企业物品管理系统,DELPHI源码+ACCESS数据库

unit Ullxx;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGridEh, DB, ADODB, ComCtrls, RzTreeVw, ExtCtrls,
  RzPanel, RzSplit, PrnDbgeh, ActnList, RzButton, StdCtrls, RzTabs;

type
  TFllxx = class(TForm)
    qryview_sell: TADOQuery;
    qryview_sellseid: TAutoIncField;
    qryview_sellbwname: TStringField;
    qryview_sellbwunit: TStringField;
    qryview_sellbwprice: TBCDField;
    qryview_sellbwid: TIntegerField;
    qryview_sellsedate: TDateTimeField;
    qryview_sellczid: TIntegerField;
    qryview_sellllid: TIntegerField;
    qryview_sellsequanty: TIntegerField;
    qryview_sellsememo: TStringField;
    qryview_sellllname: TStringField;
    qryview_sellczname: TStringField;
    qryview_sellclname: TStringField;
    qryview_sellclid: TIntegerField;
    qryview_selldeid: TIntegerField;
    qryview_selldename: TStringField;
    dssell: TDataSource;
    PrintDBGridEh1: TPrintDBGridEh;
    RzStatusBar1: TRzStatusBar;
    RzToolbar1: TRzToolbar;
    dsclass: TDataSource;
    actlst1: TActionList;
    ashow: TAction;
    RzToolButton1: TRzToolButton;
    RzToolButton3: TRzToolButton;
    RzSpacer1: TRzSpacer;
    RzSpacer2: TRzSpacer;
    wpclass: TEdit;
    RzPageControl1: TRzPageControl;
    TabSheet1: TRzTabSheet;
    TabSheet2: TRzTabSheet;
    DBGridEh2: TDBGridEh;
    procedure ashowExecute(Sender: TObject);
   // procedure RzToolButton2Click(Sender: TObject);
    procedure RzToolButton3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure RzToolButton1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Fllxx: TFllxx;

implementation

uses Udate, Umain;

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

procedure TFllxx.ashowExecute(Sender: TObject);
begin
  fdate.qryclass.Close;
  fdate.qryclass.Open;
  with qryview_sell do begin
    Close;SQL.Clear;SQL.Add('select * from view_sell where clid='''+wpclass.Text+''' order by sedate');
    Open;
  end;
end;

procedure TFllxx.FormShow(Sender: TObject);
begin
  ashow.Execute;
end;

procedure TFllxx.RzToolButton1Click(Sender: TObject);
begin
  if MessageDlg('真的要打印吗？',mtInformation,[mbYes,mbno],0)=idyes then
    PrintDBGridEh1.Preview
  else
    Exit;
end;

end.