郑德才博客

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
 
namespace SNS_Entitys
{
    public class SNSBlog
    {
        /// <summary>
        /// 空实例化
        /// </summary>
        public SNSBlog(){}
 
        /// <summary>
        /// 使用DataRow实例化
        /// </summary>
        /// <param name="dr"></param>
        public SNSBlog(DataRow dr)
        {
            SetBlog(dr);
        }
 
        /// <summary>
        /// 设置博文数据
        /// </summary>
        /// <param name="dr"></param>
        public void SetBlog(DataRow dr)
        {
            if (dr.Table.Columns.Contains("Id") && dr["Id"] != DBNull.Value && dr["Id"] != null)
                Id = Convert.ToInt32(dr["Id"]);
            if (dr.Table.Columns.Contains("Topic") && dr["Topic"] != DBNull.Value && dr["Topic"] != null)
                Topic = dr["Topic"].ToString();
        }
 
        /// <summary>
        /// 将类转化为SQL参数
        /// </summary>
        /// <returns>SQL参数数组</returns>
        public SqlParameter[] ConvertToSqlParamenter()
        {
            SqlParameter[] parameters=new SqlParameter[]{
                new SqlParameter("@Id",Id)
                ,new SqlParameter("@Topic",Topic)
            };
            return parameters;
        }
 
 
        #region 博文信息
 
        private string topic = "";
        /// <summary>
        /// 话题
        /// </summary>
        public string Topic
        {
            get { return topic; }
            set { topic = value; }
        }
         
        public long _id = 0;
        /// <summary>
        /// 博文编号
        /// </summary>
        public long Id
        {
            get { return _id; }
            set { _id = value; }
        }
         
        #endregion
    }
}