📄 model.cst
字号:
<%@ CodeTemplate Language="C#" ClassName="Model" TargetLanguage="C#" Debug="False" Description="" %>
<%@ Property Name="databaseName" Type="System.String" Default="TestDB" Optional="True" Category="Context" Description="" %>
<%@ Property Name="nameSpace" Type="System.String" Default="MyNamespace" Optional="True" Category="Context" Description="" %>
<%
DbEntity db = Template.GetDataBase(databaseName);
foreach(Table tb in db.Tables)
{
OpenResponse("Model\\"+tb.PropertyName+".cs");
string pkParmList = "";
foreach(Field fd in tb.Fields)
{
if(fd.IsPK == true)
pkParmList += fd.DataType.DotNetType+" "+fd.MemberName+",";
}
pkParmList = pkParmList.Trim(',');
%>
using System;
using System.Data.SqlClient;
namespace <%=nameSpace%>.Model
{
/// <summary>
/// <%=tb.CnName%>
/// </summary>
public class <%=tb.PropertyName%>
{
/// <summary>
///
/// </summary>
public <%=tb.PropertyName%>()
{
}
/// <summary>
///
/// </summary>
public <%=tb.PropertyName%>(<%=pkParmList%>)
{
<%
foreach(Field fd in tb.Fields)
if(fd.IsPK == true)
Response.WriteLine("\t\t\tthis."+fd.MemberName+" = "+fd.MemberName+";");
%>
}
/// <summary>
///
/// </summary>
public <%=tb.PropertyName%>(SqlDataReader dr)
{
<%
foreach(Field fd in tb.Fields)
Response.WriteLine("\t\t\tthis."+fd.MemberName
+" = Convert."+fd.DataType.Convert+"(dr[\""+fd.MemberName+"\"]);");
%>
}
<%--Field--%>
<%
foreach(Field fd in tb.Fields)
{
%>
#region <%=fd.PropertyName%>
private <%=fd.DataType.DotNetType%> <%=fd.MemberName%>;
/// <summary>
/// <%=fd.CnName%>
<%
if( fd.Note != "" && fd.Note!= null)
Response.WriteLine("\t\t/// "+fd.Note);
if( fd.Identity.Enable == true)
Response.WriteLine("\t\t/// AutoInc");
if( fd.IsPK == true)
Response.WriteLine("\t\t/// PK");
%> /// </summary>
public <%=fd.DataType.DotNetType%> <%=fd.PropertyName%>
{
get{ return <%=fd.MemberName%>; }
set{ <%=fd.MemberName%>= value; }
}
#endregion
<%
}
%>
<%--Field End--%>
}
}
<%
CloseResponse();
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -