mydatabase.h

关于联通的一个统一定制程序

// MyDatabase.h: interface for the CMyDatabase class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_MYDATABASE_H__FCEDFAEF_D438_45FF_A842_EBD4DF184887__INCLUDED_)
#define AFX_MYDATABASE_H__FCEDFAEF_D438_45FF_A842_EBD4DF184887__INCLUDED_

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

#include "stdafx.h"

class CMyDatabase  
{
public:
	CMyDatabase();
	virtual ~CMyDatabase();

public:
	BOOL OpenDB();
	void CloseDB();
	BOOL OpenUserDB();
	void CloseUserDB();

	BOOL OpenDB(LPCTSTR pszSQL, _ConnectionPtr& pConn);
	void CloseDB(_ConnectionPtr& pConn);

	//平台用户注册
	int RegisterUser(LPCTSTR pszMobile, CString& szPassword);
	int GetCommonInfo(LPCOMMONINFO pInfo);
	//二次定制
	BOOL AddOneSubConfirm(LPCTSTR pszMobile, LPCTSTR pszCmd, LPCTSTR pszContent, LPCTSTR pszSrcTermId);
	int GetSedHistory(LPCTSTR pszMobile, CString& szCmd, CString& szContent, CString& szSrcTermId, CString& szName, long& nID);
	int SedHistoryDone(long nID);
	// old product
	int AddCustom(LPCTSTR PushType, LPCTSTR CustomerNo, LPCTSTR bSendTime, LPCTSTR eSendTime,
									LPCTSTR ReceiverNo, LPCTSTR Param1, LPCTSTR Param2, long CustomMode);
	int DeleteCustom(LPCTSTR PushType, LPCTSTR CustomerNo, LPCTSTR bSendTime, LPCTSTR eSendTime,
									LPCTSTR ReceiverNo, LPCTSTR Param1, LPCTSTR Param2, long Status, long CustomMode);
	int QueryCustom(LPCTSTR PushType, LPCTSTR CustomerNo, LPCTSTR bSendTime, LPCTSTR eSendTime,
									LPCTSTR ReceiverNo, LPCTSTR Param1, LPCTSTR Param2, long Status, CString& szOut);
	// new product
	int AddCustom(_ConnectionPtr& pConn, LPCTSTR pszMobile, LPCTSTR pszSQL, long nChannel, LPCTSTR pszReceiver);
	int DeleteCustom(_ConnectionPtr& pConn, LPCTSTR pszMobile, LPCTSTR pszSQL, long nChannel);
	int QueryCustom(_ConnectionPtr& pConn, LPCTSTR pszMobile, LPCTSTR pszSQL);

	int GetOutputMsg(LPCTSTR pszMobile, LPCTSTR pszCmd, LPOUTPUTMSGLIST pList);
	int GetProductInfo(LPCTSTR pszMobile, LPCTSTR pszCmd, LPCTSTR pszSrcTermID, LPPRODUCTINFO pPI, LPMISCMSGLIST pList, LPOUTPUTMSGLIST pMsgList, LPSERVICEINFO pSI);
	
	int IsValidCity(CString& szCity);
	
	//0000
	BOOL IsUnicomPhone(LPCTSTR pszMobile);
	int CancelAll(LPCTSTR pszMobile,LPOUTPUTMSGLIST pList);
	int GetUserCustomList(LPCTSTR pszMobile, CString &strList,CString &strMsg);
	int CancelOneSubscribeByCode(LPCTSTR pszMobile,LPCTSTR pszPushType,ULONG lCustomNo,LPCTSTR pszColName,LPCTSTR pszTypeCode,ULONG lType,LPOUTPUTMSGLIST pList);
	int CancelOneSubscribeBy_USP(LPCTSTR pszMobile,LPCTSTR pszPushType,ULONG lCustomNo);
	int Get00000ProductInfo(LPCTSTR pszMobile, LPCTSTR psz00000Cmd,LPCTSTR pszTypeCode,ULONG lType,LPPRODUCTINFO pPI, LPOUTPUTMSGLIST pList);
	bool Is1860Allowed(LPCTSTR pszMobile);
private:
	_ConnectionPtr	m_pConn;
	BOOL			m_bOpenned;
	_ConnectionPtr	m_pUserConn;
	BOOL			m_bUserOpenned;
};

#endif // !defined(AFX_MYDATABASE_H__FCEDFAEF_D438_45FF_A842_EBD4DF184887__INCLUDED_)