/// <summary>
/// 結合条件作成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void mnuJoinCondition_Click(object sender, EventArgs e)
{
EntitySet <TableLayoutInfo> columns = this.dataGridView1.DataSource as EntitySet <TableLayoutInfo>;
if (columns == null)
{
return;
}
using (InputForm form = new InputForm())
{
form.ForJoin = true;
if (form.ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
string alias = form.AliasName;
string sql = this.GetJoinSql(columns, alias);
Clipboard.SetText(sql);
}
}
}
private void mnuCreateSelect_Click(object sender, EventArgs e)
{
EntitySet <TableLayoutInfo> columns = this.dataGridView1.DataSource as EntitySet <TableLayoutInfo>;
if (columns == null)
{
return;
}
using (InputForm form = new InputForm())
{
form.ForJoin = false;
if (form.ShowDialog(this) == System.Windows.Forms.DialogResult.OK)
{
bool hasWhere = form.HasWhereCondition;
bool hasComment = form.HasComment;
string alias = form.AliasName;
string sql = GetSelectSql(columns, alias, hasWhere, hasComment);
Clipboard.SetText(sql);
}
}
}
