bankbookdlg.cpp

Family Financial Management System是一个特别方便的理财系统。功能方便实用。

// BankBookDlg.cpp : implementation file
//

#include "stdafx.h"
#include "FFManage.h"
#include "BankBookDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBankBookDlg dialog



extern CRecordset g_Recordset;	
extern CDatabase  g_Database;
extern int        g_iType;

extern int Encrypt(const CString passwd, const char key, CString & resPasswd);
extern int Decrypt(const CString passwd, const char key, CString & resPasswd);



CBankBookDlg::CBankBookDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBankBookDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBankBookDlg)
	m_strAccounts = _T("");
	m_strBankBookNum = _T("");
	m_strBankName = _T("");
	m_strCardNum = _T("");
	m_strDescribe = _T("");
	m_strMoneyType = _T("");
	m_strPassWord = _T("");
	m_strStartBankName = _T("");
	m_strStartBankTel = _T("");
	m_strUserName = _T("");
	m_fMoney = 0.0f;
	m_oleDate = COleDateTime::GetCurrentTime();
	//}}AFX_DATA_INIT
	m_strFID = _T("");
}


void CBankBookDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBankBookDlg)
	DDX_Control(pDX, IDC_EDIT_Money, m_editMoney);
	DDX_Text(pDX, IDC_EDIT_Accounts, m_strAccounts);
	DDV_MaxChars(pDX, m_strAccounts, 50);
	DDX_Text(pDX, IDC_EDIT_BankBookNum, m_strBankBookNum);
	DDV_MaxChars(pDX, m_strBankBookNum, 50);
	DDX_Text(pDX, IDC_EDIT_BankName, m_strBankName);
	DDV_MaxChars(pDX, m_strBankName, 50);
	DDX_Text(pDX, IDC_EDIT_CardNum, m_strCardNum);
	DDV_MaxChars(pDX, m_strCardNum, 50);
	DDX_Text(pDX, IDC_EDIT_Describe, m_strDescribe);
	DDX_Text(pDX, IDC_EDIT_MoneyType, m_strMoneyType);
	DDV_MaxChars(pDX, m_strMoneyType, 50);
	DDX_Text(pDX, IDC_EDIT_PassWord, m_strPassWord);
	DDV_MaxChars(pDX, m_strPassWord, 10);
	DDX_Text(pDX, IDC_EDIT_StartBankName, m_strStartBankName);
	DDV_MaxChars(pDX, m_strStartBankName, 50);
	DDX_Text(pDX, IDC_EDIT_StartBankTel, m_strStartBankTel);
	DDV_MaxChars(pDX, m_strStartBankTel, 50);
	DDX_Text(pDX, IDC_EDIT_UserName, m_strUserName);
	DDV_MaxChars(pDX, m_strUserName, 50);
	DDX_Text(pDX, IDC_EDIT_Money, m_fMoney);
	DDX_DateTimeCtrl(pDX, IDC_Date_StartDate, m_oleDate);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBankBookDlg, CDialog)
	//{{AFX_MSG_MAP(CBankBookDlg)
	ON_BN_CLICKED(IDC_BTN_PassWord, OnBTNPassWord)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBankBookDlg message handlers

void CBankBookDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	if(m_strBankName.IsEmpty())
	{
		AfxMessageBox("请输入银行名称！");
		GetDlgItem(IDC_EDIT_BankName)->SetFocus();
		return;
	}

	if(m_strAccounts.IsEmpty()&&m_strCardNum.IsEmpty())
	{
		AfxMessageBox("请输入帐号或卡号！");
		GetDlgItem(IDC_EDIT_Accounts)->SetFocus();
		return;
	}
	
	CString strStartDate = m_oleDate.Format("%Y年%m月%d日");
	CString strMoney;
	strMoney.Format("%.2f",m_fMoney);
	
	CString strTemp;


	Encrypt(m_strBankName,PWDKEY,strTemp);
	m_strBankName = strTemp;

	Encrypt(m_strAccounts,PWDKEY,strTemp);
	m_strAccounts = strTemp;

	Encrypt(m_strCardNum,PWDKEY,strTemp);
	m_strCardNum = strTemp;

	Encrypt(m_strUserName,PWDKEY,strTemp);
	m_strUserName = strTemp;

	Encrypt(m_strBankBookNum,PWDKEY,strTemp);
	m_strBankBookNum = strTemp;

	Encrypt(m_strMoneyType,PWDKEY,strTemp);
	m_strMoneyType = strTemp;

	Encrypt(strStartDate,PWDKEY,strTemp);
	strStartDate = strTemp;
	
	Encrypt(m_strStartBankName,PWDKEY,strTemp);
	m_strStartBankName = strTemp;

	Encrypt(m_strStartBankTel,PWDKEY,strTemp);
	m_strStartBankTel = strTemp;

	Encrypt(strMoney,PWDKEY,strTemp);
	strMoney = strTemp;

	Encrypt(m_strDescribe,PWDKEY,strTemp);
	m_strDescribe = strTemp;

	Encrypt(m_strPassWord,PWDKEY,strTemp);
	m_strPassWord = strTemp;

	if(m_strFID.IsEmpty())
	{
		m_strSQL.Format("Insert into TBankBook(FBankName, FAccounts, FCardNum,FUserName,FBankBookNum,FMoneyType,FStartDate,FStartBankName,FStartBankTel,FMoney,FDescribe,FPassWord) values ('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s')",m_strBankName, m_strAccounts, m_strCardNum,m_strUserName,m_strBankBookNum,m_strMoneyType,strStartDate,m_strStartBankName,m_strStartBankTel,strMoney,m_strDescribe,m_strPassWord);	
	}
	else
	{
		m_strSQL.Format("Update TBankBook Set FBankName='%s', FAccounts='%s', FCardNum='%s',FUserName='%s',FBankBookNum='%s',FMoneyType='%s',FStartDate='%s',FStartBankName='%s',FStartBankTel='%s',FMoney='%s',FDescribe='%s',FPassWord='%s' where FID=%s ",m_strBankName, m_strAccounts, m_strCardNum,m_strUserName,m_strBankBookNum,m_strMoneyType,strStartDate,m_strStartBankName,m_strStartBankTel,strMoney,m_strDescribe,m_strPassWord,m_strFID);	
	}		
//	AfxMessageBox(m_strSQL);
	if(!m_strSQL.IsEmpty())
	{
		try
		{
			g_Database.ExecuteSQL(m_strSQL);
		}
		catch(...)
		{
			AfxMessageBox("错误! " + m_strSQL);			
		}
	}
	

	CDialog::OnOK();
}

BOOL CBankBookDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	if(m_strFID.IsEmpty())
	{
//		m_editMoney.SetReadOnly(FALSE);
		GetDlgItem(IDC_BTN_PassWord)->EnableWindow(FALSE);
		SetWindowText("增加银行帐号、卡号");
	}
	else
	{
	//	m_editMoney.SetReadOnly(TRUE);
		SetWindowText("修改银行帐号、卡号");
	}
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CBankBookDlg::OnBTNPassWord() 
{
	CString strTemp;
	CString strPWD;
	m_strSQL.Format("select FPassWord from TBankBook Where FID = %s",m_strFID);
	if(g_Recordset.IsOpen())g_Recordset.Close();
	g_Recordset.Open(CRecordset::forwardOnly, m_strSQL, CRecordset::readOnly);
	if(!g_Recordset.IsEOF())
	{
		g_Recordset.GetFieldValue((short)0,strPWD);				
	}
	g_Recordset.Close();
	Decrypt(strPWD,PWDKEY,strTemp);
	strPWD.Format("密码为<%s>",strTemp);
	AfxMessageBox(strPWD);
}