addbasicinfo.cpp

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

// AddBasicInfo.cpp : implementation file
//

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

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

/////////////////////////////////////////////////////////////////////////////
// AddBasicInfo dialog


AddBasicInfo::AddBasicInfo(CWnd* pParent /*=NULL*/)
	: CDialog(AddBasicInfo::IDD, pParent)
{
	//{{AFX_DATA_INIT(AddBasicInfo)
	m_basicinfo_creater = theApp.m_sCurrentUser;
	m_basicinfo_mapid = _T("");
	m_basicinfo_materialid = _T("");
	m_basicinfo_productname = _T("");
	m_basicinfo_unit = _T("");
	m_basicinfo_version = _T("");
	m_basicinfo_safestocknum = _T("");
	//}}AFX_DATA_INIT
}


void AddBasicInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(AddBasicInfo)
	DDX_Text(pDX, IDC_BASICINFO_CREATER, m_basicinfo_creater);
	DDX_Text(pDX, IDC_BASICINFO_MAPID, m_basicinfo_mapid);
	DDX_Text(pDX, IDC_BASICINFO_MATERIALID, m_basicinfo_materialid);
	DDX_Text(pDX, IDC_BASICINFO_PRODUCTNAME, m_basicinfo_productname);
	DDX_Text(pDX, IDC_BASICINFO_UNIT, m_basicinfo_unit);
	DDX_Text(pDX, IDC_BASICINFO_VERSION, m_basicinfo_version);
	DDX_Text(pDX, IDC_BASICINFO_SAFESTOCKNUM, m_basicinfo_safestocknum);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// AddBasicInfo message handlers

BOOL AddBasicInfo::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	((CEdit*)GetDlgItem(IDC_BASICINFO_MATERIALID))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_PRODUCTNAME))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_MAPID))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_VERSION))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_UNIT))->SetLimitText(50);
	
	if (m_bAppend)
	{
		//更新对话框属性
		SetWindowText(_T("添加产品基本信息"));
	}
	else
	{
	    // 更新对话框属性
		SetWindowText(_T("修改产品基本信息"));
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void AddBasicInfo::OnOK() 
{
	// TODO: Add extra validation here
	CString m_basicinfo_cdate;
	m_basicinfo_cdate = COleDateTime::GetCurrentTime().Format("%Y-%m-%d");
	
	UpdateData(true);
	CString fstocknum =_T("0.0");
	m_basicinfo_mapid.TrimRight(" ");
	m_basicinfo_version.TrimRight(" ");
	m_basicinfo_productname.TrimRight(" ");
		
	// 确定所有输入有效
	CString sWarning="";
	if ( ""==m_basicinfo_mapid) sWarning=_T("图纸编号");
    else if ( ""==m_basicinfo_version ) sWarning=_T("版本号");
	else if ( ""==m_basicinfo_productname ) sWarning=_T("产品名称");
	    
	if ( ""!=sWarning ) 
	{
	   sWarning += _T("不能为空");
	   AfxMessageBox(sWarning, MB_ICONEXCLAMATION);
	   return;
	}	
	_variant_t strQuery;
	// 添加记录;
	if (m_bAppend)
	{
		// 判断产品唯一性
	    strQuery = "select * from ProductInfo where MapID='"+m_basicinfo_mapid+"' and Version='"+m_basicinfo_version+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    int iCount = theApp.m_pADOSet->GetRecordCount();
	    if ( 0!=iCount )
		{
	       AfxMessageBox(_T("已经存在此产品的记录！"), MB_ICONEXCLAMATION);
	       return;
		}
	}
	// 添加记录;			
	if (m_bAppend)
	{
			COleDateTime today = COleDateTime::GetCurrentTime();
			m_basicinfo_sn = today.Format("%y%m%d%H%M%S");	
			strQuery = "insert ProductInfo (MapID, Version, ProductName, MaterialID, SafeStockNum, Unit, CDate, Creater,SN) \
	         	    values ('"+m_basicinfo_mapid+"', '"+m_basicinfo_version+"','"+m_basicinfo_productname+"', '"+m_basicinfo_materialid+"','"+m_basicinfo_safestocknum+"', '"+m_basicinfo_unit+"', '"+m_basicinfo_cdate+"', '"+m_basicinfo_creater+"', '"+m_basicinfo_sn+"')\
					insert ProductPrice (MapID, Version, ProductName,SN) \
					values ('"+m_basicinfo_mapid+"', '"+m_basicinfo_version+"', '"+m_basicinfo_productname+"','"+m_basicinfo_sn+"')\
					insert ProductRemain (MapID, Version, ProductName,StockNum,SN) \
					values ('"+m_basicinfo_mapid+"', '"+m_basicinfo_version+"', '"+m_basicinfo_productname+"', '"+fstocknum+"','"+m_basicinfo_sn+"')";
		if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
		{
			AfxMessageBox(_T("添加记录成功！"), MB_ICONINFORMATION);
	        
		// 清空输入数据
            m_basicinfo_mapid=m_basicinfo_version=m_basicinfo_productname=m_basicinfo_materialid=m_basicinfo_unit=m_basicinfo_safestocknum="";
			UpdateData(false);
		}
	    else AfxMessageBox(_T("添加记录失败！"), MB_ICONEXCLAMATION);
	}
	else//修改记录
	{
		strQuery = "Update ProductInfo set MapID='"+m_basicinfo_mapid+"', Version='"+m_basicinfo_version+"', ProductName='"+m_basicinfo_productname+"', MaterialID='"+m_basicinfo_materialid+"', SafeStockNum='"+m_basicinfo_safestocknum+"', Unit='"+m_basicinfo_unit+"', CDate='"+m_basicinfo_cdate+"', Creater='"+m_basicinfo_creater+"'\
			        where SN='"+theApp.m_sn_sn+"'\
					Update productPrice set MapID='"+m_basicinfo_mapid+"', Version='"+m_basicinfo_version+"', ProductName='"+m_basicinfo_productname+"' where SN='"+theApp.m_sn_sn+"'\
					Update productRemain set MapID='"+m_basicinfo_mapid+"',  Version='"+m_basicinfo_version+"', ProductName='"+m_basicinfo_productname+"' where SN='"+theApp.m_sn_sn+"'";
	    if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
			AfxMessageBox(_T("修改记录成功！"), MB_ICONINFORMATION);
	    else 
			AfxMessageBox(_T("修改记录失败！"), MB_ICONEXCLAMATION);
	}
	
	// Refresh RoomType List
	CMaterial_MISView* p = (CMaterial_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView());
	p->RefreshMaterial();
	
	if (!m_bAppend) 
	CDialog::OnOK();
}