superdepe.cpp

该系统为花店销售管理系统

// superdepe.cpp : implementation file
//

#include "stdafx.h"
#include "flowerSaleSystem.h"
#include "superdepe.h"
#include "deset.h"
#include "ex_de_sure.h"
#include "sude_pe_add.h"

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

extern CDatabase m_db;
extern CString m_iden;
/////////////////////////////////////////////////////////////////////////////
// superdepe property page
IMPLEMENT_DYNCREATE(superdepe, CPropertyPage)

superdepe::superdepe() : CPropertyPage(superdepe::IDD)
{
	//{{AFX_DATA_INIT(superdepe)
	m_name = _T("");
	m_phn = _T("");
	m_psw = _T("");
	m_user = _T("");
	m_year = 0;
	//}}AFX_DATA_INIT
	m_nIndex=-1;
}

superdepe::~superdepe()
{
}

void superdepe::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(superdepe)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_EDITname, m_name);
	DDX_Text(pDX, IDC_EDITphn, m_phn);
	DDX_Text(pDX, IDC_EDITpsw, m_psw);
	DDX_Text(pDX, IDC_EDITuser, m_user);
	DDX_Text(pDX, IDC_EDITyear, m_year);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(superdepe, CPropertyPage)
	//{{AFX_MSG_MAP(superdepe)
	ON_BN_CLICKED(IDC_BUTTONdelete, OnBUTTONdelete)
	ON_BN_CLICKED(IDC_BUTTONadd, OnBUTTONadd)
	ON_BN_CLICKED(IDC_BUTTONmodify, OnBUTTONmodify)
	ON_BN_CLICKED(IDC_BUTTONrefrush, OnBUTTONrefrush)
	ON_WM_PAINT()
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// superdepe message handlers

BOOL superdepe::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_list.SetExtendedStyle(LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES);
	m_list.SetBkColor(RGB(247,247,255));
	m_list.SetTextColor(RGB(0,0,255));
	m_list.SetTextBkColor(RGB(247,247,255));

	m_font.CreateFont(16, 0,0,0,FW_NORMAL, 0,0,0,
		DEFAULT_CHARSET, OUT_CHARACTER_PRECIS, CLIP_CHARACTER_PRECIS,
		DEFAULT_QUALITY, DEFAULT_PITCH | FF_DONTCARE, "Georgia");
    m_list.SetFont(&m_font);
	m_list.InsertColumn(0,"姓名",LVCFMT_CENTER,60);
	m_list.InsertColumn(1,"账号",LVCFMT_CENTER,100);
	m_list.InsertColumn(2,"性别",LVCFMT_CENTER,60);
	m_list.InsertColumn(3,"年龄",LVCFMT_CENTER,60);
	m_list.InsertColumn(4,"级别",LVCFMT_CENTER,60);
	m_list.InsertColumn(5,"密码",LVCFMT_CENTER,70);
	m_list.InsertColumn(6,"电话",LVCFMT_CENTER,120);
    m_brush.CreateSolidBrush(RGB(0,0,0));
    deset m_set(&m_db);

	if(m_db.IsOpen()) m_db.Close();
	m_db.Open(_T("flower"),FALSE,FALSE,_T("ODBC"),TRUE);

	//m_set.Open(AFX_DB_USE_DEFAULT_TYPE,"[管理员信息]",NULL);
    if(!m_set.IsOpen()) m_set.Open();

    m_list.DeleteAllItems();
	int n=0;
	while(!m_set.IsEOF())
	{
		m_list.InsertItem(n,"");
		CString s;
		m_list.SetItemText(n,0,m_set.m_mname);
		m_list.SetItemText(n,1,m_set.m_mid);
		m_list.SetItemText(n,2,m_set.m_msex);
        s.Format("%d",m_set.m_myear);
		m_list.SetItemText(n,3,s);
		m_list.SetItemText(n,4,m_set.m_mpower);
		m_list.SetItemText(n,5,m_set.m_mpassword);
		m_list.SetItemText(n,6,m_set.m_mphone);

		m_set.MoveNext();
		n++;
	}
	m_set.Close();
	
    //CString iden=m_iden;
	m_set.m_strFilter.Format("mid='%s'",m_iden);
	if(m_set.Open())
	{
		m_user=m_set.m_mid;
		m_psw=m_set.m_mpassword;
		m_phn=m_set.m_mphone;
		//m_year.Format("%d",m_set.m_myear);
		m_year=m_set.m_myear;
		m_name=m_set.m_mname;
		if(m_set.m_msex=="男") CheckRadioButton(IDC_RADIO,IDC_RADIO3,IDC_RADIO);
		else  CheckRadioButton(IDC_RADIO,IDC_RADIO3,IDC_RADIO3);
	}
	m_set.Close();
    CWnd *wnd1=GetDlgItem(IDC_EDITphn);
	CWnd *wnd2=GetDlgItem(IDC_EDITname);
	CWnd *wnd3=GetDlgItem(IDC_EDITuser);
	CWnd *wnd4=GetDlgItem(IDC_EDITpsw);
	CWnd *wnd5=GetDlgItem(IDC_EDITyear);
	CWnd *wnd6=GetDlgItem(IDC_RADIO);
	wnd1->EnableWindow(FALSE);
	wnd2->EnableWindow(FALSE);
	wnd3->EnableWindow(FALSE);
	wnd4->EnableWindow(FALSE);
	wnd5->EnableWindow(FALSE);
	wnd6->EnableWindow(FALSE);
	UpdateData(FALSE);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void superdepe::OnBUTTONdelete() 
{
	// TODO: Add your control notification handler code here
	//ex_de_sure exdlg;
	//if(exdlg.DoModal()==IDCANCEL)return;	
	m_list.SetFocus();
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	m_nIndex = m_list.GetNextSelectedItem(pos);  // 得到项目索引
	if(m_nIndex==-1)
	{
		
		MessageBox("请选择一项在删除!","提示",MB_ICONINFORMATION);
		return;
	}
	
	CString m_getmid;
	deset m_set;
	
	m_getmid=m_list.GetItemText(m_nIndex,1);
    m_set.m_strFilter.Format("mid='%s'",m_getmid);
	if(m_set.Open())
	{
		m_set.Delete();
		m_set.Requery();
	}
	m_set.Close();
	m_list.DeleteItem(m_nIndex); 
	UINT flag = LVIS_SELECTED|LVIS_FOCUSED;
	m_list.SetItemState(m_nIndex-1, flag, flag);
}

void superdepe::OnBUTTONadd() 
{
	// TODO: Add your control notification handler code here
	sude_pe_add spadlg;
	spadlg.DoModal();
}

void superdepe::OnBUTTONmodify() 
{
	// TODO: Add your control notification handler code here
	CString bttext;
    CWnd *wnd=GetDlgItem(IDC_BUTTONmodify);
	GetDlgItemText(IDC_BUTTONmodify,bttext);
	if(bttext=="修改")
	{
		CWnd *wnd1=GetDlgItem(IDC_EDITphn);
		CWnd *wnd2=GetDlgItem(IDC_EDITname);
		//CWnd *wnd3=GetDlgItem(IDC_EDITuser);
		CWnd *wnd4=GetDlgItem(IDC_EDITpsw);
		CWnd *wnd5=GetDlgItem(IDC_EDITyear);
		CWnd *wnd6=GetDlgItem(IDC_RADIO);
		wnd1->EnableWindow(TRUE);
		wnd2->EnableWindow(TRUE);
		wnd4->EnableWindow(TRUE);
		wnd5->EnableWindow(TRUE);
		wnd6->EnableWindow(TRUE);
		wnd->SetWindowText("确定");
	}
	else 
	{
        UpdateData(TRUE);
		if(m_name.GetLength()>6)
	{
		MessageBox("此系统最多支持3个汉字或6个英语字母!","温馨提示");
		return;
	}
	if(m_psw.GetLength()>6)
	{
		MessageBox("此系统最多支持8位密码!","温馨提示");
	}
	if(m_phn.GetLength()>12)
	{
		MessageBox("此系统最多支持12位电话号码!","温馨提示");
		return;
	}
		deset de;
		de.m_strFilter.Format("mid='%s'",m_iden);
		if(de.Open())
		{
			de.Edit();
			de.m_mid=m_iden;
			de.m_mname=m_name;
			int temp=GetCheckedRadioButton(IDC_RADIO,IDC_RADIO3);
			if(temp==IDC_RADIO) de.m_msex="男";
			else de.m_msex="女";
			de.m_myear=m_year;
			de.m_mphone=m_phn;
			de.m_mpassword=m_psw;
            de.m_mpower="超级";
		}
/*			deset des;
			if(des.Open())
			{
				while(!des.IsEOF())
				{
					if(des.m_mid==m_user)
					{
						MessageBox("此账号已存取在,请重新设定!");
							return;
					}
					else
						des.MoveNext();
				}
			}
			des.Close();
			de.m_mid=m_user;
            de.Update();
			de.Requery();
		}*/
		de.Update();
		de.Requery();
		de.Close();
		CWnd *wnd1=GetDlgItem(IDC_EDITphn);
		CWnd *wnd2=GetDlgItem(IDC_EDITname);
		CWnd *wnd3=GetDlgItem(IDC_EDITuser);
		CWnd *wnd4=GetDlgItem(IDC_EDITpsw);
		CWnd *wnd5=GetDlgItem(IDC_EDITyear);
        CWnd *wnd6=GetDlgItem(IDC_RADIO);
		wnd1->EnableWindow(FALSE);
		wnd2->EnableWindow(FALSE);
		wnd3->EnableWindow(FALSE);
		wnd4->EnableWindow(FALSE);
	    wnd5->EnableWindow(FALSE);
		wnd6->EnableWindow(FALSE);
		wnd->SetWindowText("修改");
	}
}

void superdepe::OnBUTTONrefrush() 
{
	// TODO: Add your control notification handler code here
	deset m_set;
	int n=0;
	m_set.Open();
	m_list.DeleteAllItems();
	while(!m_set.IsEOF())
	{
		CString s;
		m_list.InsertItem(n,"");
		m_list.SetItemText(n,0,m_set.m_mname);
		m_list.SetItemText(n,1,m_set.m_mid);
		m_list.SetItemText(n,2,m_set.m_msex);
        s.Format("%d",m_set.m_myear);
		m_list.SetItemText(n,3,s);
		m_list.SetItemText(n,4,m_set.m_mpower);
		m_list.SetItemText(n,5,m_set.m_mpassword);
		m_list.SetItemText(n,6,m_set.m_mphone);
		
		m_set.MoveNext();
		n++;
	}
	
	m_set.Close();
}

void superdepe::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	
	// TODO: Add your message handler code here

	CDC     memDC;
	CBitmap	bitmap;
	BITMAP  bmp;
	bitmap.LoadBitmap(IDB_BITMAPs);
	bitmap.GetObject (sizeof(BITMAP),&bmp);
	memDC.CreateCompatibleDC (&dc);
	memDC.SelectObject (bitmap);
		dc.BitBlt (0,0,bmp.bmWidth ,bmp.bmHeight ,&memDC,0,0,SRCCOPY);
	// Do not call CPropertyPage::OnPaint() for painting messages
}

HBRUSH superdepe::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CPropertyPage::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
	if(nCtlColor==CTLCOLOR_LISTBOX)   
	{   
		pDC->SetBkMode(TRANSPARENT);//   
		pDC->SetTextColor(RGB(255,0,0));   
		return   m_brush;   
	}  
	if(nCtlColor==CTLCOLOR_EDIT)
	{
		
		pDC->SetBkMode(TRANSPARENT);//   
		pDC->SetTextColor(RGB(0,255,0));   
		return m_brush;
	}
	if(nCtlColor==CTLCOLOR_STATIC)
    {
		pDC->SetBkMode(TRANSPARENT);//   
		pDC->SetTextColor(RGB(255,255,0));  
		return   m_brush
			;   
	}
	if(nCtlColor==CTLCOLOR_DLG)   
	{   
		pDC->SetBkMode(TRANSPARENT);//   
		pDC->SetTextColor(RGB(175,216,229));   //浅色字体   
		return   hbr;   
	}
	// TODO: Return a different brush if the default is not desired
	return hbr;
}