st_class.cs

it have big power,i hope to do it . happy everyday!

using System;
using Microsoft.ApplicationBlocks.Data;
using System.Data;
using System.Data.SqlClient;

namespace STGROUP.ST_BookBiz
{
	/// <summary>
	/// ST_Class 的摘要说明。
	/// </summary>
	public class ST_Class
	{
		public ST_Class()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}

		/// <summary>
		/// 插入一个分类
		/// </summary>
		/// <param name="st_className"></param>
		/// <param name="st_fatherid"></param>
		/// <returns></returns>
		public int InsertClass(string st_className, int st_fatherid)
		{
			string sqlString = "insert into ST_Class(ST_ClassName,ST_FatherID) values('"+st_className+"',"+st_fatherid+"); select SCOPE_IDENTITY()";
			object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			if(obj!=null)
				return int.Parse(obj.ToString());
			return 0;
		}
		/// <summary>
		/// 更新一个分类
		/// </summary>
		/// <param name="st_classID"></param>
		/// <param name="st_className"></param>
		/// <param name="st_fatherid"></param>
		public void UpdateClass(int st_classID, string st_className)
		{
			string sqlString = "update ST_Class set ST_ClassName='"+st_className+"' where st_classID="+st_classID;
			SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			
		}

		/// <summary>
		/// 删除一个分类
		/// </summary>
		/// <param name="st_classID"></param>
		public void DeleteClass(int st_classID)
		{
			string sqlString = "update ST_Class set ST_IsDeleted=1 where st_classID="+st_classID;
			SqlHelper.ExecuteNonQuery(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			
		}

		/// <summary>
		/// 取得分类列表
		/// </summary>
		/// <param name="st_classID"></param>
		public DataSet GetClass()
		{
			string sqlString = "select * from ST_Class where ST_IsDeleted=0 union select 0,'图书',-1,0";
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}

		/// <summary>
		/// 取得一级分类
		/// </summary>
		/// <param name="st_classID"></param>
		public DataSet GetFirstClass()
		{
			string sqlString = "select * from ST_Class where ST_IsDeleted=0 and ST_FatherID=0";
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}
		/// <summary>
		/// 取得分类的子类列表
		/// </summary>
		/// <param name="st_classID"></param>
		public DataSet GetChildClass(int st_fatherid)
		{
			string sqlString = "select * from ST_Class where ST_IsDeleted=0 and st_fatherid="+st_fatherid;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}


		/// <summary>
		/// 取得分类列表
		/// </summary>
		/// <param name="st_classID"></param>
		public DataSet GetClassByCid(int st_classid)
		{
			string sqlString = "select * from ST_Class where ST_IsDeleted=0 and st_classid="+st_classid;
			DataSet ds = SqlHelper.ExecuteDataset(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			return ds;
		}

		/// <summary>
		/// 判断节点下是否存在子节点
		/// </summary>
		public bool IsHaveChild(int st_classID)
		{
			string sqlStr = "SELECT st_classID FROM ST_Class WHERE st_fatherid="+st_classID;
			SqlDataReader sqlDr = SqlHelper.ExecuteReader(ST_Utility.ST_ConnString,CommandType.Text,sqlStr);
			while(sqlDr.Read())
			{
				return true;
			}
			sqlDr.Close();
			return false;
		}

		/// <summary>
		/// 判断节点下是否存在子节点
		/// </summary>
		public bool IsHavePd(int st_classID)
		{
			string sqlString = "select count(ST_ProductID) from ST_Product where ST_IsDeleted=0 and ST_ClassID="+st_classID;
			object obj = SqlHelper.ExecuteScalar(ST_Utility.ST_ConnString, CommandType.Text, sqlString);
			if(obj!=null && obj.ToString()!="0")
				return true;
			else
				return false;
		}

		/// <summary>
		/// 得到节点的父ID
		/// </summary>
		public int GetParentID(int ClassID)
		{
			int returnValue = -2;
			string sqlStr = "SELECT st_fatherid FROM ST_Class WHERE st_classID="+ClassID;
			SqlDataReader sqlDr = SqlHelper.ExecuteReader(ST_Utility.ST_ConnString,CommandType.Text,sqlStr);
			while(sqlDr.Read())
			{
				returnValue = sqlDr.GetInt32(0);
			}
			sqlDr.Close();
			return returnValue;
		}

		/// <summary>
		/// 判断节点是否可以有子节点
		/// </summary>
		public bool CanHaveChild(int ClassID)
		{
			int ParentID = GetParentID(ClassID);
			if(ParentID!=0 && ParentID!=-1)
				return false;
			else
				return true;
		}
	}
}