ordertj.cpp

订单管理系统

// ordertj.cpp : implementation file
//

#include "stdafx.h"
#include "ordermanagement.h"
#include "ordertj.h"
#include "ADOConn.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// ordertj dialog


ordertj::ordertj(CWnd* pParent /*=NULL*/)
	: CDialog(ordertj::IDD, pParent)
{
	//{{AFX_DATA_INIT(ordertj)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void ordertj::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ordertj)
	DDX_Control(pDX, IDC_LIST1, m_listCtr);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(ordertj, CDialog)
	//{{AFX_MSG_MAP(ordertj)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// ordertj message handlers

BOOL ordertj::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
//初始化图标
	m_imagelist.Create(16, 16,ILC_MASK,1,4);
	HICON hIcon=AfxGetApp()->LoadIcon(IDI_ICON6);
	m_imagelist.Add(hIcon);

	//初始化列表框表头
	m_listCtr.SetImageList(&m_imagelist,LVSIL_SMALL);
	m_listCtr.InsertColumn(1,  "产 品 ID",  LVCFMT_LEFT,100);
	m_listCtr.InsertColumn(2,  "产品名称",  LVCFMT_LEFT,80);
	m_listCtr.InsertColumn(3,  "订单数量",  LVCFMT_LEFT,80);
	m_listCtr.InsertColumn(4,  "销售总量", LVCFMT_LEFT,80);
//-- 设置单列全选,显示网格 -- //
	m_listCtr.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	

	ADOConn conn;
	_RecordsetPtr  m_pRecordset;
	_bstr_t vSQL;

	_bstr_t vSQL2;
	int nItem;
	CString sKey;
	CString mm;
	m_listCtr.DeleteAllItems();
	int ii;
CString   strData; 
			vSQL= "select * from ProductMessage ";
			m_pRecordset = conn.GetRecordSet(vSQL);
		
		while(!m_pRecordset->adoEOF)
		{
			
			conn.vOID = m_pRecordset->GetCollect("productID");
			conn.vCID = m_pRecordset->GetCollect("productName");
			conn.vPN = m_pRecordset->GetCollect("pdnum");
			conn.vOPNUM = m_pRecordset->GetCollect("odernum");	







   
    
    

			// -- 添加数据到列表控件中 -- //
			nItem = m_listCtr.InsertItem(0xffff,(_bstr_t)conn.vOID,0);//;
			m_listCtr.SetItemText(nItem,1,(_bstr_t)conn.vCID);	

			m_listCtr.SetItemText(nItem,3,(_bstr_t)conn.vPN);
			m_listCtr.SetItemText(nItem,2,(_bstr_t)conn.vOPNUM);
			m_pRecordset->MoveNext();
		}
//		m_pRecordset->Close();
		conn.ExitConnect();
return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}