DAL/Cate.cs

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

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

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

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

		/// <summary>
		/// 将数据实体写入数据库.
		/// </summary>
		public bool Add(RM.Entity.Cate MyEntity)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("INSERT INTO " + this.strTableName + "(");
			strSql.Append("[Name],");
			strSql.Append("[Tag],");
			strSql.Append("[ParentID],");
			strSql.Append("[SortStr],");
			strSql.Append("[Depth],");
			strSql.Append("[RootID],");
			strSql.Append("[Childs]");
			strSql.Append(")VALUES(");
			strSql.Append("@Name,@Tag,@ParentID,@SortStr,@Depth,@RootID,@Childs)");
			RM.DataProvider.SqlDBO.SqlCmdParam[] MyParam = {
				MyDBO.CreateNewParam("@Name", SqlDbType.VarChar, MyEntity.Name),
				MyDBO.CreateNewParam("@Tag", SqlDbType.VarChar, MyEntity.Tag),
				MyDBO.CreateNewParam("@ParentID", SqlDbType.Int, MyEntity.ParentID),
				MyDBO.CreateNewParam("@SortStr", SqlDbType.VarChar, MyEntity.SortStr),
				MyDBO.CreateNewParam("@Depth", SqlDbType.Int, MyEntity.Depth),
				MyDBO.CreateNewParam("@RootID", SqlDbType.Int, MyEntity.RootID),
				MyDBO.CreateNewParam("@Childs", SqlDbType.Int, MyEntity.Childs)
			};
			bool result = false;
			if(MyDBO.ExecuteNonQuery(strSql.ToString(), MyParam) > 0)
			{
				result = true;
			}
			return result;
		}

		/// <summary>
		/// 将数据实体更新到数据库.
		/// </summary>
		public bool Update(RM.Entity.Cate MyEntity)
		{
			StringBuilder strSql=new StringBuilder();