inputjhdlg.cpp

A HR database application.

// InputJHDlg.cpp : implementation file
//

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

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

//引入全局SQL环境变量
extern SQLHENV    henv;
extern SQLHDBC    hdbc;
extern SQLHSTMT   hstmt;
extern SQLRETURN  retcode;

/////////////////////////////////////////////////////////////////////////////
// CInputJHDlg dialog


CInputJHDlg::CInputJHDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CInputJHDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInputJHDlg)
	m_intJHEmployeeID = 0;
	m_strJHJobID = _T("");
	m_intJHDepartmentID = 0;
	m_strEndDate = _T("");
	m_strStartDate = _T("");
	//}}AFX_DATA_INIT
}


void CInputJHDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInputJHDlg)
	DDX_Control(pDX, IDC_INPUT_END_DATE, m_editEndDate);
	DDX_Control(pDX, IDC_INPUT_START_DATE, m_editStartDate);
	DDX_Control(pDX, IDC_INPUT_JH_DEPARTMENT_ID, m_editJHDepartmentID);
	DDX_Control(pDX, IDC_INPUT_JH_JOB_ID, m_editJHJobID);
	DDX_Control(pDX, IDC_INPUT_JH_EMPLOYEE_ID, m_editJHEmployeeID);
	DDX_Text(pDX, IDC_INPUT_JH_EMPLOYEE_ID, m_intJHEmployeeID);
	DDX_Text(pDX, IDC_INPUT_JH_JOB_ID, m_strJHJobID);
	DDX_Text(pDX, IDC_INPUT_JH_DEPARTMENT_ID, m_intJHDepartmentID);
	DDX_Text(pDX, IDC_INPUT_END_DATE, m_strEndDate);
	DDX_Text(pDX, IDC_INPUT_START_DATE, m_strStartDate);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CInputJHDlg message handlers

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

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

void CInputJHDlg::OnOK() 
{
	// 使用参数绑定的方法向表中插入数据
	SQLUINTEGER  employee_id;
	SQLVARCHAR   start_date[11];
	SQLVARCHAR   end_date[11];
	SQLVARCHAR   job_id[10];
	SQLUINTEGER  department_id;
	SQLINTEGER   employee_idInd = 0, start_dateLenOrInd = 0, end_dateLenOrInd = 0;
	SQLINTEGER   job_idLenOrInd = 0, department_idInd = 0;

	// 准备包含参数标志符的SQL语句
	TODBCs( hstmt, SQLPrepare( hstmt,                       
	   (unsigned char *)"insert into job_history (employee_id, start_date, end_date, \
	   job_id, department_id) Values (?, ?, ?, ?, ?)", SQL_NTS ) );
	
	// 为每一个参数都调用函数SQLBindParameter, 绑定相应的参数
	TODBCs( hstmt, SQLBindParameter( hstmt, 1, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER,
	                            4, 0, &employee_id, 0, &employee_idInd ) );

	// SQL_TIMESTAMP对应SQL中datetime类型
	TODBCs( hstmt, SQLBindParameter( hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_TIMESTAMP,
	                            20, 0, start_date, sizeof(start_date), &start_dateLenOrInd ) );

	// SQL_TIMESTAMP对应SQL中datetime类型
	TODBCs( hstmt, SQLBindParameter( hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_TIMESTAMP,
	                            20, 0, end_date, sizeof(end_date), &end_dateLenOrInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            10, 0, job_id, sizeof(job_id), &job_idLenOrInd ) );
	
	TODBCs( hstmt, SQLBindParameter( hstmt, 5, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER,
	                            4, 0, &department_id, 0, &department_idInd ) );

	// 先给参数变量赋值，然后执行SQL语句，向表中插入新记录
	UpdateData(TRUE); //更新控件关联变量
	employee_id = m_intJHEmployeeID;
	strcpy( (char *)start_date, m_strStartDate);
	strcpy( (char *)end_date, m_strEndDate);
	strcpy( (char *)job_id, m_strJHJobID);
	department_id = m_intJHDepartmentID;
	employee_idInd = SQL_NTS;
	start_dateLenOrInd = SQL_NTS;
	end_dateLenOrInd = SQL_NTS;
	job_idLenOrInd = SQL_NTS;
	department_idInd = 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_editJHEmployeeID.SetWindowText("");
	m_editStartDate.SetWindowText("");
	m_editEndDate.SetWindowText("");
	m_editJHJobID.SetWindowText("");
	m_editJHDepartmentID.SetWindowText("");
	
	//CDialog::OnOK();
}