sellinfor.cpp

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

// SellInfor.cpp : implementation file
//

#include "stdafx.h"
#include "resource.h"
#include "SellInfor.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSellInfor dialog
CSellInfor::CSellInfor(CWnd* pParent /*=NULL*/)
	: CDialog(CSellInfor::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSellInfor)
	m_SiEdit = _T("");
	m_SiCom = 0;
	//}}AFX_DATA_INIT
}


void CSellInfor::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSellInfor)
	DDX_Control(pDX, IDC_SILIST, m_SiList);
	DDX_Text(pDX, IDC_SIEDIT, m_SiEdit);
	DDX_CBIndex(pDX, IDC_SICOM, m_SiCom);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSellInfor, CDialog)
	//{{AFX_MSG_MAP(CSellInfor)
	ON_BN_CLICKED(IDC_SIBT, OnSibt)
	ON_CBN_DROPDOWN(IDC_SICOM, OnDropdownSicom)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

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

	m_SiList.InsertColumn(0,_T("时间"),LVCFMT_CENTER,150);
	m_SiList.InsertColumn(1,_T("ISBN"),LVCFMT_CENTER,120);
	m_SiList.InsertColumn(2,_T("书名"),LVCFMT_CENTER,140);
	m_SiList.InsertColumn(3,_T("作者"),LVCFMT_CENTER,100);
	m_SiList.InsertColumn(4,_T("类别"),LVCFMT_CENTER,80);
	m_SiList.InsertColumn(5,_T("数量"),LVCFMT_CENTER,70);
	m_SiList.InsertColumn(6,_T("售价"),LVCFMT_CENTER,80);
	m_SiList.InsertColumn(7,_T("折扣"),LVCFMT_CENTER,70);
	m_SiList.InsertColumn(8,_T("员工号"),LVCFMT_CENTER,80);
	
	OnRefreshData();
	return TRUE;
}

void CSellInfor::OnRefreshData()
{
	m_SiList.DeleteAllItems();
	_variant_t vt;
	try
	{
		SHOP::_RecordsetPtr pRst = pConn->Execute("select * from SELL",&vt,SHOP::adCmdText);
		while(!pRst->End)
		{
			_variant_t vSELLDATE = pRst->Fields->GetItem("SELLTIME")->Value;
			_variant_t vISBN = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vNAME = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vNUM = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vPRICE = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vDIS = pRst->Fields->GetItem(long(5))->Value;
			_variant_t vEMPID = pRst->Fields->GetItem(long(6))->Value;
			_variant_t vAUTHOR = pRst->Fields->GetItem(long(7))->Value;
			_variant_t vCLASS = pRst->Fields->GetItem(long(8))->Value;
			
			CString selldate = (char *)_bstr_t(vSELLDATE);
			CString isbn = vISBN.bstrVal;
			CString name = vNAME.bstrVal;
			int		num  = vNUM.iVal;
			int		price= vPRICE.iVal;
			int		dis	 = vDIS.iVal;
			CString	empid= vEMPID.bstrVal;
			CString author=vAUTHOR.bstrVal;
			CString classs=vCLASS.bstrVal;

			CString strnum,strprice,strdis;
			strnum.Format("%d",num);
			strprice.Format("%d",price);
			strdis.Format("%d",dis);

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

			m_SiList.InsertItem(0,selldate);
			m_SiList.SetItemText(0,1,isbn);
			m_SiList.SetItemText(0,2,name);
			m_SiList.SetItemText(0,3,author);
			m_SiList.SetItemText(0,4,classs);
			m_SiList.SetItemText(0,5,strnum);
			m_SiList.SetItemText(0,6,strprice);
			m_SiList.SetItemText(0,7,strdis);
			m_SiList.SetItemText(0,8,empid);
			
			pRst->MoveNext();
		}
		pRst->Close();
		pRst.Release();
	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.Description());
	}
}

void CSellInfor::OnSibt() 
{
	m_SiList.DeleteAllItems();
	SHOP::_RecordsetPtr pRst;
	this->UpdateData(true);

	SHOP::_CommandPtr cmd(__uuidof(SHOP::Command));
	CString com;
	_bstr_t condition;
	condition = m_SiEdit;
	
	try
	{
		if(m_SiCom == 0)
		{
			cmd->CommandText = "select * from SELL 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_SiCom == 1)
		{
			cmd->CommandText = "select * from SELL where SELLNAME = ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("SELLNAME",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("SELLNAME")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}
		if(m_SiCom == 2)
		{
			cmd->CommandText = "select * from SELL where SELLAUTHOR = ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("SELLAUTHOR",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("SELLAUTHOR")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}
		if(m_SiCom == 3)
		{
			cmd->CommandText = "select * from SELL where CLASS = ?"; 
			cmd->CommandType = SHOP::adCmdText;
			cmd->ActiveConnection = pConn;
			SHOP::_ParameterPtr pParam = cmd->CreateParameter("CLASS",SHOP::adBSTR,SHOP::adParamInput,0); 
			cmd->Parameters->Append(pParam);
			cmd->Parameters->GetItem("CLASS")->Value = condition;
			pRst = cmd->Execute(0,0,SHOP::adCmdText);
		}
				
		while(!pRst->End)
		{
			_variant_t vSELLDATE = pRst->Fields->GetItem("SELLTIME")->Value;
			_variant_t vISBN = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vNAME = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vNUM = pRst->Fields->GetItem(long(3))->Value;
			_variant_t vPRICE = pRst->Fields->GetItem(long(4))->Value;
			_variant_t vDIS = pRst->Fields->GetItem(long(5))->Value;
			_variant_t vEMPID = pRst->Fields->GetItem(long(6))->Value;
			_variant_t vAUTHOR = pRst->Fields->GetItem(long(7))->Value;
			_variant_t vCLASS = pRst->Fields->GetItem(long(8))->Value;
			
			CString selldate = "";
			CString isbn = vISBN.bstrVal;
			CString name = vNAME.bstrVal;
			int		num  = vNUM.iVal;
			int		price= vPRICE.iVal;
			int		dis	 = vDIS.iVal;
			CString	empid= vEMPID.bstrVal;
			CString author=vAUTHOR.bstrVal;
			CString classs=vCLASS.bstrVal;

			CString strnum,strprice,strdis;
			strnum.Format("%d",num);
			strprice.Format("%d",price);
			strdis.Format("%d",dis);

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

			m_SiList.InsertItem(0,selldate);
			m_SiList.SetItemText(0,1,isbn);
			m_SiList.SetItemText(0,2,name);
			m_SiList.SetItemText(0,3,author);
			m_SiList.SetItemText(0,4,classs);
			m_SiList.SetItemText(0,5,strnum);
			m_SiList.SetItemText(0,6,strprice);
			m_SiList.SetItemText(0,7,strdis);
			m_SiList.SetItemText(0,8,empid);
			
			pRst->MoveNext();
		}

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

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

void CSellInfor::OnDropdownSicom() 
{
	m_SiEdit.Empty();
	this->UpdateData(false);
}