page4.cpp

UG调用的动态链接数据库

// Page4.cpp : implementation file
//

#include "stdafx.h"
#include "HiCut.h"
#include "Page4.h"
#include "Data_Tool.h"
#include "Deltoldlg.h"
#include "Dialog_EditTool.h"
#include "Dialog_QueryTool.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPage4 property page

IMPLEMENT_DYNCREATE(CPage4, CPropertyPage)

CPage4::CPage4() : CPropertyPage(CPage4::IDD)
{
	//{{AFX_DATA_INIT(CPage4)
	m_angle = 0.0f;
	m_length = 0.0f;
	m_paixiechangdu = 0.0f;
	m_paixiechaoshu = 0;
	m_radius = 0.0f;
	m_tooldiameter = 0.0f;
	m_toolmaterial = _T("");
	m_tooltype = _T("");
	m_toolname = _T("");
	//}}AFX_DATA_INIT
}

CPage4::~CPage4()
{
}

void CPage4::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPage4)
	DDX_Control(pDX, IDC_LIST1, m_listctrl);
	DDX_Text(pDX, IDC_EDIT_ANGLE, m_angle);
	DDX_Text(pDX, IDC_EDIT_LENGTH, m_length);
	DDX_Text(pDX, IDC_EDIT_PAIXIECHANGDU, m_paixiechangdu);
	DDX_Text(pDX, IDC_EDIT_PAIXIECHAOSHU, m_paixiechaoshu);
	DDX_Text(pDX, IDC_EDIT_RADIUS, m_radius);
	DDX_Text(pDX, IDC_EDIT_TOOLDIAMETER, m_tooldiameter);
	DDX_Text(pDX, IDC_EDIT_TOOLMATERIAL, m_toolmaterial);
	DDX_Text(pDX, IDC_EDIT_TOOLTYPE, m_tooltype);
	DDX_Text(pDX, IDC_EDIT_TOOLNAME, m_toolname);
	//}}AFX_DATA_MAP
}


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


/////////////////////////////////////////////////////////////////////////////
// CPage4 message handlers

void CPage4::OnAdd() 
{
    m_listctrl.DeleteAllItems();
	CData_Tool *m_recordset = new CData_Tool(&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_toolname;
	m_recordset->m_column3=m_tooltype;
	m_recordset->m_column4=m_tooldiameter;
	m_recordset->m_column5=m_radius;
	m_recordset->m_column6=m_angle;
	m_recordset->m_column7=m_length;
	m_recordset->m_column8=m_toolmaterial;
	m_recordset->m_column9=m_paixiechangdu;
	m_recordset->m_column10=m_paixiechaoshu;
	m_recordset->Update();
    m_database.Close();	
	this->Show();
}

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

	}
}


BOOL CPage4::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();
	
    CData_Tool *m_recordset = new CData_Tool(&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,100);
	m_listctrl.InsertColumn(3,"圆角半径",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(3,120);
	m_listctrl.InsertColumn(4,"刀尖锥角",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(4,70);
	m_listctrl.InsertColumn(5,"刀具总长",LVCFMT_LEFT,-1,-1);
	m_listctrl.SetColumnWidth(5,150);
	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 CPage4::Show()
{
  m_listctrl.DeleteAllItems();
  CData_Tool *m_recordset = new CData_Tool(&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("%s",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("%s",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("%.4f",m_recordset->m_column10);
  m_listctrl.SetItemText(i,8,s);
		
  i++;
  m_recordset->MoveNext();
		
  }  while(!m_recordset->IsEOF());
  m_database.Close();
  //return i;	
}

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

void CPage4::OnEdit() 
{
	CDialog_EditTool dlg;
	dlg.DoModal();	
}

void CPage4::OnQuery() 
{
	CDialog_QueryTool dlg;
	dlg.DoModal();	
}