sqlserver代码:BCB6.0连接SQL Server2000代码



/*database devlop with bcb6.0
config :
database: sql server 2000
link方式: ODBC+BDE+DatabaseControl控件
chinanetboy
*/
//介绍说明:borland C builder6.0 建立个简单数据库应用代码和文件组织
/*.cpp
// 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
*/
//--------------------------------------------------------------------
# <vcl.h>
#pragma hdrstop

# "Main.h"
# "DepManage.h"
# "DepInfo.h"
# "PeopleManage.h"
# "PeopleQuery.h"
# "SalaryManage.h"
# "Taxinfo.h"
# "SalaryHis.h"
# "Prize.h"
# "Punish.h"

//--------------------------------------------------------------------
#pragma package(smart_init)
#pragma resource "*.dfm"
TfmMain *fmMain;
//
//--------------------------------------------------------------------
__fastcall TfmMain::TfmMain(TComponent* Owner)
: TForm(Owner)
{ }
//--------------------------------------------------------------------
TForm* TfmMain::FormExist(AnsiString szCaption)
{
for( i=0; i<this->MDIChildCount; i)
{
TForm *pForm = this->MDIChildren[i];
(pForm->Caption szCaption)
pForm; // 已存在窗体,返回该窗体
}
NULL; // 不存在窗体,返回空值
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuDepManageClick(TObject *Sender)
{
// 显示机构设置及编码窗体
TForm *pForm = FormExist("机构设置");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmDepManage(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuDepInfoClick(TObject *Sender)
{
// 显示机构详细信息窗体
TForm *pForm = FormExist("机构详细信息");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmDepInfo(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuPeopleManageClick(TObject *Sender)
{
// 显示职员信息维护窗体
TForm *pForm = FormExist("职员信息管理");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmPeopleManage(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuPeopleQueryClick(TObject *Sender)
{
// 显示职员信息查询窗体
TForm *pForm = FormExist("职员信息查询");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmPeopleQuery(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuSalaryManageClick(TObject *Sender)
{
// 显示当月工资管理窗体
TForm *pForm = FormExist("当月工资管理");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmSalaryManage(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuTaxInfoClick(TObject *Sender)
{
// 显示个人所得税率窗体
TForm *pForm = FormExist("个人所得税率");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmTaxInfo(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuSalaryHisClick(TObject *Sender)
{
// 显示工资发放历史窗体
TForm *pForm = FormExist("工资发放历史");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmSalaryHis(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuPrizeClick(TObject *Sender)
{
// 显示职员奖励管理窗体
TForm *pForm = FormExist("职员奖励管理");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmPrize(Application);
pForm->Show;
}
//--------------------------------------------------------------------
void __fastcall TfmMain::mnuPunishClick(TObject *Sender)
{
// 显示职员惩罚管理窗体
TForm *pForm = FormExist("职员惩罚管理");
// 如果已存在则激活否则新建个字窗体
(pForm)
pForm->SetFocus;

pForm = TfmPunish(Application);
pForm->Show;
}
//--------------------------------------------------------------------
Tags:  sqlserver2000教程 sqlserver2000 bcb6.0 sqlserver代码

延伸阅读

最新评论

发表评论