tdxxdlg.cpp

旅行社的业务帮助系统

// TDXXDlg.cpp : implementation file
//

#include "stdafx.h"
#include "LXS.h"
#include "TDXXDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CTDXXDlg dialog


CTDXXDlg::CTDXXDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTDXXDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTDXXDlg)
	m_strtddj = _T("");
	m_strtdzt = _T("");
	m_strtdbh = _T("");
	m_strctsj = _T("");
	m_strhtsj = _T("");
	m_strxlmc = _T("");
	m_strdyrs = _T("");
	m_strzdbms = _T("");
	//}}AFX_DATA_INIT
}


void CTDXXDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTDXXDlg)
	DDX_Control(pDX, IDC_LIST1, m_tdxxlist);
	DDX_CBString(pDX, IDC_COMBO1, m_strtddj);
	DDX_CBString(pDX, IDC_COMBO5, m_strtdzt);
	DDX_Text(pDX, IDC_EDIT1, m_strtdbh);
	DDX_Text(pDX, IDC_EDIT13, m_strctsj);
	DDX_Text(pDX, IDC_EDIT14, m_strhtsj);
	DDX_Text(pDX, IDC_EDIT2, m_strxlmc);
	DDX_Text(pDX, IDC_EDIT3, m_strdyrs);
	DDX_Text(pDX, IDC_EDIT4, m_strzdbms);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CTDXXDlg message handlers

BOOL CTDXXDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_tdxxlist.InsertColumn(0,"团队编号",LVCFMT_LEFT,200);
	m_tdxxlist.InsertColumn(1,"团队等级",LVCFMT_LEFT,200);
	m_tdxxlist.InsertColumn(2,"线路名称",LVCFMT_LEFT,120);
	m_tdxxlist.InsertColumn(3,"团队状态",LVCFMT_LEFT,200);
	m_tdxxlist.InsertColumn(4,"出团时间",LVCFMT_LEFT,200);
	m_tdxxlist.InsertColumn(5,"回团时间",LVCFMT_LEFT,200);
	m_tdxxlist.InsertColumn(6,"导游人数",LVCFMT_LEFT,200);
	m_tdxxlist.InsertColumn(7,"最大报名人数",LVCFMT_LEFT,200);

	m_tdxxlist.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 CTDXXDlg::OnAdd() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	if(!m_tdxx.IsOpen())	
	m_tdxx.Open();
	try
	{
	m_tdxx.AddNew();
	m_tdxx.m_tdbh=m_strtdbh;
	m_tdxx.m_tddj=m_strtddj;
	m_tdxx.m_xlmc=m_strxlmc;
	m_tdxx.m_tdzt=m_strtdzt;
	m_tdxx.m_ctsj=m_strctsj;
	m_tdxx.m_htsj=m_strhtsj;
	m_tdxx.m_dyrs=m_strdyrs;
	m_tdxx.m_zdbms=m_strzdbms;

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

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

	if(m_tdxx.IsEOF())
	{
		m_tdxx.Close();
		AfxMessageBox("没有该记录，不能修改！");
		return;
	}
	try
	{
			m_tdxx.Edit();
	//把对话框上的值赋给数据库
	m_tdxx.m_tdbh=m_strtdbh;
	m_tdxx.m_tddj=m_strtddj;
	m_tdxx.m_xlmc=m_strxlmc;
	m_tdxx.m_tdzt=m_strtdzt;
	m_tdxx.m_ctsj=m_strctsj;
	m_tdxx.m_htsj=m_strhtsj;
	m_tdxx.m_dyrs=m_strdyrs;
	m_tdxx.m_zdbms=m_strzdbms;

	if(m_tdxx.CanUpdate())
	m_tdxx.Update();
      AfxMessageBox("修改成功！");
	}
	catch(CDBException* e)
	{
		AfxMessageBox(e->m_strError,MB_ICONEXCLAMATION);
		e->Delete();
	}
	//将用户信息及时更新到ListCtrl中
		m_tdxxlist.SetItemText(m_CurUser,0,m_strtdbh);
		m_tdxxlist.SetItemText(m_CurUser,1,m_strtddj);
		m_tdxxlist.SetItemText(m_CurUser,2,m_strxlmc);
		m_tdxxlist.SetItemText(m_CurUser,3,m_strtdzt);
		m_tdxxlist.SetItemText(m_CurUser,4,m_strctsj);
		m_tdxxlist.SetItemText(m_CurUser,5,m_strhtsj);
		m_tdxxlist.SetItemText(m_CurUser,6,m_strdyrs);
		m_tdxxlist.SetItemText(m_CurUser,7,m_strzdbms);
}

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

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

	 index=m_tdxxlist.GetNextItem(-1,LVNI_SELECTED);
		m_tdxxlist.DeleteItem(index);
}

void CTDXXDlg::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	 index=m_tdxxlist.GetNextItem(-1,LVNI_SELECTED);
	if (index!=-1)
	{
	m_strtdbh=m_tdxxlist.GetItemText(index,0);
	m_strtddj=m_tdxxlist.GetItemText(index,1);
	m_strxlmc=m_tdxxlist.GetItemText(index,2);
	m_strtdzt=m_tdxxlist.GetItemText(index,3);
	m_strctsj=m_tdxxlist.GetItemText(index,4);
	m_strhtsj=m_tdxxlist.GetItemText(index,5);
	m_strdyrs=m_tdxxlist.GetItemText(index,6);
	m_strzdbms=m_tdxxlist.GetItemText(index,7);

	}
	UpdateData(FALSE);
	*pResult = 0;
}

void CTDXXDlg::ListAll()
{
	m_tdxxlist.DeleteAllItems();
 	if(!m_tdxx.IsOpen())
 		m_tdxx.Open();
 	CString strtemp;
 	int i=0;
 	m_tdxx.MoveFirst();

 	while(!m_tdxx.IsEOF())
 	{
 		
 		m_tdxxlist.InsertItem(i,strtemp);
        m_tdxxlist.SetItemText(i,0,m_tdxx.m_tdbh);
		m_tdxxlist.SetItemText(i,1,m_tdxx.m_tddj);
 		m_tdxxlist.SetItemText(i,2,m_tdxx.m_xlmc);
 		m_tdxxlist.SetItemText(i,3,m_tdxx.m_tdzt);
 		m_tdxxlist.SetItemText(i,4,m_tdxx.m_ctsj);
 		m_tdxxlist.SetItemText(i,5,m_tdxx.m_htsj);
 		m_tdxxlist.SetItemText(i,6,m_tdxx.m_dyrs);
 		m_tdxxlist.SetItemText(i,7,m_tdxx.m_zdbms);
 
 		m_tdxx.MoveNext();
 		i++;
	}
}