pageoilcan.cpp

本人工作中的一个软件开发实例。里面包含了数据库

// PageOilCan.cpp : implementation file
//

#include "stdafx.h"
#include "oil.h"
#include "PageOilCan.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPageOilCan property page

IMPLEMENT_DYNCREATE(CPageOilCan, CPropertyPage)

CPageOilCan::CPageOilCan() : CPropertyPage(CPageOilCan::IDD)
{
	//{{AFX_DATA_INIT(CPageOilCan)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}

CPageOilCan::~CPageOilCan()
{
}

void CPageOilCan::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CPageOilCan)
	DDX_Control(pDX, IDC_LIST_CANOIL, m_listCanOil);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CPageOilCan, CPropertyPage)
	//{{AFX_MSG_MAP(CPageOilCan)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CPageOilCan message handlers

BOOL CPageOilCan::OnInitDialog() 
{
	CPropertyPage::OnInitDialog();

	// TODO: Add extra initialization here
	CString  sql;
    
	//初始化油库下拉框
	//ReadtoComBoBox(GetDlgItem(IDC_COMBO_CAN),sql);

	//初始化油名下拉框
	//ReadtoComBoBox(GetDlgItem(IDC_COMBO_OILNAME),sql);

	//初始化发油列表
	//设置List Control背景色及字体颜色
	m_listCanOil.SetBkColor(RGB(240,247,233));;
	m_listCanOil.SetTextColor(RGB(250,0,0));

	//清空List控件的数据
    for(int delcolumn=100;delcolumn>=0;delcolumn--)
	    m_listCanOil.DeleteColumn(delcolumn);

	//设置List控件的列
    DWORD		dwStyle;
	RECT		rect;
	LV_COLUMN	lvc;
	dwStyle = m_listCanOil.GetStyle();
	dwStyle |= LVS_EX_GRIDLINES |LVS_EX_FULLROWSELECT|LVS_SHOWSELALWAYS ;

	m_listCanOil.SetExtendedStyle(dwStyle);
	m_listCanOil.GetClientRect(&rect);
	lvc.mask = LVCF_TEXT | LVCF_SUBITEM | LVCF_WIDTH |LVCF_FMT;
	lvc.fmt=LVCFMT_LEFT;

	lvc.iSubItem = 0;
	lvc.pszText = _T("油罐编号");
	lvc.cx = 110;
	m_listCanOil.InsertColumn(1,&lvc);

	lvc.iSubItem = 1;
	lvc.pszText = _T("油品名");
	lvc.cx = 120;
	m_listCanOil.InsertColumn(2,&lvc);

	//读数据到列表
	sql="SELECT * FROM oilcan_oilname";
	ReadtoListCtrl((CListCtrl *)GetDlgItem(IDC_LIST_CANOIL),sql);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}