dcourseteacherchanging.cs

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

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

namespace DAL.SqlServer
{
    public class DCourseTeacherChanging : IDCourseTeacherChanging
    {
        #region 插入实体操作部份
        /// <summary>
        /// 插入
        /// </summary>
        /// <param name="cmd">Command对象</param>
        /// <param name="courseTeacherChanging">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        private int Insert(SqlCommand cmd, CourseTeacherChanging courseTeacherChanging)
        {
            cmd.Parameters.Clear();
            cmd.CommandText = "insert into CourseTeacherChanging (TeachPlan_ID,Teacher_ID,Inure_Date) values (@TeachPlan_ID,@Teacher_ID,@Inure_Date)";
            //从实体中取出值放入Command的参数列表
            cmd.Parameters.Add(new SqlParameter("@TeachPlan_ID", courseTeacherChanging.TeachPlanID));
            cmd.Parameters.Add(new SqlParameter("@Teacher_ID", courseTeacherChanging.TeacherID));
            cmd.Parameters.Add(new SqlParameter("@Inure_Date", courseTeacherChanging.InureDate));
            return cmd.ExecuteNonQuery();
        }
        /// <summary>
        /// 不使用事务的插入方法
        /// </summary>
        /// <param name="courseTeacherChanging">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Insert(CourseTeacherChanging courseTeacherChanging)
        {
            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, courseTeacherChanging);
                }
            }
            return result;
        }

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

        #region 删除实体操作

        /// <summary>
        /// 不使用事务的删除方法
        /// </summary>
        /// <param name="courseTeacherChanging">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(CourseTeacherChanging courseTeacherChanging)
        {
            int result = 0;
            return result;
        }

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

        /// <summary>
        /// 根据查询对象构建过滤条件并使用事务的删除方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="courseTeacherChanging">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(IConnection connection, CourseTeacherChangingSearcher searcher)
        {
            int result = 0;
            string condition = string.Empty;
            SqlCommand cmd = connection.Command as SqlCommand;
            cmd.Parameters.Clear();
            if (searcher.TeachPlanIDIsValid)
            {
                condition += " and TeachPlan_ID=@TeachPlan_ID";
                cmd.Parameters.Add(new SqlParameter("@TeachPlan_ID", searcher.TeachPlanID));
            }
            if (searcher.TeacherIDIsValid)
            {
                condition += " and Teacher_ID=@Teacher_ID";
                cmd.Parameters.Add(new SqlParameter("@Teacher_ID", searcher.TeacherID));
            }
            if (searcher.InureDateIsValid)
            {
                condition += " and Inure_Date=@Inure_Date";
                cmd.Parameters.Add(new SqlParameter("@Inure_Date", searcher.InureDate));
            }
            if (condition != string.Empty)
            {
                condition = " where " + condition;
            }
            cmd.CommandText = "delete from  CourseTeacherChanging " + condition;
            result = cmd.ExecuteNonQuery();

            return result;
        }
        /// <summary>
        /// 根据查询对象构建过滤条件并不使用事务的删除方法
        /// </summary>
        /// <param name="searcher">查询对象</param>
        /// <returns>影响的记录行数</returns>
        public int Delete(CourseTeacherChangingSearcher 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.TeachPlanIDIsValid)
                    {
                        condition += " and TeachPlan_ID=@TeachPlan_ID";
                        cmd.Parameters.Add(new SqlParameter("@TeachPlan_ID", searcher.TeachPlanID));
                    }
                    if (searcher.TeacherIDIsValid)
                    {
                        condition += " and Teacher_ID=@Teacher_ID";
                        cmd.Parameters.Add(new SqlParameter("@Teacher_ID", searcher.TeacherID));
                    }
                    if (searcher.InureDateIsValid)
                    {
                        condition += " and Inure_Date=@Inure_Date";
                        cmd.Parameters.Add(new SqlParameter("@Inure_Date", searcher.InureDate));
                    }
                    if (condition != string.Empty)
                    {
                        condition = " where " + condition;
                    }
                    cmd.CommandText = "delete from  CourseTeacherChanging " + condition;
                    result = cmd.ExecuteNonQuery();
                }
            }
            return result;
        }
        #endregion

        #region 更新实体操作

        /// <summary>
        /// 不使用事务的更新方法
        /// </summary>
        /// <param name="courseTeacherChanging">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Update(CourseTeacherChanging courseTeacherChanging)
        {
            int result = 0;
            return result;
        }
        /// <summary>
        /// 使用事务的更新方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="courseTeacherChanging">实体类对象</param>
        /// <returns>影响的记录行数</returns>
        public int Update(IConnection connection, CourseTeacherChanging courseTeacherChanging)
        {
            int result = 0;
            return result;
        }
        /// <summary>
        /// 根据查询对象构建过滤条件并不使用事务的更新方法
        /// </summary>
        /// <param name="searcher">查询对象</param>
        /// <param name="newValues">要更新的新值</param>
        /// <returns>影响的记录行数</returns>
        public int Update(CourseTeacherChangingSearcher searcher, CourseTeacherChangingSearcher 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.TeachPlanIDIsValid)
                    {
                        updateString += ",TeachPlan_ID=@TeachPlan_ID_V";
                        cmd.Parameters.Add(new SqlParameter("@TeachPlan_ID_V", newValues.TeachPlanID));
                    }
                    if (newValues.TeacherIDIsValid)
                    {
                        updateString += ",Teacher_ID=@Teacher_ID_V";
                        cmd.Parameters.Add(new SqlParameter("@Teacher_ID_V", newValues.TeacherID));
                    }
                    if (newValues.InureDateIsValid)
                    {
                        updateString += ",Inure_Date=@Inure_Date_V";
                        cmd.Parameters.Add(new SqlParameter("@Inure_Date_V", newValues.InureDate));
                    }
                    if (searcher.TeachPlanIDIsValid)
                    {
                        condition += " and TeachPlan_ID=@TeachPlan_ID_C";
                        cmd.Parameters.Add(new SqlParameter("@TeachPlan_ID_C", searcher.TeachPlanID));
                    }
                    if (searcher.TeacherIDIsValid)
                    {
                        condition += " and Teacher_ID=@Teacher_ID_C";
                        cmd.Parameters.Add(new SqlParameter("@Teacher_ID_C", searcher.TeacherID));
                    }
                    if (searcher.InureDateIsValid)
                    {
                        condition += " and Inure_Date=@Inure_Date_C";
                        cmd.Parameters.Add(new SqlParameter("@Inure_Date_C", searcher.InureDate));
                    }
                    if (condition != string.Empty)
                    {
                        condition = " where" + condition.Substring(4);
                    }
                    cmd.CommandText = "update CourseTeacherChanging set " + updateString.Substring(1) + condition;
                    result = cmd.ExecuteNonQuery();
                }
            }
            return result;
        }
        /// <summary>
        /// 根据查询对象构建过滤条件并使用事务的更新方法
        /// </summary>
        /// <param name="connection">实现共享Command的对象</param>
        /// <param name="searcher">查询对象</param>