程序设计文档.doc

数据库建表脚本CREATE TABLE employee ( Id varchar(4) NOT NULL,UserName varchar(50),Telephone varchar(50),office varchar(50),age int,sex varchar(4),salary float,pwd varchar(50);程序主界面员工信息录入窗口界面设计员工信息保存方法代码：void CUserDialog:OnBnClickedOk()/ TODO: 在此添加控件通知处理程序代码UpdateData(TRUE);if(m_strUserId.IsEmpty()AfxMessageBox(请输入工号);return;if(m_strSex.IsEmpty()AfxMessageBox(请输入性别);return;if(m_strUserName.IsEmpty()AfxMessageBox(请输入姓名);if(m_strAge.IsEmpty()AfxMessageBox(请输入年龄);return;if(m_strSalary.IsEmpty()AfxMessageBox(请输入工资数);if(m_strOffice.IsEmpty()AfxMessageBox(请输入岗位);m_bIsNewUser = true;std:ostringstream oss;oss select id from employee where id= m_strUserId execQuery(oss.str().c_str();if(!query.eof()m_bIsNewUser = false;oss.str();int ok = 0;if(m_bIsNewUser)oss insert into employee(Id,UserName,Telephone,office,age,sex,salary) values( m_strUserId , m_strUserName , m_strPhone , m_strOffice , m_strAge , m_strSex , m_strSalary execDML(oss.str().c_str();elseoss update employee set UserName= m_strUserName ,Telephone= m_strPhone ,office= m_strOffice ,age= m_strAge ,sex= m_strSex ,salary= m_strSalary where id= m_strUserId execDML(oss.str().c_str();if(ok GetListCtrl();int cnt = list.GetItemCount();for(int i=0;icnt;i+)list.DeleteItem(0);std:ostringstream oss;oss select Id,UserName,Telephone,office,age,sex,salary from employee where 1=1 ;if(!dlg.m_strUserId.IsEmpty()oss and id like % dlg.m_strUserId ;if(!dlg.m_strUserName.IsEmpty()oss and UserName like % dlg.m_strUserName ;if(!dlg.m_strOffice.IsEmpty()oss and office like % dlg.m_strOffice ;if(!dlg.m_strSortField.IsEmpty()oss order by dlg.m_strSortField execQuery(sql.c_str();while(!q.eof()int col =0;CString strUserId = q.getStringField(col+);CString strUserName = q.getStringField(col+);CString strPhone = q.getStringField(col+);CString strOffice = q.getStringField(col+);CString strAge = q.getStringField(col+);CString strSex = q.getStringField(col+);CString strSalary = q.getStringField(col+);AddOrUpdate(strUserId,strUserName,strSex,strAge,strOffice,strSalary,strPhone);q.nextRow();用户删除代码void CSalaryMgrView:OnDelUser()/ TODO: 在此添加命令处理程序代码CListCtrl& list = this-GetListCtrl();int index = -1;index = list.GetNextItem(-1,LVIS_SELECTED);if(index 0)AfxMessageBox(请选择要删除的行);return;if(AfxMessageBox(确定要删除当前员工吗?,MB_OKCANCEL) != IDOK)return;CString strId = list.GetItemText(index,0);std:ostringstream oss;oss delete from employee where id = (LPCTSTR)strId execDML(sql.c_str();if(ok 0)list.DeleteItem(index);数据库文件备份代码void CSalaryMgrView:OnBackup()/ TODO: 在此添加命令处理程序代码TCHAR pathnameMAX_PATH;GetModuleFileName(NULL,pathname,MAX_PATH);CString path = pathname;path = path.Left(path.ReverseFind()+1);CString strSrc = path + database.db;CString strDst = path;std:string strDBPath = CharsetConvert:GBToUTF8(strSrc);CppSQLite3DB:instance()-close();SYSTEMTIME st;:GetLocalTime(&st);CString strFileName;strFileName.Format(database%04d%02d%02d%02d%02d%02d.db,st.wYear,st.wMonth,st.wDay,st.wHour,st.wMinute,st.wSecond);strDst += strFileName;BOOL fok = :CopyFile(strSrc,strDst,FALSE);if(fok)CString strmsg;strmsg.Format(备份成功，备份文件存