Exemple #1
0
void CMSG_Server::AddMessage(char *strMessage, int size, int color)
{
	CDialog *pDlg = (CDialog*)pMainDlg;
	::PostMessageA(pDlg->GetSafeHwnd(),ID_MSG_STATE,0,(LPARAM)strMessage);
}
Exemple #2
0
void CMorphaResDlg::OnClickListMorphadata(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_LISTVIEW*   pNMListView = (NM_LISTVIEW*)pNMHDR; 

	LV_COLUMN  lc;
	lc.mask  = LVCF_TEXT ;
	TCHAR pszText[40];
	lc.pszText =  pszText;
	lc.cchTextMax = sizeof(pszText)/sizeof(pszText[0]);
	int nCol = 0;
	while (m_wndMorphaDataList.GetColumn(nCol,&lc))
	{
		if(CString(lc.pszText) == TEXT("检测号"))
			break;
		++nCol;
	}
	CString str=m_wndMorphaDataList.GetItemText(pNMListView->iItem,nCol);
	if(str == "") return;
	CString strSQLinfo("select distinct *,basicinfo.pdetectno as 'pDetectno' from basicinfo,spermchait\
		where basicinfo.pdetectno=spermchait.pdetectno and \
		basicinfo.pdetectno='");
	strSQLinfo= strSQLinfo + str + CString("'");

	CPropertySheet* pSheet=(CPropertySheet*)GetParent();
	CStatic* pStatic=(CStatic*)pSheet->GetParent();
	CMorphaDataRetriveDlg* pDlg=(CMorphaDataRetriveDlg*)pStatic->GetParent();
	
	try
	{
		_variant_t var;
		COleDateTime pddt;
		_RecordsetPtr rs=theConnection->Execute((LPCTSTR)strSQLinfo,NULL,adCmdText);
		var = rs->GetCollect("pDetectno");
		pDlg->m_strEditDetectNO = (char*)(_bstr_t)var;
// 		pDlg->m_strEditDetectNO.TrimLeft();
// 		pDlg->m_strEditDetectNO.TrimRight();
		var = rs->GetCollect("pCaseNO");
		pDlg->m_strEditCaseNO = (char*)(_bstr_t)var;
// 		pDlg->m_strEditCaseNO.TrimLeft();
// 		pDlg->m_strEditCaseNO.TrimRight();
		var = rs->GetCollect("pname");
		pDlg->m_strEditName = (char*)(_bstr_t)var;
// 		pDlg->m_strEditName.TrimLeft();
// 		pDlg->m_strEditName.TrimRight();
		var = rs->GetCollect("pspermvolume");
		pDlg->m_strEditSpermVolume = (char*)(_bstr_t)var;
// 		pDlg->m_strEditSpermVolume.TrimLeft();
// 		pDlg->m_strEditSpermVolume.TrimRight();
		var = rs->GetCollect("page");
		pDlg->m_strEditAge = (char*)(_bstr_t)var;
// 		pDlg->m_strEditAge.TrimLeft();
// 		pDlg->m_strEditAge.TrimRight();
		pddt=rs->GetCollect("pdetectdatetime");
		pDlg->m_oledateDetectDate.SetDate(pddt.GetYear(),pddt.GetMonth(),pddt.GetDay());
		pDlg->m_oletimeDetectTime.SetTime(pddt.GetHour(),pddt.GetMinute(),pddt.GetSecond());
		var = rs->GetCollect("pSampleNO");
		pDlg->m_strEditSampleNO = (char*)(_bstr_t)var;
// 		pDlg->m_strEditSampleNO.TrimLeft();
// 		pDlg->m_strEditSampleNO.TrimRight();
		var = rs->GetCollect("pdilutionratio");
		pDlg->m_strEditDilutionRatio = (char*)(_bstr_t)var;
// 		pDlg->m_strEditDilutionRatio.TrimLeft();
// 		pDlg->m_strEditDilutionRatio.TrimRight();
		var = rs->GetCollect("pShape");
		pDlg->m_strEditShape = (char*)(_bstr_t)var;
// 		pDlg->m_strEditShape.TrimLeft();
// 		pDlg->m_strEditShape.TrimRight();
		pddt=rs->GetCollect("pspermgetdatetime");
		pDlg->m_oledateSpermGetDate.SetDate(pddt.GetYear(),pddt.GetMonth(),pddt.GetDay());
		pDlg->m_oletimeSpermGetTime.SetTime(pddt.GetHour(),pddt.GetMinute(),pddt.GetSecond());
		var = rs->GetCollect("pcolor");
		pDlg->m_strEditSpermColor =  (char*)(_bstr_t)var;
// 		pDlg->m_strEditSpermColor.TrimLeft();
// 		pDlg->m_strEditSpermColor.TrimRight();
		var = rs->GetCollect("pcohesion");
		pDlg->m_strEditCohension =  (char*)(_bstr_t)var;
// 		pDlg->m_strEditCohension.TrimLeft();
// 		pDlg->m_strEditCohension.TrimRight();
		var = rs->GetCollect("pRoomTempera");
		pDlg->m_strEditRoomTempera = (char*)(_bstr_t)var;
// 		pDlg->m_strEditRoomTempera.TrimLeft();
// 		pDlg->m_strEditRoomTempera.TrimRight();
		var = rs->GetCollect("pdaysofabstinency");
		pDlg->m_strEditAbstinency = (char*)(_bstr_t)var;
// 		pDlg->m_strEditAbstinency.TrimLeft();
// 		pDlg->m_strEditAbstinency.TrimRight();
		var = rs->GetCollect("pliquifystate");
		pDlg->m_strEditLiquifyState = (char*)(_bstr_t)var;
// 		pDlg->m_strEditLiquifyState.TrimLeft();
// 		pDlg->m_strEditLiquifyState.TrimRight();
		var = rs->GetCollect("psmell");
		pDlg->m_strEditSmell = (char*)(_bstr_t)var;
// 		pDlg->m_strEditSmell.TrimLeft();
// 		pDlg->m_strEditSmell.TrimRight();
		var = rs->GetCollect("pthickness");
		pDlg->m_strEditThickness = (char*)(_bstr_t)var;
// 		pDlg->m_strEditThickness.TrimLeft();
// 		pDlg->m_strEditThickness.TrimRight();
		var = rs->GetCollect("pph");
		pDlg->m_strEditPH = (char*)(_bstr_t)var;
// 		pDlg->m_strEditPH.TrimLeft();
// 		pDlg->m_strEditPH.TrimRight();
		var = rs->GetCollect("pspermmethod");
		pDlg->m_strEditSpermWay = (char*)(_bstr_t)var;
// 		pDlg->m_strEditSpermWay.TrimLeft();
// 		pDlg->m_strEditSpermWay.TrimRight();
		var = rs->GetCollect("pliquifytime");
		pDlg->m_strEditLiquifyTime = (char*)(_bstr_t)var;
// 		pDlg->m_strEditLiquifyTime.TrimLeft();
// 		pDlg->m_strEditLiquifyTime.TrimRight();
		pDlg->UpdateData(FALSE);
	}
	catch (_com_error& e)
	{
		AfxMessageBox(e.Description());
		return;
	}
	
	//
	str.Format("select * from morphasperminfo where pid like('%s%%')", pDlg->m_strEditDetectNO);
	try
	{
		_RecordsetPtr rs=theConnection->Execute((LPCTSTR)str,NULL,adCmdText);
		_variant_t vt;
		SingleSpermInfo ssInfo;

		pDlg->m_vSpermInfo.clear();

		while(!rs->EndOfFile)
		{
			vt = rs->GetCollect("x");
			ssInfo.pos.x = (long)vt;
			vt = rs->GetCollect("y");
			ssInfo.pos.y = (long)vt;

			vt = rs->GetCollect("pid");
			CString cs;
			cs = (char*)(_bstr_t)vt;

			int nl = cs.ReverseFind('_');
			nl = cs.GetLength()-nl-1;
			cs = cs.Right(nl);
			ssInfo.nSpermNO = atol((LPCTSTR)cs);

			vt = rs->GetCollect("IsNormal");
			ssInfo.bIsNormal = (bool)vt;

			vt = rs->GetCollect("m_length");
			ssInfo.smPara.m_length = (double)vt;
			vt = rs->GetCollect("m_width");
			ssInfo.smPara.m_width = (double)vt;
			vt = rs->GetCollect("m_area");
			ssInfo.smPara.m_area = (double)vt;
			
			vt = rs->GetCollect("m_ellipticity");
			ssInfo.smPara.m_ellipticity = (double)vt;
			vt = rs->GetCollect("m_perfor_area");
			ssInfo.smPara.m_perfor_area = (double)vt;
			vt = rs->GetCollect("m_head_area");
			ssInfo.smPara.m_head_area = (double)vt;
			vt = rs->GetCollect("m_perimeter");
			ssInfo.smPara.m_perimeter = (double)vt;
			vt = rs->GetCollect("m_head_perfor_area");
			ssInfo.smPara.m_head_perfor_area = (double)vt;
			
			vt = rs->GetCollect("m_tail_length");
			ssInfo.smPara.m_tail_length = (double)vt;
			vt = rs->GetCollect("m_tail_width");
			ssInfo.smPara.m_tail_width = (double)vt;
			vt = rs->GetCollect("m_tail_angle");
			ssInfo.smPara.m_tail_angle = (double)vt;

			vt = rs->GetCollect("m_extension");
			ssInfo.smPara.m_extension = (double)vt;
			vt = rs->GetCollect("m_symmetry");
			ssInfo.smPara.m_symmetry = (double)vt;
			vt = rs->GetCollect("m_ruga");
			ssInfo.smPara.m_ruga = (double)vt;
	
			pDlg->m_vSpermInfo.push_back(ssInfo);
			
			rs->MoveNext();

		}

		// Update UI button
		UINT uSelectedCount = m_wndMorphaDataList.GetSelectedCount();
		BOOL enable = uSelectedCount>=1 ? TRUE : FALSE;
		CDialog *pdlg = ((CMainFrame*)AfxGetMainWnd())->m_pWndMorphadlg;

		::SendMessage(pdlg->GetSafeHwnd(), USER_MSG_SHOW_PRINT_BTN, (WPARAM)enable, 0);
		::SendMessage(pdlg->GetSafeHwnd(), USER_MSG_SHOW_MOPHY_DEL_SEL_BTN, (WPARAM)enable, 0);

	}
	catch (_com_error& e)
	{
		MessageBox(e.Description());
		return;
	}

	*pResult = 0;
}