第九章11.txt

本书在复习C++基础知识后

void CEx_A9View::OnRButtonDown(UINT nFlags, CPoint point) 
{
	CListView::OnRButtonDown(nFlags, point);
	CListCtrl& m_ListCtrl = GetListCtrl();
	UINT uFlags;
	int nItem = m_ListCtrl.HitTest(point, &uFlags);
	if (uFlags & LVHT_ONITEMLABEL)	
{
		CStuInfoDlg dlg;
		dlg.m_strOKText	= "修改";				// 按钮标题
		dlg.m_strName	= m_ListCtrl.GetItemText( nItem, 1);	
		dlg.m_strNO		= m_ListCtrl.GetItemText( nItem, 2);	
		// 处理性别
		CString strSex, strTime;
		strSex = m_ListCtrl.GetItemText( nItem, 3);
		if (strSex=="0") strSex = "女";
		else strSex = "男";
		dlg.m_strSex = strSex;
		// 处理时间，由字符串转换成时间
		strTime = m_ListCtrl.GetItemText( nItem, 4);
		COleVariant vt(strTime);
		vt.ChangeType(VT_DATE);
		COleDateTime tm = vt;
		dlg.m_tBirth	= CTime(tm.GetYear(), tm.GetMonth(), tm.GetDay(), 0, 0, 0);
		dlg.m_strSpec	= m_ListCtrl.GetItemText( nItem, 5);
		if (IDOK == dlg.DoModal())	
{	// 修改
			// 处理性别字符串
			CString strSex, strTime;
			if ( dlg.m_strSex == "男" ) strSex = "True";
			else strSex = "False";
			// 处理时间字符串
			strTime = dlg.m_tBirth.Format("%Y-%m-%d");		// 按年-月-日格式
			// 更新记录
			_CommandPtr pCmd;
			pCmd.CreateInstance(__uuidof(Command));			
			pCmd->ActiveConnection = m_pConnection;	
			CString strText;
			strText.Format( "UPDATE student SET xb=%s,birthday='%s',special='%s'\
				WHERE studentname='%s' AND studentno='%s'",
				strSex, strTime, dlg.m_strSpec, dlg.m_strName, dlg.m_strNO );
			pCmd->CommandText = _bstr_t(strText);
			pCmd->Execute(NULL, NULL, adCmdText );	
			DispAllRec();
		}
	}
}