daystorage.cpp

小型自选商场商品管理系统 要求：能对小型自选商场的商品进货、销售、库存等环节进行管理。主要有： 1）能记录每一笔进货

// DayStorage.cpp : implementation file
//

#include "stdafx.h"
#include "ShopManage.h"
#include "DayStorage.h"

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

extern _RecordsetPtr Record1;
extern	_ConnectionPtr DataConn;
extern	_RecordsetPtr DataRecord;
extern	_CommandPtr Com;
/////////////////////////////////////////////////////////////////////////////
// DayStorage dialog


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


void DayStorage::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(DayStorage)
	DDX_Control(pDX, IDC_DSList, m_DSList);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(DayStorage, CDialog)
	//{{AFX_MSG_MAP(DayStorage)
	ON_BN_CLICKED(IDC_DSupdate, OnDSupdate)
	ON_BN_CLICKED(IDC_Delete, OnDelete)
	ON_BN_CLICKED(IDC_Quit, OnQuit)
	ON_WM_CLOSE()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// DayStorage message handlers

void DayStorage::OnOK() 
{
	// TODO: Add extra validation here
	
	//CDialog::OnOK();
}

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

	m_DSList.ModifyStyle(LVS_EDITLABELS,0);
	m_DSList.ModifyStyle(0,LVS_REPORT);
	m_DSList.ModifyStyle(0,LVS_SHOWSELALWAYS);
	m_DSList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_HEADERDRAGDROP|LVS_EX_GRIDLINES|LVS_EX_ONECLICKACTIVATE|LVS_EX_FLATSB);
	
	m_DSList.InsertColumn(0,"商品ID");
	m_DSList.InsertColumn(1,"单价");
	m_DSList.InsertColumn(2,"数量");
	m_DSList.InsertColumn(3,"金额");
	m_DSList.InsertColumn(4,"日期");
	//设置列宽度
	m_DSList.SetColumnWidth(0,80);
	m_DSList.SetColumnWidth(1,80);
	m_DSList.SetColumnWidth(2,95);	
	m_DSList.SetColumnWidth(3,100);
	m_DSList.SetColumnWidth(4,100);

	return TRUE;
}

void DayStorage::LoadData()
{
	//
}

void DayStorage::OnDSupdate() 
{
	// TODO: Add your control notification handler code here
	CString sql,info[6];
	sql.Format("select * from DayStorage");
	/*********************************************/
	Record1->raw_Close();
	Record1->Open((_variant_t)sql,DataConn.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
	if(Record1->RecordCount > 0)
	{
		int row = 0;
		m_DSList.DeleteAllItems();
		while (!Record1->adoEOF)
		{
			m_DSList.InsertItem(100,"");
			for (int col = 0;col <5;col++)
			{
				m_DSList.SetItemText(row,col,(TCHAR*)(_bstr_t)Record1->GetFields()->GetItem((long)col)->Value);
			}
			row += 1;	
			Record1->MoveNext();
		}
		Row = row;
	}
	else
		Row = 0;
}

void DayStorage::OnDelete() 
{
	// TODO: Add your control notification handler code here
	CString sql;
	sql.Format("delete from DayStorage");
	try
	{
		Record1->raw_Close();
		Record1->Open((_variant_t)sql,DataConn.GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
		this->MessageBox("操作成功","提示");
	}
	catch(_com_error& e)
	{
		MessageBox(e.ErrorMessage(),"提示");
	}
	int row = Row;
	for(row=0;row<Row;row++)
		for(int col=0;col<5;col++)
		{
			m_DSList.SetItemText(row,col,"");
		}
}

void DayStorage::OnQuit() 
{
	// TODO: Add your control notification handler code here
	EndDialog(0);
}

void DayStorage::OnClose() 
{
	// TODO: Add your message handler code here and/or call default
	
	//CDialog::OnClose();
}