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("更新成功!!");
}
}
