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 }}