resultsimple.cpp

使用vc进行数据库编程的好例子

// ResultSimple.cpp : implementation file
//

#include "stdafx.h"
#include "ManageSystem.h"
#include "ResultSimple.h"

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

#define SHOW_PRODUCT	0
#define SHOW_MEMBER		1

#define DELETEMEM	0
#define	DELETEPDT	1

#define MODIFYMEM	0
#define MODIFYPDT	1
//=======================
#define 	MEM_DETAIL	1
#define 	PDT_DETAIL	2
#define 	MEM_SIMPLE	3
#define 	PDT_SIMPLE	4
////////////////////////////////
extern	bool	g_isPLocked;
extern	bool	g_isMlocked;
/////////////////////////////////////////////////////////////////////////////
// CResultSimple dialog
IMPLEMENT_DYNCREATE(CResultSimple, CDialog)

CResultSimple::CResultSimple(CWnd* pParent /*=NULL*/)
	: CDialog(CResultSimple::IDD, pParent)
{
	//{{AFX_DATA_INIT(CResultSimple)
	m_Tatal = _T("");
	//}}AFX_DATA_INIT
}


void CResultSimple::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResultSimple)
	DDX_Control(pDX, IDC_DELETE, m_btnDelete);
	DDX_Control(pDX, IDC_MODIFY, m_btnModify);
	DDX_Control(pDX, IDC_INSERT, m_btnInsert);
	DDX_Control(pDX, IDC_RESULT_SIMPLE, m_List_Result_Simp);
	DDX_Text(pDX, IDC_TOTAL, m_Tatal);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResultSimple, CDialog)
	//{{AFX_MSG_MAP(CResultSimple)
	ON_WM_SIZE()
	ON_NOTIFY(NM_DBLCLK, IDC_RESULT_SIMPLE, OnDblclkResultSimple)
	ON_BN_CLICKED(IDC_DELETE, OnDelete)
	ON_NOTIFY(NM_CLICK, IDC_RESULT_SIMPLE, OnClickResultSimple)
	ON_BN_CLICKED(IDC_INSERT, OnInsert)
	ON_BN_CLICKED(IDC_MODIFY, OnModify)
	ON_WM_LBUTTONUP()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResultSimple message handlers

void CResultSimple::OnOK() 
{
	// TODO: Add extra validation here

}

void CResultSimple::OnCancel() 
{
	// TODO: Add extra cleanup here

}

void CResultSimple::OnSize(UINT nType, int cx, int cy) 
{
	CDialog::OnSize(nType, cx, cy);
	
	// TODO: Add your message handler code here
	OnDialogSize();
}

BOOL CResultSimple::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_btnDelete.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	m_btnDelete.DrawFlatFocus(TRUE);
	m_btnInsert.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	m_btnInsert.DrawFlatFocus(TRUE);
	m_btnModify.SetShade(CShadeButtonST::SHS_HSHADE,8,20,5,RGB(55,55,255));
	m_btnModify.DrawFlatFocus(TRUE);

	m_List_Result_Simp.SetExtendedStyle(m_List_Result_Simp.GetExtendedStyle()|LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	m_flag=-1;
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CResultSimple::OnDialogSize()
{
	if(m_List_Result_Simp.GetSafeHwnd()
		&&m_btnInsert.GetSafeHwnd()
		&&m_btnModify.GetSafeHwnd()
		&&m_btnDelete.GetSafeHwnd())
	{
		CRect rect;
		GetClientRect(&rect);
		rect.top+=100;
		rect.left-=2;
		rect.right+=1;
		rect.bottom+=2;
		m_List_Result_Simp.MoveWindow(&rect);

		CRect btnRect;
		int width=rect.right-rect.left;
		width=width/18;
		btnRect.top=72;
		btnRect.bottom=95;

		btnRect.left=7*width;
		btnRect.right=btnRect.left+width*2;
		m_btnInsert.MoveWindow(&btnRect);

		btnRect.left=11*width;
		btnRect.right=btnRect.left+width*2;
		m_btnModify.MoveWindow(&btnRect);

		btnRect.left=15*width;
		btnRect.right=btnRect.left+width*2;
		m_btnDelete.MoveWindow(&btnRect);
	}

}

void CResultSimple::AddProductColomn()
{
	if(m_flag==SHOW_PRODUCT)
		return;


	m_flag=SHOW_PRODUCT;

	int nColumnCount=m_List_Result_Simp.GetHeaderCtrl()->GetItemCount();
	// Delete all of the columns.
	for (int i=0;i < nColumnCount;i++)
	{
		m_List_Result_Simp.DeleteColumn(0);
	}


	//ADD
	m_List_Result_Simp.InsertColumn(0,_T("产品名称"),LVCFMT_CENTER,100);
	m_List_Result_Simp.InsertColumn(1,_T("产品类别"),LVCFMT_LEFT,100);
	m_List_Result_Simp.InsertColumn(2,_T("供货地"),LVCFMT_LEFT,100);
	m_List_Result_Simp.InsertColumn(3,_T("单价"),LVCFMT_LEFT,80);
	m_List_Result_Simp.InsertColumn(4,_T("公司名"),LVCFMT_LEFT,100);
	m_List_Result_Simp.InsertColumn(5,_T("公司地址"),LVCFMT_LEFT,100);
	m_List_Result_Simp.InsertColumn(6,_T("联系人"),LVCFMT_LEFT,100);
	m_List_Result_Simp.InsertColumn(7,_T("联系电话"),LVCFMT_LEFT,100);

	m_List_Result_Simp.UpdateData(false);
	
}

void CResultSimple::AddMemberColomn()
{
	if(m_flag==SHOW_MEMBER)
		return;

	m_flag=SHOW_MEMBER;


	int nColumnCount=m_List_Result_Simp.GetHeaderCtrl()->GetItemCount();

	// Delete all of the columns.
	for (int i=0;i < nColumnCount;i++)
	{
		m_List_Result_Simp.DeleteColumn(0);
	}


	//ADD
	m_List_Result_Simp.InsertColumn(0,_T("会员账号"),LVCFMT_CENTER,80);
	m_List_Result_Simp.InsertColumn(1,_T("登陆密码"),LVCFMT_LEFT,80);
	m_List_Result_Simp.InsertColumn(2,_T("姓名"),LVCFMT_LEFT,70);
	m_List_Result_Simp.InsertColumn(3,_T("年龄"),LVCFMT_LEFT,40);
	m_List_Result_Simp.InsertColumn(4,_T("性别"),LVCFMT_LEFT,40);
	m_List_Result_Simp.InsertColumn(5,_T("身份证号"),LVCFMT_LEFT,130);
	m_List_Result_Simp.InsertColumn(6,_T("单位"),LVCFMT_LEFT,100);
	m_List_Result_Simp.InsertColumn(7,_T("省"),LVCFMT_LEFT,50);
	m_List_Result_Simp.InsertColumn(8,_T("市"),LVCFMT_LEFT,50);
	m_List_Result_Simp.InsertColumn(9,_T("联系电话"),LVCFMT_LEFT,130);
	m_List_Result_Simp.InsertColumn(10,_T("注册时间"),LVCFMT_LEFT,90);

	m_List_Result_Simp.UpdateData(false);
}

void CResultSimple::OnDblclkResultSimple(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	int index =m_List_Result_Simp.GetSelectionMark();
//	CString ItemName=m_List_Result_Simp.GetItemText(index,0);
	if(index>=0)
	{
		if(m_flag==SHOW_PRODUCT)
		{
			g_isPLocked=true;
			::SendMessage(GetParent()->m_hWnd,WM_SHOW_PRO_RESULT_DETAIL,index,DELETEPDT);
		}
		else if(m_flag==SHOW_MEMBER)
		{
			g_isMlocked=true;
			::SendMessage(GetParent()->m_hWnd,WM_SHOW_MEM_RESULT_DETAIL,index,DELETEMEM);
		}
	}
	
	*pResult = 0;
}

void CResultSimple::OnDelete() 
{
	// TODO: Add your control notification handler code here
	int index =m_List_Result_Simp.GetSelectionMark();
	CString ItemName=m_List_Result_Simp.GetItemText(index,0);
	if(index>=0)
	{
		CString strMsg;
		strMsg="确实要删除纪录'";
		strMsg+=ItemName;
		strMsg+="'吗?";

		if(IDYES!=AfxMessageBox(strMsg,MB_YESNO))
			return;

		int SetIndex=m_List_Result_Simp.GetItemData(index);
		m_List_Result_Simp.DeleteItem(index);
		
		if(m_flag==SHOW_PRODUCT)
		{
			g_isPLocked=true;
			::SendMessage(GetParent()->m_hWnd,WM_DELETESET,SetIndex,DELETEPDT);
		}
		else if(m_flag==SHOW_MEMBER)
		{
			g_isMlocked=true;
			::SendMessage(GetParent()->m_hWnd,WM_DELETESET,SetIndex,DELETEMEM);
		}
	}
	else
		AfxMessageBox("请选择需要删除地记录.");

}


void CResultSimple::OnInsert() 
{
	// TODO: Add your control notification handler code here
	if(m_flag==SHOW_MEMBER)
	{
		::SendMessage(GetParent()->m_hWnd,WM_RECORD_ADD,0,MEM_SIMPLE);
	}
	else if(m_flag==SHOW_PRODUCT)
	{
		::SendMessage(GetParent()->m_hWnd,WM_RECORD_ADD,0,PDT_SIMPLE);
	}
}

void CResultSimple::OnModify() 
{
	// TODO: Add your control notification handler code here
	int index =m_List_Result_Simp.GetSelectionMark();
	int SetIndex;

	if(index>=0)
	{
		if(m_flag==SHOW_MEMBER)
		{
			SetIndex=m_List_Result_Simp.GetItemData(index);
			::SendMessage(GetParent()->m_hWnd,WM_MODIFYSET,SetIndex,MODIFYMEM);
		}
		else if(m_flag==SHOW_PRODUCT)
		{
			SetIndex=m_List_Result_Simp.GetItemData(index);
			::SendMessage(GetParent()->m_hWnd,WM_MODIFYSET,SetIndex,MODIFYPDT);
		}
	}
	else
		AfxMessageBox("请选择需要修改地记录.");
}

void CResultSimple::OnClickResultSimple(NMHDR* pNMHDR, LRESULT* pResult) 
{
	// TODO: Add your control notification handler code here
	*pResult = 0;
}



void CResultSimple::OnLButtonUp(UINT nFlags, CPoint point) 
{
	// TODO: Add your message handler code here and/or call default
	CDialog::OnLButtonUp(nFlags, point);
}