order.cpp

公司物流电脑管理系统(非常有名).rar

// Order.cpp: implementation of the COrder class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Order.h"

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

COrder::COrder()
{
    Cls_ERR=false;
	try
	{
		pOrder.CreateInstance(__uuidof(Recordset));
        pOrder->Open("select * from u_Order",pDBCnn.GetInterfacePtr(),adOpenKeyset,adLockReadOnly,-1);
	}
	catch(...)
	{
		Cls_ERR=true;
	}

}

COrder::~COrder()
{
    pOrder->Close();
	pOrder.Release();
}

void COrder::GetOrder(long argOrderID)
{
    char strbuf[25];
    _bstr_t sqlstr;
/*
	sqlstr=_itoa(argOrderID,sqlstr,10);
	sqlstr="OrderID=" + sqlstr;
*/
	sprintf(strbuf,"OrderID = %d",argOrderID);
    sqlstr=strbuf;
	Cls_ERR=false;
	try
	{
		pOrder->MoveFirst();
		pOrder->Find(sqlstr,0,adSearchForward,pOrder->Bookmark);
		if (pOrder->EndOfFile)
		{
			OrderID=-1;
			Cls_ERR=true;
		}
		else
		{
			OrderID=argOrderID;
			MtrlID=pOrder->Fields->Item["MtrlID"]->Value;
			Qty=pOrder->Fields->Item["Qty"]->Value;
			RqDate=pOrder->Fields->Item["RqDate"]->Value;
		}
	}
	catch(...)
	{
		OrderID=-1;
		Cls_ERR=true;
	}
	return;
 
}