public static bool GuidExists(SNDK.DBI.Connection DbConnection, string TableName, Guid Guid) { bool result = false; QueryBuilder qb = new QueryBuilder(QueryBuilderType.Select); qb.Table(TableName); qb.Columns("id"); qb.AddWhere("id", "=", Guid); Query query = DbConnection.Query(qb.QueryString); if (query.Success) { if (query.NextRow()) { result = true; } } query.Dispose(); query = null; qb = null; return(result); }
public static SNDK.DBI.Query GetCount(SNDK.DBI.Connection DBConnection, string TableName, string Where, params string[] OrderByColumns) { string querystring = string.Empty; querystring += "SELECT "; if (OrderByColumns.GetLength(0) >= 0) { foreach (string column in OrderByColumns) { querystring += column + ","; } } querystring += "COUNT(*) as rowcount FROM " + TableName + " "; if (Where != string.Empty) { querystring += "WHERE " + Where + " "; } if (OrderByColumns.GetLength(0) >= 0) { querystring += "ORDER BY "; foreach (string column in OrderByColumns) { querystring += column + ","; } querystring = querystring.TrimEnd(",".ToCharArray()); } return(DBConnection.Query(querystring)); }
public static int GetCount(SNDK.DBI.Connection DBConnection, string TableName, string Where) { int result = 0; string querystring = string.Empty; querystring += "SELECT "; querystring += "COUNT(*) as rowcount FROM " + TableName + " "; if (Where != string.Empty) { querystring += "WHERE " + Where + " "; } Query query = DBConnection.Query(querystring); if (query.Success) { if (query.NextRow()) { result = query.GetInt(0); } } query.Dispose(); query = null; querystring = null; return(result); }