tooldrill.cpp

基于SQLSERVER2000的机械工艺数据库系统

	j=m_Drilllist.GetItemCount();
	m_Drilllist.InsertItem(j, m_sToolID);
    m_Drilllist.SetItemText(j, 1 , m_sDrillname);
    m_Drilllist.SetItemText(j, 2 , m_sDrilldia);
	m_Drilllist.SetItemText(j, 3 , m_sDrillbrand);
    m_Drilllist.SetItemText(j, 4 , m_sDrillmaterial);
    m_Drilllist.SetItemText(j, 5 , m_sFormaterial);
	m_Drilllist.SetItemText(j, 6 , m_sProducer);
    m_Drilllist.SetItemText(j, 7 , m_sShankdia);
    m_Drilllist.SetItemText(j, 8 , m_sOveralllength);
	m_Drilllist.SetItemText(j, 9 , m_sNecklength);
    m_Drilllist.SetItemText(j, 10 , m_sFlutelength);
    m_Drilllist.SetItemText(j, 11 , m_sPath);


	if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
	{
	    if (flag==1) 
		{
			AfxMessageBox(_T("添加刀具信息成功！"), MB_ICONINFORMATION);
	        // Clear all input
       m_sToolID=m_sDrillname=m_sDrilldia=m_sDrillbrand=m_sDrillmaterial=m_sFormaterial=m_sProducer=m_sShankdia=m_sOveralllength=m_sNecklength=m_sFlutelength=m_sPath="";
            UpdateData(false);
		}
		else AfxMessageBox(_T("修改刀具信息成功！"), MB_ICONINFORMATION);
	}
	else 
	{
		if (flag==1) AfxMessageBox(_T("添加刀具信息失败！"), MB_ICONEXCLAMATION);
		else AfxMessageBox(_T("修改刀具信息失败！"), MB_ICONEXCLAMATION);
	}
    tx_Drillbrand->EnableWindow(false);
	tx_Drilldia->EnableWindow(false);
	tx_Drillmaterial->EnableWindow(false);
    tx_Drillname->EnableWindow(false);
	tx_Flutelength->EnableWindow(false);
	tx_Formaterial->EnableWindow(false);
	tx_Necklength->EnableWindow(false);
	tx_Overalllength->EnableWindow(false);
	tx_Path->EnableWindow(false);
	tx_Producer->EnableWindow(false);
	tx_Shankdia->EnableWindow(false);
	tx_ToolID->EnableWindow(false);
	
	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
	bt_browse->EnableWindow(false);
	
}

void CTOOLDRILL::OnClickList3(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
		UpdateData(true);
	POSITION pos = m_Drilllist.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_Drilllist.GetNextSelectedItem(pos);
		m_sToolID=m_Drilllist.GetItemText(nFirstSelItem,0);
		m_sDrillname=m_Drilllist.GetItemText(nFirstSelItem,1);
		m_sDrilldia=m_Drilllist.GetItemText(nFirstSelItem,2);
        m_sDrillbrand=m_Drilllist.GetItemText(nFirstSelItem,3);
		m_sDrillmaterial=m_Drilllist.GetItemText(nFirstSelItem,4);
		m_sFormaterial=m_Drilllist.GetItemText(nFirstSelItem,5);
		m_sProducer=m_Drilllist.GetItemText(nFirstSelItem,6);
		m_sShankdia=m_Drilllist.GetItemText(nFirstSelItem,7);
		m_sOveralllength=m_Drilllist.GetItemText(nFirstSelItem,8);
		m_sNecklength=m_Drilllist.GetItemText(nFirstSelItem,9);
		m_sFlutelength=m_Drilllist.GetItemText(nFirstSelItem,10);
		m_sPath=m_Drilllist.GetItemText(nFirstSelItem,11);
		//还差一个图片的显示
	}
	//AfxMessageBox(str);
if(m_sPath!="")
 {  static char BASED_CODE szFilter[] = "BMP Files (*.bmp)|*.bmp|All Files (*.*)|*.*||";
	CFileDialog dlg(TRUE,"BMP",NULL,  OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,szFilter);
    CString pathname=m_sPath;
	char *m_pBuffer;  //从BMP文件中读取的数据存放在此变量中
	
	//@@@@@@@@@@   读取BMP文件到m_pBuffer   @@@@@@@@@@
	CFile file;  //定义文件对象
	if( !file.Open(pathname, CFile::modeRead)) //以只读方式打开文件
	{
		MessageBox("无法打开BMP文件");
		return;
	}
	DWORD m_filelen;  //用于保存文件长度
	m_filelen = file.GetLength();  //读取文件长度
	m_pBuffer = new char[m_filelen + 1]; //根据文件长度分配数组空间
	if(!m_pBuffer)  //如果不空间不足则返回
	{
		MessageBox("无法分配足够的内存空间");
		return;
	}
	if(file.ReadHuge(m_pBuffer, m_filelen) != m_filelen)  //读取BMP文件到m_pBuffer中
	{
		MessageBox("读取BMP文件时出现错误");
		return;
	}
	
	//@@@@@@@@@@   将BMP文件数据从m_pBuffer中转换到m_hBitMap位图句柄中
	LPSTR hDIB;
	LPVOID lpDIBBits;
	BITMAPFILEHEADER bmfHeader;  //用于保存BMP文件头信息，包括类型、大小、位移量等
	DWORD bmfHeaderLen;  //保存文件头的长度

	bmfHeaderLen = sizeof(bmfHeader);  //读取文件头的长度
	//将m_pBuffer中文件头复制到bmfHeader中
	strncpy((LPSTR)&bmfHeader, (LPSTR)m_pBuffer, bmfHeaderLen); 	
	if (bmfHeader.bfType != (*(WORD*)"BM"))   //如果文件类型不对，则返回
	{
		MessageBox("BMP文件格式不准确");
		return;
	}
	hDIB = m_pBuffer + bmfHeaderLen;  //将指针移至文件头后面
	//读取BMP文件的图像数据，包括坐标及颜色格式等信息到BITMAPINFOHEADER对象
	BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)hDIB;
	//读取BMP文件的图像数据，包括坐标及颜色格式等信息到BITMAPINFO对象
	BITMAPINFO &bmInfo = *(LPBITMAPINFO)hDIB ;
	//根据bfOffBits属性将指针移至文件头后
	lpDIBBits = (m_pBuffer) + ((BITMAPFILEHEADER *)m_pBuffer)->bfOffBits;
	CClientDC dc(this);  //生成一个与当前窗口相关的CClientDC，用于管理输出设置
	//生成DIBitmap数据
	m_hBitmap = CreateDIBitmap(dc.m_hDC,&bmiHeader,CBM_INIT,lpDIBBits,&bmInfo,DIB_RGB_COLORS);
	
	//激活OnPaint()函数，显示图像
	Invalidate();
 }	
	bt_delete->EnableWindow(true);
	bt_modify->EnableWindow(true);

	UpdateData(false);
	*pResult = 0;
}

BOOL CTOOLDRILL::OnInitDialog() 
{
	 CDialog::OnInitDialog();
	_variant_t strQuery, Holder;
	CString str;
	DWORD style;
	style=m_Drilllist.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_Drilllist.SetExtendedStyle(style);
	m_sOldDrillid = m_sToolID;
	
	// Set Color
	//m_Codelist.SetBkColor(RGB(177, 151, 240));
//	m_Codelist.SetTextColor(RGB(0,0,0));
//	m_Codelist.SetTextBkColor(RGB(177, 151, 240));
    // 设置表字段
	m_Drilllist.InsertColumn(0,"刀具编号",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(1,"钻头名称",LVCFMT_LEFT,100);
 	m_Drilllist.InsertColumn(2,"钻头直径D",LVCFMT_LEFT,100);
    m_Drilllist.InsertColumn(3,"钻头型号",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(4,"刀具材料",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(5,"适合加工材料",LVCFMT_LEFT,100);
    m_Drilllist.InsertColumn(6,"生产商",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(7,"刀柄直径D4",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(8,"全长L1",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(9,"颈长L2",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(10,"槽长L3",LVCFMT_LEFT,100);
	m_Drilllist.InsertColumn(11,"刀具图片地址",LVCFMT_LEFT,100);

	flag=0;
	
	tx_Drillbrand=GetDlgItem(IDC_EDIT6);
	tx_Drilldia=GetDlgItem(IDC_EDIT3);
	tx_Drillmaterial=GetDlgItem(IDC_EDIT5);
    tx_Drillname=GetDlgItem(IDC_EDIT2);
	tx_Flutelength=GetDlgItem(IDC_EDIT11);
	tx_Formaterial=GetDlgItem(IDC_EDIT7);
	tx_Necklength=GetDlgItem(IDC_EDIT9);
	tx_Overalllength=GetDlgItem(IDC_EDIT10);
	tx_Path=GetDlgItem(IDC_EDIT17);
	tx_Producer=GetDlgItem(IDC_EDIT12);
	tx_Shankdia=GetDlgItem(IDC_EDIT8);
	tx_ToolID=GetDlgItem(IDC_EDIT1);

	bt_add=GetDlgItem(IDC_DrillAdd);
	bt_save=GetDlgItem(IDC_DrillSave);
	bt_modify=GetDlgItem(IDC_DrillModify);
	bt_delete=GetDlgItem(IDC_DrillDelete);
    bt_browse=GetDlgItem(IDC_DrillBrowse);

    tx_Drillbrand->EnableWindow(false);
	tx_Drilldia->EnableWindow(false);
	tx_Drillmaterial->EnableWindow(false);
    tx_Drillname->EnableWindow(false);
	tx_Flutelength->EnableWindow(false);
	tx_Formaterial->EnableWindow(false);
	tx_Necklength->EnableWindow(false);
	tx_Overalllength->EnableWindow(false);
	tx_Path->EnableWindow(false);
	tx_Producer->EnableWindow(false);
	tx_Shankdia->EnableWindow(false);
	tx_ToolID->EnableWindow(false);
  	
	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
	bt_browse->EnableWindow(false);


//列表框数据初始化
	strQuery = "select * from tooldrill";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    int iCount = theApp.m_pADOSet->GetRecordCount();
	if (0==iCount) return 0;
	theApp.m_pADOSet->MoveFirst();
	for (int i=0; i<iCount; i++)
    {
		// Get toolid
		Holder = theApp.m_pADOSet->GetCollect("drillid");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.InsertItem(i, str);
	    // Get drillname
        Holder = theApp.m_pADOSet->GetCollect("drillname");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 1, str);
		// Get drilldia
        Holder = theApp.m_pADOSet->GetCollect("drilldia");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 2, str);
		// Get drillbrand
        Holder = theApp.m_pADOSet->GetCollect("drillmodel");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 3, str);
		// Get drillmateria
        Holder = theApp.m_pADOSet->GetCollect("drillmaterial");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 4, str);
		// Get formaterial
        Holder = theApp.m_pADOSet->GetCollect("formaterial");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 5, str);
		// Get producer
        Holder = theApp.m_pADOSet->GetCollect("producer");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 6, str);
    	// Get toolholderdia
        Holder = theApp.m_pADOSet->GetCollect("toolholderdia");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 7, str);
		// Get drilllength
        Holder = theApp.m_pADOSet->GetCollect("drilllength");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 8, str);
		// Get toolnecklength
        Holder = theApp.m_pADOSet->GetCollect("toolnecklength");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 9, str);
        // Get slitlength
        Holder = theApp.m_pADOSet->GetCollect("slitlength");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 10, str);
		// Get path
        Holder = theApp.m_pADOSet->GetCollect("drillpicdir");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Drilllist.SetItemText(i, 11, str);

		theApp.m_pADOSet->MoveNext();
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CTOOLDRILL::OnPaint() 
{
    CPaintDC dc(this); // device context for painting
	int x=330, y=280;
	int iWidth=400, iHeight=400;
	// TODO: Add your message handler code here
	if(!m_hBitmap)  //如果内存中没有BMP数据，则返回
		return;
	HBITMAP tmpBitmap;  //用于保存输出到屏幕的BMP数据
	CDC MemDC;  //CDC对象，用于输出到屏幕
	MemDC.CreateCompatibleDC(&dc);
	tmpBitmap = (HBITMAP)MemDC.SelectObject(m_hBitmap);
	dc.BitBlt(x,y,iWidth,iHeight,&MemDC,0,0,SRCCOPY);
	MemDC.SelectObject(tmpBitmap);
	
	
	// Do not call CDialog::OnPaint() for painting messages
}