📄 khxxdlg.cpp

📁 旅行社的业务帮助系统
💻 CPP
字号:
// KHXXDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LXS.h"
#include "KHXXDlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CKHXXDlg dialog


CKHXXDlg::CKHXXDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CKHXXDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CKHXXDlg)
	m_strkhlx = _T("");
	m_strxb = _T("");
	m_strkhly = _T("");
	m_strkhbh = _T("");
	m_strkhzz = _T("");
	m_strkhxm = _T("");
	m_strkhlxfs = _T("");
	m_strzjlx = _T("");
	m_strzjh = _T("");
	m_strcsrq = _T("");
	m_strgzdw = _T("");
	//}}AFX_DATA_INIT
}


 void CKHXXDlg::DoDataExchange(CDataExchange* pDX)
 {
 	CDialog::DoDataExchange(pDX);
 	//{{AFX_DATA_MAP(CKHXXDlg)
	DDX_Control(pDX, IDC_LIST1, m_khxxlist);
	DDX_CBString(pDX, IDC_COMBO1, m_strkhlx);
	DDX_CBString(pDX, IDC_COMBO6, m_strxb);
	DDX_CBString(pDX, IDC_COMBO7, m_strkhly);
	DDX_Text(pDX, IDC_EDIT1, m_strkhbh);
	DDX_Text(pDX, IDC_EDIT11, m_strkhzz);
	DDX_Text(pDX, IDC_EDIT2, m_strkhxm);
	DDX_Text(pDX, IDC_EDIT3, m_strkhlxfs);
	DDX_Text(pDX, IDC_EDIT5, m_strzjlx);
	DDX_Text(pDX, IDC_EDIT6, m_strzjh);
	DDX_Text(pDX, IDC_EDIT8, m_strcsrq);
	DDX_Text(pDX, IDC_EDIT9, m_strgzdw);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CKHXXDlg, CDialog)
	//{{AFX_MSG_MAP(CKHXXDlg)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	ON_BN_CLICKED(IDC_BUTTON1, OnAdd)
	ON_BN_CLICKED(IDC_BUTTON2, OnUpdate)
	ON_BN_CLICKED(IDC_BUTTON3, OnDelete)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CKHXXDlg message handlers

/*BOOL CKHXXDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
/*m_listview.InsertColumn(0,"客户编号",LVCFMT_CENTER,80);
m_listview.InsertColumn(1,"客户姓名",LVCFMT_CENTER,80);
m_listview.InsertColumn(2,"联系方式",LVCFMT_CENTER,80);
m_listview.InsertColumn(3,"性别",LVCFMT_CENTER,80);
m_listview.InsertColumn(4,"证件类型",LVCFMT_CENTER,80);
m_listview.InsertColumn(5,"证件号",LVCFMT_CENTER,80);
m_listview.InsertColumn(6,"客户类型",LVCFMT_CENTER,80);
m_listview.InsertColumn(7,"出生日期",LVCFMT_CENTER,80);
m_listview.InsertColumn(8,"工作单位",LVCFMT_CENTER,100);
m_listview.InsertColumn(9,"客户来源",LVCFMT_CENTER,80);
m_listview.InsertColumn(10,"住址",LVCFMT_CENTER,100);

SetWindowLong(m_listview.m_hWnd,GWL_STYLE,WS_CHILD|WS_VISIBLE|WS_BORDER|LVS_REPORT);
m_listview.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
*/
/*
m_db.Open(_T("lxsMFC"));
m_rs.m_pDatabase=&m_db;

if(!m_rs.IsOpen())
m_rs.Open();
m_rs.MoveFirst();

int i=0;
while (!m_rs.IsEOF())
{m_listview.InsertItem(i,m_rs.m_khbh);
m_listview.SetItemText(i,1,m_rs.m_khxm);
m_listview.SetItemText(i,2,m_rs.m_khlxfs);
m_listview.SetItemText(i,3,m_rs.m_xb);
m_listview.SetItemText(i,4,m_rs.m_zjlx);
m_listview.SetItemText(i,5,m_rs.m_zjh);
m_listview.SetItemText(i,6,m_rs.m_khlx);
m_listview.SetItemText(i,7,m_rs.m_csrq);
m_listview.SetItemText(i,8,m_rs.m_gzdw);
m_listview.SetItemText(i,9,m_rs.m_khly);
m_listview.SetItemText(i,10,m_rs.m_khzz);

m_rs.MoveNext();

}	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE

}
*/

/*void CKHXXDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	index=m_khxxlist.GetNextItem(-1,LVNI_SELECTED);
	if (index!=-1)
	{
	m_strkhbh=m_khxxlist.GetItemText(index,0);
	m_strkhxm=m_khxxlist.GetItemText(index,1);
	m_strkhlxfs=m_khxxlist.GetItemText(index,2);
	m_strxb=m_khxxlist.GetItemText(index,3);
	m_strzjlx=m_khxxlist.GetItemText(index,4);
	m_strzjh=m_khxxlist.GetItemText(index,5);
	m_strkhlx=m_khxxlist.GetItemText(index,6);
	m_strcsrq=m_khxxlist.GetItemText(index,7);
	m_strgzdw=m_khxxlist.GetItemText(index,8);
	m_strkhly=m_khxxlist.GetItemText(index,9);
	m_strkhzz=m_khxxlist.GetItemText(index,10);
	}
	UpdateData(FALSE);
	*pResult = 0;
}
*/
BOOL CKHXXDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_khxxlist.InsertColumn(0,"客户编号",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(1,"客户姓名",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(2,"联系方式",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(3,"性别",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(4,"证件类型",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(5,"证件号",LVCFMT_LEFT,200);
	m_khxxlist.InsertColumn(6,"客户类型",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(7,"出生日期",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(8,"工作单位",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(9,"客户来源",LVCFMT_LEFT,100);
	m_khxxlist.InsertColumn(10,"住址",LVCFMT_LEFT,100);

	m_khxxlist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	ListAll();
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CKHXXDlg::ListAll()
{
	m_khxxlist.DeleteAllItems();
	if(!m_khxx.IsOpen())
		m_khxx.Open();
	CString strtemp;
	int i=0;
	m_khxx.MoveFirst();

	while(!m_khxx.IsEOF())
	{	
		
		m_khxxlist.InsertItem(i,strtemp);
        m_khxxlist.SetItemText(i,0,m_khxx.m_khbh);
		m_khxxlist.SetItemText(i,1,m_khxx.m_khxm);
		m_khxxlist.SetItemText(i,2,m_khxx.m_khlxfs);
		m_khxxlist.SetItemText(i,3,m_khxx.m_xb);
		m_khxxlist.SetItemText(i,4,m_khxx.m_zjlx);
		m_khxxlist.SetItemText(i,5,m_khxx.m_zjh);
		m_khxxlist.SetItemText(i,6,m_khxx.m_khlx);
		m_khxxlist.SetItemText(i,7,m_khxx.m_csrq);
		m_khxxlist.SetItemText(i,8,m_khxx.m_gzdw);
		m_khxxlist.SetItemText(i,9,m_khxx.m_khly);
		m_khxxlist.SetItemText(i,10,m_khxx.m_khzz);

		m_khxx.MoveNext();
		i++;
	}
}


void CKHXXDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	index=m_khxxlist.GetNextItem(-1,LVNI_SELECTED);
	if (index!=-1)
	{
	m_strkhbh=m_khxxlist.GetItemText(index,0);
	m_strkhxm=m_khxxlist.GetItemText(index,1);
	m_strkhlxfs=m_khxxlist.GetItemText(index,2);
	m_strxb=m_khxxlist.GetItemText(index,3);
	m_strzjlx=m_khxxlist.GetItemText(index,4);
	m_strzjh=m_khxxlist.GetItemText(index,5);
	m_strkhlx=m_khxxlist.GetItemText(index,6);
	m_strcsrq=m_khxxlist.GetItemText(index,7);
	m_strgzdw=m_khxxlist.GetItemText(index,8);
	m_strkhly=m_khxxlist.GetItemText(index,9);
	m_strkhzz=m_khxxlist.GetItemText(index,10);
	}
	UpdateData(FALSE);
	*pResult = 0;
}

void CKHXXDlg::OnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(!m_khxx.IsOpen())	
	m_khxx.Open();
	try
	{
	m_khxx.AddNew();
	m_khxx.m_khbh=m_strkhbh;
	m_khxx.m_khxm=m_strkhxm;
	m_khxx.m_khlxfs=m_strkhlxfs;
	m_khxx.m_xb=m_strxb;
	m_khxx.m_zjlx=m_strzjlx;
	m_khxx.m_zjh=m_strzjh;
	m_khxx.m_khlx=m_strkhlx;
	m_khxx.m_csrq=m_strcsrq;
	m_khxx.m_gzdw=m_strgzdw;
	m_khxx.m_khly=m_strkhly;
	m_khxx.m_khzz=m_strkhzz;

	if(m_khxx.CanUpdate())
		m_khxx.Update();
	}
	catch(CDBException* e)
	{e->ReportError();
	e->Delete();
	}
	m_khxx.Close();

	ListAll();	
}

void CKHXXDlg::OnUpdate() 
{
	// TODO: Add your control notification handler code here
	POSITION pos=m_khxxlist.GetFirstSelectedItemPosition();
	//记录当前行的主项目的信息
	int m_CurUser=m_khxxlist.GetNextSelectedItem(pos);
	UpdateData(TRUE);
	//定义表中的记录
	if(m_khxx.IsOpen())
	m_khxx.Close();
	m_khxx.m_strFilter.Format("khbh= '%s' ",m_strkhbh);
	m_khxx.Open();

	if(m_khxx.IsEOF())
	{
		m_khxx.Close();
		AfxMessageBox("没有该记录，不能修改！");
		return;
	}
	try
	{
			m_khxx.Edit();
	//把对话框上的值赋给数据库
	m_khxx.m_khbh=m_strkhbh;
	m_khxx.m_khxm=m_strkhxm;
	m_khxx.m_khlxfs=m_strkhlxfs;
	m_khxx.m_xb=m_strxb;
	m_khxx.m_zjlx=m_strzjlx;
	m_khxx.m_zjh=m_strzjh;
	m_khxx.m_khlx=m_strkhlx;
	m_khxx.m_csrq=m_strcsrq;
	m_khxx.m_gzdw=m_strgzdw;
	m_khxx.m_khly=m_strkhly;
	m_khxx.m_khzz=m_strkhzz;
	if(m_khxx.CanUpdate())
	m_khxx.Update();
      AfxMessageBox("修改成功！");
	}
	catch(CDBException* e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
	}
	//将用户信息及时更新到ListCtrl中
		m_khxxlist.SetItemText(m_CurUser,0,m_strkhbh);
		m_khxxlist.SetItemText(m_CurUser,1,m_strkhxm);
		m_khxxlist.SetItemText(m_CurUser,2,m_strkhlxfs);
		m_khxxlist.SetItemText(m_CurUser,3,m_strxb);
		m_khxxlist.SetItemText(m_CurUser,4,m_strzjlx);
		m_khxxlist.SetItemText(m_CurUser,5,m_strzjh);
		m_khxxlist.SetItemText(m_CurUser,6,m_strkhlx);
		m_khxxlist.SetItemText(m_CurUser,7,m_strcsrq);
		m_khxxlist.SetItemText(m_CurUser,8,m_strgzdw);
		m_khxxlist.SetItemText(m_CurUser,9,m_strkhly);
		m_khxxlist.SetItemText(m_CurUser,10,m_strkhzz);	
}

void CKHXXDlg::OnDelete() 
{
	// TODO: Add your control notification handler code here
	if(m_khxx.IsOpen())
	m_khxx.Close();
	m_khxx.m_strFilter.Format("khbh='%s' ",m_strkhbh);
	m_khxx.Open();
	if(m_khxx.IsEOF())
	{
		AfxMessageBox("没有该记录!");
		return;
	}
	int index=m_khxxlist.GetNextItem(-1,LVNI_SELECTED);
	m_khxxlist.DeleteItem(index);
	try
	{
		m_khxx.Delete();

	}
	catch(CDBException * e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
		return;
	}
	try
	{
		m_khxx.Requery();
	}
	catch(CDBException * e)
	{
	   AfxMessageBox("Can not Requery!",MB_ICONEXCLAMATION);
	   e->Delete();
	}	 
	m_khxx.Close();

	 index=m_khxxlist.GetNextItem(-1,LVNI_SELECTED);
		m_khxxlist.DeleteItem(index);
}
💿 文件大小 7267 K
👤 上传用户 archimedes88
📂 所属分类 SQL Server
🏷️ 相关标签

#旅行
⌨️ 快捷键说明

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