classaccessor.cs

新闻网站

using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using Common.Entities;
using Common;
using System.Data;
using System.Data.SqlClient;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

namespace DAL.Accessor
{
    public class ClassAccessor
    {
        public int AddClass(ClassData classData)
        {
            int rows = 0;

            //接收参数
            SqlParameter[] sqlParameter = { 
                new SqlParameter("@ClassName",SqlDbType.VarChar,20),
                new SqlParameter("@parentID",SqlDbType.Int,4),
                new SqlParameter("@LastNode",SqlDbType.Int,4),
                new SqlParameter("@Example",SqlDbType.VarChar,50)
            };

            sqlParameter[0].Value = classData.ClassName;
            sqlParameter[1].Value = classData.ParentID;
            sqlParameter[2].Value = classData.LastNode;
            sqlParameter[3].Value = classData.Example;

            using(SqlConnection sqlConnection = new SqlConnection())
            {
                sqlConnection.ConnectionString = SqlHelper.ConnectionStringLocalTransaction;

                rows = SqlHelper.ExecuteNonQuery(sqlConnection, CommandType.StoredProcedure, "ADD_Class", sqlParameter);
            }

            return rows;

        }

        //5_1_a_s_p_x.c_o_m

        //获取所有的用户信息
        public ArrayList GetClassList()
        {
            ArrayList list = new ArrayList();

            SqlDataReader read = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Class_List", null);
            while (read.Read())
            {
                ClassData classDate = new ClassData();
                classDate.ClassID = int.Parse(read["ClassID"].ToString());
                classDate.ClassName = read["ClassName"].ToString();
                classDate.ParentID = int.Parse(read["ParentID"].ToString());
                classDate.Child = int.Parse(read["Child"].ToString());
                classDate.LastNode = int.Parse(read["LastNode"].ToString());
                classDate.Example = read["Example"].ToString();

                list.Add(classDate);
            }
            read.Dispose();
            return list;

        }

        //根据PreentID来获取所有的信息//5_1_a_s_p_x.c_o_m

        public ArrayList GetClassData(int parentID)
        {
            ArrayList list = new ArrayList();
            SqlParameter[] sqlParamenter = { 
                new SqlParameter("@parentID",SqlDbType.Int,4)
            };

            sqlParamenter[0].Value = parentID;
            SqlDataReader read = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Class_Tree_ID", sqlParamenter);

            while (read.Read())
            {
                ClassData classData = new ClassData();
                classData.ClassID = int.Parse(read["ClassID"].ToString());
                classData.ClassName = read["ClassName"].ToString();
                classData.ParentID = int.Parse(read["ParentID"].ToString());
                classData.Child = int.Parse(read["Child"].ToString());
                classData.LastNode = int.Parse(read["LastNode"].ToString());
                classData.Example = read["Example"].ToString();
                list.Add(classData);
            }
            read.Dispose();
            return list;

        }
        //根据NewClassID来获取所有的信息
        public ClassData GetClassDataID(int classID)
        {
            ClassData classData = new ClassData();
            
            SqlParameter[] sqlParamenter = { 
                new SqlParameter("@ClassID",SqlDbType.Int,4)
            };

            sqlParamenter[0].Value = classID;
            SqlDataReader read = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Class_Fiind_ID", sqlParamenter);

            if (read.Read())
            {
                
                classData.ClassID = int.Parse(read["ClassID"].ToString());
                classData.ClassName = read["ClassName"].ToString();
                classData.ParentID = int.Parse(read["ParentID"].ToString());
                classData.Child = int.Parse(read["Child"].ToString());
                classData.LastNode = int.Parse(read["LastNode"].ToString());
                classData.Example = read["Example"].ToString();
                
            }
            read.Dispose();
            return classData;

        }
        

        //判断是否是子节点NewClass_ParentID
        //需要返回参数
        public ClassData GetParent(int parentID)
        {
            SqlParameter[] sqlParamenter = { 
               new SqlParameter("@parentID",SqlDbType.Int,4),
                new SqlParameter("@ClassName",SqlDbType.VarChar,20),
               new  SqlParameter("@id",SqlDbType.Int,4)
            };

            sqlParamenter[0].Direction = ParameterDirection.Output;
            sqlParamenter[1].Direction = ParameterDirection.Output;
            sqlParamenter[2].Value = parentID;

            using (SqlConnection sqlConnection = new SqlConnection())
            {
                sqlConnection.ConnectionString = SqlHelper.ConnectionStringLocalTransaction;
                SqlHelper.ExecuteNonQuery(sqlConnection, CommandType.StoredProcedure, "Class_ParentID", sqlParamenter);

            }

            ClassData classData = new ClassData();
            classData.ClassID = int.Parse(sqlParamenter[0].Value.ToString());
            classData.ClassName = sqlParamenter[1].Value.ToString();

            return classData;


        }

        // 删除操作
        public bool DeleteClass(int classID)
        {
            int rows = 0;

            SqlParameter[] sqlparameter = {
                new SqlParameter("@ClassID",SqlDbType.Int,4)
            };
            sqlparameter[0].Value = classID;

            using(SqlConnection sqlConnection = new SqlConnection())
            {
                sqlConnection.ConnectionString = SqlHelper.ConnectionStringLocalTransaction;

                rows = SqlHelper.ExecuteNonQuery(sqlConnection, CommandType.StoredProcedure, "DeleteClass", sqlparameter);
            
            }
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        //修改信息
        public bool ReWorkClass(ClassData classData)
        {
            SqlParameter[] sqlParamenter = {
                new SqlParameter("@ClassID",SqlDbType.Int,4),
                new SqlParameter("@ClassName",SqlDbType.VarChar,20),
                new SqlParameter("@LastNode",SqlDbType.Int,4),
                new SqlParameter("@Example",SqlDbType.VarChar,50)
            };

            sqlParamenter[0].Value = classData.ClassID;
            sqlParamenter[1].Value = classData.ClassName;
            sqlParamenter[2].Value = classData.LastNode;
            sqlParamenter[3].Value = classData.Example;

            int rows = 0;
            using(SqlConnection sqlConnection = new SqlConnection())
            {
                sqlConnection.ConnectionString = SqlHelper.ConnectionStringLocalTransaction;
                rows = SqlHelper.ExecuteNonQuery(sqlConnection, CommandType.StoredProcedure, "ReworkClass", sqlParamenter);
            
            }

            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }

        }

       
        //获取一级标题
        public List<ClassData> GetClassOneTitle()
        {

            List<ClassData> all = new List<ClassData>();

            SqlDataReader read = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "Class_ONE", null);

            while (read.Read())
            {
                ClassData classData = new ClassData();
                classData.ClassID = int.Parse(read["ClassID"].ToString());
                classData.ClassName = read["ClassName"].ToString();
                classData.ParentID = int.Parse(read["ParentID"].ToString());
                classData.Child = int.Parse(read["Child"].ToString());
                classData.LastNode = int.Parse(read["LastNode"].ToString());
                classData.Example = read["Example"].ToString();
                all.Add(classData);
            }
            read.Close();
            return all;
        }
    }

}