public NewSql(SQLRecord sql) { InitializeComponent(); this.Text = "更新 SQL內容"; _sql = sql; tbType.Text = _sql.Type; //分類 tbComment.Text = _sql.Comment; //說明 tbSQLQuery.Text = _sql.SQLQuery; //內容 }
/// <summary> /// 執行本SQL /// </summary> private void btnRunSql_Click(object sender, EventArgs e) { if (dataGridViewX1.SelectedRows.Count > 0 && dataGridViewX1.SelectedRows.Count <= 2) { DataGridViewRow row = dataGridViewX1.SelectedRows[0]; SQLRecord sql = (SQLRecord)row.Tag; new ExportQueryData().ExecuteTasks(sql.SQLQuery.Replace("\n\t", "")); } else { MsgBox.Show("需選擇一筆資料!!"); } }
private void 刪除ToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridViewX1.SelectedRows.Count > 0 && dataGridViewX1.SelectedRows.Count <= 2) { if (MsgBox.Show("您確定要刪除此資料?", MessageBoxButtons.YesNo, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes) { DataGridViewRow row = dataGridViewX1.SelectedRows[0]; SQLRecord sql = (SQLRecord)row.Tag; tool._A.DeletedValues(new List <SQLRecord> { sql }); MsgBox.Show("刪除成功!!"); SetForm(); } } else { MsgBox.Show("需選擇一筆資料!!"); } }
private void btnSave_Click(object sender, EventArgs e) { if (_sql == null) { //新增 SQLRecord sql = new SQLRecord(); sql.Type = tbType.Text; sql.Comment = tbComment.Text; sql.SQLQuery = tbSQLQuery.Text; sql.Admin = FISCA.Authentication.DSAServices.UserAccount; List <SQLRecord> list = tool._A.Select <SQLRecord>(tool._A.InsertValues(new List <SQLRecord>() { sql })); if (list.Count > 0) { _sql = list[0]; } MsgBox.Show("儲存成功!!"); } else { //更新 _sql.Type = tbType.Text; _sql.Comment = tbComment.Text; _sql.SQLQuery = tbSQLQuery.Text; _sql.Admin = FISCA.Authentication.DSAServices.UserAccount; tool._A.UpdateValues(new List <SQLRecord>() { _sql }); MsgBox.Show("更新成功!!"); } }