?? crdbsdlg.cpp
字號:
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("沒有選擇要更改的地區(qū)信息");
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("沒有選擇要更改的結(jié)識信息");
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);
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -