数据库:SQL Server 2000
Model, 即实体类,使用CodeSmith根据数据库表自动生成．这个是最常用的．
数据访问层, 最简单的增删改查操作也是使用CodeSmith根据数据库表配合SQLHelper类自动生成．
这层的设计,先贴点未完工的代码给大家参考参考.
1.DalCode.cs
using System;using System.Collections.Generic;using System.Text;using CodeSmith;using SchemaExplorer;using CodeSmith.CustomProperties;namespace DalCode
...{
/**//// <summary>
/// CodeSmith的DAL模板的代码类
/// </summary> public class DalCode ...{ //表 private TableSchema Table; /**//// <summary> /// 构造函数 /// </summary> /// <param name="table"></param> public DalCode(SchemaExplorer .TableSchema table) ...{ Table = table; } /**//// <summary> /// 获取Insert方法所需字段名 /// </summary> /// <returns></returns> public NameValueCollection GetInsertParm() ...{ NameValueCollection parm = new NameValueCollection(); foreach(ColumnSchema cs in Table .Columns) ...{ if(!IsIdentity (cs)) ...{ if(!IsDefault (cs)) ...{ parm.Add(cs.Name,ToSQLType (cs.DataType.ToString())); } } } return parm; } /**//// <summary> /// 获取Delete方法所需字段名 /// </summary> /// <returns></returns> public NameValueCollection GetDeleteParm() ...{ NameValueCollection parm = new NameValueCollection(); foreach (ColumnSchema cs in Table.Columns) ...{ if (IsIdentity(cs)) ...{ parm.Add(cs.Name, cs.DataType.ToString()); } } return parm; } /**//// <summary> /// 获取Update方法所需字段名 /// </summary> /// <returns></returns> public NameValueCollection GetUpdateParm() ...{ NameValueCollection parm = new NameValueCollection(); foreach (ColumnSchema cs in Table.Columns) ...{ if (!IsIdentity(cs)) ...{ parm.Add(cs.Name, cs.DataType.ToString()); } } return parm; } /**//// <summary> /// 获取Select方法所需字段名 /// </summary> /// <returns></returns> public NameValueCollection GetSelectParm() ...{ NameValueCollection parm = new NameValueCollection(); foreach (ColumnSchema cs in Table.Columns) ...{ if (IsIdentity(cs)) ...{ parm.Add(cs.Name, cs.DataType.ToString()); } } return parm; } /**//// <summary> /// 检查字段是否为标识符 /// </summary> /// <param name="cs"></param> /// <returns></returns> private bool IsIdentity(ColumnSchema cs) ...{ return (bool)cs.ExtendedProperties["CS_IsIdentity"].Value; } /**//// <summary> /// 检查字段是否有默认值 /// </summary> /// <param name="cs"></param> /// <returns></returns> private bool IsDefault(ColumnSchema cs) ...{ if ((String)cs.ExtendedProperties["CS_Default"].Value == "") ...{ return false; } return true; } /**//// <summary> /// 将数据类型转换成SQL数据类型 /// </summary> /// <param name="type"></param> /// <returns></returns> private string ToSQLType(string type) ...{ switch (type) ...{ case "AnsiString": return "SqlDbType.VarChar"; break; default : return type; } } }
}
