toolendmill.cpp

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

// TOOLENDMILL.cpp : implementation file
//

#include "stdafx.h"
#include "KNC_MIS.h"
#include "TOOLENDMILL.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CTOOLENDMILL dialog


CTOOLENDMILL::CTOOLENDMILL(CWnd* pParent /*=NULL*/)
	: CDialog(CTOOLENDMILL::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTOOLENDMILL)
	m_sEndmillid = _T("");
	m_sEndmilldia = _T("");
	m_sEndmillname = _T("");
	m_sEndmillmaterial = _T("");
	m_sEndmillbrand = _T("");
	m_sFormaterial = _T("");
	m_sProducer = _T("");
	m_sNecklength = _T("");
	m_sOveralllength = _T("");
	m_sShankdia = _T("");
	m_sFlutelength = _T("");
	m_sNeckdia = _T("");
	m_sAngle = _T("");
	m_sPath = _T("");
	//}}AFX_DATA_INIT
}


void CTOOLENDMILL::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTOOLENDMILL)
	DDX_Control(pDX, IDC_LIST2, m_Endmilllist);
	DDX_Text(pDX, IDC_EDIT1, m_sEndmillid);
	DDX_Text(pDX, IDC_EDIT12, m_sEndmilldia);
	DDX_Text(pDX, IDC_EDIT2, m_sEndmillname);
	DDX_Text(pDX, IDC_EDIT3, m_sEndmillmaterial);
	DDX_Text(pDX, IDC_EDIT6, m_sEndmillbrand);
	DDX_Text(pDX, IDC_EDIT5, m_sFormaterial);
	DDX_Text(pDX, IDC_EDIT13, m_sProducer);
	DDX_Text(pDX, IDC_EDIT14, m_sNecklength);
	DDX_Text(pDX, IDC_EDIT16, m_sOveralllength);
	DDX_Text(pDX, IDC_EDIT15, m_sShankdia);
	DDX_Text(pDX, IDC_EDIT18, m_sFlutelength);
	DDX_Text(pDX, IDC_EDIT19, m_sNeckdia);
	DDX_Text(pDX, IDC_EDIT20, m_sAngle);
	DDX_Text(pDX, IDC_EDIT17, m_sPath);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CTOOLENDMILL, CDialog)
	//{{AFX_MSG_MAP(CTOOLENDMILL)
	ON_BN_CLICKED(IDC_EndmillAdd, OnEndmillAdd)
	ON_BN_CLICKED(IDC_EndmillBrowse, OnEndmillBrowse)
	ON_BN_CLICKED(IDC_EndmillDelete, OnEndmillDelete)
	ON_BN_CLICKED(IDC_EndmillModify, OnEndmillModify)
	ON_BN_CLICKED(IDC_EndmillSave, OnEndmillSave)
	ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickList2)
	ON_WM_PAINT()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTOOLENDMILL message handlers

void CTOOLENDMILL::OnEndmillAdd() 
{
	// TODO: Add your control notification handler code here
		UpdateData(true);
	m_sAngle="";
	m_sEndmillbrand="";
	m_sEndmilldia="";
	m_sEndmillmaterial="";
   	m_sEndmillname="";
	m_sFlutelength="";
	m_sFormaterial="";
	m_sNecklength="";
	m_sOveralllength="";
	m_sPath="";
	m_sProducer="";
	m_sShankdia="";
	m_sEndmillid="";
	m_sNeckdia="";

    tx_Endmillbrand->EnableWindow(true);
	tx_Endmilldia->EnableWindow(true);
	tx_Endmillmaterial->EnableWindow(true);
    tx_Endmillname->EnableWindow(true);
	tx_Flutelength->EnableWindow(true);
	tx_Formaterial->EnableWindow(true);
	tx_Necklength->EnableWindow(true);
	tx_Overalllength->EnableWindow(true);
	tx_Path->EnableWindow(true);
	tx_Producer->EnableWindow(true);
	tx_Shankdia->EnableWindow(true);
	tx_Endmillid->EnableWindow(true);
	tx_Angle->EnableWindow(true);
	tx_Neckdia->EnableWindow(true);
	
	flag=1;
	bt_save->EnableWindow(true);
	bt_add->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
    bt_browse->EnableWindow(true);
	UpdateData(false);		
}

void CTOOLENDMILL::OnEndmillBrowse() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	static char BASED_CODE szFilter[] = "BMP Files (*.bmp)|*.bmp|All Files (*.*)|*.*||";
	CFileDialog dlg(TRUE,"BMP",NULL,  OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,szFilter);
	if(dlg.DoModal() != IDOK)
    return;
	CString pathname = dlg.GetPathName();
    m_sPath=dlg.GetPathName();
    UpdateData(false); 
		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();
}

void CTOOLENDMILL::OnEndmillDelete() 
{
	// TODO: Add your control notification handler code here
	// Del Records
    _variant_t  strQuery;
    strQuery = "select * from toolmill";
    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
 	POSITION pos = m_Endmilllist.GetFirstSelectedItemPosition();
    if ( pos == NULL ) 
 	{
 		AfxMessageBox(_T("没有选中的记录！"), MB_ICONEXCLAMATION);
		return;
 	}
     else
	{
 		int iItem;       
		CString sEndmillid;
		while (pos)
		{
            iItem = m_Endmilllist.GetNextSelectedItem(pos);
           sEndmillid = m_Endmilllist.GetItemText(iItem, 0);
		    strQuery = "delete from toolmill where millid='"+sEndmillid+"'";
	        theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    	m_Endmilllist.DeleteItem(iItem);
		}
 	}
 	m_sAngle="";
	m_sEndmillbrand="";
	m_sEndmilldia="";
	m_sEndmillmaterial="";
   	m_sEndmillname="";
	m_sFlutelength="";
	m_sFormaterial="";
	m_sNecklength="";
	m_sOveralllength="";
	m_sPath="";
	m_sProducer="";
	m_sShankdia="";
	m_sEndmillid="";
	m_sNeckdia="";
	bt_delete->EnableWindow(false);
	bt_modify->EnableWindow(false);
 	UpdateData(false);	
}

void CTOOLENDMILL::OnEndmillModify() 
{
	// TODO: Add your control notification handler code here	 tx_Endmillbrand->EnableWindow(true);
	tx_Endmilldia->EnableWindow(true);
	tx_Endmillmaterial->EnableWindow(true);
    tx_Endmillname->EnableWindow(true);
	tx_Flutelength->EnableWindow(true);
	tx_Formaterial->EnableWindow(true);
	tx_Necklength->EnableWindow(true);
	tx_Overalllength->EnableWindow(true);
	tx_Path->EnableWindow(true);
	tx_Producer->EnableWindow(true);
	tx_Shankdia->EnableWindow(true);
	tx_Endmillid->EnableWindow(true);
	tx_Angle->EnableWindow(true);
	tx_Neckdia->EnableWindow(true);
	flag=2;
	bt_save->EnableWindow(true);
	bt_delete->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_browse->EnableWindow(true);
}

void CTOOLENDMILL::OnEndmillSave() 
{
// TODO: Add your control notification handler code here
		UpdateData(true);
	// Make sure all needed info is available
	CString sWarning="";
	if ( ""==m_sEndmillid ) sWarning=_T("刀具编号");
    else if ( ""==m_sEndmillname) sWarning=_T("铣刀名称");
	else if ( ""==m_sEndmilldia) sWarning=_T("铣刀直径");
	else if ( ""==m_sEndmillbrand) sWarning=_T("铣刀型号");
	else if ( ""==m_sEndmillmaterial) sWarning=_T("刀具材料");
	else if ( ""==m_sFormaterial) sWarning=_T("适合加工材料");
	else if ( ""==m_sProducer) sWarning=_T("生产商");
	else if ( ""==m_sShankdia) sWarning=_T("刀柄直径");
	else if ( ""==m_sOveralllength) sWarning=_T("全长");
	else if ( ""==m_sNecklength) sWarning=_T("颈长");
	else if ( ""==m_sFlutelength) sWarning=_T("槽长");
    if ( ""!=sWarning ) 
	{
	   sWarning += _T("不能为空");
	   AfxMessageBox(sWarning, MB_ICONEXCLAMATION);
	   return;
	}
	_variant_t strQuery;
	if(flag==1)  //添加记录
	{
		// Judge Endmill is unique
	    strQuery = "select * from toolmill where millid='"+m_sEndmillid+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    int iCount = theApp.m_pADOSet->GetRecordCount();
	    if ( 0!=iCount )
		{
	       AfxMessageBox(_T("已经存在此刀具记录！"), MB_ICONEXCLAMATION);
	       return;
		}
	}
else if(flag==2)//修改
	{  //删除旧记录
		strQuery = "delete from toolmill where millid='"+m_sEndmillid+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	}
	// Insert Record
	strQuery = "insert toolmill (millid, millname, milldia,millmodel,millmaterial,formaterial,producer,toolholderdia,milllength,toolnecklength,cutedgelength,toolneckdia,interferenceangle,millpicdir) \
		        values ('"+m_sEndmillid+"', '"+m_sEndmillname+"', '"+m_sEndmilldia+"','"+m_sEndmillbrand+"','"+m_sEndmillmaterial+"','"+m_sFormaterial+"','"+m_sProducer+"','"+m_sShankdia+"','"+m_sOveralllength+"','"+m_sNecklength+"','"+m_sFlutelength+"','"+m_sNeckdia+"','"+m_sAngle+"','"+m_sPath+"')";
   int iItem;
  POSITION pos = m_Endmilllist.GetFirstSelectedItemPosition();
  iItem = m_Endmilllist.GetNextSelectedItem(pos);
	m_Endmilllist.DeleteItem(iItem);
	//更新列表框数据
	int j;
	j=m_Endmilllist.GetItemCount();
	m_Endmilllist.InsertItem(j, m_sEndmillid);
    m_Endmilllist.SetItemText(j, 1 , m_sEndmillname);
    m_Endmilllist.SetItemText(j, 2 , m_sEndmilldia);
	m_Endmilllist.SetItemText(j, 3 , m_sEndmillbrand);
    m_Endmilllist.SetItemText(j, 4 , m_sEndmillmaterial);