uwlcktj.pas

工廠倉庫管理系統

unit uwlcktj;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, RzButton, StdCtrls, ComCtrls, RzDTP, Grids, DBGrids,
  DB, ADODB, FR_DSet, FR_DBSet, FR_Class;

type
  Tfrmwlcktj = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    RzBitBtn1: TRzBitBtn;
    RzBitBtn2: TRzBitBtn;
    RzBitBtn3: TRzBitBtn;
    RzBitBtn4: TRzBitBtn;
    dtp1: TRzDateTimePicker;
    dtp2: TRzDateTimePicker;
    Label1: TLabel;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    DataSource1: TDataSource;
    frReport1: TfrReport;
    frDBDataSet1: TfrDBDataSet;
    procedure RzBitBtn1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure RzBitBtn4Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure dtp1Exit(Sender: TObject);
    procedure dtp2Exit(Sender: TObject);
    procedure RzBitBtn3Click(Sender: TObject);
    procedure RzBitBtn2Click(Sender: TObject);
    procedure csh();
    procedure DBGrid1TitleClick(Column: TColumn);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmwlcktj: Tfrmwlcktj;

implementation
uses uconst,ufunction,udm1,ucx;
{$R *.dfm}
procedure tfrmwlcktj.csh();
begin
strsql:='exec p_wlcktj '+''''+datetostr(dtp1.date)+''''+','+''''+datetostr(dtp2.date)+'''';
adodel(adoquery1,strsql);
strsql:='select temp_wlcktj.wldm as 物料代码,wlmc as 物料名称,wlys as 颜色,wlsh as 色号,dw as 单位,gysdm as 供应商,'+
'sl as 数量,pym as 拼音码 from temp_wlcktj,wldmk where temp_wlcktj.wldm=wldmk.wldm order by wldmk.pym asc';
adoexect(adoquery1,strsql);
end;
procedure Tfrmwlcktj.RzBitBtn1Click(Sender: TObject);
begin
frmcx:=tfrmcx.Create(self);
frmcx.adocx:=adoquery1;
frmcx.ShowModal;
adoquery1:=frmcx.adocx;
ADOquery1.Requery();
end;

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

procedure Tfrmwlcktj.RzBitBtn4Click(Sender: TObject);
begin
close;
end;

procedure Tfrmwlcktj.FormCreate(Sender: TObject);
begin
adoquery1.Connection:=dm1.ADOConnection1;
adoquery2.Connection:=dm1.ADOConnection1;
dtp1.Date:=date-30;
dtp2.Date:=date;
csh;
end;

procedure Tfrmwlcktj.dtp1Exit(Sender: TObject);
begin
csh;
end;

procedure Tfrmwlcktj.dtp2Exit(Sender: TObject);
begin
csh;
end;

procedure Tfrmwlcktj.RzBitBtn3Click(Sender: TObject);
begin
frReport1.DoublePass := True;
frReport1.Clear;
frReport1.LoadFromFile(strpath+'/report/wlcktj.frf');
frVariables['rq1']:=datetostr(dtp1.Date);
frVariables['rq2']:=datetostr(dtp2.Date);
frVariables['username']:=username;
frreport1.ShowReport;
end;

procedure Tfrmwlcktj.RzBitBtn2Click(Sender: TObject);
begin
frReport1.DoublePass := True;
frReport1.Clear;
frReport1.LoadFromFile(strpath+'/report/wlcktj.frf');
frVariables['username']:=username;
frVariables['rq1']:=datetostr(dtp1.Date);
frVariables['rq2']:=datetostr(dtp2.Date);
frreport1.DesignReport;
end;

procedure Tfrmwlcktj.DBGrid1TitleClick(Column: TColumn);
begin
dgridpx(adoquery1,DBGrid1,Column);
end;

end.