vc使用技巧集(二)

11、递归树

void CTreeDataDlg::TreeAddSubTree(CString ParTree, HTREEITEM hPartItem) { //----------------使用到的变量进行定义---------- _RecordsetPtr m_pTreeRecordset; //用于创建一个查询记录集 _variant_t vChild; //--------------Tree控件操作变量------------------------ HTREEITEM hCurrent; //---------------------------------------------- CString strSQL,strCurItem; //----------------------------------------------- strSQL="SELECT * FROM TreeItem where ParentItem like '%" ; strSQL=strSQL+ParTree+"%'"; try { HRESULT hTRes; hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset")); if (SUCCEEDED(hTRes)) { //---------------------------------------------------- hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130), _variant_t((IDispatch *)(((CTreeDataApp*)AfxGetApp())->m_pTreeConn),true), adOpenDynamic,adLockPessimistic,adCmdText); if(SUCCEEDED(hTRes)) { TRACE(_T("连接成功!/n")); //------------------------------------------ m_pTreeRecordset->MoveFirst(); if (!(m_pTreeRecordset->adoEOF)) { while(!m_pTreeRecordset->adoEOF) { hCurrent = m_ctrlTree.InsertItem((LPCTSTR)(_bstr_t)/ (m_pTreeRecordset->GetCollect("Name")), hPartItem, NULL); if (TreeSumRecordCount(VariantToCString/ (m_pTreeRecordset->GetCollect("Name")))>0) {//递归 TreeAddSubTree(VariantToCString(m_pTreeRecordset->GetCollect("Name")), hCurrent); } if (!(m_pTreeRecordset->adoEOF)) { m_pTreeRecordset->MoveNext(); } } } //--------------------------------------- } } } catch(_com_error e)///捕捉异常 { CString errormessage; MessageBox("创建City记录集失败!",ParTree); } }   

12、CListCtrl

 

 m_imagelist.Create(16,16,TRUE,2,2); m_imagelist.Add(AfxGetApp()->LoadIcon(IDI_ICON1)); m_imagelist.Add(AfxGetApp()->LoadIcon(IDR_MAINFRAME)); m_list.SetImageList(&m_imagelist,LVSIL_SMALL); m_font.CreateFont(16, 0,0,0,FW_NORMAL, 0,0,0, DEFAULT_CHARSET, OUT_CHARACTER_PRECIS, CLIP_CHARACTER_PRECIS, DEFAULT_QUALITY, DEFAULT_PITCH | FF_DONTCARE, "Arial"); m_list.SetFont(&m_font); /*-----------------------------------------------------------*/ m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES); m_list.SetBkColor(RGB(247,247,255)); m_list.SetTextColor(RGB(0,0,255)); m_list.SetTextBkColor(RGB(247,247,255)); m_list.InsertColumn(0, "学号", LVCFMT_LEFT, 110); m_list.InsertColumn(1, "姓名", LVCFMT_LEFT, 130); m_list.InsertColumn(2, "成绩", LVCFMT_LEFT, 47); m_list.InsertItem(0,"2002112105"); m_list.SetItemText(0,1,"程红秀"); m_list.SetItemText(0,2,"96"); // 得到List索引 // OnDblclkList(NMHDR* pNMHDR, LRESULT* pResult) { // TODO: Add your control notification handler code here POSITION pos = m_list.GetFirstSelectedItemPosition(); m_nIndex = m_list.GetNextSelectedItem(pos); // 得到项目索引 CString a = m_list.GetItemText(m_nIndex,0); CString b = m_list.GetItemText(m_nIndex,1); CString c = m_list.GetItemText(m_nIndex,2); } // 保存成文本 // void CListCtrlDlg::OnButtonSave() { // TODO: Add your control notification handler code here CStdioFile file; if(file.Open("record.txt",CFile::modeCreate | CFile::modeWrite)) { CString strOut = "学号/t/t姓名/t/t成绩/r/n"; file.WriteString(strOut); for(int i=0;i<m_list.GetItemCount();i++) { strOut=m_list.GetItemText(i,0) + "/t"+m_list.GetItemText(i,1)+"/t "+m_list.GetItemText(i,2) +"/r/n"; file.WriteString(strOut); } file.Close(); MessageBox("保存成功!","提示",MB_ICONINFORMATION); } else { MessageBox("保存失败!","提示",MB_ICONINFORMATION); } }   

13、程序自动启动

 m_bAutoStart = !m_bAutoStart; AfxGetApp()->WriteProfileInt(_T("User Info"), _T("AutoStart"), m_bAutoStart); HKEY hKey; LPCTSTR lpSubKey = _T("SOFTWARE//Microsoft//Windows//CurrentVersion//Run/0"); RegOpenKeyEx(HKEY_LOCAL_MACHINE, lpSubKey, 0L, KEY_ALL_ACCESS, &hKey); if (m_bAutoStart) { TCHAR AppPathName[MAX_PATH]; GetModuleFileName(NULL, AppPathName, MAX_PATH); LPCTSTR lpValue = AppPathName; RegSetValueEx(hKey, _T("nsserver"), 0L, REG_SZ, (const BYTE *)lpValue, strlen(lpValue) + 1); } else { RegDeleteValue(hKey, _T("nsserver")); }   

14、新建文档视图

void CMainFrame::OnInputUnit() { // TODO: Add your command handler code here m_currentwin=1;//录入 if(m_pInput!=NULL) { m_pInput->MDIActivate(); return; } m_pInput=new CRaChildFrame(); CCreateContext context; context.m_pNewViewClass=RUNTIME_CLASS(CInputCertView); if(!m_pInput->LoadFrame(IDI_ICON3,WS_MAXIMIZE|WS_OVERLAPPEDWINDOW,this,&context)) return; m_pInput->ShowWindow(SW_SHOWMAXIMIZED); m_pInput->InitialUpdateFrame(NULL,true); } 另外一种写法 CChildFrame* pFrame = new CChildFrame(); CCreateContext context; context.m_pCurrentDoc=mp_doc; //that's the way I avoid to create new document every time I open a new view context.m_pNewViewClass=RUNTIME_CLASS(CTSMLView); context.m_pNewDocTemplate=pDocTemplate; context.m_pLastView=(((CMainFrame *)m_pMainWnd)->GetActiveFrame() ? ((CMainFrame *)m_pMainWnd)->GetActiveFrame()->GetActiveView() : NULL); context.m_pCurrentFrame=((CMainFrame *)m_pMainWnd)->GetActiveFrame(); if (!pFrame->LoadFrame(IDR_TSMLTYPE,WS_OVERLAPPEDWINDOW | FWS_PREFIXTITLE ,m_pMainWnd, &context ))return; pFrame->InitialUpdateFrame(mp_doc,TRUE);   

 

15、只能运行一个实例

 

//此程序只能运行一次，用互斥量来判断程序是否已运行 HANDLE m_hMutex=CreateMutex(NULL,TRUE, m_pszAppName); if(GetLastError()==ERROR_ALREADY_EXISTS) { AfxMessageBox("程序已经运行！"); return FALSE; }   

16、在多文档界面下，自动生成一个新的子窗口，而一个实际的应用系统往往

是由用户操作后再生成新的窗口。为了去掉开始的子窗口，可在应用程序文件

分析命令行的语句

 

　　CCommandLineInfo cmdInfo；

 

　　ParseCommandLine(cmdInfo)；

 

　　后加入：

 

　　cmdInfo.m_nShellCommand=CCommandLineInfo::FileNothing

 

17、if(AfxMessageBox("真的要退出吗?",MB_YESNO)==IDYES)

 {

  CDialog::OnOK();

 }

 

18、ACCESS和SQL2000日期

 

 access表示为：#1981-28-12#  date BETWEEN #2005-04-28 23:59:59# AND #2005-05-24

 

23:59:59#

 SQLSERVER2000表示为：'1981-02-12'       date BETWEEN '2005-03-21' AND '2005-05-24'

 

19、初始化应用程序的大小

  BOOL CMainFrame::PreCreateWindow(CREATESTRUCT& cs) { int xsize=::GetSystemMetrics(SM_CXSCREEN); int ysize=::GetSystemMetrics(SM_CYSCREEN); cs.cx=xsize*5/10; cs.cy=ysize*5/10; cs.x=(xsize-cs.cx)/2; cs.y=(ysize-cs.cy)/2; }

 

  其中的5/10是你的初始界面占屏幕的百分比，可以自己修改。如果想使应用程序大小固定添加

 

cs.style&=~WS_THICKFRAME;

 

20、全屏FRAME

void CTestView::ShowFullScreen() { CMainFrame *pFrame=(CMainFrame *)(AfxGetApp()->m_pMainWnd); if(m_bFullScreen) { pFrame->ModifyStyle(0,WS_CAPTION); pFrame->ModifyStyle(0,WS_THICKFRAME); pFrame->ShowWindow(SW_SHOWNORMAL); m_bFullScreen=0; } else { pFrame->ModifyStyle(WS_CAPTION,0); pFrame->ModifyStyle(WS_THICKFRAME,0); pFrame->ShowWindow(SW_MAXIMIZE); m_bFullScreen=1; } }