datemplate.txt

几个用CodeSmith的自动生成的C#代码

<%-- 
Name:
Author: 
Description: 
--%>
<%@ CodeTemplate Language="C#" TargetLanguage="Text" Src="" Inherits="" Debug="False" 
Description="Template description here." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context"  
Description="Table to get the data from."%>

<%@ Property Name="Project" 
	Type="System.String" 
	Optional="False" 
	Category="1. Class Definition" 
	Description="The name of Folder." %>

<%@ Property Name="Folder" 
	Type="System.String" 
	Optional="False" 
	Category="1. Class Definition" 
	Description="The name of Folder." %>

<%@ Property Name="Summary" 
	Type="System.String" 
	Optional="False" 
	Category="1. Class Definition" 
	Description="The name of Folder." %>

<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="System.Data" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Import Namespace="System.Text"%>
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using <%= Project%>CD.<%= Folder%>;

namespace <%= Project%>DA.<%= Folder%>
{
	/// <summary>
	///<%= Summary%>
	/// </summary>
	public partial class <%= GetTableName()%>DA:Base.BaseDA
	{
		public <%= GetTableName()%>DA()
		{
		}
		public <%= GetTableName()%>CD Get(<%=GetPrimaryKeys(SourceTable.Columns)%>)
		{
			<%= GetTableName()%>CD <%=MakeFirstLetterToLower(GetTableName())%>CD = new <%= GetTableName()%>CD();
			
			return <%=MakeFirstLetterToLower(GetTableName())%>CD;
		}
		public void Insert(<%= GetTableName()%>CD <%=MakeFirstLetterToLower(GetTableName())%>CD)
		{
			//this.DAUtility.InsertTableData((Rison.CD.CDBase)addressCD);
		}
		public void Update()
		{
			
		}
		public void Delete(<%= GetTableName()%>CD <%=MakeFirstLetterToLower(GetTableName())%>CD)
		{
			
		}
		public <%= GetTableName()%>CD GetAll()
		{
			<%= GetTableName()%>CD <%=MakeFirstLetterToLower(GetTableName())%>CD = new <%= GetTableName()%>CD();
				
			return <%=MakeFirstLetterToLower(GetTableName())%>CD;
		}
	}
}

<script runat="template">
//得到表名
private string GetTableName()
{
	return SourceTable.Name.Substring(1);	
}
//得到主键列
private string GetPrimaryKeys(SchemaExplorer.ColumnSchemaCollection columnSchemaCollection)
{
	StringBuilder stringBuilder = new StringBuilder();
	int i = 0;
	foreach(ColumnSchema columnSchema in columnSchemaCollection)
	{
		if(columnSchema.IsPrimaryKeyMember)
			stringBuilder.Append(columnSchema.DataType +" "+columnSchema.Name + ",");
		
	}
	string str = stringBuilder.ToString();
	return str.Substring(0,str.Length - 1);
}
//使首字母小写
private string MakeFirstLetterToLower(string str)
{
	StringBuilder stringBuilder = new StringBuilder(); 
	for(int i=0;i<str.Length;i++)
	{
		if(i == 0)
		{
			stringBuilder.Append(str[i].ToString().ToLower());
		}else
		stringBuilder.Append(str[i].ToString());
	}
	return stringBuilder.ToString();
}
</script>