paradrill.cpp

基于SQLSERVER2000的机械工艺数据库系统

// PARADRILL.cpp : implementation file
//

#include "stdafx.h"
#include "knc_mis.h"
#include "PARADRILL.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPARADRILL dialog


CPARADRILL::CPARADRILL(CWnd* pParent /*=NULL*/)
	: CDialog(CPARADRILL::IDD, pParent)
{
	//{{AFX_DATA_INIT(CPARADRILL)
	m_sID = _T("");
	m_sDia = _T("");
	m_sMotorspeed = _T("");
	m_sCutdepth = _T("");
	m_sFeedrate = _T("");
	m_sRoughness = _T("");
	m_sPismaterial = _T("");
	m_sTool = _T("");
	m_sToolneed = _T("");
	m_sPismaterialneed = _T("");
	m_sDianeed = _T("");
	//}}AFX_DATA_INIT
}


void CPARADRILL::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPARADRILL)
	DDX_Control(pDX, IDC_LIST1, m_Pdrillresultlist);
	DDX_Control(pDX, IDC_LIST2, m_Pdrilllist);
	DDX_Text(pDX, IDC_EDIT2, m_sID);
	DDX_Text(pDX, IDC_EDIT1, m_sDia);
	DDX_Text(pDX, IDC_EDIT5, m_sMotorspeed);
	DDX_Text(pDX, IDC_EDIT3, m_sCutdepth);
	DDX_Text(pDX, IDC_EDIT6, m_sFeedrate);
	DDX_Text(pDX, IDC_EDIT20, m_sRoughness);
	DDX_Text(pDX, IDC_EDIT18, m_sPismaterial);
	DDX_Text(pDX, IDC_EDIT21, m_sTool);
	DDX_Text(pDX, IDC_EDIT16, m_sToolneed);
	DDX_Text(pDX, IDC_EDIT15, m_sPismaterialneed);
	DDX_Text(pDX, IDC_EDIT12, m_sDianeed);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPARADRILL, CDialog)
	//{{AFX_MSG_MAP(CPARADRILL)
	ON_NOTIFY(NM_CLICK, IDC_LIST2, OnClickList2)
	ON_BN_CLICKED(IDC_PdrillAdd, OnPdrillAdd)
	ON_BN_CLICKED(IDC_PdrillDelete, OnPdrillDelete)
	ON_BN_CLICKED(IDC_PdrillModify, OnPdrillModify)
	ON_BN_CLICKED(IDC_PdrillQuery, OnPdrillQuery)
	ON_BN_CLICKED(IDC_PdrillSave, OnPdrillSave)
	ON_BN_CLICKED(IDC_PdrillClear, OnPdrillClear)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPARADRILL message handlers

BOOL CPARADRILL::OnInitDialog() 
{
	CDialog::OnInitDialog();
	_variant_t strQuery, Holder;
	CString str;
	DWORD style;
	style=m_Pdrilllist.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_Pdrilllist.SetExtendedStyle(style);
	m_Pdrillresultlist.SetExtendedStyle(style);
	m_sOldID = m_sID;
	// Set Color
	//m_Codelist.SetBkColor(RGB(177, 151, 240));
//	m_Codelist.SetTextColor(RGB(0,0,0));
//	m_Codelist.SetTextBkColor(RGB(177, 151, 240));
    // 设置表字段
	m_Pdrilllist.InsertColumn(0,"编号",LVCFMT_LEFT,100);
	m_Pdrilllist.InsertColumn(1,"孔径大小",LVCFMT_LEFT,100);
	m_Pdrilllist.InsertColumn(2,"电主轴转速",LVCFMT_LEFT,100);
 	m_Pdrilllist.InsertColumn(3,"单次钻削深度",LVCFMT_LEFT,100);
    m_Pdrilllist.InsertColumn(4,"进给速度",LVCFMT_LEFT,100);
	m_Pdrilllist.InsertColumn(5,"表面精度",LVCFMT_LEFT,100);
	m_Pdrilllist.InsertColumn(6,"工件材料",LVCFMT_LEFT,100);
	m_Pdrilllist.InsertColumn(7,"刀具",LVCFMT_LEFT,100);

	m_Pdrillresultlist.InsertColumn(0,"电主轴转速",LVCFMT_LEFT,85);
	m_Pdrillresultlist.InsertColumn(1,"单次钻削深度",LVCFMT_LEFT,100);
 	m_Pdrillresultlist.InsertColumn(2,"进给速度",LVCFMT_LEFT,80);
	flag=0;
	
	tx_Cutdepth=GetDlgItem(IDC_EDIT3);
	tx_Dia=GetDlgItem(IDC_EDIT1);
	tx_Feedrate=GetDlgItem(IDC_EDIT6);
    tx_Motorspeed=GetDlgItem(IDC_EDIT5);
	tx_Pismaterial=GetDlgItem(IDC_EDIT18);
	tx_Roughness=GetDlgItem(IDC_EDIT20);
	tx_Tool=GetDlgItem(IDC_EDIT21);
	tx_ID=GetDlgItem(IDC_EDIT2);

	bt_add=GetDlgItem(IDC_PdrillAdd);
	bt_save=GetDlgItem(IDC_PdrillSave);
	bt_modify=GetDlgItem(IDC_PdrillModify);
	bt_delete=GetDlgItem(IDC_PdrillDelete);
    bt_query=GetDlgItem(IDC_PdrillQuery);

    tx_Cutdepth->EnableWindow(false);
	tx_Dia->EnableWindow(false);
	tx_Feedrate->EnableWindow(false);
    tx_Motorspeed->EnableWindow(false);
	tx_Pismaterial->EnableWindow(false);
	tx_Roughness->EnableWindow(false);
	tx_Tool->EnableWindow(false);
	tx_ID->EnableWindow(false);

  	
	bt_add->EnableWindow(true);
	bt_save->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);



//列表框数据初始化
	strQuery = "select * from paradrill";
	theApp.ADOExecute(theApp.m_pADOSet, strQuery);
    int iCount = theApp.m_pADOSet->GetRecordCount();
	if (0==iCount) return 0;
	theApp.m_pADOSet->MoveFirst();
	for (int i=0; i<iCount; i++)
    {	// Get id
		Holder = theApp.m_pADOSet->GetCollect("id");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.InsertItem(i, str);
		// Get holedia
		Holder = theApp.m_pADOSet->GetCollect("holedia");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 1, str);
	    // Get motorspindle
        Holder = theApp.m_pADOSet->GetCollect("motorspindle");
	    str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 2, str);
		// Get cutdepth
        Holder = theApp.m_pADOSet->GetCollect("drilldepth");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 3, str);
		// Get feedrate
        Holder = theApp.m_pADOSet->GetCollect("feedrate");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 4, str);
		// Get drillra
        Holder = theApp.m_pADOSet->GetCollect("drillra");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 5, str);
		// Get wpmaterial
        Holder = theApp.m_pADOSet->GetCollect("wpmaterial");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 6, str);
		// Get toolmaterial
        Holder = theApp.m_pADOSet->GetCollect("toolmaterial");
	   	str = Holder.vt==VT_NULL?"":(char*)(_bstr_t)Holder;
	    m_Pdrilllist.SetItemText(i, 7, str);

		theApp.m_pADOSet->MoveNext();
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CPARADRILL::OnClickList2(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	POSITION pos = m_Pdrilllist.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_Pdrilllist.GetNextSelectedItem(pos);
		m_sID=m_Pdrilllist.GetItemText(nFirstSelItem,0);
		m_sDia=m_Pdrilllist.GetItemText(nFirstSelItem,1);
        m_sMotorspeed=m_Pdrilllist.GetItemText(nFirstSelItem,2);
		m_sCutdepth=m_Pdrilllist.GetItemText(nFirstSelItem,3);
		m_sFeedrate=m_Pdrilllist.GetItemText(nFirstSelItem,4);
        m_sRoughness=m_Pdrilllist.GetItemText(nFirstSelItem,5);
		m_sPismaterial=m_Pdrilllist.GetItemText(nFirstSelItem,6);
		m_sTool=m_Pdrilllist.GetItemText(nFirstSelItem,7);
		//还差一个图片的显示
	}
	//AfxMessageBox(str);
	bt_delete->EnableWindow(true);
	bt_modify->EnableWindow(true);

	UpdateData(false);
	
	*pResult = 0;
}

void CPARADRILL::OnPdrillAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	m_sID="";
	m_sCutdepth="";
	m_sFeedrate="";
	m_sMotorspeed="";
   	m_sPismaterial="";
	m_sPismaterialneed="";
	m_sRoughness="";
	m_sTool="";
	m_sToolneed="";
	m_sDia="";
	m_sDianeed="";

    tx_Cutdepth->EnableWindow(true);
	tx_Dia->EnableWindow(true);
	tx_Feedrate->EnableWindow(true);
    tx_Motorspeed->EnableWindow(true);
	tx_Pismaterial->EnableWindow(true);
	tx_Roughness->EnableWindow(true);
	tx_Tool->EnableWindow(true);
	tx_ID->EnableWindow(true);
	
	flag=1;
	bt_save->EnableWindow(true);
	bt_add->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_delete->EnableWindow(false);
	UpdateData(false);		
	
	
}