adoconnect.h

个人理财系统（管理股票信息）

// AdoConnect.h: interface for the CAdoConnect class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_ADOCONNECT_H__8D691B89_FB45_4274_98C9_F820A6506B26__INCLUDED_)
#define AFX_ADOCONNECT_H__8D691B89_FB45_4274_98C9_F820A6506B26__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#include "AdoRecordSet.h"

#import "c:\program files\common files\system\ado\msado15.dll" \
		no_namespace rename("EOF","adoEOF")

class CAdoConnect  
{
	
public:
	_ConnectionPtr				m_connect;
	CAdoConnect();
	virtual ~CAdoConnect();
	BOOL InitInstance();
	BOOL GetRecordSet(CString &SqlCommand,  CAdoRecordSet &rec);
	BOOL ExecuteCmd(CString &SqlCommand);
	BOOL ConnectDb(CString &connectstr);
	//修改用户名
	BOOL AmendUserName(CString &oldname, CString &newname);
	//判断密码是否正确
	BOOL IsThePwd(CString &username, CString &inputpwd);
	//修改密码
	BOOL AmendPwd(CString &user, CString &newpwd);
	//判断是否是相同的用户名
	BOOL IsTheSameName(CString &newname);
	//创建新用户，存储到服务器
	BOOL InsertNewAccount(CString &user, CString &pwd, CString &dealtpye, double &balance, CString &remark);
	//删除账户
	BOOL DlelteAccount(CString &accountname);
	//增加参数
	BOOL AddParameter(CString &mart_type, CString &stock_spec_code ,CString &stock_for_short, double &poundage, double &least_poundage, double &stamp_tax, double &transferrate, double &least_transferred, double &commission);
	//设置当前用户的账户金额，主要用于追加资金或者划出资金
	BOOL AmendAccountMoney(CString &user, double &money);
	//把股票的信息写入数据库TB_SUMMARYLIST
	BOOL AddStockInfoToTB_SUMMARYLIST(CString &account_id, CString &stock_code, CString &stock_name, 
		double &new_price, double &cose_price, int &stock_amount, double &mart_value, double &profit_lost);
	//把交易信息写入数据库TB_DEALDETAIL
	BOOL AddStockInfoToTB_DEALDETAIL(CString &deal_type,CString &deal_date, double &unit_type,
		int &amount, double &deal_money, double &fare, double &profit_loss, double &stock_amount);

};

#endif // !defined(AFX_ADOCONNECT_H__8D691B89_FB45_4274_98C9_F820A6506B26__INCLUDED_)