inputregionsdlg.cpp

A HR database application.

// InputRegionsDlg.cpp : implementation file
//

#include <string.h>
#include <iomanip.h>
#include "stdafx.h"
#include "HRDB.h"
#include "InputRegionsDlg.h"
#include "desexec.h"


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

//定义全局SQL环境变量
SQLHENV    henv;
SQLHDBC    hdbc;
SQLHSTMT   hstmt;
SQLRETURN  retcode;
BOOL       findResult = FALSE;

/////////////////////////////////////////////////////////////////////////////
// CInputRegionsDlg dialog


CInputRegionsDlg::CInputRegionsDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CInputRegionsDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInputRegionsDlg)
	m_strRegionName = _T("");
	m_intRegionID = 0;
	//}}AFX_DATA_INIT
}


void CInputRegionsDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInputRegionsDlg)
	DDX_Control(pDX, IDC_INPUT_REGION_NAME, m_editRegionName);
	DDX_Control(pDX, IDC_INPUT_REGION_ID, m_editRegionID);
	DDX_Text(pDX, IDC_INPUT_REGION_NAME, m_strRegionName);
	DDX_Text(pDX, IDC_INPUT_REGION_ID, m_intRegionID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CInputRegionsDlg, CDialog)
	//{{AFX_MSG_MAP(CInputRegionsDlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CInputRegionsDlg message handlers

void CInputRegionsDlg::OnOK() 
{
	// 使用参数绑定的方法向表中插入数据
	SQLUINTEGER  region_id;
	SQLVARCHAR   region_name[25];
	SQLINTEGER   region_idInd = 0, region_nameLenOrInd = 0;

	// 准备包含参数标志符的SQL语句
	TODBCs( hstmt, SQLPrepare( hstmt,                        
	   (unsigned char *)"insert into regions (region_id, region_name) Values (?, ?)", SQL_NTS ) );
	
	// 为每一个参数都调用函数SQLBindParameter, 绑定相应的参数
	TODBCs( hstmt, SQLBindParameter( hstmt, 1, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER,
	                            4, 0, &region_id, 0, &region_idInd ) );
	TODBCs( hstmt, SQLBindParameter( hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            25, 0, region_name, sizeof(region_name), &region_nameLenOrInd ) );

	// 先给参数变量赋值，然后执行SQL语句，向表中插入新记录
	UpdateData(TRUE); //更新控件关联变量
	region_id = m_intRegionID;
	strcpy( (char *)region_name, m_strRegionName);
	region_nameLenOrInd = SQL_NTS;
	retcode = TODBCs( hstmt, SQLExecute(hstmt) );

	if (retcode != SQL_SUCCESS && retcode != SQL_SUCCESS_WITH_INFO)
	{
		//捕获异常
		AfxMessageBox("无权添加,或添加失败!");
	}

	// 释放绑定的参数
	TODBCs( hstmt, SQLFreeStmt( hstmt, SQL_RESET_PARAMS ) );
	
	// 释放绑定的参数
	TODBCs( hstmt, SQLFreeStmt( hstmt, SQL_UNBIND ) );

	m_editRegionID.SetWindowText("");
	m_editRegionName.SetWindowText("");

	//CDialog::OnOK();
}

BOOL CInputRegionsDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CInputRegionsDlg::OnCancel() 
{	
	CDialog::OnCancel();
}