dlgreport.cpp

我们的一个课程设计 仓库管理系统 使用方便

#include "stdafx.h"
#include "DMS.h"
#include "DlgReport.h"
#include "DataBinding.h"

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



CDlgReport::CDlgReport(CWnd* pParent )
	: CDialog(CDlgReport::IDD, pParent)
{

}


void CDlgReport::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);

}


BEGIN_MESSAGE_MAP(CDlgReport, CDialog)

END_MESSAGE_MAP()



void CDlgReport::OnBtnPrint() 
{
	if (m_devs.GetCurSel()==CB_ERR)
	{
		MessageBox("请选择一个设备");
		return;
	}

	if (!UpdateData())
		return;

	_RecordsetPtr pRst = NULL;
	CDevBuyRs rs;

	try
	{
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst->Open("device_wantbuy",_variant_t((IDispatch *) m_DBCnt, true),adOpenKeyset,adLockOptimistic,adCmdTable);

		m_devs.GetWindowText(rs.m_sz_code,11);
		sprintf(rs.m_sz_date,"%d-%d-%d %d:%d:%d",
			m_date.GetYear(), m_date.GetMonth(), m_date.GetDay(),
			m_time.GetHour(), m_time.GetMinute(), m_time.GetSecond());
		sprintf(rs.m_sz_now, "%f",m_cur);
		sprintf(rs.m_sz_total, "%f",m_total);
		sprintf(rs.m_sz_max, "%f",m_max);
		sprintf(rs.m_sz_buy, "%f",m_buy);
		strcpy(rs.m_sz_provider, m_provider);
		sprintf(rs.m_sz_price, "%f",m_price);

		COleSafeArray vaFieldlist, vaValuelist;
		rs.FillFieldsArray(vaFieldlist,vaValuelist);
		TESTHR(pRst->AddNew(vaFieldlist, vaValuelist));
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		return;
    } 

	MessageBox("完成操作！");
	m_log->AddLog("添加还库信息");

	EndDialog(0);
}

BOOL CDlgReport::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_date = CTime::GetCurrentTime();
	m_time = m_date;

	_RecordsetPtr pRst = NULL;
	IADORecordBinding   *picRs = NULL;  
	CDevCodeRs rs;

	try
	{
		_bstr_t strSQL("SELECT * FROM DEVICE_CODE");

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));

		pRst = m_DBCnt->Execute(strSQL, NULL, adCmdText);
		
		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs));

		int i = 0;
		while (!pRst->adoEOF)
		{
			m_devs.AddString(rs.m_sz_code);
			pRst->MoveNext();
		}
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
		EndDialog(0);
		return TRUE;
    } 

	UpdateData(FALSE);
	
	return TRUE;  
}


void CDlgReport::OnCloseupComboRpdevs() 
{
	char buf[64];

	m_devs.GetWindowText(buf,64);
	if (strlen(buf)<=0)
		return;	

	_RecordsetPtr pRst = NULL;
	IADORecordBinding   *picRs = NULL;    
	CDevCodeRs rs1;
	CDevRs rs2;
	_bstr_t strSQL;

	try
	{
		CString sql;
		sql.Format("SELECT * FROM DEVICE_CODE WHERE code='%s'",buf);
		strSQL = sql;
		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));
		pRst = m_DBCnt->Execute(strSQL, NULL, adCmdText);

		TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
		TESTHR(picRs->BindToRecordset(&rs1));

		m_name.Format("%s",rs1.m_sz_name);

		picRs->Release();
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
    } 

	try
	{
		CString sql;
		sql.Format("SELECT * FROM DEVICE WHERE code='%s'",buf);
		strSQL = sql;

		TESTHR(pRst.CreateInstance(__uuidof(Recordset)));
		pRst->Open(strSQL, _variant_t((IDispatch *) m_DBCnt, true), adOpenKeyset, adLockOptimistic, adCmdText);
	
		if (pRst->GetRecordCount()!=1)
		{
			m_max = 0;
			m_cur = 0;
			m_total = 0;
		} else
		{
			TESTHR(pRst->QueryInterface(__uuidof(IADORecordBinding),(LPVOID*)&picRs));
			TESTHR(picRs->BindToRecordset(&rs2));
			
			m_max = rs2.m_f_max;
			m_cur = rs2.m_f_cur;
			m_total = rs2.m_f_total;
			picRs->Release();
		}
		pRst->Close();
	}
	catch(_com_error& e)
	{
        AfxMessageBox(e.ErrorMessage());
    } 

	UpdateData(FALSE);
}