dtempcourse.cs

这是一个自动排课软件(包含源码,需求分析,详细设计).希望对你有所帮助.

using System;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using Entities;
using Search;

namespace DAL.SqlServer
{
    public class DTempCourse : IDTempCourse
    {
        #region 插入实体操作部份
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="cmd">Command对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        private int Insert(SqlCommand cmd, TempCourse tempCourse)
        {
            cmd.Parameters.Clear();
            cmd.CommandText = "insert into TempCourse (TempCourse_Name,Is_Valid,TempCourse_Color) values (@TempCourse_Name,@Is_Valid,@TempCourse_Color)";
            //从实体中取出值放入Command的参数列表
            cmd.Parameters.Add(new SqlParameter("@TempCourse_Name", tempCourse.TempCourseName));
            cmd.Parameters.Add(new SqlParameter("@Is_Valid", tempCourse.IsValid));
            cmd.Parameters.Add(new SqlParameter("@TempCourse_Color", tempCourse.TempCourseColor));
            return cmd.ExecuteNonQuery();
        }
        /// <summary>
        /// 不使用事务的插入方法
        /// </summary>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Insert(TempCourse tempCourse)
        {
            int result = 0;
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    result = Insert(cmd, tempCourse);
                }
            }
            return result;
        }

        /// <summary>
        /// 使用事务的插入方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Insert(IConnection connection, TempCourse tempCourse)
        {
            SqlCommand cmd = connection.Command as SqlCommand;
            return Insert(cmd, tempCourse);
        }
        #endregion

        #region 删除实体操作

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="cmd">Command对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        private int ExcuteDeleteCommand(SqlCommand cmd, TempCourse tempCourse)
        {
            cmd.Parameters.Clear();
            cmd.CommandText = "delete TempCourse where TempCourse_ID=@TempCourse_ID";
            //从实体中取出值放入Command的参数列表
            cmd.Parameters.Add(new SqlParameter("@TempCourse_ID", tempCourse.TempCourseID));
            return cmd.ExecuteNonQuery();

        }
        /// <summary>
        /// 不使用事务的删除方法
        /// </summary>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(TempCourse tempCourse)
        {
            int result = 0;
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {

                    result = ExcuteDeleteCommand(cmd, tempCourse);
                }
            }
            return result;
        }

        /// <summary>
        /// 使用事务的删除方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(IConnection connection, TempCourse tempCourse)
        {
            int result = 0;
            SqlCommand cmd = connection.Command as SqlCommand;
            result = ExcuteDeleteCommand(cmd, tempCourse);
            return result;
        }

        /// <summary>
        /// 根据查询对象构建过滤条件并使用事务的删除方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(IConnection connection, TempCourseSearcher searcher)
        {
            int result = 0;
            string condition = string.Empty;
            SqlCommand cmd = connection.Command as SqlCommand;
            cmd.Parameters.Clear();
            if (searcher.TempCourseIDIsValid)
            {
                condition += " and TempCourse_ID=@TempCourse_ID";
                cmd.Parameters.Add(new SqlParameter("@TempCourse_ID", searcher.TempCourseID));
            }
            if (searcher.TempCourseNameIsValid)
            {
                condition += " and TempCourse_Name=@TempCourse_Name";
                cmd.Parameters.Add(new SqlParameter("@TempCourse_Name", searcher.TempCourseName));
            }
            if (searcher.IsValidIsValid)
            {
                condition += " and Is_Valid=@Is_Valid";
                cmd.Parameters.Add(new SqlParameter("@Is_Valid", searcher.IsValid));
            }
            if (searcher.TempCourseColorIsValid)
            {
                condition += " and TempCourse_Color=@TempCourse_Color";
                cmd.Parameters.Add(new SqlParameter("@TempCourse_Color", searcher.TempCourseColor));
            }
            if (condition != string.Empty)
            {
                condition = " where " + condition;
            }
            cmd.CommandText = "delete from  TempCourse " + condition;
            result = cmd.ExecuteNonQuery();

            return result;
        }
        /// <summary>
        /// 根据查询对象构建过滤条件并不使用事务的删除方法
        /// </summary>
        /// <param name="searcher">查询对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(TempCourseSearcher searcher)
        {
            int result = 0;
            string condition = string.Empty;
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    if (searcher.TempCourseIDIsValid)
                    {
                        condition += " and TempCourse_ID=@TempCourse_ID";
                        cmd.Parameters.Add(new SqlParameter("@TempCourse_ID", searcher.TempCourseID));
                    }
                    if (searcher.TempCourseNameIsValid)
                    {
                        condition += " and TempCourse_Name=@TempCourse_Name";
                        cmd.Parameters.Add(new SqlParameter("@TempCourse_Name", searcher.TempCourseName));
                    }
                    if (searcher.IsValidIsValid)
                    {
                        condition += " and Is_Valid=@Is_Valid";
                        cmd.Parameters.Add(new SqlParameter("@Is_Valid", searcher.IsValid));
                    }
                    if (searcher.TempCourseColorIsValid)
                    {
                        condition += " and TempCourse_Color=@TempCourse_Color";
                        cmd.Parameters.Add(new SqlParameter("@TempCourse_Color", searcher.TempCourseColor));
                    }
                    if (condition != string.Empty)
                    {
                        condition = " where " + condition;
                    }
                    cmd.CommandText = "delete from  TempCourse " + condition;
                    result = cmd.ExecuteNonQuery();
                }
            }
            return result;
        }
        #endregion

        #region 更新实体操作

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="cmd">Command对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        private int ExcuteUpdateCommand(SqlCommand cmd, TempCourse tempCourse)
        {
            cmd.CommandText = "update TempCourse set TempCourse_Name=@TempCourse_Name,Is_Valid=@Is_Valid,TempCourse_Color=@TempCourse_Color where TempCourse_ID=@TempCourse_ID";
            //从实体中取出值放入Command的参数列表
            cmd.Parameters.Add(new SqlParameter("@TempCourse_Name", tempCourse.TempCourseName));
            cmd.Parameters.Add(new SqlParameter("@Is_Valid", tempCourse.IsValid));
            cmd.Parameters.Add(new SqlParameter("@TempCourse_Color", tempCourse.TempCourseColor));
            cmd.Parameters.Add(new SqlParameter("@TempCourse_ID", tempCourse.TempCourseID));
            return cmd.ExecuteNonQuery();
        }

        /// <summary>
        /// 不使用事务的更新方法
        /// </summary>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Update(TempCourse tempCourse)
        {
            int result = 0;
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    result = ExcuteUpdateCommand(cmd, tempCourse);
                }
            }
            return result;
        }
        /// <summary>
        /// 使用事务的更新方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="tempCourse">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Update(IConnection connection, TempCourse tempCourse)
        {
            int result = 0;
            SqlCommand cmd = connection.Command as SqlCommand;
            result = ExcuteUpdateCommand(cmd, tempCourse);
            return result;
        }
        /// <summary>
        /// 根据查询对象构建过滤条件并不使用事务的更新方法
        /// </summary>
        /// <param name="searcher">查询对象</param>
        /// <param name="newValues">要更新的新值</param>
        /// <returns>影响的记录行数</returns>
        public int Update(TempCourseSearcher searcher, TempCourseSearcher newValues)
        {
            int result = 0;
            string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    //string updateString=GetUpdateString(cmd, newValues)+condition;
                    string updateString = string.Empty;
                    string condition = string.Empty;
                    if (newValues.TempCourseIDIsValid)
                    {
                        updateString += ",TempCourse_ID=@TempCourse_ID_V";
                        cmd.Parameters.Add(new SqlParameter("@TempCourse_ID_V", newValues.TempCourseID));
                    }
                    if (newValues.TempCourseNameIsValid)
                    {
                        updateString += ",TempCourse_Name=@TempCourse_Name_V";
                        cmd.Parameters.Add(new SqlParameter("@TempCourse_Name_V", newValues.TempCourseName));
                    }
                    if (newValues.IsValidIsValid)
                    {
                        updateString += ",Is_Valid=@Is_Valid_V";
                        cmd.Parameters.Add(new SqlParameter("@Is_Valid_V", newValues.IsValid));
                    }
                    if (newValues.TempCourseColorIsValid)
                    {
                        updateString += ",TempCourse_Color=@TempCourse_Color_V";
                        cmd.Parameters.Add(new SqlParameter("@TempCourse_Color_V", newValues.TempCourseColor));
                    }
                    if (searcher.TempCourseIDIsValid)
                    {
                        condition += " and TempCourse_ID=@TempCourse_ID_C";