本文整理汇总了C#中MyGeneration.dOOdads.AggregateParameter类的典型用法代码示例。如果您正苦于以下问题：C# AggregateParameter类的具体用法？C# AggregateParameter怎么用？C# AggregateParameter使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
AggregateParameter类属于MyGeneration.dOOdads命名空间，在下文中一共展示了AggregateParameter类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetAggregate
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;
}示例2: GetAggregate
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;
}示例3: GetAggregate
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;
}示例4: AggregateClauseReset
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();
}示例5: AggregateClauseReset
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();
}示例6: AggregateClauseReset
public void AggregateClauseReset()
{
_ID_W = null;
_Form_W = null;
_Description_W = null;
_TypeID_W = null;
this._entity.Query.FlushAggregateParameters();
}示例7: AggregateClauseReset
public void AggregateClauseReset()
{
_SectorTypeID_W = null;
_Name_W = null;
this._entity.Query.FlushAggregateParameters();
}示例8: AggregateClauseReset
public void AggregateClauseReset()
{
_SupplyOrderID_W = null;
_SupplyOrderNo_W = null;
_SupplierID_W = null;
_SupplyOrderDate_W = null;
this._entity.Query.FlushAggregateParameters();
}示例9: AggregateClauseReset
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();
}示例10: AggregateClauseReset
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();
}示例11: AggregateClauseReset
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();
}示例12: AggregateClauseReset
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();
}示例13: AggregateClauseReset
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();
}示例14: AggregateClauseReset
public void AggregateClauseReset()
{
_CareerID_W = null;
_Name_W = null;
_Email_W = null;
_FilePath_W = null;
_Description_W = null;
this._entity.Query.FlushAggregateParameters();
}示例15: AggregateClauseReset
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();
}