inputemployeesdlg.cpp

A HR database application.

// InputEmployeesDlg.cpp : implementation file
//

#include <string.h>
#include <iomanip.h>
#include "stdafx.h"
#include "HRDB.h"
#include "InputEmployeesDlg.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;

/////////////////////////////////////////////////////////////////////////////
// CInputEmployeesDlg dialog


CInputEmployeesDlg::CInputEmployeesDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CInputEmployeesDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CInputEmployeesDlg)
	m_intEmployeeID = 0;
	m_strFirstName = _T("");
	m_strLastName = _T("");
	m_strEmail = _T("");
	m_strPhone = _T("");
	m_strEJobID = _T("");
	m_fCommissionPCT = 0.0f;
	m_intDepartmentID = 0;
	m_intManagerID = 0;
	m_strHireDate = _T("");
	m_strSalary = _T("");
	//}}AFX_DATA_INIT
}


void CInputEmployeesDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CInputEmployeesDlg)
	DDX_Control(pDX, IDC_INPUT_E_MANAGER_ID, m_editManagerID);
	DDX_Control(pDX, IDC_INPUT_E_DEPARTMENT_ID, m_editDepartmentID);
	DDX_Control(pDX, IDC_INPUT_COMMISSION, m_editCommissionPCT);
	DDX_Control(pDX, IDC_INPUT_SALARY, m_editSalary);
	DDX_Control(pDX, IDC_INPUT_E_JOB_ID, m_editEJobID);
	DDX_Control(pDX, IDC_INPUT_HIRE_DATE, m_editHireDate);
	DDX_Control(pDX, IDC_INPUT_PHONE, m_editPhone);
	DDX_Control(pDX, IDC_INPUT_EMAIL, m_editEmail);
	DDX_Control(pDX, IDC_INPUT_LAST_NAME, m_editLastName);
	DDX_Control(pDX, IDC_INPUT_FIRST_NAME, m_editFirstName);
	DDX_Control(pDX, IDC_INPUT_EMPLOYEE_ID, m_editEmployeeID);
	DDX_Text(pDX, IDC_INPUT_EMPLOYEE_ID, m_intEmployeeID);
	DDX_Text(pDX, IDC_INPUT_FIRST_NAME, m_strFirstName);
	DDX_Text(pDX, IDC_INPUT_LAST_NAME, m_strLastName);
	DDX_Text(pDX, IDC_INPUT_EMAIL, m_strEmail);
	DDX_Text(pDX, IDC_INPUT_PHONE, m_strPhone);
	DDX_Text(pDX, IDC_INPUT_E_JOB_ID, m_strEJobID);
	DDX_Text(pDX, IDC_INPUT_COMMISSION, m_fCommissionPCT);
	DDX_Text(pDX, IDC_INPUT_E_DEPARTMENT_ID, m_intDepartmentID);
	DDX_Text(pDX, IDC_INPUT_E_MANAGER_ID, m_intManagerID);
	DDX_Text(pDX, IDC_INPUT_HIRE_DATE, m_strHireDate);
	DDX_Text(pDX, IDC_INPUT_SALARY, m_strSalary);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CInputEmployeesDlg message handlers

BOOL CInputEmployeesDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();

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

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

void CInputEmployeesDlg::OnOK() 
{
	// 使用参数绑定的方法向表中插入数据
	SQLUINTEGER  employee_id;
	SQLVARCHAR   first_name[20];
	SQLVARCHAR   last_name[25];
	SQLVARCHAR   email[25];
	SQLVARCHAR   phone_number[20];
	SQLVARCHAR	 hire_date[10];
	SQLVARCHAR   job_id[10];
	SQLVARCHAR   salary[20];
	SQLFLOAT     commission_pct;
	SQLUINTEGER  manager_id;
	SQLUINTEGER  department_id;
	
	SQLINTEGER   employee_idInd = 0, first_nameLenOrInd = 0, last_nameLenOrInd = 0;
	SQLINTEGER   emailLenOrInd = 0, phone_numberLenOrInd = 0, hire_dateLenOrInd = 0;
	SQLINTEGER   job_idLenOrInd = 0, salaryLenOrInd = 0, commission_pctInd = 0;
	SQLINTEGER	 manager_idInd = 0, department_idInd = 0;

	// 准备包含参数标志符的SQL语句
	TODBCs( hstmt, SQLPrepare( hstmt,                        
	   (unsigned char *)"insert into employees (employee_id, first_name, last_name, \
	   email, phone_number, hire_date, job_id, salary, commission_pct, manager_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 ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            20, 0, first_name, sizeof(first_name), &first_nameLenOrInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 3, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            25, 0, last_name, sizeof(last_name), &last_nameLenOrInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 4, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            25, 0, email, sizeof(email), &emailLenOrInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 5, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            20, 0, phone_number, sizeof(phone_number), &phone_numberLenOrInd ) );

	// SQL_TIMESTAMP对应SQL中datetime类型
	TODBCs( hstmt, SQLBindParameter( hstmt, 6, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_TIMESTAMP,
	                            8, 0, hire_date, sizeof(hire_date), &hire_dateLenOrInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 7, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_VARCHAR,
	                            10, 0, job_id, sizeof(job_id), &job_idLenOrInd ) );
	
	// SQL_DECIMAL对应SQL中money类型
	TODBCs( hstmt, SQLBindParameter( hstmt, 8, SQL_PARAM_INPUT, SQL_C_CHAR, SQL_DECIMAL,
	                            20, 0, salary, sizeof(salary), &salaryLenOrInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 9, SQL_PARAM_INPUT, SQL_C_FLOAT, SQL_REAL,
	                            4, 0, &commission_pct, 0, &commission_pctInd ) );

	TODBCs( hstmt, SQLBindParameter( hstmt, 10, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER,
	                            4, 0, &manager_id, 0, &manager_idInd ) );
	
	TODBCs( hstmt, SQLBindParameter( hstmt, 11, SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER,
	                            4, 0, &department_id, 0, &department_idInd ) );

	// 先给参数变量赋值，然后执行SQL语句，向表中插入新记录
	UpdateData(TRUE); //更新控件关联变量
	employee_id = m_intEmployeeID;
	strcpy( (char *)first_name, m_strFirstName);
	strcpy( (char *)last_name, m_strLastName);
	strcpy( (char *)email, m_strEmail);
	strcpy( (char *)phone_number, m_strPhone);
	strcpy( (char *)hire_date, m_strHireDate);
	strcpy( (char *)job_id, m_strEJobID);
	strcpy( (char *)salary, m_strSalary);
	commission_pct = m_fCommissionPCT;
	manager_id = m_intManagerID;
	department_id = m_intDepartmentID;
	
	first_nameLenOrInd = SQL_NTS;
	last_nameLenOrInd = SQL_NTS;
	emailLenOrInd = SQL_NTS;
    phone_numberLenOrInd = SQL_NTS;
	hire_dateLenOrInd = SQL_NTS;
	job_idLenOrInd = SQL_NTS;
	salaryLenOrInd = 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_editEmployeeID.SetWindowText("");
	m_editFirstName.SetWindowText("");
	m_editLastName.SetWindowText("");
	m_editEmail.SetWindowText("");
	m_editPhone.SetWindowText("");
	m_editHireDate.SetWindowText("");
	m_editEJobID.SetWindowText("");
	m_editSalary.SetWindowText("");
	m_editCommissionPCT.SetWindowText("");
	m_editManagerID.SetWindowText("");
	m_editDepartmentID.SetWindowText("");
	
	//CDialog::OnOK();
}