Разработка базы данных поликлиники
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
d(joinCondition);. Append(filterPart);
}Query (IFilterPart filterPart)
: this()
{. Append(filterPart);
}
#region Preferred ConstructorsQuery (string schemaColumn, object Value)
: this()
{(schemaColumn, Value);
}Query (string schemaColumn, SQLComparisonOperator Operator, object Value)
: this()
{(schemaColumn, Operator, Value);
}
#endregion
#endregion
#region AddToFilter
#region Merging two Query objects togethervoid AddToFilter (SQLInFilter inFilter, JoinCondition Condition)
{(Condition);. Append (Condition, inFilter);
}void AddToFilter (Query SQLFilter)
{(SQLFilter, DefaultJoinCondition);
}bool IsDBOnlyQuery; // temp till readonly factorybool IsNoResultQuery;void AddToFilter (Query SQLFilter, JoinCondition Condition)
{(SQLFilter!= null)
{
// the filter always becomes empty when Ord with ZNoResultQuery(SQLFilter. IsNoResultQuery)
{(Condition == JoinCondition. And)
{= true;. Reset();
}if (Condition!= JoinCondition. Or)
{new NotSupportedException (Unknown join condition detected - this condition must be coded for);
}
}
{(SQLFilter);(Condition);. Append (Condition, SQLFilter);
}(SQLFilter. ReLoadExistingRows) ReLoadExistingRows = true;(SQLFilter. FetchOnlyFromLocalCache) FetchOnlyFromLocalCache = true;(SQLFilter. IsNoLock) IsNoLock = true;(SQLFilter. IsDBOnlyQuery) IsDBOnlyQuery = true;(SQLFilter. IgnoreActiveFilter) IgnoreActiveFilter = true;(! string. IsNullOrEmpty (SQLFilter. OrderBy))
{(string. IsNullOrEmpty(OrderBy))
{= SQLFilter. OrderBy;
}
{+=, + SQLFilter. OrderBy;
}
}
}
}BracketIfRequired (JoinCondition JoinOperator)
{(! FilterParts. FilterIsEmpty)
{(JoinOperator == JoinCondition. And && FilterParts. ContainsNonBracketedOr)
{. Bracket();
}
}
}
#endregionvoid AddFilterAndSQLParameterCollection (String Filter, ZSqlParameterCollection ParameterCollection)
{(Filter, ParameterCollection, JoinCondition. And);
}void AddFilterAndSQLParameterCollection (String Filter, ZSqlParameterCollection ParameterCollection, JoinCondition joinCondition)
{(ParameterCollection == null)
{= new ZSqlParameterCollection();
}(Filter. Contains (ParameterNameFactory. ParameterPrefix))
{new Exception (The filter contains an autogenerated parameter - this is incorrect and will make the filter fail when applied.\r\n\r\n + Filter + \r\n\r\n);
}(JoinCondition. And);. Append (joinCondition, new NonPersistentDataQuery (Filter, ParameterCollection));
}
#region Column Name / Value pairvoid AddToFilter (string schemaColumn, object Value)
{(DefaultJoinCondition, schemaColumn, SQLComparisonOperator. Equal, Value);
}void AddToFilter (string schemaColumn, SQLComparisonOperator ComparisonOperator, object Value)
{(DefaultJoinCondition, schemaColumn, ComparisonOperator, Value);
}void AddToFilter (JoinCondition JoinOperator, string schemaColumn, object Value)
{(JoinOperator, schemaColumn, SQLComparisonOperator. Equal, Value);
}
///
/// Ultimate calling path for ALL AddToFilter methods.
/// void AddToFilter (JoinCondition JoinOperator, string schemaColumn, SQLComparisonOperator ComparisonOperator, object Value)
{(JoinOperator);(Value, schemaColumn, ComparisonOperator, JoinOperator);
}
#endregion
#region Column Name / Column Name pair
//public void AddToFilter (string schemaColumn, SQLComparisonOperator comparisonOperator, string withSchemaColumn)
// {
// if (withSchemaColumn == null)
// {
// AddToFilter (DefaultJoinCondition, schemaColumn, comparisonOperator, null);
// }
// else
// {
// SQLColumnComparer filter = new SQLColumnComparer (schemaColumn, comparisonOperator, withSchemaColumn);
// BracketIfRequired(DefaultJoinCondition);
// FilterParts. Append (DefaultJoinCondition, filter);
// }
// }
#endregion
#endregion
#region FilterByForeignKeyvoid FilterByForeignKey (string schemaColumn, BusinessObject[] businessObjects)
{(businessObjects!= null && businessObjects. Length > 0)
{[] guids = new Guid [businessObjects. Length];(int i = 0; i < businessObjects. Length; i++)
{[i] = businessObjects[i].PK;
}(schemaColumn, guids);
}
{ // Invalidates query, youre filtering by nothing= true;
}
}
#endregionint? MaximumSecondsBeforeFlaggingSlowSQLQuery;
///
/// The default join condition; used when adding to the filter without stating a join condition.
/// JoinCondition DefaultJoinCondition
{{return defaultJoinCondition;}
{();= value;
}
}defaultJoinCondition;
///
/// Indicates to refresh existing data from permanent storage where applicable
/// bool ReLoadExistingRows
{{return reLoadExistingRows;}
{();= value;
}
}reLoadExistingRows;
///
/// Indicates to never hit the DB to get results - only fetch from local cache
/// bool FetchOnlyFromLocalCache
{{return fetchOnlyFromLocalCache;}
{();= value;
}
}fetchOnlyFromLocalCache;
///
/// Set the maximum number of rows to return - Leave as default value for all available rows
/// int? MaximumRows
{{return maximumRows;}
{();= value;
}
}? maximumRows;
///
/// Indicates if NOLOCK hints (Isolation Level Read Uncommitted) will be used for the query - Default is set in Registry
/// bool IsNoLock
{{return isNoLock;}
{();= value;
}
}isNoLock;
///
/// Ignores the ActiveFilter for the business object when retrieving.
/// bool IgnoreActiveFilter;
///
/// Indicates the sort order used to retrieve rows. May be suffixed with ascending/descending as per SQL syntax
/// String OrderBy;bool IsPrimaryKeyQuery
{
{sqlParam = GetFirstSingleEqualParameter();sqlParam!= null
&& sqlParam. SchemaColumn. EndsWith (_PK)
&& sqlParam. ComparisonOperator == SQLComparisonOperator. Equal;
}
}
///
/// Returns the Equals parameter from a filter when it is the only parameter
/// Returns null in all other cases
///
/// virtual ZSqlParameter GetFirstSingleEqualParameter()
{FilterParts. GetFirstSingleEqualParameter();
}void CheckModificationStatus()
{(! ModificationsEnabled)
{new Exception (Modifications have been disabled on this filter. No further changes should be made. Check the origin of this object (AdditionalFilter / RelationshipFilter etc));
}
}bool IsTableUsedInQuery (string TableName)
{TableList. Contains(TableName);
}void AddUsedTables (Query Query)
{DBQuery = Query as DBOnlyQuery;(DBQuery!= null)
{(DBQuery. TableName);
}(string TableName in Query. TableList)
{(TableName);
}
}void AddUsedTable (string TableName)
{(! TableList. Contains(TableName))
{. Add(TableName);
}
}
Приложение 2
Контрольный пример реализации программы
Экранная форма запуска