private void menuInsert_Click(object sender, EventArgs e) { if (CreateCode != null) { string dbName = tvDatabase.SelectedNode.Parent.Parent.Text; Model.Database db = tvDatabase.SelectedNode.Parent.Parent.Tag as Model.Database; Model.Table table = tvDatabase.SelectedNode.Tag as Model.Table; if (table != null) { SqlSeleteViewForm ssv = new SqlSeleteViewForm(db, table); string str = ""; string str2 = "insert into "; str2 = (str2 + "" + this.tvDatabase.SelectedNode.Text + "") + " (" + this.tvDatabase.SelectedNode.Nodes[0].Text; for (int i = 1; i < this.tvDatabase.SelectedNode.Nodes.Count; i++) { str = str + ",''"; str2 = str2 + "," + this.tvDatabase.SelectedNode.Nodes[i].Text; } str2 = (str2 + ") \n" + "values(''") + str + ")"; if ((ssv.sqlTextEditor.Text.Trim().Length != 0) && (ssv.sqlTextEditor.Text[ssv.sqlTextEditor.Text.Length - 1] != '\n')) { ssv.sqlTextEditor.Text = ssv.sqlTextEditor.Text + "\n"; } ssv.sqlTextEditor.Text = ssv.sqlTextEditor.Text + str2; ssv.Show(MainForm.dockPanel); } else { ShowMessage.Alert("请先选中一个表或视图。"); } } }
private void menuDelete_Click(object sender, EventArgs e) { if (CreateCode != null) { string dbName = tvDatabase.SelectedNode.Parent.Parent.Text; Model.Database db = tvDatabase.SelectedNode.Parent.Parent.Tag as Model.Database; Model.Table table = tvDatabase.SelectedNode.Tag as Model.Table; if (table != null) { SqlSeleteViewForm ssv = new SqlSeleteViewForm(db, table); string str = "\nwhere 1 = 1"; string str2 = "delete from "; str2 = (str2 + "" + this.tvDatabase.SelectedNode.Text + "") + str; if ((ssv.sqlTextEditor.Text.Trim().Length != 0) && (ssv.sqlTextEditor.Text[ssv.sqlTextEditor.Text.Length - 1] != '\n')) { ssv.sqlTextEditor.Text = ssv.sqlTextEditor.Text + "\n"; } ssv.sqlTextEditor.Text = ssv.sqlTextEditor.Text + str2; ssv.Show(MainForm.dockPanel); } else { ShowMessage.Alert("请先选中一个表或视图。"); } } }