unitsetupyear.pas.~12~

来自「初中成绩录入系统网络版(firebird) firebird下的网络编程」· ~12~ 代码 · 共 48 行

unit unitSetupYear;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, Spin;

type
  TfmSetupYear = class(TForm)
    Label1: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    SpinEdit1: TSpinEdit;
    procedure BitBtn1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  fmSetupYear: TfmSetupYear;

implementation

uses unitDatamodule, UnitGlobal;

{$R *.dfm}

procedure TfmSetupYear.FormShow(Sender: TObject);
begin
  SpinEdit1.Text:=CurYear;//当前年度
end;

procedure TfmSetupYear.BitBtn1Click(Sender: TObject);
begin
  dm.Trans1.Active:=false;
  dm.Query1.Close;
  dm.Query1.SQL.Text:='update other set oth_string='''+SpinEdit1.Text+
    ''' where oth_name=''CurYear''';
  dm.Query1.ExecSQL;
  dm.Trans1.Commit;
end;

end.