ASP.NET三层架构源码(CodeSmith版)之一：Table-BLL层
动软代码生成器生成的ASP.NET三层架构代码比较规范，是学习ASP.NET的好例子
此三层架构改造自动软的工厂模式模板，使用CodeSmith进行重写，以方便大家修改模板文件
以下是针对表格的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="TableName" Type="TableSchema" DeepLoad="True" Optional="False" Category="01. Getting Started - Required" Description="" %>
<%@ Property Name="Namespace" Type="String" Category="Context" Description="NameSpace" Default="Crs811NameSpace"%>
<%@ Property Name="Author" Type="String" Category="Context" Description="Author" Default="chenr"%>
<%@ 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) %> Business Logic
// Author:<%=Author%>
// Create Time:<%= DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")%>
//------------------------------------------------*/
using System;
using System.Text;
using System.Data;
using System.Collections.Generic;
using <%=Namespace%>.DBUtility;
using <%=Namespace%>.Model;
using <%=Namespace%>.DALFactory;
using <%=Namespace%>.IDAL;
namespace <%=Namespace%>.BLL
{
/// <summary>
/// <%=ClearPrefix(TableName.Name) %>
/// </summary>
public partial class <%=ClearPrefix(TableName.Name) %>
{
private readonly I<%=ClearPrefix(TableName.Name) %> dal = <%=Namespace%>DALFactory.Create<%=ClearPrefix(TableName.Name) %>();
public <%=ClearPrefix(TableName.Name) %>() {}
#region BasicMethod
/// <summary>
/// 得到最大ID
/// </summary>
public int GetMaxId()
{
return dal.GetMaxId();
}
/// <summary>
/// 是否存在该记录
/// </summary>
public bool Exists(<%= GetInParameter(TableName) %>)
{
return dal.Exists(<%= GetPK(TableName) %>);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(m<%=ClearPrefix(TableName.Name) %> model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(m<%=ClearPrefix(TableName.Name) %> model)
{
return dal.Update(model);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(<%= GetInParameter(TableName) %>)
{
return dal.Delete(<%= GetPK(TableName) %>);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public m<%=ClearPrefix(TableName.Name) %> GetModel(<%= GetInParameter(TableName) %>)
{
return dal.GetModel(<%= GetPK(TableName) %>);
}
/// <summary>
/// 得到一个对象实体，从缓存中
/// </summary>
/*public m<%=ClearPrefix(TableName.Name) %> GetModelByCache(<%= GetInParameter(TableName) %>)
{
string CacheKey = "tTestModel-" + c1+C5+C8;
object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey);
if (objModel == null)
{
try
{
objModel = dal.GetModel(<%= GetPK(TableName) %>);
if (objModel != null)
{
int ModelCache = Maticsoft.Common.ConfigHelper.GetConfigInt("ModelCache");
Maticsoft.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);
}
}
catch{}
}
return (<%=ClearPrefix(TableName.Name) %>)objModel;
}*/
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetList(string strWhere)
{
return dal.GetList(strWhere);
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top,string strWhere,string filedOrder)
{
return dal.GetList(Top,strWhere,filedOrder);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<m<%=ClearPrefix(TableName.Name) %>> GetModelList(string strWhere)
{
DataSet ds = dal.GetList(strWhere);
return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<m<%=ClearPrefix(TableName.Name) %>> DataTableToList(DataTable dt)
{
List<m<%=ClearPrefix(TableName.Name) %>> modelList = new List<m<%=ClearPrefix(TableName.Name) %>>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
m<%=ClearPrefix(TableName.Name) %> model;
for (int n = 0; n < rowsCount; n++)
{
model = dal.DataRowToModel(dt.Rows[n]);
if (model != null)
{
modelList.Add(model);
}
}
}
return modelList;
}
/// <summary>
/// 获得数据列表
/// </summary>
public DataSet GetAllList()
{
return GetList("");
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public int GetRecordCount(string strWhere)
{
return dal.GetRecordCount(strWhere);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
return dal.GetListByPage( strWhere, orderby, startIndex, endIndex);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
//public DataSet GetList(int PageSize,int PageIndex,string strWhere)
//{
//return dal.GetList(PageSize,PageIndex,strWhere);
//}
#endregion BasicMethod
#region ExtensionMethod
#endregion ExtensionMethod
}
}
<script runat="template">
public string ClearPrefix(string name)
{
/*int mIndex=name.IndexOf(TablePrefix);
string strResult=name.Remove(0,TablePrefix.Length);
return strResult; */
return name;
}
public string GetPK(TableSchema TableName)
{
string strReturn = "";
for (int i=0; i<TableName.PrimaryKey.MemberColumns.Count; i++)
{
strReturn += TableName.PrimaryKey.MemberColumns[i].Name+",";
}
return strReturn.TrimEnd(',');
}
public string GetInParameter(TableSchema TableName)
{
string strReturn = "";
for (int i=0; i<TableName.PrimaryKey.MemberColumns.Count; i++)
{
strReturn += GetCSharpTypeFromDBFieldType(TableName.PrimaryKey.MemberColumns[i])+" "+TableName.PrimaryKey.MemberColumns[i].Name+",";
}
return strReturn.TrimEnd(',');
}
public string GetCSharpTypeFromDBFieldType(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.StringFixedLength: return "UniqueIdentifier";
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>