ucgdd_lb.pas

工廠採購管理系統

unit ucgdd_lb;

interface

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

type
  Tfrmcgdd_lb = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    RzBitBtn1: TRzBitBtn;
    RzBitBtn2: TRzBitBtn;
    RzBitBtn3: TRzBitBtn;
    RzBitBtn4: TRzBitBtn;
    Label1: TLabel;
    ComboBox1: TComboBox;
    Label2: TLabel;
    ComboBox2: TComboBox;
    Label3: TLabel;
    dtp1: TRzDateTimePicker;
    dtp2: TRzDateTimePicker;
    DBGridEh1: TDBGridEh;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    DataSource1: TDataSource;
    procedure csh();
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure ComboBox2Change(Sender: TObject);
    procedure dtp1Exit(Sender: TObject);
    procedure dtp2Exit(Sender: TObject);
    procedure RzBitBtn4Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure RzBitBtn1Click(Sender: TObject);
    procedure RzBitBtn3Click(Sender: TObject);
    procedure RzBitBtn2Click(Sender: TObject);
    procedure DBGridEh1TitleClick(Column: TColumnEh);
  private
    { Private declarations }
    hjje:double;
    zsl:longint;
  public
    { Public declarations }
  end;

var
  frmcgdd_lb: Tfrmcgdd_lb;

implementation
uses uconst,ufunction,udm1,ucx,Unit3;
{$R *.dfm}
procedure tfrmcgdd_lb.csh();
begin
zsl:=0;
hjje:=0;
strsql:='select * from view_cgddlb 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;
if adoquery1.Recordset.eof and adoquery1.Recordset.BOF then exit;
adoquery1.First;
while not adoquery1.Eof do
    begin
    hjje:=hjje+adoquery1.fieldbyname('金额').Value;
    zsl:=zsl+ hjje+adoquery1.fieldbyname('数量').Value;
    adoquery1.Next;
    end;
DBGridEh1.Columns[1].Footer.Value := formatfloat('0.00',hjje);
DBGridEh1.Columns[3].Footer.Value := inttostr(zsl);
strsql:='select distinct xqdh from cgdd_main where cgrq>=:rq1 and cgrq<=:rq2 order by xqdh asc';
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
        combobox1.Items.Clear;
        combobox2.Items.Clear;
        adoquery2.First;
        while not adoquery2.Eof do
        begin
        combobox1.Items.add(trim(adoquery2.fieldbyname('xqdh').AsString));
        adoquery2.Next;
        end;
        adoquery2.Close;
   end;

end;
procedure Tfrmcgdd_lb.FormCreate(Sender: TObject);
begin
adoquery1.Connection:=dm1.ADOConnection1;
adoquery2.Connection:=dm1.ADOConnection1;
dtp1.Date:=date-30;
dtp2.Date:=date;
csh;
        DBGridEh1.FooterRowCount:=1;
        DBGridEh1.SumList.Active:=True;
        DBGridEh1.Columns[0].Footer.ValueType := fvtStaticText;
        DBGridEh1.Columns[0].Footer.Value := '总人数：';
end;

procedure Tfrmcgdd_lb.ComboBox1Change(Sender: TObject);
begin
strsql:='select * from view_cgddlb where 需求单号='+''''+trim(combobox1.Text)+'''';
adoexect(adoquery1,strsql);
strsql:='select * from cgdd_main where xqdh='+''''+trim(combobox1.Text)+'''';
adoexect(adoquery2,strsql);
if adoquery2.Recordset.EOF and adoquery2.Recordset.BOF then exit;
adoquery2.First;
combobox2.Items.Clear;
while not adoquery2.Eof do
     begin
     combobox2.Items.Add(adoquery2.fieldbyname('ddhm').AsString);
     adoquery2.Next;
     end;
adoquery2.Close;

end;

procedure Tfrmcgdd_lb.ComboBox2Change(Sender: TObject);
begin
strsql:='select * from view_cgddlb where 订单号码='+''''+trim(combobox2.Text)+'''';
adoexect(adoquery1,strsql);
end;

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

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

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

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

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

procedure Tfrmcgdd_lb.RzBitBtn3Click(Sender: TObject);
begin
form3.frDBDataSet1.dataset:=adoquery1;
form3.frReport1.DoublePass := True;
form3.frReport1.Clear;
form3.frReport1.LoadFromFile(strpath+'/report/cgddlb.frf');
frVariables['username']:=username;
form3.frReport1.Preview := Form3.frPreview1;
if form3.frReport1.PrepareReport then
  begin
    form3.frReport1.ShowPreparedReport;
  end;
form3.ShowModal;

end;

procedure Tfrmcgdd_lb.RzBitBtn2Click(Sender: TObject);
begin
form3.frDBDataSet1.dataset:=adoquery1;
form3.frReport1.DoublePass := True;
form3.frReport1.Clear;
form3.frReport1.LoadFromFile(strpath+'/report/cgddlb.frf');
frVariables['username']:=username;
form3.frreport1.DesignReport;
end;

procedure Tfrmcgdd_lb.DBGridEh1TitleClick(Column: TColumnEh);
begin
 Compositor(adoquery1,Column);
end;

end.