BCB6.0连接SQLServer2000代码
来源:优易学  2011-12-2 10:06:46   【优易学:中国教育考试门户网】   资料下载   IT书店
  /*database devlop with bcb6.0
  config :
  database: sql server 2000
  link方式: ODBC+BDE+Database控件
  chinanetboy
  */
  //说明:borland C++ builder6.0 建立一个简单的数据库应用代码与文件组织
  /*main.cpp
  //main project
  Hrm.bpr
  //all form file
  Main.dfm,db.dfm
  DepInfo.dfm,DepManage.dfm,PeopleManage.dfm,PeopleQuery.dfm,
  Prize.dfm,Punish.dfm,SalaryHis.dfm,SalaryManage.dfm,TaxInfo.dfm
  //all head file
  Main.h,db.h
  DepInfo.h,DepManage.h,PeopleManage.h,PeopleQuery.h,
  Prize.h,Punish.h,SalaryHis.h,SalaryManage.h,TaxInfo.h
  //all cpp file
  Main.cpp,db.cpp
  DepInfo.cpp,DepManage.cpp,PeopleManage.cpp,PeopleQuery.cpp
  ,Prize.cpp,Punish.cpp,SalaryHis.cpp,SalaryManage.cpp,TaxInfo.cpp
  */
  #include <vcl.h>
  #pragma hdrstop
  #include "Main.h"
  #include "DepManage.h"
  #include "DepInfo.h"
  #include "PeopleManage.h"
  #include "PeopleQuery.h"
  #include "SalaryManage.h"
  #include "Taxinfo.h"
  #include "SalaryHis.h"
  #include "Prize.h"
  #include "Punish.h"
  #pragma package(smart_init)
  #pragma resource "*.dfm"
  TfmMain *fmMain;
  //
  __fastcall TfmMain::TfmMain(TComponent* Owner)
  : TForm(Owner)
  { }
  TForm* TfmMain::FormExist(AnsiString szCaption)
  {
  for(int i=0; i<this->MDIChildCount; i++)
  {
  TForm *pForm = this->MDIChildren[i];
  if(pForm->Caption == szCaption)
  return pForm; // 已存在窗体,返回该窗体
  }
  return NULL; // 不存在窗体,返回空值
  }
  void __fastcall TfmMain::mnuDepManageClick(TObject *Sender)
  {
  // 显示机构设置及编码窗体
  TForm *pForm = FormExist("机构设置");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmDepManage(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuDepInfoClick(TObject *Sender)
  {
  // 显示机构详细信息窗体
  TForm *pForm = FormExist("机构详细信息");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmDepInfo(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuPeopleManageClick(TObject *Sender)
  {
  // 显示职员信息维护窗体
  TForm *pForm = FormExist("职员信息管理");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmPeopleManage(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuPeopleQueryClick(TObject *Sender)
  {
  // 显示职员信息查询窗体
  TForm *pForm = FormExist("职员信息查询");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmPeopleQuery(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuSalaryManageClick(TObject *Sender)
  {
  // 显示当月工资管理窗体
  TForm *pForm = FormExist("当月工资管理");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmSalaryManage(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuTaxInfoClick(TObject *Sender)
  {
  // 显示个人所得税率窗体
  TForm *pForm = FormExist("个人所得税率");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmTaxInfo(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuSalaryHisClick(TObject *Sender)
  {
  // 显示工资发放历史窗体
  TForm *pForm = FormExist("工资发放历史");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmSalaryHis(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuPrizeClick(TObject *Sender)
  {
  // 显示职员奖励管理窗体
  TForm *pForm = FormExist("职员奖励管理");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmPrize(Application);
  pForm->Show();
  }
  void __fastcall TfmMain::mnuPunishClick(TObject *Sender)
  {
  // 显示职员惩罚管理窗体
  TForm *pForm = FormExist("职员惩罚管理");
  // 如果已存在则激活,否则新建一个字窗体
  if(pForm)
  pForm->SetFocus();
  else
  pForm = new TfmPunish(Application);
  pForm->Show();
  }

责任编辑:小草

文章搜索:
 相关文章
热点资讯
热门课程培训