/// <summary> /// NOTE: This is called by the dOOdad framework and you should never call it. We reserve the right to remove or change this method. /// </summary> /// <param name="wItem">The AggregateParameter</param> public void AddAggregateParameter(AggregateParameter wItem) { if (_aggregateParameters == null) { _aggregateParameters = new ArrayList(); } _aggregateParameters.Add(wItem); // We don't allow Save() to succeed once they reduce the columns this._entity._canSave = false; }
protected string GetAggregate(AggregateParameter wItem, bool withAlias) { string query = string.Empty; switch (wItem.Function) { case AggregateParameter.Func.Avg: query += "AVG("; break; case AggregateParameter.Func.Count: query += "COUNT("; break; case AggregateParameter.Func.Max: query += "MAX("; break; case AggregateParameter.Func.Min: query += "MIN("; break; case AggregateParameter.Func.Sum: query += "SUM("; break; case AggregateParameter.Func.StdDev: query += "STDDEV("; break; case AggregateParameter.Func.Var: query += "VAR("; break; } if (wItem.Distinct) { query += "DISTINCT "; } query += D(wItem.Column) + ")"; if (withAlias && wItem.Alias != string.Empty) { // Need DBMS string delimiter here query += " AS " + D(wItem.Alias); } return(query); }
protected string GetAggregate(AggregateParameter wItem, bool withAlias) { string query = string.Empty; switch (wItem.Function) { case AggregateParameter.Func.Avg: query += "Avg("; break; case AggregateParameter.Func.Count: query += "Count("; break; case AggregateParameter.Func.Max: query += "Max("; break; case AggregateParameter.Func.Min: query += "Min("; break; case AggregateParameter.Func.Sum: query += "Sum("; break; case AggregateParameter.Func.StdDev: query += "StDev("; break; case AggregateParameter.Func.Var: query += "Var("; break; } if (wItem.Distinct) { query += "DISTINCT "; } query += wItem.Column; if (withAlias && wItem.Alias != string.Empty) { query += " AS " + wItem.Alias; } return(query); }
protected string GetAggregate(AggregateParameter wItem, bool withAlias) { string query = string.Empty; switch(wItem.Function) { case AggregateParameter.Func.Avg: query += "AVG("; break; case AggregateParameter.Func.Count: query += "COUNT("; break; case AggregateParameter.Func.Max: query += "MAX("; break; case AggregateParameter.Func.Min: query += "MIN("; break; case AggregateParameter.Func.Sum: query += "SUM("; break; case AggregateParameter.Func.StdDev: query += "TRUNC(STDDEV("; break; case AggregateParameter.Func.Var: query += "VARIANCE("; break; } if(wItem.Distinct) { query += "DISTINCT "; } query += "\"" + wItem.Column + "\")"; if(wItem.Function == AggregateParameter.Func.StdDev) { query += ", 10)"; } if(withAlias && wItem.Alias != string.Empty) { // Need DBMS string delimiter here query += " AS \"" + wItem.Alias + "\""; } return query; }
protected string GetAggregate(AggregateParameter wItem, bool withAlias) { string query = string.Empty; switch (wItem.Function) { case AggregateParameter.Func.Avg: query += "AVG("; break; case AggregateParameter.Func.Count: query += "COUNT("; break; case AggregateParameter.Func.Max: query += "MAX("; break; case AggregateParameter.Func.Min: query += "MIN("; break; case AggregateParameter.Func.Sum: query += "SUM("; break; case AggregateParameter.Func.StdDev: query += "STDDEV("; break; case AggregateParameter.Func.Var: query += "VARIANCE("; break; } if (wItem.Distinct) { query += "DISTINCT "; } query += "`" + wItem.Column + "`)"; if (withAlias && wItem.Alias != string.Empty) { query += " AS '" + wItem.Alias + "'"; } return(query); }
protected string GetAggregate(AggregateParameter wItem, bool withAlias) { string query = string.Empty; switch (wItem.Function) { case AggregateParameter.Func.Avg: query += "Avg("; break; case AggregateParameter.Func.Count: query += "Count("; break; case AggregateParameter.Func.Max: query += "Max("; break; case AggregateParameter.Func.Min: query += "Min("; break; case AggregateParameter.Func.Sum: query += "Sum("; break; case AggregateParameter.Func.StdDev: query += "StDev("; break; case AggregateParameter.Func.Var: query += "Var("; break; } if (wItem.Distinct) { query += "DISTINCT "; } query += wItem.Column; if (withAlias && wItem.Alias != string.Empty) { query += " AS " + wItem.Alias ; } return query; }
protected string GetAggregate(AggregateParameter wItem, bool withAlias) { string query = string.Empty; switch(wItem.Function) { case AggregateParameter.Func.Avg: query += "AVG("; break; case AggregateParameter.Func.Count: query += "COUNT("; break; case AggregateParameter.Func.Max: query += "MAX("; break; case AggregateParameter.Func.Min: query += "MIN("; break; case AggregateParameter.Func.Sum: query += "SUM("; break; case AggregateParameter.Func.StdDev: query += "STDDEV("; break; case AggregateParameter.Func.Var: query += "VAR("; break; } if(wItem.Distinct) { query += "DISTINCT "; } query += "[" + wItem.Column + "])"; if(withAlias && wItem.Alias != string.Empty) { query += " AS '" + wItem.Alias + "'"; } return query; }
public void AggregateClauseReset() { _ID_W = null; _TypeName_W = null; _Description_W = null; _IsActive_W = null; _Rowguid_W = null; _CreatedDate_W = null; _ModifiedDate_W = null; _ModifiedBy_W = null; _ModeCode_W = null; _SN_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ComboCommentAttachmentID_W = null; _ComboCommnetID_W = null; _AttachmentID_W = null; this._entity.Query.FlushAggregateParameters(); }
public override void AddOrderBy(AggregateParameter aggregate, MyGeneration.dOOdads.WhereParameter.Dir direction) { base.AddOrderBy(GetAggregate(aggregate, false), direction); }
public void AggregateClauseReset() { _ComboUserID_W = null; _NotificationTypeID_W = null; _Status_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _Name_W = null; _CountryOfOrigin_W = null; _PFSAManufCode_W = null; _Phone_W = null; _Address_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _Form_W = null; _Description_W = null; _TypeID_W = null; this._entity.Query.FlushAggregateParameters(); }
public override void AddGroupBy(AggregateParameter aggregate) { // Access does not support aggregates in a GROUP BY base.AddGroupBy(GetAggregate(aggregate, false)); }
public override void AddGroupBy(AggregateParameter aggregate) { base.AddGroupBy(GetAggregate(aggregate, false)); }
public void AggregateClauseReset() { _SupplyOrderID_W = null; _SupplyOrderNo_W = null; _SupplierID_W = null; _SupplyOrderDate_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _SectorTypeID_W = null; _Name_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _AdText_W = null; _AdImage_W = null; _RowStatusID_W = null; _StartDate_W = null; _MemberTypes_W = null; _NumOfDays_W = null; _NuOfHours_W = null; _Timestamp_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _CertificateID_W = null; _Name_W = null; _Path_W = null; _CreatedBy_W = null; _CreatedDate_W = null; _UpdatedBy_W = null; _LastUpdatedDate_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _CareerID_W = null; _Name_W = null; _Email_W = null; _FilePath_W = null; _Description_W = null; this._entity.Query.FlushAggregateParameters(); }
public override void AddGroupBy(AggregateParameter aggregate) { // MySQL4 does not support aggregates in a GROUP BY base.AddGroupBy("`" + aggregate.Alias + "`"); }
/// <summary> /// Overloaded to support aggregates. /// Derived classes implement this, like SqlClientDynamicQuery and OleDbDynamicQuery /// to account for differences in DBMS systems. /// </summary> /// <param name="aggregate">This should be an entry from your Aggregate class</param> /// <param name="direction">Either Descending or Ascending</param> /// <example> /// <code> /// emps.Query.AddOrderBy(emps.Aggregate.CategoryID, WhereParameter.Dir.ASC)</code> /// </example> public virtual void AddOrderBy(AggregateParameter aggregate, WhereParameter.Dir direction) { }
public void AggregateClauseReset() { _OrgIPID_W = null; _MachineID_W = null; _OrgIP_W = null; _Status_W = null; this._entity.Query.FlushAggregateParameters(); }
/// <summary> /// Overloaded to support aggregates. /// Derived classes implement this, like SqlClientDynamicQuery and OleDbDynamicQuery /// to account for differences in DBMS systems. /// </summary> /// <param name="aggregate">This should be an entry from your Aggregate class</param> /// <example> /// <code> /// emps.Query.AddGroupBy(emps.Aggregate.City)</code> /// </example> public virtual void AddGroupBy(AggregateParameter aggregate) { }
public override void AddGroupBy(AggregateParameter aggregate) { // Support aggregates in a GROUP BY. // Common method base.AddGroupBy(GetAggregate(aggregate, false)); }
public void AggregateClauseReset() { _CrewID_W = null; _Name_W = null; _StaffNo_W = null; _Notes_W = null; _CreatedBy_W = null; _ModifiedBy_W = null; _CreatedDate_W = null; _LastModifiedDate_W = null; _Username_W = null; _RANK_W = null; _IDNO_W = null; _LicenseNo_W = null; _Competenecycheck_W = null; _MEDICALLICENSEEXPIRYFrom_W = null; _MEDICALLICENSEEXPIRYTo_W = null; _InstructorRenewal_W = null; _TRANSITIONCOURSE_W = null; _RECURRENT12_W = null; _RECURRENT24_W = null; _SMS_W = null; _Security_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _AirPortID_W = null; _Name_W = null; _IATACode_W = null; _ACAICode_W = null; _Description_W = null; _Notes_W = null; _CreatedBy_W = null; _ModifiedBy_W = null; _CreatedDate_W = null; _LastModifiedDate_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _NotificationID_W = null; _NotifierID_W = null; _NotificationText_W = null; _FilePath_W = null; _Subject_W = null; _CompanyID_W = null; _NotifyDate_W = null; _Expr1_W = null; _CompNameEng_W = null; _CompNameAr_W = null; _Comp_Code_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _CategoryId_W = null; _SubCategoryName_W = null; _SubCategoryCode_W = null; _Description_W = null; _ParentID_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _CategoryID_W = null; _CatNameAr_W = null; _CatNameEng_W = null; _CatImage_W = null; _MainCatId_W = null; _HoverImage_W = null; _IsPartySupplier_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _ItemID_W = null; _RUOwnershipTypeID_W = null; _AllowFully_W = null; _Warning_W = null; _Restriction_W = null; _MaxIssueQty_W = null; _MaxIssueQtyGapDays_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _InAndOutDoorDetailsID_W = null; _Item_W = null; _MaterialID_W = null; _LaminationID_W = null; _ServiceID_W = null; _Picture_W = null; _DeliveryDate_W = null; _Width_W = null; _Hight_W = null; _TotalSize_W = null; _DeliveryTo_W = null; _JobOrderStatusID_W = null; _JobOrderID_W = null; _CreatedBy_W = null; _CreatedDate_W = null; _UpdatedBy_W = null; _LastUpdatedDate_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _ProgramID_W = null; _ItemID_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ID_W = null; _DRUG_REQUEST_SUBSTANCE_ID_W = null; _UNIT_ID_W = null; _QUANTITY_W = null; _EQUI_NAME_SUBSTANCE_W = null; _EQUI_QUANTITY_W = null; _EQUI_UNIT_W = null; _OVER_QUANTITY_W = null; _OVER_UNIT_ID_W = null; _OVER_EQUI_QUANTITY_W = null; _OVER_EQUI_UNIT_W = null; _SPECIFICATION_W = null; _FUNCTION__W = null; _EQUE_SPECIFICATION_W = null; _EQUE_FUNCTION_W = null; _PHONE_W = null; _FAX_W = null; _EMAIL_W = null; _ADDRESS_W = null; _MANUFACTURE_W = null; _INSPECTED_FOR_GMP_W = null; _PHONE_EQ_W = null; _EMAIL_EQ_W = null; _ADDRESS_EQ_W = null; _MANUFACTURE_EQ_W = null; _FAX_EQ_W = null; _INSPECTED_FOR_GMP_EQ_W = null; _Equiv_Substance_ID_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _SettingID_W = null; _UserName_W = null; _Password_W = null; _Keywords_uk_W = null; _Keywords_en_W = null; _Keywords_ru_W = null; _Title_uk_W = null; _Title_en_W = null; _Title_ru_W = null; _Description_uk_W = null; _Description_en_W = null; _Description_ru_W = null; _TitleSuffix_uk_W = null; _TitleSuffix_en_W = null; _TitleSuffix_ru_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _DigitalPrintingDetailsID_W = null; _JobOrderID_W = null; _PrintingTypeID_W = null; _IsRAndV_W = null; _SupplierID_W = null; _DeliveryDoneTo_W = null; _JobOrderStatusID_W = null; _CreatedBy_W = null; _CreatedDate_W = null; _UpdatedBy_W = null; _LastUpdatedDate_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _ComboUserID_W = null; _UserName_W = null; _DisplayName_W = null; _Password_W = null; _Email_W = null; _ProfileImgID_W = null; _CoverImgID_W = null; _GenderID_W = null; _Bio_W = null; _IsActivated_W = null; _ActivationCode_W = null; _ExternalID_W = null; _ExternalIDType_W = null; _DeviceID_W = null; _PassResetCode_W = null; _IsDeactivated_W = null; _SecurityQuestion_W = null; _SecurityAnswer_W = null; _UserRankID_W = null; _SecurityWord_W = null; _BirthDate_W = null; _Country_W = null; _Phone_W = null; _Website_W = null; _CountryID_W = null; _Location_W = null; _IsPrivateAccount_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _BlogPageCityID_W = null; _BlogPageID_W = null; _CityID_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _MagazineID_W = null; _EnTitle_W = null; _ArTitle_W = null; _FilePath_W = null; _CreatedDate_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _AttachementID_W = null; _DepartementID_W = null; _FilePath_W = null; _FileName_W = null; _Description_W = null; this._entity.Query.FlushAggregateParameters(); }
public void AggregateClauseReset() { _BranchID_W = null; _BranchName_W = null; _BranchAddress_W = null; _Telephone_W = null; _ManagerName_W = null; _Duration_Hours_W = null; _ImagePath_W = null; _GoogleMapLink_W = null; this._entity.Query.FlushAggregateParameters(); }
public override void AddOrderBy(AggregateParameter aggregate, MyGeneration.dOOdads.WhereParameter.Dir direction) { base.AddOrderBy("`" + aggregate.Alias + "`", direction); }