codedlg.cpp

来自「基于SQLSERVER2000的机械工艺数据库系统」· C++ 代码 · 共 465 行

// CODEDLG.cpp : implementation file
//

#include "stdafx.h"
#include "KNC_MIS.h"
#include "CODEDLG.h"
#include "KNC_MISView.h"


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

/////////////////////////////////////////////////////////////////////////////
// CCODEDLG dialog


CCODEDLG::CCODEDLG(CWnd* pParent /*=NULL*/)
	: CDialog(CCODEDLG::IDD, pParent)
{
	//{{AFX_DATA_INIT(CCODEDLG)
	m_sCodecontent = _T("");
	m_sMachinetype = _T("");
	m_sCodenum = _T("");
	m_sPath = _T("");
	//}}AFX_DATA_INIT
}


void CCODEDLG::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCODEDLG)
	DDX_Control(pDX, IDC_LIST2, m_Codelist);
	DDX_Text(pDX, IDC_EDIT1, m_sCodecontent);
	DDX_Text(pDX, IDC_EDIT2, m_sMachinetype);
	DDX_Text(pDX, IDC_EDIT3, m_sCodenum);
	DDX_Text(pDX, IDC_EDIT17, m_sPath);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCODEDLG, CDialog)
	//{{AFX_MSG_MAP(CCODEDLG)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON4, OnButton4)
	ON_BN_CLICKED(IDC_EXIT, OnExit)
	ON_BN_CLICKED(IDC_Browse, OnBrowse)
	ON_BN_CLICKED(IDC_SAVE, OnSave)
	ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickList2)
	ON_BN_CLICKED(IDC_shanchu, Onshanchu)
	ON_WM_PAINT()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCODEDLG message handlers

void CCODEDLG::OnButton3() //ADD
{
	// TODO: Add your control notification handler code here
		UpdateData(true);
	
	m_sCodenum="";
	m_sMachinetype="";
	m_sCodecontent="";
    m_sPath="";
	tx_codenum->EnableWindow(true);
	tx_codecontent->EnableWindow(true);
	tx_machinetype->EnableWindow(true);
    tx_path->EnableWindow(true);
	flag=1;
	bt_save->EnableWindow(true);
	bt_browse->EnableWindow(true);
	bt_add->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_shanchu->EnableWindow(false);
	UpdateData(false);		
}

void CCODEDLG::OnButton4() //修改
{
	// TODO: Add your control notification handler code here
	tx_codenum->EnableWindow(true);
	tx_codecontent->EnableWindow(true);
	tx_machinetype->EnableWindow(true);

	flag=2;
	bt_save->EnableWindow(true);
	bt_browse->EnableWindow(true);
	bt_shanchu->EnableWindow(false);
	bt_modify->EnableWindow(false);

}


BOOL CCODEDLG::OnInitDialog() 
{
    CDialog::OnInitDialog();
	_variant_t strQuery, Holder;
	CString str;
	DWORD style;
	style=m_Codelist.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_Codelist.SetExtendedStyle(style);
	m_sOldCodenum = m_sCodenum;
	// Set Color
	//m_Codelist.SetBkColor(RGB(177, 151, 240));
//	m_Codelist.SetTextColor(RGB(0,0,0));
//	m_Codelist.SetTextBkColor(RGB(177, 151, 240));
    // 设置表字段
	m_Codelist.InsertColumn(0,"加工类型",LVCFMT_LEFT,100);
	m_Codelist.InsertColumn(1,"程序号",LVCFMT_LEFT,100);
	m_Codelist.InsertColumn(2,"加工代码",LVCFMT_LEFT,100);
	m_Codelist.InsertColumn(3,"示意图路径",LVCFMT_LEFT,100);



	flag=0;
	
	tx_codecontent=GetDlgItem(IDC_EDIT1);
	tx_codenum=GetDlgItem(IDC_EDIT3);
	tx_machinetype=GetDlgItem(IDC_EDIT2);
	tx_path=GetDlgItem(IDC_EDIT17);
	bt_add=GetDlgItem(IDC_BUTTON3);
	bt_save=GetDlgItem(IDC_SAVE);
	bt_modify=GetDlgItem(IDC_BUTTON4);
	bt_shanchu=GetDlgItem(IDC_shanchu);
	bt_browse=GetDlgItem(IDC_Browse);

	tx_codecontent->EnableWindow(false);
	tx_codenum->EnableWindow(false);
	tx_machinetype->EnableWindow(false);
	tx_path->EnableWindow(false);
  	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_shanchu->EnableWindow(false);
	bt_browse->EnableWindow(false);


//列表框数据初始化

	strQuery = "select * from code";
	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 codename
		Holder = theApp.m_pADOSet->GetCollect("codename");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Codelist.InsertItem(i, str);
	    // Get codeid
        Holder = theApp.m_pADOSet->GetCollect("codeid");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Codelist.SetItemText(i, 1, str);
		// Get codecontent
        Holder = theApp.m_pADOSet->GetCollect("codecontent");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Codelist.SetItemText(i, 2, str);
		// Get codepicdir
        Holder = theApp.m_pADOSet->GetCollect("codepicdir");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Codelist.SetItemText(i, 3, 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 CCODEDLG::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	POSITION pos = m_Codelist.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_Codelist.GetNextSelectedItem(pos);
		m_sMachinetype=m_Codelist.GetItemText(nFirstSelItem,0);
		m_sCodenum=m_Codelist.GetItemText(nFirstSelItem,1);
       // m_sCodecontent=m_Codelist.GetItemText(nFirstSelItem,2);
		m_sPath=m_Codelist.GetItemText(nFirstSelItem,3);
	    _variant_t strQueryq,Holder;
		strQueryq = "select * from code where codeid='"+m_sCodenum+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQueryq);
		Holder = theApp.m_pADOSet->GetCollect("codecontent");
	    m_sCodecontent = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;

	}
	//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_shanchu->EnableWindow(true);
	bt_modify->EnableWindow(true);

	UpdateData(false);


	*pResult = 0;

}

void CCODEDLG::OnSave() 
{
	// TODO: Add extra validation here
	UpdateData(true);
	// Make sure all needed info is available
	CString sWarning="";
	if ( ""==m_sMachinetype ) sWarning=_T("加工类型");
    else if ( ""==m_sCodenum ) sWarning=_T("程序号");
	else if ( ""==m_sCodecontent ) sWarning=_T("加工代码");

    if ( ""!=sWarning ) 
	{
	   sWarning += _T("不能为空");
	   AfxMessageBox(sWarning, MB_ICONEXCLAMATION);
	   return;
	}
	_variant_t strQuery;
	if(flag==1)  //添加记录
	{
		// Judge Code is unique
	    strQuery = "select * from code where codeid='"+m_sCodenum+"'";
	    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 code where codeid='"+m_sCodenum+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	}
	// Insert Record
	strQuery = "insert code (codename, codeid, codecontent, codepicdir) \
		        values ('"+m_sMachinetype+"', '"+m_sCodenum+"', '"+m_sCodecontent+"', '"+m_sPath+"')";
  int iItem;
  POSITION pos = m_Codelist.GetFirstSelectedItemPosition();
  iItem = m_Codelist.GetNextSelectedItem(pos);
	m_Codelist.DeleteItem(iItem);  
	//更新列表框数据
	int j;
	j=m_Codelist.GetItemCount();
	m_Codelist.InsertItem(j, m_sMachinetype);
	m_Codelist.SetItemText(j, 1 , m_sCodenum);
    m_Codelist.SetItemText(j, 2 , m_sCodecontent);
    m_Codelist.SetItemText(j, 3 , m_sPath);

	if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
	{
	    if (flag==1) 
		{
			AfxMessageBox(_T("添加加工代码成功！"), MB_ICONINFORMATION);
	        // Clear all input
            m_sCodenum=m_sMachinetype=m_sCodenum=m_sCodecontent="";
            UpdateData(false);
		}
		else AfxMessageBox(_T("修改加工代码成功！"), MB_ICONINFORMATION);
	}
	else 
	{
		if (flag==1) AfxMessageBox(_T("添加加工代码失败！"), MB_ICONEXCLAMATION);
		else AfxMessageBox(_T("修改加工代码失败！"), MB_ICONEXCLAMATION);
	}
    
	tx_codecontent->EnableWindow(false);
	tx_codenum->EnableWindow(false);
	tx_machinetype->EnableWindow(false);
	tx_path->EnableWindow(false);
	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(true);
	bt_shanchu->EnableWindow(true);

}

void CCODEDLG::OnExit() 
{
	// TODO: Add your control notification handler code here
	this->OnCancel();
}



void CCODEDLG::OnBrowse() 
{
	// 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 CCODEDLG::Onshanchu() 
{
	// TODO: Add your control notification handler code here
	// Del Records
 	_variant_t  strQuery;
          strQuery = "select * from code";
		 theApp.ADOExecute(theApp.m_pADOSet, strQuery);
 	POSITION pos = m_Codelist.GetFirstSelectedItemPosition();
    if ( pos == NULL ) 
 	{
 		AfxMessageBox(_T("没有选中的记录！"), MB_ICONEXCLAMATION);
		return;
 	}
     else
	{
 		int iItem;       
		CString sCodename;
		while (pos)
		{
            iItem = m_Codelist.GetNextSelectedItem(pos);
           sCodename = m_Codelist.GetItemText(iItem, 0);
		    strQuery = "delete from code where codename='"+sCodename+"'";
	        theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    	m_Codelist.DeleteItem(iItem);
		}
 	}
 		
 	m_sCodenum="";
 	m_sMachinetype="";
 	m_sCodecontent="";
     m_sPath="";
 	UpdateData(false);	
}

void CCODEDLG::OnPaint() 
{
    CPaintDC dc(this); // device context for painting
	int x=15, y=130;
	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
}