internal OrionUpdateQuery(OrionDatabase parentOrionDatabase, String tableName, String whereClause, params String[] fieldNames) : base(parentOrionDatabase) { StringBuilder strQueryString, strSet; strQueryString = new StringBuilder("UPDATE " + tableName); strSet = new StringBuilder(" SET "); foreach (String strFieldNameTemp in fieldNames) { strSet.Append(strFieldNameTemp + "="); strSet.Append(this.ParentOrionDatabase.ParameterCharacter + strFieldNameTemp + ","); } strQueryString.Append(strSet.ToString().Trim(',')); if (String.IsNullOrWhiteSpace(whereClause) == false) { whereClause = OrionQuery.TrimWhereClause(whereClause); strQueryString.Append(" WHERE " + whereClause); } this.QueryString = strQueryString.ToString(); this.QueryType = QueryTypes.Update; this.m_xCommand = this.ParentOrionDatabase.CreateCommand(this.QueryString); foreach (String strFieldNameTemp in fieldNames) { this.AddParameter(strFieldNameTemp, null); } }// OrionUpdateQuery()
internal OrionDeleteQuery(OrionDatabase parentXDatabase, String tableName, String whereClause) : base(parentXDatabase) { StringBuilder strQueryString; strQueryString = new StringBuilder("DELETE FROM " + tableName); if (String.IsNullOrWhiteSpace(whereClause) == false) { whereClause = OrionQuery.TrimWhereClause(whereClause); strQueryString.Append(" WHERE " + whereClause); } this.QueryString = strQueryString.ToString(); this.QueryType = QueryTypes.Delete; this.m_xCommand = this.ParentOrionDatabase.CreateCommand(this.QueryString); }// OrionDeleteQuery()
internal OrionRowCountQuery(OrionDatabase parentXDatabase, String tableName, String whereClause = null) : base(parentXDatabase) { StringBuilder strQueryString; this.QueryType = QueryTypes.RowCount; strQueryString = new StringBuilder("SELECT COUNT(*) FROM " + tableName); if (String.IsNullOrWhiteSpace(whereClause) == false) { whereClause = OrionQuery.TrimWhereClause(whereClause); strQueryString.Append(" WHERE " + whereClause); } this.QueryString = strQueryString.ToString(); if (this.xDataAdapter == null) { this.xDataAdapter = this.ParentOrionDatabase.CreateDataAdapter(this.QueryString); } this.xDataAdapter.MissingMappingAction = MissingMappingAction.Passthrough; this.xDataAdapter.SelectCommand.Transaction = this.ParentOrionDatabase.Transaction; }// OrionRowCountQuery