CodeSmith6.5 GetList

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Debug="False" Description="Template description here." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema"  Category="数据库表"  Optional="True" Description="the table name"   %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Assembly Name="CodeSmith.BaseTemplates" %>
<%@ Import Namespace="CodeSmith.BaseTemplates" %>
<%@ Assembly Name="CodeSmith.CustomProperties" %>
<%@ Import Namespace="CodeSmith.CustomProperties" %>
<%@ Property Name="ConnectionTypeName" Type="ConnectionType" Category="数据源连接类型" %>
<%@ Map Name="CSharpAlias" Src="System-CSharpAlias" %>

<script runat="template">
public enum ConnectionType
{
    SqlHelper,
    MySqlHelper,
    OleDbHelper
}
public string GetParameterTypeName()
{
    switch(ConnectionTypeName)
    {
        case ConnectionType.SqlHelper:return "SqlParameter";
        case ConnectionType.MySqlHelper:return "MySqlParameter";
        case ConnectionType.OleDbHelper:return "OleDbParameter";
        default:return "SqlParameter";
    }
}
</script>
public IList<Model.<%=this.SourceTable.Name.Substring(0,1).ToUpper() %><%=SourceTable.Name.Substring(1) %>Model> GetList(<%=CSharpAlias[this.SourceTable.Columns[0].SystemType.FullName] %> <%=this.SourceTable.Columns[0].Name %>)
{
    <%  string cols=string.Empty;
        foreach(ColumnSchema col in this.SourceTable.Columns)
        {
            cols+=col.Name+",";
        }
        cols=cols.Remove(cols.Length-1);
        string[] strParamNames=cols.Split(',');
    %>
    StringBuilder commandText=new StringBuilder();
    commandText.Append("select <%=cols %> from <%=this.SourceTable.Name %>");
    commandText.Append(" where <%=strParamNames[0] %>=@<%=strParamNames[0] %>");
    <%=GetParameterTypeName() %>[] commandParameters = {
            new <%=GetParameterTypeName() %>("@<%=strParamNames[0] %>", <%=this.SourceTable.Columns[0].Name %>)    
            };
    
    List<Model.<%=this.SourceTable.Name.Substring(0,1).ToUpper() %><%=SourceTable.Name.Substring(1) %>Model> list=new List<Model.<%=this.SourceTable.Name.Substring(0,1).ToUpper() %><%=SourceTable.Name.Substring(1) %>Model>();
    using (DbDataReader reader = DBUtility.<%=ConnectionTypeName %>.ExecuteReader(commandText.ToString(), commandParameters))
    {
        while (reader.Read())
        {
            Model.<%=this.SourceTable.Name.Substring(0,1).ToUpper() %><%=this.SourceTable.Name.Substring(1) %>Model model = new Model.<%=this.SourceTable.Name.Substring(0,1).ToUpper() %><%=this.SourceTable.Name.Substring(1) %>Model();
            <%foreach(ColumnSchema col in this.SourceTable.Columns)
            {%>
            if (!Convert.IsDBNull(reader["<%=col.Name %>"]))
            {
                model.<%=col.Name.Substring(0,1).ToUpper() %><%=col.Name.Substring(1) %> = (<%=CSharpAlias[col.SystemType.FullName] %>)(reader["<%=col.Name %>"]); 
            }
            <%}%>

            list.Add(model);
        } 
    }

    return list;
}