unit ClassSet_Unit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DictionaryBase_Unit, StdCtrls, Buttons, DBCtrls, Mask, Grids,
  DBGrids, ExtCtrls, DB, Menus, StdActns, ActnList;

type
  TfrmClassSet = class(TfrmDictionaryBase)
    Label4: TLabel;
    DataClass: TDataSource;
    DataGradeID: TDataSource;
    cmbxCollege: TDBLookupComboBox;
    DataSource1: TDataSource;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure btnAddClick(Sender: TObject);
    procedure btnDelClick(Sender: TObject);
    procedure btnSaveClick(Sender: TObject);
    procedure btnModifyClick(Sender: TObject);
    procedure btnCancelClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmClassSet: TfrmClassSet;

implementation
uses
  Common_Unit, DM_Unit;
{$R *.dfm}

procedure TfrmClassSet.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
  frmClassSet := nil;
end;

procedure TfrmClassSet.FormCreate(Sender: TObject);
var
  SQLClass, SQLGradeID: string;
begin
  inherited;
  SQLClass := 'Select * From ClassInfo';
  DataClass.DataSet := SQLDataSet(SQLClass,DM.ADOConn);   //連接數據庫

  SQLGradeID := 'Select * From GradeInfo';
  DataGradeID.DataSet := SQLDataSet(SQLGradeID,DM.ADOConn);
end;

procedure TfrmClassSet.btnAddClick(Sender: TObject);
var
  SQLMaxID, MaxID: string;
begin
  inherited;
  DataClass.DataSet.Insert;
  SQLMaxID := 'SELECT Max(ClassID) as ClassID FROM ClassInfo';    //搜索最大的編號
  MaxID := SQLDataSet(SQLMaxID,DM.ADOConn).FieldByName('ClassID').AsString;
  if MaxID = '' then
    MaxID := MaxID + '2007001'
  else
    MaxID := IntToStr(StrToInt(MaxID) + 1 );
  txtID.Caption := MaxID;
  DataClass.DataSet.FieldByName('ClassID').AsString := MaxID;
end;

procedure TfrmClassSet.btnDelClick(Sender: TObject);
begin
  inherited;
  if Application.MessageBox('確定要刪除此條記錄?','提示',68) = IDNo then
    Exit;
  DataClass.DataSet.Delete;
end;

procedure TfrmClassSet.btnSaveClick(Sender: TObject);
begin
  inherited;
  if DataClass.State in [dsInsert,dsEdit] then          //判斷狀態,只有在添加或是修改的時候才能保存信息
    DataClass.DataSet.Post;
end;

procedure TfrmClassSet.btnModifyClick(Sender: TObject);
begin
  inherited;
  DataClass.DataSet.Edit;
end;

procedure TfrmClassSet.btnCancelClick(Sender: TObject);
begin
  inherited;
  DataClass.DataSet.Cancel;
end;

end.