GoldHoo/tools/代码生成器(Goldhoo)/Template/Empty.cst

   <script>
      public string GetLengthText(ColumnSchema column)
      {
          string result = string.Empty;
          switch(column.DataType)
          {
             case "char":
             case "varchar":
             case "nchar":
             case "nvarchar":
                result = "(" + column.Length.ToString() + ")";
                break;
             default:
               break;
          }
          return result;
      }
   </script> 
   
   <% foreach (ColumnSchema column in Table.Columns) { 
       	switch(column.CSDataType){ case "DateTime": %>
   <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").ToString("yyyy-MM-dd"), <%
            		    break;
            		case "DateTime?": %>
   <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").HasValue ? row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>").Value.ToString("yyyy-MM-dd") : string.Empty,	<%
            	       break;
            	   default:   %> 	
   <%= column.AliasName %> = row.Field<<%= column.CSDataType %>>("<%= column.AliasName %>"), <% break; } } %>
        
-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   <th field="<%= column.AliasName %>" halign="center" align="left" width="100px"><%= column.Text %></th> <% } %>  

-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   list.Add(new { id = "<%= column.AliasName %>", name = "<%= column.Text %>", value = columnSchema.TableName, group = "group1", editor = textbox }); <% } %>  

-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   <%= column.AliasName %> = '<%= column.Text %>',    <% } %>    
   
-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   dataSet.Tables[0].Columns["<%= column.AliasName %>"].Caption = "<%= column.Text %>"; <% } %>  
   			
-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   @<%= column.AliasName %>  <%= column.DataType %><%= GetLengthText(column) %>,           -- <%= column.Text %> <% } %>      
     
-------------------------------------------------------------------------------- 
 <% 
   StringBuilder sb = new StringBuilder();
   foreach (ColumnSchema column in Table.SelectedColumns)
   {         
   	  sb.Append(column.AliasName).Append(", ");
   }
 %>
   <%= sb.ToString() %>        
           
-------------------------------------------------------------------------------- 
     
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   <%= column.AliasName %> nvarchar(50),               -- <%= column.Text %> <% } %>             
           
-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   <%= column.AliasName %>,               -- <%= column.Text %> <% } %>    

-------------------------------------------------------------------------------- 
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   <%= column.AliasName %> AS <%= column.Text %>, <% } %>  
--------------------------------------------------------------------------------
   <% foreach (ColumnSchema column in Table.SelectedColumns) { %>
   <td width="10%" class="td_item" align="right">
      <%= column.Text %>：
   </td>
   <td width="23%" class="td_item_text">
      <input name="<%= column.AliasName %>" class="easyui-textbox" />
   </td>
      <% } %>