page3.cpp

UG调用的动态链接数据库

// Page3.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "Page3.h"
#include "Data_Material.h"
#include "Delmatdlg.h"
#include "Dialog_EditMaterial.h"
#include "Dialog_QueryMaterial.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPage3 property page

IMPLEMENT_DYNCREATE(CPage3, CPropertyPage)

CPage3::CPage3() : CPropertyPage(CPage3::IDD)
{
	//{{AFX_DATA_INIT(CPage3)
	m_comment = _T("");
	m_density = 0.0f;
	m_conductance = 0.0f;
	m_elastic = 0.0f;
	m_expand = 0.0f;
	m_hardness = 0.0f;
	m_material = _T("");
	m_possion = 0.0f;
	m_capacitance = 0.0f;
	//}}AFX_DATA_INIT
}

CPage3::~CPage3()
{
}

void CPage3::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPage3)
	DDX_Control(pDX, IDC_LIST1, m_listctrl);
	DDX_Text(pDX, IDC_EDIT_COMMENT, m_comment);
	DDX_Text(pDX, IDC_EDIT_DENSITY, m_density);
	DDX_Text(pDX, IDC_EDIT_CONDUCTANCE, m_conductance);
	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_MATERIAL, m_material);
	DDX_Text(pDX, IDC_EDIT_POSSION, m_possion);
	DDX_Text(pDX, IDC_EDIT_THERMALCONPACITANCE, m_capacitance);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPage3, CPropertyPage)
	//{{AFX_MSG_MAP(CPage3)
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	ON_BN_CLICKED(IDC_EDIT, OnEdit)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()


/////////////////////////////////////////////////////////////////////////////
// CPage3 message handlers

void CPage3::OnAdd() 
{
    m_listctrl.DeleteAllItems();
	CData_Material *m_recordset = new CData_Material(&m_database);
	CString strSQL;	
    strSQL.Format("select * from 模具材料表");
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	UpdateData(TRUE);
	m_recordset->AddNew();
	m_recordset->m_column2=m_material;
	m_recordset->m_column3=m_elastic;
	m_recordset->m_column4=m_possion;
	m_recordset->m_column5=m_hardness;
	m_recordset->m_column6=m_density;
	m_recordset->m_column7=m_capacitance;
	m_recordset->m_column8=m_expand;
	m_recordset->m_column9=m_conductance;
	m_recordset->m_column10=m_comment;
	m_recordset->Update();
    m_database.Close();
	this->Show();
}

void CPage3::OnDelete() 
{
    CDelmatdlg dlg;
    if(dlg.DoModal()==IDOK)
	{
		MessageBox("删除成功");
        Show();

	}
}

BOOL CPage3::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();
	CData_Material *m_recordset = new CData_Material(&m_database);
	m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[模具材料表]");
	m_listctrl.SetExtendedStyle(LVS_EX_GRIDLINES);
	m_listctrl.SetBkColor(RGB(0xFF,0xff,0xFF));
	m_listctrl.InsertColumn(0,"材料牌号",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(0,100);
	m_listctrl.InsertColumn(1,"弹性模量",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(1,100);
	m_listctrl.InsertColumn(2,"泊松比",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(2,120);
	m_listctrl.InsertColumn(3,"加工硬度",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(3,70);
	m_listctrl.InsertColumn(4,"密度",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(4,150);
	m_listctrl.InsertColumn(5,"比热容",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(5,70);
	m_listctrl.InsertColumn(6,"线胀系数",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(6,70);
	m_listctrl.InsertColumn(7,"热导率",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(7,70);
	m_listctrl.InsertColumn(8,"备注",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(8,70);	


	this->Show();
	m_database.Close();
	return TRUE;  
}

void CPage3::Show()
{
  m_listctrl.DeleteAllItems();
  CData_Material *m_recordset = new CData_Material(&m_database);
  m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,"[模具材料表]");
  int i=0;
  m_recordset->MoveFirst();
  do
  {  
  CString s;
  m_listctrl.InsertItem(i,s,0);
  
  s.Format("%s",m_recordset->m_column2);
  m_listctrl.SetItemText(i,0,s);
  s.Format("%.4f",m_recordset->m_column3);
  m_listctrl.SetItemText(i,1,s);
  s.Format("%.4f",m_recordset->m_column4);
  m_listctrl.SetItemText(i,2,s);
  s.Format("%.4f",m_recordset->m_column5);
  m_listctrl.SetItemText(i,3,s);
  s.Format("%.4f",m_recordset->m_column6);
  m_listctrl.SetItemText(i,4,s);
  s.Format("%.4f",m_recordset->m_column7);
  m_listctrl.SetItemText(i,5,s);
  s.Format("%.4f",m_recordset->m_column8);
  m_listctrl.SetItemText(i,6,s);
  s.Format("%.4f",m_recordset->m_column9);
  m_listctrl.SetItemText(i,7,s);
  s.Format("%s",m_recordset->m_column10);
  m_listctrl.SetItemText(i,8,s);
		
  i++;
  m_recordset->MoveNext();
		
  }  while(!m_recordset->IsEOF());
  m_database.Close();
  //return i;
}

BOOL CPage3::OnSetActive() 
{
    this->Show();
	return CPropertyPage::OnSetActive();
}

void CPage3::OnQuery() 
{
	CDialog_QueryMaterial dlg;
	dlg.DoModal();	
}

void CPage3::OnEdit() 
{
	CDialog_EditMaterial dlg;
	dlg.DoModal();	
}