uwljg_db.pas

工廠採購管理系統

unit uwljg_db;

interface

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

type
  Tfrmwljg_db = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    RzBitBtn1: TRzBitBtn;
    RzBitBtn2: TRzBitBtn;
    RzBitBtn3: TRzBitBtn;
    RzBitBtn4: TRzBitBtn;
    dtp1: TRzDateTimePicker;
    dtp2: TRzDateTimePicker;
    Label1: TLabel;
    Label2: TLabel;
    ComboBox1: TComboBox;
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    DBGridEh1: TDBGridEh;
    frReport1: TfrReport;
    frDBDataSet1: TfrDBDataSet;
    Label3: TLabel;
    Edit1: TEdit;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure RzBitBtn4Click(Sender: TObject);
    procedure RzBitBtn1Click(Sender: TObject);
    procedure csh();
    procedure ComboBox1Change(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure dtp1Exit(Sender: TObject);
    procedure dtp2Exit(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmwljg_db: Tfrmwljg_db;

implementation
uses uconst,ufunction,udm1,ucx;
{$R *.dfm}
procedure tfrmwljg_db.csh();
begin
strsql:='select * from view_wlbjdb where 日期>=:rq1 and 日期<=:rq2';
if adoquery1.Active then adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add(strsql);

adoquery1.Parameters.ParamByName('rq1').Value:=dtp1.Date;
adoquery1.Parameters.ParamByName('rq2').Value:=dtp2.Date;
adoquery1.Open;
strsql:='select distinct cgjhdh from cgjh_main where srrq>=:rq1 and srrq<=:rq2';
if adoquery2.Active then adoquery2.Close;
adoquery2.SQL.Clear;
adoquery2.SQL.Add(strsql);
adoquery2.Parameters.ParamByName('rq1').Value:=dtp1.Date;
adoquery2.Parameters.ParamByName('rq2').Value:=dtp2.Date;
adoquery2.Open;
if not(adoquery2.Recordset.eof and adoquery2.Recordset.BOF) then
   begin
        adoquery2.First;
        combobox1.Items.Clear;
        while not adoquery2.Eof do
             begin
                  combobox1.Items.Add(adoquery2.fieldbyname('cgjhdh').AsString);
                  adoquery2.Next;
             end;
   end;
adoquery2.Close;
end;
procedure Tfrmwljg_db.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

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

procedure Tfrmwljg_db.RzBitBtn1Click(Sender: TObject);
begin
frmcx:=tfrmcx.Create(self);
frmcx.adocx:=adoquery1;
frmcx.ShowModal;
adoquery1:=frmcx.adocx;
ADOquery1.Requery();
end;

procedure Tfrmwljg_db.ComboBox1Change(Sender: TObject);
begin
strsql:='select * from view_wlbjdb where 计划单号='+''''+trim(combobox1.Text)+'''';
adoexect(adoquery1,strsql);


end;

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

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

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

procedure Tfrmwljg_db.Edit1Change(Sender: TObject);
begin
strsql:='select * from view_wlbjdb where 助记码 like '+''''+trim(edit1.Text)+'%'+'''';
adoexect(adoquery1,strsql);
if adoquery1.Recordset.eof and adoquery1.Recordset.BOF then
   begin
   strsql:='select * from view_wlbjdb where 物料名称 like '+''''+'%'+trim(edit1.Text)+'%'+'''';
   adoexect(adoquery1,strsql);
   end;
end;

end.