录播教室预约系统(四)-ClassRoom表[带有外键的表]

最新推荐文章于 2022-04-11 14:48:13 发布
最新推荐文章于 2022-04-11 14:48:13 发布
阅读量734 收藏
点赞数
分类专栏： NetworkComms-功能教室预约系统
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/networkcomms/article/details/43645627
版权

ClassRoom是与教室信息相关的表，包含教室的名称

 

这个表比前面介绍的DepTable表稍微复杂点，他有一列DepID 这列是与DepTable表中的ID相对应的的。

有了DepID这一列，我们就可以根据DepID 获取某单位的所有教室。

我们暂时把DepID这一列叫做外键列吧。对于拥有外键列的表，仍然可以用我们的codesmith模板生成相关的存储过程和类。有的时候我们希望能够以外键为参数查找相关的数据，

所以在对应的codesmith模板中增加了以外键为参数查找和以外键为参数自动分页查找的相关的代码。分页查找的存储过程和方法也都是自动生成的。

下面我们来举例说明：

 第一步 生成存储过程，如下图，外键列名是必须填写的：

生成的存储过程如下：

 
/****** Object:  Stored Procedure [dbo].ClassRoom_Delete    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_Delete]
GO

/****** Object:  Stored Procedure [dbo].ClassRoom_SelectOne    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_SelectOne]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_SelectOne]
GO

/****** Object:  Stored Procedure [dbo].ClassRoom_SelectTopList    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_SelectTopList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_SelectTopList]
GO

/****** Object:  Stored Procedure [dbo].ClassRoom_GetCount    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_GetCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_GetCount]
GO

/****** Object:  Stored Procedure [dbo].ClassRoom_GetListCount    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_GetListCount]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_GetListCount]
GO

    
/****** Object:  Stored Procedure [dbo].ClassRoom_SelectAll    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_SelectAll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_SelectAll]
GO

/****** Object:  Stored Procedure [dbo].ClassRoom_Insert    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_Insert]
GO

/****** Object:  Stored Procedure [dbo].ClassRoom_Update    Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_Update]
GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER ON 
GO


CREATE PROCEDURE [dbo].ClassRoom_Delete

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

@Id int

AS

DELETE FROM [dbo].[ClassRoom]
WHERE
    [Id] = @Id
GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO



SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER ON 
GO



CREATE PROCEDURE [dbo].ClassRoom_GetCount

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

AS

SELECT COUNT(*) FROM [dbo].[ClassRoom]

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO





SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER ON 
GO

CREATE PROCEDURE [dbo].ClassRoom_GetListCount

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

@DepID  int

AS

SELECT COUNT(*) FROM [dbo].[ClassRoom] Where DepID=@DepID

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO



SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO


CREATE PROCEDURE [dbo].ClassRoom_SelectOne

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

@Id int

AS


SELECT
        [Id],
        [RoomName],
        [DepID],
        [Department]
        
FROM
        [dbo].[ClassRoom]
        
WHERE
        [Id] = @Id

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO






SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO


CREATE PROCEDURE [dbo].ClassRoom_SelectTopList 

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

@DepID  int

AS


SELECT  top 10
        [Id],
        [RoomName],
        [DepID],
        [Department]
        
FROM
        [dbo].[ClassRoom]
        
WHERE
         DepID=@DepID

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO







SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER ON 
GO


CREATE PROCEDURE [dbo].ClassRoom_SelectAll

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

AS


SELECT
        [Id],
        [RoomName],
        [DepID],
        [Department]
        
FROM
        [dbo].[ClassRoom]

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO


SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER ON 
GO



CREATE PROCEDURE [dbo].ClassRoom_Insert

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/

@RoomName nvarchar(200),
@DepID int,
@Department nvarchar(200)

    
AS

INSERT INTO     [dbo].[ClassRoom] 
(
                [RoomName],
                [DepID],
                [Department]
) 

VALUES 
(
                @RoomName,
                @DepID,
                @Department
                
)
SELECT @@IDENTITY 


GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO


SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER ON 
GO



CREATE PROCEDURE [dbo].ClassRoom_Update

/*
Author:               msdc
Created:             2015-2-8
Last Modified:         2015-2-8
*/
    
@Id int, 
@RoomName nvarchar(200), 
@DepID int, 
@Department nvarchar(200) 


AS

UPDATE         [dbo].[ClassRoom] 

SET
            [RoomName] = @RoomName,
            [DepID] = @DepID,
            [Department] = @Department
            
WHERE
            [Id] = @Id

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO


/****** Object:  Stored Procedure [dbo].ClassRoom_SelectPage   Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_SelectPage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_SelectPage]
GO



CREATE PROCEDURE [dbo].ClassRoom_SelectPage

-- Author:               msdc
-- Created:             2015-2-8
-- Last Modified:         2015-2-8

@PageNumber             int,
@PageSize             int

AS

DECLARE @PageLowerBound int
DECLARE @PageUpperBound int


SET @PageLowerBound = (@PageSize * @PageNumber) - @PageSize
SET @PageUpperBound = @PageLowerBound + @PageSize + 1

/*
Note: temp tables use the server default for collation not the database default
so if adding character columns be sure and specify to use the database collation like this
to avoid collation errors:

CREATE TABLE #PageIndexForUsers
(
IndexID int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(50) COLLATE DATABASE_DEFAULT,
LoginName nvarchar(50) COLLATE DATABASE_DEFAULT
) 


*/

CREATE TABLE #PageIndex 
(
    IndexID int IDENTITY (1, 1) NOT NULL,
Id Int
)

BEGIN

INSERT INTO #PageIndex ( 
Id
)

SELECT
        [Id]
        
FROM
        [dbo].[ClassRoom]
        
-- WHERE

-- ORDER BY

END


SELECT
        t1.*
        
FROM
        [dbo].[ClassRoom] t1

JOIN            #PageIndex t2
ON            
        t1.[Id] = t2.[Id]
        
WHERE
        t2.IndexID > @PageLowerBound 
        AND t2.IndexID < @PageUpperBound
        
ORDER BY t2.IndexID

DROP TABLE #PageIndex

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO



/****** Object:  Stored Procedure [dbo].ClassRoom_SelectPage   Script Date: 2015年2月8日 ******/
if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[ClassRoom_SelectListPage]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ClassRoom_SelectListPage]
GO



CREATE PROCEDURE [dbo].ClassRoom_SelectListPage

-- Author:               msdc
-- Created:             2015-2-8
-- Last Modified:         2015-2-8

@PageNumber             int,
@PageSize             int,
@DepID  int

AS

DECLARE @PageLowerBound int
DECLARE @PageUpperBound int


SET @PageLowerBound = (@PageSize * @PageNumber) - @PageSize
SET @PageUpperBound = @PageLowerBound + @PageSize + 1

/*
Note: temp tables use the server default for collation not the database default
so if adding character columns be sure and specify to use the database collation like this
to avoid collation errors:

CREATE TABLE #PageIndexForUsers
(
IndexID int IDENTITY (1, 1) NOT NULL,
UserName nvarchar(50) COLLATE DATABASE_DEFAULT,
LoginName nvarchar(50) COLLATE DATABASE_DEFAULT
) 


*/

CREATE TABLE #PageIndex 
(
    IndexID int IDENTITY (1, 1) NOT NULL,
Id Int
)

BEGIN

INSERT INTO #PageIndex ( 
Id
)

SELECT
        [Id]
        
FROM
        [dbo].[ClassRoom]  Where DepID=@DepID  order by  
Id
  DESC
        
-- WHERE

-- ORDER BY

END


SELECT
        t1.*
        
FROM
        [dbo].[ClassRoom] t1

JOIN            #PageIndex t2
ON            
        t1.[Id] = t2.[Id]
        
WHERE
        t2.IndexID > @PageLowerBound 
        AND t2.IndexID < @PageUpperBound
        
ORDER BY t2.IndexID

DROP TABLE #PageIndex

GO

SET ANSI_NULLS OFF 
GO

SET QUOTED_IDENTIFIER OFF 
GO
CodeSmith模板生成的存储过程

生成的存储过程如下：

ClassRoom_Delete
ClassRoom_GetCount
ClassRoom_SelectOne
ClassRoom_SelectAll
ClassRoom_Insert
ClassRoom_Update
ClassRoom_SelectPage

比普通表多了3个，如下

ClassRoom_SelectTopList  根据外键获取前10条
ClassRoom_GetListCount  根据外键获取总数
ClassRoom_SelectListPage 根据外键获取分页数据

 

第二步：用CodeSmith模板生成数据层代码：

 

// Author:                    msdc
// Created:                    2015-2-8
// Last Modified:            2015-2-8


using System;
using System.IO;
using System.Text;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Configuration;
using mojoPortal.Data;
    
namespace mojoPortal.Data
{
    
    public static class DBClassRoomConfig
    {
        /// <summary>
        /// Gets the connection string for read.
        /// </summary>
        /// <returns></returns>
        private static string GetReadConnectionString()
        {
            return ConfigurationManager.AppSettings["MSSQLConnectionString"];

        }

        /// <summary>
        /// Gets the connection string for write.
        /// </summary>
        /// <returns></returns>
        private static string GetWriteConnectionString()
        {
            if (ConfigurationManager.AppSettings["MSSQLWriteConnectionString"] != null)
            {
                return ConfigurationManager.AppSettings["MSSQLWriteConnectionString"];
            }

            return ConfigurationManager.AppSettings["MSSQLConnectionString"];

        }


        /// <summary>
        /// Inserts a row in the ClassRoomConfig table. Returns new integer id.
        /// </summary>
        /// <param name="daySpan"> daySpan </param>
        /// <param name="stopTime"> stopTime </param>
        /// <param name="roomID"> roomID </param>
        /// <param name="roomName"> roomName </param>
        /// <param name="modifyDate"> modifyDate </param>
        /// <returns>int</returns>
        public static int Create(
            int daySpan, 
            int stopTime, 
            int roomID, 
            string roomName, 
            DateTime modifyDate) 
        {
            SqlParameterHelper sph = new SqlParameterHelper(GetWriteConnectionString(), "ClassRoomConfig_Insert", 5);
            sph.DefineSqlParameter("@DaySpan", SqlDbType.Int, ParameterDirection.Input, daySpan);
            sph.DefineSqlParameter("@StopTime", SqlDbType.Int, ParameterDirection.Input, stopTime);
            sph.DefineSqlParameter("@RoomID", SqlDbType.Int, ParameterDirection.Input, roomID);
            sph.DefineSqlParameter("@RoomName", SqlDbType.NVarChar, 200, ParameterDirection.Input, roomName);
            sph.DefineSqlParameter("@ModifyDate", SqlDbType.DateTime, ParameterDirection.Input, modifyDate);
            int newID = Convert.ToInt32(sph.ExecuteScalar());
            return newID;
        }


        /// <summary>
        /// Updates a row in the ClassRoomConfig table. Returns true if row updated.
        /// </summary>
        /// <param name="id"> id </param>
        /// <param name="daySpan"> daySpan </param>
        /// <param name="stopTime"> stopTime </param>
        /// <param name="roomID"> roomID </param>
        /// <param name="roomName"> roomName </param>
        /// <param name="modifyDate"> modifyDate </param>
        /// <returns>bool</returns>
        public static bool Update(
            int  id, 
            int daySpan, 
            int stopTime, 
            int roomID, 
            string roomName, 
            DateTime modifyDate) 
        {
            SqlParameterHelper sph = new SqlParameterHelper(GetWriteConnectionString(), "ClassRoomConfig_Update", 6);
            sph.DefineSqlParameter("@Id", SqlDbType.Int, ParameterDirection.Input, id);
            sph.DefineSqlParameter("@DaySpan", SqlDbType.Int, ParameterDirection.Input, daySpan);
            sph.DefineSqlParameter("@StopTime", SqlDbType.Int, ParameterDirection.Input, stopTime);
            sph.DefineSqlParameter("@RoomID", SqlDbType.Int, ParameterDirection.Input, roomID);
            sph.DefineSqlParameter("@RoomName", SqlDbType.NVarChar, 200, ParameterDirection.Input, roomName);
            sph.DefineSqlParameter("@ModifyDate", SqlDbType.DateTime, ParameterDirection.Input, modifyDate);
            int rowsAffected = sph.ExecuteNonQuery();
            return (rowsAffected > 0);
            
        }
        
        /// <summary>
        /// Deletes a row from the ClassRoomConfig table. Returns true if row deleted.
        /// </summary>
        /// <param name="id"> id </param>
        /// <returns>bool</returns>
        public static bool Delete(
            int id) 
        {
            SqlParameterHelper sph = new SqlParameterHelper(GetWriteConnectionString(), "ClassRoomConfig_Delete", 1);
            sph.DefineSqlParameter("@Id", SqlDbType.Int, ParameterDirection.Input, id);
            int rowsAffected = sph.ExecuteNonQuery();
            return (rowsAffected > 0);
            
        }
        
         
        /// <summary>
        /// Gets an IDataReader with one row from the ClassRoomConfig table.
        /// </summary>
        /// <param name="id"> id </param>
        public static IDataReader GetOne(
            int  id)  
        {
            SqlParameterHelper sph = new SqlParameterHelper(GetReadConnectionString(), "ClassRoomConfig_SelectOne", 1);
            sph.DefineSqlParameter("@Id", SqlDbType.Int, ParameterDirection.Input, id);
            return sph.ExecuteReader();
            
        }
        
        
        
            /// <summary>
        /// Gets an IDataReader with some list row from the ClassRoomConfig table.
        /// </summary>
        /// <param name="id"> id </param>
        public static IDataReader GetTopList(int foreignKey)
        {
            SqlParameterHelper sph = new SqlParameterHelper(GetReadConnectionString(), "ClassRoomConfig_SelectTopList", 1);
              sph.DefineSqlParameter("@DepID", SqlDbType.Int, ParameterDirection.Input, foreignKey);
            return sph.ExecuteReader();
            
        }
        
        
        
        /// <summary>
        /// Gets a count of rows in the ClassRoomConfig table.
        /// </summary>
        public static int GetCount()
        {
            
            return Convert.ToInt32(SqlHelper.ExecuteScalar(
                GetReadConnectionString(),
                CommandType.StoredProcedure,
                "ClassRoomConfig_GetCount",
                null));
    
        }
        
        
        
        /// <summary>
        /// Gets a Listcount of rows in the ClassRoomConfig table.
        /// </summary>
        public static int GetListCount(int foreignKey)
        {
            SqlParameter  theSqlParameter=new SqlParameter("@DepID",foreignKey);
            return Convert.ToInt32(SqlHelper.ExecuteScalar(
                GetReadConnectionString(),
                CommandType.StoredProcedure,
                "ClassRoomConfig_GetListCount",
                theSqlParameter));
    
        }
            
        
        
        /// <summary>
        /// Gets an IDataReader with all rows in the ClassRoomConfig table.
        /// </summary>
        public static IDataReader GetAll()
        {
            
            return SqlHelper.ExecuteReader(
                GetReadConnectionString(),
                CommandType.StoredProcedure,
                "ClassRoomConfig_SelectAll",
                null);
    
        }
        
        /// <summary>
        /// Gets a page of data from the ClassRoomConfig table.
        /// </summary>
        /// <param name="pageNumber">The page number.</param>
        /// <param name="pageSize">Size of the page.</param>
        /// <param name="totalPages">total pages</param>
        public static IDataReader GetPage(
            int pageNumber, 
            int pageSize,
            out int itemCount)
        {
            itemCount = GetCount();
                        
            SqlParameterHelper sph = new SqlParameterHelper(GetReadConnectionString(), "ClassRoomConfig_SelectPage", 2);
            sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
            sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
            return sph.ExecuteReader();
        
        }
        
        
        public static IDataReader GetListPage(
            int pageNumber, 
            int pageSize,
            int foreignKey,
            out int itemCount)
        {
            itemCount = GetListCount(pid);
                        
            SqlParameterHelper sph = new SqlParameterHelper(GetReadConnectionString(), "ClassRoomConfig_SelectListPage", 3);
            sph.DefineSqlParameter("@PageNumber", SqlDbType.Int, ParameterDirection.Input, pageNumber);
            sph.DefineSqlParameter("@PageSize", SqlDbType.Int, ParameterDirection.Input, pageSize);
            sph.DefineSqlParameter("@DepID", SqlDbType.Int, ParameterDirection.Input, foreignKey);
            return sph.ExecuteReader();
        
        }
    
    }

}
CodeSmith模板生成的数据层数据

生成的方法如下：

Create
Update
Delete
GetOne
GetCount
GetAll
GetPage

比普通数据表多了3个方法

GetTopList 根据外键获取前10数据
GetListCount  根据外键获取数量
GetListPage   根据外键获取分页数据

第三步：根据外键获取实体类（客户端与服务器通讯时需使用，序列化方法使用protobuf.net)

生成的代码如下：

// Author:                    msdc
// Created:                    2015-2-8
// Last Modified:            2015-2-8

    
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using mojoportal.Data;
    
namespace mojoportal.Business
{
     [ProtoContract]
    public class ClassRoom
    {

#region Constructors

        public ClassRoom()
        {}
         

#endregion

#region Private Properties

        private int id = -1;
        private string roomName = string.Empty;
        private int depID = -1;
        private string department = string.Empty;
        
#endregion

#region Public Properties

        [ProtoMember(1)]
        public int Id 
        {
            get { return id; }
            set { id = value; }
        }
        [ProtoMember(2)]
        public string RoomName 
        {
            get { return roomName; }
            set { roomName = value; }
        }
        [ProtoMember(3)]
        public int DepID 
        {
            get { return depID; }
            set { depID = value; }
        }
        [ProtoMember(4)]
        public string Department 
        {
            get { return department; }
            set { department = value; }
        }

#endregion

 


    }
    
}
CodeSmith生成的实体类代码

这个和普通表大致相同

 

第四步：生成操作类：

生成代码如下：

// Author:                    msdc
// Created:                    2015-2-8
// Last Modified:            2015-2-8

    
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using mojoportal.Data;
    
namespace mojoportal.Business
{
    
    public class DoClassRoom
    {
 
     #region Private Methods

        /// <summary>
        /// Gets an instance of ClassRoom.
        /// </summary>
        /// <param name="id"> id </param>
        private static ClassRoom GetClassRoom(
            int id) 
        {
            using(IDataReader reader = DBClassRoom.GetOne(
                id)) 
            {
            return PopulateFromReader(reader);
            }
            
        }
        
        
        private static ClassRoom PopulateFromReader(IDataReader reader) 
        {
            ClassRoom classRoom = new ClassRoom();
            if(reader.Read())
            {
                classRoom.Id = Convert.ToInt32(reader["Id"]);
                classRoom.RoomName = reader["RoomName"].ToString();
                classRoom.DepID = Convert.ToInt32(reader["DepID"]);
                classRoom.Department = reader["Department"].ToString();
            
            }
            return classRoom;
         }
        
        /// <summary>
        /// Persists a new instance of ClassRoom. Returns true on success.
        /// </summary>
        /// <returns></returns>
        private static bool Create(ClassRoom classRoom)
        { 
            int newID = 0;
            
            newID = DBClassRoom.Create(
                classRoom.RoomName, 
                classRoom.DepID, 
                classRoom.Department); 
                
            classRoom.Id = newID;
                    
            return (newID > 0);

        }

        
        /// <summary>
        /// Updates this instance of ClassRoom. Returns true on success.
        /// </summary>
        /// <returns>bool</returns>
        private static bool Update(ClassRoom classRoom)
        {

            return DBClassRoom.Update(
                classRoom.Id, 
                classRoom.RoomName, 
                classRoom.DepID, 
                classRoom.Department); 
                
        }
        
        
        


#endregion

#region Public Methods

        /// <summary>
        /// Saves this instance of ClassRoom. Returns true on success.
        /// </summary>
        /// <returns>bool</returns>
        public static bool Save(ClassRoom classRoom)
        {
            if( classRoom.Id > 0)
            {
                return Update(classRoom);
            }
            else
            {
                return Create(classRoom);
            }
        }
        
        
    
        
#endregion

#region Static Methods

        /// <summary>
        /// Deletes an instance of ClassRoom. Returns true on success.
        /// </summary>
        /// <param name="id"> id </param>
        /// <returns>bool</returns>
        public static bool Delete(
            int  id) 
        {
            return DBClassRoom.Delete(
                id); 
        }
        
        
        /// <summary>
        /// Gets a count of ClassRoom. 
        /// </summary>
        public static int GetCount()
        {
            return DBClassRoom.GetCount();
        }
    
        private static IList<ClassRoom> LoadListFromReader(IDataReader reader)
        {
            IList<ClassRoom> classRoomList = new List<ClassRoom>();
            try
            {
                while (reader.Read())
                {
                    ClassRoom classRoom = new ClassRoom();
                    classRoom.Id = Convert.ToInt32(reader["Id"]);
                    classRoom.RoomName = reader["RoomName"].ToString();
                    classRoom.DepID = Convert.ToInt32(reader["DepID"]);
                    classRoom.Department = reader["Department"].ToString();
                    classRoomList.Add(classRoom);
                    
                }
            }
            finally
            {
                reader.Close();
            }
    
            return classRoomList;
        
        }
        
        
        /// <summary>
        /// Gets an IList with some instances of ClassRoom.
        /// </summary>
        public static IList<ClassRoom> GetTopList(int foreignKey)    
        {
            IDataReader reader = DBClassRoom.GetTopList(foreignKey);
             
            return LoadListFromReader(reader);
    
        }
        
    
        /// <summary>
        /// Gets an IList with all instances of ClassRoom.
        /// </summary>
        public static IList<ClassRoom> GetAll()
        {
            IDataReader reader = DBClassRoom.GetAll();
            return LoadListFromReader(reader);
    
        }
    
        /// <summary>
        /// Gets an IList with page of instances of ClassRoom.
        /// </summary>
        /// <param name="pageNumber">The page number.</param>
        /// <param name="pageSize">Size of the page.</param>
        /// <param name="totalPages">total pages</param>
        public static IList<ClassRoom> GetPage(int pageNumber, int pageSize, out int itemCount)
        {
            itemCount = 1;
            IDataReader reader = DBClassRoom.GetPage(pageNumber, pageSize, out itemCount);    
            return LoadListFromReader(reader);
        }
        
        
            /// <summary>
        /// Gets an IList with page of instances of ClassRoom.
        /// </summary>
        /// <param name="pageNumber">The page number.</param>
        /// <param name="pageSize">Size of the page.</param>
        /// <param name="itemCount">total items</param>
        public static IList<ClassRoom> GetListPage(int pageNumber, int pageSize,int foreignKey, out int itemCount)
        {
            itemCount = 1;
            IDataReader reader = DBClassRoom.GetListPage(pageNumber, pageSize,foreignKey, out itemCount);    
            return LoadListFromReader(reader);
        }
    

    
#endregion

 


    }
    
}
CodeSmith生成的操作类代码

Delete
GetCount
GetAll
GetPage

Create

Update

比普通表多2个方法

GetTopList 根据外键获取前10数据

GetListPage 根据外键获取分页数据

好的，带有外键的数据表的几层数据我们已经生成完成了。

注意使用CodeSmith生成数据的时候，数据表必须设置有主键，否则生成不成功。

其他表类似，每个表都需要建立相应的存储过程和类

Sunny5816
关注
专栏目录
--连接查询--
糖公子没来过的博客
07-05 1342
1. 什么是连接查询？ 连接查询是将两个或两个以上的表按某个条件连接起来，从中选取需要的数据。连接查询是同时查询两个或两个以上的表时使用的。当不同的表中存在相同意义的字段时，可以通过该字段连接这几个表 2. 内连接查询 INNER JOIN 或 CROSS JOIN 或 JOIN 都可以实现，cms_user 和 provinces 的顺序可以交换，一样的效果 ON 是两个表连接在一起的条件 上面的方法效果等同于下面的WHERE方法 还可以加条件、分组 HAVING二次筛选、.
马赛克还原神器—Depix，真的有那么神吗？
01-16 8496
Depix 是用于从马赛克中还原密码/英文数字组合的Python工具。 它的官方效果是这样的： 效果非常令人惊艳，恢复后基本和原文图相差无几。但是真的有那么神吗？ 老规矩，需要打包好的软件关注小编，QQ群：721195303领取。 01 怎么做到的？ 第一步，作者在编辑器中使用了与原图(带有马赛克的图片)相同的字体设置（文本大小，字体，颜色等设置），然后将debruinseq.txt内的文字和数字放入编辑器中并截图，这张截图中的所有文字都将被像素化后作为“搜索集”来识别原图中马赛克的真实..
sqlserver知识---表的创建
weixin_65330987的博客
04-11 9437
表是数据库存储数据的主要对象，sql server数据库的表由行和列组成 如下图 如何创建表 数据库中创建一张表的语法为： create table table_name( 列名1 数据类型和长度 列说明， 列名2 数据类型和长度 列说明， 列明3 数据类新和长度 列说明....... ) ...
SqlServer递归查询方法
飞翔的学习笔记
09-26 666
项目里想查询某个部门下的所有部门，表结构大体为这样主要字段depid部门编号，depname部门名称，updepid上级部门编号，根据updepid来关联。本来想利用程序写个递归的方法查询出来，后来上网一查还有Sql语句可以直接都查询出来的方法，记录下。 with temp as (select * from sys_dep where manager='' union all select ...
pid级联查询mysql_实现级联查询
weixin_29201859的博客
02-28 1388
标签：关于数据库设计中的分级分层问题的总结(适用于组织结构图及家谱等问题)大家在很多地方都会遇到诸如此类的问题，如：在一个组织中，从高层领导到中层领导到普通职工，有着一种分级的关系，这些关系在关系型数据库中表示时，有它特别的方法。有些人把它们分别建立在不同的表中，建立相应的关系，这虽然是一种解决办法，但如果在应用中，它会给软件带来诸多不便，特别是程序健壮性方法，如果此时需要多加一个职位，这种解决办...
教室预约管理系统2021.rar
11-15
第四步：在后端项目：ClassRoom_back 中修改 application.properties文件， application.properties文件中的数据库以及登录数据库的账号和密码应该与数据库相匹配 第五步：运行后端项目：运行 Java 包下的 ...
基于WebRTC和XMPP的OkEDU-Classroom-Web网页版互动教室设计源码
最新发布
10-04
该项目是一款基于WebRTC和XMPP技术的OkEDU-Classroom-Web网页版互动教室设计源码，包含313个文件，涵盖110个png图片、105个typescript文件、31个html文件、29个scss文件、10个json文件、6个javascript文件、5个jpg...
PEP英语四年级上册Unit1-My-classroom全英带教学设计.doc
11-22
这篇文档是关于PEP小学英语四年级上册Unit 1 "My-classroom"的教学设计，旨在帮助学生掌握与教室相关的词汇和句型。以下是对教学内容的详细说明： 1. **教学内容**： - 本课重点学习的新单词包括：classroom（教室...
PEP英语四年级上册Unit1-My-classroom全英带教学设计.pdf
11-28
PEP英语四年级上册Unit1-My-classroom全英带教学设计.pdf
dc-virtual-classroom:为远程教室开发学习管理系统的全栈项目
05-31
DC-虚拟教室 认证 该项目旨在创建一个多合一的应用程序，供学生进行虚拟学习并与他们的教师和同龄人交流。 （会尽快更新网址。由于某种原因，heroku 和我们的应用程序相处得不好。） 概括 入门 这些说明将为您提供...
记录使用Depix过程（小白文）
热门推荐
weixin_38252066的博客
12-13 1万+
Tips：本文仅用做探索记录（外行+新手），不保证正确性，慎读慎参考！ 背景：无聊看到一个可以去除马赛克的工具，并有GitHub源码（短短几天10K+star，lsp警告????，我反正不是，没跑过Python代码，一次尝试而已）。 过程为本人第一视角，漏掉的部分请自行探索。 下载源码，cd到根目录，执行文档（README.d）中的Example代码。到这里，目前还不明白这行代码的意思，不过可以看到两个图片路径，都在示例代码中出现，最后一个看名字就知道，工程根目录输出一个output.png图片。猜测为执
关于 mysql 存储过程 传递表名作为参数,以及从存储过程返回值的方法
hzqhbc的专栏
08-29 4380
如果在存储过程中,想根据外面传递的表名进行操作,则需要用到prepare关键字 先举例子,如果我需要在我的存储过程中,根据外面传进来的表名,做插入操作,则是以下代码 CREATE PROCEDURE `insert_mail`(IN ptable varchar(45), IN puserid int(11) unsigned, IN pdataid int(11) unsigned,
数据库表名作为参数传递给存储过程的方法
mowwwcom的专栏
06-12 8745
通常的存储过程虽然也可以带参数，但是如果你的存储过程的参数是表名、字段名、数据库名之类的时候，通常的方法就行不通了！ 下面是用表名做参数的存储过程创建： ? 1 2 3 4 5 6 7 CREATE   PROCEDURE   SpecialInsertProcedure        @TableName   varchar(50
功能教室预约系统开源下载（c#源码）
networkcomms的专栏
02-08 5938
这个功能教室预约系统是帮朋友做的，最近没事整理出来，供大家参考，本系统为CS结构，服务器端客户端程序。 本人水平有限，大神请飘过：） 数据基于mssql2005  .net2.0版本  通讯框架为networkcomms2.3.1 录播教室预约系统序言 录播教室预约系统(一)-数据库表 录播教室预约系统(二)-服务器端与数据库的交互 录播教室预约系统(三)-DepTable表[普通表
录播教室预约系统(一)-数据库表
networkcomms的专栏
02-08 1648
录播教室预约系统(一)-数据库表   数据库用的是mssql2005. 数据库表如下：   USE [RoomSchedule] GO /****** 对象: Table [dbo].[ClassRoom] 脚本日期: 02/07/2015 22:41:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIF
录播教室预约系统序言
networkcomms的专栏
02-08 1005
大概一年多年前吧，朋友让我帮他做一个预约系统，当时刚好在学习networkcomms.net的2.3.1版本（本人当时已购买商业版),正好想测试一下networkcomms.net通讯框架的稳定性，于是便开发了此预约系统，基于networkcomms2.3.1 .部署后，系统非常的稳定，平时的cpu占有率非常的低，很少有达到5%以上的情况，当然用户数也并不多，并发数最多大概100左右，没有出现过宕
录播教室预约系统(三)-DepTable表[普通表]
networkcomms的专栏
02-08 773
DepTable表  主要作用 存放单位名称 如图：   模板下载地址 CodeSmith版本为v6.5 第一步：用CodeSmith模板生成DepTable表相关的存储过程 生成的存储过程如下：  /****** Object: Stored Procedure [dbo].DepTable_Delete Script Date: 2015年2月8日 ****
录播教室预约系统(十)-客户端部门管理员重置本单位其他人员密码
networkcomms的专栏
02-08 737
客户端代码： //发出的数据类型为int类型 ItemID为用户对应的ID ResMessage resMessage = tcpConnnection.SendReceiveObject("ReqResetPsw", "ResResetPsw", 5000, itemID); if (resMessage.Message == "操
mysql建表有学生表教室表课程表成绩表怎么用主外键关联起来
05-26
1. 学生表（student）中添加一个外键（foreign key），指向教室表（classroom）的主键（primary key）： ``` ALTER TABLE student ADD CONSTRAINT fk_student_classroom_id FOREIGN KEY (classroom_id) REFERENCES ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值