deltoldlg.cpp

UG调用的动态链接数据库

// Deltoldlg.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CDeltoldlg dialog


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


void CDeltoldlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDeltoldlg)
	DDX_Control(pDX, IDC_COM_TOOLTYPE, m_com_tooltype);
	DDX_Control(pDX, IDC_COM_TOOLDIAMETER, m_com_tooldiameter);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDeltoldlg, CDialog)
	//{{AFX_MSG_MAP(CDeltoldlg)
	ON_CBN_SELCHANGE(IDC_COM_TOOLTYPE, OnSelchangeComTooltype)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDeltoldlg message handlers

void CDeltoldlg::OnOK() 
{
	CString m_tooltype,m_tooldiameter,s_tooldiameter;
	m_com_tooltype.GetWindowText(m_tooltype);
	m_com_tooldiameter.GetWindowText(m_tooldiameter);
    CData_Tool *m_recordset = new CData_Tool(&m_database);
    m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[刀具几何表]");
	for(m_recordset->MoveFirst();!(m_recordset->IsEOF());m_recordset->MoveNext())
	{   
		s_tooldiameter.Format("%.4f",m_recordset->m_column3);
		if(m_recordset->m_column2==m_tooltype&&s_tooldiameter==m_tooldiameter)
			m_recordset->Delete();
	}
	CDialog::OnOK();
}

BOOL CDeltoldlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
    /////对Combox进行初始化设置
	CData_Tool *m_recordset = new CData_Tool(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[刀具几何表]");
//计算总共的记录数
    m_recordset->MoveFirst();
	if(m_recordset->IsEOF())
		n=1;
	else
	{
		for(n=0;!(m_recordset->IsEOF());n++)//记录的条数
		{
		m_recordset->MoveNext();
 	
		}
	}
//com_tool
	CString Fieldstr, Fieldstr1;
	m_recordset->MoveFirst();
	Fieldstr.Format("%s",m_recordset->m_column2);
	m_com_tooltype.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_tooltype.AddString(Fieldstr);
		}
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CDeltoldlg::OnSelchangeComTooltype() 
{
    m_com_tooldiameter.ResetContent();
	//
	int i,j;
	CString s_tooltype,fieldstr,fieldstr1,fieldstr2,fieldstr3;
	CData_Tool *m_recordset = new CData_Tool(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[刀具几何表]");
	m_com_tooltype.GetWindowText(s_tooltype);
	if(n==1)
	{
		if(s_tooltype.Compare(m_recordset->m_column2)==0)
			fieldstr.Format("%s",m_recordset->m_column3);
			m_com_tooldiameter.AddString(fieldstr);
	}
	else
	{
    for(i=0;i<n;i++)
	{			
			m_recordset->MoveFirst();
			m_recordset->Move(i);
			fieldstr2.Format("%s",m_recordset->m_column2);
		    fieldstr.Format("%.4f",m_recordset->m_column3);
			if(s_tooltype.Compare(fieldstr2)==0)
			{
				int key=0;
		        for(j=0;j<i;j++)
				{
			        m_recordset->MoveFirst();
		            m_recordset->Move(j);
                    fieldstr1.Format("%.4f",m_recordset->m_column3);
                    fieldstr3.Format("%s",m_recordset->m_column2);
			        if(s_tooltype.Compare(fieldstr3)==0)
					{
						if(fieldstr.Compare(fieldstr1)==0)
                        key=1;
					}
				    
				}
				if(key==0)
			    m_com_tooldiameter.AddString(fieldstr);

			}			

	}			
	}
}