changestoredlg.cpp

小型超市管理系统是方便超市管理员管理超市的一个小软件

// ChangeStoreDlg.cpp : implementation file
//

#include "stdafx.h"
#include "SuperMarket.h"
#include "ChangeStoreDlg.h"
#include "afxdb.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CChangeStoreDlg dialog


CChangeStoreDlg::CChangeStoreDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CChangeStoreDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CChangeStoreDlg)
	m_spaddress = _T("");
	m_spcount = 0;
	m_spname = _T("");
	m_spnumber = _T("");
	m_spprice = 0.0f;
	//}}AFX_DATA_INIT
}


void CChangeStoreDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CChangeStoreDlg)
	DDX_Text(pDX, IDC_SPADDRESS, m_spaddress);
	DDX_Text(pDX, IDC_SPCOUNT, m_spcount);
	DDX_Text(pDX, IDC_SPNAME, m_spname);
	DDX_Text(pDX, IDC_SPNUMBER, m_spnumber);
	DDX_Text(pDX, IDC_SPPRICE, m_spprice);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CChangeStoreDlg, CDialog)
	//{{AFX_MSG_MAP(CChangeStoreDlg)
	ON_BN_CLICKED(IDC_XIANSHI, OnXianshi)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CChangeStoreDlg message handlers

void CChangeStoreDlg::OnXianshi() 
{
	// TODO: Add your control notification handler code here


	UpdateData(); 
	CDatabase dbTemp;
	CString str0,str1,str2,str3,str4;

	
	dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理数据库.mdb;");
	CRecordset  rs( &dbTemp);
	rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 商品信息表 where 商品编号='"+m_spnumber+"'");

	if(rs.IsEOF())  
	{
		MessageBox("输入的商品编号不存在，请重新输入!"); 		
	}
    else    
	{
 	   
		rs.GetFieldValue((short)1,str1);
		rs.GetFieldValue((short)2,str2);
		rs.GetFieldValue((short)3,str3);
		rs.GetFieldValue((short)4,str4);
		m_spname=str1;
		m_spprice=atof(str2);
		m_spcount=atoi(str4);
		m_spaddress=str3;
       UpdateData(false);
	}
}

void CChangeStoreDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	
		UpdateData(); 
      CString strSQL;
       CDatabase dbTemp;
	   CString str0,str1,str2,str3,str4,str5;
       dbTemp.OpenEx("Driver={Microsoft Access Driver (*.mdb)};DBQ=超市管理数据库.mdb;");
	   CRecordset  rs( &dbTemp);
	   rs.Open(AFX_DB_USE_DEFAULT_TYPE,"select * From 商品信息表 where 商品编号='"+m_spnumber+"'");
     	rs.GetFieldValue((short)1,str1);
		rs.GetFieldValue((short)2,str2);
		rs.GetFieldValue((short)3,str3);
		rs.GetFieldValue((short)4,str4);
		
       
		if(m_spname==str1&&m_spprice==atof(str2)&&m_spcount==atoi(str4)&&m_spaddress==str3)
		{
				MessageBox("商品信息没修改!"); 
		}
		else
		{
		//更新库存量
        UpdateData(); 
        str0.Format("%d",m_spcount);
	    str5.Format("%f",m_spprice);
	    strSQL="update 商品信息表 set 商品名称='"+m_spname+"' where 商品编号='"+m_spnumber+"'"; 
	    strSQL="update 商品信息表 set 商品价格='"+str5+"' where 商品编号='"+m_spnumber+"'"; 
	    strSQL="update 商品信息表 set 产地='"+m_spaddress+"' where 商品编号='"+m_spnumber+"'"; 
		strSQL="update 商品信息表 set 库存量='"+str0+"' where 商品编号='"+m_spnumber+"'"; 
	    dbTemp.ExecuteSQL(strSQL);
	   MessageBox("商品信息修改成功!"); 
		}
}