buyinfor.cpp

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

// BuyInfor.cpp : implementation file
//

#include "stdafx.h"
#include "resource.h"
#include "BuyInfor.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBuyInfor dialog


CBuyInfor::CBuyInfor(CWnd* pParent /*=NULL*/)
	: CDialog(CBuyInfor::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBuyInfor)
	m_BiEdit = _T("");
	m_BiCom = 0;
	//}}AFX_DATA_INIT
}


void CBuyInfor::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBuyInfor)
	DDX_Control(pDX, IDC_BILIST, m_BiList);
	DDX_Text(pDX, IDC_BIEDIT, m_BiEdit);
	DDX_CBIndex(pDX, IDC_BICOM, m_BiCom);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBuyInfor, CDialog)
	//{{AFX_MSG_MAP(CBuyInfor)
	ON_CBN_DROPDOWN(IDC_BICOM, OnDropdownBicom)
	ON_BN_CLICKED(IDC_BIBT, OnBibt)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

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

	m_BiList.InsertColumn(0,_T("时间"),LVCFMT_CENTER,150);
	m_BiList.InsertColumn(1,_T("ISBN"),LVCFMT_CENTER,120);
	m_BiList.InsertColumn(2,_T("书名"),LVCFMT_CENTER,140);
	m_BiList.InsertColumn(3,_T("数量"),LVCFMT_CENTER,60);
	m_BiList.InsertColumn(4,_T("进价"),LVCFMT_CENTER,80);
	m_BiList.InsertColumn(5,_T("定价"),LVCFMT_CENTER,80);
	m_BiList.InsertColumn(6,_T("员工号"),LVCFMT_CENTER,80);
	
	OnRefreshData();
	return TRUE;
}

void CBuyInfor::OnRefreshData()
{
	m_BiList.DeleteAllItems();
	_variant_t vt;
	try
	{
		SHOP::_RecordsetPtr pRst = pConn->Execute("select * from BUY",&vt,SHOP::adCmdText);
		while(!pRst->End)
		{
			_variant_t vSELLDATE = pRst->Fields->GetItem("BAT")->Value;
			_variant_t vISBN = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vNUM = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vBUYPRICE = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vEMPID = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vPRICE = pRst->Fields->GetItem(long(5))->Value;
			_variant_t vNAME = pRst->Fields->GetItem(long(6))->Value;
			
			CString buydate = (char *)_bstr_t(vSELLDATE);
			CString isbn = vISBN.bstrVal;
			int		num  = vNUM.iVal;
			int		buyprice = vBUYPRICE.iVal;
			CString empid= vEMPID.bstrVal;
			int		price= vPRICE.iVal;
			CString name = vNAME.bstrVal;

			CString strnum,strbuyprice,strprice;
			strnum.Format("%d",num);
			strbuyprice.Format("%d",buyprice);
			strprice.Format("%d",price);

			strbuyprice.Insert(strbuyprice.GetLength()-2,".");
			strprice.Insert(strprice.GetLength()-2,".");

			m_BiList.InsertItem(0,buydate);
			m_BiList.SetItemText(0,1,isbn);
			m_BiList.SetItemText(0,2,name);
			m_BiList.SetItemText(0,3,strnum);
			m_BiList.SetItemText(0,4,strbuyprice);
			m_BiList.SetItemText(0,5,strprice);
			m_BiList.SetItemText(0,6,empid);
			
			pRst->MoveNext();
		}
		pRst->Close();
		pRst.Release();
	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.Description());
	}
}

void CBuyInfor::OnDropdownBicom() 
{
	m_BiEdit.Empty();
	this->UpdateData(false);
}

void CBuyInfor::OnBibt() 
{
	m_BiList.DeleteAllItems();
	SHOP::_RecordsetPtr pRst;
	this->UpdateData(true);

	SHOP::_CommandPtr cmd(__uuidof(SHOP::Command));
	CString com;
	_bstr_t condition;
	condition = m_BiEdit;
	
	try
	{
		if(m_BiCom == 0)
		{
			cmd->CommandText = "select * from BUY where ISBN = ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("ISBN",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("ISBN")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}
		if(m_BiCom == 1)
		{
			cmd->CommandText = "select * from BUY where NAME = ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("NAME",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("NAME")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}
			
		while(!pRst->End)
		{
			_variant_t vSELLDATE = pRst->Fields->GetItem("BAT")->Value;
			_variant_t vISBN = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vNUM = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vBUYPRICE = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vEMPID = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vPRICE = pRst->Fields->GetItem(long(5))->Value;
			_variant_t vNAME = pRst->Fields->GetItem(long(6))->Value;
			
			CString buydate = " ";
			CString isbn = vISBN.bstrVal;
			int		num  = vNUM.iVal;
			int		buyprice = vBUYPRICE.iVal;
			CString empid= vEMPID.bstrVal;
			int		price= vPRICE.iVal;
			CString name = vNAME.bstrVal;

			CString strnum,strbuyprice,strprice;
			strnum.Format("%d",num);
			strbuyprice.Format("%d",buyprice);
			strprice.Format("%d",price);

			strbuyprice.Insert(strbuyprice.GetLength()-2,".");
			strprice.Insert(strprice.GetLength()-2,".");

			m_BiList.InsertItem(0,buydate);
			m_BiList.SetItemText(0,1,isbn);
			m_BiList.SetItemText(0,2,name);
			m_BiList.SetItemText(0,3,strnum);
			m_BiList.SetItemText(0,4,strbuyprice);
			m_BiList.SetItemText(0,5,strprice);
			m_BiList.SetItemText(0,6,empid);
			
			pRst->MoveNext();
		}

		pRst->Close();
		pRst.Release();

	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.Description());
	}		
}