yj_find1.pas

delphi开发的委托加工管理系统源代码

unit yj_find1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, RzButton, ExtCtrls, RzPanel, StdCtrls, RzCmboBx, DB, ADODB,
  ComCtrls, RzDTP, DosMove;

type
  Tyj_find = class(TForm)
    RzGroupBox1: TRzGroupBox;
    RzGroupBox2: TRzGroupBox;
    RzBitBtn1: TRzBitBtn;
    RzBitBtn2: TRzBitBtn;
    Label1: TLabel;
    ADOQuery1: TADOQuery;
    Edit1: TEdit;
    Label2: TLabel;
    DosMove1: TDosMove;
    procedure RzBitBtn2Click(Sender: TObject);
    procedure RzBitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  yj_find: Tyj_find;

implementation

uses adodm, yjql1;

{$R *.dfm}

procedure Tyj_find.RzBitBtn2Click(Sender: TObject);
begin
close
end;

procedure Tyj_find.RzBitBtn1Click(Sender: TObject);
begin
if edit1.Text='' then
showmessage('请输入查询月份')
else
begin
yjql.adodataset1.Active:=false;
yjql.adodataset1.CommandText:='select ckdate as 日期,wtno as 委托单号,wtnumber as 物料代码,wtpm as 品名,cksl as 数量,ckmoney as 金额,jgmoney as 加工金额,mon as 月份 from yjql where mon='''+trim(edit1.text)+''' order by wtnumber,ckdate';
yjql.adodataset1.Active:=true;
yjql.dbgrideh1.Columns[0].Width:=60;
yjql.dbgrideh1.Columns[1].Width:=120;
yjql.dbgrideh1.Columns[2].Width:=150;
yjql.dbgrideh1.Columns[3].Width:=120;
yjql.dbgrideh1.Columns[4].Width:=60;
yjql.dbgrideh1.Columns[5].Width:=60;
yjql.dbgrideh1.Columns[6].Width:=60;
yjql.dbgrideh1.Columns[7].Width:=60;
close;
end;
end;

end.