搜索
数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX1“工资管理系统”设计内容成员：XXX、XXX、XXX、XXX、XXX、XXX、XXX一、系统功能分析本系统要求实现以下主要功能：1.数据基本管理功能主要任务是对各种工资信息进行日常的管理，如：（1）工资信息的输入（2）数据的修改（3）数据的增加、删除2.数据查询功能系统需要提供以下查询功能：（1）员工基本信息情况查询：员工姓名，员工号，身份证号，职称，身份证号，银行卡号，电话（2）员工月工资情况查询：员工号，姓名，部门名，基本工资，各种扣款，加班费，应得工资（3）职称基本信息情况查询：职称名称，职称基本工资二、系统设计的功能模块数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX2三、E-R图设计四、需要建立的库和表1、建立“工资管理系统”数据库2、建立四张表（1）员工基本信息表数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX3（2）基本工资表数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX4（3）职称工资表数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX5（4）用户表数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX6五、程序和主要实现界面1、程序（1）界面//StaffSystermView.cpp:implementationoftheCStaffSystermViewclass//#includestdafx.h#includeStaffSysterm.h#includeStaffSystermDoc.h#includeStaffSystermView.h#includeafxdb.h#ifdef_DEBUG#definenewDEBUG_NEW#undefTHIS_FILEstaticcharTHIS_FILE[]=__FILE__;#endif#defineWM_INSERT2000#defineWM_DELETE2001#defineWM_ADDOVERTIME3000#defineWM_ADDPRIZE3001#defineWM_CANCELPRIZE3002#defineWM_ADDLATE3003#defineWM_WAGETOTAL3004#defineWM_CLEARPWAGE3005#defineWM_CLEARWAGE3006/////////////////////////////////////////////CStaffSystermViewIMPLEMENT_DYNCREATE(CStaffSystermView,CFormView)BEGIN_MESSAGE_MAP(CStaffSystermView,CFormView)//{{AFX_MSG_MAP(CStaffSystermView)ON_COMMAND(IDM_SHOWTAFF,OnShowtaff)ON_COMMAND(IDM_STAFFWAGE,OnStaffwage)ON_COMMAND(IDM_ADDSTAFF,OnAddstaff)ON_COMMAND(IDM_DELETESTAFF,OnDeletestaff)ON_COMMAND(IDM_LATEADD,OnLateadd)ON_COMMAND(IDM_PRIZE,OnPrize)ON_COMMAND(IDM_TOTAL,OnTotal)ON_COMMAND(IDM_CLEARPRIZE,OnClearprize)ON_COMMAND(IDM_CLEARSWAGE,OnClearswage)ON_COMMAND(IDM_CLEARWAGE,OnClearwage)ON_COMMAND(IDM_OVERTIMEWAGE,OnOvertimewage)ON_NOTIFY(NM_RCLICK,IDC_LIST1,OnRclickList1)ON_COMMAND(ID_BUTTON32791,OnButton32791)ON_COMMAND(ID_BUTTON32792,OnButton32792)ON_COMMAND(ID_BUTTON32794,OnButton32794)ON_COMMAND(ID_BUTTON32795,OnButton32795)ON_COMMAND(ID_BUTTON32796,OnButton32796)ON_COMMAND(ID_BUTTON32797,OnButton32797)ON_COMMAND(ID_BUTTON32798,OnButton32798)ON_BN_CLICKED(IDC_BTN_FIND,OnBtnFind)ON_COMMAND(ID_BUTTON32800_SHOWSTAFF,数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX7OnButton32800Showstaff)ON_COMMAND(ID_BUTTON32804_SHOWWAGE,OnButton32804Showwage)ON_COMMAND(ID_BUTTON32805_PRINTVIEW,OnButton32805Printview)ON_COMMAND(IDM_UPDATAZCWAGE,OnUpdatazcwage)ON_COMMAND(IDM_ADDZC,OnAddzc)ON_COMMAND(IDM_SHOWZC,OnShowzc)ON_COMMAND(ID_BUTTON32809_ZC,OnButton32809Zc)ON_COMMAND(WM_INSERT,OnAddstaff)ON_COMMAND(WM_DELETE,OnDeletestaff)ON_COMMAND(WM_ADDOVERTIME,OnOvertimewage)ON_COMMAND(WM_ADDPRIZE,OnPrize)ON_COMMAND(WM_CANCELPRIZE,OnClearprize)ON_COMMAND(WM_ADDLATE,OnLateadd)ON_COMMAND(WM_WAGETOTAL,OnTotal)ON_COMMAND(WM_CLEARPWAGE,OnClearswage)ON_COMMAND(WM_CLEARWAGE,OnClearwage)ON_COMMAND(IDM_SAVEDATABASE,OnSavedatabase)ON_COMMAND(IDM_RESTORE,OnRestore)//}}AFX_MSG_MAP//StandardprintingcommandsON_COMMAND(ID_FILE_PRINT,CFormView::OnFilePrint)ON_COMMAND(ID_FILE_PRINT_DIRECT,CFormView::OnFilePrint)ON_COMMAND(ID_FILE_PRINT_PREVIEW,CFormView::OnFilePrintPreview)END_MESSAGE_MAP()/////////////////////////////////CStaffSystermViewconstruction/destructionCStaffSystermView::CStaffSystermView():CFormView(CStaffSystermView::IDD){//{{AFX_DATA_INIT(CStaffSystermView)//}}AFX_DATA_INIT//TODO:addconstructioncodeherem_login.DoModal();pDb=newCDatabase();}CStaffSystermView::~CStaffSystermView(){}voidCStaffSystermView::DoDataExchange(CDataExchange*pDX){CFormView::DoDataExchange(pDX);//{{AFX_DATA_MAP(CStaffSystermView)DDX_Control(pDX,IDC_COMBO_FIND,m_ControlComFind);DDX_Control(pDX,IDC_LIST2,m_findTemp);DDX_Control(pDX,IDC_LIST1,m_DataArea);//}}AFX_DATA_MAP}BOOLCStaffSystermView::PreCreateWindow(CREATESTRUCT&cs){//TODO:ModifytheWindowclassorstylesherebymodifying//theCREATESTRUCTcsreturnCFormView::PreCreateWindow(cs);}voidCStaffSystermView::OnInitialUpdate(){CFormView::OnInitialUpdate();GetParentFrame()-RecalcLayout();ResizeParentToFit();m_DataArea.SetExtendedStyle(LVS_EX_FLATSB//扁平风格滚动条|LVS_EX_FULLROWSELECT//允许整行选中|LVS_EX_HEADERDRAGDROP//允许标题拖拽|LVS_EX_ONECLICKACTIVATE//高亮显数据库原理及应用姓名：XXX班级：通信XXX班学号：XXXXXXXXXX8示|LVS_EX_GRIDLINES//画出网格线);m_findTemp.SetExtendedStyle(LVS_EX_FLATSB//扁平风格滚动条|LVS_EX_FULLROWSELECT//允许整行选中|LVS_EX_HEADERDRAGDROP//允许标题拖拽|LVS_EX_ONECLICKACTIVATE//高亮显示|LVS_EX_GRIDLINES//画出网格线);m_ControlComFind.AddString(员工号);m_ControlComFind.AddString(员工姓名);SetDlgItemText(IDC_COMBO_FIND,员工号);}///////////////////////////////////////////CStaffSystermViewprintingBOOLCStaffSystermView::OnPreparePrinting(CPrintInfo*pInfo){//defaultpreparationreturnDoPreparePrinting(pInfo);}voidCStaffSystermView::OnBeginPrinting(CDC*/*pDC*/,CPrintInfo*/*pInfo*/){//TODO:addextrainitializationbeforeprinting}voidCStaffSystermView::OnEndPrinting(CDC*/*pDC*/,CPrintInfo*/*pInfo*/){//TODO:addcleanupafterprinting}voidCStaffSystermView::OnPrint(CDC*pDC,CPrintInfo*/*pInfo*/){//TODO:addcustomizedprintingcodehere}/////////////////////////////////////////////CStaffSystermViewdiagnostics#ifdef_DEBUGvoidCStaffSystermView::AssertValid()const{CFormView::AssertValid();}voidCStaffSystermView::Dump(CDumpContext&dc)const{CFormView::D