cpp.rar_人事工资管理_数据库课程设计报告

// SalaryDlg.cpp : implementation file // Download by http://www.codefans.net #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 DECLARE_MESSAGE_MAP() }; CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD) { //{{AFX_DATA_INIT(CAboutDlg) //}}AFX_DATA_INIT } void CAboutDlg::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CAboutDlg) //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CAboutDlg, CDialog) //{{AFX_MSG_MAP(CAboutDlg) // No message handlers //}}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_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 // 设置项目缺省选择为奖金 ((CButton*)GetDlgItem(IDC_RADIO_BONUS))->SetCheck(TRUE); // 创建状态条 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); // 设定状态条 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)); // 创建DataGrid需要用的Recordset对象 m_pDG1rs.CreateInstance(__uuidof(Recordset)); // DataGrid1相关 m_pDG2rs.CreateInstance(__uuidof(Recordset)); // DataGrid2相关 m_pDG3rs.CreateInstance(__uuidof(Recordset)); // DataGrid3相关 m_pDG4rs.CreateInstance(__uuidof(Recordset)); // DataGrid4相关 m_pDG5rs.CreateInstance(__uuidof(Recordset)); // DataGrid5相关 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对象 m_pDG1rs.Release(); // DataGrid1相关 m_pDG2rs.Release(); // DataGrid2相关 m_pDG3rs.Release(); // DataGrid3相关 m_pDG4rs.Release(); // DataGrid4相关 m_pDG5rs.Release(); // DataGrid5相关 } void CSalaryDlg::OnSystemConnect() // 显示用户登录窗口 { CLoginDlg LoginDlg; if(LoginDlg.DoModal()==IDOK) // 认证通过 m_wndStatusBar.SetPaneText(1, "已连接到数据库: " + LoginDlg.m_strDSN); } void CSalaryDlg::OnSystemDisconnect() // 断开连接 { // 关闭Connetion对象 if(pTheConn->GetState()==adStateOpen) pTheConn->Close(); m_wndStatusBar.SetPaneText(1, "尚未登录数据库，请按F2登录"); } void CSalaryDlg::OnChangeEdtDepartid() { if(pTheConn->GetState()==adStateClosed) return; // 数据库未打开则返回 UpdateData(); // 更新数据 CString str; _variant_t Value; _RecordsetPtr pRS; // Recordset对象 pRS.CreateInstance