regvipdlg.cpp

书店销售管理系统 用c++写的

// RegVipDlg.cpp : implementation file
//

#include "stdafx.h"
#include "resource.h"
#include "RegVipDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRegVipDlgDlgDlg dialog


CRegVipDlg::CRegVipDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRegVipDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRegVipDlg)
	m_VipID = _T("");
	m_Vipage = 20;
	m_Vipcompany = _T("");
	m_Vipname = _T("");
	m_VipTele = _T("");
	m_Vipgender = 0;
	m_VipregID = _T("");
	//}}AFX_DATA_INIT
}


void CRegVipDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRegVipDlg)
	DDX_Control(pDX, IDC_REGVIPLIST, m_RegVipList);
	DDX_Text(pDX, IDC_VIPID, m_VipID);
	DDX_Text(pDX, IDC_VIPAGE, m_Vipage);
	DDV_MinMaxInt(pDX, m_Vipage, 1, 100);
	DDX_Text(pDX, IDC_VIPCOMPANY, m_Vipcompany);
	DDX_Text(pDX, IDC_VIPNAME, m_Vipname);
	DDX_Text(pDX, IDC_VIPTELE, m_VipTele);
	DDX_CBIndex(pDX, IDC_VIPGENGER, m_Vipgender);
	DDX_Text(pDX, IDC_VIPREGID, m_VipregID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRegVipDlg, CDialog)
	//{{AFX_MSG_MAP(CRegVipDlg)
	ON_NOTIFY(NM_RCLICK, IDC_REGVIPLIST, OnRclickRegviplist)
	ON_BN_CLICKED(IDC_REGCONTINUE, OnRegcontinue)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRegVipDlg message handlers
BOOL CRegVipDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	m_RegVipList.SetTextColor(RGB (0, 0, 0));
	m_RegVipList.SetBkColor(RGB(255,255,255));
	m_RegVipList.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	

	m_RegVipList.InsertColumn(0,_T("会员代号"),LVCFMT_CENTER,80);
	m_RegVipList.InsertColumn(1,_T("姓名"),LVCFMT_CENTER,80);
	m_RegVipList.InsertColumn(2,_T("性别"),LVCFMT_CENTER,60);
	m_RegVipList.InsertColumn(3,_T("年龄"),LVCFMT_CENTER,60);
	m_RegVipList.InsertColumn(4,_T("身份证"),LVCFMT_CENTER,100);
	m_RegVipList.InsertColumn(5,_T("登记日期"),LVCFMT_CENTER,100);
	m_RegVipList.InsertColumn(6,_T("电话"),LVCFMT_CENTER,100);
	m_RegVipList.InsertColumn(7,_T("工作单位"),LVCFMT_CENTER,100);

	return TRUE;
}

void CRegVipDlg::OnRegcontinue() 
{
	CTime regtime;
	regtime = CTime::GetCurrentTime();
	int year,mon,day;
	year = regtime.GetYear();
	mon = regtime.GetMonth();
	day = regtime.GetDay();
	CString strtime;
	strtime.Format("%d年%d月%d日",year,mon,day);

	this->UpdateData(true);
	CString _sql;
	_sql.Format("insert into VIP(VIPNO,VIPNAME,VIPGENDER,VIPID,VIPAGE,VIPTELE,VIPREGDATE,VIPCOM) values(\'%s\',\'%s\',%d,\'%s\',%d,\'%s\',SYSDATE,\'%s\')",
		m_VipregID,m_Vipname,m_Vipgender,m_VipID,m_Vipage,m_VipTele,m_Vipcompany);
	_bstr_t sql = _sql;
		if(!m_VipregID.IsEmpty())
		{
			if(!m_Vipname.IsEmpty())
			{
				if(m_Vipage>1&&m_Vipage<100)
				{
					if(m_Vipgender == 0 ||m_Vipgender == 1)
					{
						CString m_RegGender;
						CString m_RegAge;
						if(m_Vipgender == 0)
							m_RegGender = "男";
						else
							m_RegGender = "女";
						m_RegAge.Format("%d",m_Vipage);
						
						m_RegVipList.InsertItem(0,m_VipregID,0);
						m_RegVipList.SetItemText(0,1,m_Vipname);
						m_RegVipList.SetItemText(0,2,m_RegGender);
						m_RegVipList.SetItemText(0,3,m_RegAge);
						m_RegVipList.SetItemText(0,4,m_VipID);
						m_RegVipList.SetItemText(0,5,strtime);
						m_RegVipList.SetItemText(0,6,m_VipTele);
						m_RegVipList.SetItemText(0,7,m_Vipcompany);
						
						m_VipregID = "";
						m_Vipname = "";
						m_VipID = "";
						m_VipTele = "";
						m_Vipcompany = "";
						this->UpdateData(false);
						try
						{
							pConn->Execute(sql,NULL,SHOP::adCmdText);
						} 
						catch(_com_error& e)
						{
							AfxMessageBox(e.Description());
							return;
						}  
					}
					else
						AfxMessageBox("请输入性别!");
				}
			}
			else
				AfxMessageBox("请输入会员姓名!");
		}
		else
			AfxMessageBox("请输入会员代号!");
}

void CRegVipDlg::OnRclickRegviplist(NMHDR* pNMHDR, LRESULT* pResult) 
{
	
	*pResult = 0;
}