CodeSmith 创建Ado.Net自定义模版（四）

最新推荐文章于 2025-05-10 18:26:54 发布

dbow21397

最新推荐文章于 2025-05-10 18:26:54 发布

阅读量102

点赞数

原文链接：http://www.cnblogs.com/zhongweiv/archive/2011/11/01/CodeSimth_4.html

版权

本文详细介绍使用CodeSmith工具创建Ado.Net自定义模版的过程，重点介绍业务逻辑层(BLL)模版的编写方法，并提供了完整的代码示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CodeSmith 创建Ado.Net自定义模版（四）

接上一篇： CodeSmith 创建Ado.Net自定义模版（三）

编写业务逻辑层的模版：Step4_BLL.cst

<%@ CodeTemplate Language="C#" TargetLanguage="C#" ResponseEncoding="UTF-8" Description="实体类" %>
<%@ Property Name="NameSpace" Type="System.String" Default="Service" Category="Property" Description="命名空间" %>
<%@ Property Name="ModelNameSpace" Type="System.String" Default="Model" Category="String" Description="实体层的命名空间" %>
<%@ Property Name="DALNameSpace" Type="System.String" Default="Service" Category="String" Description="数据访问层的命名空间" %>
<%@ Property Name="Author" Type="System.String" Default="Wilson" Category="Property" Description="作者名" %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Optional="True" Category="db" Description="表映射文件" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Data" %>


<script runat="template">
///<summary>
///把数据库类型转化为C#类型
///</summary>
    public string DataType2CSharpType(System.Data.DbType dbType)
    {
        switch (dbType)
        {
            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.DateTime2:
                return "DateTime";
            case DbType.DateTimeOffset:
                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 "DateTime";                
            case DbType.UInt16:
                return "ushort";
            case DbType.UInt32:
                return "uint";
            case DbType.UInt64:
                return "ulong";
            case DbType.VarNumeric:
                return "decimal";
            case DbType.Xml:
                return "string";
            default:
                return "object";
        }
    }

///<summary>
/// 字符串转化为小写
///</summary>
    public string ToLowercase(string str)
    {
        str = str.ToLower();    
return str;
    }

///<summary>
/// 泛型
///</summary>
    public string ToGeneric(string str)
    {
        str = "<" + str + ">";    
return str;
    }
</script>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using <%=DALNameSpace%>;
using <%=ModelNameSpace%>;

namespace <%=NameSpace%>
{
///<summary>
///<%=SourceTable.Name%>业务逻辑
/// 创建人：<%=Author%>
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>  
///</summary>
    public class <%=SourceTable.Name%>Manager
    {

        <% if(SourceTable.HasPrimaryKey) %>
        <%{%>
#region##通过主键ID得到<%=SourceTable.Name%>
///<summary>
/// 功能：通过ID得到<%=SourceTable.Name%>
/// 创建人：  <%=Author%> 
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>   
///</summary>
///<param name="">主键ID</param>
///<returns></returns>
        public <%=SourceTable.Name%> Get<%=SourceTable.Name%>ById(<%=DataType2CSharpType(SourceTable.PrimaryKey.MemberColumns[0].DataType)%> <%=ToLowercase(SourceTable.PrimaryKey.MemberColumns[0].Name)%>)
        {            
using (<%=SourceTable.Name%>Service ws = new <%=SourceTable.Name%>Service())
            {
return ms.Get<%=SourceTable.Name%>ById(<%=ToLowercase(SourceTable.PrimaryKey.MemberColumns[0].Name)%>);
            }
        }
#endregion

#region##通过主键ID删除<%=SourceTable.Name%>
///<summary>
/// 功能：通过主键ID删除<%=SourceTable.Name%>
/// 创建人：  <%=Author%> 
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>   
///</summary>
///<param name="">主键ID</param>
///<returns></returns>
        public int DeleteById(<%=DataType2CSharpType(SourceTable.PrimaryKey.MemberColumns[0].DataType)%> <%=ToLowercase(SourceTable.PrimaryKey.MemberColumns[0].Name)%>)
        {
using (<%=SourceTable.Name%>Service ws = new <%=SourceTable.Name%>Service())
            {
return ws.DeleteById(<%=ToLowercase(SourceTable.PrimaryKey.MemberColumns[0].Name)%>);
            }
        }
#endregion            
        <%}%>

#region##添加<%=SourceTable.Name%>
///<summary>
/// 功能：添加<%=SourceTable.Name%>
/// 创建人：  <%=Author%> 
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>
///</summary>
///<param name=""></param>
///<returns></returns>
        public int Add<%=SourceTable.Name%>(<%=SourceTable.Name%> <%=ToLowercase(SourceTable.Name)%>)
        {
using (<%=SourceTable.Name%>Service ws = new <%=SourceTable.Name%>Service())
            {
return ws.Add<%=SourceTable.Name%>(<%=ToLowercase(SourceTable.Name)%>);
            }
        }
#endregion

#region##得到<%=SourceTable.Name%>集合
///<summary>
/// 功能：得到<%=SourceTable.Name%>集合
/// 创建人：  <%=Author%> 
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>
///</summary>       
///<returns></returns>
        public IList<%=ToGeneric(SourceTable.Name)%> GetList()
        {
using (<%=SourceTable.Name%>Service ws = new <%=SourceTable.Name%>Service())
            {
return ws.GetList();
            }
        }
#endregion

#region##修改<%=SourceTable.Name%>
///<summary>
/// 功能：修改<%=SourceTable.Name%>
/// 创建人：  <%=Author%> 
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>
///</summary>
///<param name=""></param>
///<returns></returns>
        public int Mod<%=SourceTable.Name%>(<%=SourceTable.Name%> <%=ToLowercase(SourceTable.Name)%>)
        {
using (<%=SourceTable.Name%>Service ws = new <%=SourceTable.Name%>Service())
            {
return ws.Mod<%=SourceTable.Name%>(<%=ToLowercase(SourceTable.Name)%>);
            }
        }
#endregion

#region##修改<%=SourceTable.Name%>
///<summary>
/// 修改<%=SourceTable.Name%>
/// 创建人：  <%=Author%> 
/// 创建时间：<%=DateTime.Now.ToShortDateString() %>
///</summary>
///<param name=""></param>
///<returns></returns>
        public int SelectCount()
        {
using (<%=SourceTable.Name%>Service ws = new <%=SourceTable.Name%>Service())
            {
return ws.SelectCount();
            }
        }
#endregion
    }
}

总结：这套模版分四步，这样就完成了一个三层建构的网站的大体部分，其它部分可以自行扩充，比如CodeSmith直接生成文件夹目录及文件夹到本地，或是中间要加入接口层等。

要写创建文件夹，及文件，就是一个IO操作，我这里就不写了。。

如果有要扩展的在头部引用

<%@ Import Namespace="System.IO" %>

把方法写在<script runat="template">标签中

比如：写一个方法

public CreatDir()

{

      System.IO.DirectoryInfo di = new DirectoryInfo(OutputDirectory);

      di.CreateSubdirectory("Domain");

              ....

}