这些只是个人总结来写在的模版。请大家指点。 暂时我把它 生成的代码放到 BLL层，也不知道这样子分层合不合适。
<%@ CodeTemplate Language="C#" ResponseEncoding="UTF-8" TargetLanguage="Text" Src="" Inherits="" Debug="False" Description="Template description here." %> <%@ Property Name="NameSpaceOfModel" Type="System.String" Default="ZdSoft.Models" Category="Object" Description="NameSpace of Models" %> <%@ Property Name="NameSpaceOfBll" Type="System.String" Default="ZdSoft.Bll" Category="Object" Description="NameSpace of Bll" %> <%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the mapping file is based on" %> <%@ Assembly Name="SchemaExplorer" %> <%@ Property Name="RemoveTablePrefix" Type="System.String" Default="Tb" Category="Object" Description="The prefix to remove from table names" %> <%@ Assembly Name="System.Data" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Text.RegularExpressions" %> /***************************************************************** // Copyright (C) 2011-2099 ZdSoft Corporation // All rights reserved. // // Author: <%= Author %> // Create Date: <%= DateTime.Now.ToString() %> // Usage: <%= Description %> // // RevisionHistory // Date Author Description *****************************************************************/
using System; using System.Collections.Generic; using System.Linq; using System.Text; using <%=NameSpaceOfModel%>;
namespace <%=NameSpaceOfBll%> { public class <%=SourceTable.Name.Replace(RemoveTablePrefix,"")%> { public EntitiesDataContext Entities = new EntitiesDataContext();
/// <summary> /// 还回所有行 /// </summary> /// <returns></returns> public IQueryable<<%=SourceTable.Name%>> GetAll() { return Entities.<%=SourceTable.Name%>; }
/// <summary> /// 根据主键还回实体 /// </summary> /// <param name="id">主键</param> public <%=SourceTable.Name%> GetEntityById(string id) { return Entities.<%=SourceTable.Name%>.FirstOrDefault(o => o.<%=SourceTable.PrimaryKey.MemberColumns[0].Name%>.Equals(id)); }
/// <summary> /// 添加实体 /// </summary> /// <param name="entity">实体</param> public void Add(<%=SourceTable.Name%> entity) { Entities.<%=SourceTable.Name%>.InsertOnSubmit(entity); }
/// <summary> /// 删除实体 /// </summary> /// <param name="entity">实体</param> public void Delete(<%=SourceTable.Name%> entity) { Entities.<%=SourceTable.Name%>.DeleteOnSubmit(entity); } /// <summary> /// 根据主键批量删除 /// </summary> /// <param name="primaryKey">主键数组</param> public void Delete(string[] primaryKey) { if (primaryKey == null || primaryKey.Length <= 0) return; var entities = from o in Entities.<%=SourceTable.Name%> where primaryKey.Contains(o.<%=SourceTable.PrimaryKey.MemberColumns[0].Name%>) select o; Entities.<%=SourceTable.Name%>.DeleteAllOnSubmit(entities); }
/// <summary> /// 根据传入实体批量删除 /// </summary> /// <param name="entities">实体列表</param> public void Delete(List<<%=SourceTable.Name%>> entities) { if(entities==null||entities.Count==0) return; Entities.<%=SourceTable.Name%>.DeleteAllOnSubmit(entities); }
/// <summary> /// 保存修改(新增、删除、修改) /// </summary> public void Save() { Entities.SubmitChanges(); }
} } <script runat="template"> public string Author="wunaigong"; public string Description="业务逻辑 数据的增删除改查"; private DatabaseSchema _sourceDatabase; [Category("Database")] [Description("Database that the mapping file should be based on.")] //public DatabaseSchema SourceDatabase { // get { return _sourceDatabase; } // set { _sourceDatabase = value; } // }
//获取数据库字段的描述 column.Name public string GetColumnDes(ColumnSchema column) { if(column.Description.Trim().ToString()!=string.Empty) { return column.Description.Trim().ToString(); }else return column.Name.ToString().Replace("_",""); }
//C#还回数据类型 public string CSharpType(ColumnSchema column) { if (column.Name.EndsWith("TypeCode")) return column.Name;
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; } } } </script>
转载于:https://www.cnblogs.com/test99/archive/2011/04/26/codesmith2bll.html
相关资源：CodeSmith模版-生成C#增删改查（分页，主键）方法和存储过程