delmacdlg.cpp

UG调用的动态链接数据库

// Delmacdlg.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "Delmacdlg.h"
#include "Data_Machine.h"
#include "Page2.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDelmacdlg dialog


CDelmacdlg::CDelmacdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDelmacdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDelmacdlg)
	//}}AFX_DATA_INIT
}


void CDelmacdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDelmacdlg)
	DDX_Control(pDX, IDC_COMBO1, m_com_machine);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDelmacdlg, CDialog)
	//{{AFX_MSG_MAP(CDelmacdlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDelmacdlg message handlers

void CDelmacdlg::OnOK() 
{
	CDialog::OnOK();
	CData_Machine *m_recordset = new CData_Machine(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[机床参数表]");
	UpdateData(TRUE);
	m_com_machine.GetWindowText(m_machine);
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_machine)
		{
			m_recordset->Delete();
			m_recordset->Requery();
		}

	
	}

}

BOOL CDelmacdlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
/////对Combox进行初始化设置
	CData_Machine *m_recordset = new CData_Machine(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[机床参数表]");
//计算总共的记录数
	int n;
    m_recordset->MoveFirst();
	if(m_recordset->IsEOF())
		n=1;
	else
	{
		for(n=0;!(m_recordset->IsEOF());n++)//记录的条数
		{
		m_recordset->MoveNext();
 	
		}
	}
//com_machine
	CString Fieldstr, Fieldstr1;
	m_recordset->MoveFirst();
	Fieldstr.Format("%s",m_recordset->m_column2);
	m_com_machine.AddString(Fieldstr);	
	if(n>=2)
	{
		for(int i=1;i<n;i++)
		{
			int key=0;//用来判断是不是唯一
			m_recordset->MoveFirst();
			m_recordset->Move(i);
		    Fieldstr.Format("%s",m_recordset->m_column2);
		    for(int j=0;j<i;j++)
			{
			 m_recordset->MoveFirst();
		     m_recordset->Move(j);
             Fieldstr1.Format("%s",m_recordset->m_column2);
			 if(Fieldstr.Compare(Fieldstr1)==0)//字符串相同的时候返回0
				 key=1;
			}
			if(key==0)
				m_com_machine.AddString(Fieldstr);
		}
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}