呵呵 这里包含所有我毕业设计的源代码 纯属无聊 贴上来玩玩后台数据库结构和资源文件就免了 不想被人不劳而获________________________________________________________课题名称:企业办公文档管理系统的设计与实现

/************************************************* * ADOConn.h: interface for the ADOConn class. ** 功能：用于实现以ADO方式进行数据库连接 **************************************************/#if !defined(AFX_ADOCONN_H__B8D01B34_20DA_49AE_9FA1_664D67A28ABD__INCLUDED_)#define AFX_ADOCONN_H__B8D01B34_20DA_49AE_9FA1_664D67A28ABD__INCLUDED_//导入用ADO方式连接数据库时所使用的动态连接库：msado15.dll#import "C:\Program Files\Common Files\System\ado\msado15.dll" no_namespace rename("EOF","adoEOF")rename("BOF","adoBOF")#if _MSC_VER > 1000
#pragma once#
endif // _MSC_VER > 1000class ADOConn {public://添加一个指向Connection对象的指针 _ConnectionPtr m_pConnection;//添加一个指向Recordset对象的指针_RecordsetPtr m_pRecordset;public:ADOConn();virtual ~ADOConn();//初始化--连接数据库 void OnInitADOConn();//执行查询 _RecordsetPtr& GetRecordSet(_bstr_t bstrSQL);//执行SQL语句 BOOL ExecuteSQL(_bstr_t bstrSQL);//断开数据库连接void ExitConnect();};#endif // !defined(AFX_ADOCONN_H__B8D01B34_20DA_49AE_9FA1_664D67A28ABD__INCLUDED_)

//Chaxundlg.h//查询模块头文件#if !defined(AFX_CHAXUNDLG_H__47D1A1A4_7D4D_4A71_AE77_5FB0FDD17D2D__INCLUDED_)#define AFX_CHAXUNDLG_H__47D1A1A4_7D4D_4A71_AE77_5FB0FDD17D2D__INCLUDED_
#include "Zdxxb.h"#
include "Dwxxb.h"
#if _MSC_VER > 1000#
pragma once#endif // _MSC_VER > 1000// Chaxundlg.h : header file//extern CZdxxb zdxxb;/////////////////////////////////////////////////////////////////////////////// CChaxundlg dialogclass CChaxundlg : public CDialog{// Constructionpublic:int cx;CChaxundlg(CWnd* pParent = NULL); // standard constructorCDwxxb dwb;CZdxxb xxb;// Dialog Data//{{AFX_DATA(CChaxundlg)CComboBoxm_cxfs;CStringm_cxz;//}}AFX_DATA// Overrides// ClassWizard generated virtual function overrides//{{AFX_VIRTUAL(CChaxundlg)protected:virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support//}}AFX_VIRTUAL// Implementationprotected:HICON m_hIcon;// Generated message map functions//{{AFX_MSG(CChaxundlg)virtual BOOL OnInitDialog();virtual void OnOK();//}}AFX_MSGDECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_CHAXUNDLG_H__47D1A1A4_7D4D_4A71_AE77_5FB0FDD17D2D__INCLUDED_)

// Chaxundlg.cpp : implementation file//
#include "stdafx.h"#
include "WordGLXT.h"
#include "Chaxundlg.h"#
ifdef _DEBUG
#define new DEBUG_NEW#
undef THIS_FILEstatic char THIS_FILE[] = __FILE__;#endif/////////////////////////////////////////////////////////////////////////////// CChaxundlg dialogCChaxundlg::CChaxundlg(CWnd* pParent /*=NULL*/): CDialog(CChaxundlg::IDD, pParent){//{{AFX_DATA_INIT(CChaxundlg)m_cxz = _T("");//}}AFX_DATA_INITm_hIcon = AfxGetApp()->LoadIcon(IDI_ICONFIND);}void CChaxundlg::DoDataExchange(CDataExchange* pDX){CDialog::DoDataExchange(pDX);//{{AFX_DATA_MAP(CChaxundlg)DDX_Control(pDX, IDC_COMBO1, m_cxfs);DDX_Text(pDX, IDC_EDIT1, m_cxz);//}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP(CChaxundlg, CDialog)//{{AFX_MSG_MAP(CChaxundlg)//}}AFX_MSG_MAPEND_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////// CChaxundlg message handlersBOOL CChaxundlg::OnInitDialog() {CDialog::OnInitDialog();// TODO: Add extra initialization hereSetIcon(m_hIcon, TRUE);switch(cx){case 0:m_cxfs.AddString("关键字");break;case 1:m_cxfs.AddString("文档名称");break;}UpdateData(false);return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE}void CChaxundlg::OnOK() {// TODO: Add extra validation hereUpdateData(true);CString str,strzd;m_cxfs.GetLBText(m_cxfs.GetCurSel(),str);if(str=="关键字"){zdxxb.SetGJz(m_cxz);}else if(str=="文档名称"){if(xxb.sql_selectwdmc(m_cxz)>=1){zdxxb.SetWDmc(m_cxz);}else{MessageBox("文档不存在!","企业办公文档管理系统");return;}}CDialog::OnOK();}

//Dialogin.h//登录模块头文件#if !defined(AFX_DIALOGIN_H__0D90A8D2_2496_4AAB_B490_B4A567CB7B90__INCLUDED_)#define AFX_DIALOGIN_H__0D90A8D2_2496_4AAB_B490_B4A567CB7B90__INCLUDED_
#include "Rizhib.h"#
include "Users.h"
#if _MSC_VER > 1000#
pragma once#endif // _MSC_VER > 1000// Dialogin.h : header file//extern CUsers user;/////////////////////////////////////////////////////////////////////////////// CDialogin dialogclass CDialogin : public CDialog{// Constructionpublic:CString jb;CRizhib zhi;CTime t;CDialogin(CWnd* pParent = NULL); // standard constructor// Dialog Data//{{AFX_DATA(CDialogin)enum { IDD = IDD_DIALOGIN };CStringm_name;CStringm_pwd;//}}AFX_DATA// Overrides// ClassWizard generated virtual function overrides//{{AFX_VIRTUAL(CDialogin)public:protected:virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support//}}AFX_VIRTUAL// Implementationprotected:HICON m_hIcon;// Generated message map functions//{{AFX_MSG(CDialogin)virtual BOOL OnInitDialog();virtual void OnOK();//}}AFX_MSGDECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_DIALOGIN_H__0D90A8D2_2496_4AAB_B490_B4A567CB7B90__INCLUDED_)

// Dialogin.cpp : implementation file//
#include "stdafx.h"#
include "WordGLXT.h"
#include "Dialogin.h"#
ifdef _DEBUG
#define new DEBUG_NEW#
undef THIS_FILEstatic char THIS_FILE[] = __FILE__;#endif/////////////////////////////////////////////////////////////////////////////// CDialogin dialogCDialogin::CDialogin(CWnd* pParent /*=NULL*/): CDialog(CDialogin::IDD, pParent){//{{AFX_DATA_INIT(CDialogin)m_name = _T("");m_pwd = _T("");//}}AFX_DATA_INITm_hIcon = AfxGetApp()->LoadIcon(IDI_ICONLOGIN);}void CDialogin::DoDataExchange(CDataExchange* pDX){CDialog::DoDataExchange(pDX);//{{AFX_DATA_MAP(CDialogin)DDX_Text(pDX, IDC_EDIT1, m_name);DDX_Text(pDX, IDC_EDIT2, m_pwd);//}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP(CDialogin, CDialog)//{{AFX_MSG_MAP(CDialogin)//}}AFX_MSG_MAPEND_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////// CDialogin message handlersBOOL CDialogin::OnInitDialog() {CDialog::OnInitDialog();// TODO: Add extra initialization hereSetIcon(m_hIcon, TRUE);return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE}void CDialogin::OnOK() {// TODO: Add extra validation here//将对话框中编辑框的数据读取到成员变量中UpdateData(true);//检查数据有效性if(m_name==""){MessageBox("请输入用户名!","企业办公文档管理系统");return;}if(m_pwd==""){MessageBox("请输入密码!","企业办公文档管理系统");return;}//如果读取数据和用户输入不同，则返回if(user.HaveCzy(m_name,m_pwd)!=1){MessageBox("用户名或密码错误!","企业办公文档管理系统");return;}user.SetUsername(m_name);//判断用户级别jb="1";if(user.HaveCzyjb(m_name,m_pwd,jb)==1){user.SetJB(jb);}else{user.SetJB("0");}//读取当前系统时间t=CTime::GetCurrentTime();//将登录动作记录到日志表zhi.SetDLsj(t.Format("%y-%m-%d"));zhi.SetName(user.GetUsername());zhi.SetDZ("登录");zhi.sql_insert();CDialog::OnOK();}

//Dvdandlg.h//单位档案管理模块头文件#if !defined(AFX_DWDANDLG_H__612710E2_1476_4F28_B74D_DD72B2169274__INCLUDED_)#define AFX_DWDANDLG_H__612710E2_1476_4F28_B74D_DD72B2169274__INCLUDED_
#include "Dwxxb.h"#
include "Zdmlb.h"
#include "Zdxxb.h"#
include "Rizhib.h"
#include "Users.h"#
if _MSC_VER > 1000
#pragma once#
endif // _MSC_VER > 1000// Dwdandlg.h : header file//extern CUsers user;/////////////////////////////////////////////////////////////////////////////// CDwdandlg dialogclass CDwdandlg : public CDialog{// Constructionpublic:CDwdandlg(CWnd* pParent = NULL); // standard constructorCRizhib zhi;CTime t;void SetCurTab(UINT m_index);// Dialog Data//{{AFX_DATA(CDwdandlg)enum { IDD = IDD_DWDAN };CListCtrlm_list;CTabCtrlm_tab;CStringm_lxdz;intm_dwbh;CStringm_dwmc;CStringm_lxr;CStringm_lxdh;CStringm_memo;//}}AFX_DATA// Overrides// ClassWizard generated virtual function overrides//{{AFX_VIRTUAL(CDwdandlg)public:virtual BOOL PreTranslateMessage(MSG* pMsg);protected:virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support//}}AFX_VIRTUAL// Implementationprotected:HICON m_hIcon;// Generated message map functions//{{AFX_MSG(CDwdandlg)virtual void OnOK();afx_msg void OnModbutton();afx_msg void OnDelbutton();virtual BOOL OnInitDialog();afx_msg void OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult);afx_msg void OnSelchangingTab1(NMHDR* pNMHDR, LRESULT* pResult);afx_msg void OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult);//}}AFX_MSGDECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_DWDANDLG_H__612710E2_1476_4F28_B74D_DD72B2169274__INCLUDED_)

// Dwdandlg.cpp : implementation file//
#include "stdafx.h"#
include "WordGLXT.h"
#include "Dwdandlg.h"#
ifdef _DEBUG
#define new DEBUG_NEW#
undef THIS_FILEstatic char THIS_FILE[] = __FILE__;#endif/////////////////////////////////////////////////////////////////////////////// CDwdandlg dialogCDwdandlg::CDwdandlg(CWnd* pParent /*=NULL*/): CDialog(CDwdandlg::IDD, pParent){//{{AFX_DATA_INIT(CDwdandlg)m_lxdz = _T("");m_dwbh = 0;m_dwmc = _T("");m_lxr = _T("");m_lxdh = _T("");m_memo = _T("");//}}AFX_DATA_INITm_hIcon = AfxGetApp()->LoadIcon(IDI_ICONDANWEI);}void CDwdandlg::DoDataExchange(CDataExchange* pDX){CDialog::DoDataExchange(pDX);//{{AFX_DATA_MAP(CDwdandlg)DDX_Control(pDX, IDC_LIST1, m_list);DDX_Control(pDX, IDC_TAB1, m_tab);DDX_Text(pDX, IDC_EDIT5, m_lxdz);DDX_Text(pDX, IDC_EDIT1, m_dwbh);DDX_Text(pDX, IDC_EDIT2, m_dwmc);DDX_Text(pDX, IDC_EDIT3, m_lxr);DDX_Text(pDX, IDC_EDIT4, m_lxdh);DDX_Text(pDX, IDC_EDIT6, m_memo);//}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP(CDwdandlg, CDialog)//{{AFX_MSG_MAP(CDwdandlg)ON_BN_CLICKED(IDC_MODBUTTON, OnModbutton)ON_BN_CLICKED(IDC_DELBUTTON, OnDelbutton)ON_NOTIFY(TCN_SELCHANGE, IDC_TAB1, OnSelchangeTab1)ON_NOTIFY(TCN_SELCHANGING, IDC_TAB1, OnSelchangingTab1)ON_NOTIFY(NM_DBLCLK, IDC_LIST1, OnDblclkList1)//}}AFX_MSG_MAPEND_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////// CDwdandlg message handlersvoid CDwdandlg::OnOK() {// TODO: Add extra validation hereUpdateData(true);if(m_dwmc==""){MessageBox("单位名称不能为空!","企业办公文档管理系统");return;}CDwxxb dwb;if(dwb.HaveId(m_dwbh)==1){MessageBox("单位编号已存在!","企业办公文档管理系统");return;}if(m_lxdh.GetLength()>12){MessageBox("电话号码不正确!","企业办公文档管理系统");return;}dwb.SetDWbh(m_dwbh);dwb.SetDWmc(m_dwmc);dwb.SetLxr(m_lxr);dwb.SetLxdh(m_lxdh);dwb.SetLxdz(m_lxdz);dwb.SetMemo(m_memo);dwb.sql_insert();zhi.SetDLsj(t.Format("%y-%m-%d"));zhi.SetName(user.GetUsername());zhi.SetDZ("单位添加");zhi.sql_insert();CDialog::OnOK();}void CDwdandlg::OnModbutton() {// TODO: Add your control notification handler code hereUpdateData(true);if(m_dwmc==""){MessageBox("单位名称不能为空!","企业办公文档管理系统");return;}if(m_lxdh.GetLength()>12){MessageBox("电话号码不正确!","企业办公文档管理系统");return;}CDwxxb dwb;dwb.SetDWmc(m_dwmc);dwb.SetLxr(m_lxr);dwb.SetLxdh(m_lxdh);dwb.SetLxdz(m_lxdz);dwb.SetMemo(m_memo);dwb.sql_update(m_dwbh);zhi.SetDLsj(t.Format("%y-%m-%d"));zhi.SetName(user.GetUsername());zhi.SetDZ("单位修改");zhi.sql_insert();CDialog::OnOK();}void CDwdandlg::OnDelbutton() {// TODO: Add your control notification handler code hereUpdateData(true);CDwxxb dwb;dwb.sql_delete(m_dwbh);CZdmlb mlb;mlb.sql_deletedw(m_dwbh);CZdxxb xxb;xxb.sql_deletedw(m_dwbh);zhi.SetDLsj(t.Format("%y-%m-%d"));

zhi.SetName(user.GetUsername());zhi.SetDZ("单位删除");zhi.sql_insert();CDialog::OnOK();}BOOL CDwdandlg::OnInitDialog() {CDialog::OnInitDialog();// TODO: Add extra initialization hereSetIcon(m_hIcon, TRUE);t=CTime::GetCurrentTime();TC_ITEM tci;tci.mask=TCIF_TEXT;tci.pszText="单位档案";m_tab.InsertItem(0,&tci);tci.pszText="单位列表";m_tab.InsertItem(1,&tci);GetDlgItem(IDC_LIST1)->ShowWindow(SW_HIDE);UpdateData(true);m_list.SetExtendedStyle(LVS_EX_FLATSB|LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);m_list.InsertColumn(0,"单位编号",LVCFMT_LEFT,100,0);m_list.InsertColumn(1,"单位名称",LVCFMT_LEFT,100,1);m_list.InsertColumn(2,"联系人",LVCFMT_LEFT,100,2);m_list.InsertColumn(3,"联系电话",LVCFMT_LEFT,100,3);m_list.InsertColumn(4,"联系地址",LVCFMT_LEFT,100,4);m_list.InsertColumn(6,"备注",LVCFMT_LEFT,100,5);ADOConn m_AdoConn;m_AdoConn.OnInitADOConn();CString sql;sql.Format("select* from Dwxxb order by dwbh desc");m_AdoConn.GetRecordSet((_bstr_t)sql);while(m_AdoConn.m_pRecordset->adoEOF==0){m_list.InsertItem(0,"");m_list.SetItemText(0,0,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("dwbh"));m_list.SetItemText(0,1,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("dwmc"));m_list.SetItemText(0,2,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("lxr"));m_list.SetItemText(0,3,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("lxdh"));m_list.SetItemText(0,4,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("lxdz"));m_list.SetItemText(0,5,(char*)(_bstr_t)m_AdoConn.m_pRecordset->GetCollect("memo"));m_AdoConn.m_pRecordset->MoveNext();}m_AdoConn.ExitConnect();m_dwbh=1;UpdateData(false);return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE}void CDwdandlg::OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult) {// TODO: Add your control notification handler code hereswitch(m_tab.GetCurSel()){case 0: GetDlgItem(IDC_EDIT1)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT2)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT3)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT4)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT5)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT6)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC1)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC2)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC3)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC4)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC5)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC6)->ShowWindow(SW_SHOW);GetDlgItem(IDOK)->ShowWindow(SW_SHOW);GetDlgItem(IDCANCEL)->ShowWindow(SW_SHOW);GetDlgItem(IDC_MODBUTTON)->ShowWindow(SW_SHOW);GetDlgItem(IDC_DELBUTTON)->ShowWindow(SW_SHOW);break;case 1: GetDlgItem(IDC_LIST1)->ShowWindow(SW_SHOW);break;}*pResult = 0;}void CDwdandlg::OnSelchangingTab1(NMHDR* pNMHDR, LRESULT* pResult) {// TODO: Add your control notification handler code hereswitch(m_tab.GetCurSel()){

case 0: GetDlgItem(IDC_EDIT1)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT2)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT3)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT4)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT5)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT6)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC1)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC2)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC3)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC4)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC5)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC6)->ShowWindow(SW_HIDE);GetDlgItem(IDOK)->ShowWindow(SW_HIDE);GetDlgItem(IDCANCEL)->ShowWindow(SW_HIDE);GetDlgItem(IDC_MODBUTTON)->ShowWindow(SW_HIDE);GetDlgItem(IDC_DELBUTTON)->ShowWindow(SW_HIDE);break;case 1: GetDlgItem(IDC_LIST1)->ShowWindow(SW_HIDE);break;}*pResult = 0;}void CDwdandlg::SetCurTab(UINT m_index){m_tab.SetCurSel(m_index);if(m_index==0){GetDlgItem(IDC_LIST1)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT1)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT2)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT3)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT4)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT5)->ShowWindow(SW_SHOW);GetDlgItem(IDC_EDIT6)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC1)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC2)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC3)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC4)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC5)->ShowWindow(SW_SHOW);GetDlgItem(IDC_STATIC6)->ShowWindow(SW_SHOW);GetDlgItem(IDOK)->ShowWindow(SW_SHOW);GetDlgItem(IDCANCEL)->ShowWindow(SW_SHOW);GetDlgItem(IDC_MODBUTTON)->ShowWindow(SW_SHOW);GetDlgItem(IDC_DELBUTTON)->ShowWindow(SW_SHOW);}else{GetDlgItem(IDC_EDIT1)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT2)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT3)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT4)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT5)->ShowWindow(SW_HIDE);GetDlgItem(IDC_EDIT6)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC1)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC2)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC3)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC4)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC5)->ShowWindow(SW_HIDE);GetDlgItem(IDC_STATIC6)->ShowWindow(SW_HIDE);GetDlgItem(IDOK)->ShowWindow(SW_HIDE);GetDlgItem(IDCANCEL)->ShowWindow(SW_HIDE);GetDlgItem(IDC_MODBUTTON)->ShowWindow(SW_HIDE);GetDlgItem(IDC_DELBUTTON)->ShowWindow(SW_HIDE);GetDlgItem(IDC_LIST1)->ShowWindow(SW_SHOW);}}void CDwdandlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) {// TODO: Add your control notification handler code hereUpdateData(true);int pos;pos=m_list.GetSelectionMark();SetCurTab(0);m_dwbh=atoi(m_list.GetItemText(pos,0));m_dwmc=m_list.GetItemText(pos,1);m_lxr=m_list.GetItemText(pos,2);m_lxdh=m_list.GetItemText(pos,3);m_lxdz=m_list.GetItemText(pos,4);m_memo=m_list.GetItemText(pos,5);UpdateData(false);*pResult = 0;}BOOL CDwdandlg::PreTranslateMessage(MSG* pMsg) {// TODO: Add your specialized code here and/or call the base classif(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)pMsg->wParam=9;return CDialog::PreTranslateMessage(pMsg);}

/*************************************************** * Dwxxb.h: interface for the CDwxxb class. ** 功能：单位信息表对应的类 ** 说明：类成员变量对应表列， ** 类成员函数对应成员变量和可对该表进行的操作 ****************************************************/#if !defined(AFX_DWXXB_H__2FE717C8_1CF0_4C28_BD9A_8EB534760021__INCLUDED_)#define AFX_DWXXB_H__2FE717C8_1CF0_4C28_BD9A_8EB534760021__INCLUDED_
#include "ADOConn.h"#
if _MSC_VER > 1000
#pragma once#
endif // _MSC_VER > 1000class CDwxxb {private:int DWbh;CString DWmc;CString Lxr;CString Lxdh;CString Lxdz;CString Memo;public:CDwxxb();virtual ~CDwxxb();CStringArray a_DWbh;CStringArray a_DWmc;int GetDWbh();void SetDWbh(int iDWbh);CString GetDWmc();void SetDWmc(CString cDWmc);CString GetLxr();void SetLxr(CString cLxr);CString GetLxdh();void SetLxdh(CString cLxdh);CString GetLxdz();void SetLxdz(CString cLxdz);CString GetMemo();void SetMemo(CString cMemo);void sql_insert();void sql_update(int iDWbh);void sql_delete(int iDWbh);//批量读取表中数据void Load_dep();//判断是否存在相同记录int HaveId(int iDWbh);};#endif // !defined(AFX_DWXXB_H__2FE717C8_1CF0_4C28_BD9A_8EB534760021__INCLUDED_)

// Dwxxb.cpp: implementation of the CDwxxb class.////////////////////////////////////////////////////////////////////////
#include "stdafx.h"#
include "WordGLXT.h"
#include "Dwxxb.h"#
ifdef _DEBUG#undef THIS_FILEstatic char THIS_FILE[]=__FILE__;#define new DEBUG_NEW#endif//////////////////////////////////////////////////////////////////////// Construction/Destruction//////////////////////////////////////////////////////////////////////CDwxxb::CDwxxb(){}CDwxxb::~CDwxxb(){}int CDwxxb::GetDWbh(){return DWbh;}void CDwxxb::SetDWbh(int iDWbh){DWbh=iDWbh;}CString CDwxxb::GetDWmc(){return DWmc;}void CDwxxb::SetDWmc(CString cDWmc){DWmc=cDWmc;}CString CDwxxb::GetLxr(){return Lxr;}void CDwxxb::SetLxr(CString cLxr){Lxr=cLxr;}CString CDwxxb::GetLxdh(){return Lxdh;}void CDwxxb::SetLxdh(CString cLxdh){Lxdh=cLxdh;}CString CDwxxb::GetLxdz(){return Lxdz;}void CDwxxb::SetLxdz(CString cLxdz){Lxdz=cLxdz;}CString CDwxxb::GetMemo(){return Memo;}void CDwxxb::SetMemo(CString cMemo){Memo=cMemo;}void CDwxxb::sql_insert(){ ADOConn m_AdoConn;CString strDWbh;strDWbh.Format("%d",DWbh);_bstr_t vSQL;vSQL="INSERT INTO Dwxxb(DWbh,DWmc,Lxr,Lxdh,Lxdz,Memo)VALUES("+strDWbh+",'"+DWmc+"','"+Lxr+"','"+Lxdh+"','"+Lxdz+"','"+Memo+"')"; m_AdoConn.ExecuteSQL(vSQL); m_AdoConn.ExitConnect();}void CDwxxb::sql_update(int iDWbh){ ADOConn m_AdoConn;CString strDWbh;strDWbh.Format("%d",iDWbh);_bstr_t vSQL;vSQL="UPDATE Dwxxb SET DWmc='"+DWmc+"',Lxr='"+Lxr+"',Lxdh='"+Lxdh+"',Lxdz='"+Lxdz+"',Memo='"+Memo+"' WHERE DWbh="+" "+strDWbh+""; m_AdoConn.ExecuteSQL(vSQL);m_AdoConn.ExitConnect();}void CDwxxb::sql_delete(int iDWbh){ ADOConn m_AdoConn; m_AdoConn.OnInitADOConn();CString sql;sql.Format("delete from Dwxxb where DWbh='%i'",iDWbh);m_AdoConn.ExecuteSQL((_bstr_t)sql);m_AdoConn.ExitConnect();}void CDwxxb::Load_dep(){//连接数据库 ADOConn m_AdoConn;m_AdoConn.OnInitADOConn(); //设置SQL语句_bstr_t vSQL;vSQL="SELECT*FROM Dwxxb ORDER BY DWbh"; _RecordsetPtr m_pRecordset; m_pRecordset=m_AdoConn.GetRecordSet(vSQL);//初始化数组a_DWbh.RemoveAll();a_DWmc.RemoveAll();while(m_pRecordset->adoEOF==0){a_DWbh.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DWbh"));a_DWmc.Add((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DWmc"));m_pRecordset->MoveNext();}m_AdoConn.ExitConnect();}int CDwxxb::HaveId(int iDWbh){ADOConn m_AdoConn; m_AdoConn.OnInitADOConn();CString strDWbh;strDWbh.Format("%d",iDWbh);_bstr_t vSQL;vSQL="SELECT*FROM Dwxxb WHERE DWbh="+strDWbh;_RecordsetPtr m_pRecordset;m_pRecordset=m_AdoConn.GetRecordSet(vSQL);if(m_pRecordset->adoEOF)return -1;else return 1;m_AdoConn.ExitConnect();}

//KLxgdlg.h//口令修改模块头文件#if !defined(AFX_KLXGDLG_H__0A4E7A0B_0DCA_4C10_8EB9_E738CC49135C__INCLUDED_)#define AFX_KLXGDLG_H__0A4E7A0B_0DCA_4C10_8EB9_E738CC49135C__INCLUDED_
#include "Users.h"#
include "Rizhib.h"
#if _MSC_VER > 1000#
pragma once#endif // _MSC_VER > 1000// KLxgdlg.h : header file//extern CUsers user;/////////////////////////////////////////////////////////////////////////////// CKLxgdlg dialogclass CKLxgdlg : public CDialog{// Constructionpublic:CKLxgdlg(CWnd* pParent = NULL); // standard constructorCRizhib zhi;CTime t;// Dialog Data//{{AFX_DATA(CKLxgdlg)enum { IDD = IDD_KLXG };CStaticm_name;CStringm_opwd;CStringm_npwd2;CStringm_npwd1;//}}AFX_DATA// Overrides// ClassWizard generated virtual function overrides//{{AFX_VIRTUAL(CKLxgdlg)public:virtual BOOL PreTranslateMessage(MSG* pMsg);protected:virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support//}}AFX_VIRTUAL// Implementationprotected:HICON m_hIcon;// Generated message map functions//{{AFX_MSG(CKLxgdlg)virtual void OnOK();virtual BOOL OnInitDialog();virtual void OnCancel();//}}AFX_MSGDECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_KLXGDLG_H__0A4E7A0B_0DCA_4C10_8EB9_E738CC49135C__INCLUDED_)

// KLxgdlg.cpp : implementation file//
#include "stdafx.h"#
include "WordGLXT.h"
#include "KLxgdlg.h"#
ifdef _DEBUG
#define new DEBUG_NEW#
undef THIS_FILEstatic char THIS_FILE[] = __FILE__;#endif/////////////////////////////////////////////////////////////////////////////// CKLxgdlg dialogCKLxgdlg::CKLxgdlg(CWnd* pParent /*=NULL*/): CDialog(CKLxgdlg::IDD, pParent){//{{AFX_DATA_INIT(CKLxgdlg)m_opwd = _T("");m_npwd2 = _T("");m_npwd1 = _T("");//}}AFX_DATA_INITm_hIcon = AfxGetApp()->LoadIcon(IDI_ICONMIMA);}void CKLxgdlg::DoDataExchange(CDataExchange* pDX){CDialog::DoDataExchange(pDX);//{{AFX_DATA_MAP(CKLxgdlg)DDX_Control(pDX, IDC_STATICyh, m_name);DDX_Text(pDX, IDC_EDIT2, m_opwd);DDX_Text(pDX, IDC_EDIT4, m_npwd2);DDX_Text(pDX, IDC_EDIT3, m_npwd1);//}}AFX_DATA_MAP}BEGIN_MESSAGE_MAP(CKLxgdlg, CDialog)//{{AFX_MSG_MAP(CKLxgdlg)//}}AFX_MSG_MAPEND_MESSAGE_MAP()/////////////////////////////////////////////////////////////////////////////// CKLxgdlg message handlersvoid CKLxgdlg::OnOK() {// TODO: Add extra validation hereUpdateData(true);CString name;m_name.GetWindowText(name);if(m_opwd==""){MessageBox("请输入旧密码!","企业办公文档管理系统");return;}if(m_npwd1==""){MessageBox("请输入新密码!","企业办公文档管理系统");return;}if(m_npwd2==""){MessageBox("请再次输入新密码确认!","企业办公文档管理系统");return;}if(m_npwd1!=m_npwd2){MessageBox("两次输入密码不同!","企业办公文档管理系统");return;}CUsers ser;if(ser.HaveCzy(name,m_opwd)!=1){MessageBox("用户或密码错误!","企业办公文档管理系统");return;}else{ ser.SetPwd(m_npwd1); ser.sql_updatepwd(name);MessageBox("密码修改成功，下次登录请用新密码!","企业办公文档管理系统");}zhi.SetDLsj(t.Format("%y-%m-%d"));zhi.SetName(user.GetUsername());zhi.SetDZ("修改密码");zhi.sql_insert();UpdateData(false);CDialog::OnOK();}BOOL CKLxgdlg::OnInitDialog() {CDialog::OnInitDialog();// TODO: Add extra initialization hereSetIcon(m_hIcon, TRUE);t=CTime::GetCurrentTime();m_name.SetWindowText(user.GetUsername());UpdateData(false);return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE}BOOL CKLxgdlg::PreTranslateMessage(MSG* pMsg) {// TODO: Add your specialized code here and/or call the base classif(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)pMsg->wParam=9;return CDialog::PreTranslateMessage(pMsg);}void CKLxgdlg::OnCancel() {// TODO: Add extra cleanup hereCDialog::OnCancel();}

/**************************************************** Rizhib.h: interface for the CRizhib class. ** 功能：日志表对应的类 ** 说明：类成员变量对应表列， ** 类成员函数对应成员变量和可对该表进行的操作 ****************************************************/#if !defined(AFX_RIZHIB_H__DE5B54B1_DC28_486E_9BB5_C32D67EDB8FB__INCLUDED_)#define AFX_RIZHIB_H__DE5B54B1_DC28_486E_9BB5_C32D67EDB8FB__INCLUDED_
#include "ADOConn.h"#
if _MSC_VER > 1000
#pragma once#
endif // _MSC_VER > 1000class CRizhib {private:CString Name;CString DLsj;CString DZ;public:CRizhib();virtual ~CRizhib();CString GetName();void SetName(CString cName);CString GetDLsj();void SetDLsj(CString cDLsj);CString GetDZ();void SetDZ(CString cDZ);void sql_insert();};#endif // !defined(AFX_RIZHIB_H__DE5B54B1_DC28_486E_9BB5_C32D67EDB8FB__INCLUDED_)

// Rizhib.cpp: implementation of the CRizhib class.////////////////////////////////////////////////////////////////////////
#include "stdafx.h"#
include "WordGLXT.h"
#include "Rizhib.h"#
ifdef _DEBUG#undef THIS_FILEstatic char THIS_FILE[]=__FILE__;#define new DEBUG_NEW#endif//////////////////////////////////////////////////////////////////////// Construction/Destruction//////////////////////////////////////////////////////////////////////CRizhib::CRizhib(){}CRizhib::~CRizhib(){}CString CRizhib::GetName(){return Name;}void CRizhib::SetName(CString cName){Name=cName;}CString CRizhib::GetDLsj(){return DLsj;}void CRizhib::SetDLsj(CString cDLsj){DLsj=cDLsj;}CString CRizhib::GetDZ(){return DZ;}void CRizhib::SetDZ(CString cDZ){DZ=cDZ;}void CRizhib::sql_insert(){ADOConn m_AdoConn;_bstr_t vSQL;vSQL="insert into Rizhib(Name,DLsj,DZ)values('"+Name+"','"+DLsj+"','"+DZ+"')";m_AdoConn.ExecuteSQL(vSQL);m_AdoConn.ExitConnect();}

/*************************************************** * Users.h: interface for the CUsers class. ** 功能：用户表对应的类 ** 说明：类成员变量对应表列， ** 类成员函数对应成员变量和可对该表进行的操作 ****************************************************/#if !defined(AFX_USERS_H__7AB8B197_FAD4_4C75_B32B_40F799B5A97F__INCLUDED_)#define AFX_USERS_H__7AB8B197_FAD4_4C75_B32B_40F799B5A97F__INCLUDED_
#include "ADOConn.h"#
if _MSC_VER > 1000
#pragma once#
endif // _MSC_VER > 1000class CUsers {private:CString Username;CString Pwd;CString JB;public:CUsers();virtual ~CUsers();CString GetUsername();void SetUsername(CString cUsername);CString GetPwd();void SetPwd(CString cPwd);CString GetJB();void SetJB(CString cJB);void sql_insert();void sql_update(CString cUsername);void sql_delete(CString cUsername);void sql_updatepwd(CString cUsername);int Havename(CString cUsername);int HaveCzy(CString cUsername,CString cPwd);int HaveCzyjb(CString cUsername,CString cPwd,CString cJB);};#endif // !defined(AFX_USERS_H__7AB8B197_FAD4_4C75_B32B_40F799B5A97F__INCLUDED_)

// Users.cpp: implementation of the CUsers class.////////////////////////////////////////////////////////////////////////
#include "stdafx.h"#
include "WordGLXT.h"
#include "Users.h"#
ifdef _DEBUG#undef THIS_FILEstatic char THIS_FILE[]=__FILE__;#define new DEBUG_NEW#endif//////////////////////////////////////////////////////////////////////// Construction/Destruction//////////////////////////////////////////////////////////////////////CUsers::CUsers(){}CUsers::~CUsers(){}CString CUsers::GetUsername(){return Username;}void CUsers::SetUsername(CString cUsername){Username=cUsername;}CString CUsers::GetPwd(){return Pwd;}void CUsers::SetPwd(CString cPwd){Pwd=cPwd;}CString CUsers::GetJB(){return JB;}void CUsers::SetJB(CString cJB){JB=cJB;}void CUsers::sql_insert(){ADOConn m_AdoConn;_bstr_t vSQL;vSQL="insert into Users(Username,Pwd,JB)values('"+Username+"','"+Pwd+"','"+JB+"')";m_AdoConn.ExecuteSQL(vSQL);m_AdoConn.ExitConnect();}void CUsers::sql_update(CString cUsername){ADOConn m_AdoConn;_bstr_t vSQL;vSQL="update Users set Pwd='"+Pwd+"',JB='"+JB+"' where Username="+" "+cUsername+"'";m_AdoConn.ExecuteSQL(vSQL);m_AdoConn.ExitConnect();}void CUsers::sql_delete(CString cUsername){ADOConn m_AdoConn; m_AdoConn.OnInitADOConn();CString sql;sql.Format("delete from Users where Username='%s'",cUsername);m_AdoConn.ExecuteSQL((_bstr_t)sql);m_AdoConn.ExitConnect();}int CUsers::Havename(CString cUsername){ADOConn m_AdoConn; m_AdoConn.OnInitADOConn();CString sql;sql.Format("SELECT*FROM Users WHERE Username='%s'",cUsername);_RecordsetPtr m_pRecordset;m_pRecordset=m_AdoConn.GetRecordSet((_bstr_t)sql);if(m_pRecordset->adoEOF)return -1;else return 1;m_AdoConn.ExitConnect();}int CUsers::HaveCzy(CString cUsername,CString cPwd){ADOConn m_AdoConn; m_AdoConn.OnInitADOConn();CString sql;sql.Format("SELECT*FROM Users WHERE Username='%s' AND Pwd='%s'",cUsername,cPwd);_RecordsetPtr m_pRecordset;m_pRecordset=m_AdoConn.GetRecordSet((_bstr_t)sql);if(m_pRecordset->adoEOF)return -1;else return 1;m_AdoConn.ExitConnect();}int CUsers::HaveCzyjb(CString cUsername,CString cPwd,CString cJB){ADOConn m_AdoConn; m_AdoConn.OnInitADOConn();CString sql;sql.Format("SELECT*FROM Users WHERE Username='%s' AND Pwd='%s' AND JB='%s'",cUsername,cPwd,cJB);_RecordsetPtr m_pRecordset;m_pRecordset=m_AdoConn.GetRecordSet((_bstr_t)sql);if(m_pRecordset->adoEOF)return -1;else return 1;m_AdoConn.ExitConnect();}void CUsers::sql_updatepwd(CString cUsername){ADOConn m_AdoConn;_bstr_t vSQL;vSQL="UPDATE Users SET Pwd='"+Pwd+"' WHERE Username="+" '"+cUsername+"'";m_AdoConn.ExecuteSQL(vSQL);m_AdoConn.ExitConnect();

//WDgldlg.h//文档管理模块头文件#if !defined(AFX_WDGLDLG_H__9C951B13_F35A_44B5_B6C8_79A7F917AA13__INCLUDED_)#define AFX_WDGLDLG_H__9C951B13_F35A_44B5_B6C8_79A7F917AA13__INCLUDED_
#include "Dwxxb.h"#
include "Zdmlb.h"
#include "Zdxxb.h"#
include "Users.h"
#include "Rizhib.h"#
include "ADOConn.h"
#if _MSC_VER > 1000#
pragma once#endif // _MSC_VER > 1000// WDgldlg.h : header file//extern CUsers user;/////////////////////////////////////////////////////////////////////////////// CWDgldlg dialogclass CWDgldlg : public CDialog{// Constructionpublic:void SetCurTab(UINT m_index=0);int wdbh;int lbbh;int dwbh;int str;//单选按钮CString strText;CDwxxb dwb;CZdmlb mlb;CZdxxb xxb;CRizhib zhi;CTime t;UINT tabindex;CWDgldlg(CWnd* pParent = NULL);// standard constructor// Dialog Data//{{AFX_DATA(CWDgldlg)enum { IDD = IDD_WDgldlg };CListCtrlm_list;CComboBoxm_combo;CEditm_wjlj;CTabCtrlm_tab;CStringm_dwmc;CStringm_wdlb;CStringm_wdmc;CStringm_gjz;CStringm_memo;intm_wdbh;//}}AFX_DATA// Overrides// ClassWizard generated virtual function overrides//{{AFX_VIRTUAL(CWDgldlg)public:virtual BOOL PreTranslateMessage(MSG* pMsg);protected:virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support//}}AFX_VIRTUAL// Implementationprotected:HICON m_hIcon;// Generated message map functions//{{AFX_MSG(CWDgldlg)virtual BOOL OnInitDialog();afx_msg void OnWjljxz();afx_msg void OnSelchangeTab1(NMHDR* pNMHDR, LRESULT* pResult);afx_msg void OnSelchangingTab1(NMHDR* pNMHDR, LRESULT* pResult);virtual void OnOK();afx_msg void OnRadio1();afx_msg void OnRadio2();afx_msg void OnButtondel();afx_msg void OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult);//}}AFX_MSGDECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_WDGLDLG_H__9C951B13_F35A_44B5_B6C8_79A7F917AA13__INCLUDED_)

//Wdlbiedlg.h//文档类别模块头文件#if !defined(AFX_WDLBIEDLG_H__C175C508_0123_4730_BBAF_82B3479AC9A2__INCLUDED_)#define AFX_WDLBIEDLG_H__C175C508_0123_4730_BBAF_82B3479AC9A2__INCLUDED_
#include "Zdmlb.h"#
include "Zdxxb.h"
#include "Rizhib.h"#
include "Users.h"
#include "Dwxxb.h"#
if _MSC_VER > 1000
#pragma once#
endif // _MSC_VER > 1000// Wdlbiedlg.h : header file//extern CUsers user;/////////////////////////////////////////////////////////////////////////////// CWdlbiedlg dialogclass CWdlbiedlg : public CDialog{// Constructionpublic:CWdlbiedlg(CWnd* pParent = NULL); // standard constructorCTime t;CRizhib zhi;// Dialog Data//{{AFX_DATA(CWdlbiedlg)enum { IDD = IDD_WDLB };intm_dwbh;intm_lbbh;CStringm_lbmc;//}}AFX_DATA// Overrides// ClassWizard generated virtual function overrides//{{AFX_VIRTUAL(CWdlbiedlg)public:virtual BOOL PreTranslateMessage(MSG* pMsg);protected:virtual void DoDataExchange(CDataExchange* pDX); // DDX/DDV support//}}AFX_VIRTUAL// Implementationprotected:HICON m_hIcon;// Generated message map functions//{{AFX_MSG(CWdlbiedlg)virtual void OnOK();afx_msg void OnModbutton();afx_msg void OnDelbutton();virtual BOOL OnInitDialog();//}}AFX_MSGDECLARE_MESSAGE_MAP()};//{{AFX_INSERT_LOCATION}}// Microsoft Visual C++ will insert additional declarations immediately before the previous line.#endif // !defined(AFX_WDLBIEDLG_H__C175C508_0123_4730_BBAF_82B3479AC9A2__INCLUDED_)