dialog_editmaterial.cpp

UG调用的动态链接数据库

// Dialog_EditMaterial.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "Dialog_EditMaterial.h"
#include "Data_Material.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDialog_EditMaterial dialog


CDialog_EditMaterial::CDialog_EditMaterial(CWnd* pParent /*=NULL*/)
	: CDialog(CDialog_EditMaterial::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDialog_EditMaterial)
	m_comment = _T("");
	m_conductance = 0.0f;
	m_density = 0.0f;
	m_elastic = 0.0f;
	m_expand = 0.0f;
	m_hardness = 0.0f;
	m_possion = 0.0f;
	m_thermalconpacitance = 0.0f;
	//}}AFX_DATA_INIT
}


void CDialog_EditMaterial::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDialog_EditMaterial)
	DDX_Control(pDX, IDC_COMBO1, m_com_material);
	DDX_Text(pDX, IDC_EDIT_COMMENT, m_comment);
	DDX_Text(pDX, IDC_EDIT_CONDUCTANCE, m_conductance);
	DDX_Text(pDX, IDC_EDIT_DENSITY, m_density);
	DDX_Text(pDX, IDC_EDIT_ELASTIC, m_elastic);
	DDX_Text(pDX, IDC_EDIT_EXPAND, m_expand);
	DDX_Text(pDX, IDC_EDIT_HARDNESS, m_hardness);
	DDX_Text(pDX, IDC_EDIT_POSSION, m_possion);
	DDX_Text(pDX, IDC_EDIT_THERMALCONPACITANCE, m_thermalconpacitance);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDialog_EditMaterial message handlers

BOOL CDialog_EditMaterial::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_EditMaterial::ShowCombox()
{
	int n;
	CDatabase m_database;
	int i,j;
    CString Fieldstr,Fieldstr1;
	CData_Material *m_recordset1 = new CData_Material(&m_database);
	m_recordset1->Open(AFX_DB_USE_DEFAULT_TYPE,"[模具材料表]");	
	
    m_recordset1->MoveFirst();
	if(m_recordset1->IsEOF())
		n=1;
	else
	{
		for(n=0;!(m_recordset1->IsEOF());n++)
		{
		m_recordset1->MoveNext();
 	
		}
	}
//
	m_com_material.ResetContent();
	m_recordset1->MoveFirst();
	Fieldstr.Format("%s",m_recordset1->m_column2);
	m_com_material.AddString(Fieldstr);	
	if(n>=2)
	{
		for(i=1;i<n;i++)
		{
			int key=0;
			m_recordset1->MoveFirst();
			m_recordset1->Move(i);
		    Fieldstr.Format("%s",m_recordset1->m_column2);
		    for(j=0;j<i;j++)
			{
			 m_recordset1->MoveFirst();
		     m_recordset1->Move(j);
             Fieldstr1.Format("%s",m_recordset1->m_column2);
			 if(Fieldstr.Compare(Fieldstr1)==0)
				 key=1;
			}
			if(key==0)
				m_com_material.AddString(Fieldstr);
		}
	}
}

void CDialog_EditMaterial::OnSelchange() 
{
    CDatabase m_database;
    CData_Material *m_recordset = new CData_Material(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[模具材料表]");	
	CString m_material;
	m_com_material.GetWindowText(m_material);
	m_recordset->MoveFirst();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_material)
		{
	            m_comment     = m_recordset->m_column10;
	            m_conductance = m_recordset->m_column9;
	            m_density     = m_recordset->m_column6;
             	m_elastic     = m_recordset->m_column3;
             	m_expand      = m_recordset->m_column7;
            	m_hardness    = m_recordset->m_column5;
            	m_possion     = m_recordset->m_column4;
            	m_thermalconpacitance = m_recordset->m_column8;
				UpdateData(FALSE);
				return;
		}
	
	}
}

void CDialog_EditMaterial::OnOK() 
{
    CDatabase m_database;
    CData_Material *m_recordset = new CData_Material(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[模具材料表]");	
	CString m_material;
	m_com_material.GetWindowText(m_material);
	m_recordset->MoveFirst();
	for(m_recordset->MoveFirst();!m_recordset->IsEOF();m_recordset->MoveNext())
	{
		if(m_recordset->m_column2==m_material)
		{
			m_recordset->Update();
	             m_recordset->m_column10=m_comment;
	             m_recordset->m_column9=m_conductance;
	             m_recordset->m_column6=m_density;
             	 m_recordset->m_column3=m_elastic;
             	 m_recordset->m_column7=m_expand;
            	 m_recordset->m_column5=m_hardness;
            	 m_recordset->m_column4=m_possion;
            	 m_recordset->m_column8=m_thermalconpacitance;
			if(!m_recordset->Update())
				AfxMessageBox("修改数据失败!");
				UpdateData(FALSE);
				return;
		}
	
	}
	
	CDialog::OnOK();
}