goodsimport_3.cpp

库存管理系统

// GoodsImport_3.cpp : implementation file
//

#include "stdafx.h"
#include "库存管理系统.h"
#include "GoodsImport_3.h"

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

/////////////////////////////////////////////////////////////////////////////
// CGoodsImport_3 dialog


CGoodsImport_3::CGoodsImport_3(CWnd* pParent /*=NULL*/)
	: CDialog(CGoodsImport_3::IDD, pParent)
{
	//{{AFX_DATA_INIT(CGoodsImport_3)
	m_edit2 = _T("");
	m_edit1 = _T("");
	//}}AFX_DATA_INIT
}


void CGoodsImport_3::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CGoodsImport_3)
	DDX_Control(pDX, IDC_BUTTON1, m_cen);
	DDX_Control(pDX, IDC_EDIT2, m_cedit2);
	DDX_Control(pDX, IDC_ADODC1, m_adodc1);
	DDX_Control(pDX, IDC_ADODC2, m_adodc2);
	DDX_Control(pDX, IDC_DATAGRID1, m_datagrid1);
	DDX_Control(pDX, IDC_DATAGRID2, m_datagrid2);
	DDX_Text(pDX, IDC_EDIT2, m_edit2);
	DDX_Text(pDX, IDC_EDIT1, m_edit1);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CGoodsImport_3, CDialog)
	//{{AFX_MSG_MAP(CGoodsImport_3)
	ON_BN_CLICKED(IDOK, Onsave)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CGoodsImport_3 message handlers

void CGoodsImport_3::Onsave() 
{
	// TODO: Add your control notification handler code here
	
}

BEGIN_EVENTSINK_MAP(CGoodsImport_3, CDialog)
    //{{AFX_EVENTSINK_MAP(CGoodsImport_3)
	ON_EVENT(CGoodsImport_3, IDC_DATAGRID1, -600 /* Click */, OnClickDatagrid1, VTS_NONE)
	ON_EVENT(CGoodsImport_3, IDC_DATAGRID2, -600 /* Click */, OnClickDatagrid2, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CGoodsImport_3::OnClickDatagrid1() 
{
	// TODO: Add your control notification handler code here
		CString dh;
	dh=m_datagrid1.GetItem(0);
	m_adodc2.SetRecordSource("select * from 进单明细临时 where 进单号='"+dh+"' and 实到货量 is null");
    m_adodc2.Refresh();
}

void CGoodsImport_3::OnClickDatagrid2() 
{
	// TODO: Add your control notification handler code here
	CString s="";
	m_edit1=m_datagrid2.GetItem(7);
    m_edit2=s;
	UpdateData(FALSE);

}

void CGoodsImport_3::OnButton1() 
{
	// TODO: Add your control notification handler code here
		_ConnectionPtr _Conn;
	_Conn = ((CMyApp *)AfxGetApp())->m_nConnection;
	try
	{
		 _CommandPtr _Comm;
	 _Comm.CreateInstance("ADODB.Command");
	 _Comm->ActiveConnection = _Conn;
	 CString la,l1,l2;
	l1=m_datagrid2.GetItem(0);
	l2=m_datagrid1.GetItem(1);
	 la="update 进单明细临时 set 实到货量 = '"+m_edit2+"' where 进单号 ='"+l1+"' and 货号 ='"+l2+"';";
	 _Comm->CommandText=_bstr_t(la);
	 _Comm->Execute(NULL,NULL,adCmdText);
	}
	catch(_com_error &e)
	{	::AfxMessageBox( e.Description());			
	}
	m_datagrid2.Refresh();
}