txldlg.cpp

一个简单的同学录管理系统,可以试用一下.

// TXLDlg.cpp : implementation file
//

#include "stdafx.h"
#include "TXL.h"
#include "TXLDlg.h"
#include"ADDRESS.h"
#include"DLG.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CAboutDlg dialog used for App About

class CAboutDlg : public CDialog
{
public:
	CAboutDlg();

// Dialog Data
	//{{AFX_DATA(CAboutDlg)
	enum { IDD = IDD_ABOUTBOX };
	//}}AFX_DATA

	// ClassWizard generated virtual function overrides
	//{{AFX_VIRTUAL(CAboutDlg)
	protected:
	virtual void DoDataExchange(CDataExchange* pDX);    // DDX/DDV support
	//}}AFX_VIRTUAL

// Implementation
protected:
	//{{AFX_MSG(CAboutDlg)
	//}}AFX_MSG
	DECLARE_MESSAGE_MAP()
};

CAboutDlg::CAboutDlg() : CDialog(CAboutDlg::IDD)
{
	//{{AFX_DATA_INIT(CAboutDlg)
	//}}AFX_DATA_INIT
}

void CAboutDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAboutDlg)
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CAboutDlg, CDialog)
	//{{AFX_MSG_MAP(CAboutDlg)
		// No message handlers
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTXLDlg dialog

CTXLDlg::CTXLDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CTXLDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CTXLDlg)
	m_findstr = _T("");
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CTXLDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CTXLDlg)
	DDX_Control(pDX, IDC_COMBO1, m_sortstr);
	DDX_Control(pDX, IDC_FIND, m_find);
	DDX_Control(pDX, IDC_SHOWTIME, m_Clock);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_EDIT1, m_findstr);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CTXLDlg, CDialog)
	//{{AFX_MSG_MAP(CTXLDlg)
	ON_WM_SYSCOMMAND()
	ON_WM_PAINT()
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_ADD, OnAdd)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_BN_CLICKED(IDC_MODIFY, OnModify)
	ON_BN_CLICKED(IDC_SHOW, OnShow)
	ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST1, OnItemchangedList1)
	ON_BN_CLICKED(IDC_FIND, OnFind)
	ON_BN_CLICKED(IDC_jing, Onjing)
	ON_BN_CLICKED(IDC_mohu, Onmohu)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CTXLDlg message handlers

BOOL CTXLDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
    m_Clock.Start(IDB_BITMAP3,IDB_BITMAP4,IDB_BITMAP2);
   m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);
   //m_list.InsertColumn(0,"序号",LVCFMT_CENTER,100);
   m_list.InsertColumn(0,"姓名",LVCFMT_CENTER,110);
   m_list.InsertColumn(1,"性别",LVCFMT_CENTER,100);
   m_list.InsertColumn(2,"关系",LVCFMT_CENTER,110);
   m_list.InsertColumn(3,"联系电话",LVCFMT_CENTER,110);
   m_list.InsertColumn(4,"手机号码",LVCFMT_CENTER,110);
   m_list.InsertColumn(5,"家听住址",LVCFMT_CENTER,110);
   m_list.InsertColumn(6,"工作单位",LVCFMT_CENTER,110);
   m_list.InsertColumn(7,"E_mail地址",LVCFMT_CENTER,110);
   m_list.InsertColumn(8,"OICQ号码",LVCFMT_CENTER,110);
   pdb=new CDatabase;

    m_pSet=new ADDRESS(pdb);

//    m_pSet->Open(AFX_DB_USE_DEFAULT_TYPE,"select * from person");
	//AfxMessageBox("tttt");
	m_pSet->Open();
     LoadData();
   m_sortstr.InsertString(0,"NAME");
   m_sortstr.InsertString(1,"SEX");
   m_sortstr.InsertString(2,"RELATION");
   m_sortstr.InsertString(3,"TELEPHONE");
   m_sortstr.InsertString(4,"手机号码");
    m_sortstr.InsertString(4,"家听住址");
	 m_sortstr.InsertString(4,"工作单位");
	  m_sortstr.InsertString(4,"E_mail地址");
	   m_sortstr.InsertString(4,"OICQ号码");
    m_sortstr.SetCurSel(0);	
	// Add "About..." menu item to system menu.

	// IDM_ABOUTBOX must be in the system command range.
	ASSERT((IDM_ABOUTBOX & 0xFFF0) == IDM_ABOUTBOX);
	ASSERT(IDM_ABOUTBOX < 0xF000);

	CMenu* pSysMenu = GetSystemMenu(FALSE);
	if (pSysMenu != NULL)
	{
		CString strAboutMenu;
		strAboutMenu.LoadString(IDS_ABOUTBOX);
		if (!strAboutMenu.IsEmpty())
		{
			pSysMenu->AppendMenu(MF_SEPARATOR);
			pSysMenu->AppendMenu(MF_STRING, IDM_ABOUTBOX, strAboutMenu);
		}
	}

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE  unless you set the focus to a control
}

void CTXLDlg::OnSysCommand(UINT nID, LPARAM lParam)
{
	if ((nID & 0xFFF0) == IDM_ABOUTBOX)
	{
		CAboutDlg dlgAbout;
		dlgAbout.DoModal();
	}
	else
	{
		CDialog::OnSysCommand(nID, lParam);
	}
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.

void CTXLDlg::OnPaint() 
{
	if (IsIconic())
	{
		CPaintDC dc(this); // device context for painting

		SendMessage(WM_ICONERASEBKGND, (WPARAM) dc.GetSafeHdc(), 0);

		// Center icon in client rectangle
		int cxIcon = GetSystemMetrics(SM_CXICON);
		int cyIcon = GetSystemMetrics(SM_CYICON);
		CRect rect;
		GetClientRect(&rect);
		int x = (rect.Width() - cxIcon + 1) / 2;
		int y = (rect.Height() - cyIcon + 1) / 2;

		// Draw the icon
		dc.DrawIcon(x, y, m_hIcon);
	}
	else
	{
		CDialog::OnPaint();
	}
}

// The system calls this to obtain the cursor to display while the user drags
//  the minimized window.
HCURSOR CTXLDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}
void CTXLDlg::LoadData()
{
m_list.DeleteAllItems();
  int i=0;
 while(!m_pSet->IsEOF())
 { //CString str;
  //str.Format("%d",m_pSet->m_ID2);
 m_list.InsertItem(i,m_pSet->m_NAME);

  
  //m_list.SetItemText(i,1,m_pSet->m_NAME);
  
  m_list.SetItemText(i,1,m_pSet->m_SEX);
  m_list.SetItemText(i,2,m_pSet->m_RELATION);
  m_list.SetItemText(i,3,m_pSet->m_TELEPHONE);
  m_list.SetItemText(i,4,m_pSet->m_HANDPHONE);
  m_list.SetItemText(i,5,m_pSet->m_ADDRESS);
  m_list.SetItemText(i,6,m_pSet->m_WORKPLACE);
  m_list.SetItemText(i,7,m_pSet->m_EMAIL);
  m_list.SetItemText(i,8,m_pSet->m_OICQ);
  
  i++;
  m_pSet->MoveNext();
 }

}

void CTXLDlg::OnAdd() 
{		DLG mydlg;
    
	

       showflag=false;
              //m_pSet->MoveLast(); 
              //i=m_pSet->m_ID2+1;
  /*    if(m_pSet->IsOpen())
	  {	m_pSet->Close();
       m_pSet->Open();}*/
            if(mydlg.DoModal()==IDOK)
			{
	UpdateData(true);
	
	CString str;
	str.Format("insert into person values('%s' ,'%s' ,'%s','%s','%s','%s','%s','%s','%s')",
		mydlg.m_name,temp,mydlg.m_relation,mydlg.m_photo,mydlg.m_handphoto,mydlg.m_address,mydlg.m_workplace,mydlg.m_email,mydlg.m_OICQ);
	pdb->ExecuteSQL(str);

	m_pSet->Requery();
	LoadData();
	
}

}

void CTXLDlg::OnDelete() 
{
	//AfxMessageBox("请选择一条记录");
	DLG mydlg;

if(m_pSet->IsOpen())
	  {	m_pSet->Close();
       m_pSet->Open();}
    m_pSet->MoveFirst();

  while(!m_pSet->IsEOF())
	{  if(m_pSet->m_NAME==name) break;
       else m_pSet->MoveNext();}

    UpdateData(true);

     CString str;
    if(MessageBox("确定吗？","你真的要删除吗？",MB_YESNO|MB_ICONINFORMATION)==IDYES)
	{str.Format("delete from person  where NAME='%s'",name);	
     pdb->ExecuteSQL(str);
     m_pSet->Requery();
     LoadData();
	}
}

void CTXLDlg::OnModify() 
{
    DLG mydlg;
	showflag=true;
  if(m_pSet->IsOpen())
	  {	m_pSet->Close();
       m_pSet->Open();}
    m_pSet->MoveFirst();

  while(!m_pSet->IsEOF())
	{  if(m_pSet->m_NAME==name) break;
       else m_pSet->MoveNext();}
	
   
   mydlg.m_sexstr=m_pSet->m_SEX;
     mydlg.m_address=m_pSet->m_ADDRESS;
    mydlg.m_email=m_pSet->m_EMAIL;
 mydlg.m_handphoto=m_pSet->m_HANDPHONE;
  
  mydlg.m_name=m_pSet->m_NAME;
  mydlg.m_OICQ=m_pSet->m_OICQ;

   mydlg.m_relation=m_pSet->m_RELATION;

   mydlg.m_photo=m_pSet->m_TELEPHONE;
 mydlg.m_workplace=m_pSet->m_WORKPLACE;

UpdateData(false);
aa:if(mydlg.DoModal()==IDOK)
{



	UpdateData(true);
CString str;
str.Format("update person set  RELATION='%s', TELEPHONE='%s', HANDPHONE='%s', ADDRESS='%s', WORKPLACE='%s' ,EMAIL='%s', OICQ='%s' where NAME='%s'"
		,mydlg.m_relation,mydlg.m_photo,mydlg.m_handphoto,mydlg.m_address,mydlg.m_workplace,mydlg.m_email,mydlg.m_OICQ,name);
	pdb->ExecuteSQL(str);

 m_pSet->Requery();
 LoadData();











/*m_pSet->Edit();
    m_pSet->m_ADDRESS=mydlg.m_address;
    m_pSet->m_EMAIL=mydlg.m_email;
    m_pSet->m_HANDPHONE=mydlg.m_handphoto;

	m_pSet->m_NAME=mydlg.m_name;
    m_pSet->m_OICQ=mydlg.m_OICQ;

    m_pSet->m_RELATION=mydlg.m_relation;
//    m_pSet->m_SEX=mydlg.m_sex;
    m_pSet->m_TELEPHONE=mydlg.m_photo;
    m_pSet->m_WORKPLACE=mydlg.m_workplace;
	m_pSet->Update();
	m_pSet->Requery();
	
	UpdateData(false);*/}
	
}

void CTXLDlg::OnShow() 
{   m_pSet->MoveFirst();
	m_list.DeleteAllItems();
  
    int i=0;
    while(!m_pSet->IsEOF())
 { //CString str;
  //str.Format("%d",m_pSet->m_ID2);
 m_list.InsertItem(i,m_pSet->m_NAME);

  
  //m_list.SetItemText(i,1,m_pSet->m_NAME);
  
  m_list.SetItemText(i,1,m_pSet->m_SEX);
  m_list.SetItemText(i,2,m_pSet->m_RELATION);
  m_list.SetItemText(i,3,m_pSet->m_TELEPHONE);
  m_list.SetItemText(i,4,m_pSet->m_HANDPHONE);
  m_list.SetItemText(i,5,m_pSet->m_ADDRESS);
  m_list.SetItemText(i,6,m_pSet->m_WORKPLACE);
  m_list.SetItemText(i,7,m_pSet->m_EMAIL);
  m_list.SetItemText(i,8,m_pSet->m_OICQ);
  
  i++;
  m_pSet->MoveNext();
 }
}

void CTXLDlg::OnItemchangedList1(NMHDR* pNMHDR, LRESULT* pResult) 
{    DLG mydlg;
	NM_LISTVIEW* pNMListView = (NM_LISTVIEW*)pNMHDR;
  int selectrow=pNMListView->iItem;
  name=m_list.GetItemText(selectrow,0);
  //mydlg.m_sex=m_list.GetItemText(selectrow,2);
 /* mydlg.m_relation=m_list.GetItemText(selectrow,3);
  mydlg.m_photo=m_list.GetItemText(selectrow,4);
  mydlg.m_handphoto=m_list.GetItemText(selectrow,5);
  mydlg.m_address=m_list.GetItemText(selectrow,6);
  mydlg.m_workplace=m_list.GetItemText(selectrow,7);
  mydlg.m_email=m_list.GetItemText(selectrow,8);
  mydlg.m_OICQ=m_list.GetItemText(selectrow,9);*/

  UpdateData(FALSE);	
	*pResult = 0;
}

void CTXLDlg::OnFind() 
{   
      CString  temp1 = "";
      CString str;
      if(m_pSet->IsOpen())
	   m_pSet->Close();

       m_pSet->Open();
       UpdateData();
 
      int k=m_sortstr.GetCurSel();
      m_sortstr.GetLBText(k,temp1);	  
	  if(choose=false)
	  str.Format("%s='%s'",temp1,m_findstr);
	  else
	  str.Format("%s like '%%%s%%'",temp1,m_findstr); 
      m_pSet->m_strFilter=str;
      m_pSet->Requery();
	  LoadData();  


	 

}

void CTXLDlg::Onjing() 
{
	choose=false;
	
}

void CTXLDlg::Onmohu() 
{
	choose=true;
	
}