📄 department.cpp

📁 基于VC+SQL SERVER环境开发的企业商品销售系统.完整的数据库和原代码
💻 CPP
📖 第 1 页 / 共 2 页
字号:
上一页 12
	else if(departmentID<1000&&departmentID>99)
		m_departmentID.Format("department00%d",departmentID);
	CString str;
	str.Format("%d",departmentID+1);
	((CSaleApp*)AfxGetApp())->m_pIDRecordset->PutCollect("departmentID",_variant_t(str));
	((CSaleApp*)AfxGetApp())->m_pIDRecordset->Update();
	bt_addChildLevel->EnableWindow(false);
	bt_addSameLevel->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_save->EnableWindow(true);

	tx_departmentID->EnableWindow(false);
	tx_departmentName->EnableWindow(true);
	tx_departmentManager->EnableWindow(true);
	tx_departmentPhone->EnableWindow(true);
	tx_departmentFunction->EnableWindow(true);
	UpdateData(false);
}

void Department::OnModify() 
{
	UpdateData(true);
	flag=2;
	bt_modify->EnableWindow(false);
	bt_addChildLevel->EnableWindow(false);
	bt_addSameLevel->EnableWindow(false);
	bt_save->EnableWindow(true);

	tx_departmentID->EnableWindow(false);
	tx_departmentName->EnableWindow(false);
	tx_departmentManager->EnableWindow(true);
	tx_departmentPhone->EnableWindow(true);
	tx_departmentFunction->EnableWindow(true);
	
	UpdateData(false);
}

void Department::OnDelete() 
{
	CAffirm dlg;
	if(dlg.DoModal()!=IDOK)
	{
		return;
	}
	_RecordsetPtr m_pTreeRecordset;    //用于创建一个查询记录集
	
	CString strSQL,strCurItem;
	TreeCurrent=m_departmentTree.GetItemText(hTreeCurrent);
	
	strSQL="SELECT * FROM department where departmentName='" ;		
	strSQL=strSQL+TreeCurrent+"'";

	try
	{
		HRESULT hTRes;
		hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
		if (SUCCEEDED(hTRes))
		{
			hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
				((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
			if(SUCCEEDED(hTRes))
			{
				TRACE(_T("连接成功!\n"));
				m_pTreeRecordset->MoveFirst();
				m_pTreeRecordset->Delete(adAffectCurrent);
				m_departmentTree.DeleteItem(hTreeCurrent);
				m_pTreeRecordset->Update();
			}
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
		MessageBox("创建department记录集失败!","错误");
	}
	bt_delete->EnableWindow(false);
	bt_addSameLevel->EnableWindow(false);
	bt_addChildLevel->EnableWindow(false);
	bt_modify->EnableWindow(false);
	bt_save->EnableWindow(false);

	tx_departmentID->EnableWindow(false);
	tx_departmentName->EnableWindow(false);
	tx_departmentManager->EnableWindow(false);
	tx_departmentPhone->EnableWindow(false);
	tx_departmentFunction->EnableWindow(false);
	
	UpdateData(false);
	
}

void Department::OnSave() 
{	
	UpdateData(true);
	if(flag==2)
	{
		_RecordsetPtr m_pRecordset;
		CString strSQL;
		strSQL="SELECT * FROM department where departmentID='" ;
		strSQL=strSQL+m_departmentID+"'";
			
		try
		{
			HRESULT hTRes;
			hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))
			{				
				hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
				((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
						adOpenDynamic,adLockPessimistic,adCmdText);
				if(SUCCEEDED(hTRes))
				{
					TRACE(_T("连接成功!\n"));
					
					m_pRecordset->PutCollect("departmentName",_variant_t(m_departmentName.Left(25)));
					m_pRecordset->PutCollect("departmentManager",_variant_t(m_departmentManager));
					m_pRecordset->PutCollect("departmentFunction",_variant_t(m_departmentFunction));
					m_pRecordset->PutCollect("departmentPhone",_variant_t(m_departmentPhone));
					m_pRecordset->Update();
						
					AfxMessageBox("修改成功！");
				}
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString errormessage;
			MessageBox("创建记录集失败!","错误");
		}
	}
	else if(flag==11)
	{		
		_RecordsetPtr m_pTreeRecordset;    //用于创建一个查询记录集
		CString strSQL,strCurItem;
		
		TreeCurrent=m_departmentTree.GetItemText(hTreeCurrent);
		TreeParent=m_departmentTree.GetItemText(hTreeParent);

		strSQL="SELECT * FROM department " ;
		try
		{
			HRESULT hTRes;
			hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))
			{
				hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
					((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
					adOpenDynamic,adLockPessimistic,adCmdText);
				if(SUCCEEDED(hTRes))
				{
					TRACE(_T("连接成功!\n"));
					m_pTreeRecordset->AddNew();
					m_pTreeRecordset->PutCollect("departmentID",_variant_t(m_departmentID.Left(25)));
					m_pTreeRecordset->PutCollect("departmentName",_variant_t(m_departmentName.Left(50)));
					m_pTreeRecordset->PutCollect("departmentManager",_variant_t(m_departmentManager.Left(50)));
					m_pTreeRecordset->PutCollect("departmentPhone",_variant_t(m_departmentPhone.Left(20)));					
					m_pTreeRecordset->PutCollect("parentDepartmentID",_variant_t(TreeParentID.Left(20)));
					m_pTreeRecordset->PutCollect("departmentFunction",_variant_t(m_departmentFunction.Left(100)));
					m_pTreeRecordset->Update();
					m_departmentTree.InsertItem(m_departmentName,hTreeParent,NULL);
				}
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString errormessage;
			MessageBox("创建department记录集失败11!","错误");
		}
	}
	else if(flag==12)
	{		
		_RecordsetPtr m_pTreeRecordset;    //用于创建一个查询记录集	
		CString strSQL,strCurItem;
		TreeCurrent=m_departmentTree.GetItemText(hTreeCurrent);
		TreeParent=m_departmentTree.GetItemText(hTreeParent);

		strSQL="SELECT * FROM department " ;
		try
		{
			HRESULT hTRes;
			hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))
			{
				hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
					((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
					adOpenDynamic,adLockPessimistic,adCmdText);
				if(SUCCEEDED(hTRes))
				{
					TRACE(_T("连接成功!\n"));
					m_pTreeRecordset->AddNew();
					m_pTreeRecordset->PutCollect("departmentID",_variant_t(m_departmentID.Left(25)));
					m_pTreeRecordset->PutCollect("departmentName",_variant_t(m_departmentName.Left(50)));
					m_pTreeRecordset->PutCollect("departmentManager",_variant_t(m_departmentManager.Left(50)));
					m_pTreeRecordset->PutCollect("departmentPhone",_variant_t(m_departmentPhone.Left(20)));	
					m_pTreeRecordset->PutCollect("parentDepartmentID",_variant_t(TreeCurrentID.Left(25)));
					m_pTreeRecordset->PutCollect("departmentFunction",_variant_t(m_departmentFunction.Left(100)));
					m_pTreeRecordset->Update();
					m_departmentTree.InsertItem(m_departmentName,hTreeCurrent,NULL);
				}
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString errormessage;
			MessageBox("创建department记录集失败!","错误");
		}
	}
	AfxMessageBox("纪录已经存储！");
	bt_save->EnableWindow(false);
	bt_addChildLevel->EnableWindow(true);
	bt_addSameLevel->EnableWindow(true);
	bt_modify->EnableWindow(true);


	tx_departmentID->EnableWindow(false);
	tx_departmentName->EnableWindow(false);
	tx_departmentManager->EnableWindow(false);
	tx_departmentPhone->EnableWindow(false);
	tx_departmentFunction->EnableWindow(false);
	UpdateData(false);
}

void Department::OnExit() 
{
	this->OnCancel();	
}

void Department::OnSelchangedDepartmentTree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	NM_TREEVIEW* pNMTreeView = (NM_TREEVIEW*)pNMHDR;

	hTreeCurrent=m_departmentTree.GetSelectedItem ();
	hTreeParent=m_departmentTree.GetParentItem(m_departmentTree.GetSelectedItem ());

	m_departmentTree.SetItemImage(hTreeCurrent,1,true );

	TreeCurrent="'"+m_departmentTree.GetItemText(hTreeCurrent)+"'";
	TreeParent=m_departmentTree.GetItemText (hTreeParent);

	hTreeCurrent=m_departmentTree.GetSelectedItem ();
	_RecordsetPtr m_pTreeRecordset;    //用于创建一个查询记录集
	
	
	CString strSQL,strCurItem;
	TreeCurrent=m_departmentTree.GetItemText(hTreeCurrent);
		
	strSQL="SELECT * FROM department where departmentName='" ;		
	strSQL=strSQL+TreeCurrent+"'";

	try
	{
		HRESULT hTRes;
		hTRes = m_pTreeRecordset.CreateInstance(_T("ADODB.Recordset"));
		if (SUCCEEDED(hTRes))
		{			
			hTRes = m_pTreeRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
				((CSaleApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
				adOpenDynamic,adLockPessimistic,adCmdText);
			if(SUCCEEDED(hTRes))
			{
				TRACE(_T("连接成功!\n"));
					
				m_pTreeRecordset->MoveFirst();
				if (!(m_pTreeRecordset->adoEOF))
				{	
					m_departmentName=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("departmentName"));
					m_departmentID=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("departmentID"));
					m_departmentManager=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("departmentManager"));
					m_departmentPhone=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("departmentPhone"));
					m_departmentFunction=((CSaleApp*)AfxGetApp())->GetStringFromVariant(m_pTreeRecordset->GetCollect("departmentFunction"));
				}					
			}
		}
	}
	catch(_com_error e)///捕捉异常
	{
		CString errormessage;
	//	MessageBox("创建department记录集失败!","错误");
	}
	
	UpdateData(false);

	*pResult = 0;
}

void Department::OnClickDepartmentTree(NMHDR* pNMHDR, LRESULT* pResult) 
{
	m_departmentTree.SetItemImage(hTreeCurrent,0,true );

	bt_modify->EnableWindow(true);
	bt_addSameLevel->EnableWindow(true);
	bt_addChildLevel->EnableWindow(true);
	bt_delete->EnableWindow(true);
	
	*pResult = 0;
	UpdateData(false);
}
上一页 12
⌨️ 快捷键说明

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