dialog_edittool.cpp

UG调用的动态链接数据库

// Dialog_EditTool.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "Dialog_EditTool.h"
#include "Data_Tool.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialog_EditTool dialog


CDialog_EditTool::CDialog_EditTool(CWnd* pParent /*=NULL*/)
	: CDialog(CDialog_EditTool::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialog_EditTool)
	m_angle = 0.0f;
	m_length = 0.0f;
	m_paixiechangdu = 0.0f;
	m_paixiechaoshu = 0;
	m_radius = 0.0f;
	m_tooldiameter = 0.0f;
	m_toolmaterial = _T("");
	m_tooltype = _T("");
	//}}AFX_DATA_INIT
}


void CDialog_EditTool::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialog_EditTool)
	DDX_Control(pDX, IDC_COMBO4, m_com_tool);
	DDX_Text(pDX, IDC_EDIT_ANGLE, m_angle);
	DDX_Text(pDX, IDC_EDIT_LENGTH, m_length);
	DDX_Text(pDX, IDC_EDIT_PAIXIECHANGDU, m_paixiechangdu);
	DDX_Text(pDX, IDC_EDIT_PAIXIECHAOSHU, m_paixiechaoshu);
	DDX_Text(pDX, IDC_EDIT_RADIUS, m_radius);
	DDX_Text(pDX, IDC_EDIT_TOOLDIAMETER, m_tooldiameter);
	DDX_Text(pDX, IDC_EDIT_TOOLMATERIAL, m_toolmaterial);
	DDX_Text(pDX, IDC_EDIT_TOOLTYPE, m_tooltype);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialog_EditTool, CDialog)
	//{{AFX_MSG_MAP(CDialog_EditTool)
	ON_CBN_SELCHANGE(IDC_COMBO4, OnSelchange)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialog_EditTool message handlers

BOOL CDialog_EditTool::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	
	ShowCombox();// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CDialog_EditTool::ShowCombox()
{
	int n;
	CDatabase m_database;
	int i,j;
    CString Fieldstr,Fieldstr1;
	CData_Tool *m_recordset3 = new CData_Tool(&m_database);
	m_recordset3->Open(AFX_DB_USE_DEFAULT_TYPE,"[刀具几何表]");
//计算总共的记录数
    m_recordset3->MoveFirst();
	if(m_recordset3->IsEOF())
		n=1;
	else
	{
		for(n=0;!(m_recordset3->IsEOF());n++)
		{
		m_recordset3->MoveNext();
 	
		}
	}
    m_com_tool.ResetContent();
	m_recordset3->MoveFirst();
	Fieldstr.Format("%s",m_recordset3->m_column2);
	m_com_tool.AddString(Fieldstr);	
	if(n>=2)
	{
		for(i=1;i<n;i++)
		{
			int key=0;
			m_recordset3->MoveFirst();
			m_recordset3->Move(i);
		    Fieldstr.Format("%s",m_recordset3->m_column2);
		    for(j=0;j<i;j++)
			{
			 m_recordset3->MoveFirst();
		     m_recordset3->Move(j);
             Fieldstr1.Format("%s",m_recordset3->m_column2);
			 if(Fieldstr.Compare(Fieldstr1)==0)
				 key=1;
			}
			if(key==0)
				m_com_tool.AddString(Fieldstr);
		}
	}
	m_database.Close();	
//com_tooldiameter
}

void CDialog_EditTool::OnSelchange() 
{
    CDatabase m_database;
    CData_Tool *m_recordset = new CData_Tool(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[刀具几何表]");	
	CString m_tool;
	m_com_tool.GetWindowText(m_tool);
	m_recordset->MoveFirst();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_tool)
		{
        	m_angle         = m_recordset->m_column6;
         	m_length        = m_recordset->m_column7;
           	m_paixiechangdu = m_recordset->m_column9;
           	m_paixiechaoshu = m_recordset->m_column10;
         	m_radius        = m_recordset->m_column5;
        	m_tooldiameter  = m_recordset->m_column4;
        	m_toolmaterial  = m_recordset->m_column8;
        	m_tooltype      = m_recordset->m_column3;
				UpdateData(FALSE);
				return;
		}
	
	}
	
}

void CDialog_EditTool::OnOK() 
{
	CDatabase m_database;
    CData_Tool *m_recordset = new CData_Tool(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[刀具几何表]");	
	CString m_tool;
	m_com_tool.GetWindowText(m_tool);
	m_recordset->MoveFirst();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_tool)
		{
			m_recordset->Edit();
        	m_recordset->m_column6 = m_angle;
         	m_recordset->m_column7 = m_length ;
            m_recordset->m_column9 = m_paixiechangdu ;
            m_recordset->m_column10 = m_paixiechaoshu ;
            m_recordset->m_column5 = m_radius ;
        	m_recordset->m_column4 = m_tooldiameter;
            m_recordset->m_column8 = m_toolmaterial;
            m_recordset->m_column3 = m_tooltype ;
			if(!m_recordset->Update())
				AfxMessageBox("修改记录失败!");
				UpdateData(FALSE);
				return;
		}
	// TODO: Add extra validation here
	
	CDialog::OnOK();
	}
}