BLL <%-- Name:BLL Author: XuYabao Description: CREATE BLL --%> <%@ CodeTemplate Language="C#" TargetLanguage="C#" ResponseEncoding="UTF-8" Src="" Inherits="" Debug="False" Description="Template description here." %> <%@ Assembly Name="System.Data" %> <%@ Import Namespace="System.Data" %> <%@ Assembly Name="SchemaExplorer" %> <%@ Import Namespace="SchemaExplorer" %> <%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="Table that the stored procedures should be based on." %> <%@ Property Name="Namespace" Type="String" Default="XUBLL" Category="Context" Description="Namespace." %> <%@ Property Name="DAL" Type="String" Default="XUDAL" Category="Context" Description="Namespace." %> <%@ Property Name="Model" Type="String" Default="XUModel" Category="Context" Description="Namespace." %> <%@ Property Name="Author" Type="String" Default="徐亚豹" Category="Context" Description="Author." %> <%@ Property Name="Description" Type="String" T Default="" Category="Context" Description="Description." Optional="true" %> <mce:script runat="template"><!-- public string GetDataType(ColumnSchema column) { string param = ""; switch (column.DataType) { case DbType.Int32: param += "int"; break; case DbType.Int64: param += "int"; break; case DbType.Double: param += "double"; break; case DbType.DateTime: param += "DateTime"; break; case DbType.Decimal: { param += "decimal"; break; } default: { param += "string"; break; } } return param; } // --></mce:script> using System; using System.Collections.Generic; using System.Text; using System.Data; namespace <%= Namespace %> { /// <summary> /// 描述: <% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> public class <%= SourceTable.Name.Substring(2) %> { private <%= DAL %>.<%= SourceTable.Name.Substring(2) %> obj = new <%= DAL %>.<%= SourceTable.Name.Substring(2) %>(); #region <% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %>对象赋值 /// <summary> /// 描述: <% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %>对象赋值 /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> <% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++) { %> /// <param name="<%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2) %>"><%= SourceTable.PrimaryKey.MemberColumns[i].Description %></param> <% } %> /// <returns></returns> public <%= Model %>.<%= SourceTable.Name.Substring(2) %> <%= SourceTable.Name.Substring(2) %>ModelInit(<%= Model %>.<%= SourceTable.Name.Substring(2) %> mod, DataRow dr) { <% for (int i = 0; i < SourceTable.Columns.Count; i++) { %> <% if(SourceTable.Columns[i].DataType == DbType.String) {%> mod.<%= SourceTable.Columns[i].Name.Substring(2) %> = dr["<%= SourceTable.Columns[i].Name%>"].ToString(); <% } else { %> mod.<%= SourceTable.Columns[i].Name.Substring(2) %> = dr["<%= SourceTable.Columns[i].Name%>"] == DBNull.Value ? <% if(SourceTable.Columns[i].DataType == DbType.DateTime){%>DateTime.MinValue<%}else{ %>0<%}%> : Convert.To<%= SourceTable.Columns[i].DataType %>(dr["<%= SourceTable.Columns[i].Name%>"]); <% }} %> return mod; } #endregion #region 获取<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %>对象 /// <summary> /// 描述: 获取<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %>对象 /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> <% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++) { %> /// <param name="<%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2) %>"><%= SourceTable.PrimaryKey.MemberColumns[i].Description %></param> <% } %> /// <returns></returns> public <%= Model %>.<%= SourceTable.Name.Substring(2) %> <%= SourceTable.Name.Substring(2) %>ModelGet(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= GetDataType(SourceTable.PrimaryKey.MemberColumns[i]) + " " +SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>) { <%= Model %>.<%= SourceTable.Name.Substring(2) %> mod = new <%= Model %>.<%= SourceTable.Name.Substring(2) %>(); DataTable dt = obj.<%= SourceTable.Name.Substring(2) %>Get(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; <%= SourceTable.Name.Substring(2) %>ModelInit(mod, dr); } else { mod = null; } return mod; } #endregion #region 获取<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %>对象组 /// <summary> /// 描述: 获取<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %>对象组 /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> <% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++) { %> /// <param name="<%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2) %>"><%= SourceTable.PrimaryKey.MemberColumns[i].Description %></param> <% } %> /// <returns></returns> public List<<%= Model %>.<%= SourceTable.Name.Substring(2) %>> <%= SourceTable.Name.Substring(2) %>ModelsGet(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= GetDataType(SourceTable.PrimaryKey.MemberColumns[i]) + " " +SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>) { List<<%= Model %>.<%= SourceTable.Name.Substring(2) %>> lstMod = new List<<%= Model %>.<%= SourceTable.Name.Substring(2) %>>(); <%= Model %>.<%= SourceTable.Name.Substring(2) %> mod = new <%= Model %>.<%= SourceTable.Name.Substring(2) %>(); DataTable dt = obj.<%= SourceTable.Name.Substring(2) %>Get(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>); if (dt != null && dt.Rows.Count > 0) { DataRow dr; int n = dt.Rows.Count; for (int i = 0; i < n; i++) { mod = new <%= Model %>.<%= SourceTable.Name.Substring(2) %>(); dr = dt.Rows[i]; <%= SourceTable.Name.Substring(2) %>ModelInit(mod, dr); lstMod.Add(mod); mod = null; } } else { lstMod = null; } return lstMod; } #endregion #region 获取<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// <summary> /// 描述: 获取<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> <% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++) { %> /// <param name="<%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2) %>"><%= SourceTable.PrimaryKey.MemberColumns[i].Description %></param> <% } %> /// <returns></returns> public DataTable <%= SourceTable.Name.Substring(2) %>Get(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= GetDataType(SourceTable.PrimaryKey.MemberColumns[i]) + " " +SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>) { return obj.<%= SourceTable.Name.Substring(2) %>Get(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>); } #endregion #region 新增<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// <summary> /// 描述: 新增<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> /// <param name="mod">对象实例</param> /// <returns></returns> public int <%= SourceTable.Name.Substring(2) %>Add(<%= Model %>.<%= SourceTable.Name.Substring(2) %> mod) { return obj.<%= SourceTable.Name.Substring(2) %>Add(mod); } #endregion #region 修改<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// <summary> /// 描述: 修改<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> /// <param name="mod">对象实例</param> /// <returns></returns> public int <%= SourceTable.Name.Substring(2) %>Edit(<%= Model %>.<%= SourceTable.Name.Substring(2) %> mod) { return obj.<%= SourceTable.Name.Substring(2) %>Edit(mod); } #endregion #region 删除<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// <summary> /// 描述: 删除<% if (SourceTable.Description.Trim().Length == 0) { %><%= SourceTable.Name.Substring(2) %><% }else{%><%= SourceTable.Description %><% } %> /// 创建: <%= Author %> <%= DateTime.Now.ToString("yyyy-MM-dd") %> /// </summary> <% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++) { %> /// <param name="<%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2) %>"><%= SourceTable.PrimaryKey.MemberColumns[i].Description %></param> <% } %> /// <returns></returns> public int <%= SourceTable.Name.Substring(2) %>Del(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= GetDataType(SourceTable.PrimaryKey.MemberColumns[i]) + " " +SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>) { return obj.<%= SourceTable.Name.Substring(2) %>Del(<% for (int i = 0; i < SourceTable.PrimaryKey.MemberColumns.Count; i++){%><% if(i > 0){%>, <%}%><%= SourceTable.PrimaryKey.MemberColumns[i].Name.Substring(2)%><%}%>); } #endregion } }