CodeSmith6.5 Exists

最新推荐文章于 2021-04-07 18:05:27 发布

aizhuao7642

最新推荐文章于 2021-04-07 18:05:27 发布

阅读量104

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/xinzheng/p/4488132.html

版权

<%@ CodeTemplate Language="C#" TargetLanguage="C#" Debug="False" Description="Template description here." %>
<%@ Property Name="SourceTable" Type="SchemaExplorer.TableSchema"  Category="数据库表"  Optional="True" Description="the table name"   %>
<%@ Assembly Name="SchemaExplorer" %>
<%@ Import Namespace="SchemaExplorer" %>
<%@ Assembly Name="CodeSmith.BaseTemplates" %>
<%@ Import Namespace="CodeSmith.BaseTemplates" %>
<%@ Assembly Name="CodeSmith.CustomProperties" %>
<%@ Import Namespace="CodeSmith.CustomProperties" %>
<%@ Property Name="ConnectionTypeName" Type="ConnectionType" Category="数据源连接类型" %>
<%@ Map Name="CSharpAlias" Src="System-CSharpAlias" %>

<script runat="template">
public enum ConnectionType
{
    SqlHelper,
    MySqlHelper,
    OleDbHelper
}
public string GetParameterTypeName()
{
    switch(ConnectionTypeName)
    {
        case ConnectionType.SqlHelper:return "SqlParameter";
        case ConnectionType.MySqlHelper:return "MySqlParameter";
        case ConnectionType.OleDbHelper:return "OleDbParameter";
        default:return "SqlParameter";
    }
}
</script>
public bool Exists(<%=CSharpAlias[this.SourceTable.Columns[0].SystemType.FullName] %> <%=this.SourceTable.Columns[0].Name %>)
{
    <%  string cols=string.Empty;
        foreach(ColumnSchema col in this.SourceTable.Columns)
        {
            cols+=col.Name+",";
        }
        cols=cols.Remove(cols.Length-1);
        string[] strParamNames=cols.Split(',');
    %>
    StringBuilder commandText=new StringBuilder();
    commandText.Append("select count(*) from <%=this.SourceTable.Name %>");
    commandText.Append(" where <%=strParamNames[0] %>=@<%=strParamNames[0] %>");
    <%=GetParameterTypeName() %>[] commandParameters = {
            new <%=GetParameterTypeName() %>("@<%=strParamNames[0] %>", <%=this.SourceTable.Columns[0].Name %>)    
            };

    return Convert.ToInt32(DBUtility.SqlHelper.ExecuteScalar(commandText.ToString(), commandParameters)) > 0;
}