news.h

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

// News.h: interface for the CNews class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_NEWS_H__C794491F_8960_4C73_A0A2_E674C3AAFD54__INCLUDED_)
#define AFX_NEWS_H__C794491F_8960_4C73_A0A2_E674C3AAFD54__INCLUDED_

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

#include "ADOConn.h"

class CNews : public ADOConn  
{
public:
	CNews();
	virtual ~CNews();
private:
	int UID;
	CString Title;
	int UserID;
	int	ChannelID;
	int ColumnID;
	int MustAuditID;
	CString Desc;
	CString FileName;
	int FileSize;
	CString SendTime;
	CString PassTime;
	int State;
	int IsDelete;
	CString IPStr;
	CString FilePath;

public:
	CString GetIPStr();
	CString GetFilePath();
	void SetIPStr(CString cIPStr);
	void SetFilePath(CString cFilePath);

	BOOL QryTitleExist(CString FileName);
	int QryFileExist(CString FileName,CString ServerPath);
	int GetUID();
	CString GetTitle();
	int GetUserID();
	int	GetChannelID();
	int GetColumnID();
	CString GetDesc();
	CString GetFileName();
	int GetFileSize();
	CString GetSendTime();
	CString GetPassTime();
	int GetState();
	int GetIsDelete();
	int GetMustAuditID();

	void SetUID(int iUID);
	void SetTitle(CString cTitle);
	void SetUserID(int iUserID);
	void SetChannelID(int iChannelID);
	void SetColumnID(int iColumnID);
	void SetDesc(CString cDesc);
	void SetFileName(CString cFileName);
	void SetFileSize(int iFileSize);
	void SetSendTime(CString cSendTime);
	void SetPassTime(CString cPassTime);
	void SetState(int iState);
	void SetIsDelete(int cIsDelete);
	void SetMustAuditID(int iMustAuditID);
	


	//数据库操作
	BOOL GetNewNews(CUIntArray& allNewsItem);
	void ShowNewNews(long NewsID,CString& cMessage); 
	void CancleNews(long NewsID,long UserID,long& iFlg,CString& cMessage); 
	void GetAllNewsByUserID(CUIntArray& allNewsItem,int iUserID,int Type =0,CString cCondition="");
	void AuditNews(long iNewsID,long iAuditID,CString cAuditDesc,long iType,long bsUID,long& iFlg,CString& cMessage); 
	void UploadNews(CString cTitle,long iUserID,long iColumnID,CString cDesc,CString cFileName,long iFileSize,long iAuditUserID,long IsOverLoad,CString FilePath,long& iFlag,CString& cMessage);
	void sql_insert(CString cTitle,int iUserID,int iChannelID,int iColumnID,CString cDesc,CString cFileName,int iFileSize,CString cSendTime,CString cPassTime,CString cState,CString cIsDelete,CString cIsAudit);  
	void sql_update(int iUID,CString cTitle,int iUserID,int iChannelID,int iColumnID,CString cDesc,CString cFileName,int iFileSize,CString cSendTime,CString cPassTime,CString cState,CString cIsDelete,CString cIsAudit);
	void sql_delete(int iUID);
	void ReadNews(int iUID);
	void GetAllNews(CUIntArray& allNewsItem,CString cCondition="");
	void GetServerInfByNewsID(int iUID,CString& FileName,unsigned short& Port,CString& strIP);
	//读取所有字段值
	void GetData(int UID);

	void ShowList(CListCtrl& listctrl);

	int getUIDByTitle(CString title);

	void ShowListByNewsID(CListCtrl& listctrl,int iNewsID);
	void GetRepInf(CStringArray& RepInf);


};

#endif // !defined(AFX_NEWS_H__C794491F_8960_4C73_A0A2_E674C3AAFD54__INCLUDED_)