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

📄 crdbsdlg.cpp

📁 用ASP做的客户管理系统
💻 CPP
📖 第 1 页 / 共 3 页
字号:
🔍
123 
   END_CATCH
}

void CCRDBSDlg::RefreshAreaComboData()
{
  m_comboArea.ResetContent();
  TRY
  {
	  CRecordset rs(&m_db);
	  rs.Open(CRecordset::dynaset,"select * from area_info_tab");
	  while(!rs.IsEOF())
	  {
		  CString strName;
		  rs.GetFieldValue(1,strName);
		  m_comboArea.AddString(strName);
		  rs.MoveNext();
	  }
	  m_comboArea.SetCurSel(0);
  }
  CATCH(CDBException,ex)
  {
	  AfxMessageBox(ex->m_strError);
	  AfxMessageBox(ex->m_strStateNativeOrigin);
  }
  AND_CATCH(CMemoryException,pEx)
  {
	  pEx->ReportError();
      AfxMessageBox("memory exception");
  }
  AND_CATCH(CException,e)
  {
	  TCHAR szError[100];
	  e->GetErrorMessage(szError,100);
	  AfxMessageBox(szError);
  }
  END_CATCH
}

void CCRDBSDlg::RefreshApprComboData()
{
  m_comboApproach.ResetContent();
  TRY
  {
	  CRecordset rs(&m_db);
	  rs.Open(CRecordset::dynaset,"select * from approach_info_tab");
	  while(!rs.IsEOF())
	  {
		  CString strName;
		  rs.GetFieldValue(1,strName);
		  m_comboApproach.AddString(strName);
		  rs.MoveNext();
	  }
	  m_comboApproach.SetCurSel(0);
  }
  CATCH(CDBException,ex)
  {
	  AfxMessageBox(ex->m_strError);
	  AfxMessageBox(ex->m_strStateNativeOrigin);
  }
  AND_CATCH(CMemoryException,pEx)
  {
	  pEx->ReportError();
      AfxMessageBox("memory exception");
  }
  AND_CATCH(CException,e)
  {
	  TCHAR szError[100];
	  e->GetErrorMessage(szError,100);
	  AfxMessageBox(szError);
  }
  END_CATCH
}

void CCRDBSDlg::RefreshProfComboData()
{
  m_comboProfession.ResetContent();
  TRY
  {
	  CRecordset rs(&m_db);
	  rs.Open(CRecordset::dynaset,"select * from profession_info_tab");
	  while(!rs.IsEOF())
	  {
		  CString strName;
		  rs.GetFieldValue(1,strName);
		  m_comboProfession.AddString(strName);
		  rs.MoveNext();
	  }
	  m_comboProfession.SetCurSel(0);
  }
  CATCH(CDBException,ex)
  {
	  AfxMessageBox(ex->m_strError);
	  AfxMessageBox(ex->m_strStateNativeOrigin);
  }
  AND_CATCH(CMemoryException,pEx)
  {
	  pEx->ReportError();
      AfxMessageBox("memory exception");
  }
  AND_CATCH(CException,e)
  {
	  TCHAR szError[100];
	  e->GetErrorMessage(szError,100);
	  AfxMessageBox(szError);
  }
  END_CATCH
}

void CCRDBSDlg::RefreshVocComboData()
{
  m_comboVocation.ResetContent();
  TRY
  {
	  CRecordset rs(&m_db);
	  rs.Open(CRecordset::dynaset,"select * from vocation_info_tab");
	  while(!rs.IsEOF())
	  {
		  CString strName;
		  rs.GetFieldValue(1,strName);
		  m_comboVocation.AddString(strName);
		  rs.MoveNext();
	  }
	  m_comboVocation.SetCurSel(0);
  }
  CATCH(CDBException,ex)
  {
	  AfxMessageBox(ex->m_strError);
	  AfxMessageBox(ex->m_strStateNativeOrigin);
  }
  AND_CATCH(CMemoryException,pEx)
  {
	  pEx->ReportError();
      AfxMessageBox("memory exception");
  }
  AND_CATCH(CException,e)
  {
	  TCHAR szError[100];
	  e->GetErrorMessage(szError,100);
	  AfxMessageBox(szError);
  }
  END_CATCH
}

void CCRDBSDlg::OnBtnAreaAdd() 
{
   if(!UpdateData())
	   return;
   if(m_strConfigArea.IsEmpty())
	   return;
   TRY
   {
	   CRecordset rs(&m_db);
	   CString sql;
	   rs.Open(CRecordset::dynaset,"Select max(area_id) from area_info_tab");
	   int newID=1;
	   if(!rs.IsEOF())
	   {
		   CDBVariant var;
		   rs.GetFieldValue((short)0,var,SQL_C_SLONG);
		   if(var.m_dwType!=DBVT_NULL)
			   newID=var.m_iVal+1;
	   }

	   sql.Format("Insert into area_info_tab(area_id,""area_name)""VALUES(" "%d,'%s')",newID,m_strConfigArea);
	   TRACE(sql);
	   m_db.ExecuteSQL(sql);
	   InsertConfigItem(&m_listArea,newID,m_strConfigArea);
	   RefreshAreaComboData();
   }
   CATCH(CDBException,ex)
   {
	   AfxMessageBox(ex->m_strError);
	   AfxMessageBox(ex->m_strStateNativeOrigin);
   }
   AND_CATCH(CException,e)
   {
	   TCHAR szError[100];
	   e->GetErrorMessage(szError,100);
	   AfxMessageBox(szError);
   }
   END_CATCH
}

void CCRDBSDlg::OnBtnApproachAdd() 
{
  if(!UpdateData())
	   return;
   if(m_strConfigApproach.IsEmpty())
	   return;
   TRY
   {
	   CRecordset rs(&m_db);
	   CString sql;
	   rs.Open(CRecordset::dynaset,"Select max(approach_id) from approach_info_tab");
	   int newID=1;
	   if(!rs.IsEOF())
	   {
		   CDBVariant var;
		   rs.GetFieldValue((short)0,var,SQL_C_SLONG);
		   if(var.m_dwType!=DBVT_NULL)
			   newID=var.m_iVal+1;
	   }

	   sql.Format("Insert into approach_info_tab(approach_id,""approach_name)""VALUES(" "%d,'%s')",newID,m_strConfigApproach);
	   TRACE(sql);
	   m_db.ExecuteSQL(sql);
	   InsertConfigItem(&m_listApproach,newID,m_strConfigApproach);
	   RefreshApprComboData();
   }
   CATCH(CDBException,ex)
   {
	   AfxMessageBox(ex->m_strError);
	   AfxMessageBox(ex->m_strStateNativeOrigin);
   }
   AND_CATCH(CException,e)
   {
	   TCHAR szError[100];
	   e->GetErrorMessage(szError,100);
	   AfxMessageBox(szError);
   }
   END_CATCH	
}

void CCRDBSDlg::OnBtnProfessionAdd() 
{
if(!UpdateData())
	   return;
   if(m_strConfigProfession.IsEmpty())
	   return;
   TRY
   {
	   CRecordset rs(&m_db);
	   CString sql;
	   rs.Open(CRecordset::dynaset,"Select max(profession_id) from profession_info_tab");
	   int newID=1;
	   if(!rs.IsEOF())
	   {
		   CDBVariant var;
		   rs.GetFieldValue((short)0,var,SQL_C_SLONG);
		   if(var.m_dwType!=DBVT_NULL)
			   newID=var.m_iVal+1;
	   }

	   sql.Format("Insert into profession_info_tab(profession_id,""profession_name)""VALUES(" "%d,'%s')",newID,m_strConfigProfession);
	   TRACE(sql);
	   m_db.ExecuteSQL(sql);
	   InsertConfigItem(&m_listProfession,newID,m_strConfigProfession);
	   RefreshProfComboData();
   }
   CATCH(CDBException,ex)
   {
	   AfxMessageBox(ex->m_strError);
	   AfxMessageBox(ex->m_strStateNativeOrigin);
   }
   AND_CATCH(CException,e)
   {
	   TCHAR szError[100];
	   e->GetErrorMessage(szError,100);
	   AfxMessageBox(szError);
   }
   END_CATCH	
}

void CCRDBSDlg::OnBtnVocationAdd() 
{
if(!UpdateData())
	   return;
   if(m_strConfigVocation.IsEmpty())
	   return;
   TRY
   {
	   CRecordset rs(&m_db);
	   CString sql;
	   rs.Open(CRecordset::dynaset,"Select max(vocation_id) from vocation_info_tab");
	   int newID=1;
	   if(!rs.IsEOF())
	   {
		   CDBVariant var;
		   rs.GetFieldValue((short)0,var,SQL_C_SLONG);
		   if(var.m_dwType!=DBVT_NULL)
			   newID=var.m_iVal+1;
	   }

	   sql.Format("Insert into vocation_info_tab(vocation_id,""vocation_name)""VALUES(" "%d,'%s')",newID,m_strConfigVocation);
	   TRACE(sql);
	   m_db.ExecuteSQL(sql);
	   InsertConfigItem(&m_listVocation,newID,m_strConfigVocation);
	   RefreshVocComboData();
   }
   CATCH(CDBException,ex)
   {
	   AfxMessageBox(ex->m_strError);
	   AfxMessageBox(ex->m_strStateNativeOrigin);
   }
   AND_CATCH(CException,e)
   {
	   TCHAR szError[100];
	   e->GetErrorMessage(szError,100);
	   AfxMessageBox(szError);
   }
   END_CATCH	
}

void CCRDBSDlg::OnClickListArea(NMHDR* pNMHDR, LRESULT* pResult) 
{
    int nItem=m_listArea.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString name=m_listArea.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_CONFIG_AREA)->SetWindowText(name);
	}
	*pResult = 0;
}

void CCRDBSDlg::OnClickListApproach(NMHDR* pNMHDR, LRESULT* pResult) 
{
int nItem=m_listApproach.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString name=m_listApproach.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_CONFIG_APPROACH)->SetWindowText(name);
	}	
	*pResult = 0;
}

void CCRDBSDlg::OnClickListProfession(NMHDR* pNMHDR, LRESULT* pResult) 
{
int nItem=m_listProfession.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString name=m_listProfession.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_CONFIG_PROFESSION)->SetWindowText(name);
	}	
	*pResult = 0;
}

void CCRDBSDlg::OnClickListVocation(NMHDR* pNMHDR, LRESULT* pResult) 
{
int nItem=m_listVocation.GetNextItem(-1,LVNI_SELECTED);
	if(nItem!=-1)
	{
		CString name=m_listVocation.GetItemText(nItem,1);
		GetDlgItem(IDC_EDIT_CONFIG_VOCATION)->SetWindowText(name);
	}	
	*pResult = 0;
}

void CCRDBSDlg::OnBtnAreaMod() 
{
  if(!UpdateData())
	  return;
  if(m_strConfigArea.IsEmpty())
	  return;
  int nItem=m_listArea.GetNextItem(-1,LVNI_SELECTED);
  if(nItem==-1){
	  AfxMessageBox("没有选择要更改的地区信息");
  return;
  }
  int id = atoi(m_listArea.GetItemText(nItem,0));

  TRY
  {
     CRecordset rs(&m_db);
	 CString sql;
	 sql.Format("update area_info_tab "
		 "set area_name= '%s'  "
		 "where area_id= %d",m_strConfigArea,id);
	 TRACE(sql);
	 m_db.ExecuteSQL(sql);
	 m_listArea.SetItemText(nItem,1,m_strConfigArea);
	 RefreshAreaComboData();
  }
  CATCH(CDBException,ex)
   {
	   AfxMessageBox(ex->m_strError);
	   AfxMessageBox(ex->m_strStateNativeOrigin);
   }
   AND_CATCH(CException,e)
   {
	   TCHAR szError[100];
	   e->GetErrorMessage(szError,100);
	   AfxMessageBox(szError);
   }
   END_CATCH	
}

void CCRDBSDlg::OnBtnApproachMod() 
{
if(!UpdateData())
	  return;
  if(m_strConfigApproach.IsEmpty())
	  return;
  int nItem=m_listApproach.GetNextItem(-1,LVNI_SELECTED);
  if(nItem==-1){
	  AfxMessageBox("没有选择要更改的结识信息");
  return;
  }
  int id = atoi(m_listApproach.GetItemText(nItem,0));

  TRY
  {
     CRecordset rs(&m_db);
	 CString sql;
	 sql.Format("update approach_info_tab "
		 "set approach_name= '%s'  "
		 "where approach_id= %d",m_strConfigApproach,id);
	 TRACE(sql);
	 m_db.ExecuteSQL(sql);
	 m_listApproach.SetItemText(nItem,1,m_strConfigApproach);
	 RefreshApprComboData();
  }
  CATCH(CDBException,ex)
   {
	   AfxMessageBox(ex->m_strError);
	   AfxMessageBox(ex->m_strStateNativeOrigin);
   }
   AND_CATCH(CException,e)
   {
	   TCHAR szError[100];
	   e->GetErrorMessage(szError,100);
	   AfxMessageBox(szError);
   }
   END_CATCH		
}

void CCRDBSDlg::OnBtnProfessionMod() 
{
if(!UpdateData())
	  return;
  if(m_strConfigProfession.IsEmpty())
	  return;
  int nItem=m_listProfession.GetNextItem(-1,LVNI_SELECTED);
  if(nItem==-1){
	  AfxMessageBox("没有选择要更改的职位信息");
  return;
  }
  int id = atoi(m_listProfession.GetItemText(nItem,0));

  TRY
  {
     CRecordset rs(&m_db);
123

⌨️ 快捷键说明

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