dialog_editmachine.cpp

UG调用的动态链接数据库

// Dialog_EditMachine.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "Dialog_EditMachine.h"
#include "Data_Machine.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialog_EditMachine dialog


CDialog_EditMachine::CDialog_EditMachine(CWnd* pParent /*=NULL*/)
	: CDialog(CDialog_EditMachine::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialog_EditMachine)
	m_axispower = 0.0f;
	m_axisspeed = 0.0f;
	m_axistype = _T("");
	m_coolant = _T("");
	m_machinetype = _T("");
	m_ncsystem = _T("");
	m_toolholder = _T("");
	//}}AFX_DATA_INIT
}


void CDialog_EditMachine::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialog_EditMachine)
	DDX_Control(pDX, IDC_COMBO1, m_com_machine);
	DDX_Text(pDX, IDC_EDIT_AXISPOWER, m_axispower);
	DDX_Text(pDX, IDC_EDIT_AXISSPEED, m_axisspeed);
	DDX_Text(pDX, IDC_EDIT_AXISTYPE, m_axistype);
	DDX_Text(pDX, IDC_EDIT_COOLANT, m_coolant);
	DDX_Text(pDX, IDC_EDIT_MACHINETYPE, m_machinetype);
	DDX_Text(pDX, IDC_EDIT_NCSYSTEM, m_ncsystem);
	DDX_Text(pDX, IDC_EDIT_TOOLHOLDER, m_toolholder);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDialog_EditMachine, CDialog)
	//{{AFX_MSG_MAP(CDialog_EditMachine)
	ON_CBN_SELCHANGE(IDC_COMBO1, OnSelchange)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDialog_EditMachine message handlers

BOOL CDialog_EditMachine::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_EditMachine::ShowCombox()
{
	//com_machine
	int n;
	CDatabase m_database;
	CData_Machine *m_recordset = new CData_Machine(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[机床参数表]");	
	int i,j;
    CString Fieldstr,Fieldstr1;
//计算总共的记录数
    m_recordset->MoveFirst();
	if(m_recordset->IsEOF())
		n=1;
	else
	{
		for(n=0;!(m_recordset->IsEOF());n++)
		{
		m_recordset->MoveNext();
 	
		}
	}
//	
	m_com_machine.ResetContent();
	m_recordset->MoveFirst();
	Fieldstr.Format("%s",m_recordset->m_column2);
	m_com_machine.AddString(Fieldstr);	
	if(n>=2)
	{
		for(i=1;i<n;i++)
		{
			int key=0;
			m_recordset->MoveFirst();
			m_recordset->Move(i);
		    Fieldstr.Format("%s",m_recordset->m_column2);
		    for(j=0;j<i;j++)
			{
			 m_recordset->MoveFirst();
		     m_recordset->Move(j);
             Fieldstr1.Format("%s",m_recordset->m_column2);
			 if(Fieldstr.Compare(Fieldstr1)==0)
				 key=1;
			}
			if(key==0)
				m_com_machine.AddString(Fieldstr);
		}
	}

}

void CDialog_EditMachine::OnSelchange() 
{

	CDatabase m_database;
    CData_Machine *m_recordset = new CData_Machine(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[机床参数表]");	
	CString m_machine;
	m_com_machine.GetWindowText(m_machine);
	m_recordset->MoveFirst();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_machine)
		{
				m_axispower   = m_recordset->m_column5;
	            m_axisspeed   = m_recordset->m_column6;
	            m_axistype    = m_recordset->m_column4;
	            m_coolant     = m_recordset->m_column9;
              	m_machinetype = m_recordset->m_column3;
	            m_ncsystem    = m_recordset->m_column8;
	            m_toolholder  = m_recordset->m_column7;
				UpdateData(FALSE);
				return;
		}
       
	}

}

void CDialog_EditMachine::OnOK() 
{
	CDatabase m_database;
    CData_Machine *m_recordset = new CData_Machine(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[机床参数表]");	
	CString m_machine;
	m_com_machine.GetWindowText(m_machine);
	m_recordset->MoveFirst();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_machine)
		{
			m_recordset->Edit();
				   m_recordset->m_column5 =m_axispower;
	               m_recordset->m_column6 =m_axisspeed;
	               m_recordset->m_column4 =m_axistype;
	               m_recordset->m_column9 =m_coolant;
              	   m_recordset->m_column3 =m_machinetype;
	               m_recordset->m_column8 =m_ncsystem;
	               m_recordset->m_column7 =m_toolholder;
			if(!m_recordset->Update())
				AfxMessageBox("修改记录失败!");
				UpdateData(FALSE);
				return;
		}
       
	}
	
	CDialog::OnOK();
}