dholiday.cs

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

			            cmd.Parameters.Add(new SqlParameter("@Start_Date_C",searcher.StartDate));
					}
		            if(searcher.EndDateIsValid)
			        {
			            condition += " and End_Date=@End_Date_C";
			            cmd.Parameters.Add(new SqlParameter("@End_Date_C",searcher.EndDate));
					}
		            if(searcher.AMStartIsValid)
			        {
			            condition += " and AM_Start=@AM_Start_C";
			            cmd.Parameters.Add(new SqlParameter("@AM_Start_C",searcher.AMStart));
					}
		            if(searcher.AMEndIsValid)
			        {
			            condition += " and AM_End=@AM_End_C";
			            cmd.Parameters.Add(new SqlParameter("@AM_End_C",searcher.AMEnd));
					}
					if(condition != string.Empty)
					{
						condition=" where"+condition.Substring(4);
					}
				    cmd.CommandText="update Holiday set "+updateString.Substring(1)+condition;
                    result=cmd.ExecuteNonQuery();
                }
			}
			return result;
		}
		/// <summary>
        /// 根据查询对象构建过滤条件并使用事务的更新方法
        /// </summary>
		/// <param name="connection">实现共享Command的对象</param>
        /// <param name="searcher">查询对象</param>
		/// <param name="newValues">要更新的新值</param>
        /// <returns>影响的记录行数</returns>
	    public int Update(IConnection connection,HolidaySearcher searcher,HolidaySearcher newValues)
		{
		    string updateString = string.Empty;
		    string condition = string.Empty;
			SqlCommand cmd=connection.Command as SqlCommand;
			cmd.Parameters.Clear();
		    if(newValues.HolidayIDIsValid)
			{
			    updateString += ",Holiday_ID=@Holiday_ID_V";
			    cmd.Parameters.Add(new SqlParameter("@Holiday_ID_V",newValues.HolidayID));
            }
		    if(newValues.ClassIDIsValid)
			{
			    updateString += ",Class_ID=@Class_ID_V";
			    cmd.Parameters.Add(new SqlParameter("@Class_ID_V",newValues.ClassID));
            }
		    if(newValues.StartDateIsValid)
			{
			    updateString += ",Start_Date=@Start_Date_V";
			    cmd.Parameters.Add(new SqlParameter("@Start_Date_V",newValues.StartDate));
            }
		    if(newValues.EndDateIsValid)
			{
			    updateString += ",End_Date=@End_Date_V";
			    cmd.Parameters.Add(new SqlParameter("@End_Date_V",newValues.EndDate));
            }
		    if(newValues.AMStartIsValid)
			{
			    updateString += ",AM_Start=@AM_Start_V";
			    cmd.Parameters.Add(new SqlParameter("@AM_Start_V",newValues.AMStart));
            }
		    if(newValues.AMEndIsValid)
			{
			    updateString += ",AM_End=@AM_End_V";
			    cmd.Parameters.Add(new SqlParameter("@AM_End_V",newValues.AMEnd));
            }
		    if(searcher.HolidayIDIsValid)
			{
			    condition += " and Holiday_ID=@Holiday_ID_C";
			    cmd.Parameters.Add(new SqlParameter("@Holiday_ID_C",searcher.HolidayID));
		    }
		    if(searcher.ClassIDIsValid)
			{
			    condition += " and Class_ID=@Class_ID_C";
			    cmd.Parameters.Add(new SqlParameter("@Class_ID_C",searcher.ClassID));
		    }
		    if(searcher.StartDateIsValid)
			{
			    condition += " and Start_Date=@Start_Date_C";
			    cmd.Parameters.Add(new SqlParameter("@Start_Date_C",searcher.StartDate));
		    }
		    if(searcher.EndDateIsValid)
			{
			    condition += " and End_Date=@End_Date_C";
			    cmd.Parameters.Add(new SqlParameter("@End_Date_C",searcher.EndDate));
		    }
		    if(searcher.AMStartIsValid)
			{
			    condition += " and AM_Start=@AM_Start_C";
			    cmd.Parameters.Add(new SqlParameter("@AM_Start_C",searcher.AMStart));
		    }
		    if(searcher.AMEndIsValid)
			{
			    condition += " and AM_End=@AM_End_C";
			    cmd.Parameters.Add(new SqlParameter("@AM_End_C",searcher.AMEnd));
		    }
			if(condition != string.Empty)
			{
				condition=" where"+condition.Substring(4);
			}
		    cmd.CommandText="update Holiday set "+updateString.Substring(1)+condition;
            return cmd.ExecuteNonQuery();
		}
		#endregion
		
		#region 查询实体集合
		/// <summary>
        /// 根据查询对象构建过滤条件查询
        /// </summary>
        /// <param name="searcher">查询对象</param>
        /// <returns>实体类对象列表</returns>
        public ArrayList Select(HolidaySearcher searcher)
        {
            ArrayList entities = new ArrayList();
			string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
			using(SqlConnection conn=new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
					entities = Select(cmd,searcher);
				}
            }
			return entities;
        }
		/// <summary>
        /// 使用事务并且依据查询对象构建过滤条件查询
        /// </summary>
		/// <param name="connection">实现共享Command的对象</param>
        /// <param name="searcher">查询对象</param>
        /// <returns>实体类对象列表</returns>
        public ArrayList Select(IConnection connection, HolidaySearcher searcher)
        {
		    SqlCommand cmd=connection.Command as SqlCommand;
            return Select(cmd,searcher);
        }
		public ArrayList Select(SqlCommand command,HolidaySearcher searcher)
		{
		    string condition=string.Empty;
		    command.Parameters.Clear();
			ArrayList entities = new ArrayList();
		    if(searcher.HolidayIDIsValid)
			{
			    condition += " and Holiday_ID=@Holiday_ID_C";
			    command.Parameters.Add(new SqlParameter("@Holiday_ID_C",searcher.HolidayID));
		    }
		    if(searcher.ClassIDIsValid)
			{
			    condition += " and Class_ID=@Class_ID_C";
			    command.Parameters.Add(new SqlParameter("@Class_ID_C",searcher.ClassID));
		    }
		    if(searcher.StartDateIsValid)
			{
			    condition += " and Start_Date=@Start_Date_C";
			    command.Parameters.Add(new SqlParameter("@Start_Date_C",searcher.StartDate));
		    }
		    if(searcher.EndDateIsValid)
			{
			    condition += " and End_Date=@End_Date_C";
			    command.Parameters.Add(new SqlParameter("@End_Date_C",searcher.EndDate));
		    }
		    if(searcher.AMStartIsValid)
			{
			    condition += " and AM_Start=@AM_Start_C";
			    command.Parameters.Add(new SqlParameter("@AM_Start_C",searcher.AMStart));
		    }
		    if(searcher.AMEndIsValid)
			{
			    condition += " and AM_End=@AM_End_C";
			    command.Parameters.Add(new SqlParameter("@AM_End_C",searcher.AMEnd));
		    }
			if(condition != string.Empty)
			{
				condition=" where"+condition.Substring(4);
			}
			
            command.CommandText = "select * from Holiday"+condition;
            return ExcuteSelectCommand(command);
		}
		/// <summary>
        /// 执行Command获取对象列表
        /// </summary>
        /// <param name="cmd">Command对象</param>
        /// <returns>实体类对象列表</returns>
        private ArrayList ExcuteSelectCommand(SqlCommand cmd)
        {
            ArrayList entities = new ArrayList();
            using (SqlDataReader dr = cmd.ExecuteReader())
            {
                while (dr.Read())
                {
                    Holiday  entity = DataReaderToEntity(dr);
                    entities.Add(entity);
                }
            }
			SetForeignKeyEntity(cmd, ref entities);
			return entities;
        }
		private void SetForeignKeyEntity(SqlCommand command, ref ArrayList entities)
		{
		    //由外键获取相关实体
			DClass dClass=new DClass();
			foreach(Holiday  entity in entities)
			{
	            entity.Class = dClass.SelectSingle(command,entity.ClassID);
			}
		}
        /// <summary>
        /// 查询所有实体
        /// </summary>
        /// <returns>实体类对象列表</returns>
        public ArrayList Select()
        {
            ArrayList entities = new ArrayList();
			string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
			using(SqlConnection conn=new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = "select * from Holiday";
                    entities=ExcuteSelectCommand(cmd);
                }
                return entities;
            }
        }
		/// <summary>
        /// 使用事务查询查询所有实体
        /// </summary>
		/// <param name="connection">实现共享Command的对象</param>
        /// <param name="searcher">查询对象</param>
        /// <returns>实体类对象列表</returns>
        public ArrayList Select(IConnection connection)
        {
            ArrayList entities = new ArrayList();
            SqlCommand cmd=connection.Command as SqlCommand;
			cmd.Parameters.Clear();
            cmd.CommandText = "select * from Holiday";
            return ExcuteSelectCommand(cmd);
        }
		#endregion
		
		#region 查询单个实体
		/// <summary>
        /// 按主键字段查询特定实体
        /// </summary>
        /// <param name="pkValue">主键值</param>
        /// <returns>实体类对象</returns>
        public Holiday SelectSingle(object pkValue)
        {
		    Holiday entity=null;
			string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
			using(SqlConnection conn=new SqlConnection(connectionString))
            {
                conn.Open();
                using (SqlCommand cmd = conn.CreateCommand())
                {
                    entity=SelectSingle(cmd,pkValue);
                }   
            } 
			return entity;
        }
		
		/// <summary>
        /// 使用事务并按主键字段查询特定实体
        /// </summary>
        /// <param name="pkValue">主键值</param>
        /// <returns>实体类对象</returns>
        public Holiday SelectSingle(IConnection connection,object pkValue)
        {
		    SqlCommand cmd=connection.Command as SqlCommand;
			return SelectSingle(cmd,pkValue);
            
        }
		public Holiday SelectSingle(SqlCommand command,object pkValue)
		{
		    Holiday entity=null;
		    command.Parameters.Clear();
		    command.CommandText = "select * from Holiday where Holiday_ID=@pk";
			command.Parameters.Add(new SqlParameter("@pk",pkValue));
			using (SqlDataReader dr = command.ExecuteReader())
            {
			    if(dr.Read())
				    entity = DataReaderToEntity(dr);
			}
						
			//由外键获取相关实体
			DClass dClass=new DClass();
	        entity.Class = dClass.SelectSingle(command,entity.ClassID);
            return entity;
		}
		#endregion
		
				
		/// <summary>
        /// 从DataReader中取出值生成实体对象
        /// </summary>
        /// <param name="searcher">查询对象</param>
        /// <returns>过滤条件字符串</returns>
		private Holiday DataReaderToEntity(SqlDataReader dr)
		{
		    Holiday entity = new Holiday ();
			if(dr["Holiday_ID"]!=System.DBNull.Value)
			{
			    entity.HolidayID=Convert.ToInt32(dr["Holiday_ID"]);
			}
			if(dr["Class_ID"]!=System.DBNull.Value)
			{
			    entity.ClassID=Convert.ToInt32(dr["Class_ID"]);
			}
			if(dr["Start_Date"]!=System.DBNull.Value)
			{
			    entity.StartDate=Convert.ToDateTime(dr["Start_Date"]);
			}
			if(dr["End_Date"]!=System.DBNull.Value)
			{
			    entity.EndDate=Convert.ToDateTime(dr["End_Date"]);
			}
			if(dr["AM_Start"]!=System.DBNull.Value)
			{
			    entity.AMStart=Convert.ToBoolean(dr["AM_Start"]);
			}
			if(dr["AM_End"]!=System.DBNull.Value)
			{
			    entity.AMEnd=Convert.ToBoolean(dr["AM_End"]);
			}
			return entity;
		}
	}
}