department.cpp

用c++builder编写的人事管理系统,主要用于公司进行人事管理,工资发放使用.界面简介好用,功能较为简单,本人本科设计时编写

//---------------------------------------------------------------------------

#include <vcl.h>
#pragma hdrstop

#include "Department.h"
#include "db.h"
#include "Main.h"
//---------------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TFormDepartment *FormDepartment;
//---------------------------------------------------------------------------
__fastcall TFormDepartment::TFormDepartment(TComponent* Owner)
        : TForm(Owner)
{
     if(FormMain->manager==0)
       SetButtonEnable(3);
     else
       SetButtonEnable(2);  
}
//---------------------------------------------------------------------------
void __fastcall TFormDepartment::FormClose(TObject *Sender,
      TCloseAction &Action)
{
       Action=caFree;
       FormDepartment=NULL;  
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::FirstClick(TObject *Sender)
{
         DataModule1->Table2->First();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::PriorClick(TObject *Sender)
{
          DataModule1->Table2->Prior();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::NextClick(TObject *Sender)
{
          DataModule1->Table2->Next();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::LastClick(TObject *Sender)
{
          DataModule1->Table2->Last();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::AddClick(TObject *Sender)
{
       SetButtonEnable(1);
      DataModule1->Table2->Append();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::EditClick(TObject *Sender)
{
      SetButtonEnable(1);
    DataModule1->Table2->Edit();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::DeleteClick(TObject *Sender)
{
    if(Application->MessageBoxA("是否删除记录","",MB_YESNO)==IDYES)
     {
          DataModule1->DataSource2->Edit();
          DataModule1->Table2->Delete();
     }
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::SaveClick(TObject *Sender)
{
         DataModule1->Table2->Post();
          SetButtonEnable(2);
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::CancelClick(TObject *Sender)
{
     DataModule1->Table2->Cancel();
          SetButtonEnable(2);
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::ExitClick(TObject *Sender)
{
           this->Close();
}
//---------------------------------------------------------------------------

void __fastcall TFormDepartment::BitBtn1Click(TObject *Sender)
{
        DataModule1->Table2->Active=false;
    DataModule1->Table2->Filter="";
    AnsiString szFilter="";
    if(Edit1->Text.IsEmpty()&&Edit2->Text.IsEmpty())
        {
          MessageBox(NULL,"请输入你的查询条件","信息",MB_OK);
          return;
        }
    if(!Edit1->Text.IsEmpty())
           szFilter+="DNO="+Edit1->Text+" and ";
    if(!Edit2->Text.IsEmpty())
           szFilter+="DName='"+Edit2->Text+"' and ";
    szFilter=szFilter.SubString(1,szFilter.Length()-5);
     DataModule1->Table2->Filter=szFilter;
    DataModule1->Table2->Active=true;
    DataModule1->Table2->Filtered=false;
    DataModule1->Table2->Filtered=true;
}
//---------------------------------------------------------------------------


void TFormDepartment::SetButtonEnable(int nStatus)
{
        //TODO: Add your source code here
        if(nStatus==1)
          {
             //编辑状态
            First->Enabled=false;
            Prior->Enabled=false;
            Next->Enabled=false;
            Last->Enabled=false;
            Add->Enabled=false;
            Edit->Enabled=false;
            Delete->Enabled=false;

            Save->Enabled=true;
            Cancel->Enabled=true;
            Panel1->Enabled=true;

            DBGrid1->Enabled=false;
          }
         if(nStatus==2)
          {
             //浏览状态
            First->Enabled=true;
            Prior->Enabled=true;
            Next->Enabled=true;
            Last->Enabled=true;
            Add->Enabled=true;
            Edit->Enabled=true;
            Delete->Enabled=true;

            Save->Enabled=false;
            Cancel->Enabled=false;
            Panel1->Enabled=false;

            DBGrid1->Enabled=false;
          }
          if(nStatus==3)
          {
             //一般用户权限
            First->Enabled=true;
            Prior->Enabled=true;
            Next->Enabled=true;
            Last->Enabled=true;
            Add->Enabled=false;
            Edit->Enabled=false;
            Delete->Enabled=false;

            Save->Enabled=false;
            Cancel->Enabled=false;
            Panel1->Enabled=false;

            DBGrid1->Enabled=false;
          }


}