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