unitlsdjsc.pas

西京票据管理系统刚刚获得

unit Unitlsdjsc;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, ComCtrls;

type
  TFormlsdjsc = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Button1: TButton;
    Button2: TButton;
    Edid: TEdit;
    Clx: TComboBox;
    Czt: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Cdd: TComboBox;
    Label4: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Formlsdjsc: TFormlsdjsc;

implementation
uses UDM;
{$R *.dfm}

procedure TFormlsdjsc.Button2Click(Sender: TObject);
begin
  close;
end;

procedure TFormlsdjsc.FormShow(Sender: TObject);
begin
  Edid.Text:='';
  Clx.Text:='';
  Czt.Text:='';
  Cdd.Text:='';
    with dm.qrytemp do
     begin
       Close;
       SQL.Clear;
       SQL.Add('select djzt from meun_zt');
       Prepared;
       Open;
     end;
    Czt.Items.Clear;
    while not dm.qrytemp.Eof do
      begin
        Czt.Items.Append(dm.qrytemp.Fields[0].AsString);
        DM.qrytemp.Next;
      end;


   with dm.qrytemp do
     begin
       Close;
       SQL.Clear;
       SQL.Add('select typename from typeunit');
       Prepared;
       Open;
     end;
    Clx.Items.Clear;
    while not dm.qrytemp.Eof do
      begin
        Clx.Items.Append(dm.qrytemp.Fields[0].AsString);
        DM.qrytemp.Next;
      end;
    with dm.qrytemp do
     begin
       Close;
       SQL.Clear;
       SQL.Add('select placename from ly_place');
       Prepared;
       Open;
     end;
     Cdd.Items.Clear;
     while not dm.qrytemp.Eof do
      begin
        Cdd.Items.Append(dm.qrytemp.Fields[0].AsString);
        dm.qrytemp.Next;
      end;
 if Caption='未领用单据查询' then
   begin
     Czt.Enabled:=False;
     Czt.Color:=clScrollBar;
   end
   else
 if Caption='核销单据查询' then
   begin
    Cdd.Enabled:=False;
     Cdd.Color:=clScrollBar;
   end;
end;

procedure TFormlsdjsc.Button1Click(Sender: TObject);
begin
 if Caption='未领用单据查询' then
   begin
     with DM.ADOlibnumber do
      begin
        close;
        SQL.Clear;
        SQL.Add('select * from libnumber');
        SQL.Add('where numberid=:id and numbertype like :type and libnumberplace like :place');
        Parameters.ParamByName('id').Value:=Edid.Text;
        Parameters.ParamByName('type').Value:='%'+clx.Text+'%';
        Parameters.ParamByName('place').Value:='%'+cdd.Text+'%';
        Prepared;
        Open;
      end;
   end
   else
 if Caption='核销单据查询' then
   begin
     with DM.ADOlibnumberls do
      begin
        close;
        SQL.Clear;
        SQL.Add('select * from libnumberls');
        SQL.Add('where numberid=:id and numbertype like :type and zt like :zt');
        Parameters.ParamByName('id').Value:=Edid.Text;
        Parameters.ParamByName('type').Value:='%'+clx.Text+'%';
        Parameters.ParamByName('zt').Value:='%'+czt.Text+'%';
        Prepared;
        Open;
      end;
   end;

end;

end.