DAL/Category.cs

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

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

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using Maticsoft.DBUtility;//Please add references
namespace HLW.DAL
{
	/// <summary>
	/// 数据访问类:Category
	/// </summary>
	public partial class Category
	{
		public Category()
		{}
		#region  BasicMethod

		/// <summary>
		/// 得到最大ID
		/// </summary>
		public int GetMaxId()
		{
		return DbHelperSQL.GetMaxID("cat_id", "tb_Category"); 
		}

		/// <summary>
		/// 是否存在该记录
		/// </summary>
		public bool Exists(int cat_id)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("select count(1) from tb_Category (nolock) ");
			strSql.Append(" where cat_id=@cat_id");
			SqlParameter[] parameters = {
					new SqlParameter("@cat_id", SqlDbType.Int,4)
			};
			parameters[0].Value = cat_id;

			return DbHelperSQL.Exists(strSql.ToString(),parameters);
		}


		/// <summary>
		/// 增加一条数据
		/// </summary>
		public int Add(HLW.Model.Category model)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.Append("insert into tb_Category(");
			strSql.Append("cat_name,cat_Mark,cat_parentid,cat_c_level,cat_sort,cat_addtime,cat_img,cat_intro,cat_content,cat_isshow,cat_isrecommend,cat_seo_title,cat_seo_keyword,cat_seo_description,cat_point,cat_isnet)");
			strSql.Append(" values (");
			strSql.Append("@cat_name,@cat_Mark,@cat_parentid,@cat_c_level,@cat_sort,@cat_addtime,@cat_img,@cat_intro,@cat_content,@cat_isshow,@cat_isrecommend,@cat_seo_title,@cat_seo_keyword,@cat_seo_description,@cat_point,@cat_isnet)");
			strSql.Append(";select @@IDENTITY");
			SqlParameter[] parameters = {
					new SqlParameter("@cat_name", SqlDbType.NVarChar,150),
					new SqlParameter("@cat_Mark", SqlDbType.NVarChar,150),
					new SqlParameter("@cat_parentid", SqlDbType.Int,4),
					new SqlParameter("@cat_c_level", SqlDbType.Int,4),
					new SqlParameter("@cat_sort", SqlDbType.Int,4),
					new SqlParameter("@cat_addtime", SqlDbType.DateTime),
					new SqlParameter("@cat_img", SqlDbType.NVarChar,250),