• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# dOOdads.AggregateParameter类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了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;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# dOOdads.BusinessEntity类代码示例发布时间:2022-05-26
下一篇:
C# Sharp.Widget类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap