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));
}
