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>