//?AddNewMerchandiseDlg.cpp?:?implementation?file
//

#include?“stdafx.h“
#include?“SuperMarket.h“
#include?“AddNewMerchandiseDlg.h“
#include?“afxdb.h“

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

/////////////////////////////////////////////////////////////////////////////
//?CAddNewMerchandiseDlg?dialog


CAddNewMerchandiseDlg::CAddNewMerchandiseDlg（CWnd*?pParent?/*=NULL*/）
	:?CDialog（CAddNewMerchandiseDlg::IDD?pParent）
{
	//{{AFX_DATA_INIT（CAddNewMerchandiseDlg）
	m_number?=?_T（““）;
	m_name?=?_T（““）;
	m_price?=?0.0f;
	m_count?=?1;
	m_producing_area?=?_T（““）;
	//}}AFX_DATA_INIT
}


void?CAddNewMerchandiseDlg::DoDataExchange（CDataExchange*?pDX）
{
	CDialog::DoDataExchange（pDX）;
	//{{AFX_DATA_MAP（CAddNewMerchandiseDlg）
	DDX_Text（pDX?IDC_EDIT1?m_number）;
	DDX_Text（pDX?IDC_EDIT2?m_name）;
	DDX_Text（pDX?IDC_EDIT3?m_price）;
	DDX_Text（pDX?IDC_EDIT4?m_count）;
	DDX_Text（pDX?IDC_EDIT5?m_producing_area）;
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP（CAddNewMerchandiseDlg?CDialog）
	//{{AFX_MSG_MAP（CAddNewMerchandiseDlg）
	//}}AFX_MSG_MAP
END_MESSAGE_MAP（）

/////////////////////////////////////////////////////////////////////////////
//?CAddNewMerchandiseDlg?message?handlers

void?CAddNewMerchandiseDlg::OnOK（）??//商品入庫(kù)操作
{
	//?TODO:?Add?extra?validation?here
	
????//?CDialog::OnOK（）;
	CString?str0str1str2;
	int?count;
????CString?strSQL;
	CDatabase?dbTemp;

	UpdateData（）;
	dbTemp.OpenEx（“Driver={Microsoft?Access?Driver?（*.mdb）};DBQ=超市管理數(shù)據(jù)庫(kù).mdb;“）;
	CRecordset??rs（?&dbTemp）;
	rs.Open（AFX_DB_USE_DEFAULT_TYPE“select?*?From?商品信息?where?商品編號(hào)=‘“+m_number+“‘“）;

	if（!rs.IsEOF（））??//如果是舊產(chǎn)品，更新庫(kù)存?
	{
		rs.GetFieldValue（（short）4str2）;?//更新庫(kù)存量
		count=atoi（str2）;?????
	????count=count+m_count;
	????str2.Format（“%d“count）;
		strSQL=“update?商品信息?set?庫(kù)存量=‘“+str2+“‘?where?商品編號(hào)=‘“+m_number+“‘“;?
	????dbTemp.ExecuteSQL（strSQL）;		
	}
????else????//如果是新產(chǎn)品，添加商品信息??
	{
		str0.Format（“%d“m_count）;
		str1.Format（“%f“m_price）;				
		strSQL=“insert?into?商品信息?values（‘“+m_number+“‘‘“+m_name+“‘‘“+str1+“‘‘“+m_producing_area+“‘‘“+str0+“‘）“;??
	????dbTemp.ExecuteSQL（strSQL）;
	}

	MessageBox（“錄入成功!“）;?//初始化窗口
	m_number?=?_T（““）;
	m_name?=?_T（““）;
	m_price?=?0.0f;
	m_count?=?1;
	m_producing_area?=?_T（““）;
	UpdateData（false）;
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????2452??2007-06-15?11:52??SuperMarket\AddNewMerchandiseDlg.cpp

?????文件???????1378??2007-06-15?10:04??SuperMarket\AddNewMerchandiseDlg.h

?????文件???????3132??2007-07-07?12:49??SuperMarket\AddPersonDlg.cpp

?????文件???????1323??2007-06-17?13:03??SuperMarket\AddPersonDlg.h

?????文件???????2758??2007-06-15?20:41??SuperMarket\BackMerchandiseDlg.cpp

?????文件???????1381??2007-06-15?20:42??SuperMarket\BackMerchandiseDlg.h

?????文件???????1790??2007-06-16?22:58??SuperMarket\ChildFrm.cpp

?????文件???????1440??2007-06-16?22:58??SuperMarket\ChildFrm.h

?????文件??????72710??2004-12-06?23:14??SuperMarket\corona.smf

?????文件??????48621??2017-01-08?15:08??SuperMarket\Debug\AddNewMerchandiseDlg.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\AddNewMerchandiseDlg.sbr

?????文件??????55480??2017-01-08?15:08??SuperMarket\Debug\AddPersonDlg.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\AddPersonDlg.sbr

?????文件??????49012??2017-01-08?15:08??SuperMarket\Debug\BackMerchandiseDlg.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\BackMerchandiseDlg.sbr

?????文件???????2996??2017-01-08?15:08??SuperMarket\Debug\BscMake.command.1.tlog

?????文件???????4124??2017-01-08?15:08??SuperMarket\Debug\bscmake.read.1.tlog

?????文件???????2064??2017-01-08?15:08??SuperMarket\Debug\bscmake.write.1.tlog

?????文件??????26000??2017-01-08?15:08??SuperMarket\Debug\ChildFrm.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\ChildFrm.sbr

?????文件??????15918??2017-01-08?15:08??SuperMarket\Debug\cl.command.1.tlog

?????文件??????54442??2017-01-08?15:08??SuperMarket\Debug\CL.read.1.tlog

?????文件???????9302??2017-01-08?15:08??SuperMarket\Debug\CL.write.1.tlog

?????文件??????40402??2017-01-08?15:08??SuperMarket\Debug\DeleteDlg.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\DeleteDlg.sbr

?????文件??????48136??2017-01-08?15:08??SuperMarket\Debug\EnrolDlg.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\EnrolDlg.sbr

?????文件??????48968??2017-01-08?15:08??SuperMarket\Debug\EnterDlg.obj

?????文件??????????0??2017-01-08?15:08??SuperMarket\Debug\EnterDlg.sbr

?????文件??????70772??2017-01-08?15:08??SuperMarket\Debug\FinaceDlg.obj

............此處省略120個(gè)文件信息