bkinfomodifydlg.cpp

VC下基于SQL的图书管理系统源代码

// BkInfoModifyDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookAdmi.h"
#include "BkInfoModifyDlg.h"
#include "BookInfo.h"
#include "ADOConn.h"

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

/////////////////////////////////////////////////////////////////////////////
// BkInfoModifyDlg dialog


BkInfoModifyDlg::BkInfoModifyDlg(CWnd* pParent /*=NULL*/)
	: CDialog(BkInfoModifyDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(BkInfoModifyDlg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void BkInfoModifyDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
//	DDX_Control(pDX, IDOK, m_ok);
	DDX_Text(pDX, IDC_EDIT1, m_BookNameEdit);
	DDX_Text(pDX, IDC_EDIT2, m_BookClaIdEdit);
	DDX_Text(pDX, IDC_EDIT3, m_BookIdEdit);
	DDX_Text(pDX, IDC_EDIT4, m_AuthorIdEdit);
	DDX_Text(pDX, IDC_EDIT5, m_PubDateEdit);
	DDX_Text(pDX, IDC_EDIT6, m_PubNumEdit);
	DDX_Text(pDX, IDC_EDIT7, m_PubCompanyEdit);
	DDX_Text(pDX, IDC_EDIT10, m_CopyRightEdit);
	DDX_Text(pDX, IDC_EDIT8, m_BookPriceEdit);
	DDX_Text(pDX, IDC_EDIT9, m_PageAmountEdit);
	//{{AFX_DATA_MAP(BkInfoModifyDlg)
		// NOTE: the ClassWizard will add DDX and DDV calls here
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// BkInfoModifyDlg message handlers

void BkInfoModifyDlg::OnOK() 
{
	UpdateData(true);
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	_bstr_t vSQL;
	vSQL="SELECT * from t_book where BookId='"+m_BookIdEdit+"'";
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(!m_pRecordset->adoEOF&&m_BookIdEdit!=OldBookId)
	{
		MessageBox("此图书编号已存在!!");
		return;
	}
	if(BookInfoError())
	{
		MessageBox(ErrorStr+"输入有误!!");
		return;
	}
	pSearchResultDlg->deadDelete=true;
	pSearchResultDlg->OnDelete();
	BookInfo BkInfo;
	BkInfo.a_BookId=m_BookIdEdit;
	BkInfo.a_BookName=m_BookNameEdit;
	BkInfo.a_Copyright=m_CopyRightEdit;	
	BkInfo.a_PubCompany=m_PubCompanyEdit;
	BkInfo.a_PubNumber=m_PubNumEdit;
	BkInfo.a_AuthorId=m_AuthorIdEdit;
	BkInfo.a_BookClaId=m_BookClaIdEdit;
	BkInfo.a_BookPrice=m_BookPriceEdit;
	BkInfo.a_PubDate=m_PubDateEdit;
	if(m_BookPriceEdit=="")
		BkInfo.a_BookPrice="0";	
	BkInfo.a_PageAmount=m_PageAmountEdit;
	if(m_PageAmountEdit=="")
		BkInfo.a_PageAmount="0";
	BkInfo.sql_insert();
	pSearchResultDlg->m_adodc.Refresh();
	pSearchResultDlg->deadDelete=false;
	MessageBox("数据修改成功!!");
	CDialog::OnOK();
}

bool BkInfoModifyDlg::BookInfoError()
{
	if(m_BookNameEdit=="")
	{
		ErrorStr="图书名";
		return(true);
	}
	if(m_BookIdEdit=="")
	{
		ErrorStr="图书编号";
		return(true);
	}
	CString date=m_PubDateEdit,chr1,chr2;
	if(date!="")
	{
		int j=0,len=date.GetLength(),year,month,day,chrP[2]={20,20};
		for(int i=1;i<len;i++)
		{
			if(date.Left(i).Right(1)=="-")
			{
				chrP[j]=i;
				j++;
			}
			if(j==2)
				i=len;
		}		
		year=atoi(date.Left(4));
		month=atoi(date.Left(chrP[1]-1).Right(chrP[1]-chrP[0]-1));
		day=atoi(date.Right(len-chrP[1]));	
		if(len>10||len<8
			||year<1900 ||year>2100 || day>31||day<1||month>12||month<1)
		{
			ErrorStr="出版日期";
			return(true);
		}
	}
	
	if(atoi(m_BookPriceEdit)<0)
	{
		ErrorStr="定价";
		return(true);
	}
	
	if(atoi(m_PageAmountEdit)<0)
	{
		ErrorStr="页数";
		return(true);
	}
	if(m_CopyRightEdit!="")
		if(atoi(m_CopyRightEdit)<1900 ||atoi(m_CopyRightEdit)>3000)
		{
		ErrorStr="著作权年限";
		return(true);
		}
	return(false);
}

void BkInfoModifyDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	pSearchResultDlg->deadDelete=false;
	CDialog::OnCancel();
}