page2.cpp

UG调用的动态链接数据库

// Page2.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// CPage2 property page

IMPLEMENT_DYNCREATE(CPage2, CPropertyPage)

CPage2::CPage2() : CPropertyPage(CPage2::IDD)
{
	//{{AFX_DATA_INIT(CPage2)
	m_axispower = 0.0f;
	m_axisspeed = 0.0f;
	m_axistype = _T("");
	m_coolant = _T("");
	m_machinename = _T("");
	m_machinetype = _T("");
	m_ncsystem = _T("");
	m_toolholder = _T("");
	//}}AFX_DATA_INIT
}

CPage2::~CPage2()
{
}

void CPage2::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPage2)
	DDX_Control(pDX, IDC_LIST1, m_listctrl);
	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_MACHINE, m_machinename);
	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(CPage2, CPropertyPage)
	//{{AFX_MSG_MAP(CPage2)
	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()

/////////////////////////////////////////////////////////////////////////////
// CPage2 message handlers

BOOL CPage2::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();
	
	CData_Machine *m_recordset = new CData_Machine(&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);
	this->Show();
	m_database.Close();	
	return TRUE;  
}

void CPage2::Show()
{
  m_listctrl.DeleteAllItems();
  CData_Machine *m_recordset = new CData_Machine(&m_database);
  CString strSQL;	
  strSQL.Format("select * from 机床参数表");
  m_recordset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
  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("%s",m_recordset->m_column3);
  m_listctrl.SetItemText(i,1,s);
  s.Format("%s",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("%s",m_recordset->m_column7);
  m_listctrl.SetItemText(i,5,s);
  s.Format("%s",m_recordset->m_column8);
  m_listctrl.SetItemText(i,6,s);
  s.Format("%s",m_recordset->m_column9);
  m_listctrl.SetItemText(i,7,s);		
  i++;
  m_recordset->MoveNext();		
  }  while(!m_recordset->IsEOF());
  m_database.Close();
 // return i;
}

void CPage2::OnAdd() 
{
	CData_Machine *m_recordset = new CData_Machine(&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_machinename;
	m_recordset->m_column3=m_machinetype;
	m_recordset->m_column4=m_axistype;
	m_recordset->m_column5=m_axispower;
	m_recordset->m_column6=m_axisspeed;
	m_recordset->m_column7=m_toolholder;
	m_recordset->m_column8=m_ncsystem;
	m_recordset->m_column9=m_coolant;
	m_recordset->Update();
    m_database.Close();
	m_listctrl.DeleteAllItems();
	this->Show();	
}

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



BOOL CPage2::OnSetActive() 
{
     Show();	// TODO: Add your specialized code here and/or call the base class
	
	return CPropertyPage::OnSetActive();
}

void CPage2::OnQuery() 
{
	CDialog_QueryMachine dlg;
	dlg.DoModal();
	
}

void CPage2::OnEdit() 
{  
	CDialog_EditMachine dlg;
	dlg.DoModal();
	
}