unit frm_classU;

interface

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

type
  Tfrm_class = class(Tfrm_info)
    edt_name: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    cbx_class: TComboBox;
    procedure btn_addClick(Sender: TObject);
    procedure cbx_classChange(Sender: TObject);
    procedure btn_delClick(Sender: TObject);
    procedure btn_editClick(Sender: TObject);
    procedure DBGrid_infoCellClick(Column: TColumn);
  private
    { Private declarations }
  public
    procedure FillData;override;
    procedure FillCbx;//填充combobox
  end;

var
  frm_class: Tfrm_class;

implementation

{$R *.dfm}
procedure Tfrm_class.FillData;
begin
  DataSource_info.DataSet:=Control_classU.GetclassesArray;
  self.DBGrid_info.Columns[0].Visible  :=false;
  self.DBGrid_info.Columns[2].Visible  :=false;
  self.FillCbx;
end;
procedure Tfrm_class.FillCbx;
var
  query:TADOQuery;
begin
  query:=TADOQuery.Create(nil);
  query:=Control_classU.GetclassesArray;
  self.cbx_class.Items.Clear;
  cbx_class.Items.Add('本校');
  cbx_class.Tag:=0;
  while not query.Eof do
    begin
      self.cbx_class.Items.Add(query.Fields[1].Value );
      query.Next;
    end;
  cbx_class.ItemIndex:=0;
  query:=nil;
end;
procedure Tfrm_class.btn_addClick(Sender: TObject);
var
  Classes:TClasses;
  fatherID:integer;
begin
  inherited;
     if((edt_Name.Text='')) then
        begin
           MessageBox(Handle, '內(nèi)容填寫不正確！', '信息', MB_ICONEXCLAMATION);
           exit;
        end;
       //查找是否存在重復(fù)
      if (GetclassesByName(trim(edt_name.Text)))<>nil then
        begin
          MessageBox(Handle, '該院系已經(jīng)存在,請(qǐng)重新設(shè)置！', '信息', MB_ICONEXCLAMATION);
          exit;
        end;
      classes:=Tclasses.Create;
      classes.id:=edt_name.Tag;
      classes.className:=edt_name.Text;
      classes.fatherID:=self.cbx_class.Tag;

      if(Control_classU.Addclasses(classes)) then
        begin
          MessageBox(Handle, '添加成功！', '信息', MB_ICONASTERISK);
          self.edt_name.Tag:=0;
          self.edt_name.Text:='';
          self.cbx_class.ItemIndex:=0;

          //刷新內(nèi)容
          FillData;
        end
      else
        begin
          MessageBox(Handle, '添加失敗！', '信息', MB_ICONEXCLAMATION);
          exit;
        end;
end;

procedure Tfrm_class.cbx_classChange(Sender: TObject);
var
  Classes:TClasses;
begin
  inherited;
  Classes:=TClasses.Create;
  Classes:=GetclassesByName(self.cbx_class.Text);
  if Classes<>nil then
    self.cbx_class.Tag:=Classes.id;
end;

procedure Tfrm_class.btn_delClick(Sender: TObject);
var
  Classes:TClasses;
begin
  inherited;
  if MessageBox(Handle, '您確定要?jiǎng)h除該院系班級(jí)信息', '信息',
     MB_ICONQUESTION or MB_OKCANCEL) = IDOK then
    begin
      Control_ClassU.DelClasses(self.edt_name.Tag);
      FillData;
      if self.DBGrid_info.Fields[0].IsNull then
        exit;
      self.edt_name.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
      self.edt_name.Text :=self.DBGrid_info.Fields[1].Value;
      self.cbx_class.Tag:=self.DBGrid_info.Fields[2].Value;
      self.cbx_class.Text:=self.DBGrid_info.Fields[3].Value;
    end;
end;

procedure Tfrm_class.btn_editClick(Sender: TObject);
var
  Classes:TClasses;
begin
inherited;
  if edt_name.Text ='' then
    begin
       MessageBox(Handle, '沒有可以修改的數(shù)據(jù)！', '信息', MB_ICONEXCLAMATION);
      exit;
    end;
  //查找是否存在重復(fù)
  Classes:=TClasses.Create;
  Classes:=GetclassesByName(trim(edt_name.Text));
  if(Classes<>nil) then
    begin
      if(Classes.id<>edt_name.Tag) then
        begin
          MessageBox(Handle, '該院系班級(jí)已經(jīng)存在,請(qǐng)重新設(shè)置！', '信息', MB_ICONEXCLAMATION);
          exit;
        end;
    end;
  Classes:=TClasses.Create;
  Classes.id:=edt_name.Tag;
  Classes.className:=edt_name.Text;
  Classes.fatherID:=self.cbx_class.Tag;
  if(Control_ClassU.EditClasses(Classes)) then
    begin
      MessageBox(Handle, '修改成功！', '信息', MB_ICONASTERISK);
      //刷新內(nèi)容
      FillData;
    end
  else
     begin
      MessageBox(Handle, '修改失敗！', '信息', MB_ICONEXCLAMATION);
      exit;
     end;
  self.edt_name.SetFocus;
end;

procedure Tfrm_class.DBGrid_infoCellClick(Column: TColumn);
begin
  inherited;
self.edt_name.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
self.edt_name.Text :=self.DBGrid_info.Fields[1].Value;
self.cbx_class.Tag:=self.DBGrid_info.Fields[2].Value;
self.cbx_class.Text:=self.DBGrid_info.Fields[3].Value;
end;

end.