?? detailquerydlg.cpp
字號:
// DetailQueryDlg.cpp : implementation file
//
#include "stdafx.h"
#include "CRDBS.h"
#include "DetailQueryDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDetailQueryDlg dialog
CDetailQueryDlg::CDetailQueryDlg(CWnd* pParent /*=NULL*/)
: CDialog(CDetailQueryDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CDetailQueryDlg)
// NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
}
void CDetailQueryDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDetailQueryDlg)
DDX_Control(pDX, IDC_COMBO_APPROACH, m_comboApproach);
DDX_Control(pDX, IDC_COMBO_AREA, m_comboArea);
DDX_Control(pDX, IDC_COMBO_PROFESSION, m_comboProfession);
DDX_Control(pDX, IDC_COMBO_VOCATION, m_comboVocation);
DDX_Control(pDX, IDC_LIST_HR, m_listHR);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDetailQueryDlg, CDialog)
//{{AFX_MSG_MAP(CDetailQueryDlg)
ON_CBN_CLOSEUP(IDC_COMBO_APPROACH, OnCloseupComboApproach)
ON_CBN_CLOSEUP(IDC_COMBO_AREA, OnCloseupComboArea)
ON_CBN_CLOSEUP(IDC_COMBO_PROFESSION, OnCloseupComboProfession)
ON_CBN_CLOSEUP(IDC_COMBO_VOCATION, OnCloseupComboVocation)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDetailQueryDlg message handlers
BOOL CDetailQueryDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |
LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
m_listHR.SetExtendedStyle(dwExStyle);
//初始客戶信息列表控件
//添加客戶ID列
LV_COLUMN lvColumn;
lvColumn.mask = LVCF_FMT | LVCF_WIDTH | LVCF_TEXT | LVCF_SUBITEM;
lvColumn.fmt = LVCFMT_CENTER;
lvColumn.cx = 60;
lvColumn.iSubItem = 0;
lvColumn.pszText = "客戶ID";
m_listHR.InsertColumn(0, &lvColumn);
//添加姓名名稱列
lvColumn.cx = 80;
lvColumn.iSubItem = 1;
lvColumn.pszText = "姓名";
m_listHR.InsertColumn(1, &lvColumn);
//添加所在地區列
lvColumn.cx = 80;
lvColumn.iSubItem = 2;
lvColumn.pszText = "所在地區";
m_listHR.InsertColumn(2, &lvColumn);
//添加職業列
lvColumn.cx = 80;
lvColumn.iSubItem = 3;
lvColumn.pszText = "職業";
m_listHR.InsertColumn(3, &lvColumn);
//添加行業列
lvColumn.cx = 80;
lvColumn.iSubItem = 4;
lvColumn.pszText = "行業";
m_listHR.InsertColumn(4, &lvColumn);
//添加所在單位列
lvColumn.cx = 80;
lvColumn.iSubItem = 5;
lvColumn.pszText = "所在單位";
m_listHR.InsertColumn(5, &lvColumn);
//添加結識途徑列
lvColumn.cx = 80;
lvColumn.iSubItem = 6;
lvColumn.pszText = "結識途徑";
m_listHR.InsertColumn(6, &lvColumn);
//添加e-mail列
lvColumn.cx = 80;
lvColumn.iSubItem = 7;
lvColumn.pszText = "e-mail";
m_listHR.InsertColumn(7, &lvColumn);
//添加固定電話列
lvColumn.cx = 80;
lvColumn.iSubItem = 8;
lvColumn.pszText = "固定電話";
m_listHR.InsertColumn(8, &lvColumn);
//添加移動電話列
lvColumn.cx = 80;
lvColumn.iSubItem = 9;
lvColumn.pszText = "移動電話";
m_listHR.InsertColumn(9, &lvColumn);
//添加愛好列
lvColumn.cx = 80;
lvColumn.iSubItem = 10;
lvColumn.pszText = "愛好";
m_listHR.InsertColumn(10, &lvColumn);
//添加說明列
lvColumn.cx = 140;
lvColumn.iSubItem = 11;
lvColumn.pszText = "說明";
m_listHR.InsertColumn(11, &lvColumn);
//加載四個組合框控件中的數據
InitComboData();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CDetailQueryDlg::InitComboData()
{
TRY{
CRecordset rs(m_pDB);
//打開所有的地區信息記錄.
rs.Open(CRecordset::dynaset, "select * from area_info_tab");
while (!rs.IsEOF()) {
CString strName;
//獲取地區信息名稱字段值
rs.GetFieldValue(1, strName);
//向地區信息名稱組合框添加地區信息名稱.
m_comboArea.AddString(strName);
rs.MoveNext();
}
rs.Close();
m_comboArea.SetCurSel(0);
rs.Open(CRecordset::dynaset, "select * from approach_info_tab");
while (!rs.IsEOF()) {
CString strName;
//獲取結識途徑信息名稱字段值
rs.GetFieldValue(1, strName);
//向結識途徑信息名稱組合框添加結識途徑信息名稱.
m_comboApproach.AddString(strName);
rs.MoveNext();
}
rs.Close();
m_comboApproach.SetCurSel(0);
rs.Open(CRecordset::dynaset, "select * from profession_info_tab");
while (!rs.IsEOF()) {
CString strName;
//獲取職位信息名稱字段值
rs.GetFieldValue(1, strName);
//向職位信息名稱組合框添加職位信息名稱.
m_comboProfession.AddString(strName);
rs.MoveNext();
}
rs.Close();
m_comboProfession.SetCurSel(0);
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);
rs.Close();
}
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 CDetailQueryDlg::OnCloseupComboApproach()
{
// TODO: Add your control notification handler code here
CString sql;
CString strSelected;
//獲取當前選擇項目
int nIndex = m_comboApproach.GetCurSel();
//如果沒有選擇,退出
if(nIndex == -1)
return;
//獲取當前選擇的結識途徑名稱
m_comboApproach.GetLBText(nIndex,strSelected);
//如果選項為空,退出
if(strSelected.IsEmpty())
return;
//構造打開所有結識途徑名稱為strSelected客戶信息的sql語句
sql.Format("select * from customer_info_tab where approach = '%s' order by id",
strSelected);
//根據sql語句打開滿足條件的客戶信息,顯示在列表中
RefreshCtrlData(sql);
}
void CDetailQueryDlg::OnCloseupComboArea()
{
// TODO: Add your control notification handler code here
CString sql;
CString strSelected;
//獲取當前選擇項目
int nIndex = m_comboArea.GetCurSel();
//如果沒有選擇,退出
if(nIndex == -1)
return;
//獲取當前選擇的地區信息名稱
m_comboArea.GetLBText(nIndex,strSelected);
//如果選項為空,退出
if(strSelected.IsEmpty())
return;
//構造打開所有地區信息名稱為strSelected客戶信息的SQL語句
sql.Format("select * from customer_info_tab where area = '%s' order by id",
strSelected);
//根據sql語句打開滿足條件的客戶信息,顯示在列表中
RefreshCtrlData(sql);
}
void CDetailQueryDlg::OnCloseupComboProfession()
{
// TODO: Add your control notification handler code here
CString sql;
CString strSelected;
//獲取當前選擇項目
int nIndex = m_comboProfession.GetCurSel();
//如果沒有選擇,退出
if(nIndex == -1)
return;
//獲取當前選擇的職位名稱
m_comboProfession.GetLBText(nIndex,strSelected);
//如果選項為空,退出
if(strSelected.IsEmpty())
return;
//構造打開所有職位名稱為strSelected客戶信息的SQL語句
sql.Format("select * from customer_info_tab where profession = '%s' order by id",
strSelected);
//根據sql語句打開滿足條件的客戶信息,顯示在列表中
RefreshCtrlData(sql);
}
void CDetailQueryDlg::OnCloseupComboVocation()
{
// TODO: Add your control notification handler code here
CString sql;
CString strSelected;
//獲取當前選擇項目
int nIndex = m_comboVocation.GetCurSel();
//如果沒有選擇,退出
if(nIndex == -1)
return;
//獲取當前選擇的行業名稱
m_comboVocation.GetLBText(nIndex,strSelected);
//如果選項為空,退出
if(strSelected.IsEmpty())
return;
//構造打開所有行業名稱為strSelected客戶信息的SQL語句
sql.Format("select * from customer_info_tab where vocation = '%s' order by id",
strSelected);
//根據sql語句打開滿足條件的客戶信息,顯示在列表中
RefreshCtrlData(sql);
}
void CDetailQueryDlg::RefreshCtrlData(CString sql)
{
// TODO: Add your control notification handler code here
if(!m_pDB->IsOpen()){
MessageBox("數據庫未打開");
return;
}
m_listHR.DeleteAllItems();
TRY{
CRecordset rs(m_pDB);
//打開所有的滿足條件的客戶信息記錄
rs.Open(CRecordset::dynaset, sql);
while (!rs.IsEOF()) {
int id;
CString name,area,profession,vocation,company;
CString approach,email,phone,mobile,interest,memo;
CDBVariant var;
//獲取客戶信息ID字段值
rs.GetFieldValue((short)0, var, SQL_C_SLONG);
if (var.m_dwType != DBVT_NULL)
id = var.m_iVal;
var.Clear();
//獲取姓名字段值
rs.GetFieldValue(1, name);
//獲取地區信息字段值
rs.GetFieldValue(2, area);
//獲取職業字段值
rs.GetFieldValue(3, profession);
//獲取行業字段值
rs.GetFieldValue(4, vocation);
//獲取所在單位字段值
rs.GetFieldValue(5, company);
//獲取結識途徑字段值
rs.GetFieldValue(6, approach);
//獲取email字段值
rs.GetFieldValue(7, email);
//獲取固定電話字段值
rs.GetFieldValue(8, phone);
//獲取移動電話字段值
rs.GetFieldValue(9, mobile);
//獲取愛好字段值
rs.GetFieldValue(10, interest);
//獲取備注字段值
rs.GetFieldValue(11, memo);
//向客戶信息列表控件中加入新的一行信息.
InsertHRInfoItem(id,name,area,profession,vocation,company,approach,
email,phone,mobile,interest,memo);
rs.MoveNext();
}
rs.Close();
}
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 CDetailQueryDlg::InsertHRInfoItem(int id,CString name,CString area,CString prof,CString voc,CString com,CString appr,CString email,CString phone,CString mobile,CString interest,CString memo)
{
//獲取當前的紀錄條數.
int nIndex = m_listHR.GetItemCount();
LV_ITEM lvItem;
lvItem.mask = LVIF_TEXT ;
lvItem.iItem = nIndex; //行數
lvItem.iSubItem = 0;
CString temp ;
temp.Format("%d",id);
lvItem.pszText = (char*)(LPCTSTR)temp; //第一列
//在最后一行插入記錄值.
m_listHR.InsertItem(&lvItem);
//設置該行的其他列的值.
m_listHR.SetItemText(nIndex,1,name);
m_listHR.SetItemText(nIndex,2,area);
m_listHR.SetItemText(nIndex,3,prof);
m_listHR.SetItemText(nIndex,4,voc);
m_listHR.SetItemText(nIndex,5,com);
m_listHR.SetItemText(nIndex,6,appr);
m_listHR.SetItemText(nIndex,7,email);
m_listHR.SetItemText(nIndex,8,phone);
m_listHR.SetItemText(nIndex,9,mobile);
m_listHR.SetItemText(nIndex,10,interest);
m_listHR.SetItemText(nIndex,11,memo);
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -