menudlg.cpp

该源码的前台用C++编写

		m_btnSelPhoto.EnableWindow(FALSE);
		return TRUE;
	}
	//如果不是第一条记录，指向前一个记录
	m_pRecordset->MovePrevious();
	//此时如果为第一条记录，则指向第一条记录
	if(m_pRecordset->BOF)
	{
		m_pRecordset->MoveFirst();
		return TRUE;
	}
	//如果不是，则指向下一条记录
	else
	{
		m_pRecordset->MoveNext();
		return FALSE;
	}
}

//-----------------判断是否是最后一个记录--------------//
BOOL CMenuDlg::LastRecord()
{
	if(m_pRecordset->adoEOF)
	{
		m_editName.EnableWindow(FALSE);
		m_editNum.EnableWindow(FALSE);
		m_editType.EnableWindow(FALSE);
		m_editPrice.EnableWindow(FALSE);
		m_editRemark.EnableWindow(FALSE);
		m_editFoodCost.EnableWindow(FALSE);

		return TRUE;
	}
	m_pRecordset->MoveNext();
	if(m_pRecordset->adoEOF)
	{
		m_pRecordset->MovePrevious();
		return TRUE;
	}
	else
	{
		m_pRecordset->MovePrevious();
		return FALSE;
	}
}

//------------读取记录集当前记录中数据---------------//
void CMenuDlg::ReadData()
{
	//消除原有的图像数据
	DestroyPhoto();	

	//如果当前记录超过了记录集的起始与结尾，显示为空或0
	if(m_pRecordset->adoEOF||m_pRecordset->BOF) 
	{
		m_strFoodName.Empty();
		m_nFoodNum = 0;
		m_strFoodType.Empty();
		m_nFoodPrice = 0;
		m_nFoodCost = 0;
		m_strFoodRemark.Empty();

		UpdateData(FALSE);
		return;
	}
	//--------图像数据----------------------//
	long lDataSize = m_pRecordset->GetFields()->GetItem("FoodPic")->ActualSize;

	if(lDataSize > 0)
	{
		_variant_t	varBLOB;
		varBLOB = m_pRecordset->GetFields()->GetItem("FoodPic")->GetChunk(lDataSize);
		
		if(varBLOB.vt == (VT_ARRAY | VT_UI1))
		{
			if(m_pBMPBuffer = new char[lDataSize+1])			
			{	
				char *pBuf = NULL;
				SafeArrayAccessData(varBLOB.parray,(void **)&pBuf);
				memcpy(m_pBMPBuffer,pBuf,lDataSize);				
				SafeArrayUnaccessData (varBLOB.parray);
				m_nFileLen = lDataSize;
				m_hPhotoBitmap = BufferToHBITMAP();					
			}
		}
	}

	//------------------------------//
	//从数据库中读出各个字段的数据，反馈给界面控件
	m_strFoodName = m_pRecordset->GetCollect("FoodName").bstrVal;
	m_nFoodNum= m_pRecordset->GetCollect("FoodNum").lVal;
	m_strFoodType= m_pRecordset->GetCollect("FoodType").bstrVal;	
	m_strFoodRemark = m_pRecordset->GetCollect("FoodRemark").bstrVal;//类型确定	
	m_nFoodPrice = m_pRecordset->GetCollect("FoodPrice").lVal;
	m_nFoodCost = m_pRecordset->GetCollect("FoodCost").lVal;

	m_editName.EnableWindow();
	m_editNum.EnableWindow();
	m_editType.EnableWindow();
	m_editPrice.EnableWindow();
	m_editRemark.EnableWindow();
	m_editFoodCost.EnableWindow();

	m_btnSelPhoto.EnableWindow();
	m_btnSave.EnableWindow(FALSE);
	m_btnDelete.EnableWindow();
	UpdateData(FALSE);
}




void CMenuDlg::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	if (IsIconic())
	{
		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		//dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{	
		CWnd *pWnd = GetDlgItem(IDC_PICTURE);
		CRect rect; 
		pWnd->GetClientRect(&rect);
		DrawUserPhoto(rect.left,rect.top,&dc);
		CDialog::OnPaint();
	}
}

//-----------在屏幕上显示图像-------------------//
void CMenuDlg::DrawUserPhoto(int x, int y, CDC *pDC)
{
	if(!m_hPhotoBitmap) return;
	
	HBITMAP OldBitmap;

	CWnd *pWnd = GetDlgItem(IDC_PICTURE);
	CRect rect; 
	pWnd->GetClientRect(&rect);	
	pDC = pWnd->GetDC();

	CDC MemDC;
	
	MemDC.CreateCompatibleDC(pDC);
	OldBitmap=(HBITMAP)MemDC.SelectObject(m_hPhotoBitmap);
	pDC->BitBlt(x,y,rect.Width(),rect.Height(),&MemDC,0,0,SRCCOPY);
	MemDC.SelectObject(OldBitmap);
}
//-----------------------------------------//

/////////////清除分配的对象/////////////
void CMenuDlg::DestroyPhoto()
{
	if(m_hPhotoBitmap)
	{
		DeleteObject(m_hPhotoBitmap);
		m_hPhotoBitmap = NULL;
	}
	if(m_pBMPBuffer)
	{
		delete m_pBMPBuffer;
		m_pBMPBuffer = NULL;
	}
}

/////////////加载BMP文件到内存//////////////
BOOL CMenuDlg::LoadBMPFile(const char *pBMPPathname)
{
	CFile file;
	if( !file.Open( pBMPPathname, CFile::modeRead) )
		return FALSE;
	m_nFileLen = file.GetLength();
	m_pBMPBuffer = new char[m_nFileLen + 1];
	if(!m_pBMPBuffer)
		return FALSE;
	if(file.ReadHuge(m_pBMPBuffer,m_nFileLen) != m_nFileLen)
		return FALSE;
	return TRUE;
}

///////////将内存中的BMP文件内容转换到HBITMAP///////
HBITMAP CMenuDlg::BufferToHBITMAP()
{
	HBITMAP				hBmp;
	LPSTR				hDIB,lpBuffer = m_pBMPBuffer;
	LPVOID				lpDIBBits;
	BITMAPFILEHEADER	bmfHeader;
	DWORD				bmfHeaderLen;

	bmfHeaderLen = sizeof(bmfHeader);
	strncpy((LPSTR)&bmfHeader,(LPSTR)lpBuffer,bmfHeaderLen);

	if (bmfHeader.bfType != (*(WORD*)"BM")) return NULL;//我copy《Windows程序设计》上的做法。
	hDIB = lpBuffer + bmfHeaderLen;
	BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)hDIB ;
	BITMAPINFO &bmInfo = *(LPBITMAPINFO)hDIB ;

	lpDIBBits=(lpBuffer)+((BITMAPFILEHEADER *)lpBuffer)->bfOffBits;//这行功能和上面被注释掉的代码相同，容易理解。
	CClientDC dc(this);
	hBmp = CreateDIBitmap(dc.m_hDC,&bmiHeader,CBM_INIT,lpDIBBits,&bmInfo,DIB_RGB_COLORS);
	return hBmp;
}

void CMenuDlg::OnDeleteFood() 
{
	// TODO: Add your control notification handler code here
	m_pRecordset->Delete(adAffectCurrent);
	if(m_pRecordset->adoEOF)
		m_pRecordset->MoveLast();
	ResetControls();
	m_btnDelete.EnableWindow(FALSE);
	ReadData();
	Invalidate();		
	
}

void CMenuDlg::OnSaveFood() 
{
	// TODO: Add your control notification handler code here
	if(!m_bModify) return;
	UpdateData();
	if( m_strFoodName == "" ||  m_strFoodType == "" || m_nFoodNum == 0|| m_strFoodRemark == "" ||	m_nFoodPrice== 0 ||m_nFoodCost == 0 )
	{
		AfxMessageBox("您没有提供完整的用户信息。");
		return;
	}
	m_btnSave.EnableWindow(FALSE);
	//---------------图像数据-----------------------------//
	char			*pBuf = m_pBMPBuffer;
	VARIANT			varBLOB;
	SAFEARRAY		*psa;
    SAFEARRAYBOUND	rgsabound[1];
	if(pBuf)
	{    
		rgsabound[0].lLbound = 0;
		rgsabound[0].cElements = m_nFileLen;
		psa = SafeArrayCreate(VT_UI1, 1, rgsabound);
		for (long i = 0; i < (long)m_nFileLen; i++)
			SafeArrayPutElement (psa, &i, pBuf++);
		varBLOB.vt = VT_ARRAY | VT_UI1;
		varBLOB.parray = psa;
		m_pRecordset->GetFields()->GetItem("FoodPic")->AppendChunk(varBLOB);
	}

	//-----------------------------------------------------//

	if(m_bNewRecord)
		m_pRecordset->AddNew();
	m_pRecordset->PutCollect("FoodName",_variant_t(m_strFoodName));
	m_pRecordset->PutCollect("FoodType",_variant_t(m_strFoodType));
	m_pRecordset->PutCollect("FoodRemark",_variant_t(m_strFoodRemark));

	CString str;
	str.Format("%d",m_nFoodPrice);
	m_pRecordset->PutCollect("FoodPrice",_variant_t(str));
	str.Format("%d",m_nFoodNum);
	m_pRecordset->PutCollect("FoodNum",_variant_t(str));
	str.Format("%d",m_nFoodCost);
	m_pRecordset->PutCollect("FoodCost",_variant_t(str));

	m_pRecordset->Update();
	m_btnDelete.EnableWindow();
	ResetControls();
	m_bModify = FALSE;
	m_bNewRecord = FALSE;	
	
}

void CMenuDlg::OnChangeFoodNum() 
{
	// TODO: Add your control notification handler code here
	m_bModify = TRUE;
	m_btnSave.EnableWindow();
}

void CMenuDlg::OnChangeFoodName() 
{
	// TODO: Add your control notification handler code here
	m_bModify = TRUE;
	m_btnSave.EnableWindow();
	
}

void CMenuDlg::OnChangeFoodType() 
{
	// TODO: Add your control notification handler code here
	m_bModify = TRUE;
	m_btnSave.EnableWindow();	
}

void CMenuDlg::OnChangeFoodPrice() 
{
	// TODO: Add your control notification handler code here
	m_bModify = TRUE;
	m_btnSave.EnableWindow();	
}

void CMenuDlg::OnChangeFoodRemark() 
{
	// TODO: Add your control notification handler code here
	m_bModify = TRUE;
	m_btnSave.EnableWindow();	
}

BOOL CMenuDlg::DestroyWindow() 
{
	// TODO: Add your specialized code here and/or call the base class
	DestroyPhoto();	
	m_pRecordset ->Close();
	m_pRecordset = NULL;
	
	return CDialog::DestroyWindow();
}