在【CodeSmith快速入门之四：模型层的生成】中，我们介绍了模型层模板的生成，在本章我们将会介绍其他层次的模板。
因为每个层次的模板编写都比较类似，所以这次不会对模板代码进行详细的说明，尽请谅解，谢谢
1、数据访问接口代码生成模版
<%--
Name: 数据访问接口代码生成模版
Author: Fencer
Description: 根据数据库的内容生成数据访问层接口
Version: V1.0 新规初成
--%>
<%@ CodeTemplate Language="C#" TargetLanguage="Text" ResponseEncoding="UTF-8"%>
<%@ Property Name="Namespace" Type="String" Default="IDAL" Category="内容" Description="命名空间名称" %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="内容" Description="数据源表" %>
<%@ Property Name="ObjectName" Type="String" Category="注释" Description="对象名称，为生成注释而用" %>
<%@ Assembly Name="System.Data" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
using System;
using System.Collections.Generic;
using System.Text;
namespace <%=Namespace%>
{
using Model;
/// <summary>
/// <%=ObjectName%>的数据访问操作
/// </summary>
public interface I<%=GetModelName(SourceTable)%>
{
/// <summary>
/// 添加<%=ObjectName%>
/// </summary>
/// <param name="<%=GetModelParameterName(SourceTable)%>"><%=ObjectName%></param>
/// <returns>最新编号</returns>
int Add<%=GetModelName(SourceTable)%>(<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%>);
/// <summary>
/// 更新<%=ObjectName%>
/// </summary>
/// <param name="<%=GetModelParameterName(SourceTable)%>"><%=ObjectName%></param>
/// <returns>bool</returns>
bool Update<%=GetModelName(SourceTable)%>(<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%>);
/// <summary>
/// 根据ID删除<%=ObjectName%>
/// </summary>
/// <param name="<%=GetPrimaryKeyFieldName(SourceTable)%>"><%=ObjectName%>ID</param>
/// <returns>bool</returns>
bool Delete<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyType(SourceTable)%> <%=GetPrimaryKeyFieldName(SourceTable)%>);
/// <summary>
/// 根据ID查询<%=ObjectName%>
/// </summary>
/// <param name="<%=GetPrimaryKeyFieldName(SourceTable)%>"><%=ObjectName%>ID</param>
/// <returns><%=ObjectName%>对象</returns>
<%=GetModelName(SourceTable)%> Get<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyType(SourceTable)%> <%=GetPrimaryKeyFieldName(SourceTable)%>);
/// <summary>
/// 获得所有<%=ObjectName%>
/// </summary>
/// <returns><%=ObjectName%>集合</returns>
IList<<%=GetModelName(SourceTable)%>> GetAll<%=GetModelName(SourceTable)%>s();
}
}
<script runat="template">
public string GetClassName(TableSchema table)
{
string tempTable;
if (table.Name.EndsWith("s"))
{
tempTable = table.Name.Substring(0,table.Name.Length-1);
}
else
{
tempTable = table.Name;
}
return tempTable;
}
public string GetModelName(TableSchema table)
{
return ConvertToPascal(GetClassName(table));
}
public string GetModelParameterName(TableSchema table)
{
return ConvertToCamel(GetClassName(table));
}
public string GetPrimaryKeyType(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return GetCSharpDataTypeByDBColumn(table.PrimaryKey.MemberColumns[0]);
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public string GetPrimaryKeyName(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return table.PrimaryKey.MemberColumns[0].Name;
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public string GetPrimaryKeyFieldName(TableSchema table)
{
return ConvertToCamel(GetPrimaryKeyName(table));
}
public string GetPrimaryKeyPropertyName(TableSchema table)
{
return ConvertToPascal(GetPrimaryKeyName(table));
}
public string GetCSharpDataTypeByDBColumn(ColumnSchema column)
{
switch (column.DataType)
{
case DbType.AnsiString: return "string";
case DbType.AnsiStringFixedLength: return "string";
case DbType.Binary: return "byte[]";
case DbType.Boolean: return "bool";
case DbType.Byte: return "byte";
case DbType.Currency: return "decimal";
case DbType.Date: return "DateTime";
case DbType.DateTime: return "DateTime";
case DbType.Decimal: return "decimal";
case DbType.Double: return "double";
case DbType.Guid: return "Guid";
case DbType.Int16: return "short";
case DbType.Int32: return "int";
case DbType.Int64: return "long";
case DbType.Object: return "object";
case DbType.SByte: return "sbyte";
case DbType.Single: return "float";
case DbType.String: return "string";
case DbType.StringFixedLength: return "string";
case DbType.Time: return "TimeSpan";
case DbType.UInt16: return "ushort";
case DbType.UInt32: return "uint";
case DbType.UInt64: return "ulong";
case DbType.VarNumeric: return "decimal";
default:
{
return "__UNKNOWN__" + column.NativeType;
}
}
}
public string ConvertToPascal(string str)
{
return str.Substring(0,1).ToUpper() + str.Substring(1);
}
public string ConvertToCamel(string str)
{
return str.Substring(0,1).ToLower() + str.Substring(1);
}
public override string GetFileName()
{
return "I" + GetModelName(SourceTable) + ".cs";
}
</script>
2、数据访问层代码生成模版
<%--
Name: 数据访问层代码生成模版
Author: Fencer
Description: 根据数据库的内容生成模型层代码
Version: V1.0 新规初成
--%>
<%@ CodeTemplate Language="C#" TargetLanguage="Text" ResponseEncoding="UTF-8"%>
<%@ Property Name="Namespace" Type="String" Default="SQLServerDAL" Category="内容" Description="命名空间名称" %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="内容" Description="数据源表" %>
<%@ Property Name="ObjectName" Type="String" Category="注释" Description="对象名称，为生成注释而用" %>
<%@ Assembly Name="System.Data" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace <%=Namespace%>
{
using IDAL;
using Model;
using Common;
/// <summary>
/// <%=ObjectName%>的数据访问操作
/// </summary>
public class <%=GetModelName(SourceTable)%>s : I<%=GetModelName(SourceTable)%>
{
/// <summary>
/// 添加<%=ObjectName%>
/// </summary>
/// <param name="<%=GetModelParameterName(SourceTable)%>"><%=ObjectName%></param>
/// <returns>最新编号</returns>
public int Add<%=GetModelName(SourceTable)%>(<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%>)
{
string sql = <%=GetInsertSql()%>;
SqlParameter[] pas = new SqlParameter[]
{
<%
for(int i=0; i<SourceTable.NonPrimaryKeyColumns.Count; i++)
{
ColumnSchema column = SourceTable.NonPrimaryKeyColumns[i];
%>
new SqlParameter("@<%=column.Name%>",SqlDbType.<%=GetSqlDbType(column)%>,<%=column.Size%>)<%= (i==(SourceTable.NonPrimaryKeyColumns.Count-1)? "":",")%>
<%
}
%>
};
<%
for(int i=0; i<SourceTable.NonPrimaryKeyColumns.Count; i++)
{
%>
pas[<%=i%>].Value = <%=GetModelParameterName(SourceTable)%>.<%=SourceTable.NonPrimaryKeyColumns[i].Name%>;
<%
}
%>
return Convert.ToInt32(SqlHelper.ExecuteScalar(SqlHelper.CONN_STRING, CommandType.Text, sql, pas));
}
/// <summary>
/// 更新<%=ObjectName%>
/// </summary>
/// <param name="<%=GetModelParameterName(SourceTable)%>"><%=ObjectName%></param>
/// <returns>bool</returns>
public bool Update<%=GetModelName(SourceTable)%>(<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%>)
{
string sql = <%=GetUpdateSql()%>;
SqlParameter[] pas = new SqlParameter[]
{
<%
for(int i=0; i<SourceTable.NonPrimaryKeyColumns.Count; i++)
{
ColumnSchema column = SourceTable.NonPrimaryKeyColumns[i];
%>
new SqlParameter("@<%=column.Name%>",SqlDbType.<%=GetSqlDbType(column)%>,<%=column.Size%>),
<%
}
%>
new SqlParameter("@<%=GetPrimaryKeyName(SourceTable)%>",SqlDbType.<%=GetSqlDbType(GetPrimaryKeyColumn(SourceTable))%>,<%=GetPrimaryKeySize(SourceTable)%>)
};
<%
for(int i=0; i<=SourceTable.NonPrimaryKeyColumns.Count; i++)
{
if (i < SourceTable.NonPrimaryKeyColumns.Count)
{
%>
pas[<%=i%>].Value = <%=GetModelParameterName(SourceTable)%>.<%=SourceTable.NonPrimaryKeyColumns[i].Name%>;
<%
}
else
{
%>
pas[<%=i%>].Value = <%=GetModelParameterName(SourceTable)%>.<%=GetPrimaryKeyName(SourceTable)%>;
<%
}
}
%>
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING,CommandType.Text,sql,pas);
return (rows == 1);
}
/// <summary>
/// 根据ID删除<%=ObjectName%>
/// </summary>
/// <param name="<%=GetPrimaryKeyFieldName(SourceTable)%>"><%=ObjectName%>ID</param>
/// <returns>bool</returns>
public bool Delete<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyType(SourceTable)%> <%=GetPrimaryKeyFieldName(SourceTable)%>)
{
string sql = "DELETE FROM <%=SourceTable.Name%> WHERE <%=GetPrimaryKeyName(SourceTable)%>=@<%=GetPrimaryKeyName(SourceTable)%>";
SqlParameter pa = new SqlParameter("@<%=GetPrimaryKeyName(SourceTable)%>",SqlDbType.<%=GetPrimaryKeySqlDbType(SourceTable)%>,<%=GetPrimaryKeySize(SourceTable)%>);
pa.Value = <%=GetPrimaryKeyFieldName(SourceTable)%>;
int rows = SqlHelper.ExecuteNonQuery(SqlHelper.CONN_STRING,CommandType.Text,sql,pa);
return (rows == 1);
}
/// <summary>
/// 根据ID查询<%=ObjectName%>
/// </summary>
/// <param name="<%=GetPrimaryKeyFieldName(SourceTable)%>"><%=ObjectName%>ID</param>
/// <returns><%=ObjectName%>对象</returns>
public <%=GetModelName(SourceTable)%> Get<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyType(SourceTable)%> <%=GetPrimaryKeyFieldName(SourceTable)%>)
{
string sql = <%=GetSelectOneModelSql()%>;
SqlParameter pa = new SqlParameter("@<%=GetPrimaryKeyName(SourceTable)%>",SqlDbType.<%=GetPrimaryKeySqlDbType(SourceTable)%>,<%=GetPrimaryKeySize(SourceTable)%>);
pa.Value = <%=GetPrimaryKeyFieldName(SourceTable)%>;
using(SqlDataReader rdr = SqlHelper.ExecuteReader(
SqlHelper.CONN_STRING,CommandType.Text,sql,pa))
{
if (rdr.Read())
{
<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%> = new <%=GetModelName(SourceTable)%>();
<%
foreach(ColumnSchema column in SourceTable.Columns)
{
%>
<%=GetModelParameterName(SourceTable)%>.<%=column.Name%> = (<%=GetCSharpDataTypeByDBColumn(column)%>)rdr["<%=column.Name%>"];
<%
}
%>
return <%=GetModelParameterName(SourceTable)%>;
}
}
return null;
}
/// <summary>
/// 获得所有<%=ObjectName%>
/// </summary>
/// <returns><%=ObjectName%>集合</returns>
public IList<<%=GetModelName(SourceTable)%>> GetAll<%=GetModelName(SourceTable)%>s()
{
string sql = <%=GetSelectAllModelSql()%>;
IList<<%=GetModelName(SourceTable)%>> all<%=GetModelName(SourceTable)%>s = new List<<%=GetModelName(SourceTable)%>>();
using(SqlDataReader rdr = SqlHelper.ExecuteReader(
SqlHelper.CONN_STRING,CommandType.Text,sql))
{
while (rdr.Read())
{
<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%> = new <%=GetModelName(SourceTable)%>();
<%
foreach(ColumnSchema column in SourceTable.Columns)
{
%>
<%=GetModelParameterName(SourceTable)%>.<%=column.Name%> = (<%=GetCSharpDataTypeByDBColumn(column)%>)rdr["<%=column.Name%>"];
<%
}
%>
all<%=GetModelName(SourceTable)%>s.Add(<%=GetModelParameterName(SourceTable)%>);
}
}
return all<%=GetModelName(SourceTable)%>s;
}
}
}
<script runat="template">
public string GetClassName(TableSchema table)
{
string tempTable;
if (table.Name.EndsWith("s"))
{
tempTable = table.Name.Substring(0,table.Name.Length-1);
}
else
{
tempTable = table.Name;
}
return tempTable;
}
public string GetModelName(TableSchema table)
{
return ConvertToPascal(GetClassName(table));
}
public string GetModelParameterName(TableSchema table)
{
return ConvertToCamel(GetClassName(table));
}
public string GetPrimaryKeyType(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return GetCSharpDataTypeByDBColumn(table.PrimaryKey.MemberColumns[0]);
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public ColumnSchema GetPrimaryKeyColumn(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return table.PrimaryKey.MemberColumns[0];
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public string GetPrimaryKeyName(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return table.PrimaryKey.MemberColumns[0].Name;
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public string GetPrimaryKeySize(TableSchema table)
{
return table.PrimaryKey.MemberColumns[0].Size.ToString();
}
public string GetPrimaryKeySqlDbType(TableSchema table)
{
return GetSqlDbType(table.PrimaryKey.MemberColumns[0]);
}
public string GetPrimaryKeyFieldName(TableSchema table)
{
return ConvertToCamel(GetPrimaryKeyName(table));
}
public string GetPrimaryKeyPropertyName(TableSchema table)
{
return ConvertToPascal(GetPrimaryKeyName(table));
}
public string GetInsertSql()
{
string sql = ""INSERT INTO " + SourceTable.Name + "(";
foreach(ColumnSchema column in SourceTable.NonPrimaryKeyColumns)
{
sql += column.Name + ",";
}
sql = sql.Substring(0,sql.Length-1);
sql += ")" + ";
sql += " " values(";
foreach(ColumnSchema column in SourceTable.NonPrimaryKeyColumns)
{
sql += "@" + column.Name + ",";
}
sql = sql.Substring(0,sql.Length-1);
sql += ");" + ";
sql += " " SELECT SCOPE_IDENTITY();"";
return sql;
}
public string GetUpdateSql()
{
string sql = ""UPDATE " + SourceTable.Name + " " + ";
sql += " "SET ";
foreach(ColumnSchema column in SourceTable.NonPrimaryKeyColumns)
{
sql += column.Name + "=@" + column.Name + ",";
}
sql = sql.Substring(0,sql.Length-1);
sql += " " + ";
sql += " "WHERE " + GetPrimaryKeyName(SourceTable) + "=@" + GetPrimaryKeyName(SourceTable) + """;
return sql;
}
public string GetSelectOneModelSql()
{
string sql = ""SELECT ";
foreach(ColumnSchema column in SourceTable.Columns)
{
sql += column.Name + ",";
}
sql = sql.Substring(0,sql.Length-1);
sql += " " + ";
sql += " "FROM " + SourceTable.Name + " " + ";
sql += " "WHERE " + GetPrimaryKeyName(SourceTable) + "=@" + GetPrimaryKeyName(SourceTable) + """;
return sql;
}
public string GetSelectAllModelSql()
{
string sql = ""SELECT ";
foreach(ColumnSchema column in SourceTable.Columns)
{
sql += column.Name + ",";
}
sql = sql.Substring(0,sql.Length-1);
sql += " " + ";
sql += " "FROM " + SourceTable.Name + """;
return sql;
}
public string GetCSharpDataTypeByDBColumn(ColumnSchema column)
{
switch (column.DataType)
{
case DbType.AnsiString: return "string";
case DbType.AnsiStringFixedLength: return "string";
case DbType.Binary: return "byte[]";
case DbType.Boolean: return "bool";
case DbType.Byte: return "byte";
case DbType.Currency: return "decimal";
case DbType.Date: return "DateTime";
case DbType.DateTime: return "DateTime";
case DbType.Decimal: return "decimal";
case DbType.Double: return "double";
case DbType.Guid: return "Guid";
case DbType.Int16: return "short";
case DbType.Int32: return "int";
case DbType.Int64: return "long";
case DbType.Object: return "object";
case DbType.SByte: return "sbyte";
case DbType.Single: return "float";
case DbType.String: return "string";
case DbType.StringFixedLength: return "string";
case DbType.Time: return "TimeSpan";
case DbType.UInt16: return "ushort";
case DbType.UInt32: return "uint";
case DbType.UInt64: return "ulong";
case DbType.VarNumeric: return "decimal";
default:
{
return "__UNKNOWN__" + column.NativeType;
}
}
}
public string GetSqlDbType(ColumnSchema column)
{
switch (column.NativeType)
{
case "bigint": return "BigInt";
case "binary": return "Binary";
case "bit": return "Bit";
case "char": return "Char";
case "datetime": return "DateTime";
case "decimal": return "Decimal";
case "float": return "Float";
case "image": return "Image";
case "int": return "Int";
case "money": return "Money";
case "nchar": return "NChar";
case "ntext": return "NText";
case "numeric": return "Decimal";
case "nvarchar": return "NVarChar";
case "real": return "Real";
case "smalldatetime": return "SmallDateTime";
case "smallint": return "SmallInt";
case "smallmoney": return "SmallMoney";
case "sql_variant": return "Variant";
case "sysname": return "NChar";
case "text": return "Text";
case "timestamp": return "Timestamp";
case "tinyint": return "TinyInt";
case "uniqueidentifier": return "UniqueIdentifier";
case "varbinary": return "VarBinary";
case "varchar": return "VarChar";
default: return "__UNKNOWN__" + column.NativeType;
}
}
public string ConvertToPascal(string str)
{
return str.Substring(0,1).ToUpper() + str.Substring(1);
}
public string ConvertToCamel(string str)
{
return str.Substring(0,1).ToLower() + str.Substring(1);
}
public override string GetFileName()
{
return GetModelName(SourceTable) + "s.cs";
}
</script>
3、数据访问工厂代码生成模版
<%--
Name: 数据访问工厂代码生成模版
Author: Fencer
Description: 根据数据库的内容生成数据访问工厂
Version: V1.0 新规初成
--%>
<%@ CodeTemplate Language="C#" TargetLanguage="Text" ResponseEncoding="UTF-8"%>
<%@ Property Name="Namespace" Type="String" Default="DALFactory" Category="内容" Description="命名空间名称" %>
<%@ Property Name="Database" Type="SchemaExplorer.DatabaseSchema" Category="内容" Description="目标数据库" %>
<%@ Assembly Name="System.Data" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
using System;
using System.Collections.Generic;
using System.Text;
using System.Configuration;
using System.Reflection;
namespace <%=Namespace%>
{
using IDAL;
/// <summary>
/// 数据访问工厂
/// </summary>
public sealed class DataAccess
{
private static readonly string path = ConfigurationManager.AppSettings["DAL"];
<%
foreach(TableSchema table in Database.Tables)
{
%>
/// <summary>
///
/// </summary>
/// <returns>接口</returns>
public static I<%=table.Name%> Create<%=table.Name%>()
{
string className = path + ".<%=table.Name%>s";
return (I<%=table.Name%>)Assembly.Load(path).CreateInstance(className);
}
<%
}
%>
}
}
<script runat="template">
public override string GetFileName()
{
return "DataAccess.cs";
}
</script>
4、业务层代码生成模版
<%--
Name: 业务层代码生成模版
Author: Fencer
Description: 根据数据库的内容生成业务层代码
Version: V1.0 新规初成
--%>
<%@ CodeTemplate Language="C#" TargetLanguage="Text" ResponseEncoding="UTF-8"%>
<%@ Property Name="BLLNamespace" Type="String" Default="BLL" Category="内容" Description="业务层命名空间名称" %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="内容" Description="数据源表" %>
<%@ Property Name="ObjectName" Type="String" Category="注释" Description="对象名称，为生成注释而用" %>
<%@ Assembly Name="System.Data" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
using System;
using System.Collections.Generic;
using System.Text;
namespace <%=BLLNamespace%>
{
using IDAL;
using Model;
using DALFactory;
/// <summary>
/// <%=ObjectName%>的业务处理类
/// </summary>
public class <%=GetModelName(SourceTable)%>BLL
{
private static readonly I<%=GetModelName(SourceTable)%> dal = DataAccess.Create<%=GetModelName(SourceTable)%>();
/// <summary>
/// 添加<%=ObjectName%>
/// </summary>
/// <param name="<%=GetModelParameterName(SourceTable)%>"><%=ObjectName%></param>
/// <returns>最新编号</returns>
public static int Add<%=GetModelName(SourceTable)%>(<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%>)
{
return dal.Add<%=GetModelName(SourceTable)%>(<%=GetModelParameterName(SourceTable)%>);
}
/// <summary>
/// 更新<%=ObjectName%>
/// </summary>
/// <param name="<%=GetModelParameterName(SourceTable)%>"><%=ObjectName%></param>
/// <returns>bool</returns>
public static bool Update<%=GetModelName(SourceTable)%>(<%=GetModelName(SourceTable)%> <%=GetModelParameterName(SourceTable)%>)
{
return dal.Update<%=GetModelName(SourceTable)%>(<%=GetModelParameterName(SourceTable)%>);
}
/// <summary>
/// 根据ID删除<%=ObjectName%>
/// </summary>
/// <param name="<%=GetPrimaryKeyFieldName(SourceTable)%>"><%=ObjectName%>ID</param>
/// <returns>bool</returns>
public static bool Delete<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyType(SourceTable)%> <%=GetPrimaryKeyFieldName(SourceTable)%>)
{
return dal.Delete<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyFieldName(SourceTable)%>);
}
/// <summary>
/// 根据ID查询<%=ObjectName%>
/// </summary>
/// <param name="<%=GetPrimaryKeyFieldName(SourceTable)%>"><%=ObjectName%>ID</param>
/// <returns><%=ObjectName%>对象</returns>
public static <%=GetModelName(SourceTable)%> Get<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyType(SourceTable)%> <%=GetPrimaryKeyFieldName(SourceTable)%>)
{
return dal.Get<%=GetModelName(SourceTable)%>By<%=GetPrimaryKeyPropertyName(SourceTable)%>(<%=GetPrimaryKeyFieldName(SourceTable)%>);
}
/// <summary>
/// 获得所有<%=ObjectName%>
/// </summary>
/// <returns><%=ObjectName%>集合</returns>
public static IList<<%=GetModelName(SourceTable)%>> GetAll<%=GetModelName(SourceTable)%>s()
{
return dal.GetAll<%=GetModelName(SourceTable)%>s();
}
}
}
<script runat="template">
public string GetClassName(TableSchema table)
{
string tempTable;
if (table.Name.EndsWith("s"))
{
tempTable = table.Name.Substring(0,table.Name.Length-1);
}
else
{
tempTable = table.Name;
}
return tempTable;
}
public string GetModelName(TableSchema table)
{
return ConvertToPascal(GetClassName(table));
}
public string GetModelParameterName(TableSchema table)
{
return ConvertToCamel(GetClassName(table));
}
public string GetPrimaryKeyName(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return table.PrimaryKey.MemberColumns[0].Name;
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public string GetPrimaryKeyType(TableSchema table)
{
if (table.PrimaryKey != null)
{
if (table.PrimaryKey.MemberColumns.Count == 1)
{
return GetCSharpDataTypeByDBColumn(table.PrimaryKey.MemberColumns[0]);
}
else
{
throw new ApplicationException("此模板只支持单个列的主键");
}
}
else
{
throw new ApplicationException("此模板需要有主键的表");
}
}
public string GetCSharpDataTypeByDBColumn(ColumnSchema column)
{
switch (column.DataType)
{
case DbType.AnsiString: return "string";
case DbType.AnsiStringFixedLength: return "string";
case DbType.Binary: return "byte[]";
case DbType.Boolean: return "bool";
case DbType.Byte: return "byte";
case DbType.Currency: return "decimal";
case DbType.Date: return "DateTime";
case DbType.DateTime: return "DateTime";
case DbType.Decimal: return "decimal";
case DbType.Double: return "double";
case DbType.Guid: return "Guid";
case DbType.Int16: return "short";
case DbType.Int32: return "int";
case DbType.Int64: return "long";
case DbType.Object: return "object";
case DbType.SByte: return "sbyte";
case DbType.Single: return "float";
case DbType.String: return "string";
case DbType.StringFixedLength: return "string";
case DbType.Time: return "TimeSpan";
case DbType.UInt16: return "ushort";
case DbType.UInt32: return "uint";
case DbType.UInt64: return "ulong";
case DbType.VarNumeric: return "decimal";
default:
{
return "__UNKNOWN__" + column.NativeType;
}
}
}
public string GetPrimaryKeyFieldName(TableSchema table)
{
return ConvertToCamel(GetPrimaryKeyName(table));
}
public string GetPrimaryKeyPropertyName(TableSchema table)
{
return ConvertToPascal(GetPrimaryKeyName(table));
}
public string ConvertToPascal(string str)
{
return str.Substring(0,1).ToUpper() + str.Substring(1);
}
public string ConvertToCamel(string str)
{
return str.Substring(0,1).ToLower() + str.Substring(1);
}
public override string GetFileName()
{
return GetModelName(SourceTable) + "BLL.cs";
}
</script>
好了，到本章为止主要的模板就都已经开发完了（此模板都比较简单，大家可以根据实际情况进行修改） 下载所有的模板（附带SqlHelper）。
问题：每次代码生成时都需要一个个模板运行，然后COPY->PASTE，是不是太麻烦了，下次会跟大家介绍怎么进行模板的调用，“一键”搭建起项目，谢谢。