CodeSmith模板

重复性的工作交给代码生成器就好，这里分享几套模板，

1.从数据库抓取字段，生成Table元素，这个在web开发中很有用

<%-- 
Name:
Author: 
Description: 
--%>
<%@ Template Language="C#" TargetLanguage="Text" %>

<%@ Assembly Name="SchemaExplorer" %> 
<%@ Import Namespace="SchemaExplorer" %>  
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema"
      Category="Context"
      Description="Table that the stored procedures should be based on." %>
      <%@ Property Name="SortColsNum" Type="System.Int32" Default="4" Optional="True" Category="Int" Description="每行显示栏数"  %>
      
<form id="f_edit">
  <table cellpadding="0" cellspacing="0" style=" 100%; text-align: left; table-layout: fixed; border: 1px solid #BABABA; padding: 8px 4px 4px 4px;margin-bottom:4px ">
              <% int i=0;%>  
<% foreach (ColumnSchema column in this.SourceTable.Columns) 
  { %>
  <% i++; %>
  <% if (i%SortColsNum==1 || SortColsNum==1)
     { %>
        <tr>
  <% } %>
     <td class="myothertdnm"><%=GetName(GetColumnName( column.Name)).ToUpper()%>:</td>
  <% if (i%SortColsNum==0)
     { %>
     <td class="myothertdlast"><input type="text" name="<%=GetName(GetColumnName( column.Name))%>" class="easyui-validatebox" required="true" validtype="length[1,5]" style="96%;" /></td>
  <% } %>
  <% else
     { %>
     <td class="myothertdnm"><input type="text" name="<%=GetName(GetColumnName( column.Name))%>" class="easyui-validatebox" required="true" validtype="length[1,5]" style="96%;" /></td>
  <% } %>
<% if (i%SortColsNum==0) 
     { %>
        </tr>
  <% } %>
<% } %>

<% if ((i%SortColsNum!=0 && i%SortColsNum!=1)||(SortColsNum<i&&SortColsNum!=1))
     { %>
        </tr>
  <% } %>
  </table>
</form>
            
<script runat="template">
public string GetClassName(string name)
    {
        string returnName="";
         
        if(name.Length >0)
        {
            string[] names = name.Split('_');
            foreach(string item in names)
            {
                
                 returnName+= GetFunctionStr(item);
            }
            returnName ="Ent"+returnName;
        }
        
        
        return returnName;
        }
    public string GetColumnName(string name)
    { 
        string returnName="";
         
        if(name.Length >0)
        {
            string[] names = name.Split('_');
            foreach(string item in names)
            {
                
                 returnName+= GetFunctionStr(item);
                }
        } 
        return returnName;
    }
        
public string GetFunctionStr(string name)
{
    string nameLower;
    if(name.Length >0)
    {
        nameLower = name.ToLower();
        return nameLower.Substring(0,1).ToUpper()+nameLower.Substring(1);
        }
    return "";
    }

public string GetType(SchemaExplorer.ViewColumnSchema field)
{     
            string nativeType  = field.NativeType.ToLower();
            string result = "no:"+nativeType;

            switch(nativeType)
            {
            case "nvarchar2": result ="string";break;
            case "varchar2": result ="string";break;
            case "char": result ="string";break;
            case "number": result ="decimal?";break;
            case "long": result ="double";break;
            case "date": result ="System.DateTime?";break;
            } 
            
            switch(field.DataType)
            {
            case DbType.AnsiString:result= "string" ;break;
            case DbType.AnsiStringFixedLength:result= "string" ;break;
            case DbType.Boolean:result= "bool" ;break;
            case DbType.Date:result= "DateTime?" ;break;
            case DbType.Double:result="double?" ;break;
            case DbType.Decimal:result="decimal?" ;break;
            case DbType.DateTime:result= "DateTime?" ;break;
            case DbType.Int32:result= "int?" ;break; 
            
            }
            
            return result;
}

public string  GetName(string name)
{
     return name;
}
</script>

 CodeSmith可以去网上下载，pj版的比较多，涉及版权，我就不放了，

基本上重复性的工作都可以交给它