column.h

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

// Column.h: interface for the CColumn class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_COLUMN_H__7C8A1FC7_1BCD_48B2_BA34_514ECB00322D__INCLUDED_)
#define AFX_COLUMN_H__7C8A1FC7_1BCD_48B2_BA34_514ECB00322D__INCLUDED_

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

#include "ADOConn.h"

class CColumn : public ADOConn  
{
	private:
	long UID;
	long ChannelID;
	CString Name;
	CString Desc;
public:
	void SetUID(int iUID);
	int GetUID();
	CColumn();
	virtual ~CColumn();
	
	CString GetName();	
	CString GetDesc();
	long GetChannelID();

	void SetName(CString cName);
	void SetDesc(CString cDesc);
	void SetChannelID(long lChannelID);
	void GetAllColumn(CStringArray& allColumns,CString strSQL="");

	//数据库操作
	void ShowList(CListCtrl& listctrl,CString strSQL="");
	void ShowTree(CTreeCtrl& treectrl,CString strCondition="");
	void sql_insert(CString cName,CString cDesc,long lChannelID,long& iFlg,CString& cMessage);  
	void sql_update(long iUID,CString cName,CString cDesc,long lChannelID,long& iFlg,CString& cMessage);
	void sql_delete(long iUID,long& iFlg,CString& cMessage);
	//读取所有字段值
	void GetData(int UID);
	int GetIDByName(CString cName);
	void GetAllColumn(CStringArray& allColumns,int iChannelID);
	
	int  getUIDByColumnName(CString columnName);

};

#endif // !defined(AFX_COLUMN_H__7C8A1FC7_1BCD_48B2_BA34_514ECB00322D__INCLUDED_)