mydlg7.cpp

实现对电机的转速

// MyDlg7.cpp : implementation file
//

#include "stdafx.h"
#include "电机性能测试.h"
#include "MyDlg7.h"
#include "电机性能测试Dlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CMyApp theApp;
/////////////////////////////////////////////////////////////////////////////
// MyDlg7 dialog


MyDlg7::MyDlg7(CWnd* pParent /*=NULL*/)
	: CDialog(MyDlg7::IDD, pParent)
{
	//{{AFX_DATA_INIT(MyDlg7)
	m_BM = _T("");
	m_AD = _T("");
	m_NA = _T("");
	m_SEX = _T("");
	m_QX = _T("");
	m_BZ = _T("");
	m_BH = _T("");
	m_CS = _T("");
	m_MI = _T("");
	m_PH = _T("");
	m_SFZ = _T("");
	//}}AFX_DATA_INIT
}


void MyDlg7::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(MyDlg7)
	DDX_Text(pDX, IDC_BUMEN, m_BM);
	DDX_Text(pDX, IDC_ADDRESS, m_AD);
	DDX_Text(pDX, IDC_NAME, m_NA);
	DDX_Text(pDX, IDC_SEX, m_SEX);
	DDX_Text(pDX, IDC_QUANXIAN, m_QX);
	DDX_Text(pDX, IDC_BEIZHU, m_BZ);
	DDX_Text(pDX, IDC_BIANHAO, m_BH);
	DDX_Text(pDX, IDC_CHUSHENG, m_CS);
	DDX_Text(pDX, IDC_MIMA, m_MI);
	DDX_Text(pDX, IDC_PHONE, m_PH);
	DDX_Text(pDX, IDC_SHENFENZHENG, m_SFZ);
	DDX_Control(pDX, IDC_DATAGRID1, m_GRID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(MyDlg7, CDialog)
	//{{AFX_MSG_MAP(MyDlg7)
	ON_CBN_SELENDOK(IDC_COMBO1, OnSelendokCombo1)
	ON_BN_CLICKED(IDC_BAOCUN, OnBaocun)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// MyDlg7 message handlers

void MyDlg7::OnSelendokCombo1() 
{
	// TODO: Add your control notification handler code here
	
}

void MyDlg7::OnBaocun() 
{
	// TODO: Add your control notification handler code here
//检查数据完整性
	if(m_BH.IsEmpty()||m_NA.IsEmpty()||m_SEX.IsEmpty()||m_BM.IsEmpty()||m_PH.IsEmpty()||m_SFZ.IsEmpty()||m_AD.IsEmpty()||m_MI.IsEmpty()||m_QX.IsEmpty()||m_BZ.IsEmpty())
	{
		AfxMessageBox("请输入完整信息！");
		return;
	}
	//此步做什么工作，根据按钮的内容决定
	CString sql,nowtime,temp;
	GetDlgItemText(IDC_BAOCUN,temp);
	//添加记录
	if(temp=="保存")
	{
		sql="insert into 用户信息管理(编号,姓名,性别,出生日期,工作部门,联系电话,身份证号,联系地址,密码,权限,备注)values('"+m_BH+"','"+m_NA+"','"+m_SEX+"','"+m_CS+"','"+m_BM+"','"+m_PH+"','"+m_SFZ+"','"+m_AD+"','"+m_MI+"','"+m_QX+"','"+m_BZ+"')";
        //执行语句
		
        _variant_t RecordsAffected;
		theApp.m_pConnection->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
		AfxMessageBox("成功插入1条数据！");
		//刷新list 列表的内容，必须引用#include "电机测试系统Dlg.h"
		CMyApp *pApp=(CMyApp *)AfxGetApp();
		MyDlg7 *pDlg=(MyDlg7 *)pApp->m_pMainWnd;
	}
}
void MyDlg7::OnDelete() 
{
	// TODO: Add your control notification handler code here
	UpdateData(0);
		 CString sql,nowtime,temp,pic;
		 try
		{
			  m_GRID.SetRow(m_GRID.GetRow());   
              m_GRID.SetCol(0);   
	          pic=m_GRID.GetText();

			  
		sql="delete from 用户信息管理 where 编号="+pic;
		 //sql = sql + (CString)pic;

        _variant_t RecordsAffected;
		theApp.m_pConnection->Execute((_bstr_t)sql,&RecordsAffected,adCmdText);
		AfxMessageBox("成功删除1条数据！");
		//刷新list 列表的内容，必须引用#include "电机测试系统Dlg.h"
		CMyApp *pApp=(CMyApp *)AfxGetApp();
		MyDlg7 *pDlg=(MyDlg7 *)pApp->m_pMainWnd;
		}
		catch(_com_error e)///捕捉异常
		{

			CString temp;
			temp.Format("连接数据库错误信息:%s",e.ErrorMessage());
			AfxMessageBox(temp);
			return;
		}
}

BEGIN_EVENTSINK_MAP(MyDlg7, CDialog)
    //{{AFX_EVENTSINK_MAP(MyDlg7)
	ON_EVENT(MyDlg7, IDC_DATAGRID1, -600 /* Click */, OnClickDatagrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void MyDlg7::OnClickDatagrid1() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
CString pic1,pic2,pic3,pic4,pic5,pic6,pic7,pic8,pic9,pic10,pic11;
		
		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(0);   
	    pic1=m_GRID.GetText();
		m_BH=pic1;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(1);   
	    pic2=m_GRID.GetText();
		m_NA=pic2;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(2);   
	    pic3=m_GRID.GetText();
		m_SEX=pic3;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(3);   
	    pic4=m_GRID.GetText();
		m_CS=pic4;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(4);   
	    pic5=m_GRID.GetText();
		m_BM=pic5;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(5);   
	    pic6=m_GRID.GetText();
		m_PH=pic6;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(6);   
	    pic7=m_GRID.GetText();
		m_SFZ=pic7;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(7);   
	    pic8=m_GRID.GetText();
		m_AD=pic8;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(8);   
	    pic9=m_GRID.GetText();
		m_MI=pic9;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(9);   
	    pic10=m_GRID.GetText();
		m_QX=pic10;

		m_GRID.SetRow(m_GRID.GetRow());   
        m_GRID.SetCol(10);   
	    pic11=m_GRID.GetText();
		m_BZ=pic11;

	UpdateData(FALSE);
}