【正文】 OnAppend() {CUserEdit useredit。if (() == IDOK){()。(UserName,(_bstr_t))。(PassWord,(_bstr_t))。()。UpdateGrid()。}}void CUserManage::OnEdit() 24 / 38{int pos = ()。if (pos != 1){CUserEdit useredit。int no = (())。(no1)。 = (char *)(_bstr_t)()Item[LUserName]Value。if (() == IDOK){(UserName,(_bstr_t))。()。UpdateGrid()。}}}void CUserManage::OnDelete() {int pos = ()。if (pos != 1){CString name = (pos,0)。if (name != mr){if (MessageBox(是否刪除此記錄！,提示,MB_YESNO|MB_ICONWARNING) == IDYES){int no = (())。(no1)。()。()。UpdateGrid()。}}else{25 / 38MessageBox(該用戶不能刪除！)。return。}}}void CDeptManage::UpdateDept(){()。GetNode(TVI_ROOT,0)。}void CDeptManage::GetNode(HTREEITEM pNode,int nPid){HTREEITEM node。CADODataSet DataSet。(::GetConnection())。CString str。(Select * From tab_Dept where pid = %d,nPid)。(str)。int count = ()。int ID。_variant_t value。for (int i = 0。icount。i++){node = ((_bstr_t)()Item[DeptName]Value,pNode)。value = (_variant_t)()Item[ID]Value。ID = 。(node,ID)。GetNode(node,ID)。()。}}void CDeptManage::OnAdd() 26 / 38{CDeptEdit deptedit。if (() == IDOK){HTREEITEM pNode = ()。int pID。if ()pID = 0。elsepID = (pNode)。CADODataSet dataset。(::GetConnection())。(Select top 1 * From tab_Dept)。()。(DeptName,(_variant_t))。(memo,(_variant_t))。(PID,(long)pID)。()。UpdateDept()。}}void CDeptManage::OnEdit() {CDeptEdit deptedit。 = false。HTREEITEM pNode = ()。if (pNode == 0)return。int pID = (pNode)。CADODataSet dataset。(::GetConnection())。CString str。27 / 38(Select * From tab_Dept where id = %d,pID)。(str)。 = (char *)(_bstr_t)()Item[LDeptName]Value。 = (char *)(_bstr_t)()Item[memo]Value。if (() == IDOK){(DeptName,(_variant_t))。(memo,(_variant_t))。()。UpdateDept()。}void CDeptManage::OnDelete() {HTREEITEM pNode = ()。if (pNode == 0)return。if (MessageBox(是否刪除此記錄！,提示,MB_YESNO|MB_ICONWARNING) == IDYES){int pID = (pNode)。CADODataSet dataset。(::GetConnection())。CString str。(Select * From tab_Dept where id = %d,pID)。(str)。()。()。UpdateDept()。}}void CDeptManage::GetNode(HTREEITEM pNode,int nPid){HTREEITEM node。CADODataSet DataSet。(::GetConnection())。CString str。28 / 38(Select * From tab_Dept where pid = %d,nPid)。(str)。int count = ()。int ID。_variant_t value。for (int i = 0。icount。i++){value = (_variant_t)()Item[ID]Value。ID = 。(node,ID)。GetNode(node,ID)。()。}}void CPersonManage::UpdatePerson(){()。CADODataSet DataSet。(::GetConnection())。CString str。if (m_DeptID == 1)(Select * From tab_Employees)。else(Select * From tab_Employees where Dept = %d,m_DeptID)。(str)。int count = ()。int n = 0。_variant_t value。for (int i = 0。icount。i++){int index = 1。(n,(_bstr_t)()Item[Emp_Id]Value)。value = ()Item[AutoID]Value。(n,)。29 / 38}}void CPersonManage::OnAdd() {CPersonEdit personedit。 = m_DeptID。if (() == IDOK){CADODataSet dataset。(::GetConnection())。CString str = select top 1 * from tab_Employees。(str)。()。()。UpdatePerson()。}}void CPersonManage::OnEdit() {if (() == 1)return。int id = (())。CPersonEdit personedit。CADODataSet dataset。(::GetConnection())。CString str。(select * from tab_Employees where autoid = %d,id)。(str)。void CPersonManage::OnDelete() {if (MessageBox(是否刪除此記錄！,提示,MB_YESNO|MB_ICONWARNING) == IDYES){if (() == 1)30 / 38return。int id = (())。CADODataSet dataset。(::GetConnection())。CString str。(select * from tab_Employees where autoid = %d,id)。(str)。()。()。UpdatePerson()。}}void CCheckManage::UpdateList(){thisUpdateData()。CString str。if (m_check)(Select * From tab_Check)。else{CString Starttime,EndTime。Starttime = m_yy + + m_mm + 1 。(DATEADD(month,1,39。%s39。),Starttime)。}CADODataSet dataset。(::GetConnection())。(str)。()。for (int i = 0 。 i () 。 i++){int n = 0。long data = ()Item[autoid]Value。(i,)。(i,data)。31 / 38()。}}void CCheckManage::OnAdd() {CCheckEdit checkedit。if (() == IDOK){CString time。CString str = Select top 1 * From tab_Check。CADODataSet dataset。(::GetConnection())。(str)。()。(name,(_bstr_t))。CTime latetime = DecTime(,)。(%d:%d:%d,(),(),ond())。(latetime,(_bstr_t)time)。CTime leaveearly = DecTime(,)。(%d:%d:%d,(),(),leaveearly.GetSecond())。(leaveearly,(_bstr_t)time)。()。UpdateList()。}}void CCheckManage::OnEdit() {if (() == 1)return。int id = (())。CCheckEdit checkedit。32 / 38CString str。(Select * From tab_Check where autoid = %d,id)。CADODataSet dataset。(::GetConnection())。(str)。 = (char *)(_bstr_t)()Item[name]Value。 = GetTimeForStr((char *)(_bstr_t)()Item[ondutytime]Value)。if (() == IDOK){CString time。CTime leaveearly = DecTime(,)。(%d:%d:%d,(),(),leaveea())。(leaveearly,(_bstr_t)time)。()。UpdateList()。}}void CCheckManage::OnDelete() {if (MessageBox(是否刪除此記錄！,提示,MB_YESNO|MB_ICONWARNING) == IDYES){if (() == 1)return。int id = (())。CADODataSet dataset。(::GetConnection())。CString str。(select * from tab_Check where autoid = %d,id)。(str)。()。33 / 38()。UpdateList()。}}void CCheckSum::UpdateList(){()。thisUpdateData()。CADODataSet dataset。(::GetConnection())。CString str,temp,where,datestr,StartDate,EndDate。StartDate = m_yy + + m_mm + 1 。(DATEADD(month,1,39。%s39。),StartDate)。( between 39。%s39。 and %s,StartDate,EndDate)。temp += select ,ROUND(isnull(,0),2)。sum(DATEPART(second,latetime)))。( where = 39。%s39。,m_emp)。if (m_emp == (全部)) (temp,datestr,datestr,datestr,datestr,datestr,)。else(temp,datestr,datestr,datestr,datestr,datestr,where)。//*/(str,adLockUnspecified)。for (int i = 0。 i () 。 i++){int n = 0。(i,)。()。}//*/}