SqlBusiness.cst 商务层生成
1
<%--
2
Name:
3
Author:
4
Description:
5
--%>
6
<%@ CodeTemplate Language="C#" ResponseEncoding="UTF-8" TargetLanguage="Text" Src="Helper.cs" Inherits="Helper" Debug="False" Description="Template description here." %>
7![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
<%@ Assembly Name="System.Data" %>
9
<%@ Assembly Name="SchemaExplorer" %>
10
<%@ Assembly Name="CodeSmith.BaseTemplates" %>
11
<%@ Import Namespace="System.Data" %>
12
<%@ Import Namespace="SchemaExplorer" %>
13
<%@ Import Namespace="CodeSmith.BaseTemplates" %>
14![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
<%@ Property Name="DataBase" Type="SchemaExplorer.DatabaseSchema" Category="1.数据库对象" Description="当前生成的数据库对象" %>
16
<%@ Property Name="NameSpace" Type="System.String" Default="" Optional="false" Category="" Description="当前生成命名空间" %>
17
<%@ Property Name="ModuleName" Type="System.String" Default="" Optional="false" Category="" Description="项目名称" %>
18![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
using System;
20
using System.Collections.Generic;
21
using System.Text;
22
using rs.ABC.Framework;
23![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
namespace <%=NameSpace%>.Business
25
{
26
public static class <%= ModuleName%>Manage
27
{
28
<%
29
foreach(TableSchema Table in DataBase.Tables)
30
{
31
%>
32
public static <%
33
if(!IsMorePrimary(Table))
34
{%><%= GetCSharpVariableType(Table.PrimaryKey.MemberColumns[0])%> <%
35
36
}
37
else
38
{%>void <%
39
}
40
%> Create<%= GetClassName(Table)%>(<%= GetClassName(Table)%> <%= GetparameteryName(Table)%>)
41
{
42
<%
43
if(!IsMorePrimary(Table))
44
{%> return <%= ModuleName%>Provider.Instance.Create<%= GetClassName(Table)%>(<%= GetparameteryName(Table)%>); <%
45
46
}
47
else
48
{%><%= ModuleName%>Provider.Instance.Create<%= GetClassName(Table)%>(<%= GetparameteryName(Table)%>);<%
49
}
50
%>
51
52
}
53![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
54
public static void UpDate<%= GetClassName(Table)%>(<%= GetClassName(Table)%> <%= GetparameteryName(Table)%>)
55
{
56
<%= ModuleName%>Provider.Instance.Update<%= GetClassName(Table)%>(<%= GetparameteryName(Table)%>);
57
}
58![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
59
public static void Delete<%= GetClassName(Table)%>(<%
60
foreach(ColumnSchema column in Table.PrimaryKey.MemberColumns)
61
{
62
%><%= GetCSharpVariableType(column)%> <%=GetFiledName(column)%><%= GetComma(column,Table.PrimaryKey.MemberColumns)%><%}%>)
63
{
64
<%= ModuleName%>Provider.Instance.Delete<%= GetClassName(Table)%>(<%
65
foreach(ColumnSchema column in Table.PrimaryKey.MemberColumns)
66
{
67
%><%=GetFiledName(column)%><%= GetComma(column,Table.PrimaryKey.MemberColumns)%><%}%>);
68
}
69![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
70
public static <%= GetClassName(Table)%> Get<%= GetClassName(Table)%>(<%
71
foreach(ColumnSchema column in Table.PrimaryKey.MemberColumns)
72
{
73
%><%= GetCSharpVariableType(column)%> <%=GetFiledName(column)%><%= GetComma(column,Table.PrimaryKey.MemberColumns)%><%}%>)
74
{
75
return <%= ModuleName%>Provider.Instance.Get<%= GetClassName(Table)%>(<%
76
foreach(ColumnSchema column in Table.PrimaryKey.MemberColumns)
77
{
78
%><%=GetFiledName(column)%><%= GetComma(column,Table.PrimaryKey.MemberColumns)%><%}%>);
79
}
80
<%}%>
81![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
83
}
84
}
85![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
86![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
87
<script runat="template">
88![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
89
</script>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
68
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
69
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
70
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
76
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
77
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
78
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)