实体层代码演示，自动生成实体类，所有属性，以及实体相关方法等，
自动生成枚举类，自动生成接口类，自动生成实体比较类，列表排序，自动生成强类型实体，并生成相关的Excel,Csv,XMl等方法
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;
using System.ComponentModel;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Formatters.Binary;
#region 修改日志
/*
----------------------------------------------------------------------------------------------------
-- 类创建时间: 星期二, 2008年5月20日 23:21:55
-- Created By:CrazyCoder 疯狂代码
-- 目的:表Qst_Article的实体类ArticleInfo 以及实体接口 比较等
-- 表说明:分类文章信息表
-- 备注:该类以及基类所有方法由"疯狂代码"代码生成器创建 www.crazycoder.cn
-- mail:[email protected]
-- Msn:[email protected]
-- QQ:9095230
-- www.crazycoder.cn
----------------------------------------------------------------------------------------------------
*/
#endregion
namespace CrazyCoder.Entities.News
{
///
/// 数据表Qst_Article实体类基类 主键PK_QST_ARTICLE 外键列表为CategoryID 自增字段 ArticleIDInt32 唯一字段为：
///
[Serializable]
public partial class ArticleInfo : EntitiesBase,IDataEntities,IArticleInfo
{
#region 变量
private static string _tableName = "Qst_Article";
///
/// 实体的数据表名
///
public static string TableName
{
get { return _tableName; }
}
private static string[] _tableColumns;//数据表 中的字段数组
///
/// 数据表 中的字段数组
///
public static string[] TableColumns
{
get {
_tableColumns = new string[25]{"ArticleID","CategoryID","Title","SpecialUrl","Attr","Source","Author","IsPic","IsCommend","IsChecked","IsFocus","IsSpider","SourceUrl","PicUrl","Summary","Content","Hits","ReNum","Digs","DigDowns","LastDigTime","Points","UserGrade","FileName","AddDate"};
return _tableColumns; }
}
///
/// 实体类名
///
public static string EntitiesClassName
{
get { return "ArticleInfo"; }
}
///
/// 实体类基类名
///
public static string EntitiesBaseClassName
{
get { return "ArticleInfoBase"; }
}
#endregion
#region 构造函数
///
/// 默认构造函数 创建新的实例
///
public ArticleInfo()
{
}
#region 构造函数，含所有参数
///
/// 构造函数 创建新的实例
///
///
///
///
///
文章的网址，如果指定的话就直接指向网址
///
文章属性 0为普通文章[GetList]
///
文章来源
///
文章作者[GetList]
///
是否图文[GetList]
///
是否推荐[GetList]
///
是否已审核[GetList]
///
是否焦点新闻[GetList]
///
是否是蜘蛛采集[GetList]
///
文章的来源地址
///
///
///
///
点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
///
评论次数
///
顶的次数
///
踩的次数
///
上次顶的时间
///
文章的点数 阅读文章需要支付的点数
///
用户级别 0为不限制
///
文件名
///
发布时间
public ArticleInfo(System.Int32 _articleID,System.Int32 _categoryID,System.String _title,System.String _specialUrl,System.Int32 _attr,System.String _source,System.String _author,System.Boolean _isPic,System.Boolean _isCommend,System.Boolean _isChecked,System.Boolean _isFocus,System.Boolean _isSpider,System.String _sourceUrl,System.String _picUrl,System.String _summary,System.String _content,System.Int32 _hits,System.Int32 _reNum,System.Int32 _digs,System.Int32 _digDowns,System.DateTime _lastDigTime,System.Int32 _points,System.Int32 _userGrade,System.String _fileName,System.DateTime _addDate)
{
this._articleID = _articleID;
this._categoryID = _categoryID;
this._title = _title;
this._specialUrl = _specialUrl;
this._attr = _attr;
this._source = _source;
this._author = _author;
this._isPic = _isPic;
this._isCommend = _isCommend;
this._isChecked = _isChecked;
this._isFocus = _isFocus;
this._isSpider = _isSpider;
this._sourceUrl = _sourceUrl;
this._picUrl = _picUrl;
this._summary = _summary;
this._content = _content;
this._hits = _hits;
this._reNum = _reNum;
this._digs = _digs;
this._digDowns = _digDowns;
this._lastDigTime = _lastDigTime;
this._points = _points;
this._userGrade = _userGrade;
this._fileName = _fileName;
this._addDate = _addDate;
}
#endregion
#endregion
#region 通过数据构造函数 IDataRecord DataRow DataRowView
#region 使用只读只进的数据流的构造函数 ArticleInfo(IDataRecord dr)
///
/// 使用只读只进的数据流的构造函数
///
///
只读只进的数据流
public ArticleInfo(IDataRecord dr)
{
string rowIndexName = dr.GetName(0);
if (!string.IsNullOrEmpty(rowIndexName) && rowIndexName.ToLower() == "rowindex")
{
//如果返回RowIndex
this.RowIndex = (long)dr[0];
}
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
}
#endregion
#region 使用只读只进的数据流的构造函数ArticleInfo(IDataRecord dr, string[] columnNames)
///
/// 使用只读只进的数据流的构造函数
///
///
只读只进的数据流
///
需要实例化的字段列表
public ArticleInfo(IDataRecord dr, string[] columnNames)
{
if (columnNames == null || columnNames.Length <= 0)
return;
string rowIndexName = dr.GetName(0);
if (!string.IsNullOrEmpty(rowIndexName) && rowIndexName.ToLower() == "rowindex")
{
this.RowIndex = (long)dr[0];
}
foreach (string columnName in columnNames)
{
if (!string.IsNullOrEmpty(columnName))
{
switch (columnName.ToLower())
{
case "articleid":
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
break;
case "categoryid":
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
break;
case "title":
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
break;
case "specialurl":
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
break;
case "attr":
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
break;
case "source":
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
break;
case "author":
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
break;
case "ispic":
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
break;
case "iscommend":
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
break;
case "ischecked":
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
break;
case "isfocus":
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
break;
case "isspider":
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
break;
case "sourceurl":
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
break;
case "picurl":
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
break;
case "summary":
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
break;
case "content":
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
break;
case "hits":
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
break;
case "renum":
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
break;
case "digs":
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
break;
case "digdowns":
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
break;
case "lastdigtime":
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
break;
case "points":
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
break;
case "usergrade":
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
break;
case "filename":
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
break;
case "adddate":
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
break;
default:
break;
}
}
}
}
#endregion
#region 使用只读只进的数据流的构造函数ArticleInfo(IDataRecord dr, ArticleInfoEnumeration[] columnNames)
///
/// 使用只读只进的数据流的构造函数
///
///
只读只进的数据流
///
需要实例化的字段列表
public ArticleInfo(IDataRecord dr, ArticleInfoEnumeration[] columnNames)
{
if (columnNames == null || columnNames.Length <= 0)
return;
string rowIndexName = dr.GetName(0);
if (!string.IsNullOrEmpty(rowIndexName) && rowIndexName.ToLower() == "rowindex")
{
this.RowIndex = (long)dr[0];
}
foreach (ArticleInfoEnumeration columnName in columnNames)
{
switch (columnName)
{
case ArticleInfoEnumeration.ArticleID:
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
break;
case ArticleInfoEnumeration.CategoryID:
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
break;
case ArticleInfoEnumeration.Title:
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
break;
case ArticleInfoEnumeration.SpecialUrl:
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.Attr:
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.Source:
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.Author:
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.IsPic:
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsCommend:
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsChecked:
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsFocus:
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsSpider:
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.SourceUrl:
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.PicUrl:
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.Summary:
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
break;
case ArticleInfoEnumeration.Content:
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
break;
case ArticleInfoEnumeration.Hits:
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.ReNum:
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.Digs:
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.DigDowns:
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.LastDigTime:
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
break;
case ArticleInfoEnumeration.Points:
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.UserGrade:
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.FileName:
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.AddDate:
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
break;
default:
break;
}
}
}
#endregion
#region 使用DataRow构造函数 ArticleInfo(DataRow dr)
///
/// 使用DataRow构造函数
///
///
DataRow
public ArticleInfo(DataRow dr)
{
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
}
#endregion
#region 使用DataRow构造函数 ArticleInfo(DataRow dr, string[] columnNames)
///
/// 使用DataRow构造函数
///
///
DataRow
///
需要实例化的字段列表
public ArticleInfo(DataRow dr, string[] columnNames)
{
if (columnNames == null || columnNames.Length <= 0)
return;
foreach (string columnName in columnNames)
{
if (!string.IsNullOrEmpty(columnName))
{
switch (columnName.ToLower())
{
case "articleid":
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
break;
case "categoryid":
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
break;
case "title":
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
break;
case "specialurl":
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
break;
case "attr":
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
break;
case "source":
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
break;
case "author":
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
break;
case "ispic":
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
break;
case "iscommend":
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
break;
case "ischecked":
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
break;
case "isfocus":
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
break;
case "isspider":
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
break;
case "sourceurl":
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
break;
case "picurl":
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
break;
case "summary":
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
break;
case "content":
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
break;
case "hits":
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
break;
case "renum":
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
break;
case "digs":
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
break;
case "digdowns":
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
break;
case "lastdigtime":
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
break;
case "points":
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
break;
case "usergrade":
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
break;
case "filename":
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
break;
case "adddate":
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
break;
default:
break;
}
}
}
}
#endregion
#region 使用DataRow构造函数 ArticleInfo(DataRow dr, ArticleInfoEnumeration[] columnNames)
///
/// 使用DataRow构造函数
///
///
DataRow
///
需要实例化的字段列表
public ArticleInfo(DataRow dr, ArticleInfoEnumeration[] columnNames)
{
if (columnNames == null || columnNames.Length <= 0)
return;
foreach (ArticleInfoEnumeration columnName in columnNames)
{
switch (columnName)
{
case ArticleInfoEnumeration.ArticleID:
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
break;
case ArticleInfoEnumeration.CategoryID:
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
break;
case ArticleInfoEnumeration.Title:
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
break;
case ArticleInfoEnumeration.SpecialUrl:
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.Attr:
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.Source:
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.Author:
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.IsPic:
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsCommend:
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsChecked:
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsFocus:
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsSpider:
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.SourceUrl:
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.PicUrl:
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.Summary:
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
break;
case ArticleInfoEnumeration.Content:
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
break;
case ArticleInfoEnumeration.Hits:
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.ReNum:
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.Digs:
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.DigDowns:
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.LastDigTime:
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
break;
case ArticleInfoEnumeration.Points:
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.UserGrade:
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.FileName:
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.AddDate:
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
break;
default:
break;
}
}
}
#endregion
#region 使用DataRowView构造函数 ArticleInfo(DataRowView dr)
///
/// 使用DataRowView构造函数
///
///
DataRowView
public ArticleInfo(DataRowView dr)
{
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
}
#endregion
#region 使用DataRowView构造函数 ArticleInfo(DataRowView dr, string[] columnNames)
///
/// 使用DataRowView构造函数
///
///
DataRowView
///
需要实例化的字段列表
public ArticleInfo(DataRowView dr, string[] columnNames)
{
if (columnNames == null || columnNames.Length <= 0)
return;
foreach (string columnName in columnNames)
{
if (!string.IsNullOrEmpty(columnName))
{
switch (columnName.ToLower())
{
case "articleid":
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
break;
case "categoryid":
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
break;
case "title":
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
break;
case "specialurl":
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
break;
case "attr":
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
break;
case "source":
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
break;
case "author":
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
break;
case "ispic":
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
break;
case "iscommend":
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
break;
case "ischecked":
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
break;
case "isfocus":
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
break;
case "isspider":
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
break;
case "sourceurl":
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
break;
case "picurl":
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
break;
case "summary":
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
break;
case "content":
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
break;
case "hits":
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
break;
case "renum":
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
break;
case "digs":
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
break;
case "digdowns":
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
break;
case "lastdigtime":
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
break;
case "points":
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
break;
case "usergrade":
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
break;
case "filename":
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
break;
case "adddate":
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
break;
default:
break;
}
}
}
}
#endregion
#region 使用DataRowView构造函数 ArticleInfo(DataRowView dr, ArticleInfoEnumeration[] columnNames)
///
/// 使用DataRowView构造函数
///
///
DataRowView
///
需要实例化的字段列表
public ArticleInfo(DataRowView dr, ArticleInfoEnumeration[] columnNames)
{
if (columnNames == null || columnNames.Length <= 0)
return;
foreach (ArticleInfoEnumeration columnName in columnNames)
{
switch (columnName)
{
case ArticleInfoEnumeration.ArticleID:
this._articleID = dr["ArticleID"] == DBNull.Value ? 0 : (System.Int32)dr["ArticleID"]; // 数据类型int 大小4 不允许空值
break;
case ArticleInfoEnumeration.CategoryID:
this._categoryID = dr["CategoryID"] == DBNull.Value ? 0 : (System.Int32)dr["CategoryID"]; // 数据类型int 大小4 不允许空值
break;
case ArticleInfoEnumeration.Title:
this._title = dr["Title"] == DBNull.Value ? null : (System.String)dr["Title"]; // 数据类型nvarchar 大小100 不允许空值
break;
case ArticleInfoEnumeration.SpecialUrl:
this._specialUrl = dr["SpecialUrl"] == DBNull.Value ? null : (System.String)dr["SpecialUrl"]; //文章的网址，如果指定的话就直接指向网址 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.Attr:
this._attr = dr["Attr"] == DBNull.Value ? 0 : (System.Int32)dr["Attr"]; //文章属性 0为普通文章[GetList] 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.Source:
this._source = dr["Source"] == DBNull.Value ? null : (System.String)dr["Source"]; //文章来源 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.Author:
this._author = dr["Author"] == DBNull.Value ? null : (System.String)dr["Author"]; //文章作者[GetList] 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.IsPic:
this._isPic = dr["IsPic"] == DBNull.Value ? false : (System.Boolean)dr["IsPic"]; //是否图文[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsCommend:
this._isCommend = dr["IsCommend"] == DBNull.Value ? false : (System.Boolean)dr["IsCommend"]; //是否推荐[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsChecked:
this._isChecked = dr["IsChecked"] == DBNull.Value ? false : (System.Boolean)dr["IsChecked"]; //是否已审核[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsFocus:
this._isFocus = dr["IsFocus"] == DBNull.Value ? false : (System.Boolean)dr["IsFocus"]; //是否焦点新闻[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.IsSpider:
this._isSpider = dr["IsSpider"] == DBNull.Value ? false : (System.Boolean)dr["IsSpider"]; //是否是蜘蛛采集[GetList] 数据类型bit 大小1 允许空值
break;
case ArticleInfoEnumeration.SourceUrl:
this._sourceUrl = dr["SourceUrl"] == DBNull.Value ? "new Guid()" : (System.String)dr["SourceUrl"]; //文章的来源地址 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.PicUrl:
this._picUrl = dr["PicUrl"] == DBNull.Value ? null : (System.String)dr["PicUrl"]; // 数据类型nvarchar 大小200 允许空值
break;
case ArticleInfoEnumeration.Summary:
this._summary = dr["Summary"] == DBNull.Value ? null : (System.String)dr["Summary"]; // 数据类型nvarchar 大小500 允许空值
break;
case ArticleInfoEnumeration.Content:
this._content = dr["Content"] == DBNull.Value ? null : (System.String)dr["Content"]; // 数据类型ntext 大小16 不允许空值
break;
case ArticleInfoEnumeration.Hits:
this._hits = dr["Hits"] == DBNull.Value ? (int)0 : (System.Int32)dr["Hits"]; //点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.ReNum:
this._reNum = dr["ReNum"] == DBNull.Value ? (int)0 : (System.Int32)dr["ReNum"]; //评论次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.Digs:
this._digs = dr["Digs"] == DBNull.Value ? 0 : (System.Int32)dr["Digs"]; //顶的次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.DigDowns:
this._digDowns = dr["DigDowns"] == DBNull.Value ? (int)0 : (System.Int32)dr["DigDowns"]; //踩的次数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.LastDigTime:
this._lastDigTime = dr["LastDigTime"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["LastDigTime"]; //上次顶的时间 数据类型datetime 大小8 允许空值
break;
case ArticleInfoEnumeration.Points:
this._points = dr["Points"] == DBNull.Value ? (int)0 : (System.Int32)dr["Points"]; //文章的点数 阅读文章需要支付的点数 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.UserGrade:
this._userGrade = dr["UserGrade"] == DBNull.Value ? (int)0 : (System.Int32)dr["UserGrade"]; //用户级别 0为不限制 数据类型int 大小4 允许空值
break;
case ArticleInfoEnumeration.FileName:
this._fileName = dr["FileName"] == DBNull.Value ? null : (System.String)dr["FileName"]; //文件名 数据类型nvarchar 大小50 允许空值
break;
case ArticleInfoEnumeration.AddDate:
this._addDate = dr["AddDate"] == DBNull.Value ? DateTime.Now : (System.DateTime)dr["AddDate"]; //发布时间 数据类型datetime 大小8 允许空值
break;
default:
break;
}
}
}
#endregion
#endregion
#region 数据列属性
private System.Int32 _articleID;//
private System.Int32 _categoryID;//
private System.String _title;//
private System.String _specialUrl;//文章的网址，如果指定的话就直接指向网址
private System.Int32 _attr;//文章属性 0为普通文章[GetList]
private System.String _source;//文章来源
private System.String _author;//文章作者[GetList]
private System.Boolean _isPic;//是否图文[GetList]
private System.Boolean _isCommend;//是否推荐[GetList]
private System.Boolean _isChecked;//是否已审核[GetList]
private System.Boolean _isFocus;//是否焦点新闻[GetList]
private System.Boolean _isSpider;//是否是蜘蛛采集[GetList]
private System.String _sourceUrl;//文章的来源地址
private System.String _picUrl;//
private System.String _summary;//
private System.String _content;//
private System.Int32 _hits;//点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
private System.Int32 _reNum;//评论次数
private System.Int32 _digs;//顶的次数
private System.Int32 _digDowns;//踩的次数
private System.DateTime _lastDigTime;//上次顶的时间
private System.Int32 _points;//文章的点数 阅读文章需要支付的点数
private System.Int32 _userGrade;//用户级别 0为不限制
private System.String _fileName;//文件名
private System.DateTime _addDate;//发布时间
///
/// 获取或者设置 ArticleID 属性.
///
///
///
///
/// 该属性 不能设置为空
///
public System.Int32 ArticleID
{
get { return _articleID; }
set {
if (_articleID == value)
{
return;
}
_articleID = value; }
}
///
/// 获取或者设置 CategoryID 属性.
///
///
///
///
/// 该属性 不能设置为空
///
public System.Int32 CategoryID
{
get { return _categoryID; }
set {
if (_categoryID == value)
{
return;
}
_categoryID = value; }
}
///
/// 获取或者设置 Title 属性.
///
///
///
///
/// 该属性 不能设置为空
///
public System.String Title
{
get { return _title; }
set {
if (_title == value)
{
return;
}
_title = value; }
}
///
/// 获取或者设置 SpecialUrl 属性.
/// 文章的网址，如果指定的话就直接指向网址
///
///
///
/// 该属性 能设置为空
///
public System.String SpecialUrl
{
get { return _specialUrl; }
set {
if (_specialUrl == value)
{
return;
}
_specialUrl = value; }
}
///
/// 获取或者设置 Attr 属性.
/// 文章属性 0为普通文章[GetList]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 Attr
{
get { return _attr; }
set {
if (_attr == value)
{
return;
}
_attr = value; }
}
///
/// 获取或者设置 Source 属性.
/// 文章来源
///
///
///
/// 该属性 能设置为空
///
public System.String Source
{
get { return _source; }
set {
if (_source == value)
{
return;
}
_source = value; }
}
///
/// 获取或者设置 Author 属性.
/// 文章作者[GetList]
///
///
///
/// 该属性 能设置为空
///
public System.String Author
{
get { return _author; }
set {
if (_author == value)
{
return;
}
_author = value; }
}
///
/// 获取或者设置 IsPic 属性.
/// 是否图文[GetList]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 false
///
public System.Boolean IsPic
{
get { return _isPic; }
set {
if (_isPic == value)
{
return;
}
_isPic = value; }
}
///
/// 获取或者设置 IsCommend 属性.
/// 是否推荐[GetList]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 false
///
public System.Boolean IsCommend
{
get { return _isCommend; }
set {
if (_isCommend == value)
{
return;
}
_isCommend = value; }
}
///
/// 获取或者设置 IsChecked 属性.
/// 是否已审核[GetList]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 false
///
public System.Boolean IsChecked
{
get { return _isChecked; }
set {
if (_isChecked == value)
{
return;
}
_isChecked = value; }
}
///
/// 获取或者设置 IsFocus 属性.
/// 是否焦点新闻[GetList]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 false
///
public System.Boolean IsFocus
{
get { return _isFocus; }
set {
if (_isFocus == value)
{
return;
}
_isFocus = value; }
}
///
/// 获取或者设置 IsSpider 属性.
/// 是否是蜘蛛采集[GetList]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 false
///
public System.Boolean IsSpider
{
get { return _isSpider; }
set {
if (_isSpider == value)
{
return;
}
_isSpider = value; }
}
///
/// 获取或者设置 SourceUrl 属性.
/// 文章的来源地址
///
///
///
/// 该属性 能设置为空
///
public System.String SourceUrl
{
get { return _sourceUrl; }
set {
if (_sourceUrl == value)
{
return;
}
_sourceUrl = value; }
}
///
/// 获取或者设置 PicUrl 属性.
///
///
///
///
/// 该属性 能设置为空
///
public System.String PicUrl
{
get { return _picUrl; }
set {
if (_picUrl == value)
{
return;
}
_picUrl = value; }
}
///
/// 获取或者设置 Summary 属性.
///
///
///
///
/// 该属性 能设置为空
///
public System.String Summary
{
get { return _summary; }
set {
if (_summary == value)
{
return;
}
_summary = value; }
}
///
/// 获取或者设置 Content 属性.
///
///
///
///
/// 该属性 不能设置为空
///
public System.String Content
{
get { return _content; }
set {
if (_content == value)
{
return;
}
_content = value; }
}
///
/// 获取或者设置 Hits 属性.
/// 点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 Hits
{
get { return _hits; }
set {
if (_hits == value)
{
return;
}
_hits = value; }
}
///
/// 获取或者设置 ReNum 属性.
/// 评论次数
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 ReNum
{
get { return _reNum; }
set {
if (_reNum == value)
{
return;
}
_reNum = value; }
}
///
/// 获取或者设置 Digs 属性.
/// 顶的次数
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 Digs
{
get { return _digs; }
set {
if (_digs == value)
{
return;
}
_digs = value; }
}
///
/// 获取或者设置 DigDowns 属性.
/// 踩的次数
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 DigDowns
{
get { return _digDowns; }
set {
if (_digDowns == value)
{
return;
}
_digDowns = value; }
}
///
/// 获取或者设置 LastDigTime 属性.
/// 上次顶的时间
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 DateTime.MinValue
///
public System.DateTime LastDigTime
{
get { return _lastDigTime; }
set {
if (_lastDigTime == value)
{
return;
}
_lastDigTime = value; }
}
///
/// 获取或者设置 Points 属性.
/// 文章的点数 阅读文章需要支付的点数
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 Points
{
get { return _points; }
set {
if (_points == value)
{
return;
}
_points = value; }
}
///
/// 获取或者设置 UserGrade 属性.
/// 用户级别 0为不限制
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 (int)0
///
public System.Int32 UserGrade
{
get { return _userGrade; }
set {
if (_userGrade == value)
{
return;
}
_userGrade = value; }
}
///
/// 获取或者设置 FileName 属性.
/// 文件名
///
///
///
/// 该属性 能设置为空
///
public System.String FileName
{
get { return _fileName; }
set {
if (_fileName == value)
{
return;
}
_fileName = value; }
}
///
/// 获取或者设置 AddDate 属性.
/// 发布时间
///
///
///
/// 该属性 能设置为空
/// 如果该属性设置为Null,那么返回 DateTime.MinValue
///
public System.DateTime AddDate
{
get { return _addDate; }
set {
if (_addDate == value)
{
return;
}
_addDate = value; }
}
#endregion
#region 序列化和反序列化 静态方法
///
/// 将对象序列化到文件
///
///
需要保存的路径
///
public bool Serialize(string path)
{
return Serialize(path, this);
}
///
/// 将对象序列化
///
///
需要保存的路径
///
ArticleInfo对象
///
public static bool Serialize(string path, ArticleInfo objArticleInfo)
{
try
{
string dirName = System.IO.Path.GetDirectoryName(path);
if (!Directory.Exists(dirName))
{
Directory.CreateDirectory(dirName);
}
FileStream fs = new FileStream(path, FileMode.Create);
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(fs, objArticleInfo);
fs.Close();
fs.Dispose();
return true;
}
catch
{
return false;
}
}
///
/// 将对象反序列化
///
///
源对象的路径
///
public static ArticleInfo DeSerialize(string path)
{
try
{
FileStream fs = new FileStream(path, FileMode.Open);
BinaryFormatter formatter = new BinaryFormatter();
ArticleInfo objArticleInfo = (ArticleInfo)formatter.Deserialize(fs);
fs.Close();
fs.Dispose();
return objArticleInfo;
}
catch
{
return null;
}
}
#endregion
#region 字符串序列化
///
/// 将对象转化为以逗号分割的字符串列表，类似序列化
///
///
public string ToSplitString()
{
StringBuilder sb = new StringBuilder();
sb.Append(_tableName);
sb.Append(",");
sb.Append(this._articleID);
sb.Append(",");
sb.Append(this._categoryID);
sb.Append(",");
sb.Append(this._title);
sb.Append(",");
sb.Append(this._specialUrl);
sb.Append(",");
sb.Append(this._attr);
sb.Append(",");
sb.Append(this._source);
sb.Append(",");
sb.Append(this._author);
sb.Append(",");
sb.Append(this._isPic);
sb.Append(",");
sb.Append(this._isCommend);
sb.Append(",");
sb.Append(this._isChecked);
sb.Append(",");
sb.Append(this._isFocus);
sb.Append(",");
sb.Append(this._isSpider);
sb.Append(",");
sb.Append(this._sourceUrl);
sb.Append(",");
sb.Append(this._picUrl);
sb.Append(",");
sb.Append(this._summary);
sb.Append(",");
sb.Append(this._content);
sb.Append(",");
sb.Append(this._hits);
sb.Append(",");
sb.Append(this._reNum);
sb.Append(",");
sb.Append(this._digs);
sb.Append(",");
sb.Append(this._digDowns);
sb.Append(",");
sb.Append(this._lastDigTime);
sb.Append(",");
sb.Append(this._points);
sb.Append(",");
sb.Append(this._userGrade);
sb.Append(",");
sb.Append(this._fileName);
sb.Append(",");
sb.Append(this._addDate);
return sb.ToString();
}
///
/// 从字符串中初始化对象，类似反序列化
///
///
对象字符串
public void FormSplitString(string objString)
{
if (objString == null)
{
return;
}
string[] objs = objString.Split(Convert.ToChar(","));
if (objs.Length != 26)
{
return;
}
if (objs[1] != null || objs[1].Length >= 1)
{
this._articleID = System.Int32.Parse(objs[1]);
}
if (objs[2] != null || objs[2].Length >= 1)
{
this._categoryID = System.Int32.Parse(objs[2]);
}
if (objs[3] != null || objs[3].Length >= 1)
{
this._title = objs[3];
}
if (objs[4] != null || objs[4].Length >= 1)
{
this._specialUrl = objs[4];
}
if (objs[5] != null || objs[5].Length >= 1)
{
this._attr = System.Int32.Parse(objs[5]);
}
if (objs[6] != null || objs[6].Length >= 1)
{
this._source = objs[6];
}
if (objs[7] != null || objs[7].Length >= 1)
{
this._author = objs[7];
}
if (objs[8] != null || objs[8].Length >= 1)
{
this._isPic = System.Boolean.Parse(objs[8]);
}
if (objs[9] != null || objs[9].Length >= 1)
{
this._isCommend = System.Boolean.Parse(objs[9]);
}
if (objs[10] != null || objs[10].Length >= 1)
{
this._isChecked = System.Boolean.Parse(objs[10]);
}
if (objs[11] != null || objs[11].Length >= 1)
{
this._isFocus = System.Boolean.Parse(objs[11]);
}
if (objs[12] != null || objs[12].Length >= 1)
{
this._isSpider = System.Boolean.Parse(objs[12]);
}
if (objs[13] != null || objs[13].Length >= 1)
{
this._sourceUrl = objs[13];
}
if (objs[14] != null || objs[14].Length >= 1)
{
this._picUrl = objs[14];
}
if (objs[15] != null || objs[15].Length >= 1)
{
this._summary = objs[15];
}
if (objs[16] != null || objs[16].Length >= 1)
{
this._content = objs[16];
}
if (objs[17] != null || objs[17].Length >= 1)
{
this._hits = System.Int32.Parse(objs[17]);
}
if (objs[18] != null || objs[18].Length >= 1)
{
this._reNum = System.Int32.Parse(objs[18]);
}
if (objs[19] != null || objs[19].Length >= 1)
{
this._digs = System.Int32.Parse(objs[19]);
}
if (objs[20] != null || objs[20].Length >= 1)
{
this._digDowns = System.Int32.Parse(objs[20]);
}
if (objs[21] != null || objs[21].Length >= 1)
{
this._lastDigTime = System.DateTime.Parse(objs[21]);
}
if (objs[22] != null || objs[22].Length >= 1)
{
this._points = System.Int32.Parse(objs[22]);
}
if (objs[23] != null || objs[23].Length >= 1)
{
this._userGrade = System.Int32.Parse(objs[23]);
}
if (objs[24] != null || objs[24].Length >= 1)
{
this._fileName = objs[24];
}
if (objs[25] != null || objs[25].Length >= 1)
{
this._addDate = System.DateTime.Parse(objs[25]);
}
}
#endregion
#region 将对象转化为Url连接字符串 string ToUrlEncodeLinkString()
///
/// 将对象转化为Url连接字符串
///
///
public string ToUrlEncodeLinkString()
{
System.Text.StringBuilder sbStr = new System.Text.StringBuilder(1024);
sbStr.Append("&ArticleID=").Append(System.Web.HttpUtility.UrlEncode(this._articleID.ToString()));
sbStr.Append("&CategoryID=").Append(System.Web.HttpUtility.UrlEncode(this._categoryID.ToString()));
if (!string.IsNullOrEmpty(this._title))
{
sbStr.Append("&Title=").Append(System.Web.HttpUtility.UrlEncode(this._title));
}
if (!string.IsNullOrEmpty(this._specialUrl))
{
sbStr.Append("&SpecialUrl=").Append(System.Web.HttpUtility.UrlEncode(this._specialUrl));
}
sbStr.Append("&Attr=").Append(System.Web.HttpUtility.UrlEncode(this._attr.ToString()));
if (!string.IsNullOrEmpty(this._source))
{
sbStr.Append("&Source=").Append(System.Web.HttpUtility.UrlEncode(this._source));
}
if (!string.IsNullOrEmpty(this._author))
{
sbStr.Append("&Author=").Append(System.Web.HttpUtility.UrlEncode(this._author));
}
sbStr.Append("&IsPic=").Append(System.Web.HttpUtility.UrlEncode(this._isPic.ToString()));
sbStr.Append("&IsCommend=").Append(System.Web.HttpUtility.UrlEncode(this._isCommend.ToString()));
sbStr.Append("&IsChecked=").Append(System.Web.HttpUtility.UrlEncode(this._isChecked.ToString()));
sbStr.Append("&IsFocus=").Append(System.Web.HttpUtility.UrlEncode(this._isFocus.ToString()));
sbStr.Append("&IsSpider=").Append(System.Web.HttpUtility.UrlEncode(this._isSpider.ToString()));
if (!string.IsNullOrEmpty(this._sourceUrl))
{
sbStr.Append("&SourceUrl=").Append(System.Web.HttpUtility.UrlEncode(this._sourceUrl));
}
if (!string.IsNullOrEmpty(this._picUrl))
{
sbStr.Append("&PicUrl=").Append(System.Web.HttpUtility.UrlEncode(this._picUrl));
}
if (!string.IsNullOrEmpty(this._summary))
{
sbStr.Append("&Summary=").Append(System.Web.HttpUtility.UrlEncode(this._summary));
}
if (!string.IsNullOrEmpty(this._content))
{
sbStr.Append("&Content=").Append(System.Web.HttpUtility.UrlEncode(this._content));
}
sbStr.Append("&Hits=").Append(System.Web.HttpUtility.UrlEncode(this._hits.ToString()));
sbStr.Append("&ReNum=").Append(System.Web.HttpUtility.UrlEncode(this._reNum.ToString()));
sbStr.Append("&Digs=").Append(System.Web.HttpUtility.UrlEncode(this._digs.ToString()));
sbStr.Append("&DigDowns=").Append(System.Web.HttpUtility.UrlEncode(this._digDowns.ToString()));
sbStr.Append("&LastDigTime=").Append(System.Web.HttpUtility.UrlEncode(this._lastDigTime.ToString()));
sbStr.Append("&Points=").Append(System.Web.HttpUtility.UrlEncode(this._points.ToString()));
sbStr.Append("&UserGrade=").Append(System.Web.HttpUtility.UrlEncode(this._userGrade.ToString()));
if (!string.IsNullOrEmpty(this._fileName))
{
sbStr.Append("&FileName=").Append(System.Web.HttpUtility.UrlEncode(this._fileName));
}
sbStr.Append("&AddDate=").Append(System.Web.HttpUtility.UrlEncode(this._addDate.ToString()));
return sbStr.ToString();
}
#endregion
#region 将对象转化为Url Javascript格式的Escape连接字符串 string ToUrlEscapeString()
///
/// 将对象转化为Url连接字符串
///
///
public string ToUrlEscapeString()
{
System.Text.StringBuilder sbStr = new System.Text.StringBuilder(1024);
sbStr.Append("&ArticleID=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._articleID.ToString()));
sbStr.Append("&CategoryID=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._categoryID.ToString()));
if (!string.IsNullOrEmpty(this._title))
{
sbStr.Append("&Title=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._title));
}
if (!string.IsNullOrEmpty(this._specialUrl))
{
sbStr.Append("&SpecialUrl=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._specialUrl));
}
sbStr.Append("&Attr=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._attr.ToString()));
if (!string.IsNullOrEmpty(this._source))
{
sbStr.Append("&Source=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._source));
}
if (!string.IsNullOrEmpty(this._author))
{
sbStr.Append("&Author=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._author));
}
sbStr.Append("&IsPic=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._isPic.ToString()));
sbStr.Append("&IsCommend=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._isCommend.ToString()));
sbStr.Append("&IsChecked=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._isChecked.ToString()));
sbStr.Append("&IsFocus=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._isFocus.ToString()));
sbStr.Append("&IsSpider=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._isSpider.ToString()));
if (!string.IsNullOrEmpty(this._sourceUrl))
{
sbStr.Append("&SourceUrl=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._sourceUrl));
}
if (!string.IsNullOrEmpty(this._picUrl))
{
sbStr.Append("&PicUrl=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._picUrl));
}
if (!string.IsNullOrEmpty(this._summary))
{
sbStr.Append("&Summary=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._summary));
}
if (!string.IsNullOrEmpty(this._content))
{
sbStr.Append("&Content=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._content));
}
sbStr.Append("&Hits=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._hits.ToString()));
sbStr.Append("&ReNum=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._reNum.ToString()));
sbStr.Append("&Digs=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._digs.ToString()));
sbStr.Append("&DigDowns=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._digDowns.ToString()));
sbStr.Append("&LastDigTime=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._lastDigTime.ToString()));
sbStr.Append("&Points=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._points.ToString()));
sbStr.Append("&UserGrade=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._userGrade.ToString()));
if (!string.IsNullOrEmpty(this._fileName))
{
sbStr.Append("&FileName=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._fileName));
}
sbStr.Append("&AddDate=").Append(System.Web.HttpUtility.UrlEncodeUnicode(this._addDate.ToString()));
return sbStr.ToString();
}
#endregion
#region 复制对象，返回一个新对象 virtual ArticleInfo Copy()
///
/// 复制对象，返回一个新对象
///
///
public virtual ArticleInfo Copy()
{
ArticleInfo copy = new ArticleInfo();
copy.RowIndex = this.RowIndex;
copy.ArticleID = this.ArticleID;
copy.CategoryID = this.CategoryID;
copy.Title = this.Title;
copy.SpecialUrl = this.SpecialUrl;
copy.Attr = this.Attr;
copy.Source = this.Source;
copy.Author = this.Author;
copy.IsPic = this.IsPic;
copy.IsCommend = this.IsCommend;
copy.IsChecked = this.IsChecked;
copy.IsFocus = this.IsFocus;
copy.IsSpider = this.IsSpider;
copy.SourceUrl = this.SourceUrl;
copy.PicUrl = this.PicUrl;
copy.Summary = this.Summary;
copy.Content = this.Content;
copy.Hits = this.Hits;
copy.ReNum = this.ReNum;
copy.Digs = this.Digs;
copy.DigDowns = this.DigDowns;
copy.LastDigTime = this.LastDigTime;
copy.Points = this.Points;
copy.UserGrade = this.UserGrade;
copy.FileName = this.FileName;
copy.AddDate = this.AddDate;
return copy;
}
#endregion
#region 返回两个对象是否相等 virtual bool Equals(ArticleInfo toObject static bool Equals(ArticleInfo Object1, ArticleInfo Object2)
///
/// 返回是否与指定对象相等
///
///
///
public virtual bool Equals(ArticleInfo toObject)
{
if (toObject == null)
return false;
return Equals(this, toObject);
}
///
/// 判断两个对象是否相等
///
///
ArticleInfo实体
///
ArticleInfo实体
///
public static bool Equals(ArticleInfo Object1, ArticleInfo Object2)
{
if (Object1 == null && Object2 == null)
return true;
if (Object1 == null ^ Object2 == null)
return false;
bool equal = true;
if (Object1.ArticleID != Object2.ArticleID)
return false;
if (Object1.CategoryID != Object2.CategoryID)
return false;
if (Object1.Title != null && Object2.Title != null)
{
if (Object1.Title != Object2.Title)
return false;
}
else if (Object1.Title == null ^ Object2.Title == null)
{
return false;
}
if (Object1.SpecialUrl != null && Object2.SpecialUrl != null)
{
if (Object1.SpecialUrl != Object2.SpecialUrl)
return false;
}
else if (Object1.SpecialUrl == null ^ Object2.SpecialUrl == null)
{
return false;
}
if (Object1.Attr != Object2.Attr)
return false;
if (Object1.Source != null && Object2.Source != null)
{
if (Object1.Source != Object2.Source)
return false;
}
else if (Object1.Source == null ^ Object2.Source == null)
{
return false;
}
if (Object1.Author != null && Object2.Author != null)
{
if (Object1.Author != Object2.Author)
return false;
}
else if (Object1.Author == null ^ Object2.Author == null)
{
return false;
}
if (Object1.IsPic != Object2.IsPic)
return false;
if (Object1.IsCommend != Object2.IsCommend)
return false;
if (Object1.IsChecked != Object2.IsChecked)
return false;
if (Object1.IsFocus != Object2.IsFocus)
return false;
if (Object1.IsSpider != Object2.IsSpider)
return false;
if (Object1.SourceUrl != null && Object2.SourceUrl != null)
{
if (Object1.SourceUrl != Object2.SourceUrl)
return false;
}
else if (Object1.SourceUrl == null ^ Object2.SourceUrl == null)
{
return false;
}
if (Object1.PicUrl != null && Object2.PicUrl != null)
{
if (Object1.PicUrl != Object2.PicUrl)
return false;
}
else if (Object1.PicUrl == null ^ Object2.PicUrl == null)
{
return false;
}
if (Object1.Summary != null && Object2.Summary != null)
{
if (Object1.Summary != Object2.Summary)
return false;
}
else if (Object1.Summary == null ^ Object2.Summary == null)
{
return false;
}
if (Object1.Content != null && Object2.Content != null)
{
if (Object1.Content != Object2.Content)
return false;
}
else if (Object1.Content == null ^ Object2.Content == null)
{
return false;
}
if (Object1.Hits != Object2.Hits)
return false;
if (Object1.ReNum != Object2.ReNum)
return false;
if (Object1.Digs != Object2.Digs)
return false;
if (Object1.DigDowns != Object2.DigDowns)
return false;
if (Object1.LastDigTime != Object2.LastDigTime)
return false;
if (Object1.Points != Object2.Points)
return false;
if (Object1.UserGrade != Object2.UserGrade)
return false;
if (Object1.FileName != null && Object2.FileName != null)
{
if (Object1.FileName != Object2.FileName)
return false;
}
else if (Object1.FileName == null ^ Object2.FileName == null)
{
return false;
}
if (Object1.AddDate != Object2.AddDate)
return false;
return equal;
}
#endregion
#region 返回实体数据表字段的Xml Map ToDataEntitiesMap()
///
/// 返回实体数据表字段的Xml Map
///
///
public static string ToDataEntitiesMap()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("\n");
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
return sb.ToString();
}
#endregion
#region ToXml 返回存储在实体类中的Xml表现形式
///
/// 返回存储在实体类中的Xml表现形式
///
///
public string ToXml()
{
System.Xml.Serialization.XmlSerializer xs = new System.Xml.Serialization.XmlSerializer(typeof(ArticleInfo), "http://www.crazycoder.cn/coder/entitiesnamespace");
MemoryStream stream = new MemoryStream();
System.Xml.XmlWriterSettings setting = new System.Xml.XmlWriterSettings();
setting.Encoding = new UTF8Encoding(false);
setting.Indent = true;
using (System.Xml.XmlWriter writer = System.Xml.XmlWriter.Create(stream, setting))
{
xs.Serialize(writer, this);
}
return Encoding.UTF8.GetString(stream.ToArray());
}
#endregion
#region FromXml 从Xml字符串中反序列化获得实体类
///
/// 从Xml字符串中反序列化获得实体类
///
///
Xml
///
public static ArticleInfo FromXml(string xml)
{
return FromXml(xml, System.Text.Encoding.UTF8);
}
///
/// 从Xml字符串中反序列化获得实体类
///
///
Xml
///
public static ArticleInfo FromXml(string xml, System.Text.Encoding encoding)
{
byte[] bt = encoding.GetBytes(xml);
System.IO.Stream sm = (System.IO.Stream)new System.IO.MemoryStream(bt);
System.IO.TextReader tr = new System.IO.StreamReader(sm);
System.Xml.Serialization.XmlSerializer ser = new System.Xml.Serialization.XmlSerializer(typeof(ArticleInfo));
ArticleInfo obj = (ArticleInfo)ser.Deserialize(tr);
tr.Close();
sm.Close();
return obj;
}
#endregion
#region 获取哈希值 override int GetHashCode()
///
/// 获取哈希值
///
///
public override int GetHashCode()
{
return this.ArticleID.GetHashCode() ^
this.CategoryID.GetHashCode() ^
((this.Title == null) ? string.Empty : this.Title).GetHashCode() ^
((this.SpecialUrl == null) ? string.Empty : this.SpecialUrl).GetHashCode() ^
this.Attr.GetHashCode() ^
((this.Source == null) ? string.Empty : this.Source).GetHashCode() ^
((this.Author == null) ? string.Empty : this.Author).GetHashCode() ^
this.IsPic.GetHashCode() ^
this.IsCommend.GetHashCode() ^
this.IsChecked.GetHashCode() ^
this.IsFocus.GetHashCode() ^
this.IsSpider.GetHashCode() ^
((this.SourceUrl == null) ? string.Empty : this.SourceUrl).GetHashCode() ^
((this.PicUrl == null) ? string.Empty : this.PicUrl).GetHashCode() ^
((this.Summary == null) ? string.Empty : this.Summary).GetHashCode() ^
((this.Content == null) ? string.Empty : this.Content).GetHashCode() ^
this.Hits.GetHashCode() ^
this.ReNum.GetHashCode() ^
this.Digs.GetHashCode() ^
this.DigDowns.GetHashCode() ^
this.LastDigTime.GetHashCode() ^
this.Points.GetHashCode() ^
this.UserGrade.GetHashCode() ^
((this.FileName == null) ? string.Empty : this.FileName).GetHashCode() ^
this.AddDate.GetHashCode();
}
#endregion
#region 输出表定义的Sql语句 static string ToTableSql()
///
/// 输出表定义的Sql语句
///
///
public static string ToTableSql()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("alter table dbo.[dbo.Qst_Article]\n");
sb.Append(" drop constraint FK_ArticleToCategory\n");
sb.Append("go\n");
sb.Append("if exists (select 1\n");
sb.Append(" from sysobjects\n");
sb.Append(" where id = object_id('dbo.Qst_Article')\n");
sb.Append(" and type = 'U')\n");
sb.Append(" drop table dbo.Qst_Article\n");
sb.Append("go\n");
sb.Append("/*==============================================================*/\n");
sb.Append("/* Table: Qst_Article */\n");
sb.Append("/* 创建人: 分类文章信息表 */\n");
sb.Append("/* 创建时间: 星期二, 2008年5月20日 */\n");
sb.Append("/*==============================================================*/\n");
sb.Append("create table dbo.[Qst_Article] (\n");
sb.Append(" [ArticleID] int NOT NULL identity,\n");
sb.Append(" [CategoryID] int NOT NULL ,\n");
sb.Append(" [Title] nvarchar(100) NOT NULL ,\n");
sb.Append(" [SpecialUrl] nvarchar(200) ,\n");
sb.Append(" [Attr] int ,\n");
sb.Append(" [Source] nvarchar(50) ,\n");
sb.Append(" [Author] nvarchar(50) ,\n");
sb.Append(" [IsPic] bit default ((0)) ,\n");
sb.Append(" [IsCommend] bit default ((0)) ,\n");
sb.Append(" [IsChecked] bit default ((0)) ,\n");
sb.Append(" [IsFocus] bit default ((0)) ,\n");
sb.Append(" [IsSpider] bit default ((0)) ,\n");
sb.Append(" [SourceUrl] nvarchar(200) default (newid()) ,\n");
sb.Append(" [PicUrl] nvarchar(200) ,\n");
sb.Append(" [Summary] nvarchar(500) ,\n");
sb.Append(" [Content] ntext NOT NULL ,\n");
sb.Append(" [Hits] int default ((0)) ,\n");
sb.Append(" [ReNum] int default ((0)) ,\n");
sb.Append(" [Digs] int ,\n");
sb.Append(" [DigDowns] int default ((0)) ,\n");
sb.Append(" [LastDigTime] datetime default (getdate()) ,\n");
sb.Append(" [Points] int default ((0)) ,\n");
sb.Append(" [UserGrade] int default ((0)) ,\n");
sb.Append(" [FileName] nvarchar(50) ,\n");
sb.Append(" [AddDate] datetime default (getdate()) ,\n");
sb.Append(" constraint PK_QST_ARTICLE primary key (ArticleID)\n");
sb.Append(")\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '分类文章信息表',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文章的网址，如果指定的话就直接指向网址',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'SpecialUrl'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文章属性 0为普通文章[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'Attr'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文章来源',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'Source'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文章作者[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'Author'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '是否图文[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'IsPic'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '是否推荐[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'IsCommend'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '是否已审核[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'IsChecked'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '是否焦点新闻[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'IsFocus'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '是否是蜘蛛采集[GetList]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'IsSpider'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文章的来源地址',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'SourceUrl'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '点击次数[GetList type=\"1\" orderby=\"Hits desc,ArticleID desc\"]',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'Hits'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '评论次数',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'ReNum'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '顶的次数',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'Digs'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '踩的次数',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'DigDowns'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '上次顶的时间',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'LastDigTime'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文章的点数 阅读文章需要支付的点数',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'Points'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '用户级别 0为不限制',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'UserGrade'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '文件名',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'FileName'\n");
sb.Append("go\n");
sb.Append("execute sp_addextendedproperty 'MS_Description', \n");
sb.Append(" '发布时间',\n");
sb.Append(" 'user', 'dbo', 'table', 'Qst_Article', 'column', 'AddDate'\n");
sb.Append("go\n");
sb.Append("alter table dbo.[Qst_Article]\n");
sb.Append(" add constraint FK_ArticleToCategory foreign key (CategoryID)\n");
sb.Append(" references dbo.[Qst_Category] (CategoryID)\n");
sb.Append("go\n");
return sb.ToString();
}
#endregion
}
#region 实体接口类
///
/// 数据表Qst_Article 的实体类 ArticleInfo 的接口
///
public partial interface IArticleInfo : IDataEntities
{
#region 属性
///
///
///
System.Int32 ArticleID{ get; set; }
///
///
///
System.Int32 CategoryID{ get; set; }
///
///
///
System.String Title{ get; set; }
///
/// 文章的网址，如果指定的话就直接指向网址
///
System.String SpecialUrl{ get; set; }
///
/// 文章属性 0为普通文章[GetList]
///
System.Int32 Attr{ get; set; }
///
/// 文章来源
///
System.String Source{ get; set; }
///
/// 文章作者[GetList]
///
System.String Author{ get; set; }
///
/// 是否图文[GetList]
///
System.Boolean IsPic{ get; set; }
///
/// 是否推荐[GetList]
///
System.Boolean IsCommend{ get; set; }
///
/// 是否已审核[GetList]
///
System.Boolean IsChecked{ get; set; }
///
/// 是否焦点新闻[GetList]
///
System.Boolean IsFocus{ get; set; }
///
/// 是否是蜘蛛采集[GetList]
///
System.Boolean IsSpider{ get; set; }
///
/// 文章的来源地址
///
System.String SourceUrl{ get; set; }
///
///
///
System.String PicUrl{ get; set; }
///
///
///
System.String Summary{ get; set; }
///
///
///
System.String Content{ get; set; }
///
/// 点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
///
System.Int32 Hits{ get; set; }
///
/// 评论次数
///
System.Int32 ReNum{ get; set; }
///
/// 顶的次数
///
System.Int32 Digs{ get; set; }
///
/// 踩的次数
///
System.Int32 DigDowns{ get; set; }
///
/// 上次顶的时间
///
System.DateTime LastDigTime{ get; set; }
///
/// 文章的点数 阅读文章需要支付的点数
///
System.Int32 Points{ get; set; }
///
/// 用户级别 0为不限制
///
System.Int32 UserGrade{ get; set; }
///
/// 文件名
///
System.String FileName{ get; set; }
///
/// 发布时间
///
System.DateTime AddDate{ get; set; }
#endregion
#region 方法
/// 复制对象，返回一个新对象
///
///
ArticleInfo Copy();
///
/// 返回两个对象是否相等
///
///
///
bool Equals(ArticleInfo toObject);
#endregion
}
#endregion
#region 表 的字段枚举
///
/// 表Qst_Article的字段枚举
///
public enum ArticleInfoEnumeration
{
///
/// 默认属性，表示未知属性 枚举值为0
///
Undefined = 0,
///
/// ArticleID : 1
///
[EnumTextValue("ArticleID")]
[ColumnEnum("ArticleID", typeof(System.Int32), System.Data.DbType.Int32, true, true, false, true,4)]
ArticleID = 1,
///
/// CategoryID : 2
///
[EnumTextValue("CategoryID")]
[ColumnEnum("CategoryID", typeof(System.Int32), System.Data.DbType.Int32, false, false, false, false,4)]
CategoryID = 2,
///
/// Title : 3
///
[EnumTextValue("Title")]
[ColumnEnum("Title", typeof(System.String), System.Data.DbType.String, false, false, false, false,100)]
Title = 3,
///
/// SpecialUrl : 4 文章的网址，如果指定的话就直接指向网址
///
[EnumTextValue("SpecialUrl")]
[ColumnEnum("SpecialUrl", typeof(System.String), System.Data.DbType.String, false, false, true, false,200)]
SpecialUrl = 4,
///
/// Attr : 5 文章属性 0为普通文章[GetList]
///
[EnumTextValue("Attr")]
[ColumnEnum("Attr", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
Attr = 5,
///
/// Source : 6 文章来源
///
[EnumTextValue("Source")]
[ColumnEnum("Source", typeof(System.String), System.Data.DbType.String, false, false, true, false,50)]
Source = 6,
///
/// Author : 7 文章作者[GetList]
///
[EnumTextValue("Author")]
[ColumnEnum("Author", typeof(System.String), System.Data.DbType.String, false, false, true, false,50)]
Author = 7,
///
/// IsPic : 8 是否图文[GetList]
///
[EnumTextValue("IsPic")]
[ColumnEnum("IsPic", typeof(System.Boolean), System.Data.DbType.Boolean, false, false, true, false,1)]
IsPic = 8,
///
/// IsCommend : 9 是否推荐[GetList]
///
[EnumTextValue("IsCommend")]
[ColumnEnum("IsCommend", typeof(System.Boolean), System.Data.DbType.Boolean, false, false, true, false,1)]
IsCommend = 9,
///
/// IsChecked : 10 是否已审核[GetList]
///
[EnumTextValue("IsChecked")]
[ColumnEnum("IsChecked", typeof(System.Boolean), System.Data.DbType.Boolean, false, false, true, false,1)]
IsChecked = 10,
///
/// IsFocus : 11 是否焦点新闻[GetList]
///
[EnumTextValue("IsFocus")]
[ColumnEnum("IsFocus", typeof(System.Boolean), System.Data.DbType.Boolean, false, false, true, false,1)]
IsFocus = 11,
///
/// IsSpider : 12 是否是蜘蛛采集[GetList]
///
[EnumTextValue("IsSpider")]
[ColumnEnum("IsSpider", typeof(System.Boolean), System.Data.DbType.Boolean, false, false, true, false,1)]
IsSpider = 12,
///
/// SourceUrl : 13 文章的来源地址
///
[EnumTextValue("SourceUrl")]
[ColumnEnum("SourceUrl", typeof(System.String), System.Data.DbType.String, false, false, true, false,200)]
SourceUrl = 13,
///
/// PicUrl : 14
///
[EnumTextValue("PicUrl")]
[ColumnEnum("PicUrl", typeof(System.String), System.Data.DbType.String, false, false, true, false,200)]
PicUrl = 14,
///
/// Summary : 15
///
[EnumTextValue("Summary")]
[ColumnEnum("Summary", typeof(System.String), System.Data.DbType.String, false, false, true, false,500)]
Summary = 15,
///
/// Content : 16
///
[EnumTextValue("Content")]
[ColumnEnum("Content", typeof(System.String), System.Data.DbType.String, false, false, false, false,16)]
Content = 16,
///
/// Hits : 17 点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
///
[EnumTextValue("Hits")]
[ColumnEnum("Hits", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
Hits = 17,
///
/// ReNum : 18 评论次数
///
[EnumTextValue("ReNum")]
[ColumnEnum("ReNum", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
ReNum = 18,
///
/// Digs : 19 顶的次数
///
[EnumTextValue("Digs")]
[ColumnEnum("Digs", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
Digs = 19,
///
/// DigDowns : 20 踩的次数
///
[EnumTextValue("DigDowns")]
[ColumnEnum("DigDowns", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
DigDowns = 20,
///
/// LastDigTime : 21 上次顶的时间
///
[EnumTextValue("LastDigTime")]
[ColumnEnum("LastDigTime", typeof(System.DateTime), System.Data.DbType.DateTime, false, false, true, false,8)]
LastDigTime = 21,
///
/// Points : 22 文章的点数 阅读文章需要支付的点数
///
[EnumTextValue("Points")]
[ColumnEnum("Points", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
Points = 22,
///
/// UserGrade : 23 用户级别 0为不限制
///
[EnumTextValue("UserGrade")]
[ColumnEnum("UserGrade", typeof(System.Int32), System.Data.DbType.Int32, false, false, true, false,4)]
UserGrade = 23,
///
/// FileName : 24 文件名
///
[EnumTextValue("FileName")]
[ColumnEnum("FileName", typeof(System.String), System.Data.DbType.String, false, false, true, false,50)]
FileName = 24,
///
/// AddDate : 25 发布时间
///
[EnumTextValue("AddDate")]
[ColumnEnum("AddDate", typeof(System.DateTime), System.Data.DbType.DateTime, false, false, true, false,8)]
AddDate = 25
}
#endregion
#region 比较规则
///
/// ArticleInfo的比较规则
///
public partial class ArticleInfoCompare
{
///
/// 根据 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int ArticleID(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.ArticleID > obj2.ArticleID)
{
return 1;
}
else if (obj1.ArticleID == obj2.ArticleID)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int CategoryID(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.CategoryID > obj2.CategoryID)
{
return 1;
}
else if (obj1.CategoryID == obj2.CategoryID)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Title(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.Title, obj2.Title);
}
///
/// 根据 文章的网址，如果指定的话就直接指向网址 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int SpecialUrl(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.SpecialUrl, obj2.SpecialUrl);
}
///
/// 根据 文章属性 0为普通文章[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Attr(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.Attr > obj2.Attr)
{
return 1;
}
else if (obj1.Attr == obj2.Attr)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 文章来源 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Source(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.Source, obj2.Source);
}
///
/// 根据 文章作者[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Author(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.Author, obj2.Author);
}
///
/// 根据 是否图文[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int IsPic(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.IsPic && obj2.IsPic)
{
return 0;
}
else if (obj1.IsPic && !obj2.IsPic)
{
return 1;
}
else
{
return -1;
}
}
///
/// 根据 是否推荐[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int IsCommend(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.IsCommend && obj2.IsCommend)
{
return 0;
}
else if (obj1.IsCommend && !obj2.IsCommend)
{
return 1;
}
else
{
return -1;
}
}
///
/// 根据 是否已审核[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int IsChecked(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.IsChecked && obj2.IsChecked)
{
return 0;
}
else if (obj1.IsChecked && !obj2.IsChecked)
{
return 1;
}
else
{
return -1;
}
}
///
/// 根据 是否焦点新闻[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int IsFocus(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.IsFocus && obj2.IsFocus)
{
return 0;
}
else if (obj1.IsFocus && !obj2.IsFocus)
{
return 1;
}
else
{
return -1;
}
}
///
/// 根据 是否是蜘蛛采集[GetList] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int IsSpider(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.IsSpider && obj2.IsSpider)
{
return 0;
}
else if (obj1.IsSpider && !obj2.IsSpider)
{
return 1;
}
else
{
return -1;
}
}
///
/// 根据 文章的来源地址 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int SourceUrl(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.SourceUrl, obj2.SourceUrl);
}
///
/// 根据 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int PicUrl(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.PicUrl, obj2.PicUrl);
}
///
/// 根据 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Summary(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.Summary, obj2.Summary);
}
///
/// 根据 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Content(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.Content, obj2.Content);
}
///
/// 根据 点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Hits(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.Hits > obj2.Hits)
{
return 1;
}
else if (obj1.Hits == obj2.Hits)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 评论次数 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int ReNum(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.ReNum > obj2.ReNum)
{
return 1;
}
else if (obj1.ReNum == obj2.ReNum)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 顶的次数 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Digs(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.Digs > obj2.Digs)
{
return 1;
}
else if (obj1.Digs == obj2.Digs)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 踩的次数 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int DigDowns(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.DigDowns > obj2.DigDowns)
{
return 1;
}
else if (obj1.DigDowns == obj2.DigDowns)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 上次顶的时间 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int LastDigTime(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.LastDigTime > obj2.LastDigTime)
{
return 1;
}
else if (obj1.LastDigTime == obj2.LastDigTime)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 文章的点数 阅读文章需要支付的点数 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int Points(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.Points > obj2.Points)
{
return 1;
}
else if (obj1.Points == obj2.Points)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 用户级别 0为不限制 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int UserGrade(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.UserGrade > obj2.UserGrade)
{
return 1;
}
else if (obj1.UserGrade == obj2.UserGrade)
{
return 0;
}
else
{
return -1;
}
}
///
/// 根据 文件名 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int FileName(ArticleInfo obj1,ArticleInfo obj2)
{
return System.Collections.Comparer.Default.Compare(obj1.FileName, obj2.FileName);
}
///
/// 根据 发布时间 统计
///
///
分类文章信息表 对象
///
分类文章信息表 对象
///
public static int AddDate(ArticleInfo obj1,ArticleInfo obj2)
{
if (obj1.AddDate > obj2.AddDate)
{
return 1;
}
else if (obj1.AddDate == obj2.AddDate)
{
return 0;
}
else
{
return -1;
}
}
}
#endregion
#region 强类型实体基类 ArticleInfoCollection
///
/// ArticleInfo强类型实体集合
///
[Serializable]
public partial class ArticleInfoCollection : TList
{
#region ExportExcelXml 导出到EXCEL
///
/// 输入列表为Excel的Xml文件
///
///
public string ExportExcelXml()
{
System.Text.StringBuilder sb = new System.Text.StringBuilder(1024);
#region 头文件
sb.Append("\n");
sb.Append("\n");
sb.Append("
sb.Append(" xmlns:x=\"urn:schemas-microsoft-com:office:excel\"\n");
sb.Append(" xmlns:ss=\"urn:schemas-microsoft-com:office:spreadsheet\"\n");
sb.Append(" xmlns:html=\"http://www.w3.org/TR/REC-html40\">\n");
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append(" \n");
sb.Append("
sb.Append("
sb.Append("
sb.Append(" x:FullRows=\"1\" ss:DefaultColumnWidth=\"54\" ss:DefaultRowHeight=\"14.25\">\n");
#endregion
sb.Append("
#region 标题
//ArticleID
sb.Append("
//CategoryID
sb.Append("
//Title
sb.Append("
//文章的网址，如果指定的话就直接指向网址
sb.Append("
//文章属性 0为普通文章[GetList]
sb.Append("
//文章来源
sb.Append("
//文章作者[GetList]
sb.Append("
//是否图文[GetList]
sb.Append("
//是否推荐[GetList]
sb.Append("
//是否已审核[GetList]
sb.Append("
//是否焦点新闻[GetList]
sb.Append("
//是否是蜘蛛采集[GetList]
sb.Append("
//文章的来源地址
sb.Append("
//PicUrl
sb.Append("
//Summary
sb.Append("
//Content
sb.Append("
//点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
sb.Append("
//评论次数
sb.Append("
//顶的次数
sb.Append("
//踩的次数
sb.Append("
//上次顶的时间
sb.Append("
//文章的点数 阅读文章需要支付的点数
sb.Append("
//用户级别 0为不限制
sb.Append("
//文件名
sb.Append("
//发布时间
sb.Append("
#endregion
sb.Append("
foreach (ArticleInfo obj in this)
{
sb.Append("
#region 内容
//ArticleID
sb.Append("
sb.Append(obj.ArticleID);
sb.Append("
//CategoryID
sb.Append("
sb.Append(obj.CategoryID);
sb.Append("
//Title
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.Title) ? "" : obj.Title.Replace(">", ">").Replace("<", "<"));
sb.Append("
//文章的网址，如果指定的话就直接指向网址
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.SpecialUrl) ? "" : obj.SpecialUrl.Replace(">", ">").Replace("<", "<"));
sb.Append("
//文章属性 0为普通文章[GetList]
sb.Append("
sb.Append(obj.Attr);
sb.Append("
//文章来源
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.Source) ? "" : obj.Source.Replace(">", ">").Replace("<", "<"));
sb.Append("
//文章作者[GetList]
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.Author) ? "" : obj.Author.Replace(">", ">").Replace("<", "<"));
sb.Append("
//是否图文[GetList]
sb.Append("
sb.Append(obj.IsPic);
sb.Append("
//是否推荐[GetList]
sb.Append("
sb.Append(obj.IsCommend);
sb.Append("
//是否已审核[GetList]
sb.Append("
sb.Append(obj.IsChecked);
sb.Append("
//是否焦点新闻[GetList]
sb.Append("
sb.Append(obj.IsFocus);
sb.Append("
//是否是蜘蛛采集[GetList]
sb.Append("
sb.Append(obj.IsSpider);
sb.Append("
//文章的来源地址
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.SourceUrl) ? "" : obj.SourceUrl.Replace(">", ">").Replace("<", "<"));
sb.Append("
//PicUrl
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.PicUrl) ? "" : obj.PicUrl.Replace(">", ">").Replace("<", "<"));
sb.Append("
//Summary
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.Summary) ? "" : obj.Summary.Replace(">", ">").Replace("<", "<"));
sb.Append("
//Content
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.Content) ? "" : obj.Content.Replace(">", ">").Replace("<", "<"));
sb.Append("
//点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
sb.Append("
sb.Append(obj.Hits);
sb.Append("
//评论次数
sb.Append("
sb.Append(obj.ReNum);
sb.Append("
//顶的次数
sb.Append("
sb.Append(obj.Digs);
sb.Append("
//踩的次数
sb.Append("
sb.Append(obj.DigDowns);
sb.Append("
//上次顶的时间
sb.Append("
sb.Append(obj.LastDigTime);
sb.Append("
//文章的点数 阅读文章需要支付的点数
sb.Append("
sb.Append(obj.Points);
sb.Append("
//用户级别 0为不限制
sb.Append("
sb.Append(obj.UserGrade);
sb.Append("
//文件名
sb.Append("
sb.Append(string.IsNullOrEmpty(obj.FileName) ? "" : obj.FileName.Replace(">", ">").Replace("<", "<"));
sb.Append("
//发布时间
sb.Append("
sb.Append(obj.AddDate);
sb.Append("
#endregion
sb.Append("
}
sb.Append(" \n");
#region 尾文件
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append("
sb.Append(" \n");
sb.Append("\n");
#endregion
return sb.ToString();
}
#endregion
#region ToXml 返回实体类强类型列表的Xml表现形式
///
/// 返回实体类强类型列表的Xml表现形式
///
///
public string ToXml()
{
System.Xml.Serialization.XmlSerializer xs = new System.Xml.Serialization.XmlSerializer(typeof(ArticleInfoCollection), "http://www.crazycoder.cn/coder/entitiesnamespace");
MemoryStream stream = new MemoryStream();
System.Xml.XmlWriterSettings setting = new System.Xml.XmlWriterSettings();
setting.Encoding = new UTF8Encoding(false);
setting.Indent = true;
using (System.Xml.XmlWriter writer = System.Xml.XmlWriter.Create(stream, setting))
{
xs.Serialize(writer, this);
}
return Encoding.UTF8.GetString(stream.ToArray());
}
#endregion
#region FromXml 从Xml字符串中反序列化获得类
///
/// 从Xml字符串中反序列化获得类
///
///
Xml
///
public static ArticleInfoCollection FromXml(string xml)
{
return FromXml(xml, System.Text.Encoding.UTF8);
}
///
/// 从Xml字符串中反序列化获得类
///
///
Xml
///
public static ArticleInfoCollection FromXml(string xml, System.Text.Encoding encoding)
{
byte[] bt = encoding.GetBytes(xml);
System.IO.Stream sm = (System.IO.Stream)new System.IO.MemoryStream(bt);
System.IO.TextReader tr = new System.IO.StreamReader(sm);
System.Xml.Serialization.XmlSerializer ser = new System.Xml.Serialization.XmlSerializer(typeof(ArticleInfoCollection));
ArticleInfoCollection obj = (ArticleInfoCollection)ser.Deserialize(tr);
tr.Close();
sm.Close();
return obj;
}
#endregion
#region 创建插入的SQL语句 string ToInsertSql()
///
/// 创建插入的SQL语句
///
///
public string ToInsertSql()
{
StringBuilder sb = new StringBuilder();
foreach (ArticleInfo obj in this)
{
sb.Append("INSERT INTO [Qst_Article]([CategoryID],[Title],[SpecialUrl],[Attr],[Source],[Author],[IsPic],[IsCommend],[IsChecked],[IsFocus],[IsSpider],[SourceUrl],[PicUrl],[Summary],[Content],[Hits],[ReNum],[Digs],[DigDowns],[LastDigTime],[Points],[UserGrade],[FileName],[AddDate]) \n");
sb.Append("VALUES (");
sb.Append(obj.CategoryID);
sb.Append(",");
sb.Append("'");
sb.Append(obj.Title);
sb.Append("'");
sb.Append(",");
sb.Append("'");
sb.Append(obj.SpecialUrl);
sb.Append("'");
sb.Append(",");
sb.Append(obj.Attr);
sb.Append(",");
sb.Append("'");
sb.Append(obj.Source);
sb.Append("'");
sb.Append(",");
sb.Append("'");
sb.Append(obj.Author);
sb.Append("'");
sb.Append(",");
sb.Append(obj.IsPic ? "1":"0");
sb.Append(",");
sb.Append(obj.IsCommend ? "1":"0");
sb.Append(",");
sb.Append(obj.IsChecked ? "1":"0");
sb.Append(",");
sb.Append(obj.IsFocus ? "1":"0");
sb.Append(",");
sb.Append(obj.IsSpider ? "1":"0");
sb.Append(",");
sb.Append("'");
sb.Append(obj.SourceUrl);
sb.Append("'");
sb.Append(",");
sb.Append("'");
sb.Append(obj.PicUrl);
sb.Append("'");
sb.Append(",");
sb.Append("'");
sb.Append(obj.Summary);
sb.Append("'");
sb.Append(",");
sb.Append("'");
sb.Append(obj.Content);
sb.Append("'");
sb.Append(",");
sb.Append(obj.Hits);
sb.Append(",");
sb.Append(obj.ReNum);
sb.Append(",");
sb.Append(obj.Digs);
sb.Append(",");
sb.Append(obj.DigDowns);
sb.Append(",");
sb.Append("'");
sb.Append(obj.LastDigTime);
sb.Append("'");
sb.Append(",");
sb.Append(obj.Points);
sb.Append(",");
sb.Append(obj.UserGrade);
sb.Append(",");
sb.Append("'");
sb.Append(obj.FileName);
sb.Append("'");
sb.Append(",");
sb.Append("'");
sb.Append(obj.AddDate);
sb.Append("'");
sb.Append(")\n");
sb.Append("Go\n");
}
return sb.ToString();
}
#endregion
#region 创建更新的SQL语句 string ToUpdateSql()
///
/// 创建更新的SQL语句
///
///
public string ToUpdateSql()
{
StringBuilder sb = new StringBuilder();
foreach (ArticleInfo obj in this)
{
sb.Append("UPDATE [Qst_Article] Set\n");
sb.Append("CategoryID =");
sb.Append(obj.CategoryID);
sb.Append(",");
sb.Append("[Title]='");
sb.Append(obj.Title);
sb.Append("'");
sb.Append(",");
sb.Append("[SpecialUrl]='");
sb.Append(obj.SpecialUrl);
sb.Append("'");
sb.Append(",");
sb.Append("Attr =");
sb.Append(obj.Attr);
sb.Append(",");
sb.Append("[Source]='");
sb.Append(obj.Source);
sb.Append("'");
sb.Append(",");
sb.Append("[Author]='");
sb.Append(obj.Author);
sb.Append("'");
sb.Append(",");
sb.Append("IsPic =");
sb.Append(obj.IsPic ? "1":"0");
sb.Append(",");
sb.Append("IsCommend =");
sb.Append(obj.IsCommend ? "1":"0");
sb.Append(",");
sb.Append("IsChecked =");
sb.Append(obj.IsChecked ? "1":"0");
sb.Append(",");
sb.Append("IsFocus =");
sb.Append(obj.IsFocus ? "1":"0");
sb.Append(",");
sb.Append("IsSpider =");
sb.Append(obj.IsSpider ? "1":"0");
sb.Append(",");
sb.Append("[SourceUrl]='");
sb.Append(obj.SourceUrl);
sb.Append("'");
sb.Append(",");
sb.Append("[PicUrl]='");
sb.Append(obj.PicUrl);
sb.Append("'");
sb.Append(",");
sb.Append("[Summary]='");
sb.Append(obj.Summary);
sb.Append("'");
sb.Append(",");
sb.Append("[Content]='");
sb.Append(obj.Content);
sb.Append("'");
sb.Append(",");
sb.Append("Hits =");
sb.Append(obj.Hits);
sb.Append(",");
sb.Append("ReNum =");
sb.Append(obj.ReNum);
sb.Append(",");
sb.Append("Digs =");
sb.Append(obj.Digs);
sb.Append(",");
sb.Append("DigDowns =");
sb.Append(obj.DigDowns);
sb.Append(",");
sb.Append("[LastDigTime]='");
sb.Append(obj.LastDigTime);
sb.Append("'");
sb.Append(",");
sb.Append("Points =");
sb.Append(obj.Points);
sb.Append(",");
sb.Append("UserGrade =");
sb.Append(obj.UserGrade);
sb.Append(",");
sb.Append("[FileName]='");
sb.Append(obj.FileName);
sb.Append("'");
sb.Append(",");
sb.Append("[AddDate]='");
sb.Append(obj.AddDate);
sb.Append("'");
sb.Append(obj.ArticleID);
sb.Append("Go\n");
}
return sb.ToString();
}
#endregion
#region 序列化和反序列化 静态方法
///
/// 将对象序列化
///
///
需要保存的路径
///
ArticleInfoCollection对象
///
public static bool Serialize(string path, ArticleInfoCollection objArticleInfoCollection)
{
try
{
FileStream fs = new FileStream(path, FileMode.Create);
string folder = Path.GetDirectoryName(path);
if (!Directory.Exists(folder))
{
Directory.CreateDirectory(folder);
}
BinaryFormatter formatter = new BinaryFormatter();
formatter.Serialize(fs, objArticleInfoCollection);
fs.Close();
fs.Dispose();
return true;
}
catch
{
return false;
}
}
///
/// 将对象反序列化
///
///
源对象的路径
///
public new static ArticleInfoCollection DeSerialize(string path)
{
try
{
FileStream fs = new FileStream(path, FileMode.Open);
BinaryFormatter formatter = new BinaryFormatter();
ArticleInfoCollection objArticleInfoCollection = (ArticleInfoCollection)formatter.Deserialize(fs);
fs.Close();
fs.Dispose();
return objArticleInfoCollection;
}
catch
{
return null;
}
}
#endregion
#region 分页 Paging
///
/// 分页
///
///
页码
///
页面大小
///
public ArticleInfoCollection Paging(int pageIndex, int pageSize)
{
if (pageIndex <= 0)
{
pageIndex = 1;
}
if (pageSize <= 0)
{
pageSize = 10;
}
ArticleInfoCollection list = new ArticleInfoCollection();
int recordCount = this.Length;
int startIndex = (pageIndex - 1) * pageSize;
if (startIndex > recordCount - 1)
return list;
int endIndex = pageIndex * pageSize;
if (endIndex > recordCount - 1)
endIndex = recordCount - 1;
for (int i = startIndex; i <= endIndex; i++)
{
list.Add(this[i]);
}
return list;
}
#endregion
#region 获取对象
///
/// 根据主键ArticleID获取ArticleInfo分类文章信息表对象
///
///
主键articleID
///
public ArticleInfo GetByArticleID(System.Int32 articleID)
{
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.ArticleID == articleID)
{
return objArticleInfo;
}
}
return null;
}
#endregion
#region 根据对象枚举获取列表
///
/// 根据对象枚举ArticleInfoEnumeration获取列表
///
///
对象数据
///
对象列枚举
///
public ArticleInfoCollection GetList(object obj, ArticleInfoEnumeration en)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
switch (en)
{
case ArticleInfoEnumeration.ArticleID:
//根据ArticleID:取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.ArticleID == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.CategoryID:
//根据CategoryID:取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.CategoryID == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Title:
//根据Title:取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Title.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.SpecialUrl:
//根据SpecialUrl:文章的网址，如果指定的话就直接指向网址取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.SpecialUrl.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Attr:
//根据Attr:文章属性 0为普通文章[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Attr == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Source:
//根据Source:文章来源取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Source.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Author:
//根据Author:文章作者[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Author.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.IsPic:
//根据IsPic:是否图文[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.IsPic == (System.Boolean)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.IsCommend:
//根据IsCommend:是否推荐[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.IsCommend == (System.Boolean)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.IsChecked:
//根据IsChecked:是否已审核[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.IsChecked == (System.Boolean)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.IsFocus:
//根据IsFocus:是否焦点新闻[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.IsFocus == (System.Boolean)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.IsSpider:
//根据IsSpider:是否是蜘蛛采集[GetList]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.IsSpider == (System.Boolean)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.SourceUrl:
//根据SourceUrl:文章的来源地址取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.SourceUrl.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.PicUrl:
//根据PicUrl:取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.PicUrl.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Summary:
//根据Summary:取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Summary.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Content:
//根据Content:取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Content.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Hits:
//根据Hits:点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Hits == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.ReNum:
//根据ReNum:评论次数取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.ReNum == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Digs:
//根据Digs:顶的次数取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Digs == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.DigDowns:
//根据DigDowns:踩的次数取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.DigDowns == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.LastDigTime:
//根据LastDigTime:上次顶的时间取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.LastDigTime == (System.DateTime)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.Points:
//根据Points:文章的点数 阅读文章需要支付的点数取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.Points == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.UserGrade:
//根据UserGrade:用户级别 0为不限制取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.UserGrade == (System.Int32)obj)
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.FileName:
//根据FileName:文件名取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.FileName.Equals((System.String)obj, StringComparison.CurrentCultureIgnoreCase))
{
list.Add(objArticleInfo);
}
}
break;
case ArticleInfoEnumeration.AddDate:
//根据AddDate:发布时间取出列表
if (obj == null)
{
break;
}
else
{
if (objArticleInfo.AddDate == (System.DateTime)obj)
{
list.Add(objArticleInfo);
}
}
break;
default:
break;
}
}
return list;
}
#endregion
#region 根据开始和结束位置的索引获取列表
///
/// 根据开始和结束位置的索引获取列表
///
///
索引开始位置
///
索引结束位置
///
public ArticleInfoCollection GetList(int startIndex, int endIndex)
{
ArticleInfoCollection list = new ArticleInfoCollection();
if (startIndex > this.Length - 1)
{
return list;
}
if (endIndex > this.Length - 1)
{
endIndex = this.Length - 1;
}
for (int i = startIndex; i <= endIndex; i++)
{
list.Add(this[i]);
}
return list;
}
#endregion
#region 根据外键获取对象列表
///
/// 根据外键CategoryID 获取ArticleInfoQst_Article对象列表
///
///
System.Int32
///
public ArticleInfoCollection GetListByCategoryID(System.Int32 categoryID)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.CategoryID == categoryID)
{
list.Add(objArticleInfo);
}
}
return list;
}
#endregion
#region 根据数字行列获取列表
///
/// 根据Attr文章属性 0为普通文章[GetList] 获取ArticleInfoQst_Article对象列表
///
///
System.Int32文章属性 0为普通文章[GetList]
///
public ArticleInfoCollection GetListByAttr(System.Int32 attr)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.Attr == attr)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据IsPic是否图文[GetList] 获取ArticleInfoQst_Article对象列表
///
///
System.Boolean是否图文[GetList]
///
public ArticleInfoCollection GetListByIsPic(System.Boolean isPic)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.IsPic == isPic)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据IsCommend是否推荐[GetList] 获取ArticleInfoQst_Article对象列表
///
///
System.Boolean是否推荐[GetList]
///
public ArticleInfoCollection GetListByIsCommend(System.Boolean isCommend)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.IsCommend == isCommend)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据IsChecked是否已审核[GetList] 获取ArticleInfoQst_Article对象列表
///
///
System.Boolean是否已审核[GetList]
///
public ArticleInfoCollection GetListByIsChecked(System.Boolean isChecked)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.IsChecked == isChecked)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据IsFocus是否焦点新闻[GetList] 获取ArticleInfoQst_Article对象列表
///
///
System.Boolean是否焦点新闻[GetList]
///
public ArticleInfoCollection GetListByIsFocus(System.Boolean isFocus)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.IsFocus == isFocus)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据IsSpider是否是蜘蛛采集[GetList] 获取ArticleInfoQst_Article对象列表
///
///
System.Boolean是否是蜘蛛采集[GetList]
///
public ArticleInfoCollection GetListByIsSpider(System.Boolean isSpider)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.IsSpider == isSpider)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据Hits点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"] 获取ArticleInfoQst_Article对象列表
///
///
System.Int32点击次数[GetList type="1" orderby="Hits desc,ArticleID desc"]
///
public ArticleInfoCollection GetListByHits(System.Int32 hits)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.Hits == hits)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据ReNum评论次数 获取ArticleInfoQst_Article对象列表
///
///
System.Int32评论次数
///
public ArticleInfoCollection GetListByReNum(System.Int32 reNum)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.ReNum == reNum)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据Digs顶的次数 获取ArticleInfoQst_Article对象列表
///
///
System.Int32顶的次数
///
public ArticleInfoCollection GetListByDigs(System.Int32 digs)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.Digs == digs)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据DigDowns踩的次数 获取ArticleInfoQst_Article对象列表
///
///
System.Int32踩的次数
///
public ArticleInfoCollection GetListByDigDowns(System.Int32 digDowns)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.DigDowns == digDowns)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据Points文章的点数 阅读文章需要支付的点数 获取ArticleInfoQst_Article对象列表
///
///
System.Int32文章的点数 阅读文章需要支付的点数
///
public ArticleInfoCollection GetListByPoints(System.Int32 points)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.Points == points)
{
list.Add(objArticleInfo);
}
}
return list;
}
///
/// 根据UserGrade用户级别 0为不限制 获取ArticleInfoQst_Article对象列表
///
///
System.Int32用户级别 0为不限制
///
public ArticleInfoCollection GetListByUserGrade(System.Int32 userGrade)
{
ArticleInfoCollection list = new ArticleInfoCollection();
foreach (ArticleInfo objArticleInfo in this)
{
if (objArticleInfo.UserGrade == userGrade)
{
list.Add(objArticleInfo);
}
}
return list;
}
#endregion
}
#endregion
}
最新评论