dlg_query_text.cpp

功能非常强大的数据采集系统

// DLG_QUERY_TEXT.cpp : implementation file
//

#include "stdafx.h"
#include "Ncap.h"
#include "DLG_QUERY_TEXT.h"
#include "ADOConn.h"

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

extern CNcapApp theApp;
/////////////////////////////////////////////////////////////////////////////
// DLG_QUERY_TEXT dialog


DLG_QUERY_TEXT::DLG_QUERY_TEXT(CWnd* pParent /*=NULL*/)
	: CDialog(DLG_QUERY_TEXT::IDD, pParent)
{
	//{{AFX_DATA_INIT(DLG_QUERY_TEXT)
	m_sChannel = _T("");
	m_sDate = _T("");
	m_sDemo = _T("");
	m_sDs_time = _T("");
	m_sName = _T("");
	m_sNum = _T("");
	m_sNumber = _T("");
	m_sUnit = _T("");
	//}}AFX_DATA_INIT
}


void DLG_QUERY_TEXT::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(DLG_QUERY_TEXT)
	DDX_Control(pDX, IDC_QUERY_TEXT_OK, m_cOk);
	DDX_Control(pDX, IDC_QUERY_TEXT_DELETE, m_cDelete);
	DDX_Text(pDX, IDC_QUERY_TEXT_CHANNEL, m_sChannel);
	DDX_Text(pDX, IDC_QUERY_TEXT_DATE, m_sDate);
	DDX_Text(pDX, IDC_QUERY_TEXT_DEMO, m_sDemo);
	DDV_MaxChars(pDX, m_sDemo, 250);
	DDX_Text(pDX, IDC_QUERY_TEXT_DS_TIME, m_sDs_time);
	DDX_Text(pDX, IDC_QUERY_TEXT_NAME, m_sName);
	DDX_Text(pDX, IDC_QUERY_TEXT_NUM, m_sNum);
	DDX_Text(pDX, IDC_QUERY_TEXT_NUMBER, m_sNumber);
	DDX_Text(pDX, IDC_QUERY_TEXT_UNIT, m_sUnit);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(DLG_QUERY_TEXT, CDialog)
	//{{AFX_MSG_MAP(DLG_QUERY_TEXT)
	ON_BN_CLICKED(IDC_QUERY_TEXT_DELETE, OnQueryTextDelete)
	ON_BN_CLICKED(IDC_QUERY_TEXT_OK, OnQueryTextOk)
	ON_EN_CHANGE(IDC_QUERY_TEXT_DEMO, OnChangeQueryTextDemo)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// DLG_QUERY_TEXT message handlers

//-------------------------------------------------------------------------------------------------
// 消息预处理(主要针对按键处理)
//-------------------------------------------------------------------------------------------------
BOOL DLG_QUERY_TEXT::PreTranslateMessage(MSG* pMsg) 
{
	// TODO: Add your specialized code here and/or call the base class
	if (pMsg->message==WM_KEYDOWN && pMsg->wParam==VK_RETURN)
	{
		CDialog* Pwnd=(CDialog*)GetActiveWindow();						//取得对话框指针 
		Pwnd->NextDlgCtrl();											//切换到下一个输入焦点 
		return true;
	}
	
	return CDialog::PreTranslateMessage(pMsg);
}

//-------------------------------------------------------------------------------------------------
// 初始化对话窗信息
//-------------------------------------------------------------------------------------------------
BOOL DLG_QUERY_TEXT::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	v_iReturn=0;														//执行返回值默认值

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

//-------------------------------------------------------------------------------------------------
// 删除实验信息
//-------------------------------------------------------------------------------------------------
void DLG_QUERY_TEXT::OnQueryTextDelete() 
{
	// TODO: Add your control notification handler code here
	if(::MessageBox(NULL,"是否真要删除实验信息 ?  ","删除确认",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)
	{
		CString v_sSql="DELETE from query where znum='"+m_sNum+"'";		//SQL语句
		if (We_save(v_sSql))											//删除：实验信息记录
		{
			v_sSql="DELETE from information where znum='"+m_sNum+"'";	//SQL语句
			if (We_save(v_sSql))										//删除：实验数据记录
			{
				v_iReturn=1;											//删除实验信息返回值
				CDialog::OnCancel();									//退出对话窗			
			}
		}
	}
}

//-------------------------------------------------------------------------------------------------
// 修改实验备注内容
//-------------------------------------------------------------------------------------------------
void DLG_QUERY_TEXT::OnQueryTextOk() 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	m_sDemo.Replace("'","''");
	CString v_sSql="UPDATE query SET zdemo='"+m_sDemo+"' where znum='"+m_sNum+"'";	
																		//SQL语句
	if (We_save(v_sSql))												//执行命令
	{
		v_iReturn=2;													//备注修改返回值
		CDialog::OnCancel();											//退出对话窗			
	}
}

//-------------------------------------------------------------------------------------------------
// 备注内容修改标志
//-------------------------------------------------------------------------------------------------
void DLG_QUERY_TEXT::OnChangeQueryTextDemo() 
{
	// TODO: Add your control notification handler code here
	m_cOk.EnableWindow(true);
}

//-------------------------------------------------------------------------------------------------
// 执行数据库命令
//-------------------------------------------------------------------------------------------------
bool DLG_QUERY_TEXT::We_save(CString v_sSql) 
{
	// TODO: Add your control notification handler code here
	bool v_bReturn=true;
	ADOConn v_cAdoConn;													// 数据库实例
	v_cAdoConn.OnInitADOConn(theApp.a_iDatabase_Type,theApp.a_sDatabase_Ip,theApp.a_sDatabase_Name,theApp.a_sDatabase_User,theApp.a_sDatabase_Password);
																		// 连接数据库
	if (!v_cAdoConn.ExecuteSQL((_bstr_t)v_sSql))						// 执行数据库操作
		v_bReturn=false;
	v_cAdoConn.ExitConnect();											//断开连接
	return v_bReturn;
}

//-------------------------------------------------------------------------------------------------
// 结束
//-------------------------------------------------------------------------------------------------