userchannel.h

一个电视台专用的信息管理软件源代码

// UserChannel.h: interface for the CUserChannel class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_USERCHANNEL_H__5346FF59_6BAD_498B_B3DB_61CE7AA6B61F__INCLUDED_)
#define AFX_USERCHANNEL_H__5346FF59_6BAD_498B_B3DB_61CE7AA6B61F__INCLUDED_

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

#include "ADOConn.h"

class CUserChannel : public ADOConn  
{
public:
	CUserChannel();
	virtual ~CUserChannel();
private:
	int UID;
	int UserID;
	int ChannelID;
	int ColumnID;
public:
	int GetUID();
	int GetUserID();
	int GetChannelID();
	int GetColumnID();

	void SetUID(int iUID);
	void SetUserID(int iUserID);
	void SetChannelID(int iChannelID);
	void SetColumnID(int iColumnID);

	//数据库操作
	void sql_insert(int iUserID,int iChannelID,int iColumnID);  
	void sql_update(int iUID,int iUserID,int iChannelID,int iColumnID);
	void sql_delete(int iUID);
	//读取所有字段值
	void GetData(int UID);
	int GetAuditor(int iChannelID,int iColumnID);
	int GetChannelIDByUserID(int iUserID);
	int GetColumnIDByUserID(int iUserID);

};

#endif // !defined(AFX_USERCHANNEL_H__5346FF59_6BAD_498B_B3DB_61CE7AA6B61F__INCLUDED_)