frm_companyu.~pas

这是一个毕业生就业管理系统

unit frm_companyU;

interface

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

type
  Tfrm_company = class(Tfrm_info)
    edt_company: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    cbx_type: TComboBox;
    Label3: TLabel;
    edt_address: TEdit;
    Lab_newclass: TLabel;
    edt_linkmanner: TEdit;
    Label9: TLabel;
    Memo_remark: TMemo;
    lab_linkman: TLabel;
    edt_linkman: TEdit;
    Label18: TLabel;
    edt_company_s: TEdit;
    btn_search_company: TButton;
    procedure btn_addClick(Sender: TObject);
    procedure btn_delClick(Sender: TObject);
    procedure btn_editClick(Sender: TObject);
    procedure DBGrid_infoCellClick(Column: TColumn);
    procedure btn_search_companyClick(Sender: TObject);
  private
  public
    procedure FillData;override;
  end;

var
  frm_company: Tfrm_company;

implementation

{$R *.dfm}
procedure Tfrm_company.FillData;
begin
  DataSource_info.DataSet:=Control_CompanyU.GetCompanyArray;
  self.DBGrid_info.Columns[0].Visible  :=false;
end;

procedure Tfrm_company.btn_addClick(Sender: TObject);
var
  Student:TStudent;
  Company:TCompany;
begin
  inherited;
 if((self.edt_company.Text='')) then
        begin
           MessageBox(Handle, '内容填写不正确！', '信息', MB_ICONEXCLAMATION);
           exit;
        end;

    Company:=TCompany.Create;
    Company.company:=self.edt_company.Text;
    Company.companyType:=self.cbx_type.Text;
    Company.address:=self.edt_address.Text;
    Company.linkman:=self.edt_linkman.Text;
    Company.linkManner:=self.edt_linkmanner.Text;
    Company.remark:=self.Memo_remark.Text;

      if(Control_CompanyU.AddCompany(Company)) then
        begin
          MessageBox(Handle, '添加成功！', '信息', MB_ICONASTERISK);
          //刷新内容
          FillData;
        end
      else
        begin
          MessageBox(Handle, '添加失败！', '信息', MB_ICONEXCLAMATION);
          exit;
        end;
end;

procedure Tfrm_company.btn_delClick(Sender: TObject);
begin
  inherited;
  if MessageBox(Handle, '您确定要删除该条信息', '信息',
     MB_ICONQUESTION or MB_OKCANCEL) = IDOK then
    begin
      Control_CompanyU.DelCompany(self.edt_company.Tag);
      FillData;
      if self.DBGrid_info.Fields[0].IsNull then
        exit;
      self.edt_company.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
      self.edt_company.Text:=self.DBGrid_info.Fields[1].Value;
      self.cbx_type.Text:=self.DBGrid_info.Fields[2].Value;
      self.edt_address.Text:=self.DBGrid_info.Fields[3].Value;
      self.edt_linkman.Text:=self.DBGrid_info.Fields[4].Value;
      self.edt_linkmanner.Text:=self.DBGrid_info.Fields[5].Value;
      self.Memo_remark.Text:=self.DBGrid_info.Fields[6].Value;
    end;
end;

procedure Tfrm_company.btn_editClick(Sender: TObject);
var
  Company:TCompany;
  Student:TStudent;
  typeStr:string;
begin
inherited;
  if edt_company.Text ='' then
    begin
      MessageBox(Handle, '没有可以修改的数据！', '信息', MB_ICONEXCLAMATION);
      exit;
    end
  else
    begin
      if((edt_company.Text='')) then
    begin
       MessageBox(Handle, '内容填写不正确！', '信息', MB_ICONEXCLAMATION);
       exit;
    end;

    Company:=TCompany.Create;
    Company.id:=self.edt_company.Tag;
    Company.company:=self.edt_company.Text;
    Company.companyType:=self.cbx_type.Text;
    Company.address:=self.edt_address.Text;
    Company.linkman:=self.edt_linkman.Text;
    Company.linkManner:=self.edt_linkmanner.Text;
    Company.remark:=self.Memo_remark.Text;

  if(Control_CompanyU.EditCompany(Company)) then
    begin
      MessageBox(Handle, '修改成功！', '信息', MB_ICONASTERISK);
      //刷新内容
      FillData;
    end
  else
     begin
      MessageBox(Handle, '修改失败！', '信息', MB_ICONEXCLAMATION);
      exit;
     end;
      self.edt_company.SetFocus;
  end;
end;

procedure Tfrm_company.DBGrid_infoCellClick(Column: TColumn);

begin
  inherited;
if self.DBGrid_info.Fields[0].IsNull then
    exit;

      self.edt_company.Tag:=self.DBGrid_info.Fields[0].Value;//保存id
      self.edt_company.Text:=self.DBGrid_info.Fields[1].Value;
      self.cbx_type.Text:=self.DBGrid_info.Fields[2].Value;
      self.edt_address.Text:=self.DBGrid_info.Fields[3].Value;
      self.edt_linkman.Text:=self.DBGrid_info.Fields[4].Value;
      self.edt_linkmanner.Text:=self.DBGrid_info.Fields[5].Value;
      self.Memo_remark.Text:=self.DBGrid_info.Fields[6].Value;
end;

procedure Tfrm_company.btn_search_companyClick(Sender: TObject);
begin
  inherited;
  if self.edt_company_s.Text='' then
    DataSource_info.DataSet:=Control_CompanyU.GetCompanyArray
  else
    DataSource_info.DataSet:=GetCompanyQueryByCompany(self.edt_company_s.Text);
  self.DBGrid_info.Columns[0].Visible  :=false;
end;

end.