u_otherchargeqry.~pas

河南师范大学餐饮进销存软件,只要控制库存的数据。

unit u_OtherChargeQRY;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, ComCtrls, Grids, DBGrids, DB, ADODB;

type
  TfrmOtherChargeQry = class(TForm)
    Panel1: TPanel;
    edtName: TLabeledEdit;
    edtUser: TLabeledEdit;
    dtpDate: TDateTimePicker;
    Label1: TLabel;
    qry: TADOQuery;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    procedure edtNameChange(Sender: TObject);
    procedure edtUserChange(Sender: TObject);
    procedure dtpDateChange(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmOtherChargeQry: TfrmOtherChargeQry;

implementation

uses u_DataCtrl;

{$R *.dfm}

procedure TfrmOtherChargeQry.edtNameChange(Sender: TObject);
begin
  qry.Close;
  qry.SQL.Clear;
  qry.SQL.Text := 'exec psp_OtherCharge '+QuotedStr(edtName.Text)+','+QuotedStr(edtUser.Text)+','+QuotedStr(FormatDateTime('yyyy-mm-dd',dtpDate.Date));
  qry.Open;
end;

procedure TfrmOtherChargeQry.edtUserChange(Sender: TObject);
begin
  qry.Close;
  qry.SQL.Clear;
  qry.SQL.Text := 'exec psp_OtherCharge '+QuotedStr(edtName.Text)+','+QuotedStr(edtUser.Text)+','+QuotedStr(FormatDateTime('yyyy-mm-dd',dtpDate.Date));
  qry.Open;
end;

procedure TfrmOtherChargeQry.dtpDateChange(Sender: TObject);
begin
  qry.Close;
  qry.SQL.Clear;
  qry.SQL.Text := 'exec psp_OtherCharge '+QuotedStr(edtName.Text)+','+QuotedStr(edtUser.Text)+','+QuotedStr(FormatDateTime('yyyy-mm-dd',dtpDate.Date));
  qry.Open;
end;

procedure TfrmOtherChargeQry.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  Action := Cafree ;
end;

procedure TfrmOtherChargeQry.FormShow(Sender: TObject);
begin
  qry.Active := True;
  edtName.Clear;
  edtUser.Clear;
end;

end.