DAL/Article.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
namespace RM.DAL
{
	/// <summary>
	/// 数据访问类Article
	/// </summary>
	public class Article : Basic
	{
		#region 构造函数
		public Article()
		{
			this.strPKName = "ID";
			this.strTableName = "rm_Article";
		}
		#endregion

		#region 数据访问处理方法[自动生成].

		/// <summary>
		/// 将数据实体写入数据库.
		/// </summary>
		public bool Add(RM.Entity.Article MyEntity)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("INSERT INTO " + this.strTableName + "(");
			strSql.Append("[ClassID],");
			strSql.Append("[Title],");
			strSql.Append("[Content],");
			strSql.Append("[ImageUrl],");
			strSql.Append("[Source],");
			strSql.Append("[Author],");
			strSql.Append("[Keyword],");
			strSql.Append("[Summary],");
			strSql.Append("[IsTop],");
			strSql.Append("[IsHot],");
			strSql.Append("[IsHome],");
			strSql.Append("[IsPub],");
			strSql.Append("[Hits],");
			strSql.Append("[SortOrder],");
			strSql.Append("[Operator],");
			strSql.Append("[CreateTime],");
			strSql.Append("[ModifyTime]");
			strSql.Append(")VALUES(");
			strSql.Append("@ClassID,@Title,@Content,@ImageUrl,@Source,@Author,@Keyword,@Summary,@IsTop,@IsHot,@IsHome,@IsPub,@Hits,@SortOrder,@Operator,@CreateTime,@ModifyTime)");
			RM.DataProvider.SqlDBO.SqlCmdParam[] MyParam = {
				MyDBO.CreateNewParam("@ClassID", SqlDbType.Int, MyEntity.ClassID),
				MyDBO.CreateNewParam("@Title", SqlDbType.VarChar, MyEntity.Title),
				MyDBO.CreateNewParam("@Content", SqlDbType.Text, MyEntity.Content),
				MyDBO.CreateNewParam("@ImageUrl", SqlDbType.VarChar, MyEntity.ImageUrl),
				MyDBO.CreateNewParam("@Source", SqlDbType.VarChar, MyEntity.Source),
				MyDBO.CreateNewParam("@Author", SqlDbType.VarChar, MyEntity.Author),
				MyDBO.CreateNewParam("@Keyword", SqlDbType.VarChar, MyEntity.Keyword),
				MyDBO.CreateNewParam("@Summary", SqlDbType.VarChar, MyEntity.Summary),
				MyDBO.CreateNewParam("@IsTop", SqlDbType.Bit, MyEntity.IsTop),
				MyDBO.CreateNewParam("@IsHot", SqlDbType.Bit, MyEntity.IsHot),
				MyDBO.CreateNewParam("@IsHome", SqlDbType.Bit, MyEntity.IsHome),
				MyDBO.CreateNewParam("@IsPub", SqlDbType.Bit, MyEntity.IsPub),