addbasicinfo.cpp

利用vc开发的一个数据库管理信息系统

// 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_wzID = _T("");
	m_wzKind = _T("");
	m_wzName = _T("");
	m_wzSpec = _T("");
	m_wzUnit = _T("");
	//}}AFX_DATA_INIT
}


void AddBasicInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(AddBasicInfo)
	DDX_Text(pDX, IDC_BASICINFO_WZID, m_wzID);
	DDX_Text(pDX, IDC_BASICINFO_WZKIND, m_wzKind);
	DDX_Text(pDX, IDC_BASICINFO_WZNAME, m_wzName);
	DDX_Text(pDX, IDC_BASICINFO_WZSPEC, m_wzSpec);
	DDX_Text(pDX, IDC_BASICINFO_WZUNIT, m_wzUnit);
	//}}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_WZID))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_WZNAME))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_WZSPEC))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_WZKIND))->SetLimitText(50);
	((CEdit*)GetDlgItem(IDC_BASICINFO_WZUNIT))->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
	UpdateData(true);
	
	m_wzID.TrimRight(" ");
    m_wzName.TrimRight(" ");
	m_wzKind.TrimRight(" ");
	m_wzSpec.TrimRight(" ");
	m_wzUnit.TrimRight(" ");
	
	
	// 确定所有输入有效
	CString sWarning="";
	if ( ""==m_wzID ) sWarning=_T("物资编号");
    else if ( ""==m_wzName ) sWarning=_T("物资名称");
	else if ( ""==m_wzKind ) sWarning=_T("类别");
	else if ( ""==m_wzSpec ) sWarning=_T("规格型号");
	else if ( ""==m_wzUnit ) sWarning=_T("计量单位");
	    
	if ( ""!=sWarning ) 
	{
	   sWarning += _T("不能为空");
	   AfxMessageBox(sWarning, MB_ICONEXCLAMATION);
	   return;
	}	
	_variant_t strQuery;	
	if (m_bAppend)
	{
		// 判断物资唯一性
	    strQuery = "select * from material where wzid='"+m_wzID+"'";
	    theApp.ADOExecute(theApp.m_pADOSet, strQuery);
	    int iCount = theApp.m_pADOSet->GetRecordCount();
	    if ( 0!=iCount )
		{
	       AfxMessageBox(_T("已经存在此物资的记录！"), MB_ICONEXCLAMATION);
	       return;
		}
	}
			
	if (m_bAppend)
	{
	    strQuery = "insert material (wzid, wzname, wzspec, wzkind, wzunit) \
	         	    values ('"+m_wzID+"', '"+m_wzName+"','"+m_wzSpec+"','"+m_wzKind+"','"+m_wzUnit+"')";
	    if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) 
		{
			AfxMessageBox(_T("添加记录成功！"), MB_ICONINFORMATION);
	        
		// 清空输入数据
            m_wzID=m_wzName=m_wzSpec=m_wzKind=m_wzUnit="";
			UpdateData(false);
		}
	    else AfxMessageBox(_T("添加记录失败！"), MB_ICONEXCLAMATION);
	}
	else//修改记录
	{
		strQuery = "Update material set wzname='"+m_wzName+"', wzspec='"+m_wzSpec+"', wzunit='"+m_wzUnit+",\
			        where wzid='"+m_wzID+"'";
	    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();
}