// SalaryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Salary.h"
#include "SalaryDlg.h"
#include "LoginDlg.h"
#include "FormulaDlg.h"
#include "PreviewDlg.h"

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

extern _ConnectionPtr pTheConn;
/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	afx_msg void OnAboutbox();
	virtual BOOL OnInitDialog();
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}
BOOL CAboutDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	return TRUE;
}
void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
	ON_COMMAND(IDS_ABOUTBOX, OnAboutbox)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSalaryDlg dialog

CSalaryDlg::CSalaryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSalaryDlg::IDD, pParent)
{
	CTime t=CTime::GetCurrentTime();
	//{{AFX_DATA_INIT(CSalaryDlg)
	m_strDepartID = _T("");
	m_strDepartName = _T("");
	m_strPersonID = _T("");
	m_strPersonName = _T("");
	m_fBasicSalary = 0.0f;
	m_strYearMonth = t.Format("%Y-%m");
	m_bFixed = FALSE;
	m_strItemName = _T("");
	m_fMoney = 0.0f;
	m_strDesription = _T("");
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CSalaryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSalaryDlg)
	DDX_Text(pDX, IDC_EDT_DEPARTID, m_strDepartID);
	DDV_MaxChars(pDX, m_strDepartID, 3);
	DDX_Control(pDX, IDC_DATAGRID1, m_cDG1);
	DDX_Text(pDX, IDC_EDT_DEPARTNAME, m_strDepartName);
	DDX_Text(pDX, IDC_EDT_PERSONID, m_strPersonID);
	DDX_Text(pDX, IDC_EDT_PERSONNAME, m_strPersonName);
	DDX_Text(pDX, IDC_EDT_BASICSALARY, m_fBasicSalary);
	DDX_Text(pDX, IDC_EDT_YEARMONTH, m_strYearMonth);
	DDX_Control(pDX, IDC_DATAGRID2, m_cDG2);
	DDX_Control(pDX, IDC_DATAGRID3, m_cDG3);
	DDX_Control(pDX, IDC_DATAGRID4, m_cDG4);
	DDX_Control(pDX, IDC_DATAGRID5, m_cDG5);
	DDX_Check(pDX, IDC_CHK_FIXED, m_bFixed);
	DDX_CBString(pDX, IDC_CMB_ITEMNAME, m_strItemName);
	DDX_Text(pDX, IDC_EDT_MONEY, m_fMoney);
	DDX_Text(pDX, IDC_EDT_DESCRIPTION, m_strDesription);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CSalaryDlg, CDialog)
	//{{AFX_MSG_MAP(CSalaryDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_COMMAND(IDM_SYSTEM_CONNECT, OnSystemConnect)
	ON_COMMAND(IDM_SYSTEM_DISCONNECT, OnSystemDisconnect)
	ON_EN_CHANGE(IDC_EDT_DEPARTID, OnChangeEdtDepartid)
	ON_WM_DESTROY()
	ON_EN_CHANGE(IDC_EDT_PERSONID, OnChangeEdtPersonid)
	ON_BN_CLICKED(IDC_BTN_CHANGESALARY, OnBtnChangesalary)
	ON_BN_CLICKED(IDC_BTN_ADD_PERSON, OnBtnAddPerson)
	ON_BN_CLICKED(IDC_BTN_ADD_LIST, OnBtnAddList)
	ON_COMMAND(IDM_CONFIG_FORMULA, OnConfigFormula)
	ON_COMMAND(IDM_SYSTEM_EXIT, OnSystemExit)
	ON_COMMAND(IDM_CALCULATE_STAT, OnCalculateStat)
    ON_COMMAND(IDM_ABOUTBOX, OnAboutDlg)

	ON_WM_MENUSELECT()
	ON_COMMAND(IDM_MENU_DELETERECORD, OnDeleteRecord)
	ON_COMMAND(IDM_PREVIEW_VIEW, OnPreviewView)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

static UINT indicators[] =
{
	ID_INDICATOR_MESSAGE,        // status line indicator
	ID_INDICATOR_LOGIN
};

/////////////////////////////////////////////////////////////////////////////
// CSalaryDlg message handlers

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

	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	// 設(shè)置項(xiàng)目缺省選擇為獎(jiǎng)金
	((CButton*)GetDlgItem(IDC_RADIO_BONUS))->SetCheck(TRUE);
	// 創(chuàng)建狀態(tài)條
	if (!m_wndStatusBar.Create(this) ||
		!m_wndStatusBar.SetIndicators(indicators,
		  sizeof(indicators)/sizeof(UINT)))
	{
		TRACE0("Failed to create status bar\n");
		return -1;      // fail to create
	}
	CRect rect;
	GetClientRect(&rect);
	// 設(shè)定狀態(tài)條
	m_wndStatusBar.SetPaneInfo(0,ID_INDICATOR_MESSAGE, 
							   SBPS_NORMAL,rect.Width()/2);
	m_wndStatusBar.SetPaneInfo(1,ID_INDICATOR_LOGIN,SBPS_STRETCH,0);
	RepositionBars(AFX_IDW_CONTROLBAR_FIRST,AFX_IDW_CONTROLBAR_LAST,
    ID_INDICATOR_LOGIN);
	// 加載加速鍵
	m_hAccTable=::LoadAccelerators(AfxGetApp()->m_hInstance, MAKEINTRESOURCE(IDR_ACCELERATOR));
	// 創(chuàng)建DataGrid需要用的Recordset對(duì)象
	m_pDG1rs.CreateInstance(__uuidof(Recordset)); // DataGrid1相關(guān)
	m_pDG2rs.CreateInstance(__uuidof(Recordset)); // DataGrid2相關(guān)
	m_pDG3rs.CreateInstance(__uuidof(Recordset)); // DataGrid3相關(guān)
	m_pDG4rs.CreateInstance(__uuidof(Recordset)); // DataGrid4相關(guān)
	m_pDG5rs.CreateInstance(__uuidof(Recordset)); // DataGrid5相關(guān)
	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CSalaryDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CSalaryDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CSalaryDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CSalaryDlg::OnDestroy() 
{
	CDialog::OnDestroy();
	
	// 釋放DataGrid需要用的Recordset對(duì)象
	m_pDG1rs.Release(); // DataGrid1相關(guān)
	m_pDG2rs.Release(); // DataGrid2相關(guān)
	m_pDG3rs.Release(); // DataGrid3相關(guān)
	m_pDG4rs.Release(); // DataGrid4相關(guān)
	m_pDG5rs.Release(); // DataGrid5相關(guān)
}

void CSalaryDlg::OnSystemConnect() // 顯示用戶登錄窗口
{
	CLoginDlg LoginDlg;
	if(LoginDlg.DoModal()==IDOK) // 認(rèn)證通過
		m_wndStatusBar.SetPaneText(1, "已連接到數(shù)據(jù)庫: " + LoginDlg.m_sDSN);
}

void CSalaryDlg::OnSystemDisconnect() // 斷開連接
{
	// 關(guān)閉Connetion對(duì)象
	if(pTheConn->GetState()==adStateOpen)
		pTheConn->Close();
	m_wndStatusBar.SetPaneText(1, "尚未登錄數(shù)據(jù)庫，請(qǐng)按F2登錄");
}

void CSalaryDlg::OnChangeEdtDepartid() 
{
	if(pTheConn->GetState()==adStateClosed) return; // 數(shù)據(jù)庫未打開則返回
	UpdateData(); // 更新數(shù)據(jù)

	CString str;
	_variant_t Value;
	
	_RecordsetPtr pRS; // Recordset對(duì)象
	pRS.CreateInstance(__uuidof(Recordset)); // 創(chuàng)建
	// 更新DataGrid1數(shù)據(jù)
	str="select ID,NAME from PERSONINFO where departmentID like '"
		+ m_strDepartID + "' and STATE='T'";
	
	if(m_pDG1rs->GetState()==adStateOpen) m_pDG1rs->Close(); // 關(guān)閉Recordset
	
	// 打開Recordset
	m_pDG1rs->Open(str.AllocSysString(),
		pTheConn.GetInterfacePtr(),
		adOpenStatic,adLockReadOnly,adCmdText);
	
	// 設(shè)置DataGrid1
	m_cDG1.SetRefDataSource((LPUNKNOWN)m_pDG1rs);
	// 更新部門名稱
	str="select NAME from DEPARTMENT where ID='" + m_strDepartID + "'";
	pRS->Open(str.AllocSysString(),
			pTheConn.GetInterfacePtr(),
			adOpenStatic,adLockReadOnly,adCmdText);
	if(pRS->RecordCount==1) // 判斷記錄是否存在
	{
		Value=pRS->GetCollect("NAME"); // 得到部門名稱
		
		if(Value.vt!=VT_NULL) m_strDepartName=(char*)_bstr_t(Value);
		
	}
	else
		m_strDepartName.Empty(); // 清除部門名稱

	UpdateData(FALSE); // 更新界面數(shù)據(jù)
	pRS.Release(); // 釋放
}

BEGIN_EVENTSINK_MAP(CSalaryDlg, CDialog)
    //{{AFX_EVENTSINK_MAP(CSalaryDlg)
	ON_EVENT(CSalaryDlg, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDatagrid1, VTS_NONE)
	ON_EVENT(CSalaryDlg, IDC_DATAGRID2, -605 /* MouseDown */, OnMouseDownDatagrid2, VTS_I2 VTS_I2 VTS_I4 VTS_I4)
	ON_EVENT(CSalaryDlg, IDC_DATAGRID3, -605 /* MouseDown */, OnMouseDownDatagrid3, VTS_I2 VTS_I2 VTS_I4 VTS_I4)
	ON_EVENT(CSalaryDlg, IDC_DATAGRID4, -605 /* MouseDown */, OnMouseDownDatagrid4, VTS_I2 VTS_I2 VTS_I4 VTS_I4)
	ON_EVENT(CSalaryDlg, IDC_DATAGRID5, -605 /* MouseDown */, OnMouseDownDatagrid5, VTS_I2 VTS_I2 VTS_I4 VTS_I4)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CSalaryDlg::OnDblClickDatagrid1() 
{
	UpdateData(); // 更新數(shù)據(jù)
	_variant_t Value;
	if(m_pDG1rs->GetState()==adStateOpen) // 判斷列表是否打開
	{
		Value=m_pDG1rs->GetCollect("ID"); // 得到員工號(hào)
		m_strPersonID=(char*)_bstr_t(Value);
	}
	UpdateData(FALSE); // 更新界面數(shù)據(jù)
	OnChangeEdtPersonid(); // 改變員工信息
}

void CSalaryDlg::OnChangeEdtPersonid() 
{
	// 數(shù)據(jù)庫未連接則返回
	if(pTheConn->GetState()==adStateClosed) return;

	UpdateData(); // 更新數(shù)據(jù)
	CString str;
	_variant_t Value;
	_RecordsetPtr pRS; // Recordset對(duì)象
	str="select NAME from personInfo where ID='"
		+ m_strPersonID + "' and STATE='T'";
	pRS.CreateInstance(__uuidof(Recordset)); // 創(chuàng)建
	// 打開Recordset
	pRS->Open(str.AllocSysString(),
		pTheConn.GetInterfacePtr(),
		adOpenStatic,adLockReadOnly,adCmdText);
	if(pRS->RecordCount==1) // 判斷記錄是否存在
	{
	// 更新員工姓名
		Value=pRS->GetCollect("NAME"); // 得到員工姓名
		if(Value.vt!=VT_NULL) m_strPersonName=(char*)_bstr_t(Value);
	// 更新基本工資
		pRS->Close(); // 關(guān)閉
		str="PersonID='" + m_strPersonID + "'";
		pRS->Filter=str.AllocSysString();
		// 打開Recordset
		pRS->Open("SALARY",
			pTheConn.GetInterfacePtr(),
			adOpenKeyset,adLockOptimistic,adCmdTable);
		if(pRS->RecordCount==1) // 判斷記錄是否存在
		{
			Value=pRS->GetCollect("SalaryValue"); // 得到工資
			if(Value.vt!=VT_NULL) m_fBasicSalary=Value.fltVal;
			
		}
		else // 添加記錄
		{
			m_fBasicSalary=0; // 缺省工資
			pRS->AddNew();
			pRS->Fields->GetItem("PersonID")->PutValue(m_strPersonID.AllocSysString());
			pRS->Fields->GetItem("SalaryValue")->PutValue(_variant_t(m_fBasicSalary));
			pRS->Update();
		}
	// 開放“更改基本工資”按鈕
		GetDlgItem(IDC_BTN_CHANGESALARY)->EnableWindow(TRUE);
	// 更新“固定福利津貼”列表
		UpdateDG(m_pDG2rs, m_cDG2, 2);
	// 更新“月度獎(jiǎng)金”列表
		UpdateDG(m_pDG3rs, m_cDG3, 3);
	// 更新“月度福利津貼”列表
		UpdateDG(m_pDG4rs, m_cDG4, 4);
	// 更新“月度扣發(fā)”列表
		UpdateDG(m_pDG5rs, m_cDG5, 5);
	}
	else
	{
		m_strPersonName.Empty(); // 清除員工姓名
		m_fBasicSalary=0; // 清除工資
		// 禁止“更改基本工資”按鈕
		GetDlgItem(IDC_BTN_CHANGESALARY)->EnableWindow(FALSE);
		// 清除各DataGrid
		if(m_pDG2rs->GetState()==adStateOpen) m_pDG2rs->Close();
		if(m_pDG3rs->GetState()==adStateOpen) m_pDG3rs->Close();
		if(m_pDG4rs->GetState()==adStateOpen) m_pDG4rs->Close();
		if(m_pDG5rs->GetState()==adStateOpen) m_pDG5rs->Close();
		m_cDG2.Refresh();
		m_cDG3.Refresh();
		m_cDG4.Refresh();
		m_cDG5.Refresh();
	}

	UpdateData(FALSE); // 更新界面數(shù)據(jù)
	pRS.Release(); // 釋放
}

void CSalaryDlg::OnBtnChangesalary() 
{
	// 數(shù)據(jù)庫未連接則返回
	if(pTheConn->GetState()==adStateClosed) return;

	CString str;
	_variant_t Value;
	_RecordsetPtr pRS; // Recordset對(duì)象
	pRS.CreateInstance(__uuidof(Recordset)); // 創(chuàng)建
	UpdateData(); // 更新數(shù)據(jù)
	// 打開Recordset
	str="PersonID='" + m_strPersonID + "'";
	pRS->Filter=str.AllocSysString(); // 設(shè)置過濾條件
	pRS->Open("SALARY",
		pTheConn.GetInterfacePtr(),
		adOpenKeyset,adLockOptimistic,adCmdTable);
	if(pRS->RecordCount==1) // 判斷記錄是否存在
	{
		// 更新工資