CommonUtility.cst
1
<%@ CodeTemplate Language="C#" TargetLanguage="C#" Src="" Description="" %>
2
<%@ Assembly Name="SchemaExplorer" %>
3
<%@ Assembly Name="System.Data" %>
4
<%@ Import Namespace="SchemaExplorer" %>
5
<%@ Import Namespace="System.Data" %>
6
<%@ Property Name="TableCollection" Type="SchemaExplorer.TableSchemaCollection" Category="Context" Description="Tables wicth used to generate utility"%>
7
<%@ Assembly Src="CommonUtility.cs" %>
8
<%@ Property Name="NameSpace" Type="System.String" Category="" Description="" %>
9
<%@ Property Name="ClassName" Type="System.String" Description="" %>
10
<%@ Property Name="AutherName" Type="System.String" Default="Slash" Description="" %>
11
<%@ Import Namespace="Common.Data" %>
12
<script runat="template">
13
CommonUtility rule=new CommonUtility();
14
</script>
15
/////////////////////////////
16
//File:<%= ClassName %>.cs
17
//Data Created:<%= DateTime.Now.ToLongDateString() %>
18
//Created by:<%= AutherName %>
19
/////////////////////////////
20
namespace <%= NameSpace %>
21
{
22
using System;
23
using System.Data;
24
using System.Runtime.Serialization;
25
26
/// <summary>
27
/// A custom serializable dataset containing order information.
28
/// <remarks>
29
/// This class is used to define the shape of OrderData.
30
/// </remarks>
31
/// <remarks>
32
/// The serializale constructor allows objects of type OrderData to be remoted.
33
/// </remarks>
34
/// </summary>
35
[System.ComponentModel.DesignerCategoryAttribute("Code")]
36
[SerializableAttribute]
37
public class <%= ClassName %> : DataSet
38
{
39
40
<%for(int k=0;k<TableCollection.Count;k++) %>
41
<%{%>
42
43
//
44
//<%=rule.GetCamelCaseName(TableCollection[k].Name) %> items table constants
45
//
46
///<value>The constant used for <%= rule.GetCamelCaseName(TableCollection[k].Name) %> table.</value>
47
<%= rule.GetTableConstantDeclarationStatement(TableCollection[k]) %>;
48
<%for(int i=0;i<TableCollection[k].Columns.Count;i++) %>
49
<%{ %>
50
///<value>The constant used for <%= TableCollection[k].Columns[i].Name %> field in the <%= rule.GetCamelCaseName(TableCollection[k].Name) %> table.</value>
51
<%= rule.GetMemberConstantDeclarationStatement(TableCollection[k].Columns[i])%>;
52
<%} %>
53
<%} %>
54
55
/// <summary>
56
/// Constructor to support serialization.
57
/// <remarks>Constructor that supports serialization.</remarks>
58
/// <param name="info">The SerializationInfo object to read from.</param>
59
/// <param name="context">Information on who is calling this method.</param>
60
/// </summary>
61
private <%= ClassName %>(SerializationInfo info,StreamingContext context):base(info,context)
62
{
63
}
64
65
/// <summary>
66
/// Constructor for <%= ClassName %>.
67
/// <remarks>Initialize a <%= ClassName %>instance by building the table schema.</remarks>
68
/// </summary>
69
public <%= ClassName %>
70
{
71
//
72
//Create the tables in the dataset
73
//
74
BuildDataTables();
75
}
76
77
///----------------------------------------------------------------
78
/// Sub BuildDataTables:
79
/// Creates the following datatables: OrderItems, OrderSummary,
80
/// Customer, ShippingAddress, Payment, Order
81
///----------------------------------------------------------------
82
private void BuildDataTables()
83
{
84
///
85
///create the <%= TableCollection[0].Name %> items table.
86
///
87
DataTable table=new DataTable(<%= rule.GetCamelCaseName(TableCollection[0].Name)%>);
88
DataColumnCollection columns=table.Columns;
89
90
<% for(int i=0;i<TableCollection.Count;i++)%>
91
<% {%>
92
<% for(int m=0;m<TableCollection[i].Columns.Count;m++)%>
93
<%{ %>
94
columns.Add(<%= rule.GetCamelCaseName(TableCollection[i].Columns[m].Name)%>,typeof(<%= rule.GetCSharpBaseType(TableCollection[i].Columns[m])%>));
95
<% }%>
96
<%} %>
97
this.Tables.Add(table);
98
}
99
100
}
101
}
102![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
103![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](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/ExpandedBlockStart.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/ExpandedBlockStart.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.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/InBlock.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/ExpandedSubBlockEnd.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.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/InBlock.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/InBlock.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.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/ExpandedSubBlockEnd.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/InBlock.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/ExpandedSubBlockEnd.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.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/ExpandedSubBlockStart.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.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/InBlock.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
90
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
91
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
92
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
93
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
94
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
95
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
96
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
97
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
98
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
99
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
100
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
101
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
102
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
103
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)