// AddView.cpp : implementation file
//

#include "stdafx.h"
#include "zhaoliang.h"
#include "AddView.h"
#include "Crypt.h"
#include "MainFrm.h"

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

extern CDatabase db;
/////////////////////////////////////////////////////////////////////////////
// CAddView

IMPLEMENT_DYNCREATE(CAddView, CFormView)

CAddView::CAddView()
	: CFormView(CAddView::IDD)
{
	//{{AFX_DATA_INIT(CAddView)
	m_strID = _T("");
	m_strPasswd = _T("");
	m_strName = _T("");
	m_strBirthday = _T("");
	m_strDepartment = _T("");
	m_strJob = _T("");
	m_strEdulevel = _T("");
	m_strSpecialty = _T("");
	m_strAddress = _T("");
	m_strTel = _T("");
	m_strEmail = _T("");
	m_strMemo = _T("");
	//}}AFX_DATA_INIT
}

CAddView::~CAddView()
{
}

void CAddView::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddView)
	DDX_Control(pDX, IDC_ADD_CMB_EDULEVEL, m_cEdulevel);
	DDX_Control(pDX, IDC_ADD_CMB_JOB, m_cJob);
	DDX_Control(pDX, IDC_ADD_CMB_DEPARTMENT, m_cDepartment);
	DDX_Text(pDX, IDC_ADD_EDT_ID, m_strID);
	DDX_Text(pDX, IDC_ADD_EDT_PASSWD, m_strPasswd);
	DDX_Text(pDX, IDC_ADD_EDT_NAME, m_strName);
	DDX_Text(pDX, IDC_ADD_EDT_BIRTHDAY, m_strBirthday);
	DDX_CBString(pDX, IDC_ADD_CMB_DEPARTMENT, m_strDepartment);
	DDX_CBString(pDX, IDC_ADD_CMB_JOB, m_strJob);
	DDX_CBString(pDX, IDC_ADD_CMB_EDULEVEL, m_strEdulevel);
	DDX_Text(pDX, IDC_ADD_EDT_SPECIALTY, m_strSpecialty);
	DDX_Text(pDX, IDC_ADD_EDT_ADDRESS, m_strAddress);
	DDX_Text(pDX, IDC_ADD_EDT_TEL, m_strTel);
	DDX_Text(pDX, IDC_ADD_EDT_EMAIL, m_strEmail);
	DDX_Text(pDX, IDC_ADD_EDT_MEMO, m_strMemo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddView, CFormView)
	//{{AFX_MSG_MAP(CAddView)
	ON_BN_CLICKED(IDC_ADD_BTN_ADD, OnAddBtnAdd)
	ON_WM_DESTROY()
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddView diagnostics

#ifdef _DEBUG
void CAddView::AssertValid() const
{
	CFormView::AssertValid();
}

void CAddView::Dump(CDumpContext& dc) const
{
	CFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CAddView message handlers

void CAddView::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();

	// 使框架窗口大小與視圖匹配
	GetParentFrame()->RecalcLayout();
    ResizeParentToFit(FALSE);

	GetParentFrame()->SetWindowText("增加新員工"); // 設置標題

	CRecordset rs(&db); // 數據集
	CString str;
	// 設置部門下拉框所取的值為DEPARTMENT表中的值
	rs.Open(CRecordset::forwardOnly, "select NAME from DEPARTMENT");
	while(!rs.IsEOF())
	{
		rs.GetFieldValue("NAME", str);
		m_cDepartment.AddString(str);
		rs.MoveNext();
	}
	rs.Close();

	// 設置職務下拉框所取的值為JOB表中的值
	rs.Open(CRecordset::forwardOnly, "select DESCRIPTION from JOB");
	while(!rs.IsEOF())
	{
		rs.GetFieldValue("DESCRIPTION", str);
		m_cJob.AddString(str);
		rs.MoveNext();
	}
	rs.Close();

	// 設置受教育水平下拉框所取的值為EDU_LEVEL表中的值
	rs.Open(CRecordset::forwardOnly, "select DESCRIPTION from EDU_LEVEL");
	while(!rs.IsEOF())
	{
		rs.GetFieldValue("DESCRIPTION", str);
		m_cEdulevel.AddString(str);
		rs.MoveNext();
	}
	rs.Close();
    m_brush.CreateSolidBrush(RGB(0,150,200));
	Init(); // 調用初始化函數
}

void CAddView::OnAddBtnAdd() 
{
	CString str,strSQL;
	int counter; // 用于計數
	CRecordset rs(&db); // 數據集

	UpdateData(); // 更新數據
	if(m_strName.IsEmpty()) // 姓名為空則返回
	{
		AfxMessageBox("姓名不能為空!");
		return;
	}

// 累加員工編號計數器
	rs.Open(CRecordset::forwardOnly,
		"select COUNTER_VALUE from COUNTER where ID='P'");
	rs.GetFieldValue("COUNTER_VALUE", str);
	sscanf(str, "%d", &counter); // 獲取計數值
	rs.Close(); // 關閉數據集
	counter++;	// 計數值加1
	str.Format("%d", counter); // 轉換為字符串
	strSQL="update COUNTER set COUNTER_VALUE=" + str + " where  ID='P'"; // 設置SQL語句
	db.ExecuteSQL(strSQL); // 執行
// 增加員工個人信息記錄
	CString strPasswd,strSex,strDepID,strJobID,strEduID;
	// 判斷生日是否為空
	if(m_strBirthday.IsEmpty()) m_strBirthday="1900-1-1"; // 缺省值
	// 加密密碼
	strPasswd=CCrypt::Encrypt(m_strPasswd, 123);
	// 判斷性別
	if(((CButton*)GetDlgItem(IDC_ADD_RADIO_MALE))->GetCheck()) strSex="M";
	else strSex="F";
	// 得到部門ID
	rs.Open(CRecordset::forwardOnly,
		"select ID from DEPARTMENT where NAME='" + m_strDepartment +"'");
	rs.GetFieldValue("ID", strDepID);
	rs.Close();
	// 得到職務代碼
	rs.Open(CRecordset::forwardOnly,
		"select CODE from JOB where DESCRIPTION='" + m_strJob +"'");
	rs.GetFieldValue("CODE", strJobID);
	rs.Close();
	// 得到受教育水平代碼
	rs.Open(CRecordset::forwardOnly,
		"select CODE from EDU_LEVEL where DESCRIPTION='" + m_strEdulevel +"'");
	rs.GetFieldValue("CODE", strEduID);
	rs.Close();
	// 寫SQL語句
	strSQL="insert into PERSON(ID,PASSWD,NAME,SEX,\
		BIRTHDAY,DEPARTMENT,JOB,EDU_LEVEL,SPECIALTY,\
		ADDRESS,TEL,EMAIL,REMARK) \
		values('"
		+ m_strID + "','" // ID
		+ strPasswd + "','" // PASSWD
		+ m_strName + "','" // NAME
		+ strSex + "','" // SEX
		+ m_strBirthday + "','" // BIRTHDAY
		+ strDepID + "','" // DEPARTMENT
		+ strJobID + "','" // JOB
		+ strEduID + "','" // EDU_LEVEL
		+ m_strSpecialty + "','" // SPECIALTY
		+ m_strAddress + "','" // ADDRESS
		+ m_strTel + "','" // TEL
		+ m_strEmail + "','" // EMAIL
		+ m_strMemo + "')"; // REMARK
	db.ExecuteSQL(strSQL); // 執行
// 獲取人事變動記錄號并累加
	rs.Open(CRecordset::forwardOnly,
		"select COUNTER_VALUE from COUNTER where ID='C'");
	rs.GetFieldValue("COUNTER_VALUE", str);
	sscanf(str, "%d", &counter); // 獲取計數值
	rs.Close(); // 關閉數據集
	counter++;	//計數值加1
	str.Format("%d", counter); // 轉換為字符串
	strSQL="update COUNTER set COUNTER_VALUE=" + str + " where  ID='C'"; // 設置SQL語句
	db.ExecuteSQL(strSQL); // 執行
// 追加人事變動記錄
	str.Format("%d",counter); // 計數值轉換為字符串
	CTime time=CTime::GetCurrentTime();
	CString strNow=time.Format("%Y-%m-%d %H:%M:%S");
	// 寫SQL語句
	strSQL="insert into zhaoliang(ID,PERSON,CHANGE,\
		RECORD_TIME,DESCRIPTION)\
		values("
		+ str + ",'" // ID
		+ m_strID + "','" // PERSON
		+ "0" + "','" // CHANGE - 加入公司代碼
		+ strNow + "','" // RECORD_TIME
		+ "加入公司')"; // DESCRIPTION
	db.ExecuteSQL(strSQL);

// 重新初始化窗口
	Init();
}

void CAddView::Init()
{
	// 清空成員變量
	m_strID = _T("");
	m_strPasswd = _T("");
	m_strName = _T("");
	m_strBirthday = _T("");
	m_strDepartment = _T("");
	m_cDepartment.SetCurSel(-1);
	m_strJob = _T("");
	m_cJob.SetCurSel(-1);
	m_strEdulevel = _T("");
	m_cEdulevel.SetCurSel(-1);
	m_strSpecialty = _T("");
	m_strAddress = _T("");
	m_strTel = _T("");
	m_strEmail = _T("");
	m_strMemo = _T("");

	// 生成員工號
	CString str;
	int counter; // 用于計數
	CRecordset rs(&db); // 數據集
	rs.Open(CRecordset::forwardOnly,
		"select COUNTER_VALUE from COUNTER where ID='P'");
	rs.GetFieldValue("COUNTER_VALUE", str);
	sscanf(str, "%d", &counter); // 獲取計數值
	rs.Close();
	str.Format("P%05d", counter); // 產生標準格式的編號
	m_strID=str; // 自動產生員工號
	m_strPasswd=str; // 默認密碼為員工號

	// 設置缺省性別為男
	((CButton*)GetDlgItem(IDC_ADD_RADIO_MALE))->SetCheck(TRUE);

	UpdateData(FALSE); // 更新界面數據
}

void CAddView::OnDestroy() 
{
	CFormView::OnDestroy();
	
	((CMainFrame*)AfxGetMainWnd())->m_bItemAdd=TRUE; // 開放"增加新員工"功能
	((CMainFrame*)AfxGetMainWnd())->m_pAdd=NULL; // 清空窗口指針
}

HBRUSH CAddView::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = (HBRUSH)m_brush;
   
	if(nCtlColor==CTLCOLOR_STATIC)
	{   pDC->SetBkMode(TRANSPARENT);
		return hbr;
	}
	if(nCtlColor==CTLCOLOR_EDIT)
	{  
		return NULL;
	}

	return hbr;
}