⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 dwdandlg.cpp

📁 用于单位文档管理系统
💻 CPP
字号:
🔍 
// Dwdandlg.cpp : implementation file
//

#include "stdafx.h"
#include "WordGLXT.h"
#include "Dwdandlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDwdandlg dialog


CDwdandlg::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_INIT
	m_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_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDwdandlg message handlers

void CDwdandlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(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 here
	UpdateData(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 here
	UpdateData(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 here
	SetIcon(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 here
	switch(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 here
	switch(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 here
	UpdateData(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 class
	if(pMsg->message==WM_KEYDOWN && pMsg->wParam==13)
		pMsg->wParam=9;	
	return CDialog::PreTranslateMessage(pMsg);
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -