wdgldlg.cpp

一个基于VC的文档管理系统。该程序可以方便地管理文件

		MessageBox("单位名称不能为空,请选择单位!","文档管理系统");
	    return;
	}
	else 
		m_combo3.GetLBText(m_combo3.GetCurSel(),strdwmc);
	
	
	if(m_combo4.GetCurSel()==CB_ERR)
	{
		MessageBox("文档类别不能为空,请选择文档类别!","文档管理系统");
		return;
	}
	else 
		m_combo4.GetLBText(m_combo4.GetCurSel(),strwdlb);

	if(m_wdmc=="")
	{
		MessageBox("文档名称不能为空","文档管理系统");
		return;
	}
	CString strwjlj;
	m_wjlj.GetWindowText(strwjlj);
	if(strwjlj=="")
	{
		MessageBox("文档路径不能为空","文档管理系统");
		return;
	}

	int dw=0,lb=0;
	for(int i=0;i<dwb.a_DWbh.GetSize();i++)//根据单位编号搜索单位名称
	{
		if(strdwmc==dwb.a_DWmc.GetAt(i))
		{
			dwbh=atoi(dwb.a_DWbh.GetAt(i));
			dw++; 
		}
	}
	if(dw==0)
	{
		MessageBox("单位名称不存在","文档管理系统");
		return;
	}
	for(i=0;i<mlb.a_DWbh.GetSize();i++)//根据单位编号搜索单位类别
	{
		if(dwbh==atoi(mlb.a_DWbh.GetAt(i)) && strwdlb==mlb.a_LBmc.GetAt(i))
		{
			lbbh=atoi(mlb.a_LBbh.GetAt(i));//类别编号
			lb++;
		}
	}
	if(lb==0)
	{
		MessageBox("文档类别不存在","文档管理系统");
		return;
	}

	xxb.SetDWbh(dwbh);
	xxb.SetLBbh(lbbh);
	xxb.SetWDbh(m_wdbh);
	xxb.SetWDmc(m_wdmc);
	xxb.SetGJz(m_gjz);
	    
	xxb.SetWJlj(strwjlj);
	xxb.SetMemo(m_memo);
	xxb.SetTjrxm(user.GetUsername());
	switch(str)
	{
		case 0: //添加
			if(xxb.HaveId(dwbh,lbbh,m_wdbh)==1)
			{
				MessageBox("文档已存在","文档管理系统");
				return;
			}
			xxb.sql_insert();
			zhi.SetDLsj(t.Format("%y-%m-%d"));
			zhi.SetName(user.GetUsername());
			zhi.SetDZ("添加文档");
			zhi.sql_insert();
           
			break;
		case 1:  //修改
			xxb.sql_update(m_wdbh);
			zhi.SetDLsj(t.Format("%y-%m-%d"));
			zhi.SetName(user.GetUsername());
			zhi.SetDZ("修改文档");
			zhi.sql_insert();
			break;
	}
	dw=0;
	lb=0;
	CDialog::OnOK();
}

void CWDgldlg::OnRadio1() //选择添加
{
	// TODO: Add your control notification handler code here
	str=0;
	
}
void CWDgldlg::OnRadio2() //选择修改
{
	// TODO: Add your control notification handler code here
	str=1;		
}

void CWDgldlg::SetCurTab(UINT m_index)
{
	m_tab.SetCurSel(m_index);
	if(m_index==0)
	{
		//标签1的控件隐藏
		GetDlgItem(IDC_LIST1)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_COMBO1)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_BUTTONDEL)->ShowWindow(SW_HIDE);
		//标签0的控件显示
		//GetDlgItem(IDC_EDIT1)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_COMBO3)->ShowWindow(SW_SHOW);
		//GetDlgItem(IDC_EDIT2)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_COMBO4)->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_EDIT7)->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(IDC_STATIC7)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_STATIC8)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_WJLJXZ)->ShowWindow(SW_SHOW);
		GetDlgItem(IDOK)->ShowWindow(SW_SHOW);
		GetDlgItem(IDCANCEL)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_RADIO1)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_RADIO2)->ShowWindow(SW_SHOW);
	}
	else
	{   //标签0的控件隐藏
		//GetDlgItem(IDC_EDIT1)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_COMBO3)->ShowWindow(SW_HIDE);
		//GetDlgItem(IDC_EDIT2)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_COMBO4)->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_EDIT7)->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(IDC_STATIC7)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_STATIC8)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_WJLJXZ)->ShowWindow(SW_HIDE);
		GetDlgItem(IDOK)->ShowWindow(SW_HIDE);
		GetDlgItem(IDCANCEL)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_RADIO1)->ShowWindow(SW_HIDE);
		GetDlgItem(IDC_RADIO2)->ShowWindow(SW_HIDE);
        //标签1的控件显示
		GetDlgItem(IDC_LIST1)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_COMBO1)->ShowWindow(SW_SHOW);
		GetDlgItem(IDC_BUTTONDEL)->ShowWindow(SW_SHOW);
	}
}
void CWDgldlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);
	int pos;
	pos=m_list.GetSelectionMark();
	m_combo1.SelectString(-1,m_list.GetItemText(pos,3));

	*pResult = 0;
}

void CWDgldlg::OnDblclkList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	UpdateData(true);

	int pos;
	pos=m_list.GetSelectionMark();
	SetCurTab(0); //切换到标签0下
	//将列表中内容添加到标签0的各个控件中
	CString strdwmc,strwdlb;

	strdwmc=m_list.GetItemText(pos,0);	
    m_combo3.SelectString(-1,strdwmc);

    OnSelchangeCombo3(); //先调用执行该函数,才能正确执行下面的语句

    strwdlb=m_list.GetItemText(pos,1);	
	m_combo4.SelectString(-1,strwdlb);

	m_wdbh=atoi(m_list.GetItemText(pos,2));
	m_wdmc=m_list.GetItemText(pos,3);
	m_gjz=m_list.GetItemText(pos,4);
	m_wjlj.SetWindowText(m_list.GetItemText(pos,5));
	m_memo=m_list.GetItemText(pos,6);


	*pResult = 0;
}


void CWDgldlg::OnSelchangeCombo3() //自己添加的函数
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CString strdwmc;
	m_combo3.GetLBText(m_combo3.GetCurSel(),strdwmc);//获得当前选中的单位名称
			
	dwb.Load_dep();
	mlb.Load_dep();
	xxb.Load_dep();
	m_combo4.ResetContent();//删除数据
	for(int i=0;i<dwb.a_DWbh.GetSize();i++) //根据单位编号在单位表中搜索单位名称
	{
		if(strdwmc == dwb.a_DWmc.GetAt(i))
		{
			for(int j=0;j<mlb.a_LBbh.GetSize();j++) //根据类别编号在类别表中搜索类别名称
				if(atoi(dwb.a_DWbh.GetAt(i))==atoi(mlb.a_DWbh.GetAt(j)))
					//自动往标签页1下的类别组合框添加文档类别 		   
					m_combo4.AddString(mlb.a_LBmc.GetAt(j));
		}
	}
}
void CWDgldlg::OnBUTTONDelWD() //删除文档的按钮响应函数
{
	// TODO: Add your control notification handler code here
		
	CString wdmc;

	if(m_combo1.GetCurSel()==CB_ERR) 
	{
		MessageBox("文档名称不能为空,请选择文档!","文档管理系统");
	    return;
	}
	else 
		m_combo1.GetLBText(m_combo1.GetCurSel(),wdmc);
	
	for(int i=0;i<xxb.a_WDbh.GetSize();i++)
	{
		if(wdmc==xxb.a_WDmc.GetAt(i))
		{
			wdbh=atoi(xxb.a_WDbh.GetAt(i));
		}
	}
	xxb.sql_delete(wdbh);
	zhi.SetDLsj(t.Format("%y-%m-%d"));
	zhi.SetName(user.GetUsername());
	zhi.SetDZ("文档删除");
	zhi.sql_insert();	
	CDialog::OnOK();

}


BOOL CWDgldlg::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);
}