📄 bookdialog1.cpp

📁 家族信息管理系统
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12
}
void CBookDialog::CloseDatabase()
{
	if(m_dataRecset != NULL)
	{
		if(m_dataRecset->IsOpen ())
			m_dataRecset->Close ();
		delete m_dataRecset;
		m_dataRecset = NULL;
	}
	closeDatabase(&m_pDB);
	CloseODBCEnvironment(m_szPathName);
}
void CBookDialog::OnDestroy() 
{
	CDialog::OnDestroy();
	
	CloseDatabase()	;
//	delete m_pImageList;
}
void CBookDialog::RefreshData()
{
	CString szTemp;
	szTemp.Empty();
	int nListIndex=0;
   	if(m_dataRecset != NULL)
	{
		//list group
        m_dataRecset->MoveFirst();
		while(!m_dataRecset->IsEOF())
		{
			m_list.InsertItem(nListIndex,LPSTR_TEXTCALLBACK);
			m_list.SetItemText(nListIndex,0,m_dataRecset->m_name);
			m_list.SetItemText(nListIndex,1,m_dataRecset->m_email);
			m_list.SetItemText(nListIndex,2,m_dataRecset->m_oicq);
			m_list.SetItemText(nListIndex,3,m_dataRecset->m_mobile);
			m_list.SetItemText(nListIndex,4,m_dataRecset->m_phone);
			m_list.SetItemText(nListIndex,5,m_dataRecset->m_birthday);
			m_list.SetItemText(nListIndex,6,m_dataRecset->m_workunit);
			m_list.SetItemText(nListIndex,7,m_dataRecset->m_homepage);
			m_list.SetItemText(nListIndex,8,m_dataRecset->m_demo);
			
			nListIndex++;
            m_dataRecset->MoveNext();
		}
		
	}

}

void CBookDialog::OnButtonMember() 
{
  CCreateCardDialog dlg;
   //dlg.DoModal();
   if(dlg.DoModal()==IDOK)
   {
		m_dataRecset->AddNew ();
		m_dataRecset->m_name=dlg.m_name;
		m_dataRecset->m_email=dlg.m_email;
		m_dataRecset->m_oicq=dlg.m_oicq;
		m_dataRecset->m_mobile=dlg.m_mobile;
		m_dataRecset->m_phone=dlg.m_phone;
		m_dataRecset->m_birthday=dlg.m_birthday;
		m_dataRecset->m_workunit=dlg.m_unit;
		m_dataRecset->m_homepage=dlg.m_homepage;
		m_dataRecset->m_demo=dlg.m_demo;
		m_dataRecset->Update ();

		int nListIndex = m_list.GetItemCount();
		m_list.InsertItem(nListIndex,LPSTR_TEXTCALLBACK);
		m_list.SetItemText(nListIndex,0,dlg.m_name);
		m_list.SetItemText(nListIndex,1,dlg.m_email);
		m_list.SetItemText(nListIndex,2,dlg.m_oicq);
		m_list.SetItemText(nListIndex,3,dlg.m_mobile);
		m_list.SetItemText(nListIndex,4,dlg.m_phone);
		m_list.SetItemText(nListIndex,5,dlg.m_birthday);
		m_list.SetItemText(nListIndex,6,dlg.m_unit);
		m_list.SetItemText(nListIndex,7,dlg.m_homepage);
		m_list.SetItemText(nListIndex,8,dlg.m_demo);
   }
}

void CBookDialog::OnButtonDelete() 
{
	int nItem;
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	if (pos == NULL)
	{
		MessageBox("请先选择所要删除的记录！","提示",MB_OK);
		return;
	}
	else
	{
	   nItem = m_list.GetNextSelectedItem(pos);
       if(MessageBox("真的要删除此记录吗？","提示",MB_YESNO)==IDYES)
	   {
		   m_list.DeleteItem(nItem);
		   //delete database
		   m_dataRecset->MoveFirst();
		   m_dataRecset->Move( nItem, SQL_FETCH_RELATIVE );
		   if(m_dataRecset->CanUpdate())
		   {
			   m_dataRecset->Delete();
			   m_dataRecset->MoveNext();
		   }
	   }
	}
}

void CBookDialog::OnButtonProperty() 
{
	int nItem;
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	if (pos == NULL)
	{
		MessageBox("请先选择记录！","提示",MB_OK);
		return;
	}
	else
	{
	   nItem = m_list.GetNextSelectedItem(pos);
	   m_dataRecset->MoveFirst();
	   m_dataRecset->Move( nItem, SQL_FETCH_RELATIVE );
	   
	   CFamilytreeApp *pApp = (CFamilytreeApp *)AfxGetApp();
		pApp->m_bookData.szName    = m_dataRecset->m_name ;   
		pApp->m_bookData.szEmail   = m_dataRecset->m_email ;  
		pApp->m_bookData.szOicq    = m_dataRecset->m_oicq  ;  
		pApp->m_bookData.szMobile  = m_dataRecset->m_mobile ; 
		pApp->m_bookData.szPhone   = m_dataRecset->m_phone  ; 
		pApp->m_bookData.szBirthday= m_dataRecset->m_birthday;
		pApp->m_bookData.szWorkUnit= m_dataRecset->m_workunit;
		pApp->m_bookData.szHomepage= m_dataRecset->m_homepage;
		pApp->m_bookData.szDemo    = m_dataRecset->m_demo  ;  

	   CPropertyDlg dlg;

	   if(dlg.DoModal()==IDOK)
	   {
			m_dataRecset->Edit ();
			m_dataRecset->m_name     =dlg.m_name;
			m_dataRecset->m_email    =dlg.m_email;
			m_dataRecset->m_oicq     =dlg.m_oicq;
			m_dataRecset->m_mobile   =dlg.m_mobile;
			m_dataRecset->m_phone    =dlg.m_phone;
			m_dataRecset->m_birthday =dlg.m_birthday;
			m_dataRecset->m_workunit =dlg.m_unit;
			m_dataRecset->m_homepage =dlg.m_homepage;
			m_dataRecset->m_demo     =dlg.m_demo;
			m_dataRecset->Update ();

			m_list.SetItemText(nItem,0,dlg.m_name);
			m_list.SetItemText(nItem,1,dlg.m_email);
			m_list.SetItemText(nItem,2,dlg.m_oicq);
			m_list.SetItemText(nItem,3,dlg.m_mobile);
			m_list.SetItemText(nItem,4,dlg.m_phone);
			m_list.SetItemText(nItem,5,dlg.m_birthday);
			m_list.SetItemText(nItem,6,dlg.m_unit);
			m_list.SetItemText(nItem,7,dlg.m_homepage);
			m_list.SetItemText(nItem,8,dlg.m_demo);
	   }
	}
	
}

void CBookDialog::OnButtonFind() 
{
	CFindDlg dlg;
	CString szItem,szValue,szFind;
	int nIndex=0;
   if(dlg.DoModal()==IDOK)
   {
 		CFamilytreeApp *pApp = (CFamilytreeApp *)AfxGetApp();
	   szItem.Empty();
        szItem = pApp->m_szSelectItem;
	   szValue.Empty();
	   szValue = pApp->m_szValue;
       if(szItem=="姓名")
		   nIndex=1;
	   else if(szItem=="EMAIL")
		   nIndex=2;
	   else if(szItem=="OICQ")
		   nIndex=3;
	   else if(szItem=="手机号码")
		   nIndex=4;
	   else if(szItem=="电话号码")
		   nIndex=5;
	   else if(szItem=="生日")
		   nIndex=6;
	   else if(szItem=="工作单位")
		   nIndex=7;
	   else if(szItem=="个人主页")
		   nIndex=8;
	   else if(szItem=="备注")
		   nIndex=9;
	   BOOL bFind=FALSE;
	   int nItemFind=0;
	   m_dataRecset->MoveFirst();
	   while(!m_dataRecset->IsEOF())
	   {
		   switch(nIndex)
		   {
			case 1:
				if(m_dataRecset->m_name.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 2:
				if(m_dataRecset->m_email.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 3:
				if(m_dataRecset->m_oicq.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 4:
				if(m_dataRecset->m_mobile.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 5:
				if(m_dataRecset->m_phone.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 6:
				if(m_dataRecset->m_birthday.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 7:
				if(m_dataRecset->m_workunit.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 8:
				if(m_dataRecset->m_homepage.Find(szValue)!=-1)
					bFind=TRUE;
				break;
			case 9:
				if(m_dataRecset->m_demo.Find(szValue)!=-1)
					bFind=TRUE;
				break;
		   }
		   if(bFind)
			   break;
		   m_dataRecset->MoveNext();
		   nItemFind++;
	   }
	   if(!bFind)
	   {
			MessageBox("通讯录中没有此记录！","提示",MB_OK);
			return;
	   }
	   m_dataRecset->MoveFirst();
	   m_dataRecset->Move( nItemFind, SQL_FETCH_RELATIVE );
	   
//	   CSuperWorldApp *pApp = (CSuperWorldApp *)AfxGetApp();
		pApp->m_bookData.szName    = m_dataRecset->m_name ;   
		pApp->m_bookData.szEmail   = m_dataRecset->m_email ;  
		pApp->m_bookData.szOicq    = m_dataRecset->m_oicq  ;  
		pApp->m_bookData.szMobile  = m_dataRecset->m_mobile ; 
		pApp->m_bookData.szPhone   = m_dataRecset->m_phone  ; 
		pApp->m_bookData.szBirthday= m_dataRecset->m_birthday;
		pApp->m_bookData.szWorkUnit= m_dataRecset->m_workunit;
		pApp->m_bookData.szHomepage= m_dataRecset->m_homepage;
		pApp->m_bookData.szDemo    = m_dataRecset->m_demo  ;  

		CPropertyDlg dlg;

	   if(dlg.DoModal()==IDOK)
	   {
			m_dataRecset->Edit ();
			m_dataRecset->m_name     =dlg.m_name;
			m_dataRecset->m_email    =dlg.m_email;
			m_dataRecset->m_oicq     =dlg.m_oicq;
			m_dataRecset->m_mobile   =dlg.m_mobile;
			m_dataRecset->m_phone    =dlg.m_phone;
			m_dataRecset->m_birthday =dlg.m_birthday;
			m_dataRecset->m_workunit =dlg.m_unit;
			m_dataRecset->m_homepage =dlg.m_homepage;
			m_dataRecset->m_demo     =dlg.m_demo;
			m_dataRecset->Update ();

			m_list.SetItemText(nItemFind,0,dlg.m_name);
			m_list.SetItemText(nItemFind,1,dlg.m_email);
			m_list.SetItemText(nItemFind,2,dlg.m_oicq);
			m_list.SetItemText(nItemFind,3,dlg.m_mobile);
			m_list.SetItemText(nItemFind,4,dlg.m_phone);
			m_list.SetItemText(nItemFind,5,dlg.m_birthday);
			m_list.SetItemText(nItemFind,6,dlg.m_unit);
			m_list.SetItemText(nItemFind,7,dlg.m_homepage);
			m_list.SetItemText(nItemFind,8,dlg.m_demo);
	   }

   }
}

void CBookDialog::OnButtonEmail() 
{
	CFamilytreeApp *pApp = (CFamilytreeApp *)AfxGetApp();
	int nItem;
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	if (pos != NULL)
	{
	   nItem = m_list.GetNextSelectedItem(pos);
	   m_dataRecset->MoveFirst();
	   m_dataRecset->Move( nItem, SQL_FETCH_RELATIVE );
	   pApp->m_szToEmail.Empty();
	   pApp->m_szToEmail = m_dataRecset->m_email;
	}
	CSendMail dlg;
	dlg.DoModal();	
}

void CBookDialog::OnButtonBack() 
{
	CColorDialog dlg;
	if (dlg.DoModal() == IDOK)
	{
	   COLORREF color = dlg.GetColor();
		m_list.SetBkColor(color);
		m_list.SetTextBkColor(color);
		RedrawWindow(NULL, NULL,  RDW_INVALIDATE | RDW_UPDATENOW | RDW_ERASE ); 
	}


}

void CBookDialog::OnButtonFont() 
{
	CColorDialog dlg;
	if (dlg.DoModal() == IDOK)
	{
	   COLORREF color = dlg.GetColor();
		m_list.SetTextColor(color);	
		RedrawWindow(NULL, NULL,  RDW_INVALIDATE | RDW_UPDATENOW | RDW_ERASE ); 
	}
}

void CBookDialog::OnButtonNote() 
{
	// TODO: Add your control notification handler code here
	CWorldDialog dlg;
	dlg.DoModal();
}
上一页 12
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -