conclass.cs

不错的 漂亮分类源代码 很又用

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

using JohnTree.Library.Model;

namespace JohnTree.Library.DAL
{
    public class ConClass : DbHelpers
    {
        /// <summary>
        /// 获取ClassId的包含菜单列表
        /// </summary>
        /// <param name="ClassId"></param>
        /// <returns></returns>
        public DataSet GetClassListByClassId( string ClassId )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ClassList,ClassTj from Content_Class");
            strSql.Append(" where ClassID=" + ClassId + " ");
            return GetDataset(CommandType.Text, strSql.ToString());
        }

        /// <summary>
        /// 添加一个菜单项
        /// </summary>
        /// <param name="ClassId"></param>
        /// <param name="ClassName"></param>
        /// <param name="ClassList"></param>
        /// <param name="ClassPre"></param>
        /// <param name="ClassTj"></param>
        /// <returns></returns>
        public bool ClassAdd( ConClassInfo model )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into Content_Class(");
            strSql.Append("ClassId,ClassName,ClassList,ClassPre,ClassTj,ClassKind");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("'" + model.ClassId + "',");
            strSql.Append("'" + model.ClassName + "',");
            strSql.Append("'" + model.ClassList + "',");
            strSql.Append("'" + model.ClassPre + "',");
            strSql.Append("" + model.ClassTj + ",");
            strSql.Append("" + model.ClassKind + "");
            strSql.Append(")");

            return NonQueryBool(CommandType.Text, strSql.ToString());
        }

        /// <summary>
        /// 编辑一个菜单项
        /// </summary>
        /// <param name="ClassId"></param>
        /// <param name="ClassName"></param>
        /// <param name="ClassList"></param>
        /// <param name="ClassPre"></param>
        /// <param name="ClassTj"></param>
        /// <returns></returns>
        public bool ClassSave( ConClassInfo model )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Content_Class set ");
            strSql.Append("ClassName='" + model.ClassName + "',");
            strSql.Append("ClassList='" + model.ClassList + "',");
            strSql.Append("ClassPre='" + model.ClassPre + "',");
            strSql.Append("ClassTj=" + model.ClassTj + "");
            strSql.Append(" where ClassId='" + model.ClassId + "' ");


            //同步更新子菜单项
            DataSet ds = this.GetSubClassList(model.ClassId);
            if (ds.Tables[0].Rows.Count > 0)
            {
                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    string SubClassList = model.ClassList + dr["ClassId"].ToString().Trim() + ",";

                    model.ClassId = dr["ClassId"].ToString().Trim();
                    model.ClassName = dr["ClassName"].ToString().Trim();
                    model.ClassList = SubClassList.ToString().Trim();
                    model.ClassPre = dr["ClassPre"].ToString().Trim();
                    model.ClassTj = model.ClassTj + 1;
                    ClassSave(model);
                }
            }

            return NonQueryBool(CommandType.Text, strSql.ToString());
        }

        /// <summary>
        /// 获取该菜单项的所有子菜单项
        /// </summary>
        /// <param name="ClassId"></param>
        /// <returns></returns>
        public DataSet GetSubClassList( string ClassId )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Content_Class");
            strSql.Append(" where ClassPre='" + ClassId + "' ");
            return GetDataset(CommandType.Text, strSql.ToString());
        }

        /// <summary>
        /// 获取菜单列表
        /// </summary>
        /// <returns></returns>
        public DataSet GetClassList( int ClassKind )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from Content_Class");
            strSql.Append(" where ClassKind=" + ClassKind + "");
            strSql.Append(" Order By ClassList Asc,ClassOrder Asc");
            return GetDataset(CommandType.Text, strSql.ToString());
        }

        public string GetPreClassId( string ClassId )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("Select top 1 ClassPre From Content_Class");
            strSql.Append(" Where ClassId='" + ClassId + "'");
            return NonQueryScalar(CommandType.Text, strSql.ToString()).ToString();
        }

        /// <summary>
        /// 删除一个菜单项
        /// </summary>
        /// <param name="ClassId"></param>
        /// <returns></returns>
        public bool DelByClassId( string ClassId )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("Delete From Content_Class");
            strSql.Append(" where ClassId='" + ClassId + "'");
            return NonQueryBool(CommandType.Text, strSql.ToString());
        }

        /// <summary>
        /// 更新排序
        /// </summary>
        /// <param name="ClassId"></param>
        /// <param name="ClassOrder"></param>
        /// <returns></returns>
        public bool UpdateClassOrder( string ClassId, int ClassOrder )
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("Update Content_Class Set ");
            strSql.Append("ClassOrder=" + ClassOrder + " ");
            strSql.Append(" where ClassId='" + ClassId + "'");
            return NonQueryBool(CommandType.Text, strSql.ToString());
        }
    }
}