lookrecord.cpp

实现电脑销售系统实现电脑销售管理系统分多个部门

// LookRecord.cpp : 实现文件
//

#include "stdafx.h"
#include "ComSales.h"
#include "LookRecord.h"


// CLookRecord 对话框

IMPLEMENT_DYNAMIC(CLookRecord, CDialog)

CLookRecord::CLookRecord(CWnd* pParent /*=NULL*/)
	: CDialog(CLookRecord::IDD, pParent)
{

}

CLookRecord::~CLookRecord()
{
}

void CLookRecord::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Control(pDX, IDC_LIST, m_scList);
}

void CLookRecord::InitList()
{
	DWORD style = m_scList.GetExtendedStyle();
	m_scList.SetExtendedStyle(style| LVS_EX_GRIDLINES);
	m_scList.InsertColumn(0 , _T("销售编号") , LVCFMT_LEFT , 100);
	m_scList.InsertColumn(1 , _T("电脑编号") , LVCFMT_LEFT , 100);
	m_scList.InsertColumn(2 , _T("电脑名称") , LVCFMT_LEFT , 100);
	m_scList.InsertColumn(3 , _T("销售时间") , LVCFMT_LEFT , 100);
	m_scList.InsertColumn(4 , _T("销售价格") , LVCFMT_LEFT , 100);
	m_scList.InsertColumn(5 , _T("销售数量") , LVCFMT_LEFT , 100);



}

BEGIN_MESSAGE_MAP(CLookRecord, CDialog)
	ON_BN_CLICKED(IDC_DEL, &CLookRecord::OnBnClickedDel)
END_MESSAGE_MAP()


// CLookRecord 消息处理程序

BOOL CLookRecord::OnInitDialog()
{
	CDialog::OnInitDialog();

	// TODO:  在此添加额外的初始化
	InitList();
	LoadData();
	return TRUE;  // return TRUE unless you set the focus to a control
	// 异常: OCX 属性页应返回 FALSE
}

void CLookRecord::LoadData()
{
	m_scList.DeleteAllItems();
	CString str;
	// 	str.Format(" insert into sales (computerID  ,salesDATE  ,perPrice , num) \
	// 			   values ('%s' , '%s' ,'%s' ,'%s' ) "  , m_strComId ,m_strTime  ,m_strPrice , m_strNum);
	str.Format("select salesID , sales.computerID as id ,salesDATE , num, perPrice, computer.name from sales , computer where sales.computerID = computer.computerID" );
	CComSalesApp* app =(CComSalesApp*) AfxGetApp();
	// 	app->m_pConnection.Execute(str , NULL , adCmdText);
	_RecordsetPtr	m_pRecordset;
	m_pRecordset.CreateInstance("ADODB.Recordset");		
	m_pRecordset->Open((_variant_t)str,
		_variant_t((IDispatch *)app->m_pConnection,true),
		adOpenStatic,
		adLockOptimistic,
		adCmdText);			

	_variant_t vtemp;
	int nItem = 0;
	while(!m_pRecordset->adoEOF)
	{		
		m_scList.InsertItem(nItem,"");
		
		//vtemp=m_pRecordset->GetCollect("sales.salesID");
		vtemp=m_pRecordset->GetCollect("salesID");
		m_scList.SetItemText(nItem,0,(_bstr_t)vtemp);

		
		vtemp=m_pRecordset->GetCollect("id");
		m_scList.SetItemText(nItem,1,(_bstr_t)vtemp);

		vtemp=m_pRecordset->GetCollect("name");
		m_scList.SetItemText(nItem,2,(_bstr_t)vtemp);

		vtemp=m_pRecordset->GetCollect("salesDATE");
		m_scList.SetItemText(nItem,3,(_bstr_t)vtemp);

		vtemp=m_pRecordset->GetCollect("perPrice");
		m_scList.SetItemText(nItem,4,(_bstr_t)vtemp);

		vtemp=m_pRecordset->GetCollect("num");
		m_scList.SetItemText(nItem,5,(_bstr_t)vtemp);
		nItem++;

// 		vtemp=pRs->GetCollect("goodsNum");
// 		m_ListO.SetItemText(nItem,4,(_bstr_t)vtemp);

		m_pRecordset->MoveNext();
	}
}

void CLookRecord::DelRecord( int nRow )
{
	CString str;
	// 	str.Format(" insert into sales (computerID  ,salesDATE  ,perPrice , num) \
	// 			   values ('%s' , '%s' ,'%s' ,'%s' ) "  , m_strComId ,m_strTime  ,m_strPrice , m_strNum);
	int i = nRow;
	CString salesId  = m_scList.GetItemText(i,0);
	str.Format("select * from sales  where salesID = %s" , salesId );
	CComSalesApp* app =(CComSalesApp*) AfxGetApp();
	// 	app->m_pConnection.Execute(str , NULL , adCmdText);
	_RecordsetPtr	m_pRecordset;
	m_pRecordset.CreateInstance("ADODB.Recordset");		
	m_pRecordset->Open((_variant_t)str,
		_variant_t((IDispatch *)app->m_pConnection,true),
		adOpenStatic,
		adLockOptimistic,
		adCmdText);		
	
	m_pRecordset->Delete(adAffectCurrent);

}
void CLookRecord::OnBnClickedDel()
{
	int i = m_scList.GetSelectionMark();   
	if(i == -1)
		return;

	DelRecord(i);
	LoadData();
}