unitqueryout.pas

这是一个SQL的物资管理系统 这是一个SQL的物资管理系统

unit UnitQueryOut;

interface

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

type
  TFrmQueryOut = class(TForm)
    Label1: TLabel;
    cun: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    cmbbxOutDepartment: TComboBox;
    cmbbxUserDepartment: TComboBox;
    edtSign: TEdit;
    edtOutMan: TEdit;
    btnQuery: TButton;
    DBGrid1: TDBGrid;
    ADOStoredProc1: TADOStoredProc;
    DataSource1: TDataSource;
    edtOutID: TEdit;
    Label2: TLabel;
    cmbbxCustomerName: TComboBox;
    procedure btnQueryClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  FrmQueryOut: TFrmQueryOut;

implementation

uses UnitDM;

{$R *.dfm}

procedure TFrmQueryOut.btnQueryClick(Sender: TObject);
begin
  ADOStoredProc1.Connection:=DataModule2.ADOConnection1;
  ADOStoredProc1.Close;
  ADOStoredProc1.ProcedureName:='QueryOut';
  ADOStoredProc1.Parameters.Refresh;

  ADOStoredProc1.Parameters.ParamByName('@OutPlace').Value:=self.cmbbxOutDepartment.Text;
  ADOStoredProc1.Parameters.ParamByName('@OutID').Value:=self.edtOutID.Text;
  ADOStoredProc1.Parameters.ParamByName('@UseDepartment').Value:=self.cmbbxUserDepartment.Text;
  ADOStoredProc1.Parameters.ParamByName('@OutMan').Value:=self.edtOutMan.Text;
  ADOStoredProc1.Parameters.ParamByName('@Sign').Value:=self.edtSign.Text;
  ADOStoredProc1.Parameters.ParamByName('@CustomerName').Value:=self.cmbbxCustomerName.Text;

  ADOStoredProc1.ExecProc;
  ADOStoredProc1.Active:=true;
end;

end.