数据逻辑类生成模板

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Description="" %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Assembly Name="CodeSmith.CustomProperties"%>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema" Category="Context" Description="" %>
<%@ Property Name="NameSpace" Type="String" Category="Context" Description="" %>
<%@ Property Name="IsListAll" Type="System.Boolean" Category="Context" Description="" %>

if (column.Size > 0&&column.NativeType.ToString().ToLower()!="ntext"&&column.NativeType.ToString().ToLower()!="text")
{
re+=","+column.Size;
}
//re=column.NativeType.ToLower();
return re;
}
public string GetModifyColName(ColumnSchema column)
{
if(((bool)column.ExtendedProperties["CS_IsIdentity"].Value)!=true&&column.Name.EndsWith("Id"))
{
return column.Name.Substring(0,column.Name.Length-2)+"."+column.Name;
}
else
{
return column.Name;
}
}
</script>

using System;
using SystemFramework;
using Business;
using System.Data;
using System.Data.SqlClient;

// Description: Enter summary here after generation.
// ---------------------
// Copyright . <%= DateTime.Now.Year %> Our Client
// ---------------------
// History
// <%= DateTime.Now.ToString() %>

namespace <%=NameSpace %>
{
public sealed class <%= SourceTable.Name %>Provider
{
public static <%= SourceTable.Name %>Collection List<%= SourceTable.Name %>(<%if(!IsListAll){%>int PageNum,int PageSize<%}%>)
{
  <%= SourceTable.Name %>Collection <%= SourceTable.Name %>s=new <%= SourceTable.Name %>Collection();
  using(SqlConnection conn=MSSQLProvider.GetConnection())
  {
   using(SqlCommand cmd=new SqlCommand("List<%= SourceTable.Name %>",conn))
   {
    conn.Open();
    cmd.CommandType=CommandType.StoredProcedure;

    <%if(!IsListAll){%>
    SqlParameter pa;
    pa=cmd.Parameters.Add("@PageNum",SqlDbType.Int);
    pa.Value=PageNum;
    pa=cmd.Parameters.Add("@PageSize",SqlDbType.Int);
    pa.Value=PageSize;
    <%}%>
    SqlDataReader dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);

    <%= SourceTable.Name %> obj;
    while(dr.Read())
    {
     obj=new <%= SourceTable.Name %>();
     //TODO:insert your code for read list columns
     <%= SourceTable.Name %>s.Add(obj);
    }

    dr.Close();
   }
  }
  return <%= SourceTable.Name %>s;
}

public static <%= SourceTable.Name %> Get<%= SourceTable.Name %>(<%=GetType(SourceTable.PrimaryKey.MemberColumns[0])%> id)
{
  <%= SourceTable.Name %> obj=null;
  using(SqlConnection conn=MSSQLProvider.GetConnection())
  {
   using(SqlCommand cmd=new SqlCommand("Get<%= SourceTable.Name %>",conn))
   {
    conn.Open();
    cmd.CommandType=CommandType.StoredProcedure;
    SqlParameter pa;
    pa=cmd.Parameters.Add("@id",SqlDbType.<%=GetDbType(SourceTable.PrimaryKey.MemberColumns[0])%>);
    pa.Value=id;
    SqlDataReader dr=cmd.ExecuteReader(CommandBehavior.CloseConnection);

    if(dr.Read())
    {
     obj=new <%= SourceTable.Name %>();
     obj.<%= SourceTable.Name %>Id=id;
     <% for (int i = 0; i < SourceTable.NonPrimaryKeyColumns.Count; i++) { %>
     <%if(SourceTable.NonPrimaryKeyColumns[i].Name.EndsWith("Id")){%>
     obj.<%=SourceTable.NonPrimaryKeyColumns[i].Name.Substring(0,SourceTable.NonPrimaryKeyColumns[i].Name.Length-2)%>=new <%=SourceTable.NonPrimaryKeyColumns[i].Name.Substring(0,SourceTable.NonPrimaryKeyColumns[i].Name.Length-2)%>();
     obj.<%=SourceTable.NonPrimaryKeyColumns[i].Name.Substring(0,SourceTable.NonPrimaryKeyColumns[i].Name.Length-2)%>.<%= SourceTable.NonPrimaryKeyColumns[i].Name %>=<%=GetConvertType(SourceTable.NonPrimaryKeyColumns[i])%>(dr["<%= SourceTable.NonPrimaryKeyColumns[i].Name %>"]);
     <%}else{%>
     obj.<%= SourceTable.NonPrimaryKeyColumns[i].Name %>=<%=GetConvertType(SourceTable.NonPrimaryKeyColumns[i])%>(dr["<%= SourceTable.NonPrimaryKeyColumns[i].Name %>"]);
     <%}%>
     <% } %>
    }

    dr.Close();
   }
  }
  return obj;
}

public static <%=GetType(SourceTable.PrimaryKey.MemberColumns[0])%> Insert<%= SourceTable.Name %>(<%= SourceTable.Name %> obj)
{
  <%=GetType(SourceTable.PrimaryKey.MemberColumns[0])%> re;
  using(SqlConnection conn=MSSQLProvider.GetConnection())
  {
   using(SqlCommand cmd=new SqlCommand("Insert<%= SourceTable.Name %>",conn))
   {
    conn.Open();
    cmd.CommandType=CommandType.StoredProcedure;
    SqlParameter pa;
    <% for (int i = 0; i < SourceTable.NonPrimaryKeyColumns.Count; i++) { %>
    pa=cmd.Parameters.Add("@<%= SourceTable.NonPrimaryKeyColumns[i].Name %>",SqlDbType.<%=GetAllDbType(SourceTable.NonPrimaryKeyColumns[i])%>);
    pa.Value=obj.<%= GetModifyColName(SourceTable.NonPrimaryKeyColumns[i])%>;
    <% } %>

    try
    {
     re=<%=GetType(SourceTable.PrimaryKey.MemberColumns[0])%>.Parse(cmd.ExecuteScalar().ToString());
    }
    catch(Exception ex)
    {
     conn.Close();
     throw ex;
    }
    conn.Close();
   }
  }
  return re;
}

public static void Update<%= SourceTable.Name %>(<%= SourceTable.Name %> obj)
{
  using(SqlConnection conn=MSSQLProvider.GetConnection())
  {
   using(SqlCommand cmd=new SqlCommand("Update<%= SourceTable.Name %>",conn))
   {
    conn.Open();
    cmd.CommandType=CommandType.StoredProcedure;
    SqlParameter pa;
    pa=cmd.Parameters.Add("@id",SqlDbType.<%=GetDbType(SourceTable.PrimaryKey.MemberColumns[0])%>);
    pa.Value=obj.<%= SourceTable.Name %>Id;
    <% for (int i = 0; i < SourceTable.NonPrimaryKeyColumns.Count; i++) { %>
    pa=cmd.Parameters.Add("@<%= SourceTable.NonPrimaryKeyColumns[i].Name %>",SqlDbType.<%=GetAllDbType(SourceTable.NonPrimaryKeyColumns[i])%>);
    pa.Value=obj.<%= GetModifyColName(SourceTable.NonPrimaryKeyColumns[i])%>;
    <% } %>

    try
    {
     cmd.ExecuteNonQuery();
    }
    catch(Exception ex)
    {
     conn.Close();
     throw ex;
    }
    conn.Close();
   }
  }
}

public static void Del<%= SourceTable.Name %>(<%=GetType(SourceTable.PrimaryKey.MemberColumns[0])%> id)
{
  using(SqlConnection conn=MSSQLProvider.GetConnection())
  {
   using(SqlCommand cmd=new SqlCommand("Del<%= SourceTable.Name %>",conn))
   {
    conn.Open();
    cmd.CommandType=CommandType.StoredProcedure;
    SqlParameter pa;
    pa=cmd.Parameters.Add("@id",SqlDbType.<%=GetDbType(SourceTable.PrimaryKey.MemberColumns[0])%>);
    pa.Value=id;

    try
    {
     cmd.ExecuteNonQuery();
    }
    catch(Exception ex)
    {
     conn.Close();
     throw ex;
    }
    conn.Close();
   }
  }
}
}
}

发表于 2006-11-16 11:21 erik168 阅读(168) 评论(0) 收藏举报

刷新页面返回顶部

数据逻辑类生成模板

公告

导航