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

最新推荐文章于 2024-07-28 23:23:55 发布
最新推荐文章于 2024-07-28 23:23:55 发布
阅读量133 收藏 1
点赞数
文章标签： c# 网络 数据库
原文链接：https://my.oschina.net/networkcomms/blog/382038
版权

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生成数据的时候，数据表必须设置有主键，否则生成不成功。

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

【开源下载】基于TCP网络通信的即时聊天系统（IM系统）（c#源码）

【开源下载】基于TCP网络通信的自动升级程序c#源码

【开源下载】基于winform的xml菜单编辑器（c#源码)

[源码下载]Demo2.模拟简单登陆-效果图 基于networkcomms2.3.1

[源码下载]Demo1 客户端从服务器获取信息（基于networkcomms2.3.1)

【模板下载】分享我所使用的数据库框架

转载于:https://my.oschina.net/networkcomms/blog/382038

chvft44866
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
SqlServer递归查询方法
飞翔的学习笔记
09-26 640
项目里想查询某个部门下的所有部门，表结构大体为这样主要字段depid部门编号，depname部门名称，updepid上级部门编号，根据updepid来关联。本来想利用程序写个递归的方法查询出来，后来上网一查还有Sql语句可以直接都查询出来的方法，记录下。 with temp as (select * from sys_dep where manager='' union all select ...
pid级联查询mysql_实现级联查询
weixin_29201859的博客
02-28 1354
标签：关于数据库设计中的分级分层问题的总结(适用于组织结构图及家谱等问题)大家在很多地方都会遇到诸如此类的问题，如：在一个组织中，从高层领导到中层领导到普通职工，有着一种分级的关系，这些关系在关系型数据库中表示时，有它特别的方法。有些人把它们分别建立在不同的表中，建立相应的关系，这虽然是一种解决办法，但如果在应用中，它会给软件带来诸多不便，特别是程序健壮性方法，如果此时需要多加一个职位，这种解决办...
--连接查询--
糖公子没来过的博客
07-05 1238
1. 什么是连接查询？ 连接查询是将两个或两个以上的表按某个条件连接起来，从中选取需要的数据。连接查询是同时查询两个或两个以上的表时使用的。当不同的表中存在相同意义的字段时，可以通过该字段连接这几个表 2. 内连接查询 INNER JOIN 或 CROSS JOIN 或 JOIN 都可以实现，cms_user 和 provinces 的顺序可以交换，一样的效果 ON 是两个表连接在一起的条件 上面的方法效果等同于下面的WHERE方法 还可以加条件、分组 HAVING二次筛选、.
马赛克还原神器—Depix，真的有那么神吗？
01-16 8367
Depix 是用于从马赛克中还原密码/英文数字组合的Python工具。 它的官方效果是这样的： 效果非常令人惊艳，恢复后基本和原文图相差无几。但是真的有那么神吗？ 老规矩，需要打包好的软件关注小编，QQ群：721195303领取。 01 怎么做到的？ 第一步，作者在编辑器中使用了与原图(带有马赛克的图片)相同的字体设置（文本大小，字体，颜色等设置），然后将debruinseq.txt内的文字和数字放入编辑器中并截图，这张截图中的所有文字都将被像素化后作为“搜索集”来识别原图中马赛克的真实..
教室预约管理系统2021.rar
11-15
第四步：在后端项目：ClassRoom_back 中修改 application.properties文件， application.properties文件中的数据库以及登录数据库的账号和密码应该与数据库相匹配 第五步：运行后端项目：运行 Java 包下的 ...
rain-classroom-helper:使下雨教室更易于在PC和平板电脑上使用
03-08
雨教室助手该用户脚本引导为大屏幕设备（PC，平板）提供更好的雨课堂学生端使用体验。介绍雨课堂学生端本来是针对手机使用而开发的，PC网页版存在的问题不可谓不多：所谓的PC网页版（v1）实际上也只是用了一个iframe...
四上-my-classroom.doc
12-06
四上-my-classroom.doc
四年级my-classroom[1].ppt
11-10
标题 "四年级my-classroom[1].ppt" 涉及到的是一个针对四年级学生的英语教学材料，主要内容是教学生学习与教室相关的词汇和句型。这份资料以彭光发老师的讲解为主线，引导学生认识并掌握教室内的基本元素。 在描述...
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 4336
如果在存储过程中,想根据外面传递的表名进行操作,则需要用到prepare关键字 先举例子,如果我需要在我的存储过程中,根据外面传进来的表名,做插入操作,则是以下代码 CREATE PROCEDURE `insert_mail`(IN ptable varchar(45), IN puserid int(11) unsigned, IN pdataid int(11) unsigned,
数据库表名作为参数传递给存储过程的方法
mowwwcom的专栏
06-12 8697
通常的存储过程虽然也可以带参数，但是如果你的存储过程的参数是表名、字段名、数据库名之类的时候，通常的方法就行不通了！ 下面是用表名做参数的存储过程创建： ? 1 2 3 4 5 6 7 CREATE   PROCEDURE   SpecialInsertProcedure        @TableName   varchar(50
记录｜使用ＨslCommunication库进行写入Real数据的坑
技术小白=-=的博客
07-24 510
现在已经通过HslCommunication连接上了PLC，需要对DB1.DBD10的位置处进行数据写入。
C#实现数据采集系统-Mqtt实现采集数据转发
最新发布
海盗Sharp的博客
07-28 32
在数据采集系统中，通过ModbusTcp采集到数据之后，再通过MQTT转发到其他应用。
C# —— 析构函数
一个新人博客，愿多多支持。
07-25 316
构造函数创建对象 对属性进行初始化的作用析构函数: 当一个对象被释放的时候执行。
C#:通用方法总结—第3集
m0_53104033的博客
07-25 428
今天我们继续讲解通用方法系列，这在帮助有需要的人的同时，也是在记录我自己的工作经验。 下面开始介绍今天的通用方法： （1）这个通用方法为加载datatable表头，输入参数为System.Data.DataTable /// /// 加载表头 /// /// public void HeaderName(System.Da
C# 与C++ cli
汤圆
07-23 592
问题起因：“windows.h”间接引入了 servprov.h， 而 servprov.h中存在：typedef interface IServiceProvider IServiceProvider;其中 IServiceProvider与System命名空间中的 IServiceProvider冲突，从而引起不确定性。解决办法： 优先 using namespace System 引用。
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、付费专栏及课程。

余额充值