deluserdlg.cpp

小型超市管理系统是方便超市管理员管理超市的一个小软件

// DelUserDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SuperMarket.h"
#include "DelUserDlg.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CDelUserDlg dialog


CDelUserDlg::CDelUserDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CDelUserDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CDelUserDlg)
	m_number = _T("");
	a=0;
	//}}AFX_DATA_INIT
}


void CDelUserDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDelUserDlg)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_number, m_number);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CDelUserDlg, CDialog)
	//{{AFX_MSG_MAP(CDelUserDlg)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDelUserDlg message handlers

void CDelUserDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	m_list.DeleteAllItems();
	UpdateData(); 
	CDatabase dbTemp;
	CString str0,str1,str2,str3,name;
	int times=0;
	
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理数据库.mdb;");               
	CRecordset  rs( &dbTemp);  //查询
	rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 用户表");
	while(!rs.IsEOF())
	{
		rs.GetFieldValue((short)0,str0);
		rs.GetFieldValue((short)1,str1);
		rs.GetFieldValue((short)2,str2);
		rs.GetFieldValue((short)3,str3);
	
	   
		if(str0==m_number||str1==m_number)
		{
			a=1;
			
			m_list.InsertItem   (times,str0);//写第一列；   
			m_list.SetItemText   (times,1,str1);//第二列；   
			m_list.SetItemText   (times,2,str2);//第三列；   
			m_list.SetItemText   (times,3,str3);//第四列；
            times = times + 1;
		}
		
		rs.MoveNext();
	}
	if(a==0)
	{
		
			MessageBox("你所查询的用户不存在，请重新输入");
			m_number="";
			UpdateData(FALSE);
		
	}
}


BOOL CDelUserDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_list.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT|LVS_EX_ONECLICKACTIVATE);
	
	m_list.InsertColumn(0,"用户编号",LVCFMT_LEFT,80);
	m_list.InsertColumn(1,"用户名称",LVCFMT_LEFT,110);
	m_list.InsertColumn(2,"用户密码",LVCFMT_LEFT,80);
	m_list.InsertColumn(3,"用户类型",LVCFMT_LEFT,120);

	// 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 CDelUserDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	CDatabase dbTemp;
  	CString strSQL;
	UpdateData();
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理数据库.mdb;");
	if (a == 1)
	{
        strSQL="delete from 用户表  where userid='"+m_number+"'";
		strSQL="delete from 用户表  where username='"+m_number+"'";
		dbTemp.ExecuteSQL(strSQL);
		MessageBox("删除成功!");

		
		m_number="";
	} 
	
	
   
	UpdateData(false);
	dbTemp.Close();
}