数据字典生成工具之旅(7)：NVelocity实现代码生成器

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;namespace Mysoft.Code.Entity
{
///<summary>阶段设置表</summary>
public class Pack_Stage
{ ///<summary>更新包GUID </summary>
public string StageGUID
{
get;
set;
} ///<summary>更新包名称 </summary>
public string StageName
{
get;
set;
} ///<summary>阶段序号 </summary>
public string OrderNo
{
get;
set;
} ///<summary>是否开始合并包 </summary>
public string IsHBPackage
{
get;
set;
}
}
}

SELECT T.name AS table_name ,T.OBJECT_ID,
ISNULL(CONVERT(VARCHAR(MAX), E.value), '') AS table_name_c ,
C.name AS field_name ,
ISNULL(CONVERT(VARCHAR(MAX), D.value), '') AS field_name_c ,
ROW_NUMBER() OVER(PARTITION BY T.name ORDER BY C.colid) AS field_sequence ,
TYPE_NAME(C.xtype) AS date_type ,
(CASE WHEN EXISTS ( SELECT 1
FROM sysobjects
WHERE xtype = 'PK'
AND name IN (
SELECT name
FROM sysindexes
WHERE id = C.id
AND indid IN (
SELECT indid
FROM sysindexkeys
WHERE id = C.id
AND colid = C.colid ) ) )
THEN 1
ELSE 0
END) AS pk ,
ISNULL(C.isnullable, 1) AS isnullable ,
ISNULL(COLUMNPROPERTY(c.id, c.name, 'IsIdentity'), 0) AS isidentity
FROM sys.tables AS T
LEFT JOIN syscolumns AS C ON c.id = T.object_id
LEFT JOIN sys.extended_properties AS D ON D.major_id = T.object_id
AND D.minor_id = C.colid
AND D.major_id = C.id
LEFT JOIN sys.extended_properties AS E ON E.major_id = T.object_id
AND E.minor_id = 0