editprice.cpp

去年暑假帮朋友企业写的仓库管理软件

// EditPrice.cpp : implementation file
//

#include "stdafx.h"
#include "Material_MIS.h"
#include "EditPrice.h"
#include "Material_MISView.h"

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

/////////////////////////////////////////////////////////////////////////////
// EditPrice dialog


EditPrice::EditPrice(CWnd* pParent /*=NULL*/)
	: CDialog(EditPrice::IDD, pParent)
{
	//{{AFX_DATA_INIT(EditPrice)
	m_mapid = _T("");
	m_price = _T("");
	m_productname = _T("");
	m_version = _T("");
	//}}AFX_DATA_INIT
}


void EditPrice::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(EditPrice)
	DDX_Text(pDX, IDC_MAPID, m_mapid);
	DDX_Text(pDX, IDC_PRICE, m_price);
	DDX_Text(pDX, IDC_PRODUCTNAME, m_productname);
	DDX_Text(pDX, IDC_VERSION, m_version);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// EditPrice message handlers

void EditPrice::OnOK() 
{
	UpdateData(TRUE);
	_variant_t strQuery;
	int count;

	strQuery = "select * from ProductPrice where MapID='"+m_mapid+"'and Version='"+m_version+"'";
	theApp.ADOExecute(theApp.m_pADOSet,strQuery);
	count = theApp.m_pADOSet->GetRecordCount();
	if(count == 0)
	{
		AfxMessageBox("不存在此产品！",MB_ICONEXCLAMATION);
		((CEdit*)GetDlgItem(IDC_USER_ADD))->SetWindowText("");
		((CEdit*)GetDlgItem(IDC_USER_ADD))->SetFocus();
		return;
	}
	strQuery = "Update ProductPrice set Price='"+m_price+"', CDate='"+COleDateTime::GetCurrentTime().Format("%Y-%m-%d")+"', Creater='"+theApp.m_sCurrentUser+"' where MapID='"+m_mapid+"' and Version='"+m_version+"'";
	if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
		AfxMessageBox(_T("修改记录成功！"), MB_ICONINFORMATION);
	else
	{
		AfxMessageBox(_T("修改记录失败！"),MB_ICONEXCLAMATION);
		return;
	}
	strQuery = "select * from ProductPrice";
	CMaterial_MISView* p = (CMaterial_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshPrice(strQuery);
	CDialog::OnOK();
}