sellamountdlg.cpp

数据库开发的工资管理系统

#include "stdafx.h"
#include "SalaryManagement.h"
#include "SellamountDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
BOOL CSellamountDlg::OnInitDialog(){  //重载初始化对话框的虚函数
	CListCtrl *pList=(CListCtrl *)GetDlgItem(IDC_SELLAMOUNT_RECORD_LIST);  //建立一个控制列表控件资源的指针
	//初始化要显示的列表控件
	pList->InsertColumn(0,"职员号");
	pList->InsertColumn(1,"姓名");
	pList->InsertColumn(2,"本月销售额");
	pList->SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);  //设置列表的风格 有网格线 全行选中
	//列表控件的一列的宽度
	RECT ListRect;  //得到列表控件的空间
	pList->GetWindowRect(&ListRect);
	int breadth=ListRect.right-ListRect.left;  //得到列表控件的宽度
	pList->SetColumnWidth(0,breadth/3-1);
	pList->SetColumnWidth(1,breadth/3-1);
	pList->SetColumnWidth(2,breadth/3-1);
	//列出职员信息
	DisplaySellamountList();  //列出职员信息
	//界面的其他细节
	CButton *pButton=(CButton *)GetDlgItem(IDC_SELLAMOUNT_CONFIRM_BUTTON);  //按钮不可用
	pButton->EnableWindow(FALSE);

	CDialog::OnInitDialog();
	return TRUE;
}

void CSellamountDlg::DisplaySellamountList(){  //显示销售额列表
	CListCtrl *pList=(CListCtrl *)GetDlgItem(IDC_SELLAMOUNT_RECORD_LIST);  //建立一个控制列表控件资源的指针

	pDepartment->GetDepartmentEmployee();  //得到此部门的全部职员基本信息
	pDepartment->GetEmployeeSellamount();  //职员的销售额信息

	pList->DeleteAllItems();  //删除原有的条目
	int temp;  //用来存放销售额
	char sellamount[10];
	int i=0;
	int j=pDepartment->GetEmployeeNumber();  //j为此部门中职员的人数
	while(i<j){  //得到这个部门的职员信息
		pList->InsertItem(i,"");
		pList->SetItemText(i,0,(pDepartment->m_employee+i)->GetEmployeeID());  //职员号
		pList->SetItemText(i,1,(pDepartment->m_employee+i)->GetEmployeeName());  //姓名
		temp=(pDepartment->m_employee+i)->GetEmployeeSellamount();  //得到职员的销售额
		sprintf(sellamount,"%d",temp);
		pList->SetItemText(i,2,sellamount);  //销售额
		i++;
	}
	UpdateData(FALSE);
}
/*------------------------------------------------------------------------------------*/		
CSellamountDlg::CSellamountDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSellamountDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSellamountDlg)
	m_name = _T("");
	m_id = _T("");
	m_sellamount = _T("");
	//}}AFX_DATA_INIT
}


void CSellamountDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSellamountDlg)
	DDX_Control(pDX, IDC_SELLAMOUNT_RECORD_LIST, m_recordlist);
	DDX_Text(pDX, IDC_SELLAMOUNT_NAME_EDIT, m_name);
	DDX_Text(pDX, IDC_SELLAMOUNT_ID_EDIT, m_id);
	DDX_Text(pDX, IDC_SELLAMOUNT_AMOUNT_EDIT, m_sellamount);
	DDV_MaxChars(pDX, m_sellamount, 6);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSellamountDlg, CDialog)
	//{{AFX_MSG_MAP(CSellamountDlg)
	ON_NOTIFY(NM_CLICK, IDC_SELLAMOUNT_RECORD_LIST, OnClickSellamountRecordList)
	ON_BN_CLICKED(IDC_SELLAMOUNT_CONFIRM_BUTTON, OnSellamountConfirmButton)
	ON_BN_CLICKED(IDC_SELLAMOUNT_CANCEL_BUTTON, OnSellamountCancelButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSellamountDlg message handlers

void CSellamountDlg::OnClickSellamountRecordList(NMHDR* pNMHDR, LRESULT* pResult){
	CListCtrl *pList=(CListCtrl *)GetDlgItem(IDC_SELLAMOUNT_RECORD_LIST);  //建立一个控制列表控件资源的指针
	int i=pList->GetSelectionMark();

	m_id=pList->GetItemText(i,0);  
	m_name=pList->GetItemText(i,1);
	m_sellamount=pList->GetItemText(i,2);

	CButton *pButton=(CButton *)GetDlgItem(IDC_SELLAMOUNT_CONFIRM_BUTTON);  //按钮可用
	pButton->EnableWindow(TRUE);
	UpdateData(FALSE);
	*pResult = 0;
}

void CSellamountDlg::OnSellamountConfirmButton(){  //更新职员的销售额
	CString SQL;  //建立要操作的SQL语句
	UpdateData(TRUE);
	if(pDepartment->GetDepartmentName()=="A部门")
		SQL="update AYear"+pDepartment->GetYear()+" set "+pDepartment->GetMonth()+"="+m_sellamount+" where 职员号='"+m_id+"'";  //对A部门的表进行操作
	else if(pDepartment->GetDepartmentName()=="B部门")
		SQL="update BYear"+pDepartment->GetYear()+" set "+pDepartment->GetMonth()+"="+m_sellamount+" where 职员号='"+m_id+"'";  //专门操作数据库中B部门的表
	else if(pDepartment->GetDepartmentName()=="C部门")
		SQL="update CYear"+pDepartment->GetYear()+" set "+pDepartment->GetMonth()+"="+m_sellamount+" where 职员号='"+m_id+"'";  //专门操作数据库中C部门的表
	database.ExecuteSQL(SQL);  //执行SQL语句

	DisplaySellamountList();  //显示修改后的结果
	CButton *pButton=(CButton *)GetDlgItem(IDC_SELLAMOUNT_CONFIRM_BUTTON);  //按钮不可用
	pButton->EnableWindow(FALSE);
}

void CSellamountDlg::OnSellamountCancelButton(){  //取消
	EndDialog(IDCANCEL);
}