unit1.pas

小型企业物品管理系统,DELPHI源码+ACCESS数据库

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGridEh, RzButton;

type
  TForm1 = class(TForm)
    con1: TADOConnection;
    con2: TADOConnection;
    DBGridEh1: TDBGridEh;
    DBGridEh2: TDBGridEh;
    qry1: TADOQuery;
    qry2: TADOQuery;
    ds1: TDataSource;
    ds2: TDataSource;
    spinyq: TADOStoredProc;
    RzBitBtn1: TRzBitBtn;
    qry1dq: TWideStringField;
    qry1sm: TWideStringField;
    qry1yb: TWideStringField;
    qry1qh: TWideStringField;
    procedure RzBitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses Unit2;

{$R *.dfm}

procedure TForm1.RzBitBtn1Click(Sender: TObject);
var j:Integer;
begin
  for j:=0 to qry1.RecordCount do begin
    if j=0 then qry1.First
    else
      qry1.Next;
    with spinyq do begin
      Close;
      Parameters.ParamByName('@yqsf').Value:=qry1sm.Value;
      Parameters.ParamByName('@yqdq').Value:=qry1dq.Value;
      Parameters.ParamByName('@yqyb').Value:=qry1yb.Value;
      Parameters.ParamByName('@yqqh').Value:=qry1qh.Value;
      ExecProc;
    end;
    if spinyq.Parameters.ParamByName('@msg').Value=1 then
      Continue;
    qry1.Next;
  end;
  qry2.Close;
  qry2.Open;
end;

end.