public static string RenderFnGetUserOrderInfoAsColumn(SubSonic.TableSchema.TableColumn userCol, SubSonic.TableSchema.TableColumn companyCol, SubSonic.TableSchema.TableColumn dateCol, string dataFormat, string column) { return string.Concat(__FnGetUserOrderInfo, '(', userCol.QualifiedName, ',', companyCol.QualifiedName, ',', dateCol.QualifiedName, ',', '\'', dataFormat, '\'', ") AS ", column); }
protected override void LoadPropertyValues(string propertyName, SubSonic.Schema.IRelation reference) { throw new InvalidOperationException("Must not load already loaded properties twice!"); }
/// <summary> /// Generates the 'SELECT' part of an <see cref="SubSonic.Query.Aggregate"/> /// </summary> /// <param name="aggregate">The aggregate to include in the SELECT clause</param> /// <returns>The portion of the SELECT clause represented by this <see cref="SubSonic.Query.Aggregate"/></returns> /// <remarks> /// The ToString() logic moved from <see cref="SubSonic.Query.Aggregate.ToString"/>, rather than /// including it in the Aggregate class itself... /// </remarks> protected virtual string GenerateAggregateSelect(SubSonic.Query.Aggregate aggregate) { bool hasAlias = !String.IsNullOrEmpty(aggregate.Alias); if(aggregate.AggregateType == AggregateFunction.GroupBy && hasAlias) return String.Format("{0} AS {1}", aggregate.ColumnName, aggregate.Alias); if(aggregate.AggregateType == AggregateFunction.GroupBy) return string.Format("{0}", aggregate.ColumnName); if(hasAlias) { return String.Format("{0}({1}) AS {2}", SubSonic.Query.Aggregate.GetFunctionType(aggregate).ToUpper(), aggregate.ColumnName, aggregate.Alias); } return String.Format("{0}({1})", SubSonic.Query.Aggregate.GetFunctionType(aggregate).ToUpper(), aggregate.ColumnName); }
static SqlConnectionStringBuilder GetConnectionString(SubSonic.DataProviders.IDataProvider provider) { return new System.Data.SqlClient.SqlConnectionStringBuilder(provider.ConnectionString); }
public PollQuestionsCollection FetchByQuery(SubSonic.Query qry) { PollQuestionsCollection coll = new PollQuestionsCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public static string RenderUserPhone(SubSonic.TableSchema.TableColumn phone) { return RenderUserPhone(Utilities.GetTableColumn(phone)); }
public static string RenderUserPhone(SubSonic.TableSchema.TableColumn userID, SubSonic.TableSchema.TableColumn companyID, SubSonic.TableSchema.TableColumn phone, SubSonic.TableSchema.TableColumn memberCompanyID, bool isAsCol = true) { return RenderUserPhone(Utilities.GetTableColumn(userID), Utilities.GetTableColumn(companyID), Utilities.GetTableColumn(phone), Utilities.GetTableColumn(memberCompanyID), isAsCol); }
public static string RenderIsOwner(SubSonic.TableSchema.TableColumn userID, SubSonic.TableSchema.TableColumn companyID) { return RenderIsOwner(Utilities.GetTableColumn(userID), Utilities.GetTableColumn(companyID)); }
public static string FnCompare(string constraint, SubSonic.TableSchema.TableColumn columnA, string valueB, object eqVal) { return string.Concat(constraint, '(', __FnCompare, '(', columnA.QualifiedName, ',', '\'', valueB, '\'', ')', '=', eqVal, ')'); }
public static string GetFirstAreaName(SubSonic.TableSchema.TableColumn col, string asColName) { return string.Format(GET_FIRST_AREA_NAME_FUNC, Utilities.GetTableColumn(col), asColName); }
public static string GetAreaNamesByColumn(SubSonic.TableSchema.TableColumn col) { return string.Format(GETAREA_NAMES_FUNC, Utilities.GetTableColumn(col), col.ColumnName); }
public static string RenderGetAdPointFunc(decimal lastOrderSum, SubSonic.TableSchema.TableColumn adIdCol) { return string.Format(GET_COMPANY_AD_POINT_FUNC, Utilities.GetTableColumn(adIdCol), lastOrderSum, SysCompanyAdsPointSetting.AdsPointColumn.ColumnName); }
public static string RenderCheckAdsDayLimit(SubSonic.TableSchema.TableColumn adIdCol, SubSonic.TableSchema.TableColumn amountLimitCol, SubSonic.TableSchema.TableColumn sumLimitCol) { return string.Format(CHECK_ADS_DAY_LIMIT, Utilities.GetTableColumn(adIdCol), Utilities.GetTableColumn(amountLimitCol), Utilities.GetTableColumn(sumLimitCol)); }