Model模板文件：
<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %> <%@ Assembly Name="SchemaExplorer" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Text" %> <%@ Property Name="NameSpace" Type="String" Category="Context" Description="The namespace to use for this class" %> <%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %> <%@ Property Name="Author" Type="String" Category="Context" Description="Author" %> <%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %> /*------------------------------------------------ // File Name:<%=ClearPrefix(TableName.Name) %>Info.cs // File Description:<%=ClearPrefix(TableName.Name) %> DataBase Entity // Author:<%=Author%> // Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%> //------------------------------------------------*/ using System; namespace <%=NameSpace%>.Model { /// <summary> /// Description <%=TableName.Description %> /// </summary> [Serializable] public class <%=ClearPrefix(TableName.Name) %>Info { #region Private Protery <%for(int i=0;i<TableName.Columns.Count;i++){%> private <%=CSharpType(TableName.Columns[i])%> _<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>; <%}%> #endregion #region Constructor /// <summary> /// <%=ClearPrefix(TableName.Name) %> Constructor /// </summary> public <%=ClearPrefix(TableName.Name) %>Info() { } /// <summary> /// <%=ClearPrefix(TableName.Name) %> Constructor With Parameters /// </summary> <%for(int i=0;i<TableName.Columns.Count;i++){%> ///<param name="<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>"><%if(TableName.Columns[i].Description.Length>0){%><%=TableName.Columns[i].Name+" "+TableName.Columns[i].Description%><%}else{%><%=TableName.Columns[i].Name%><%}%></param> <%}%> public <%=ClearPrefix(TableName.Name) %>Info(<%for(int i=0;i<TableName.Columns.Count;i++){%><%=CSharpType(TableName.Columns[i])%> <%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%><% if (i < TableName.Columns.Count - 1) { %>,<%}%><%}%>) { <%for(int i=0;i<TableName.Columns.Count;i++){%> this._<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%> = <%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>; <%}%> } #endregion #region Public Property <%for(int i=0;i<TableName.Columns.Count;i++){%> ///<Summary> /// <%=TableName.Columns[i].Name%><%if(TableName.Columns[i].Description.Length>0){%> /// <%=TableName.Columns[i].Description%><%}%> ///</Summary> public <%=CSharpType(TableName.Columns[i]).Trim()%> <%=TableName.Columns[i].Name%> { get { return _<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%>; } set { _<%=TableName.Columns[i].Name.Substring(0,1).ToLower()+TableName.Columns[i].Name.Substring(1,TableName.Columns[i].Name.Length-1)%> = value; } } <%}%> #endregion } } <script runat="template"> public string CSharpType(ColumnSchema column) { if (column.Name.EndsWith("TypeCode")) return column.Name; switch (column.DataType) { case DbType.AnsiString: case DbType.String: case DbType.StringFixedLength: case DbType.AnsiStringFixedLength: return "string"; case DbType.VarNumeric: case DbType.Currency: case DbType.Decimal: return "decimal"; case DbType.Binary: return "byte[]"; case DbType.Boolean: return "bool"; case DbType.Byte: return "byte"; case DbType.Date: return "DateTime"; case DbType.DateTime: return "DateTime"; 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.Time: return "TimeSpan"; case DbType.UInt16: return "ushort"; case DbType.UInt32: return "uint"; case DbType.UInt64: return "ulong"; default: { return "__UNKNOWN__" + column.NativeType; } } } public string ClearPrefix(string name) { int mIndex=name.IndexOf(TablePrefix); string strResult=name.Remove(0,TablePrefix.Length); return strResult; } </script>
IDAL模板文件：
<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %> <%@ Assembly Name="SchemaExplorer" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Text" %> <%@ Property Name="Namespace" Type="String" Category="Context" Description="The namespace to use for this class" %> <%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %> <%@ Property Name="Author" Type="String" Category="Context" Description="Author" %> <%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %> /*------------------------------------------------ // File Name:I<%=ClearPrefix(TableName.Name) %>.cs // File Description:<%=ClearPrefix(TableName.Name) %> Interface // Author:<%=Author%> // Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%> //------------------------------------------------*/ using System; using System.Text; using System.Collections.Generic; using <%=Namespace%>.Model; namespace <%=Namespace%>.IDAL { /// <summary> /// <%=ClearPrefix(TableName.Name) %> Interface /// </summary> public interface I<%=ClearPrefix(TableName.Name) %> { /// <summary> /// Add <%=ClearPrefix(TableName.Name) %> /// </summary> /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param> /// <returns>True or False</returns> bool Add(<%=ClearPrefix(TableName.Name) %>Info model); /// <summary> /// Delete <%=ClearPrefix(TableName.Name) %> By ID /// </summary> /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param> /// <returns>True or False</returns> bool DeleteByID(int id); /// <summary> /// Delete <%=ClearPrefix(TableName.Name) %> By Name /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns>True or False</returns> bool DeleteByName(string name); /// <summary> /// Update <%=ClearPrefix(TableName.Name) %> /// </summary> /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param> /// <returns>True or False</returns> bool Update(<%=ClearPrefix(TableName.Name) %>Info model); /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> By ID /// </summary> /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param> /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns> <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByID(int id); /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> By Name /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns> <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByName(string name); /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> List /// </summary> /// <returns><%=ClearPrefix(TableName.Name) %> List</returns> IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>ListByPage(); /// <summary> /// Check If <%=ClearPrefix(TableName.Name) %> Exist /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns>True or False</returns> bool Is<%=ClearPrefix(TableName.Name) %>Exist(string name); } } <script runat="template"> public string ClearPrefix(string name) { int mIndex=name.IndexOf(TablePrefix); string strResult=name.Remove(0,TablePrefix.Length); return strResult; } </script>
SQLServerDAL模板文件：
<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %> <%@ Assembly Name="SchemaExplorer" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Text" %> <%@ Property Name="Namespace" Type="String" Category="Context" Description="The namespace to use for this class" %> <%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %> <%@ Property Name="Author" Type="String" Category="Context" Description="Author" %> <%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %> /*------------------------------------------------ // File Name:<%=ClearPrefix(TableName.Name) %>.cs // File Description:<%=ClearPrefix(TableName.Name) %> SQL Server DataBase Access // Author:<%=Author%> // Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%> //------------------------------------------------*/ using System; using System.Text; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using <%=Namespace%>.Model; using <%=Namespace%>.IDAL; namespace <%=Namespace%>.DAL { /// <summary> /// <%=ClearPrefix(TableName.Name) %> /// </summary> public class <%=ClearPrefix(TableName.Name) %>:I<%=ClearPrefix(TableName.Name) %> { public <%=ClearPrefix(TableName.Name) %>(){} #region <%=ClearPrefix(TableName.Name) %> Interface Implement /// <summary> /// Add <%=ClearPrefix(TableName.Name) %> /// </summary> /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param> /// <returns>True or False</returns> public bool Add(<%=ClearPrefix(TableName.Name) %>Info model){ SqlParameter[] param = new SqlParameter[<%=TableName.Columns.Count-1 %>]; <%for(int i=0;i<TableName.Columns.Count;i++){ if(((bool)TableName.Columns[i].ExtendedProperties["CS_IsIdentity"].Value) == true) { continue; }%> param[<%=i %>] = new SqlParameter("@<%=TableName.Columns[i].Name%>",model.<%=TableName.Columns[i].Name%>); <%}%> try { SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Add<%=ClearPrefix(TableName.Name) %>", param); return true; }catch { return false; } } /// <summary> /// Delete <%=ClearPrefix(TableName.Name) %> By ID /// </summary> /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param> /// <returns>True or False</returns> public bool DeleteByID(int id){ SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", id); try { SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Del<%=ClearPrefix(TableName.Name) %>ByID", param); return true; }catch { return false; } } /// <summary> /// Delete <%=ClearPrefix(TableName.Name) %> By Name /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns>True or False</returns> public bool DeleteByName(string name){ SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@name",name); try { SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Del<%=ClearPrefix(TableName.Name) %>ByName", param); return true; }catch { return false; } } /// <summary> /// Update <%=ClearPrefix(TableName.Name) %> /// </summary> /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param> /// <returns>True or False</returns> public bool Update(<%=ClearPrefix(TableName.Name) %>Info model){ SqlParameter[] param = new SqlParameter[<%=TableName.Columns.Count-1 %>]; <%for(int i=0;i<TableName.Columns.Count;i++){%> param[<%=i %>] = new SqlParameter("@<%=TableName.Columns[i].Name%>",model.<%=TableName.Columns[i].Name%>); <%}%> try { SQLHelper.ExecuteNonQuery(CommandType.StoredProcedure,"SP_Update<%=ClearPrefix(TableName.Name) %>", param); return true; }catch { return false; } } /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> By ID /// </summary> /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param> /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns> public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByID(int id){ SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", id); <%=ClearPrefix(TableName.Name) %>Info model = null; using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure,"SP_Get<%=ClearPrefix(TableName.Name) %>ByID", param)) { while (dr.Read()) { model = Get<%=ClearPrefix(TableName.Name) %>Model(dr); } return model; } } /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> By Name /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns> public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByName(string name){ SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@name", name); <%=ClearPrefix(TableName.Name) %>Info model = null; using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure,"SP_Get<%=ClearPrefix(TableName.Name) %>ByName", param)) { while (dr.Read()) { model = Get<%=ClearPrefix(TableName.Name) %>Model(dr); } return model; } } /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> List /// </summary> /// <returns><%=ClearPrefix(TableName.Name) %> List</returns> public IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>ListByPage(){ using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.StoredProcedure, "SP_Get<%=ClearPrefix(TableName.Name) %>ListByPage", null)) { IList<<%=ClearPrefix(TableName.Name) %>Info> list = new List<<%=ClearPrefix(TableName.Name) %>Info>(); while(dr.Read()) { list.Add(Get<%=ClearPrefix(TableName.Name) %>Model(dr)); } return list; } } /// <summary> /// Check If <%=ClearPrefix(TableName.Name) %> Exist /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns>True or False</returns> public bool Is<%=ClearPrefix(TableName.Name) %>Exist(string name){ SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@name", name); return Convert.ToBoolean(SQLHelper.ExecuteScalar(CommandType.StoredProcedure,"SP_Is<%=ClearPrefix(TableName.Name) %>Exist", param)); } #endregion #region Private Methods private <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>Model(SqlDataReader dr){ <%=ClearPrefix(TableName.Name) %>Info model=new <%=ClearPrefix(TableName.Name) %>Info(); <%for(int i=0;i<TableName.Columns.Count;i++){%> model.<%=TableName.Columns[i].Name%>=SQLDataHelper.<%=CSharpType(TableName.Columns[i])%>(dr, "<%=TableName.Columns[i].Name%>"); <%}%> return model; } private IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>List(SqlDataReader dr){ IList<<%=ClearPrefix(TableName.Name) %>Info> list = new List<<%=ClearPrefix(TableName.Name) %>Info>(); while (dr.Read()) { list.Add(Get<%=ClearPrefix(TableName.Name) %>Model(dr)); } return list; } #endregion } } <script runat="template"> public string CSharpType(ColumnSchema column) { if (column.Name.EndsWith("TypeCode")) return column.Name; switch (column.DataType) { case DbType.AnsiString: case DbType.String: case DbType.StringFixedLength: case DbType.AnsiStringFixedLength: return "GetString"; case DbType.Int16: case DbType.Int32: case DbType.Int64: case DbType.UInt16: case DbType.UInt32: case DbType.UInt64: return "GetInt"; case DbType.Time: case DbType.Date: case DbType.DateTime: return "GetDateTime"; case DbType.Binary: case DbType.SByte: case DbType.Byte: return "GetBytes"; case DbType.VarNumeric: case DbType.Currency: case DbType.Decimal: return "GetDecimal"; case DbType.Single: case DbType.Double: return "GetDouble"; case DbType.Boolean: return "GetBoolean"; case DbType.Guid: return "GetGuid"; case DbType.Object: return "GetObject"; default: { return "__UNKNOWN__" + column.NativeType; } } } public string ClearPrefix(string name) { int mIndex=name.IndexOf(TablePrefix); string strResult=name.Remove(0,TablePrefix.Length); return strResult; } </script>
BLL模板文件：
<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="Generates a class including a special informational header" %> <%@ Assembly Name="SchemaExplorer" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Import Namespace="System.Text" %> <%@ Property Name="Namespace" Type="String" Category="Context" Description="The namespace to use for this class" %> <%@ Property Name="TableName" Type="SchemaExplorer.TableSchema" DeepLoad="True" Optional="False" Category="Context" Description="The name of the table to generate" %> <%@ Property Name="Author" Type="String" Category="Context" Description="Author" %> <%@ Property Name="TablePrefix" Type="System.String" Default="T" Category="Context" Description="The prefix to remove from table names" %> /*------------------------------------------------ // File Name:<%=ClearPrefix(TableName.Name) %>BLL.cs // File Description:<%=ClearPrefix(TableName.Name) %> Business Logic // Author:<%=Author%> // Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%> //------------------------------------------------*/ using System; using System.Text; using System.Collections.Generic; using <%=Namespace%>.Model; using <%=Namespace%>.IDAL; namespace <%=Namespace%>.BLL { /// <summary> /// <%=ClearPrefix(TableName.Name) %>BLL /// </summary> public class <%=ClearPrefix(TableName.Name) %>BLL { //Get <%=ClearPrefix(TableName.Name) %> Entity Class from Factory Layer private static readonly I<%=ClearPrefix(TableName.Name) %> dal = <%=Namespace%>.DALFactory.DataAccess.<%=ClearPrefix(TableName.Name) %>(); /// <summary> /// Add <%=ClearPrefix(TableName.Name) %> /// </summary> /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param> /// <returns>True or False</returns> public bool Add(<%=ClearPrefix(TableName.Name) %>Info model){ return dal.Add(model); } /// <summary> /// Delete <%=ClearPrefix(TableName.Name) %> By ID /// </summary> /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param> /// <returns>True or False</returns> public bool DeleteByID(int id){ return dal.DeleteByID(id); } /// <summary> /// Delete <%=ClearPrefix(TableName.Name) %> By Name /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns>True or False</returns> public bool DeleteByName(string name){ return dal.DeleteByName(name); } /// <summary> /// Update <%=ClearPrefix(TableName.Name) %> /// </summary> /// <param name="model"><%=ClearPrefix(TableName.Name) %> Model</param> /// <returns>True or False</returns> public bool Update(<%=ClearPrefix(TableName.Name) %>Info model){ return dal.Update(model); } /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> By ID /// </summary> /// <param name="id"><%=ClearPrefix(TableName.Name) %> ID</param> /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns> public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByID(int id){ return dal.Get<%=ClearPrefix(TableName.Name) %>InfoByID(id); } /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> By Name /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns><%=ClearPrefix(TableName.Name) %> Model</returns> public <%=ClearPrefix(TableName.Name) %>Info Get<%=ClearPrefix(TableName.Name) %>InfoByName(string name){ return dal.Get<%=ClearPrefix(TableName.Name) %>InfoByName(name); } /// <summary> /// Get <%=ClearPrefix(TableName.Name) %> List /// </summary> /// <returns><%=ClearPrefix(TableName.Name) %> List</returns> public IList<<%=ClearPrefix(TableName.Name) %>Info> Get<%=ClearPrefix(TableName.Name) %>ListByPage(){ return dal.Get<%=ClearPrefix(TableName.Name) %>ListByPage(); } /// <summary> /// Check If <%=ClearPrefix(TableName.Name) %> Exist /// </summary> /// <param name="name"><%=ClearPrefix(TableName.Name) %> Name</param> /// <returns>True or False</returns> public bool Is<%=ClearPrefix(TableName.Name) %>Exist(string name){ return dal.Is<%=ClearPrefix(TableName.Name) %>Exist(name); } } } <script runat="template"> public string ClearPrefix(string name) { int mIndex=name.IndexOf(TablePrefix); string strResult=name.Remove(0,TablePrefix.Length); return strResult; } </script>