selectproduct.cpp

企业库存管理系统, 企业库存管理系统

// SelectProduct.cpp : implementation file
//

#include "stdafx.h"
#include "Store.h"
#include "SelectProduct.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSelectProduct dialog


CSelectProduct::CSelectProduct(CWnd* pParent /*=NULL*/)
	: CDialog(CSelectProduct::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSelectProduct)
	m_num = 0;
	m_productID="";
	m_productName="";
	m_model="";
	m_unit="";
	m_price=0;
	//}}AFX_DATA_INIT
}


void CSelectProduct::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSelectProduct)
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Text(pDX, IDC_num, m_num);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSelectProduct, CDialog)
	//{{AFX_MSG_MAP(CSelectProduct)
	ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSelectProduct message handlers

BOOL CSelectProduct::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	DWORD style;
	style=m_list.GetExStyle();
	style=(style|LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT)&(~LVS_EX_CHECKBOXES) ;
	m_list.SetExtendedStyle(style);
	
	m_list.InsertColumn(0,"产品编码",LVCFMT_LEFT,100);
	m_list.InsertColumn(1,"产品名称",LVCFMT_LEFT,100);
	m_list.InsertColumn(2,"规格",LVCFMT_LEFT,100);
	m_list.InsertColumn(3,"型号",LVCFMT_LEFT,100);
	m_list.InsertColumn(4,"单价",LVCFMT_LEFT,100);
	m_list.InsertColumn(5,"保质期",LVCFMT_LEFT,100);
	m_list.InsertColumn(6,"维护期",LVCFMT_LEFT,100);
	m_list.InsertColumn(7,"计量单位",LVCFMT_LEFT,100);
	m_list.InsertColumn(8,"颜色类别",LVCFMT_LEFT,100);
	m_list.InsertColumn(9,"质量等级",LVCFMT_LEFT,100);
	m_list.InsertColumn(10,"成品率",LVCFMT_LEFT,100);
	m_list.InsertColumn(11,"存放仓库",LVCFMT_LEFT,100);
	m_list.InsertColumn(12,"税率",LVCFMT_LEFT,100);
	m_list.InsertColumn(13,"备注",LVCFMT_LEFT,100);
	


	_RecordsetPtr m_pListRecordset;    //用于创建一个查询记录集
	CString strSQL;
	//-----------------------------------------------
	strSQL="SELECT * FROM product";
		try
		{
			HRESULT hTRes;
			hTRes = m_pListRecordset.CreateInstance(_T("ADODB.Recordset"));
			if (SUCCEEDED(hTRes))
			{
				//----------------------------------------------------
				hTRes = m_pListRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
					((CStoreApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
					adOpenDynamic,adLockPessimistic,adCmdText);
				if(SUCCEEDED(hTRes))
				{
					TRACE(_T("连接成功!\n"));
					//------------------------------------------
					if (!(m_pListRecordset->adoEOF))
					{
						int i=0;
						while(!m_pListRecordset->adoEOF)
						{
							//_variant_t vIndex=(long)0;
							m_list.InsertItem(i,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("productID")));
							m_list.SetItemText(i,1,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("productName")));				
							m_list.SetItemText(i,2,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("standard")));
							m_list.SetItemText(i,3,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("model")));
							m_list.SetItemText(i,4,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("price")));
							m_list.SetItemText(i,5,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("qualityGuarantee")));
							m_list.SetItemText(i,6,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("maintance")));
							m_list.SetItemText(i,7,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("unit")));
							m_list.SetItemText(i,8,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("colorType")));							
							m_list.SetItemText(i,9,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("qualityLevel")));
							m_list.SetItemText(i,10,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("finishRate")));
							m_list.SetItemText(i,11,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("storeHouse")));
							m_list.SetItemText(i,12,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("taxRate")));							
							m_list.SetItemText(i,13,((CStoreApp*)AfxGetApp())->GetStringFromVariant(m_pListRecordset->GetCollect("remark")));
							if (!(m_pListRecordset->adoEOF))
							{
								
								m_pListRecordset->MoveNext();
								i++;
							}
						}		
					}
					//---------------------------------------
				}
			}
		}
		catch(_com_error e)///捕捉异常
		{
			CString errormessage;
			MessageBox("创建记录集失败!","错误");
		}

	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CSelectProduct::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
{
	UpdateData(true);
	POSITION pos = m_list.GetFirstSelectedItemPosition();
	if(pos)
	{
		int nFirstSelItem = m_list.GetNextSelectedItem(pos);
		m_productID=m_list.GetItemText(nFirstSelItem,0);
		m_productName=m_list.GetItemText(nFirstSelItem,1);
		m_unit=m_list.GetItemText(nFirstSelItem,7);
		m_model=m_list.GetItemText(nFirstSelItem,3);
		m_price=atof(m_list.GetItemText(nFirstSelItem,4));
	}
	*pResult = 0;
}