message.cs

企业网站前台后台源程序,用于大中小型企业网站后台程序开发

using System;
using System.Data;
using Socut.Data;
namespace BLL
{
	/// <summary>
	/// 留言本类
	/// </summary>
	public class messages
	{
		protected CData myData = new CData();
		protected DataSet ds = new DataSet();
		protected user us=new user();
		/// <summary>
		/// 检查是否已经被回复，如果被恢复返回被谁回复
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public string get_message(string id)
		{
			string msg="未回复";
			string sql = "select top 1 MESSAGE_user_id from MESSAGE_again where  MESSAGE_id="+Convert.ToInt32(id);
			ds = myData.GetDataSet(sql, 0, 0, "MESSAGE_again");
			if(ds!=null && ds.Tables["MESSAGE_again"].Rows.Count>0)
				msg="<b>"+us.search_data("[user]","id",Convert.ToInt32(ds.Tables["MESSAGE_again"].Rows[0][0].ToString()),"login_name")+"</b>回复";
			
				

			return msg;
		}
		/// <summary>
		/// 检查是否已经被回复，如果被恢复返回"YES"否则是"NO"
		/// </summary>
		/// <param name="id"></param>
		/// <returns></returns>
		public string get_message(int id)
		{
			string msg="NO";
			string sql = "select top 1 MESSAGE_user_id from MESSAGE_again where  MESSAGE_id="+id;
			ds = myData.GetDataSet(sql, 0, 0, "MESSAGE_again");
			if(ds!=null && ds.Tables["MESSAGE_again"].Rows.Count>0)
				msg="YES";
			
			return msg;
		}
	}
}