add_good.cpp

库存管理系统

// ADD_GOOD.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// ADD_GOOD dialog


ADD_GOOD::ADD_GOOD(CWnd* pParent /*=NULL*/)
	: CDialog(ADD_GOOD::IDD, pParent)
{
	//{{AFX_DATA_INIT(ADD_GOOD)
	m_goodno = _T("");
	m_name = _T("");
	m_xinhao = _T("");
	m_guige = _T("");
	m_danwei = _T("");
	_Conn = ((CMyApp *)AfxGetApp())->m_nConnection;
	//}}AFX_DATA_INIT
}


void ADD_GOOD::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ADD_GOOD)
	DDX_Text(pDX, IDC_EDIT1, m_goodno);
	DDX_Text(pDX, IDC_EDIT2, m_name);
	DDX_Text(pDX, IDC_EDIT3, m_xinhao);
	DDX_Text(pDX, IDC_EDIT4, m_guige);
	DDX_Text(pDX, IDC_EDIT5, m_danwei);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(ADD_GOOD, CDialog)
	//{{AFX_MSG_MAP(ADD_GOOD)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// ADD_GOOD message handlers

void ADD_GOOD::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	if(m_goodno == _T("")||
	m_name == _T("")||
	m_xinhao == _T("")||
	m_guige == _T("")||
	m_danwei == _T(""))
	{MessageBox("请填满所有信息!");
	return;}
		try
	{
		_RecordsetPtr pRecord;
		pRecord.CreateInstance("ADODB.Recordset");
		CString sql;
		sql.Format("select * from 货物 where 货号 = '%s",m_goodno);
		sql+="'";
		 pRecord->Open(_variant_t(sql),_variant_t((IDispatch *)_Conn,true),
		 adOpenStatic,adLockPessimistic,adCmdText);
		 if(pRecord->GetRecordCount()!=0)
		 {MessageBox("已存在该客户号,请重新输入","warning");
		 m_goodno="";
		 UpdateData(FALSE);
		 return;
		 }
		 else 
			 if(MessageBox("确定保存?","wraning",MB_YESNO|MB_ICONQUESTION) == 6)
		 {
			 _CommandPtr _Comm;
			 _Comm.CreateInstance("ADODB.Command");
			 _Comm->ActiveConnection = _Conn;
			 CString la;
			 la="insert into 货物(货号,货名,型号,规格,计量单位) values ('"+m_goodno+"','"+m_name+"','"+m_xinhao+"','"+m_guige+"','"+m_danwei+"');";
			 _Comm->CommandText=_bstr_t(la);
			 _Comm->Execute(NULL,NULL,adCmdText);
			 
			MessageBox("保存成功");
			m_goodno = _T("");
			m_name = _T("");
			m_xinhao = _T("");
			m_guige = _T("");
			m_danwei = _T("");
			UpdateData(FALSE);
			return;
		 }
		 
	}
		catch(_com_error &e)
		{	::AfxMessageBox( e.Description());			
		}
}