SQLserver數(shù)據(jù)庫(kù)課程設(shè)計(jì)報(bào)告

.10/10淮海工學(xué)院計(jì)算機(jī)工程學(xué)院課程設(shè)計(jì)報(bào)告設(shè)計(jì)名稱：數(shù)據(jù)庫(kù)課程設(shè)計(jì)姓名：學(xué)號(hào)：專業(yè)班級(jí)：網(wǎng)絡(luò)121系院：計(jì)算機(jī)工程學(xué)院設(shè)計(jì)時(shí)間：2014.6.15設(shè)計(jì)地點(diǎn)：機(jī)房、宿舍、文通樓、圖書(shū)館成績(jī)：指導(dǎo)教師評(píng)語(yǔ)：成績(jī)：簽名：年月日.需求分析目前,大多數(shù)文檔管理系統(tǒng)在實(shí)現(xiàn)了企業(yè)各部門(mén)日常文件管理的基本功能外,還增設(shè)了很多的新功能用以滿足文檔管理電子化、標(biāo)準(zhǔn)化的新要求,功能強(qiáng)大的檔案查詢模塊大大方便了管理者日常查找文檔的工作,解決了傳統(tǒng)管理中查找困難、查找耗時(shí)間等問(wèn)題。使用現(xiàn)代化的文檔管理系統(tǒng)滿足了企業(yè)"無(wú)紙化"的辦公要求,實(shí)現(xiàn)了通過(guò)計(jì)算機(jī)對(duì)文檔管理全程跟蹤的要求。概念結(jié)構(gòu)設(shè)計(jì)1.系統(tǒng)功能結(jié)構(gòu)文檔管理文檔管理系統(tǒng)系統(tǒng)設(shè)置基本信息文檔管理數(shù)據(jù)庫(kù)管理用戶管理口令修改退出系統(tǒng)單位檔案文檔類(lèi)別添加文檔修改文檔刪除文檔文檔瀏覽查看屬性數(shù)據(jù)庫(kù)備份數(shù)據(jù)庫(kù)還原日志管理2.業(yè)務(wù)流程圖管理人員管理人員數(shù)據(jù)庫(kù)管理文檔管理信息數(shù)據(jù)庫(kù)備份數(shù)據(jù)庫(kù)還原添加文檔修改文檔集刪除文檔集物理結(jié)構(gòu)設(shè)計(jì)系統(tǒng)表文檔表單位表文檔表用戶表應(yīng)用系統(tǒng)實(shí)現(xiàn)與測(cè)試登陸界面系統(tǒng)界面文檔基本信息日志管理文檔基本信息文檔類(lèi)別單位列表五、部分代碼//ADO.cpp:implementationoftheCADOclass.////////////////////////////////////////////////////////////////////////#include"stdafx.h"#include"ADO.h"#include<comdef.h>#ifdef_DEBUG#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;#definenewDEBUG_NEW#endif////////////////////////////////////////////////////////////////////////Construction/Destruction//////////////////////////////////////////////////////////////////////intConCount=0;CADOConnectiong_Connection;//全局?jǐn)?shù)據(jù)庫(kù)連接對(duì)象CADOConnection*GetConnection<>{ return&g_Connection;}CADOConnection::CADOConnection<>{ InitADO<>; m_Connection.CreateInstance<"ADODB.Connection">;}CADOConnection::~CADOConnection<>{ if<IsOpen<>> m_Connection->Close<>; m_Connection=NULL; UnInitADO<>;}voidCADOConnection::InitADO<>{ if<ConCount++==0> CoInitialize<NULL>;};voidCADOConnection::UnInitADO<>{ if<--ConCount==0> CoUninitialize<>;};BOOLCADOConnection::Open<CStringConStr>{ if<IsOpen<>> m_Connection->Close<>; m_Connection->Open<<_bstr_t>ConStr,"","",adModeUnknown>; returnIsOpen<>;}CStringCADOConnection::GetSQLConStr<CStringIP,CStringDBName>{ CStringStr; Str.Format<"Provider=SQLOLEDB.1;PersistSecurityInfo=False;UserID=sa;InitialCatalog=%s;DataSource=%s",DBName,IP>; returnStr;}_ConnectionPtrCADOConnection::GetConnection<>{ returnm_Connection;}BOOLCADOConnection::IsOpen<>{ longState; m_Connection->get_State<&State>; if<State==adStateOpen> returntrue; returnfalse;}////////////////////////////////////////CADODataSet::CADODataSet<>{ m_DataSet.CreateInstance<"ADODB.Recordset">;}CADODataSet::~CADODataSet<>{ if<IsOpen<>> m_DataSet->Close<>; m_DataSet=NULL; m_Connection=NULL;}voidCADODataSet::SetConnection<CADOConnection*pCon>{ m_Connection=pCon;}intCADODataSet::GetRecordCount<>{ if<IsOpen<>> returnm_DataSet->GetRecordCount<>; else return0;}BOOLCADODataSet::Open<CStringSQLStr>{ if<IsOpen<>> m_DataSet->Close<>; //*/ m_DataSet->Open<_bstr_t<SQLStr>, _variant_t<<IDispatch*>g_Connection.GetConnection<>,true>, adOpenKeyset,adLockOptimistic,adCmdText>; returnIsOpen<>; //*/}BOOLCADODataSet::IsOpen<>{ longState; m_DataSet->get_State<&State>; if<State==adStateOpen> returntrue; returnfalse;}FieldsPtrCADODataSet::GetFields<>{ returnm_DataSet->GetFields<>;}BOOLCADODataSet::Next<>{ if<m_DataSet->adoEOF> returnfalse; m_DataSet->MoveNext<>; returntrue;}voidCADODataSet::AddNew<>{ m_DataSet->AddNew<>;}voidCADODataSet::SetFieldValue<CStringFieldName,_variant_tValue>{ m_DataSet->PutCollect<<_bstr_t>FieldName,Value>;}voidCADODataSet::Save<>{ m_DataSet->Update<>;}voidCADODataSet::move<intnIndex>{ m_DataSet->MoveFirst<>; m_DataSet->Move<nIndex>;}intCADODataSet::GetRecordNo<>{ returnm_DataSet->AbsolutePosition;}voidCADODataSet::Delete<>{ m_DataSet->Delete<adAffectCurrent>;}BOOLCADODataSet::Open<CStringSQLStr,intLockType>{ if<IsOpen<>> m_DataSet->Close<>; //*/ m_DataSet->Open<_bstr_t<SQLStr>, _variant_t<<IDispatch*>g_Connection.GetConnection<>,true>, adOpenKeyset,<LockTypeEnum>LockType,adCmdText>; returnIsOpen<>;}/CheckSum.cpp:implementationfile//#include"stdafx.h"#include"Person.h"#include"CheckSum.h"#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;#endif///////////////////////////////////////////////////////////////////////////////CCheckSumdialogCCheckSum::CCheckSum<CWnd*pParent/*=NULL*/> :CDialog<CCheckSum::IDD,pParent>{ //{{AFX_DATA_INIT<CCheckSum> m_emp=_T<"">; m_mm=_T<"">; m_yy=_T<"">; //}}AFX_DATA_INIT}voidCCheckSum::DoDataExchange<CDataExchange*pDX>{ CDialog::DoDataExchange<pDX>; //{{AFX_DATA_MAP<CCheckSum> DDX_Control<pDX,IDC_LISTEMP,m_list>; DDX_Control<pDX,IDC_CYY,m_cyy>; DDX_Control<pDX,IDC_CMM,m_cmm>; DDX_Control<pDX,IDC_CEMP,m_cemp>; DDX_CBString<pDX,IDC_CEMP,m_emp>; DDX_CBString<pDX,IDC_CMM,m_mm>; DDX_CBString<pDX,IDC_CYY,m_yy>; //}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP<CCheckSum,CDialog> //{{AFX_MSG_MAP<CCheckSum> ON_CBN_CLOSEUP<IDC_CEMP,OnCloseupCemp> ON_CBN_CLOSEUP<IDC_CYY,OnCloseupCyy> ON_CBN_CLOSEUP<IDC_CMM,OnCloseupCmm> //}}AFX_MSG_MAPEND_MESSAGE_MAP<>///////////////////////////////////////////////////////////////////////////////CCheckSummessagehandlersBOOLCCheckSum::OnInitDialog<>{ CDialog::OnInitDialog<>; inti=0; m_list.InsertColumn<i,"人員姓名">; m_list.SetColumnWidth<i++,100>; m_list.InsertColumn<i,"工作總天數(shù)">; m_list.SetColumnWidth<i++,100>; m_list.InsertColumn<i,"遲到總天數(shù)">; m_list.SetColumnWidth<i++,100>; m_list.InsertColumn<i,"早退總天數(shù)">; m_list.SetColumnWidth<i++,100>; m_list.InsertColumn<i,"病假總天數(shù)">; m_list.SetColumnWidth<i++,100>; m_list.InsertColumn<i,"事假總天數(shù)">; m_list.SetColumnWidth<i++,100>; m_list.SetExtendedStyle<LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES>; intcuryear,curmonth; CTimetime<CTime::GetCurrentTime<>>; curyear=time.GetYear<>; curmonth=time.GetMonth<>; charvalue[10]; for<inty=2000;y<2100;y++> { _itoa<y,value,10>; m_cyy.InsertString<y-2000,value>; } m_cyy.SetCurSel<curyear-2000>; for<intn=1;n<=12;n++> { _itoa<n,value,10>; m_cmm.InsertString<n-1,value>; } m_cmm.SetCurSel<curmonth-1>; CADODataSetdataset; dataset.SetConnection<::GetConnection<>>; dataset.Open<"Select*Fromtab_Employees">; m_cemp.InsertString<0,"<全部>">; for<intindex=1;index<=dataset.GetRecordCount<>;index++> { m_cemp.InsertString<index,<_bstr_t>dataset.GetFields<>->Item["emp_name"]->Value>; dataset.Next<>; } m_cemp.SetCurSel<0>; UpdateList<>; returnTRUE;//returnTRUEunlessyousetthefocustoacontrol //EXCEPTION:OCXPropertyPagesshouldreturnFALSE}voidCCheckSum::UpdateList<>{ m_list.DeleteAllItems<>; this->UpdateData<>; CADODataSetdataset; dataset.SetConnection<::GetConnection<>>; CStringstr,temp,where,datestr,StartDate,EndDate; StartDate=m_yy+"-"+m_mm+"-1"; EndDate.Format<"DATEADD<month,1,'%s'>",StartDate>; datestr.Format<"between'%s'and%s",StartDate,EndDate>; //*/ temp+="selectemp.emp_name,ROUND<isnull<works.workday,0>,2>"; temp+="workday,ROUND<isnull<lates.lateday,0>,2>lateday,"; temp+="ROUND<isnull<leaveearlys.leaveearlyday,0>,2>leaveearlyday,"; temp+="ROUND<isnull<bjdays.bjday,0>,2>bjday,ROUND<isnull<sjdays.sjday,0>,2>sjday"; temp+="fromtab_Employeesemp"; temp+="leftjoin"; temp+="<selectsum<DATEDIFF<second,ontime,offtime>>/60.0/60.0/8.0"; temp+="asworkday,nameFromtab_Checkwherecheckdate%sgroupbyname>"; temp+="worksonemp.emp_name="; temp+="leftjoin"; temp+="<select<sum<DATEPART<Hour,latetime>>*60*60+"; temp+="sum<DATEPART<minute,latetime>>*60+sum<DATEPART<second,latetime>>>"; temp+="/60.0/60.0/8.0aslateday,nameFromtab_Checkwherecheckdate"; temp+="%sgroupbyname>latesonemp.emp_name="; temp+="leftjoin"; temp+="<select<sum<DATEPART<Hour,leaveearly>>*60*60+"; temp+="sum<DATEPART<minute,leaveearly>>*60+sum<DATEPART<second,leaveearly>>>"; temp+="/60.0/60.0/8.0asleaveearlyday,nameFromtab_Checkwhere"; temp+="checkdate%sgroupbyname>leaveearlysonemp.emp_name"; temp+="="; temp+="leftjoin"; temp+="<selectisnull<sum<DATEDIFF<second,onleave,offleave>>"; temp+="/60.0/60.0/8.0,0>asbjday,nameFromtab_Checkwhere"; temp+="leave='病假'andcheckdate%sgroupbyname>"; temp+="bjdaysonemp.emp_name="; temp+="leftjoin"; temp+="<selectisnull<sum<DATEDIFF<second,onleave,offleave>>"; temp+="/60.0/60.0/8.0,0>assjday,nameFromtab_Checkwhere"; temp+="leave='事假'andcheckdate%sgroupbyname>"; temp+="sjdaysonemp.emp_name="; temp+="%s";//*/ // where.Format<"whereemp.emp_name='%s'",m_emp>; if<m_emp=="<全部>"> str.Format<temp,datestr,datestr,datestr,datestr,datestr,"">; else str.Format<temp,datestr,datestr,datestr,datestr,datestr,where>; //*/ dataset.Open<str,adLockUnspecified>; for<inti=0;i<dataset.GetRecordCount<>;i++> { intn=0; m_list.InsertItem<i,"">; m_list.SetItemText<i,n++,<_bstr_t>dataset.GetFields<>->Item["emp_name"]->Value>; m_list.SetItemText<i,n++,<_bstr_t>dataset.GetFields<>->Item["workday"]->Value>; m_list.SetItemText<i,n++,<_bstr_t>dat