unit4.pas

来自「一个学生管理系统 这是我将自己sql2000版的东东转为access数据库的简」· PAS 代码 · 共 79 行

unit Unit4;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, TFlatEditUnit, TFlatSpeedButtonUnit;

type
  Tsskxxll = class(TForm)
    Label1: TLabel;
    FlatSpeedButton1: TFlatSpeedButton;
    FlatEdit1: TFlatEdit;
    FlatEdit2: TFlatEdit;
    FlatEdit3: TFlatEdit;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    procedure FlatSpeedButton1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FlatEdit3KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  sskxxll: Tsskxxll;

implementation

{$R *.dfm}uses datamodule, Unit10;


procedure Tsskxxll.FlatSpeedButton1Click(Sender: TObject);
var j, i: integer;
  lh,lcs, fjs: string;
  fjh: string;
begin
  lh:=flatedit1.text;
  lcs:= flatedit2.Text;
  fjs:= flatedit3.Text;
  for j := 1 to strtoint(lcs) do
  begin
    for i := 1 to strtoint(fjs) do
    begin
      fjh := Format('%d', [j * 100 + i]);
      with dm.ADOQuery2 do
      begin
          close;
          sql.Clear;
          sql.Add('insert into sskxx (sslh,ssh) values ('''+lh+''','+fjh+')');
          execsql;
      end;
      dm.ADOQuery2.Close;
      
    end;
  end;
  showmessage('添加新宿舍入库成功，按确定返回');
end;


procedure Tsskxxll.FormClose(Sender: TObject; var Action: TCloseAction);
begin
sjcz.close;
end;

procedure Tsskxxll.FlatEdit3KeyPress(Sender: TObject; var Key: Char);
begin
if key=#13 then
begin
key:=#0;
flatspeedbutton1.Click;
end;
end;

end.