stockdlg1.cpp

来自「图书销售管理系统 1基本信息管理 主要是操作管理员信息管理」· C++ 代码 · 共 91 行

// StockDlg1.cpp : implementation file
//

#include "stdafx.h"
#include "BookManage.h"
#include "StockDlg1.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStockDlg1 dialog

extern _ConnectionPtr m_pCon;  
extern _RecordsetPtr m_pRs; 
extern _CommandPtr m_pCom;

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


void CStockDlg1::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStockDlg1)
	DDX_Control(pDX, IDC_STOCK_LIST, m_StockList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStockDlg1, CDialog)
	//{{AFX_MSG_MAP(CStockDlg1)
		// NOTE: the ClassWizard will add message map macros here
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

	DWORD dwStyle=GetWindowLong(m_StockList.GetSafeHwnd(),GWL_STYLE);
	dwStyle&=~LVS_TYPEMASK;
	dwStyle|=LVS_REPORT;
	SetWindowLong(m_StockList.GetSafeHwnd(),GWL_STYLE,dwStyle);

	m_StockList.InsertColumn(0,"序列号",LVCFMT_LEFT,80);
	m_StockList.InsertColumn(1,"进货时间",LVCFMT_LEFT,80);
	m_StockList.InsertColumn(2,"ISBN",LVCFMT_LEFT,100);
	m_StockList.InsertColumn(3,"书名",LVCFMT_LEFT,130);
	m_StockList.InsertColumn(4,"作者",LVCFMT_LEFT,90);
	m_StockList.InsertColumn(5,"出版社",LVCFMT_LEFT,130);
	m_StockList.InsertColumn(6,"分类",LVCFMT_LEFT,90);
	m_StockList.InsertColumn(7,"成本",LVCFMT_LEFT,80);
	m_StockList.InsertColumn(8,"进货量",LVCFMT_LEFT,80);

	m_StockList.SetExtendedStyle(LVS_EX_GRIDLINES);
    ::SendMessage(m_StockList.m_hWnd, LVM_SETEXTENDEDLISTVIEWSTYLE,
      LVS_EX_FULLROWSELECT, LVS_EX_FULLROWSELECT);

	ShowStock();
	return TRUE;
}

//显示进货记录...
void CStockDlg1::ShowStock()
{
	m_pRs->raw_Close();
	CString sql;
	sql.Format("select * from bm_BookStock");
	m_pRs->Open((_variant_t)sql,m_pCon.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
	int index = 0;
	m_StockList.DeleteAllItems();
	while (!m_pRs->adoEOF)
	{
		index = m_StockList.InsertItem(m_StockList.GetItemCount(),
			(TCHAR*)(_bstr_t)m_pRs->GetFields()->GetItem((long)0)->Value);
		for(int col = 1;col <9;col++)
			m_StockList.SetItemText(index,col,(TCHAR*)(_bstr_t)m_pRs->GetFields()->GetItem((long)col)->Value);
		m_pRs->MoveNext();
	}
}