serchuserdlg.cpp

本售货管理系统用vc和sql开发

// SerchuserDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "SerchuserDlg.h"

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

extern CDatabase m_database;
/////////////////////////////////////////////////////////////////////////////
// CSerchuserDlg dialog


CSerchuserDlg::CSerchuserDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CSerchuserDlg::IDD, pParent)
{
	m_select=true;
	//{{AFX_DATA_INIT(CSerchuserDlg)
	m_name = _T("");
	sql=_T("");
	//}}AFX_DATA_INIT
}


void CSerchuserDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSerchuserDlg)
	DDX_Control(pDX, IDC_SERCHPOWER, m_searchlist);
	DDX_Control(pDX, IDC_CHECKUSER, m_checkname);
	DDX_Control(pDX, IDC_CHECKPOWER, m_checkpower);
	DDX_Text(pDX, IDC_SEARCHNAME, m_name);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSerchuserDlg, CDialog)
	//{{AFX_MSG_MAP(CSerchuserDlg)
	ON_BN_CLICKED(IDSEARCH, OnSearch)
	ON_CBN_SELCHANGE(IDC_SERCHPOWER, OnSelchangeSerchpower)
	ON_BN_CLICKED(IDSEARCHCANCEL, OnSearchcancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSerchuserDlg message handlers

void CSerchuserDlg::OnSearch() 
{
	UpdateData(TRUE);
	bool sign=false;
	CString temp;
	//sql是一个CString 的变量
	sql.Format("select * from 用户密码表 ");
	//判断是否选择用户名查询
	if(m_checkname.GetCheck()){
		temp.Format("'%s'",m_name);
		sql=sql+"where 用户名="+temp;
		sign=true;
	}
	//判断是否选择权限查询
	if(m_checkpower.GetCheck()){
		//判断是否使用用户名进行查询，以便作出不同处理
		if(sign){
			temp.Format("'%s'",m_power);
			sql=sql+" and 用户权限="+temp;
		}else{
			temp.Format("'%s'",m_power);
			sql=sql+" where 用户权限="+temp;
		}
	}
	CDialog::OnOK();
	
}

BOOL CSerchuserDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();	
	CPowerSet m_powerset;
	m_powerset.m_pDatabase=&m_database;
	sql.Format("select *from 用户权限表");
	m_powerset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	if(!m_powerset.IsEOF()){
		int i=0;
		while(!m_powerset.IsEOF()){	
			m_searchlist.InsertString(i,m_powerset.m_column1);
			m_powerset.MoveNext();
			i++;
		}
		m_searchlist.SetCurSel(0);
		m_searchlist.GetLBText(0,m_power);
		m_power.TrimRight();
		m_power.TrimLeft();
	}
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSerchuserDlg::OnSelchangeSerchpower() 
{
	
	int i =m_searchlist.GetCurSel();
	m_searchlist.GetLBText(i,m_power);
	m_power.TrimRight();
	m_power.TrimLeft();
}

void CSerchuserDlg::OnSearchcancel() 
{
	m_select=false;
	CDialog::OnCancel();
	
}