/// <summary>
/// 查询是否存在列
/// </summary>
public bool Exists(string column_name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from " + databaseprefix + "article_attribute_field");
strSql.Append(" where name=@name ");
OleDbParameter[] parameters =
{
new OleDbParameter("@name", OleDbType.VarChar, 100)
};
parameters[0].Value = column_name;
if (DbHelperOleDb.Exists(strSql.ToString(), parameters) || DbHelperOleDb.ExitColumnName(databaseprefix + "article", column_name))
{
return(true);
}
return(false);
}
public bool Exists(string column_name)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select count(1) from " + this.databaseprefix + nameof(article_attribute_field));
stringBuilder.Append(" where name=@name ");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@name", OleDbType.VarChar, 100)
};
oleDbParameterArray[0].Value = (object)column_name;
return(DbHelperOleDb.Exists(stringBuilder.ToString(), oleDbParameterArray) || DbHelperOleDb.ExitColumnName(this.databaseprefix + "article", column_name));
}
