/// <summary>
/// Write out the TOP part of sql select statement
/// It basically writes TOP (X) [WITH TIES].
/// </summary>
/// <param name="writer"></param>
/// <param name="sqlGenerator"></param>
public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
{
if (SkipCount != null)
{
writer.WriteLine();
writer.Write("offset ");
writer.Write(SkipCount.GetInt(sqlGenerator) + 1);
writer.Write(" ");
}
if (TopCount != null)
{
writer.WriteLine();
writer.Write("fetch ");
if (SkipCount != null)
{
writer.Write("next ");
}
else
{
writer.Write("first ");
}
writer.Write(TopCount.GetInt(sqlGenerator));
writer.Write(" rows only ");
}
}
public void InitWithNull()
{
TopCount Item = new TopCount(null);
Assert.Throws(Is.TypeOf <MDXException>()
.And.Message.EqualTo(MDXTextUtil.GetMessageErrorBaseNotInit(Item)),
() => Item.Build());
}
public void InitWithAxisItemAndDataOK()
{
TopCount Item = new TopCount(MDXTextUtil.GetMoqMDXAxisItem());
Item.Comparator = MDXTextUtil.GetDummySalesMeasure();
Item.Count = 5;
Assert.AreEqual("TOPCOUNT (" + MDXTextUtil.GetDummyMember() + ", 5, " + MDXTextUtil.GetDummySalesMeasure() + ")", Item.Build());
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("UPDATE");
if (TopCount != null)
{
stream.Write(" ");
TopCount.WriteToStream(stream);
}
if (Table != null)
{
stream.Write(" ");
Table.WriteToStream(stream);
}
if (WithOptions != null && WithOptions.Count > 0)
{
stream.Write(" WITH(");
WithOptions.WriteToStreamWithComma(stream);
stream.Write(")");
}
stream.Write(" SET ");
SetColumnsList.WriteToStreamWithComma(stream);
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (IntoExpr != null)
{
stream.WriteLine();
IntoExpr.WriteToStream(stream);
}
if (FromTableList != null && FromTableList.Count > 0)
{
stream.WriteLine();
stream.Write("FROM ");
FromTableList.WriteToStreamWithComma(stream);
}
if (WhereExpr != null)
{
stream.WriteLine();
stream.Write("WHERE ");
WhereExpr.WriteToStream(stream);
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("INSERT");
if (TopCount != null)
{
stream.Write(" ");
TopCount.WriteToStream(stream);
}
stream.Write(" ");
IntoTable.WriteToStream(stream);
if (Columns != null && Columns.Count > 0)
{
stream.Write(" ");
Columns.WriteToStream(stream);
}
stream.Write(" EXEC ");
ExecExpr.WriteToStream(stream);
}
private void btnSave_Click(object sender, EventArgs e)
{
var configuration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
if (configuration.AppSettings.Settings[ConfigurationParameters.LogFontSize] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.LogFontSize, LogFontSize.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.LogFontSize].Value = LogFontSize.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.TreeViewFontSize] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.TreeViewFontSize, TreeViewFontSize.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.TreeViewFontSize].Value = TreeViewFontSize.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.ShowMessageCountParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.ShowMessageCountParameter, ShowMessageCount.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.ShowMessageCountParameter].Value = ShowMessageCount.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SaveMessageToFileParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SaveMessageToFileParameter, SaveMessageToFile.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SaveMessageToFileParameter].Value = SaveMessageToFile.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.UseAsciiParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.UseAsciiParameter, UseAscii.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.UseAsciiParameter].Value = UseAscii.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SavePropertiesToFileParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SavePropertiesToFileParameter, SavePropertiesToFile.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SavePropertiesToFileParameter].Value = SavePropertiesToFile.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SaveCheckpointsToFileParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SaveCheckpointsToFileParameter, SaveCheckpointsToFile.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SaveCheckpointsToFileParameter].Value = SaveCheckpointsToFile.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.RetryCountParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.RetryCountParameter, RetryCount.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.RetryCountParameter].Value = RetryCount.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.RetryTimeoutParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.RetryTimeoutParameter, RetryTimeout.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.RetryTimeoutParameter].Value = RetryTimeout.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.TopParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.TopParameter, TopCount.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.TopParameter].Value = TopCount.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.ReceiveTimeoutParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.ReceiveTimeoutParameter, ReceiveTimeout.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.ReceiveTimeoutParameter].Value = ReceiveTimeout.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.ServerTimeoutParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.ServerTimeoutParameter, ServerTimeout.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.ServerTimeoutParameter].Value = ServerTimeout.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SenderThinkTimeParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SenderThinkTimeParameter, SenderThinkTime.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SenderThinkTimeParameter].Value = SenderThinkTime.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SenderThinkTimeParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SenderThinkTimeParameter, SenderThinkTime.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SenderThinkTimeParameter].Value = SenderThinkTime.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.ReceiverThinkTimeParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.ReceiverThinkTimeParameter, ReceiverThinkTime.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.ReceiverThinkTimeParameter].Value = ReceiverThinkTime.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.MonitorRefreshIntervalParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.MonitorRefreshIntervalParameter, MonitorRefreshInterval.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.MonitorRefreshIntervalParameter].Value = MonitorRefreshInterval.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.PrefetchCountParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.PrefetchCountParameter, PrefetchCount.ToString(CultureInfo.InvariantCulture));
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.PrefetchCountParameter].Value = PrefetchCount.ToString(CultureInfo.InvariantCulture);
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SubscriptionIdParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SubscriptionIdParameter, SubscriptionId);
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SubscriptionIdParameter].Value = SubscriptionId;
}
if (configuration.AppSettings.Settings[ConfigurationParameters.CertificateThumbprintParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.CertificateThumbprintParameter, CertificateThumbprint);
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.CertificateThumbprintParameter].Value = CertificateThumbprint;
}
if (configuration.AppSettings.Settings[ConfigurationParameters.LabelParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.LabelParameter, Label);
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.LabelParameter].Value = Label;
}
if (configuration.AppSettings.Settings[ConfigurationParameters.FileParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.FileParameter, MessageFile);
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.FileParameter].Value = MessageFile;
}
if (configuration.AppSettings.Settings[ConfigurationParameters.MessageParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.MessageParameter, MessageText);
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.MessageParameter].Value = MessageText;
}
if (configuration.AppSettings.Settings[ConfigurationParameters.ConnectivityMode] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.ConnectivityMode, ServiceBusHelper.ConnectivityMode.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.ConnectivityMode].Value = ServiceBusHelper.ConnectivityMode.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.Encoding] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.Encoding, ServiceBusHelper.EncodingType.ToString());
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.Encoding].Value = ServiceBusHelper.EncodingType.ToString();
}
if (configuration.AppSettings.Settings[ConfigurationParameters.SelectedEntitiesParameter] == null)
{
configuration.AppSettings.Settings.Add(ConfigurationParameters.SelectedEntitiesParameter, cboSelectedEntities.Text);
}
else
{
configuration.AppSettings.Settings[ConfigurationParameters.SelectedEntitiesParameter].Value = cboSelectedEntities.Text;
}
configuration.Save(ConfigurationSaveMode.Minimal);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("SELECT");
if (TopCount != null)
{
stream.Write(" ");
TopCount.WriteToStream(stream);
}
stream.Write(" ");
foreach (var column in Columns.Select((value, idx) => new { value, idx }))
{
if (column.idx != 0)
{
stream.Write(", ");
}
column.value.WriteToStream(stream);
}
if (IntoTable != null)
{
stream.WriteLine();
stream.Write("INTO ");
IntoTable.WriteToStream(stream);
}
if (FromSourceList.Count > 0)
{
stream.WriteLine();
stream.Write("FROM ");
stream.Indent++;
for (int i = 0; i < FromSourceList.Count; i++)
{
if (i != 0)
{
stream.WriteLine(", ");
}
var fromSource = FromSourceList[i];
fromSource.WriteToStream(stream);
}
stream.Indent--;
}
if (ForXmlExpr != null)
{
stream.WriteLine();
ForXmlExpr.WriteToStream(stream);
}
if (PivotExpr != null)
{
stream.WriteLine();
PivotExpr.WriteToStream(stream);
}
if (WhereExpr != null)
{
stream.WriteLine();
stream.Write("WHERE ");
WhereExpr.WriteToStream(stream);
}
if (GroupByList.Count > 0)
{
stream.WriteLine();
stream.Write("GROUP BY ");
GroupByList.WriteToStreamWithComma(stream);
}
if (Having != null)
{
stream.WriteLine();
Having.WriteToStream(stream);
}
if (OrderByList.Count > 0)
{
stream.WriteLine();
stream.Write("ORDER BY ");
OrderByList.WriteToStreamWithComma(stream);
}
if (OptionExpr != null)
{
stream.WriteLine();
OptionExpr.WriteToStream(stream);
}
if (UnionSelectList != null && UnionSelectList.Count > 0)
{
stream.WriteLine();
UnionSelectList.WriteToStream(stream);
}
if (IsSemicolon)
{
stream.Write(" ;");
}
}
