搭建你的Spring.Net+Nhibernate+Asp.Net Mvc 框架 （二）创建你的项目

CREATE TABLE Hksj_User
(
    Id INT IDENTITY(1,1) NOT NULL,
    SName NVARCHAR(20) NOT NULL,
    SNickName NVARCHAR(20),
    SPassWord NVARCHAR(30) NOT NULL,
    DCreateDate DATETIME ,
    SCreator NVARCHAR(20),
    SEmail NVARCHAR(50),
    SPhone NVARCHAR(50),
    SIdentifyId NVARCHAR(30),
    DLastTimeLogOn DATETIME

PRIMARY KEY CLUSTERED
    (
        Id ASC
    )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
--添加注释
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登录名' ,  @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hksj_User', @level2type=N'COLUMN',@level2name=N'SName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Hksj_User', @level2type=N'COLUMN',@level2name=N'SEmail'

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace MyWeb.WebTemp.Model
{
    [Serializable]
public class User
    {
/// <summary>
/// 用户id
/// </summary>
        public Int32 Id
        {
get;
set;
        }

/// <summary>
/// 用户名，登录所用的名字
/// </summary>
        public string Name
        {
get;
set;
        }

/// <summary>
/// 真实姓名
/// </summary>
        public string NickName
        {
get;
set;
        }

/// <summary>
/// 密码
/// </summary>
        public string PassWord
        {
get;
set;
        }

/// <summary>
/// 创建日期
/// </summary>
        public DateTime CreateTime
        {
get;
set;
        }

/// <summary>
/// 创建人
/// </summary>
        public string Creator
        {
get;
set;
        }

/// <summary>
/// Email
/// </summary>
        public string Email
        {
get;
set;
        }

/// <summary>
/// 联系电话
/// </summary>
        public string Phone
        {
get;
set;
        }

/// <summary>
/// 身份证
/// </summary>
        public string IdentifyId
        {
get;
set;
        }

/// <summary>
/// 最后一次登录时间
/// </summary>
        public DateTime LastTimeLogOn
        {
get;
set;
        }
    }
}