bmdlg.cpp

旅行社的业务帮助系统

// BMDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LXS.h"
#include "BMDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBMDlg dialog


CBMDlg::CBMDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBMDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBMDlg)
	m_bmrq = _T("");
	m_cjtd = _T("");
	m_dd = _T("");
	m_gzdw = _T("");
	m_khlx = _T("");
	m_khly = _T("");
	m_khxm = _T("");
	m_lxfs = _T("");
	m_lyxl = _T("");
	//}}AFX_DATA_INIT
}


void CBMDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBMDlg)
	DDX_Control(pDX, IDC_bmList, m_bmlist);
	DDX_Text(pDX, IDC_bmrq, m_bmrq);
	DDX_Text(pDX, IDC_cjtd, m_cjtd);
	DDX_Text(pDX, IDC_dd, m_dd);
	DDX_Text(pDX, IDC_gzdw, m_gzdw);
	DDX_CBString(pDX, IDC_khlx, m_khlx);
	DDX_CBString(pDX, IDC_khly, m_khly);
	DDX_Text(pDX, IDC_khxm, m_khxm);
	DDX_Text(pDX, IDC_lxfs, m_lxfs);
	DDX_Text(pDX, IDC_lyxl, m_lyxl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBMDlg, CDialog)
	//{{AFX_MSG_MAP(CBMDlg)
	ON_NOTIFY(NM_CLICK, IDC_bmList, OnClickbmList)
	ON_BN_CLICKED(IDC_bmbc, Onbmbc)
	ON_BN_CLICKED(IDC_bmxg, Onbmxg)
	ON_BN_CLICKED(IDC_bmsc, Onbmsc)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBMDlg message handlers

BOOL CBMDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_bmlist.InsertColumn(0,"客户姓名",LVCFMT_LEFT,80);
	m_bmlist.InsertColumn(1,"联系方式",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(2,"性别",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(3,"游客类型",LVCFMT_LEFT,100);
    m_bmlist.InsertColumn(4,"工作单位",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(5,"游客来源",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(6,"住址",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(7,"参加团队",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(8,"旅游线路",LVCFMT_LEFT,100);
	m_bmlist.InsertColumn(9,"报名日期",LVCFMT_LEFT,100);
	m_bmlist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	ListAll();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBMDlg::ListAll()
{
m_bmlist.DeleteAllItems();
	if(!m_rs.IsOpen())
		m_rs.Open();
	int i=0;
	//m_rs.MoveFirst();

	while(!m_rs.IsEOF())
	{
		m_bmlist.InsertItem(i,m_rs.m_khxm);
        m_bmlist.SetItemText(i,1,m_rs.m_lxfs);
		m_bmlist.SetItemText(i,2,m_rs.m_xb);
		m_bmlist.SetItemText(i,3,m_rs.m_yklx);
		m_bmlist.SetItemText(i,4,m_rs.m_gzdw);
		m_bmlist.SetItemText(i,5,m_rs.m_ykly);
		m_bmlist.SetItemText(i,6,m_rs.m_dz);
		m_bmlist.SetItemText(i,7,m_rs.m_cjtd);
		m_bmlist.SetItemText(i,8,m_rs.m_lyxlmc);
		m_bmlist.SetItemText(i,9,m_rs.m_bmrq);
		m_rs.MoveNext();
		i++;
	}
}

void CBMDlg::OnClickbmList(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int index=m_bmlist.GetNextItem(-1,LVNI_SELECTED);
	if (index!=-1)
	{
		m_khxm=m_bmlist.GetItemText(index,0);
		m_lxfs=m_bmlist.GetItemText(index,1);
		m_khlx=m_bmlist.GetItemText(index,3);
		m_gzdw=m_bmlist.GetItemText(index,4);
	    m_khly=m_bmlist.GetItemText(index,5);
		m_dd=m_bmlist.GetItemText(index,6);
		m_cjtd=m_bmlist.GetItemText(index,7);
		m_lyxl=m_bmlist.GetItemText(index,8);
		m_bmrq=m_bmlist.GetItemText(index,9);
	}
	UpdateData(FALSE);
	*pResult = 0;
}

void CBMDlg::Onbmbc() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(!m_rs.IsOpen())	
	m_rs.Open();
	try
		{
			m_rs.AddNew();
			m_rs.m_khxm=m_khxm;
			m_rs.m_lxfs=m_lxfs;
			m_rs.m_ykly=m_khly;
			m_rs.m_gzdw=m_gzdw;
			m_rs.m_yklx=m_khlx;
			m_rs.m_dz=m_dd;
			m_rs.m_cjtd=m_cjtd;
			m_rs.m_lyxlmc=m_lyxl;
			m_rs.m_bmrq=m_bmrq;
			if(m_rs.CanUpdate())
				m_rs.Update();
		}
	catch(CDBException* e)
		{
			e->ReportError();
			e->Delete();
		}
	m_rs.Close();

	ListAll();	
}

void CBMDlg::Onbmxg() 
{
	// TODO: Add your control notification handler code here
	POSITION pos=m_bmlist.GetFirstSelectedItemPosition();
	int m_CurUser=m_bmlist.GetNextSelectedItem(pos);
	UpdateData(TRUE);
	if(m_rs.IsOpen())
		m_rs.Close();
	m_rs.Open();

	if(m_rs.IsEOF())
	{
		m_rs.Close();
		AfxMessageBox("没有该记录，不能修改！");
		return;
	}
	try
	{
			m_rs.Edit();
			m_rs.m_bmrq=m_bmrq;
			m_rs.m_cjtd=m_cjtd;
			m_rs.m_dz=m_dd;
			m_rs.m_gzdw=m_gzdw;
			m_rs.m_khxm=m_khxm;
			m_rs.m_lxfs=m_lxfs;
			m_rs.m_yklx=m_khlx;
			m_rs.m_ykly=m_khly;
			m_rs.m_lyxlmc=m_lyxl;
	if(m_rs.CanUpdate())
	m_rs.Update();
      AfxMessageBox("修改成功！");
	}
	catch(CDBException* e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
	}
		m_bmlist.SetItemText(m_CurUser,0,m_khxm);
		m_bmlist.SetItemText(m_CurUser,1,m_lxfs);
		m_bmlist.SetItemText(m_CurUser,3,m_khlx);
		m_bmlist.SetItemText(m_CurUser,4,m_gzdw);
		m_bmlist.SetItemText(m_CurUser,5,m_khly);
		m_bmlist.SetItemText(m_CurUser,6,m_dd);
		m_bmlist.SetItemText(m_CurUser,7,m_cjtd);
		m_bmlist.SetItemText(m_CurUser,8,m_lyxl);
		m_bmlist.SetItemText(m_CurUser,9,m_bmrq);
}

void CBMDlg::Onbmsc() 
{
	// TODO: Add your control notification handler code here
if(m_rs.IsOpen())
		m_rs.Close();
	m_rs.Open();
	if(m_rs.IsEOF())
	{
		AfxMessageBox("没有该记录!");
		return;
	}
	int index=m_bmlist.GetNextItem(-1,LVNI_SELECTED);
	m_bmlist.DeleteItem(index);
	try
	{
		m_rs.Delete();

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