/// <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)); }