selcaldlg.cpp

这是工厂应用的软件

// SelCalDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SUNTEK.h"
#include "SelCalDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSelCalDlg dialog


CSelCalDlg::CSelCalDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSelCalDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSelCalDlg)
	m_mineType = _T("21RF");
	//}}AFX_DATA_INIT
	record=0;
}


void CSelCalDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSelCalDlg)
	DDX_Control(pDX, IDOK, m_myButton);
	DDX_Control(pDX, IDC_TYPE, m_TypeCtrl);
	DDX_Control(pDX, IDC_LIST1, m_ListCtrl);
	DDX_CBString(pDX, IDC_TYPE, m_mineType);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSelCalDlg, CDialog)
	//{{AFX_MSG_MAP(CSelCalDlg)
	ON_BN_CLICKED(ID_SEL, OnSel)
	ON_BN_CLICKED(IDOK, OnmyOK)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSelCalDlg message handlers

void CSelCalDlg::OnSel() 
{
	

	m_TypeCtrl.GetWindowText(m_mineType);
	CString cmd="select * from STD where Type='";
	cmd=cmd+m_mineType+"'";
	if(n_SelRecsetSTD.IsOpen())
	{
		n_SelRecsetSTD.Close();
	}
	n_SelRecsetSTD.Open(AFX_DB_USE_DEFAULT_TYPE,cmd);
	while(m_ListCtrl.GetCount()>0)
	{
		m_ListCtrl.DeleteString(0);
	}
	for( record=0;;record++)
	{
		if(n_SelRecsetSTD.IsBOF() && n_SelRecsetSTD.IsEOF())
		{
			AfxMessageBox("No record in database!");
			return;
		}

		if(n_SelRecsetSTD.IsEOF())
		{
			n_SelRecsetSTD.MovePrev();
			break;
		}
		else
		{
			n_SelRecsetSTD.MoveNext();
		}
	}

	m_ListCtrl.InitStorage(record,12);//m_ListCtrl.AddString(" ");
	CString str,strt1,strt2,strt3;
//	m_ListCtrl.AddString("      时      间       Cal_T1  Cal_T2   Cal_T3");
	
	float t1=0,t2=0,t3=0;
	n_SelRecsetSTD.MoveFirst();
	for(int ii=0;ii<record;ii++)
	{
		str=n_SelRecsetSTD.m_Time;
		t1=n_SelRecsetSTD.m_CALT1;
		t2=n_SelRecsetSTD.m_CALT2;
		t3=n_SelRecsetSTD.m_CALT3;
		strt1.Format("%.3f",t1);
		strt2.Format("%.3f",t2);
		strt3.Format("%.3f",t3);
		str=str+"    "+strt1+"    "+strt2+"    "+strt3;
		m_ListCtrl.AddString(str);
		n_SelRecsetSTD.MoveNext();
		if(n_SelRecsetSTD.IsEOF())
			n_SelRecsetSTD.MovePrev();
	}


	n_SelRecsetSTD.Close();
		m_myButton.EnableWindow(true);


/*
// Dump all of the items in the list box.

   CString str, str2;
   int n;
   for (int i=0;i < pmyListBox->GetCount();i++)
   {
      n = pmyListBox->GetTextLen( i );
      pmyListBox->GetText( i, str.GetBuffer(n) );
      str.ReleaseBuffer();

      str2.Format(_T("item %d: %s\r\n"), i, str.GetBuffer(0));
      afxDump << str2;
   }

*/

}


void CSelCalDlg::OnmyOK() 
{
	int index=m_ListCtrl.GetCurSel();
	if(index==LB_ERR)
		return ;
	int n=m_ListCtrl.GetTextLen(index);
	m_ListCtrl.GetText(index,selTime);
	CString str=selTime.Left(14);

	CString cmd="select * from STD where Time='";
	cmd=cmd+str+"'";
	if(n_SelRecsetSTD.IsOpen())
	{
		n_SelRecsetSTD.Close();
	}
	n_SelRecsetSTD.Open(AFX_DB_USE_DEFAULT_TYPE,cmd);
	
	fCALT1=n_SelRecsetSTD.m_CALT1;
	fCALT2=n_SelRecsetSTD.m_CALT2;
	fCALT3=n_SelRecsetSTD.m_CALT3;

//	selTime.ReleaseBuffer();
	CDialog::OnOK();

}

BOOL CSelCalDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	
	m_myButton.EnableWindow(false);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}