BLL层 <%@ CodeTemplate Language=C# TargetLanguage=Text Src= Inherits= Debug=False Description=Template description here %> <%@ Assembly Name=SchemaExplorer %> <%@ Assembly Name=SystemData %> <%@ Property Name=TargetTable Type=SchemaExplorerTableSchema Category=Context Description=TargetTable that the object is based on %> <%@ Property Name=Author Type=SystemString Default=Xiao ChangJian Category=Context Description=The author for this procedure %> <%@ Property Name=NameSpace Type=SystemString Default=MySpace Category=Context Description=TargetTable that the object is based on %> <%@ Property Name=Description Type=SystemString Default= Category=Context Description=The description for this procedure%> <%@ Map Name=CSharpAlias Src=SystemCSharpAlias Description=System to C# Type Map %> <%@ Import Namespace=SchemaExplorer %> <%@ Import Namespace=SystemData %> /* * File Name: <%= GetTableName(TargetTable) %>Bllcs * * Create Author: <%= Author %> * * Create DateTime: <%=DateTimeNowToShortDateString() %> * * Description: <%= Description %> **/ using System; using SystemCollections; using SystemCollectionsGeneric; using SystemText; namespace <%= NameSpace %> { public class <%= GetTableName(TargetTable) %>Bll { private static readonly <%= GetTableName(TargetTable) %>Bll _classinstance = new <%= GetTableName(TargetTable) %>Bll(); public static <%= GetTableName(TargetTable) %>Bll ClassInstance {get{return _classinstance; }} /// <summary> /// Add Record /// </summary> public int Insert_<%= GetTableName(TargetTable) %>(<%= GetTableName(TargetTable) %>Model instance) { return <%= GetTableName(TargetTable) %>DalClassInstanceInsert_<%= GetTableName(TargetTable) %>(instance); } /// <summary> /// Delete Record /// </summary> public int Delete_<%= GetTableName(TargetTable) %>(String pkid) { return <%= GetTableName(TargetTable) %>DalClassInstanceDelete_<%= GetTableName(TargetTable) %>(pkid); } /// <summary> /// Update Record /// </summary> public int Update_<%= GetTableName(TargetTable) %>(<%= GetTableName(TargetTable) %>Model instance) { return <%= GetTableName(TargetTable) %>DalClassInstanceUpdate_<%= GetTableName(TargetTable) %>(instance); } /// <summary> /// Get Record By Primary Key /// </summary> public <%= GetTableName(TargetTable) %>Model Get_<%= GetTableName(TargetTable) %>ByPKID(String pkid) { return <%= GetTableName(TargetTable) %>DalClassInstanceGet_<%= GetTableName(TargetTable) %>ByPKID(pkid); } /// <summary> /// Get Total Record Number /// </summary> public Int Get_<%= GetTableName(TargetTable) %>Count(String tablename String swhere) { return <%= GetTableName(TargetTable) %>DalClassInstanceGet_<%= GetTableName(TargetTable) %>Count(tablenameswhere); } /// <summary> /// Get Record With Split Page /// </summary> public List<<%= GetTableName(TargetTable) %>Model> Get_<%= GetTableName(TargetTable) %>ByWhere ( String tablename String column String swhere String sorder String ordertype Int pagecurrent Int pagecount ) { return <%= GetTableName(TargetTable) %>DalClassInstanceGet_<%= GetTableName(TargetTable) %>ByWhere(tablenamecolumnswheresorderordertypepagecurrentpagecount); } } } <script runat=template> //Get tablename public string GetTableName(TableSchema table) { if(table==null) { return null; } return tableName ; } </script> |