當前位置: 首頁>>代碼示例>>C#>>正文

C# dOOdads.AggregateParameter類代碼示例

本文整理匯總了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;
		}
開發者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


注：本文中的MyGeneration.dOOdads.AggregateParameter類示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。