本文整理汇总了C#中MyGeneration.dOOdads.AggregateParameter类的典型用法代码示例。如果您正苦于以下问题:C# AggregateParameter类的具体用法?C# AggregateParameter怎么用?C# AggregateParameter使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
AggregateParameter类属于MyGeneration.dOOdads命名空间,在下文中一共展示了AggregateParameter类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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;
}
开发者ID:nguyenhuuhuy,项目名称:mygeneration,代码行数:49,代码来源:OracleClientDynamicQuery.cs
示例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;
}
开发者ID:nguyenhuuhuy,项目名称:mygeneration,代码行数:43,代码来源:SQLiteDynamicQuery.cs
示例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;
}
开发者ID:nguyenhuuhuy,项目名称:mygeneration,代码行数:43,代码来源:VisualFoxProDynamicQuery.cs
示例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();
}
开发者ID:USAID-DELIVER-PROJECT,项目名称:ethiopia-hcmis-facility,代码行数:11,代码来源:_Manufactures.cs
示例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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:12,代码来源:Certificate.cs
示例6: AggregateClauseReset
public void AggregateClauseReset()
{
_ID_W = null;
_Form_W = null;
_Description_W = null;
_TypeID_W = null;
this._entity.Query.FlushAggregateParameters();
}
开发者ID:USAID-DELIVER-PROJECT,项目名称:ethiopia-hcmis-facility,代码行数:9,代码来源:_DosageForm.cs
示例7: AggregateClauseReset
public void AggregateClauseReset()
{
_SectorTypeID_W = null;
_Name_W = null;
this._entity.Query.FlushAggregateParameters();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:7,代码来源:SectorType.cs
示例8: AggregateClauseReset
public void AggregateClauseReset()
{
_SupplyOrderID_W = null;
_SupplyOrderNo_W = null;
_SupplierID_W = null;
_SupplyOrderDate_W = null;
this._entity.Query.FlushAggregateParameters();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:9,代码来源:SupplyOrders.cs
示例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();
}
开发者ID:USAID-DELIVER-PROJECT,项目名称:ethiopia-hcmis-warehouse,代码行数:15,代码来源:_Mode.cs
示例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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:22,代码来源:InAndOutDoorDetails.cs
示例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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:12,代码来源:Categories.cs
示例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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:16,代码来源:v_GetAllNotifications.cs
示例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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:26,代码来源:Crew.cs
示例14: AggregateClauseReset
public void AggregateClauseReset()
{
_CareerID_W = null;
_Name_W = null;
_Email_W = null;
_FilePath_W = null;
_Description_W = null;
this._entity.Query.FlushAggregateParameters();
}
开发者ID:andrewsaad,项目名称:SMOT,代码行数:10,代码来源:Career.cs
示例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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:14,代码来源:MailAds.cs
示例16: AggregateClauseReset
public void AggregateClauseReset()
{
_ComboCommentAttachmentID_W = null;
_ComboCommnetID_W = null;
_AttachmentID_W = null;
this._entity.Query.FlushAggregateParameters();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:8,代码来源:ComboCommentAttachment.cs
示例17: AggregateClauseReset
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();
}
开发者ID:USAID-DELIVER-PROJECT,项目名称:ethiopia-hcmis-facility,代码行数:11,代码来源:_SubCategory.cs
示例18: AggregateClauseReset
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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:33,代码来源:SUBSTANCE_SUPPLIER.cs
示例19: AggregateClauseReset
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();
}
开发者ID:USAID-DELIVER-PROJECT,项目名称:ethiopia-hcmis-warehouse,代码行数:13,代码来源:_ItemOwnershipType.cs
示例20: AggregateClauseReset
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();
}
开发者ID:menasbeshay,项目名称:ivalley-svn,代码行数:16,代码来源:DigitalPrintingDetails.cs
注:本文中的MyGeneration.dOOdads.AggregateParameter类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论