www.pudn.com > chenjing.rar > NewProofDlg.cpp
// NewProofDlg.cpp : implementation file
//
#include "stdafx.h"
#include "Library.h"
#include "NewProofDlg.h"
#include "ProofSet.h"
#include "PersonInfoDlg.h"
#include "CheckProofDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CNewProofDlg dialog
CNewProofDlg::CNewProofDlg(CWnd* pParent /*=NULL*/)
: CDialog(CNewProofDlg::IDD, pParent)
{
//{{AFX_DATA_INIT(CNewProofDlg)
m_strTel = _T("");
m_iSex = -1;
m_strProofID = _T("");
m_strName = _T("");
m_strID = _T("");
m_strAddress = _T("");
//}}AFX_DATA_INIT
}
void CNewProofDlg::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CNewProofDlg)
DDX_Control(pDX, IDC_COMBO_YEAR, m_comYear);
DDX_Control(pDX, IDC_COMBO_MONTH, m_comMonth);
DDX_Control(pDX, IDC_COMBO_DAY, m_comDay);
DDX_Text(pDX, IDC_EDIT_TEL, m_strTel);
DDX_Radio(pDX, IDC_RADIO_MALE, m_iSex);
DDX_Text(pDX, IDC_EDIT_PROOF, m_strProofID);
DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
DDX_Text(pDX, IDC_EDIT_ID, m_strID);
DDX_Text(pDX, IDC_EDIT_ADDRESS, m_strAddress);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CNewProofDlg, CDialog)
//{{AFX_MSG_MAP(CNewProofDlg)
ON_BN_CLICKED(IDC_BUTTON_BACK, OnButtonBack)
ON_WM_CLOSE()
ON_BN_CLICKED(IDC_BUTTON_OK, OnButtonOk)
ON_BN_CLICKED(IDC_BUTTON_CHECK_PROOF, OnButtonCheckProof)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CNewProofDlg message handlers
BOOL CNewProofDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_comYear.AddString("请选择年份");
m_comYear.AddString("1965");
m_comYear.AddString("1966");
m_comYear.AddString("1967");
m_comYear.AddString("1968");
m_comYear.AddString("1969");
m_comYear.AddString("1970");
m_comYear.AddString("1971");
m_comYear.AddString("1972");
m_comYear.AddString("1973");
m_comYear.AddString("1974");
m_comYear.AddString("1975");
m_comYear.AddString("1976");
m_comYear.AddString("1977");
m_comYear.AddString("1978");
m_comYear.AddString("1979");
m_comYear.AddString("1980");
m_comYear.AddString("1981");
m_comYear.AddString("1982");
m_comYear.AddString("1983");
m_comYear.AddString("1984");
m_comYear.AddString("1985");
m_comYear.AddString("1986");
m_comYear.AddString("1987");
m_comYear.AddString("1988");
m_comYear.AddString("1989");
m_comYear.AddString("1990");
m_comYear.AddString("1991");
m_comYear.AddString("1992");
m_comYear.AddString("1993");
m_comYear.AddString("1994");
m_comYear.AddString("1995");
m_comYear.AddString("1996");
m_comYear.AddString("1997");
m_comYear.AddString("1998");
m_comYear.AddString("1999");
m_comYear.AddString("2000");
m_comYear.SelectString(-1,"请选择年份");
m_comMonth.AddString("请选择月份");
m_comMonth.AddString("01");
m_comMonth.AddString("02");
m_comMonth.AddString("03");
m_comMonth.AddString("04");
m_comMonth.AddString("05");
m_comMonth.AddString("06");
m_comMonth.AddString("07");
m_comMonth.AddString("08");
m_comMonth.AddString("09");
m_comMonth.AddString("10");
m_comMonth.AddString("11");
m_comMonth.AddString("12");
m_comMonth.SelectString(-1,"请选择月份");
m_comDay.AddString("请选择日期");
m_comDay.AddString("01");
m_comDay.AddString("02");
m_comDay.AddString("03");
m_comDay.AddString("04");
m_comDay.AddString("05");
m_comDay.AddString("06");
m_comDay.AddString("07");
m_comDay.AddString("08");
m_comDay.AddString("09");
m_comDay.AddString("10");
m_comDay.AddString("11");
m_comDay.AddString("12");
m_comDay.AddString("13");
m_comDay.AddString("14");
m_comDay.AddString("15");
m_comDay.AddString("16");
m_comDay.AddString("17");
m_comDay.AddString("18");
m_comDay.AddString("19");
m_comDay.AddString("20");
m_comDay.AddString("21");
m_comDay.AddString("22");
m_comDay.AddString("23");
m_comDay.AddString("24");
m_comDay.AddString("25");
m_comDay.AddString("26");
m_comDay.AddString("27");
m_comDay.AddString("28");
m_comDay.AddString("29");
m_comDay.AddString("30");
m_comDay.AddString("31");
m_comDay.SelectString(-1,"请选择日期");
UpdateData(FALSE);
CheckRadioButton(IDC_RADIO_MALE,IDC_RADIO_FEMALE,IDC_RADIO_MALE);
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CNewProofDlg::OnButtonBack()
{
if(m_database.IsOpen())
m_database.Close();
OnOK();
}
void CNewProofDlg::OnClose()
{
OnButtonBack();
}
void CNewProofDlg::OnButtonOk()
{
UpdateData();
if(m_strProofID=="")
{
MessageBox("请填写完整数据!","办理借阅证");
return;
}
if(!m_database.IsOpen())
{
if(!m_database.Open(_T("Library")))
{
MessageBox("不能打开数据库","办理借阅证");
return;
}
}
CProofSet *m_pset=new CProofSet(&m_database);
//察看是否已经有该人，有将不予办理！
CString strSQL;
strSQL.Format("select * from Proof_Info where Proof_ID='%s'",m_strProofID);
m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
if(m_pset->GetRecordCount()!=0)
{
MessageBox("该号码已存在!","办理借阅证");
m_pset->Close();
m_database.Close();
m_strProofID.Empty();
UpdateData(FALSE);
return;
}
m_pset->Close();
//没有这个号码，办理借阅证，存入数据库
if(m_strProofID==""||m_strName==""||m_strAddress==""
||m_strID==""||m_strTel=="")
{
MessageBox("请添写完整数据!","办理借阅证");
return;
}
m_iSex=GetCheckedRadioButton(IDC_RADIO_MALE,IDC_RADIO_FEMALE);
if(m_iSex==IDC_RADIO_MALE)
m_strSex="Male";
else if(m_iSex==IDC_RADIO_FEMALE)
m_strSex="Female";
else
{
MessageBox("请选择性别！","办理借阅证");
return;
}
CString m_strYear,m_strMonth,m_strDay;
int m_year,m_month,m_day;
m_comYear.GetWindowText(m_strYear);
m_year=atoi(m_strYear);
m_comMonth.GetWindowText(m_strMonth);
m_month=atoi(m_strMonth);
m_comDay.GetWindowText(m_strDay);
m_day=atoi(m_strDay);
strSQL.Format("select * from Proof_Info");
m_pset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
if(m_pset->GetRecordCount()==0)
{
MessageBox("确定办理借书证","办理借阅证");
}
m_pset->AddNew();
m_pset->SetFieldNull(&(m_pset->m_Proof_ID),FALSE);
m_pset->m_Proof_ID=m_strProofID;
m_pset->SetFieldNull(&(m_pset->m_Name),FALSE);
m_pset->m_Name=m_strName;
m_pset->SetFieldNull(&(m_pset->m_Sex),FALSE);
m_pset->m_Sex=m_strSex;
CTime m_strBirthTime(m_year,m_month,m_day,10,5,6,-1);
m_pset->SetFieldNull(&(m_pset->m_Birth_Time),FALSE);
m_pset->m_Birth_Time=m_strBirthTime;
m_pset->SetFieldNull(&(m_pset->m_Address),FALSE);
m_pset->m_Address=m_strAddress;
m_pset->SetFieldNull(&(m_pset->m_ID_Number),FALSE);
m_pset->m_ID_Number=m_strID;
m_pset->SetFieldNull(&(m_pset->m_Tel_Number),FALSE);
m_pset->m_Tel_Number=m_strTel;
m_pset->SetFieldNull(&(m_pset->m_Now_Borrow_Amount),FALSE);
m_pset->m_Now_Borrow_Amount=0;
m_pset->Update();
m_pset->Requery();
m_pset->Close();
m_database.Close();
MessageBox("办理借书证成功！","办理借阅证");
CPersonInfoDlg m_dlg;
m_dlg.m_strProofID=m_strProofID;
m_dlg.DoModal();
}
void CNewProofDlg::OnButtonCheckProof()
{
CCheckProofDlg m_dlg;
m_dlg.m_strProofID=m_strProofID;
m_dlg.DoModal();
}