private void ShowTableAttributes(Hubble.Framework.Data.DataTable table)
{
foreach (Hubble.Framework.Data.DataRow row in table.Rows)
{
AttributeCtrl ctrl;
if (_TableInfoControlDict.TryGetValue(row["Attribute"].ToString(), out ctrl))
{
if (ctrl.Ctrl is NumericUpDown)
{
(ctrl.Ctrl as NumericUpDown).Value = long.Parse(row["Value"].ToString());
ctrl.OriginalValue = (ctrl.Ctrl as NumericUpDown).Value.ToString();
}
else
{
ctrl.Ctrl.Text = row["Value"].ToString();
ctrl.OriginalValue = ctrl.Ctrl.Text;
}
}
}
if (comboBoxIndexOnly.Text.Trim().Equals("True", StringComparison.CurrentCultureIgnoreCase))
{
comboBoxTableSynchronization.Enabled = true;
}
else
{
comboBoxTableSynchronization.Enabled = false;
}
if (textBoxDocId.Text != "" && comboBoxTableSynchronization.Text.Equals("True", StringComparison.CurrentCultureIgnoreCase))
{
textBoxTriggerTableName.Enabled = true;
}
else
{
textBoxTriggerTableName.Enabled = false;
}
}
private void toolStripButtonExcute_Click(object sender, EventArgs e)
{
try
{
toolStripStatusLabelReport.Text = "";
tabControl1.SelectedTab = tabPageResults;
textBoxMessages.Text = "";
QueryPerfCounter qp = new QueryPerfCounter();
qp.Start();
int count = 0;
SFQLParse sfqlParse = new SFQLParse();
string sql = textBoxSql.Text;
if (!string.IsNullOrEmpty(textBoxSql.SelectedText))
{
sql = textBoxSql.SelectedText;
}
if (sql.StartsWith("SP_", StringComparison.CurrentCultureIgnoreCase))
{
sql = "exec " + sql;
}
if (performanceReportToolStripMenuItem.Checked)
{
sql = "[PerformanceReport]\r\n" + sql;
}
QueryResult queryResult;
GlobalSetting.DataAccess.ResetDataCacheAfterTimeout =
resetDataCacheAfterTimeoutToolStripMenuItem.Checked;
if (dataCacheToolStripMenuItem.Checked)
{
queryResult = GlobalSetting.DataAccess.Excute(sql, 0);
}
else
{
queryResult = GlobalSetting.DataAccess.Excute(sql);
}
Hubble.Framework.Data.DataTable table = null;
if (queryResult.DataSet.Tables.Count > 0)
{
table = queryResult.DataSet.Tables[0];
count = table.MinimumCapacity;
}
qp.Stop();
double ns = qp.Duration(1);
StringBuilder report = new StringBuilder();
report.AppendFormat("Duration:{0} ", (ns / (1000 * 1000)).ToString("0.00") + " ms");
report.AppendFormat("Count={0}", count);
if (queryResult.PrintMessages != null)
{
if (queryResult.PrintMessageCount > 0)
{
ShowMessages(queryResult.PrintMessages, table == null);
}
}
MultiGridView mulitGridView = new MultiGridView(panelResult, queryResult.DataSet.Tables.Count);
for (int i = 0; i < queryResult.DataSet.Tables.Count; i++)
{
queryResult.DataSet.Tables[i].MinimumCapacity = 0;
mulitGridView.GridViewList[i].DataSource = queryResult.DataSet.Tables[i].ConvertToSystemDataTable();
DataTable tbl = queryResult.DataSet.Tables[i];
for (int j = 0; j < tbl.Columns.Count; j++)
{
if (tbl.Columns[j].DataType == typeof(DateTime))
{
mulitGridView.GridViewList[i].Columns[j].DefaultCellStyle.Format = "yyyy-MM-dd HH:mm:sss";
}
}
}
toolStripStatusLabelReport.Text = report.ToString();
if (performanceReportToolStripMenuItem.Checked)
{
tabControl1.SelectedTab = tabPageMessages;
}
}
catch (Hubble.Core.SFQL.LexicalAnalysis.LexicalException lexicalEx)
{
ShowErrorMessage(lexicalEx.ToString());
}
catch (Hubble.Core.SFQL.SyntaxAnalysis.SyntaxException syntaxEx)
{
ShowErrorMessage(syntaxEx.ToString());
}
catch (Hubble.Framework.Net.ServerException e1)
{
ShowErrorMessage(e1.Message + "\r\n" + e1.StackTrace);
}
catch (Exception e1)
{
ShowErrorMessage(e1.Message + "\r\n" + e1.StackTrace);
}
finally
{
}
textBoxSql.Focus();
}